HP_SAL_RANGE_CDEFFDTDefault Value: %date
SEQ_NOHP_SAL_RANGE_DL(SQL Table) |
Index Back |
|---|---|
Salary Range Matrix DetailThis table stores the salary range with corresponding encumbrance percentage and additional amount. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HP_SAL_RANGE_CD |
Character(5) | VARCHAR2(5) NOT NULL | Salary Range Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | SEQ_NO |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | HP_MIN_SALARY | Number(14,2) | DECIMAL(13,2) NOT NULL | Minimum Salary defined on Salary Range table |
| 5 | HP_MAX_SALARY | Number(14,2) | DECIMAL(13,2) NOT NULL | Maximum Salary defined on Salary Range table |
| 6 | ENCUMB_DFLT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Default Percentage |
| 7 | ENCB_DFLT_ADDL_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Additional Default Amt |