GPDE_AZ_IMDL(SQL Table) |
Index Back |
|---|---|
OAPT Increase ModelRates and Properties for an old age parttime increase model |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPDE_AZ_IMODEL_ID |
Character(12) | VARCHAR2(12) NOT NULL | Descr |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | GPDE_AZ_PCT_GRS | Number(6,2) | DECIMAL(5,2) NOT NULL | Gross Increase |
| 5 | GPDE_AZ_LMODE1 | Character(1) | VARCHAR2(1) NOT NULL |
Descr
A=Apply SI-Limit I=Ignore SI-Limit S=Statutory Limit Method Default Value: A |
| 6 | GPDE_AZ_SUB_PREV | Character(1) | VARCHAR2(1) NOT NULL |
Descr
Y/N Table Edit Default Value: Y |
| 7 | GPDE_AZ_PCT_NET | Number(6,2) | DECIMAL(5,2) NOT NULL | Descr |
| 8 | GPDE_AZ_LMODE2 | Character(1) | VARCHAR2(1) NOT NULL |
Descr
A=Apply SI-Limit I=Ignore SI-Limit S=Statutory Limit Method Default Value: A |
| 9 | GPDE_AZ_PCT_PENS | Number(6,2) | DECIMAL(5,2) NOT NULL | Descr |
| 10 | GPDE_AZ_FULL_BBG | Character(1) | VARCHAR2(1) NOT NULL |
Apply 100% of BBG
Y/N Table Edit Default Value: N |