FMLA_PLAN_LNG(SQL Table) |
Index Back |
---|---|
FMLA Plan TableThe FMLA PLAN TABLE is used to establish a company's policies regarding eligibility and tracking of FMLA protected leave. Such parameters as the "FMLA Year" type used, the minimum eligibility requirements, the annual entitlement granted, and the source of eligibility information are specified here. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FMLA_PLAN_ID | Character(3) | VARCHAR2(3) NOT NULL | Family Medical Leave Plan ID |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %DATE |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |