POPC_CNTRCT_FRA

(SQL Table)
 Index Back

Contracts Population Category

  • Parent record: CNTRCT_FUND_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 POPULATION_CTG_FRA Character(3) VARCHAR2(3) NOT NULL Population Category - FRA

    Prompt Table: POP_CTG_FRA_TBL

    4 BASE_CALC_TYPE_FRA Character(2) VARCHAR2(2) NOT NULL Bse Calculation Type - France
    00=Other
    01=Ceiling A or 1
    02=Ceiling 2
    03=Ceiling 1+2
    04=Ceiling B
    05=B-Ceiling Isolated Sums
    06=Ceiling B + B Ceiling Isolated
    07=C-Ceiling
    08=C-Ceiling Isolated Sums
    09=Ceiling C + C Ceiling Isolated
    10=CET
    11=C-Ceiling Lump-sum
    12=GMP
    13=Lump-Sum Basis
    14=Guaranty
    15=Social Security Ceiling
    16=Total Salary
    17=Ceiling 4
    18=SMIC
    19=Ceiling B+C
    20=APEC Lump-Sum
    21=GMP Lump-Sum
    31=T1 AGFF
    32=T2 AGFF
    34=TB AGFF
    35=SITB AGFF
    36=Ceiling B + SITB AGFF
    37=Lump Sum Amount
    5 DCL_POP_CTG_FRA Character(3) VARCHAR2(3) NOT NULL Declared Population - France
    6 EE_RATE_FRA Number(7,3) DECIMAL(6,3) NOT NULL Entry Rate - France
    7 ER_RATE_FRA Number(7,3) DECIMAL(6,3) NOT NULL Employee Rate - France
    8 FORMULA_PIN_FRA Number(8,0) INTEGER NOT NULL Formula Name - France

    Prompt Table: %GP_EDIT_FLD1

    9 CODE_OPT_FRA Character(30) VARCHAR2(30) NOT NULL Code Option FRA
    10 SQL_FILTER_FRA Long Character CLOB SQL Filter