GPGB_CO_AUTHRTY(SQL Table) |
Index Back |
---|---|
Court Order AuthorityThis record stores the legal authority names and descriptions to be captured at the payee level for GBR court orders. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPGB_CO_AUTHORITY | Character(60) | VARCHAR2(60) NOT NULL | Court Order Issuing Authority |
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_ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
Y/N Table Edit |
4 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data |