PA_RT_PAY_DETL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	PA_RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Run ID
4	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
5	PA_PMT_NBR	Number(2,0)	SMALLINT NOT NULL	Payment Number
6	PA_PMT_END_DT	Date(10)	DATE	Pay Period End Date
7	PA_CHECK_DATE	Date(10)	DATE	Check Date
8	CALC_NAME	Character(20)	VARCHAR2(20) NOT NULL	Calculation Name
9	PYMT_FREQ	Character(4)	VARCHAR2(4) NOT NULL	Payment Frequency 0=One Time Payment 1=Annual Payment 12=Monthly Payment 2=Semi-Annual 24=Semi-Monthly Payment 26=BiWeekly Payment 4=Quarterly
10	FORM_LONG_NAME	Character(100)	VARCHAR2(100) NOT NULL	Form Long Name
11	FORM_CODE	Character(4)	VARCHAR2(4) NOT NULL	Form Code CO=Certain Only Installment JS=Joint & Survivor Annuity LIFE=Life Annuity LIO=Level Income Option LTS=Last to Survive Annuity LUMP=Lump Sum POP=Pop Up Annuity REV=Reversionary Annuity SPJS=Spouse Demonstration JS
12	GUARANTEED_PAYMENT	Number(3,0)	SMALLINT NOT NULL	Guaranteed Payments
13	PCT_CONTINUED	Number(6,2)	DECIMAL(5,2) NOT NULL	Percent Continued to Survivor
14	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
15	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
16	PA_PMT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payment Type
17	PA_PMT_AMT	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Payment Amount
18	PA_ADJ_AMT	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Adjustment Amount
19	PA_PMT_TOTAL	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Payment Total
20	PA_PMT_AMT_NOTAX	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Payment Amount Non Taxable
21	PA_ADJ_AMT_NOTAX	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Adjustment Amount Non Taxable
22	PA_PMT_TOTAL_NOTAX	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Payment Non Taxable Total
23	PA_ALT_PAYEE	Character(30)	VARCHAR2(30) NOT NULL	Designated Payee Name