PY_CTX910RL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
6	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN).
7	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN).
8	PY_YE_SOURCEFILE	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs.
9	PY_YE_SOURCELOC	Character(254)	VARCHAR2(254) NOT NULL	Location where source XML file generated by one of the year end SQR programs is stored.
10	PY_YE_SRC_FILENAME	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs, including file path.
11	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
14	YE_SLIP_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Slip Process Type A=Amended C=Cancelled D=Delete N=Newly Reissued O=Original
15	RV1_COPY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	RL-1 Slip Copy Type 1=Government Copy 2=Employee Copy 4=Company Copy
16	RL2_FINAL_PRINT	Character(1)	VARCHAR2(1) NOT NULL	RL-2 Final Print
17	RL1_FINAL_PRINT	Character(1)	VARCHAR2(1) NOT NULL	RL-1 Final Print
18	PY_YE_RPT_BURST	Character(1)	VARCHAR2(1) NOT NULL	Indicates if report bursting is required. Y/N Table Edit
19	BURST_FIELDNAME	Character(30)	VARCHAR2(30) NOT NULL	Burst Field Name
20	PY_YE_BURST_ID	Character(40)	VARCHAR2(40) NOT NULL	Stores the value used for bursting a PDF file into separate employee-level files.
21	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
22	CONTENTID	Number(15,0)	DECIMAL(15) NOT NULL	Report ID
23	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
24	SEARCH_FIELDNAME	Character(30)	VARCHAR2(30) NOT NULL	Search Field Name
25	PY_RPT_DEFN_ID_SS	Character(12)	VARCHAR2(12) NOT NULL	Report Definition to be used for Self-Sevice.
26	PY_RPT_TMPL_ID_SS	Character(30)	VARCHAR2(30) NOT NULL	Report Template to be used for Self-Sevice.
27	PY_YE_RPT_SS	Character(1)	VARCHAR2(1) NOT NULL	Indicates if report destination is a self-service application.
28	PY_YE_SOURCEFILE2	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs.
29	PY_YE_SRC_FILENAM2	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs, including file path.
30	PY_YE_NOTIFY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether notification of availability for viewing a year-end form has been sent to employee. Y - notification already sent to employee N - notification not yet sent to employee
31	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
32	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
33	PY_YE_FILEURLID	Character(30)	VARCHAR2(30) NOT NULL	URL ID used to store and retrieve year-end pdf forms.
34	PY_SLIP_FINAL_PRT	Character(1)	VARCHAR2(1) NOT NULL	Final Print?
35	TAXFORM_ID	Character(1)	VARCHAR2(1) NOT NULL	Tax Form Identification A=T4A Slip B=Business Payrolls Survey - CAN C=WCB Assessable Earnings E=Record of Employment F=940 - Annual Employer's FUTA I=W-2VI J=W-2cVI M=W-2GU N=W-2cGU P=W-2PR Q=W-2cPR R=RL-1 Slip S=W-2AS T=T4 Slip U=W-2cAS V=RL-2 Slip W=W-2 X=W-2c Y=1099-R Z=1042-S
36	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.