PAY_NA_CTX_DIST

#	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	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: ACCT_CD_TBL
12	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
13	ADDL_NBR	Number(3,0)	SMALLINT NOT NULL	Additional Pay Line Nbr
14	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
15	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
16	TAX_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Tax
17	PY_ACCRUAL_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Accural Amount