EMPLIDEMPL_RCDPrompt Table: GPGB_STARTER_VW
GPGB_CO_ORD_REFGPGB_CO_LEGEW=England and Wales
NI=Northern Ireland
SC=Scotland
GPGB_CO_ORDERPrompt Table: %RECNAME_EDIT
INSTANCEDefault Value: 1
Prompt Table: GP_RCPPYEDTL_VW
GPGB_CO_RCP_TAG(SQL Table) |
Index Back |
|---|---|
CO Recipient Tag RecordThis record stores the court order recipient tags details. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: GPGB_STARTER_VW |
| 3 | GPGB_CO_ORD_REF |
Character(25) | VARCHAR2(25) NOT NULL | GPUK Court Order Reference |
| 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
Prompt Table: %RECNAME_EDIT |
| 6 | INSTANCE |
Number(3,0) | SMALLINT NOT NULL |
Instance Number
Default Value: 1 |
| 7 | RECIPIENT_TAG | Number(3,0) | SMALLINT NOT NULL |
Used to identify recipients for E/D, PI
Prompt Table: GP_RCPPYEDTL_VW |