GPGB_RTIXML_TBL(SQL Table) |
Index Back |
|---|---|
RTI XML Transaction TableRTI XML Transaction Table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPGB_RTIXML_S_FAC |
Number(8,0) | INTEGER NOT NULL | RTI XML Split Factor |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | GPGB_EDI_TRANS | Character(4) | VARCHAR2(4) NOT NULL |
EDI Transaction Types
EDI=EDI Extraction EXPT=P46 Expat Starter Notification P14=P14 P35=P35 P451=P45 Leaver Notification P453=P45 Starter Notification P46=P46 Starters P6=P6 P6B=P6B P9=P9 PEN=P46 Pension Starter PGL1=PGL1 Start Notice PGL2=PGL2 Stop Notice SL1=SL1 Start Notice SL2=SL2 Stop Notice WNU=Works Number Update |
| 6 | GPGB_XML_TRANID | Number(31,0) | DECIMAL(31) NOT NULL | GPGB_XML_TRANID |
| 7 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 8 | EMPLID_FROM | Character(11) | VARCHAR2(11) NOT NULL | EMPLID (first for a range) |
| 9 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | Empl ID To |
| 10 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |