RC_US_YE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: PRCSRUNCNTL.OPRID
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Default Value: PRCSRUNCNTL.RUN_CNTL_ID
3	SORT_CODE1	Character(1)	VARCHAR2(1) NOT NULL	Sort Code1 1=None 2=State 3=Paygroup 4=Department 5=Zip Code 6=Mail Drop 7=State/Locality Default Value: 1
4	ASOFDATE	Date(10)	DATE	As of Date
5	SORT_CODE3	Character(1)	VARCHAR2(1) NOT NULL	Sort Code3 1=Employee ID 2=Employee SSN 3=Employee Last Name
6	REG_SELECT_PROC	Character(1)	VARCHAR2(1) NOT NULL	Regular or Select Empl Proc A=Select Tax Reporting Agencies C=Selected W-2 Companies E=Selected EMPLIDs F=All Payees G=Selected Payees H=Within Selected Hire Dates J=All Tax Agencies L=Select Jurisdictions M=Within Selected Companies P=Within Selected Paygroups R=All Employees S=Selected Employees T=Sel Elig Locals by State Default Value: R
7	TOTALS_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Totals Only Flag Y/N Table Edit Default Value: Y
8	TAX_NUMBER	Character(8)	VARCHAR2(8) NOT NULL	Tax ID Number Default Value: 0
9	QTR1_AMT	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Quarter1 Amount
10	QTR2_AMT	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Quarter2 Amount
11	QTR3_AMT	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Quarter3 Amount
12	QTR4_AMT	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Quarter4 Amount
13	DISTRIB_CODE	Character(2)	VARCHAR2(2) NOT NULL	Distribution Code
14	TOTAL_DISTRIB_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Total Distribution Flag Y/N Table Edit Default Value: Y
15	TEST_IND_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Test Indicator Flag Y/N Table Edit Default Value: N
16	PAYER_NAME_CNTRL	Character(4)	VARCHAR2(4) NOT NULL	Payer Name Control
17	LAST_FILING_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Last Filing Flag Y/N Table Edit Default Value: N
18	COMB_FEDST_FILER	Character(1)	VARCHAR2(1) NOT NULL	Combined Federal/State Filer Y/N Table Edit Default Value: N
19	MEDIA	Character(1)	VARCHAR2(1) NOT NULL	Media D=Diskette N=None R=Report T=Tape Default Value: T
20	DISKETTE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Diskette Type 0=Not Applicable 1=3.5 Inches High Density 2=3.5 Inches Double Density
21	MARK_VOIDS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Mark Voids Flag Y/N Table Edit Default Value: N
22	DISK_TYPE3	Character(1)	VARCHAR2(1) NOT NULL	Diskette Type3 1=3.5in High Density 2=5.25in High Density 3=5.25in Double Density
23	LINES_PER_INCH	Character(1)	VARCHAR2(1) NOT NULL	Lines per Inch 6=6 Lines per Inch 8=8 Lines per Inch Default Value: 6
24	NY_FEDWAGE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	New York Use Fed Wage Flag Y/N Table Edit Default Value: N
25	LOCTX_EEDT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Local Tax EE Detail Rpt Flag F=Employee Detail-Local and Fed N=Totals Only Y=Employee Detail (Local Only) Default Value: N
26	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
27	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
28	OPEN_CLOSE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Open Close Flag C=Close O=Open
29	PAYER_PHONE	Character(15)	VARCHAR2(15) NOT NULL	Payer's phone number && Ext
30	PAYER_NAME	Character(40)	VARCHAR2(40) NOT NULL	Payer's Name
31	TRANS_CNTL_CODE	Character(5)	VARCHAR2(5) NOT NULL	Transmitter control code.
32	REPLACE_ALPHA	Character(2)	VARCHAR2(2) NOT NULL	Replacement Alpha Character
33	TELEPHONE_NBR	Character(15)	VARCHAR2(15) NOT NULL	Telephone Number
34	RESUB_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Resub Indicator. Y/N Table Edit Default Value: N
35	LAYOUT_STYLE	Character(10)	VARCHAR2(10) NOT NULL	Layout Style Prompt Table: LAYOUT_STYLE_VW
36	REPRINT_PROMPT	Character(1)	VARCHAR2(1) NOT NULL	Reprint Y/N Table Edit
37	REPRINT_DESCR	Character(1)	VARCHAR2(1) NOT NULL	Reprint Description B=No Specific Reason C=Corrected R=Reissued Statement
38	REG_SELECT_COMP	Character(1)	VARCHAR2(1) NOT NULL	Regular or Select Empl Proc C=Selected Companies R=All Companies Default Value: R
39	PAYER_EMAIL_ADDR	Character(40)	VARCHAR2(40) NOT NULL	Contact Email Address
40	XMIT_MEDIA_NBR	Character(6)	VARCHAR2(6) NOT NULL	Transmitter's Media Number
41	REG_SELECT_STATE	Character(1)	VARCHAR2(1) NOT NULL	Regular or Select State/Locl A=All States and Localities S=Selected States and Localities Default Value: A
42	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification Default Value: TAXRPT_RUNCTL.FORM_ID
43	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN).
44	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN).
45	PY_W2_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Year End using XML Publisher: Identifies US or Territory. I=W-2VI M=W-2GU S=W-2AS W=W-2 Default Value: W
46	PY_W2_COPY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	W-2/W-2c Type 1=Government Copy 2=Employee Copy 4=Company Copy Default Value: 2
47	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 Default Value: 1
48	PY_W2_FINAL_PRINT	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether final run or not. Y/N Table Edit Default Value: N
49	PY_YE_RPT_BURST	Character(1)	VARCHAR2(1) NOT NULL	Indicates if report bursting is required. Y/N Table Edit
50	FROMDATE	Date(10)	DATE	From Date
51	THRUDATE	Date(10)	DATE	End Date
52	CONSENT_PROC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Consent Report Request Flag A=All Statuses Summary C=Consented R=Reset W=Withdrawn Default Value: A