FMLA_PLAN_LNG

(SQL Table)
Index Back

FMLA Plan Table

The 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.

  • Related Language Record for FMLA_PLAN_TBL
  • # 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