| # |
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
5=Payee Copy
6=Payer 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
Y=1099-R
Z=1042-S
Default Value: X
|
| 14 |
PY_W2_MASK_SSN |
Character(1) |
VARCHAR2(1) NOT NULL |
SSN masking option for preprinted W-2/W-2c forms.
Y/N Table Edit
Default Value: N
|