GPGB_EE_CO_DTL

#	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	CREATION_TIME	Time(15)	TIMESTAMP NOT NULL	CreationTime Default Value: %time
4	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
5	GPGB_CO_ORDER	Character(3)	VARCHAR2(3) NOT NULL	UK Court Orders Prompt Table: %RECNAME_EDIT
6	GPGB_CO_NDR	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	GPUK Court Order Normal Deduction Rate
7	GPGB_CO_PER	Number(9,2)	DECIMAL(8,2) NOT NULL	GPUK Court Order Protected Earnings Rate
8	GPGB_CO_AMT_PAYBLE	Number(9,2)	DECIMAL(8,2) NOT NULL	GPUK Court Amount Payable
9	GPGB_CO_ORD_REF	Character(20)	VARCHAR2(20) NOT NULL	GPUK Court Order Reference
10	GPGB_CO_FEE_TAKEN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether te employer wishes to charge a fee to the employee for the admin costs involved in deduction of the court order
11	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO
12	STOP_DATE	Date(10)	DATE	Stop Date
13	GPGB_CO_CAO_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used for conjoined Scottish court orders to show whether the order is for fines/maintenance or debt or both B=Both F=Fines M=Maintenance
14	GPGB_CO_CRT_TM	Character(15)	VARCHAR2(15) NOT NULL	GPUK Court Order Create Time Default Value: GPGB_EE_CO_DTL.CREATION_TIME
15	GPGB_CO_ORD_NUM	Number(1,0)	SMALLINT NOT NULL	Used to pass a number for each type of order to the GP process - for example, if there are three DEOs, they will be numbered from 1 - 3
16	END_DATE	Date(10)	DATE	End Date
17	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default Value: A
18	GPGB_EE_PCTG_CONT	Number(6,2)	DECIMAL(5,2) NOT NULL	Employee's Percentage Contribution
19	GPGB_COUNT	Number(19,0)	DECIMAL(19) NOT NULL	GP UK Counter
20	GPGB_FROM_DT	Date(10)	DATE	GP UK From Date