CALENDAR_YEARHR_PAY_BAND_IDN=No
Y=Yes
Default Value: N
HR_EEO1_PAYBAND(SQL Table) |
Index Back |
|---|---|
EEO1 Pay BandsConfiguration table for EEO1 Pay Bands |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 2 | HR_PAY_BAND_ID |
Number(3,0) | SMALLINT NOT NULL | PayBand ID to be used for EEO1 Reporting |
| 3 | HR_LOWER_LIMIT | Number(20,0) | DECIMAL(20) NOT NULL | Pay Lower Limit for EEO1 reporting configuration |
| 4 | HR_UPPER_LIMIT | Number(20,0) | DECIMAL(20) NOT NULL | Pay Upper Limit for EEO1 reporting configuration |
| 5 | HR_NO_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
Field used for EEO1 reporting pay band configuration.
N=No Y=Yes Default Value: N |