GPCH_CA_STAT_S1

(SQL Table)
 Index Back

Children Allowance Header

Rules for Family allowances (Children, Education, and Household) for each Canton, including part-time rules and single,part-time rules.

  • Parent Record Of GPCH_CA_STAT_S2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPCH_CA_RATES_ID Character(3) VARCHAR2(3) NOT NULL Family Allowance ID
    2 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton

    Prompt Table: GPCH_SI_STCD_VW

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 GPCH_CA_HH_AMOUNT Signed Number(14,2) DECIMAL(12,2) NOT NULL Household Amount - Canton Jura
    6 GPCH_CA_FT_RULE Character(1) VARCHAR2(1) NOT NULL Full Time Rule
    0=Paid by Canton
    1=Age Based
    2=Number of Children Based
    3=Maximum Number

    Default Value: 1

    7 GPCH_CA_PT_RULE Character(1) VARCHAR2(1) NOT NULL Part Time Rule
    0=Paid by Canton
    1=Hours/Divisor
    2=Factor Hours/Amount
    3=Factor Hours/Divisor
    4=Work Hours (only NW)
    5=Hours/Factor
    U=Bank Rules

    Default Value: 1

    8 GPCH_CA_PT_LIM_MIN Number(7,3) DECIMAL(6,3) NOT NULL Minimum Hours Limit
    9 GPCH_CA_PT_LIM_MAX Number(6,2) DECIMAL(5,2) NOT NULL Maximum Limit/Factor
    10 GPCH_CA_PT_VALUE Number(7,3) DECIMAL(6,3) NOT NULL Hourly Rate or Divisor
    11 GPCH_CA_SPT_RULE Character(1) VARCHAR2(1) NOT NULL Single Parent Part Time Rule
    0=Paid by Canton
    1=Divisor and Limited Hours
    2=Amount/Factor Hours
    3=Divisor/Factor Hours
    4=Work Hours (only NW)
    5=Amount/Limit
    6=Full Amount (JU)
    U=Bank Rules

    Default Value: 1

    12 GPCH_CA_SPT_LIM_MN Number(7,3) DECIMAL(6,3) NOT NULL Minimum Hours Limit
    13 GPCH_CA_SPT_LIM_MX Number(7,3) DECIMAL(6,3) NOT NULL Maximum Limit/Factor
    14 GPCH_CA_SPT_VALUE Number(7,3) DECIMAL(6,3) NOT NULL Hourly Rate or Divisor
    15 GPCH_CA_BIRTH_AMT Number(9,2) DECIMAL(8,2) NOT NULL Birth Allowance Amount
    16 GPCH_CA_ADOP_AMT Number(9,2) DECIMAL(8,2) NOT NULL Adoption Allowance Amount
    17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CHF

    Prompt Table: CURRENCY_CD_TBL

    18 GPCH_CA_BIRTH_PT Character(1) VARCHAR2(1) NOT NULL Birth Allowance % Method
    1=Full Amount
    2=Limited Amount
    3=Full or None
    19 GPCH_CA_AGE_MAX Number(2,0) SMALLINT NOT NULL CA Age Maximum 1
    20 GPCH_CA_AGE_MAX2 Number(2,0) SMALLINT NOT NULL CA Age Maximum 2
    21 GPCH_DIS_AGE_MAX Number(2,0) SMALLINT NOT NULL Disabled Age Maximum
    22 GPCH_EDU_AGE_MAX Number(2,0) SMALLINT NOT NULL Education Age Maximum