GPCH_CA_DATA2

(SQL Table)
Index Back

Child Allowance CHE

Child Allowance CHE

  • Parent Record Of GPCH_CA_XML_ALL GPCH_CA_XML_BEN GPCH_CA_XML_DEP GPCH_CA_XML_STR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
    01=default

    Prompt Table: GPCH_CA_DATA_VW

    5 GPCH_CA_RELATION Character(2) VARCHAR2(2) NOT NULL Field for Family Relationship.
    10=Mother
    11=Stepmother
    12=FosterMother
    13=Sister
    14=GrandMother
    20=Father
    21=Stepfather
    22=FosterFather
    23=Brother
    24=Grandfather
    6 BIRTHDATE Date(10) DATE Date of Birth
    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 STUDENT Character(1) VARCHAR2(1) NOT NULL Student
    N=No
    Y=Yes

    Y/N Table Edit

    9 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

    Y/N Table Edit

    10 GPCH_CA_EDU_END_DT Date(10) DATE Reduced End Date
    11 GPCH_CA_CA_ELIG Character(1) VARCHAR2(1) NOT NULL Child Allowance

    Y/N Table Edit

    Default Value: Y

    12 GPCH_CA_LEGAL_END Date(10) DATE Legal End Date
    13 GPCH_CA_RED_BGN_DT Date(10) DATE Reducded Begin Date
    14 GPCH_CA_BIRTH_CD Character(1) VARCHAR2(1) NOT NULL Birth Allowance Type
    1=Voluntary
    2=Birth Statutory
    3=Adoption Statutory
    15 GPCH_CA_BIRTH_PYDT Date(10) DATE Birth Allowance Date
    16 GPCH_CA_FOREIGNER Character(1) VARCHAR2(1) NOT NULL Child lives not in Switzerland

    Y/N Table Edit

    17 GPCH_CA_BALL_PCT Number(3,1) DECIMAL(2,1) NOT NULL Birth Allowance Factor
    18 GPCH_CA_FOR_AMOUNT Number(9,2) DECIMAL(8,2) NOT NULL CA granted in foreign country
    19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    20 GPCH_CA_PCT Number(6,3) DECIMAL(5,3) NOT NULL Percent
    21 GPCH_CA_TYPE Number(2,0) SMALLINT NOT NULL Field to store Allowance Type.
    22 GPCH_CA_CR_BGN Date(10) DATE Reduced End Date
    23 GPCH_CA_CR_END Date(10) DATE Reduced End Date
    24 GPCH_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL Pay Year
    25 GPCH_CA_CR_STORNO Character(2) VARCHAR2(2) NOT NULL Reduced End Date
    26 EXCLUDE Character(1) VARCHAR2(1) NOT NULL Exclude

    Y/N Table Edit

    27 GPCH_CA_NUMEROUS Character(1) VARCHAR2(1) NOT NULL Numerous flag

    Y/N Table Edit

    Default Value: N

    28 GPCH_CA_RIGHTS Number(9,2) DECIMAL(8,2) NOT NULL CA granted in foreign country