PY_SS_1042S_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
5	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.
8	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
9	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
10	SEQUENCE_NUMBER	Number(2,0)	SMALLINT NOT NULL	Sequence Number
11	PY_BATCH_NBR	Number(4,0)	SMALLINT NOT NULL	Batch Number
12	PY_BATCH_YR	Number(4,0)	SMALLINT NOT NULL	Batch Year
13	PY_YE_FORM_SEQNUM	Number(2,0)	SMALLINT NOT NULL	A sequential number to indicate the number of W2/W-2c that have been issued/generated for an employee. Initial copy will have a value of 1. Used in Self Service Year-End Forms.
14	IRS_INCOME_CD_1042	Character(2)	VARCHAR2(2) NOT NULL	This field is to store the income code associated with the tax 1042 earnings. This income code is required on 1042S form.
15	YE_FORM_ISSUE_DT	Date(10)	DATE	This field is used in Payroll for North America Self Service Year-End Forms. It stores the date when the forms were generated.
16	YE_FORM_VIEWING_DT	Date(10)	DATE	This field is used in Payroll for North America Self Service Year-End Forms. It stores the date that determines when the forms become viewable in Self Service.
17	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
18	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
19	PY_YE_FILEURLID	Character(30)	VARCHAR2(30) NOT NULL	URL ID used to store and retrieve year-end pdf forms.
20	PY_YE_REPORT_URL	Character(254)	VARCHAR2(254) NOT NULL	Report URL
21	PY_YE_BURST_ID	Character(40)	VARCHAR2(40) NOT NULL	Stores the value used for bursting a PDF file into separate employee-level files.
22	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
23	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN).
24	BURST_FIELDNAME	Character(30)	VARCHAR2(30) NOT NULL	Burst Field Name
25	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
26	PY_1042S_FNL_PRINT	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether final run or not.
27	PY_YE_UPD_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Update Flag: I - Insert D- Delete C- Change/Replace F - Failed update C=Change D=Delete F=Failed I=Insert
28	PY_AMEND_NO	Number(2,0)	SMALLINT NOT NULL	1042S Amendment Number
29	TAX_RT	Signed Number(12,10)	DECIMAL(10,10) NOT NULL	Tax Rate (after form)