PY_TAX950_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	PY_YE_SOURCEFILE	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs.
7	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.
8	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.
9	PY_YE_OSPLATFORM	Character(4)	VARCHAR2(4) NOT NULL	Operating System Platform. Valid Values are: UNIX, MVS, NT
10	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
11	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
12	PY_YE_SOURCEFILE2	Character(254)	VARCHAR2(254) NOT NULL	Filename of XML file generated by one of the year end forms SQR programs.
13	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.
14	PY_YE_FILE_COUNT	Number(3,0)	SMALLINT NOT NULL	File Count
15	MEDIA_1042	Character(1)	VARCHAR2(1) NOT NULL	Media for 1042 B=Both Paper and Electronic File E=Electronic File P=Paper
16	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.
17	PY_1042S_GVT_CPY	Character(1)	VARCHAR2(1) NOT NULL	Government Copy
18	PY_1042S_EMP_CPY	Character(1)	VARCHAR2(1) NOT NULL	Employee Copy
19	PY_1042S_CO_CPY	Character(1)	VARCHAR2(1) NOT NULL	1042-S Copy Type
20	PY_RPT_DFN_VALID	Character(1)	VARCHAR2(1) NOT NULL	Flag to check valid report defenition
21	PY_TMPL_DFN_VALID	Character(1)	VARCHAR2(1) NOT NULL	Flag to check valid template defenition
22	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
23	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
24	PY_YE_FILEURLID	Character(30)	VARCHAR2(30) NOT NULL	URL ID used to store and retrieve year-end pdf forms.
25	PY_1042_CPY_TYP_SS	Character(1)	VARCHAR2(1) NOT NULL	Self Service Copy
26	PY_1042S_FNL_PRINT	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether final run or not.
27	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
28	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
29	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
30	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN).
31	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN).
32	PY_YE_RPT_BURST	Character(1)	VARCHAR2(1) NOT NULL	Indicates if report bursting is required. Y/N Table Edit
33	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
34	PY_RPT_DEFN_ID_SS	Character(12)	VARCHAR2(12) NOT NULL	Report Definition to be used for Self-Sevice.
35	PY_RPT_TMPL_ID_SS	Character(30)	VARCHAR2(30) NOT NULL	Report Template to be used for Self-Sevice.
36	PY_YE_RPT_SS	Character(1)	VARCHAR2(1) NOT NULL	Indicates if report destination is a self-service application.
37	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