RC_TAX920UST

(SQL Table)
Index Back

Process W-2c

Process Scheduler report parameter record utilized by Process W-2c function.

# 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 W2C_TAXFORM_ID Character(1) VARCHAR2(1) NOT NULL Tax Form Identification
I=W-2VI
M=W-2GU
P=W-2PR
S=W-2AS
W=W-2

Default Value: W

4 W2C_REG_REPRINT Character(1) VARCHAR2(1) NOT NULL Regular or Reprint Processing
C=Process Current Batch
R=Reprint Employee W-2cs

Default Value: C

5 ALIGN_COUNT Number(3,0) SMALLINT NOT NULL Alignment Count

Default Value: 0

6 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification

Default Value: LSR01

Prompt Table: W2C_FORM_UST_VW

7 EMPLOYEES_PER_PAGE Number(1,0) SMALLINT NOT NULL Employees Per Page

Default Value: 1

8 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
9 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).
10 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

11 PY_W2_FINAL_PRINT Character(1) VARCHAR2(1) NOT NULL Identifies whether final run or not.

Y/N Table Edit

12 PY_YE_RPT_BURST Character(1) VARCHAR2(1) NOT NULL Indicates if report bursting is required.

Y/N Table Edit

13 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

Default Value: X