| Query Name |
Query Description |
| HR_DEPT_EMP_LIST |
List of Employees by
Department (Department Roster – as of
current date) |
| HR_SWB_06_01_07 |
List of Employees on SWB on 9 1 07 |
| HR_TRN_BY_DEPT_ALL_COURSES |
Training-Status by all courses |
| HR_TRN_COMPLETIONS_BYCOLL |
Training-All Course completions by Coll |
| HR_TRN_COMPLETIONS_BYCRSE |
Training-Students Completing A Course |
| HR_TRN_COMPLETIONS_BYDEPT_TL |
Training-All Course Completions By Dept |
| HR_TRN_COMPLETIONS_BYDIV |
Training-Course Completions by Division |
| HR_TRN_COMPLETIONS_BYSTUDENT |
Training-Course Completions by Student |
| HR_TRN_COUNTOFSESSIONS |
Training-Count of Sessions |
| HR_89_SAMPLE_QUERY_BY_COL |
List of Employees by College.
Query consists of multiple tables. |
| HR_89_SAMPLE_QUERY_BY_DEPT |
List of Employees by Department.
Query consists of multiple tables. |
| HR_89_SAMPLE_QUERY_BY_DIV |
List of Employees by Division.
Query consists of multiple tables. |
| HR_89_SAMPLE_QUERY_BY_EMPLID
|
List Employee by Employee Identification
Number.
Query consists of multiple tables. |
| HRMS_EMP_JOB_HISTORY |
Creates a List of Job
Actions with Associated Job Data by Empl ID. |
| HR_PER_TENURE_BU |
Tenure data by Business
Unit |
| HR_PER_TENURE_BU_CAL_GRP |
Tenure data by
Business Unit and Cal Group |
| UBUD |
Generates a list of common Budget queries |
| UCSC_ACTION_RPT_DEPT |
Review HR Actions |
| UPAY |
Generates a list of common payroll queries |
