GPGB_CO_DEA_RPT (SQL Table)	Index Back
GPGB CO DEA Reporting Table GPGB CO DEA Reporting Table

GPGB_CO_DEA_RPT

(SQL Table)

GPGB CO DEA Reporting Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 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

5 GPGB_CO_ORDER Character(3) VARCHAR2(3) NOT NULL UK Court Orders

6 GPGB_FROM_DT Date(10) DATE GP UK From Date

7 GPGB_COUNT Number(19,0) DECIMAL(19) NOT NULL GP UK Counter

8 GPGB_CO_ORD_REF Character(20) VARCHAR2(20) NOT NULL GPUK Court Order Reference

9 CREATION_TIME Time(15) TIMESTAMP CreationTime

10 NAME Character(50) VARCHAR2(50) NOT NULL Name

11 GPGB_CO_AMT_PAYBLE Number(9,2) DECIMAL(8,2) NOT NULL GPUK Court Amount Payable

12 GPGB_CO_NDR Signed Number(9,2) DECIMAL(7,2) NOT NULL GPUK Court Order Normal Deduction Rate

13 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.

14 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

15 GPGB_DEA_REASON Character(50) VARCHAR2(50) NOT NULL Reason for No Deductions in case of DEA Court Order.

16 HIRE_DT Date(10) DATE First Start Date

17 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

18 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	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
5	GPGB_CO_ORDER	Character(3)	VARCHAR2(3) NOT NULL	UK Court Orders
6	GPGB_FROM_DT	Date(10)	DATE	GP UK From Date
7	GPGB_COUNT	Number(19,0)	DECIMAL(19) NOT NULL	GP UK Counter
8	GPGB_CO_ORD_REF	Character(20)	VARCHAR2(20) NOT NULL	GPUK Court Order Reference
9	CREATION_TIME	Time(15)	TIMESTAMP	CreationTime
10	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
11	GPGB_CO_AMT_PAYBLE	Number(9,2)	DECIMAL(8,2) NOT NULL	GPUK Court Amount Payable
12	GPGB_CO_NDR	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	GPUK Court Order Normal Deduction Rate
13	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
14	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
15	GPGB_DEA_REASON	Character(50)	VARCHAR2(50) NOT NULL	Reason for No Deductions in case of DEA Court Order.
16	HIRE_DT	Date(10)	DATE	First Start Date
17	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
18	PIN_CODE	Character(22)	VARCHAR2(22) NOT NULL	Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)