GPGB_P6P9_X_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPGB_SEQ_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
3	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
4	GPGB_EDI_WORKS_ID	Character(35)	VARCHAR2(35) NOT NULL	GP UK Inland Revenue Works Id (Unique EmplId)
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	ISSUE_DT	Date(10)	DATE	Issue Date for Payment Reconciliation
7	GPGB_TAX_END_YR	Number(4,0)	SMALLINT NOT NULL	Tax Year Ends In This Calendar Year
8	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
9	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
10	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
11	GPGB_F_ER_PAYE_REF	Character(14)	VARCHAR2(14) NOT NULL	Employer's PAE reference number
12	TAX_CODE_UK	Character(15)	VARCHAR2(15) NOT NULL	Tax Code for UK
13	TAX_BASIS_UK	Character(1)	VARCHAR2(1) NOT NULL	Tax Basis for the UK 0=Cumulative 1=Week 1/Month 1
14	GPGB_SV_TAX_IND	Character(1)	VARCHAR2(1) NOT NULL	Scottish Variable Tax Indicator - Y/N. If this is set to Y then the Tax Code entered should be prefixed with an 'S' C=Welsh S=Scottish U=UK
15	GPGB_P45_PAY_TD	Number(19,6)	DECIMAL(18,6) NOT NULL	Total Pay to Date from P45
16	GPGB_P45_TAX_TD	Number(19,6)	DECIMAL(18,6) NOT NULL	Total Tax to Date from P45