CNTRCT_FUND_FRA

(SQL Table)
 Index Back

Pension/Contingency Contracts

  • Related Language Record: CNTRT_FND_F_LNG

  • Parent Record Of CPNY_CNTRCT_FRA ESTB_CNTRCT_FRA POPC_CNTRCT_FRA

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 FUND_INST_FRA Character(4) VARCHAR2(4) NOT NULL Fund Institution Number

    Prompt Table: FUND_INST_FRA

    7 MEMBERSHIP_DT_FRA Date(10) DATE Membership Date

    Default Value: %date

    8 MEMBERSHIP_IND_FRA Character(1) VARCHAR2(1) NOT NULL Membership Indicator - France
    M=Mandatory
    O=Optional

    Default Value: M

    9 COMMENTS Long Character CLOB Comment