CODE_OPT_VW

(SQL View)
 Index Back

Code Option View

Code Option View

SELECT C.POPULATION_CTG_FRA , C.CODE_OPT_FRA FROM PS_POPC_CNTRCT_FRA C , PS_CNTRCT_FUND_FRA CF WHERE C.MEMBERSHIP_NBR_FRA = CF.MEMBERSHIP_NBR_FRA AND C.EFFDT = CF.EFFDT AND CODE_OPT_FRA<>' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 POPULATION_CTG_FRA Character(3) VARCHAR2(3) NOT NULL Population Category - FRA
2 CODE_OPT_FRA Character(30) VARCHAR2(30) NOT NULL Code Option FRA