GPGB_PYENT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
2	GPGB_ER_NAME	Character(36)	VARCHAR2(36) NOT NULL	Employer's name
3	GPGB_ER_TAXNUM	Number(3,0)	SMALLINT NOT NULL	Employer's Tax Number
4	GPGB_ER_TAX_DNAME	Character(40)	VARCHAR2(40) NOT NULL	Employer's Tax District Name
5	GPGB_ER_PAYE_REF	Character(10)	VARCHAR2(10) NOT NULL	Employer's PAE reference number
6	GPGB_ER_PERMIT_NUM	Character(12)	VARCHAR2(12) NOT NULL	Permit Number for end of year submissions on magnetic media.
7	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
8	GPGB_ER_ECON	Character(9)	VARCHAR2(9) NOT NULL	Employers Contracted Out Number Prompt Table: GPGB_ACTECON_VW
9	GPGB_EDI_SENDER_ID	Character(35)	VARCHAR2(35) NOT NULL	GP UK EDI Sender ID.
10	GPGB_ACCT_OFF_NBR	Character(13)	VARCHAR2(13) NOT NULL	Employer Accounts Office Number
11	GPGB_SAUTR_REF	Number(10,0)	DECIMAL(10) NOT NULL	Self Assessment Unique Identifier
12	GPGB_COTAXREF	Number(10,0)	DECIMAL(10) NOT NULL	Corporation Tax Reference
13	GPGB_SELECT	Character(1)	VARCHAR2(1) NOT NULL	GP UK Use This
14	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID Prompt Table: GPGB_RTI_BNK_VW
15	GPGB_BANK_DETAIL	Character(15)	VARCHAR2(15) NOT NULL	Bank details
16	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID Prompt Table: GPGB_RTI_BNK_VW
17	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID Prompt Table: GPGB_BNK_BR_VW
18	GPGB_SCON	Character(9)	VARCHAR2(9) NOT NULL	SCON - Scheme Contracted Out Number Prompt Table: GPGB_ACTSCON_VW