HR CSP ELIGIBILITY Table
Stores eligibility rules for the Childcare Scholarship Program (CSP) - Eligibility Chart / Non Tenured PSAs Eligible by personnel subarea and effective date range, indicating eligibility for capped, uncapped, and MIT-specific benefits. Each row represents an eligibility rule over a defined date range.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ELIGIBLE_FOR_CAPPED |
Indicator identifying whether the personnel subarea is eligible for capped CSP benefits (Y/N). |
VARCHAR2 |
1 |
ELIGIBLE_FOR_MIT |
Indicator identifying whether the personnel subarea is eligible for MIT-funded CSP benefits (Y/N). |
VARCHAR2 |
1 |
ELIGIBLE_FOR_UNCAPPED |
Indicator identifying whether the personnel subarea is eligible for uncapped CSP benefits (Y/N). |
VARCHAR2 |
1 |
END_DATE |
End date on which the eligibility rule expires. |
DATE |
|
PERSONNEL_SUBAREA_CODE |
Personnel subarea code used to determine CSP eligibility (as defined by source). |
VARCHAR2 |
4 |
START_DATE |
Start date on which the eligibility rule becomes effective. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |