OPRIDRUN_CNTL_IDY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
10=W-2
110=W-2c
120=W-2cAS
130=W-2cGU
140=W-2cPR
150=W-2cVI
20=W-2AS
30=W-2GU
40=W-2PR
50=W-2VI
GPUS_RC_MMREF(SQL Table) |
Index Back |
|---|---|
Year End MMREF Run Control TabRun Control table to create MMREF files. |
| # | 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 | CALENDAR_YEAR | Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 4 | GPUS_RESUB_IND | Character(1) | VARCHAR2(1) NOT NULL |
Resubmit Indicator.
Y/N Table Edit Default Value: N |
| 5 | GPUS_RESUB_WFID | Character(6) | VARCHAR2(6) NOT NULL | Wage File Identifier |
| 6 | GPUS_TOTALS_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Totals Only Flag
Y/N Table Edit Default Value: Y |
| 7 | GPUS_YEW2C_CNT | Number(7,0) | INTEGER NOT NULL | Rows ready for EFW2 file |
| 8 | GPUS_TAXFORM_ID | Character(3) | VARCHAR2(3) NOT NULL |
Tax Form ID
10=W-2 110=W-2c 120=W-2cAS 130=W-2cGU 140=W-2cPR 150=W-2cVI 20=W-2AS 30=W-2GU 40=W-2PR 50=W-2VI |