GPGB_EDI_AUDPMT (SQL View)	Index Back
GPUK EDI Audit Prompt GPUK prompt table for EDI Audits

GPGB_EDI_AUDPMT

(SQL View)

GPUK EDI Audit Prompt

GPUK 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
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

#	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 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