GPGB_EDI_AUDPMT(SQL View) |
Index Back |
|---|---|
GPUK EDI Audit PromptGPUK prompt table for EDI Audits |
| SELECT DISTINCT H.GPGB_EDI_TRANS ,H.PAY_ENTITY ,H.GPGB_EDI_REF ,H.SEQNUM ,H.ASOFDATE FROM PS_GPGB_EDI_AUDHDR H , PS_GPGB_EDI_AUDDTL D WHERE D.GPGB_EDI_REF = H.GPGB_EDI_REF AND D.SEQNUM = H.SEQNUM AND D.EMPLID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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 |
| 2 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT_OPR_VW |
| 3 | GPGB_EDI_REF |
Number(14,0) | DECIMAL(14) NOT NULL | GPUK EDI stores EDI transaction number |
| 4 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | ASOFDATE | Date(10) | DATE | As of Date |