PY_TAX960US_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	PY_W2_PROCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Year End using XML Publisher: Identifies type of process. 1=Original 2=Corrected 3=Reissued Statement 4=No Specific Reason
15	PY_W2_FINAL_PRINT	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether final run or not. Y/N Table Edit
16	PY_YE_RPT_BURST	Character(1)	VARCHAR2(1) NOT NULL	Indicates if report bursting is required. Y/N Table Edit
17	PY_W2_COPY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	W-2/W-2c Type 1=Government Copy 2=Employee Copy 4=Company Copy
18	BURST_FIELDNAME	Character(30)	VARCHAR2(30) NOT NULL	Burst Field Name
19	PY_YE_BURST_ID	Character(40)	VARCHAR2(40) NOT NULL	Stores the value used for bursting a PDF file into separate employee-level files.
20	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
21	CONTENTID	Number(15,0)	DECIMAL(15) NOT NULL	Report ID
22	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
23	SEARCH_FIELDNAME	Character(30)	VARCHAR2(30) NOT NULL	Search Field Name
24	PY_RPT_DEFN_ID_SS	Character(12)	VARCHAR2(12) NOT NULL	Report Definition to be used for Self-Sevice.
25	PY_RPT_TMPL_ID_SS	Character(30)	VARCHAR2(30) NOT NULL	Report Template to be used for Self-Sevice.
26	PY_YE_RPT_SS	Character(1)	VARCHAR2(1) NOT NULL	Indicates if report destination is a self-service application.
27	PY_YE_SOURCEFILE2	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs.
28	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.
29	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
30	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
31	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
32	PY_YE_FILEURLID	Character(30)	VARCHAR2(30) NOT NULL	URL ID used to store and retrieve year-end pdf forms.
33	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
34	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.