PY_QRY_WC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
3	PAY_END_DT	Date(10)	DATE	Pay Period End Date
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
5	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
6	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
7	ADDL_NBR	Number(3,0)	SMALLINT NOT NULL	Additional Pay Line Nbr
8	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
11	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
12	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
13	EFFDT	Date(10)	DATE	Effective Date
14	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
15	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
16	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
17	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
18	JOB_CHANGE	Character(1)	VARCHAR2(1) NOT NULL	Job Pay Data Change N=No R=Calculation Required Y=Yes
19	PAYCHECK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Paycheck status. A=Adjusted C=Calculated F=Confirmed R=Reversed V=Reversing Check
20	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
21	TOTAL_GROSS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Gross
22	TOTAL_ERN_HRS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Sum of earn hours, reg hours and OT hours on pay earnings.
23	COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Country Code
24	INDUSTRY_SECTOR	Character(4)	VARCHAR2(4) NOT NULL	Industry Sector CORE=Core PBSC=Public Sector USFG=US Federal Government