GPGB_SL_TRN_STG (SQL Table)	Index Back
Staging Table for GPUK SL XML Staging Table for GPUK SL1/SL2 XML

GPGB_SL_TRN_STG

(SQL Table)

Staging Table for GPUK SL XML

Staging Table for GPUK SL1/SL2 XML

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	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