GPGB_EDI_AUDHDR(SQL Table) |
Index Back |
|---|---|
EDI Audit Header TableAudit header containing transaction summary information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPGB_EDI_REF |
Number(14,0) | DECIMAL(14) NOT NULL | GPUK EDI stores EDI transaction number |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT_OPR_VW |
| 4 | 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 |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | GPGB_EDI_FILENAME | Character(35) | VARCHAR2(35) NOT NULL | GPUK EDI stores EDI filename |
| 8 | GPGB_EDI_MESSAGE | Character(254) | VARCHAR2(254) NOT NULL | EDI Messages |
| 9 | ASOFDATE | Date(10) | DATE | As of Date |