GPGB_EE_CO_HDR (SQL Table)	Index Back
Employee Court Orders Header Header record to hold effective date and sequence and region (Legislation)

GPGB_EE_CO_HDR

(SQL Table)

Employee Court Orders Header

Header record to hold effective date and sequence and region (Legislation)

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 GPGB_CO_LEG Character(2) VARCHAR2(2) NOT NULL Used for UK and NI court orders to define the regulatory region - different rules exist for Scotland, England & Wales and Northern Ireland
EW=England And Wales
NI=Northern Ireland
SC=Scotland

3 GPGB_CO_SEQ_IND Character(1) VARCHAR2(1) NOT NULL GPUK Court Order Sequence
M=Page Order
S=System Sequenced
Default Value: S

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	GPGB_CO_LEG	Character(2)	VARCHAR2(2) NOT NULL	Used for UK and NI court orders to define the regulatory region - different rules exist for Scotland, England & Wales and Northern Ireland EW=England And Wales NI=Northern Ireland SC=Scotland
3	GPGB_CO_SEQ_IND	Character(1)	VARCHAR2(1) NOT NULL	GPUK Court Order Sequence M=Page Order S=System Sequenced Default Value: S