GPGB_SS_IDGPGB_SS_TYPE_IDPrompt Table: GPGB_SS_TYPE_VW
GPGB_SS_D_SRCH(SQL View) |
Index Back |
|---|---|
GP UK Share Scheme DefinitionShare Scheme Definition |
| SELECT GPGB_SS_ID ,GPGB_SS_TYPE_ID ,DESCR ,BGN_DT FROM PS_GPGB_SS_DEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPGB_SS_ID |
Character(10) | VARCHAR2(10) NOT NULL | Share Schemes Scheme ID |
| 2 | GPGB_SS_TYPE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Identifies a Share Scheme (Save, Buy or Other) and associated Inland Revenue contribution limits
Prompt Table: GPGB_SS_TYPE_VW |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | BGN_DT | Date(10) | DATE | Begin Date |