CNTRL_BENPL_LNG

(SQL View)
 Index Back

Controlling BenPlans- Rel Lang

This is the related language view associated with CNTRL_BENPL_VW, which is a prompt table which provides plan type, benefit plan and description for use by "controlling" benefit plans

SELECT P.PLAN_TYPE ,P.BENEFIT_PLAN ,P.LANGUAGE_CD ,P.EFFDT ,P.DESCR ,P.DESCRSHORT FROM PS_BENEF_PLAN_LANG P

  • Related Language Record for CNTRL_BENPLN_VW EXCLD_BENPLN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CNTRL_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL This is used to identify the controlling Plan Type on setup tables, when PLAN_TYPE is already a record key.

    Prompt Table: PLAN_TYPE_VW

    2 CNTRL_BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL This is used to identify the controlling Benefit Plan on setup tables, when BENEFIT_PLAN is already a record key.

    Prompt Table: BENEF_PLAN_TBL

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE Effective Date
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description