The link between a job title code and a campus-specified job group code. Not every job
title in the CTLTCI table has an entry in this table, however all the job titles that are
currently used at UC Davis do have an entry in this table. The translation of the Job
Group code is in the CTLJGD table. The data originates from the Payroll Control Table
(CTL).
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| JGT_EE06_CATEGORY | EE06 CATEGORY | VARCHAR2(1) | The code indicating the job category the title falls into for this federally-mandated EE06 report. (values are 1=officials and managers, 2=professionals-includes academics, 3=technicians, 4=sales workers-not used by UC system, 5=office and clerical, 6=craft workers-skilled, 7=operatives-semiskilled, 8=laborers-unskilled, 9=service workers) |
| JGT_HOME_DEPT | HOME DEPARTMENT CODE | VARCHAR2(6) | NOT USED. |
| JGT_JOB_GROUP_ID | JOB GROUP ID CODE | VARCHAR2(3) | The code indicating the type of job group. (translation in CTLJGD table) |
| JGT_LAST_ACTION | LAST ACTION CODE | VARCHAR2(1) | The code indicating the most recent action. |
| JGT_LAST_ACTION_DT | LAST ACTION DATE | DATE | The effective date of the most recent action. |
| JGT_TITLE_CODE | TITLE CODE | VARCHAR2(4) | The code indicating the position classification. (key) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: February 8, 1999