OCCUP_CG_AUS

(SQL Table)
Index Back

Occupational categories

Setup record for Occupational categories for WGEA report generation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OCCUP_CG_AUS Character(4) VARCHAR2(4) NOT NULL Occupational category for WGEA report
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
6 CATEGORY_TYPE Character(3) VARCHAR2(3) NOT NULL occupational category type
MGR=Manager
NON=Non-Manager

Default Value: NON

7 REPORTING_LVL_CEO Signed Number(6,0) DECIMAL(5) NOT NULL Reporting level to CEO