| # |
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 |
TAX_YEAR |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Tax Year
|
| 4 |
TRANSMITTER |
Character(3) |
VARCHAR2(3) NOT NULL |
Transmitter
Prompt Table:
PY_1042S_TR2_VW
|
| 5 |
PY_1042S_AMEND |
Character(1) |
VARCHAR2(1) NOT NULL |
Amendment Run
Y/N Table Edit
Default Value: N
|
| 6 |
HP_1042_FINAL_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Run indicator for 1042S Magnetic Media Process.
F=Final Run
I=Reissue 1042-S
R=Recreate File
T=Preliminary Run
|
| 7 |
MEDIA_1042 |
Character(1) |
VARCHAR2(1) NOT NULL |
Media for 1042
B=Both Paper and Electronic File
E=Electronic File
P=Paper
|
| 8 |
HP_1042S_FORM_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
1042-S Form ID indicator.
L=LSR01
P=LSR03UP
P=LSR03UP
V=LPS3V
V=LPS3V
X=BI Publisher
|
| 9 |
PY_FILE_NO |
Number(3,0) |
SMALLINT NOT NULL |
1042S File Number
|
| 10 |
ALIGN_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Alignment Count
|
| 11 |
ALIGN_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Alignment Only
Y/N Table Edit
|
| 12 |
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
|
| 13 |
PY_1042S_GVT_CPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Government Copy
Y/N Table Edit
|
| 14 |
PY_1042S_EMP_CPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Copy
Y/N Table Edit
|
| 15 |
PY_1042S_CO_CPY |
Character(1) |
VARCHAR2(1) NOT NULL |
1042-S Copy Type
Y/N Table Edit
|
| 16 |
PY_RPT_BATCH_SIZE |
Number(6,0) |
INTEGER NOT NULL |
Indicates the batch sizes for breaking down a large report.
|
| 17 |
PY_1042S_FNL_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether final run or not.
Y/N Table Edit
Default Value: N
|