PY_MOD_BNPRGLVW (SQL View)	Index Back
Rel. Lang. for PY_MOD_BNPRG_VW Active Benefit Program View

PY_MOD_BNPRGLVW

(SQL View)

Rel. Lang. for PY_MOD_BNPRG_VW

Active Benefit Program View

SELECT DISTINCT A.BENEFIT_PROGRAM , B.LANGUAGE_CD , B.DESCR FROM PS_BEN_DEFN_PGM A , PS_BENEF_PGM_LANG B WHERE A.BENEFIT_PROGRAM = B.BENEFIT_PROGRAM AND A.EFFDT = B.EFFDT AND A.EFF_STATUS = 'A'

Related Language Record for PY_MOD_BNPRG_VW

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description