BAS_CMP_CST_LV

(SQL View)
Index Back

Comparison Definitions Lang


SELECT BAS_CMP_PLAN_TYPE , BAS_CMP_DEFN_ID , LANGUAGE_CD , BAS_CMP_DEFN_NAME , BAS_CMP_DEFN_DESCR FROM PS_BAS_CMP_DEFN_LN A WHERE BAS_CMP_DEFN_TYPE = 'S' AND %EffdtCheck(BAS_CMP_DEFN B, A, %CURRENTDATEIN) AND BAS_CMP_PLAN_TYPE = 'CM' AND BAS_CMP_DEFN_ID IN ('COVG','PPC','PPCD')

  • Related Language Record for BAS_CMP_CST_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BAS_CMP_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
    2 BAS_CMP_DEFN_ID Character(5) VARCHAR2(5) NOT NULL Compare Definition ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 BAS_CMP_DEFN_NAME Character(30) VARCHAR2(30) NOT NULL Definition Name
    5 BAS_CMP_DEFN_DESCR Long Character CLOB Definition Description