BAS_CMP_ALLAT_V

(SQL View)
 Index Back

compare template format


SELECT SEC.PLAN_TYPE ,SEC.BAS_CMP_TMPL_ID ,SEC.BAS_CMP_SEC_PTYPE ,SEC.BAS_CMP_SECT_ID ,SEC.EFFDT ,SEC.BAS_CMP_SECT_ORD ,ATT.BAS_CMP_ATT_PTYPE ,ATT.BAS_CMP_ATTR_ID ,ATT.BAS_CMP_ATTR_ORD ,ITM.BAS_CMP_ITEM_ID ,ITM.BAS_CMP_ITEM_ORD FROM PS_BAS_CMP_TMP_SEC SEC , PS_BAS_CMP_TMP_ATT ATT , PS_BAS_CMP_TMP_ITM ITM WHERE SEC.PLAN_TYPE =ATT.PLAN_TYPE AND SEC.PLAN_TYPE = ITM.PLAN_TYPE AND SEC.BAS_CMP_TMPL_ID =ATT.BAS_CMP_TMPL_ID AND SEC.BAS_CMP_TMPL_ID=ITM.BAS_CMP_TMPL_ID AND SEC.BAS_CMP_SEC_PTYPE= ATT.BAS_CMP_SEC_PTYPE AND SEC.BAS_CMP_SEC_PTYPE=ITM.BAS_CMP_SEC_PTYPE AND SEC.BAS_CMP_SECT_ID= ATT.BAS_CMP_SECT_ID AND SEC.BAS_CMP_SECT_ID=ITM.BAS_CMP_SECT_ID AND ATT.BAS_CMP_ATT_PTYPE = ITM.BAS_CMP_ATT_PTYPE AND ATT.BAS_CMP_ATTR_ID = ITM.BAS_CMP_ATTR_ID AND SEC.EFFDT = ATT.EFFDT AND SEC.EFFDT = ITM.EFFDT UNION SELECT SEC.PLAN_TYPE ,SEC.BAS_CMP_TMPL_ID ,SEC.BAS_CMP_SEC_PTYPE ,SEC.BAS_CMP_SECT_ID ,SEC.EFFDT ,SEC.BAS_CMP_SECT_ORD ,ATT.BAS_CMP_ATT_PTYPE ,ATT.BAS_CMP_ATTR_ID ,ATT.BAS_CMP_ATTR_ORD ,' ' ,0 FROM PS_BAS_CMP_TMP_SEC SEC , PS_BAS_CMP_TMP_ATT ATT WHERE SEC.PLAN_TYPE =ATT.PLAN_TYPE AND SEC.BAS_CMP_TMPL_ID =ATT.BAS_CMP_TMPL_ID AND SEC.BAS_CMP_SEC_PTYPE= ATT.BAS_CMP_SEC_PTYPE AND SEC.BAS_CMP_SECT_ID= ATT.BAS_CMP_SECT_ID AND SEC.EFFDT = ATT.EFFDT

  • Parent record: BAS_CMP_TMP_ATT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Template ID
    3 BAS_CMP_SEC_PTYPE 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.
    4 BAS_CMP_SECT_ID Character(5) VARCHAR2(5) NOT NULL Section ID
    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 BAS_CMP_SECT_ORD Number(3,0) SMALLINT NOT NULL Order
    7 BAS_CMP_ATT_PTYPE 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.
    8 BAS_CMP_ATTR_ID Character(5) VARCHAR2(5) NOT NULL Attribute ID
    9 BAS_CMP_ATTR_ORD Number(3,0) SMALLINT NOT NULL Order
    10 BAS_CMP_ITEM_ID Character(5) VARCHAR2(5) NOT NULL Item ID
    11 BAS_CMP_ITEM_ORD Number(3,0) SMALLINT NOT NULL Order