GPIN_F16RPT_KEYGPIN_FLD_NAMEGPIN_FLD_NAME1GPIN_FLD_NAME2GPIN_F16_TMP4(SQL Table) |
Index Back |
|---|---|
Form 16/16 AA StagingTableUsed to hold the Form 16/16AA data of all employees from which XML is built for each employee and stored in GPIN_F16_RPT self service record. This hold the data of current run. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPIN_F16RPT_KEY |
Number(20,0) | DECIMAL(20) NOT NULL | Report Key |
| 2 | GPIN_FLD_NAME |
Character(15) | VARCHAR2(15) NOT NULL | Payee Report Field Name |
| 3 | GPIN_FLD_NAME1 |
Character(30) | VARCHAR2(30) NOT NULL | Payee Report Field Name |
| 4 | GPIN_FLD_NAME2 |
Character(50) | VARCHAR2(50) NOT NULL | Payee Report Field Name |
| 5 | GPIN_NUM_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 6 | GPIN_CHAR_VAL | Character(150) | VARCHAR2(150) NOT NULL | Application Framework - Character |
| 7 | GPIN_F16_DTYPE | Character(4) | VARCHAR2(4) NOT NULL | Data Type |
| 8 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 9 | GPIN_LBL_ID | Character(10) | VARCHAR2(10) NOT NULL | label ID |