The campus-defined translation list for the job group code such as Academic
Administrator, Technicians, and Administrative Specialists. This code and related
description is tied to the job title through the CTLJGT table. The data originates from
the Payroll Control Table (CTL).
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| JGD_ABBREV_DESC | JOB GROUP ID CODE ABBREVIATED DESCRIPTION | VARCHAR2(20) | The short description of the job group id code. |
| JGD_FULL_DESC | JOB GROUP ID CODE DESCRIPTION | VARCHAR2(50) | The complete description of the job group id code. |
| JGD_ID | JOB GROUP ID CODE | VARCHAR2(3) | The code indicating the type of job group id. (key) |
| JGD_LAST_ACTION | LAST ACTION CODE | VARCHAR2(1) | The code indicating the most recent action. (values are A=add, C=changed) |
| JGD_LAST_ACTION_DT | LAST ACTION DATE | DATE | The effective date of the most recent action. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: February 8, 1999