POP_CTG_EEFRA_V

(SQL View)
 Index Back

Population Category View

Population Category View for Contingency

SELECT P.POPULATION_CTG_FRA , P.DESCR FROM PS_POP_CTG_FRA_TBL P WHERE EXISTS( SELECT 'X' FROM PS_POPC_CNTRCT_FRA C , PS_CNTRCT_FUND_FRA CF WHERE C.POPULATION_CTG_FRA = P.POPULATION_CTG_FRA AND C.MEMBERSHIP_NBR_FRA = CF.MEMBERSHIP_NBR_FRA AND C.EFFDT = CF.EFFDT)

  • Related Language Record: POP_CTG_EEV_LNG

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