POP_CTG_EEV_LNG

(SQL View)
 Index Back

SELECT P.POPULATION_CTG_FRA ,P.LANGUAGE_CD , P.DESCR FROM PS_POP_CTG_FRA_LNG 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 for POP_CTG_EEFRA_V

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