PAY_NA_CTX_LIAB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
3	PAY_END_DT	Date(10)	DATE NOT NULL	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	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
8	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
9	TAX_CLASS_CAN	Character(3)	VARCHAR2(3) NOT NULL	Canadian Tax Class ALL=Total Gross CBT=Canadian Bonus Tax CIT=Canadian Income Tax (T4) CP2=CPP Second Additional Employee CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan Employer CR2=CPP Second Additional Employer EIE=Employment Insurance Employee EIR=Employment Insurance Employer HTX=Provincial Health Tax PYT=Payroll Tax QBT=Quebec Bonus Tax QCD=Quebec Tax Deduction QIE=Quebec Parental Plan Employee QIR=Quebec Parental Plan Employer QIT=Quebec Income Tax (RL-1) QP2=QPP Second Additional Employee QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan Employer QR2=QPP Second Additional Employer RV2=Quebec Income Tax (RL-2) T4A=Canadian Income Tax (T4A) TRV=True RL TT4=True T4
10	PY_LIABEXPFLG	Character(1)	VARCHAR2(1) NOT NULL	Liability / Expense Flag E=GL Expense L=GL Liability R=GL Employer's Liability
11	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
12	ADDL_NBR	Number(3,0)	SMALLINT NOT NULL	Additional Pay Line Nbr
13	TAX_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tax
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
15	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
16	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
17	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
18	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
19	CHECK_DT	Date(10)	DATE	Check date.
20	PAYCHECK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Paycheck status. A=Adjusted C=Calculated F=Confirmed R=Reversed V=Reversing Check
21	WAGE_LOSS_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Wage Loss Replacement Plan
22	CANADA_BN	Character(15)	VARCHAR2(15) NOT NULL	Payroll Account Number
23	PAY_TAXES_THRU_AP	Character(1)	VARCHAR2(1) NOT NULL	Pay Taxes through AP
24	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
25	DEPTID_CF	Character(10)	VARCHAR2(10) NOT NULL	Department
26	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
27	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
28	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
29	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
30	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
31	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
32	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
33	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
34	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
35	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
36	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
37	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
38	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
39	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate2
40	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Business Unit
41	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
42	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Type
43	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Category
44	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Sub Category
45	AP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AP Status S=Sent to AP X=Extracted