Payroll Personnel Data Warehouse


Table and Fields Description

Table Description --- DVTCTO

The Class Title Ouline code indicates the primary occupation group to which a job title is assigned for reporting purposes. For staff titles this field is known as the Occupational SubGroup Code. This table translates the CTO/OSC code found in the Job Title Code - Common Information (CTLTCI) table.

There are 3 levels of code interpretation, each increasingly more detailed. Currently this table only contains level 1 and level 2 entries with the data coming from the Office of the President Corporate Personnel System Data Dictionary. This entity will be manually maintained.


Fields Definition


Field Name Business Name Data Type Description
CTO_LEVEL CODE INTERPRETATION LEVEL VARCHAR2(1) The one character code indicating the level of detailed translation for the CTO/OSC code.
CTO_CODE CTO/OSC CODE VARCHAR2(3) The Class Title Outline or Occupational SubGroup Code associated with the job title.
CTO_DESCRIPTION CTO/OSC DESCRIPTION VARCHAR2(40) The Class Title Outline or Occupational SubGroup Code translation associated with the job title.

Top of this page Data Dictionary PPS Main Menu



Sent Comment to: PPS Data Warehouse Support
Last Updated: February 8, 1999