GPGB_SS_IDPrompt Table: GPGB_SS_TYPE_VW
B=Share Buy
S=Share Save (SAYE)
Y/N Table Edit
Default Value: N
A=Fixed Amount
P=Percentage
Default Value: A
Y/N Table Edit
Default Value: N
0=Extend Scheme Period
1=Employee Settle Direct
Default Value: 0
GPGB_SS_DEFN_VW(SQL View) |
Index Back |
|---|---|
View Share Scheme DefinitionShare Scheme Definition - View used in the Assign Share Schemes at employee level. |
| SELECT GPGB_SS_ID ,GPGB_SS_TYPE_ID ,GPGB_SS_TYPE ,BGN_DT ,END_DT ,GPGB_SS_DUR_MN ,GPGB_SS_EXT_MN ,GPGB_SS_MAX_DUR_MN ,GPGB_SS_EMP_OVRD ,GPGB_SS_CONT_BASIS ,GPGB_SS_MIN_AMT_MN ,GPGB_SS_MIN_AMT_WK ,GPGB_SS_MIN_PCT ,GPGB_SS_MAX_AMT_MN ,GPGB_SS_MAX_AMT_WK ,GPGB_SS_MAX_PCT ,GPGB_SS_HOL_ALLOW ,GPGB_SS_HOL_DURMAX ,GPGB_SS_HOL_OPT ,GPGB_SS_DED_ELEM_1 ,GPGB_SS_DED_ELEM_2 ,GPGB_SS_ACM_ELEM_1 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 | GPGB_SS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Share Schemes Scheme Type
B=Share Buy S=Share Save (SAYE) |
| 4 | BGN_DT | Date(10) | DATE NOT NULL | Begin Date |
| 5 | END_DT | Date(10) | DATE | end date |
| 6 | GPGB_SS_DUR_MN | Number(3,0) | SMALLINT NOT NULL | Share Scheme Duration in Months |
| 7 | GPGB_SS_EXT_MN | Number(3,0) | SMALLINT NOT NULL | Share Scheme Extension Period in Months |
| 8 | GPGB_SS_MAX_DUR_MN | Number(3,0) | SMALLINT NOT NULL | Share Save Maximum Duration |
| 9 | GPGB_SS_EMP_OVRD | Character(1) | VARCHAR2(1) NOT NULL |
Share Scheme Duration Override at Employee level
Y/N Table Edit Default Value: N |
| 10 | GPGB_SS_CONT_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Share Scheme Employee Contribution Basis
A=Fixed Amount P=Percentage Default Value: A |
| 11 | GPGB_SS_MIN_AMT_MN | Number(9,2) | DECIMAL(8,2) NOT NULL | Share Schemes Minimum Monthly Contribution Amount |
| 12 | GPGB_SS_MIN_AMT_WK | Number(9,2) | DECIMAL(8,2) NOT NULL | Share Schemes Minimum Weekly Contribution Amount |
| 13 | GPGB_SS_MIN_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Minimum Percentage Contribution Amount |
| 14 | GPGB_SS_MAX_AMT_MN | Number(9,2) | DECIMAL(8,2) NOT NULL | Share Schemes Maximum Monthly Contribution Amount |
| 15 | GPGB_SS_MAX_AMT_WK | Number(9,2) | DECIMAL(8,2) NOT NULL | Share Schemes Maximum Weekly Contribution Amount |
| 16 | GPGB_SS_MAX_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Scheme Maximum Contribution Percentage |
| 17 | GPGB_SS_HOL_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Share Scheme Employee Contribution Holiday permitted
Y/N Table Edit Default Value: N |
| 18 | GPGB_SS_HOL_DURMAX | Number(3,0) | SMALLINT NOT NULL | Share Schemes Employee Contribution Holiday Duration in months |
| 19 | GPGB_SS_HOL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Share Schemes Employee Contribution Holiday Options
0=Extend Scheme Period 1=Employee Settle Direct Default Value: 0 |
| 20 | GPGB_SS_DED_ELEM_1 | Number(8,0) | INTEGER NOT NULL | Share Schemes - Actual Contributions Deduction Element |
| 21 | GPGB_SS_DED_ELEM_2 | Number(8,0) | INTEGER NOT NULL | Share Schemes - Actual Contributions Deduction Element |
| 22 | GPGB_SS_ACM_ELEM_1 | Number(8,0) | INTEGER NOT NULL | Share Schemes - Actual Contributions Deduction Element |