GPDE_AZ_MODEL(SQL Table) |
Index Back |
---|---|
Old Age Part Time ModelOld Age Part Time Model |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPDE_AZ_MODEL_ID | Character(6) | VARCHAR2(6) NOT NULL | OAPT Model |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | GPDE_AZ_RATE1_LAW | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
Increase 1 Compulsory in %
Default Value: 20 |
5 | GPDE_AZ_RATE2_LAW | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
Minimum Net Compulsory in %
Default Value: 70 |
6 | GPDE_AZ_RATE2_VOL | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
Increase 1 Voluntary in %
Default Value: 0 |
7 | GPDE_AZ_SIRATE_LAW | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
Increase PI Gross Compulsory %
Default Value: 90 |
8 | GPDE_AZ_SIRATE_VOL | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
Increase PI Gross Voluntary %
Default Value: 0 |
9 | GPDE_AZ_RATE_T1 | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Minimum Net Tariff in % |
10 | GPDE_AZ_PCT_PT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
OAPT Part Time Percentage
Default Value: 50 |