EMPLIDEMPL_RCDGPGB_SS_IDEFFDTDefault Value: %date
0=Deduct Zero
1=Deduct Amount Available
2=Deduct Maximum Percentage
0=Process in Final Pay Period
1=Process if Employed Final Pd
2=Do Not Process in Final Pay Pd
GPGB_SS_EE_VW(SQL View) |
Index Back |
|---|---|
Share Scheme Processing ViewShare Schemes - This views pulls minimum values, maximum values and payroll processing rules from Scheme and Scheme Type tables. It is used by the main array SS AR MAIN during payroll processing |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.GPGB_SS_ID ,C.EFFDT ,B.GPGB_SS_MIN_AMT_MN ,B.GPGB_SS_MIN_AMT_WK ,B.GPGB_SS_MAX_AMT_MN ,B.GPGB_SS_MAX_AMT_WK ,B.GPGB_SS_MIN_PCT ,B.GPGB_SS_MAX_PCT ,B.GPGB_SS_RULE_MAT ,B.GPGB_SS_RULE_ERN ,B.GPGB_SS_RULE_LVE ,C.GPGB_IR_MIN_AMT_MN ,C.GPGB_IR_MIN_AMT_WK ,C.GPGB_IR_MAX_AMT_MN ,C.GPGB_IR_MAX_AMT_WK ,C.GPGB_IR_MAX_AMT_YR ,C.GPGB_IR_MAX_PCT FROM PS_GPGB_EE_SS A , PS_GPGB_SS_DEFN B , PS_GPGB_SS_LIMITS C WHERE A.GPGB_SS_ID = B.GPGB_SS_ID AND B.GPGB_SS_TYPE_ID = C.GPGB_SS_TYPE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | GPGB_SS_ID |
Character(10) | VARCHAR2(10) NOT NULL | Share Schemes Scheme ID |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | GPGB_SS_MIN_AMT_MN | Number(9,2) | DECIMAL(8,2) NOT NULL | Share Schemes Minimum Monthly Contribution Amount |
| 6 | GPGB_SS_MIN_AMT_WK | Number(9,2) | DECIMAL(8,2) NOT NULL | Share Schemes Minimum Weekly Contribution Amount |
| 7 | GPGB_SS_MAX_AMT_MN | Number(9,2) | DECIMAL(8,2) NOT NULL | Share Schemes Maximum Monthly Contribution Amount |
| 8 | GPGB_SS_MAX_AMT_WK | Number(9,2) | DECIMAL(8,2) NOT NULL | Share Schemes Maximum Weekly Contribution Amount |
| 9 | GPGB_SS_MIN_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Minimum Percentage Contribution Amount |
| 10 | GPGB_SS_MAX_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Scheme Maximum Contribution Percentage |
| 11 | GPGB_SS_RULE_MAT | Character(1) | VARCHAR2(1) NOT NULL | Share Schemes Maternity Suspension Payroll Processing rule |
| 12 | GPGB_SS_RULE_ERN | Character(1) | VARCHAR2(1) NOT NULL |
Share Schemes Insufficient Earnings Payroll Processing rule
0=Deduct Zero 1=Deduct Amount Available 2=Deduct Maximum Percentage |
| 13 | GPGB_SS_RULE_LVE | Character(1) | VARCHAR2(1) NOT NULL |
Share Schemes Leaver Processing rule
0=Process in Final Pay Period 1=Process if Employed Final Pd 2=Do Not Process in Final Pay Pd |
| 14 | GPGB_IR_MIN_AMT_MN | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Minimum Monthly Contribution Amount |
| 15 | GPGB_IR_MIN_AMT_WK | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Minimum Weekly Contribution Amount |
| 16 | GPGB_IR_MAX_AMT_MN | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Maximum Monthly Contribution Amount |
| 17 | GPGB_IR_MAX_AMT_WK | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Schemes Maximum Weekly Contribution Amount |
| 18 | GPGB_IR_MAX_AMT_YR | Number(9,2) | DECIMAL(8,2) NOT NULL | Share Schemes Maximum Monthly Contribution Amount |
| 19 | GPGB_IR_MAX_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Share Scheme Maximum Contribution Percentage |