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 OPS_COMP_DTL OPS_ESTAB_DTL OPS_ESTAB_IMP OPS_ESTAB_IMP_W OPS_NODE_DTL 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 OPS_TYPE_FRA Character(10) VARCHAR2(10) NOT NULL OPSType (FRA)

    Prompt Table: OPS_CTYPE_VW

    7 FUND_INST_FRA Character(4) VARCHAR2(4) NOT NULL Fund Institution Number
    8 FUND_INST_VAL_FRA Character(20) VARCHAR2(20) NOT NULL Deligate instutiion ID

    Prompt Table: OPS_FUND_INST_V

    9 OPS_DLG_TYPE_FRA Character(10) VARCHAR2(10) NOT NULL Delegate Code (FRA)

    Prompt Table: OPSDLG_TYPE_VW

    10 FUND_DELG_VAL_FRA Character(20) VARCHAR2(20) NOT NULL Deligate instutiion ID

    Prompt Table: FUND_DLGVAL_VW

    11 REPORT_ON_DSN Character(1) VARCHAR2(1) NOT NULL Report on DSN?

    Y/N Table Edit

    12 MEMBERSHIP_DT_FRA Date(10) DATE Membership Date

    Default Value: %date

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

    Default Value: M

    14 COMMENTS Long Character CLOB Comment
    15 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence