RC_TAX920UST(SQL Table) |
Index Back |
---|---|
Process W-2cProcess 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 |