GPCH_CA_RATES_IDGPCH_TX_CANTONPrompt Table: GPCH_SI_STCD_VW
DESCRLANGUAGE_CDGPCH_CA_SRCH_LN(SQL View) |
Index Back |
|---|---|
Child Allowance SearchChild Allowance Search |
| SELECT a.gpch_ca_rates_id , a.gpch_tx_canton , b.descr ,b.language_cd FROM PS_GPCH_CA_STAT_S1 a , PS_STATE_TBL_LANG b WHERE b.state = a.gpch_tx_canton AND b.country = 'CHE' |
| # | 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 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |