PROCESS_INSTANCEY/N Table Edit
Default Value: N
Default Value: 0
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_FM1C_AET(SQL Table) |
Index Back |
|---|---|
State Record for AE program GPThis record stores all the parameters retrieved from Run Control page GPUS_RC_MMREFFD1C |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPUS_YE_RPT_CO | Character(3) | VARCHAR2(3) NOT NULL | Year-End Reporting Company |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | CALENDAR_YEAR | Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 6 | GPUS_RESUB_IND | Character(1) | VARCHAR2(1) NOT NULL |
Resubmit Indicator.
Y/N Table Edit Default Value: N |
| 7 | GPUS_RESUB_WFID | Character(6) | VARCHAR2(6) NOT NULL | Wage File Identifier |
| 8 | GPUS_THIRDPARTY_TX | Number(15,2) | DECIMAL(14,2) NOT NULL |
Third Party Tax Amount
Default Value: 0 |
| 9 | GPUS_XMITTER_ID | Character(8) | VARCHAR2(8) NOT NULL | Transmitter No |
| 10 | 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 |
| 11 | GPUS_CNTRL_NBR | Character(9) | VARCHAR2(9) NOT NULL | Control Number |
| 12 | GPUS_ACCESS_CD | Character(5) | VARCHAR2(5) NOT NULL | Access Code |
| 13 | GPUS_REGISTER_NBR | Character(5) | VARCHAR2(5) NOT NULL | Specialists Register Number |
| 14 | GPUS_SUPP_D2_2 | Character(46) | VARCHAR2(46) NOT NULL | Supplemental Data 2 |
| 15 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If flag |