CT_FND_ACFR_LNG

(SQL View)
Index Back

Related View AGIRC/ARRCO


SELECT A.MEMBERSHIP_NBR_FRA , A.EFFDT , A.LANGUAGE_CD , A.DESCR50 FROM PS_CNTRT_FND_F_LNG A , PS_FUND_INST_FRA B , PS_CNTRCT_FUND_FRA D WHERE A.MEMBERSHIP_NBR_FRA=D.MEMBERSHIP_NBR_FRA AND A.EFFDT=D.EFFDT AND D.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CNTRT_FND_F_LNG WHERE MEMBERSHIP_NBR_FRA = A.MEMBERSHIP_NBR_FRA AND EFFDT <= %CurrentDateIn) AND D.FUND_INST_FRA = B.FUND_INST_FRA AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_FUND_INST_FRA WHERE FUND_INST_FRA = D.FUND_INST_FRA AND EFFDT <= A.EFFDT) AND B.EFF_STATUS = 'A' AND B.FND_INST_TYPE_FRA IN ('A', 'C')

  • Related Language Record for CT_FND_AC_FRAVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MEMBERSHIP_NBR_FRA Character(20) VARCHAR2(20) NOT NULL Membership Number - France
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50