BAS_CMP_TMP_PRG (SQL View)	Index Back
Benefit Programs with Template List Benefit Programs that have compare templates defined.

BAS_CMP_TMP_PRG

(SQL View)

Benefit Programs with Template

List Benefit Programs that have compare templates defined.

SELECT DISTINCT B.BENEFIT_PROGRAM FROM PS_BEN_DEFN_PLAN A , PS_BEN_DEFN_OPTN B WHERE A.BENEFIT_PROGRAM = B.BENEFIT_PROGRAM AND A.PLAN_TYPE = B.PLAN_TYPE AND A.BAS_CMP_TMPL_ID > ' ' AND A.EFFDT = B.EFFDT AND B.BENEFIT_PLAN > ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
Prompt Table: BEN_DEFN_PGM