GPCH_CA_RATES_IDGPCH_TX_CANTONPrompt Table: GPCH_SI_STCD_VW
EFFDTDefault Value: %date
SEQNUMGPCH_CA_CHILD_MINDefault Value: 1
Default Value: CHF
Prompt Table: CURRENCY_CD_TBL
GPCH_CA_STAT_S2(SQL Table) |
Index Back |
|---|---|
Child Allowance Detail TableRules for Children allowances for each Canton, including part-time rules and single,part-time rules. |
| # | 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 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | GPCH_CA_CHILD_MIN |
Number(2,0) | SMALLINT NOT NULL |
Minimum Number of Children
Default Value: 1 |
| 6 | GPCH_CA_AMOUNT | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Child Allowance 1 |
| 7 | GPCH_CA_AMOUNT2 | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Child Allowance 2 |
| 8 | GPCH_EDU_AMOUNT | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Education Allowance |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CHF Prompt Table: CURRENCY_CD_TBL |