WGEA_EMP_AUS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	GPAU_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year - End of Year Processing
3	CATEGORY_TYPE	Character(3)	VARCHAR2(3) NOT NULL	occupational category type MGR=Manager NON=Non-Manager
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
9	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
10	ASCO_CD_AUS	Character(6)	VARCHAR2(6) NOT NULL	This field is used to group occupations into categories
11	OCCUP_CG_AUS	Character(4)	VARCHAR2(4) NOT NULL	Occupational category for WGEA report
12	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
13	CONTRACT_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Field to identify Contractors in AUS
14	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
15	GRADUATE_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Graduated N=No Y=Yes
16	APPRENTICE	Character(1)	VARCHAR2(1) NOT NULL	Apprentice-level Employee N=None Y=Apprentice
17	ANNUAL_BASE_SAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GP AUS wgea report calculated payroll data
18	ANNUAL_TOTAL_SAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GP AUS wgea report calculated payroll data