GPGB_SS_TYPE_IDPrompt Table: GPGB_SS_TYPES
EFFDTGPGB_SS_LIM_VW(SQL View) |
Index Back |
|---|---|
GP UK Share Scheme LimitsShare Scheme Types Inland Revenue Limits. |
| SELECT A.GPGB_SS_TYPE_ID ,A.EFFDT ,A.GPGB_IR_MIN_AMT_WK ,A.GPGB_IR_MIN_AMT_MN ,A.GPGB_IR_MAX_AMT_WK ,A.GPGB_IR_MAX_AMT_MN ,A.GpGB_IR_MAX_AMT_YR ,A.GPGB_IR_MAX_PCT FROM PS_GPGB_SS_LIMITS A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GPGB_SS_LIMITS B) |
| # | 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 |
| 3 | GPGB_IR_MIN_AMT_WK | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Minimum Weekly Contribution Amount |
| 4 | GPGB_IR_MIN_AMT_MN | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Minimum Monthly Contribution Amount |
| 5 | GPGB_IR_MAX_AMT_WK | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Maximum Weekly Contribution Amount |
| 6 | GPGB_IR_MAX_AMT_MN | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Maximum Monthly 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 |