GPGB_EE_CO_VW(SQL View) |
Index Back |
|---|---|
Detail for EE court ordersHolds detail data lines for Court Orders |
| SELECT EMPLID ,GPGB_CO_ORD_REF ,GPGB_CO_LEG ,GPGB_CO_ORDER ,INSTANCE ,CREATION_TIME ,EMPL_RCD ,SEQNUM ,GPGB_CO_ORD_NUM ,GPGB_CO_AUTHORITY ,GPGB_CO_REASON ,GPGB_CO_NDR ,GPGB_CO_PER ,GPGB_CO_AMT_PAYBLE ,GPGB_CO_FEE_TAKEN ,START_DATE ,STOP_DATE ,END_DATE ,GPGB_CO_CAO_IND ,ACTIVE_FLAG ,GPGB_EE_PCTG_CONT ,RECIPIENT_TAG ,GPGB_CO_CRT_TM ,GPGB_CO_HRT ,UPDATE_ID ,GPGB_CO_UPDTYPE FROM PS_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_ORD_REF | Character(25) | VARCHAR2(25) NOT NULL | GPUK Court Order Reference |
| 3 | 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 |
| 4 | GPGB_CO_ORDER |
Character(3) | VARCHAR2(3) NOT NULL |
UK Court Orders
Prompt Table: %RECNAME_EDIT |
| 5 | INSTANCE |
Number(3,0) | SMALLINT NOT NULL |
Instance Number
Default Value: 1 |
| 6 | CREATION_TIME |
Time(15) | TIMESTAMP NOT NULL |
Creation Time
Default Value: %time |
| 7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: GPGB_STARTER_VW |
| 8 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 9 | 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 |
| 10 | GPGB_CO_AUTHORITY | Character(60) | VARCHAR2(60) NOT NULL |
Court Order Issuing Authority
Prompt Table: GPGB_CO_AUTH_VW |
| 11 | GPGB_CO_REASON | Character(50) | VARCHAR2(50) NOT NULL |
Store the Court Order reasons value.
Prompt Table: GPGB_CO_RSN_VW |
| 12 | GPGB_CO_NDR | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | GPUK Court Order Normal Deduction Rate |
| 13 | GPGB_CO_PER | Number(9,2) | DECIMAL(8,2) NOT NULL | GPUK Court Order Protected Earnings Rate |
| 14 | GPGB_CO_AMT_PAYBLE | Number(9,2) | DECIMAL(8,2) NOT NULL | GPUK Court Amount Payable |
| 15 | 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 |
| 16 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 17 | STOP_DATE | Date(10) | DATE | Stop Date |
| 18 | END_DATE | Date(10) | DATE | End Date |
| 19 | 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 |
| 20 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Default Value: A |
| 21 | GPGB_EE_PCTG_CONT | Number(6,2) | DECIMAL(5,2) NOT NULL | Employee's Percentage Contribution |
| 22 | RECIPIENT_TAG | Number(3,0) | SMALLINT NOT NULL |
Used to identify recipients for E/D, PI
Prompt Table: GPGB_RCPPYE_VW |
| 23 | GPGB_CO_CRT_TM | Character(15) | VARCHAR2(15) NOT NULL |
GPUK Court Order Create Time
Default Value: GPGB_EE_CO_DTL.CREATION_TIME |
| 24 | GPGB_CO_HRT | Character(1) | VARCHAR2(1) NOT NULL |
High/Low Deduction rate indicator
Default Value: N |
| 25 | UPDATE_ID | Character(30) | VARCHAR2(30) NOT NULL | Update ID |
| 26 | GPGB_CO_UPDTYPE | Character(3) | VARCHAR2(3) NOT NULL | Field to Capture update type of court order end date |