FMLA_PLAN_TBL(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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | FMLA_CALENDAR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Calendar Type
B=Roll-Backward C=Fixed Calendar F=Roll-Forward Default Value: C |
| 7 | CALENDAR_BEGIN_MM | Number(2,0) | SMALLINT NOT NULL | Begin Month |
| 8 | CALENDAR_BEGIN_DD | Number(2,0) | SMALLINT NOT NULL | Begin Day |
| 9 | MIN_HOURS_REQD | Number(4,0) | SMALLINT NOT NULL |
Minimum Earned Hours Required
Default Value: 1250 |
| 10 | MIN_SVC_WKS_REQD | Number(2,0) | SMALLINT NOT NULL |
Minimum Service Weeks Required
Default Value: 52 |
| 11 | STD_OR_PAY_HRS | Character(1) | VARCHAR2(1) NOT NULL |
Use Standard or Payroll Hours
P=Use Payroll Hours S=Use Standard Hours Default Value: S |
| 12 | ERNCD_SPCL | Character(3) | VARCHAR2(3) NOT NULL |
Special Accumulator Code
Prompt Table: SPCL_EARNS_TBL |
| 13 | ANN_ENTITLEMNT_WKS | Number(4,1) | DECIMAL(3,1) NOT NULL |
Annual Entitlement
Default Value: 12 |