FP_POINTYP_CDEFFDTDefault Value: %Date
FP_INCS_INDDefault Value: %Date
FPMINDEXAMT_TBL(SQL Table) |
Index Back |
|---|---|
Amount Index Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FP_POINTYP_CD |
Character(2) | VARCHAR2(2) NOT NULL | Point Type Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %Date |
| 3 | FP_INCS_IND |
Number(4,0) | SMALLINT NOT NULL | Increased Index |
| 4 | FP_ANNL_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Annual Amount |
| 5 | FP_MONTH_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Monthly Amount |
| 6 | FP_HOUR_AMT | Number(7,2) | DECIMAL(6,2) NOT NULL | Amount per Hour |
| 7 | LAST_UPDATE_DATE | Date(10) | DATE |
Date of last update
Default Value: %Date |