GPGB_SS_IDA=Fixed Amount
P=Percentage
GPGB_SS_BUY_VW(SQL View) |
Index Back |
|---|---|
GP UK Share Scheme DefinitionShare Scheme Definition |
| SELECT A.GPGB_SS_ID , A.DESCR , A.BGN_DT , A.GPGB_SS_REFERENCE , A.GPGB_SS_CONT_BASIS FROM PS_GPGB_SS_DEFN A , PS_GPGB_SS_TYPES B WHERE A.GPGB_SS_TYPE_ID = B.GPGB_SS_TYPE_ID AND A.GPGB_SS_ENROL_LOCK = 'N' AND B.GPGB_SS_TYPE = 'B' AND B.EFF_STATUS = 'A' |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | BGN_DT | Date(10) | DATE | Begin Date |
| 4 | GPGB_SS_REFERENCE | Character(15) | VARCHAR2(15) NOT NULL | Share Schemes Scheme Reference |
| 5 | GPGB_SS_CONT_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Share Scheme Employee Contribution Basis
A=Fixed Amount P=Percentage |