GPGB_SS_TYPE_IDPrompt Table: GPGB_SS_TYPES
EFFDTDefault Value: %date
GPGB_SS_LIMITS(SQL Table) |
Index Back |
|---|---|
GP UK Share Scheme LimitsShare Scheme Types Inland Revenue Limits. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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_TYPES |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPGB_IR_MIN_AMT_MN | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Minimum Monthly Contribution Amount |
| 4 | GPGB_IR_MAX_AMT_MN | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Maximum Monthly Contribution Amount |
| 5 | GPGB_IR_MIN_AMT_WK | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Minimum Weekly Contribution Amount |
| 6 | GPGB_IR_MAX_AMT_WK | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Maximum Weekly Contribution Amount |
| 7 | GPGB_IR_MAX_AMT_YR | Number(9,2) | DECIMAL(8,2) NOT NULL | Share Schemes Maximum Monthly Contribution Amount |
| 8 | GPGB_IR_MAX_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Scheme Maximum Contribution Percentage |