GPCH_CA_SRCH

(SQL View)
 Index Back

Child Allowance Search

Child Allowance Search

SELECT a.gpch_ca_rates_id , a.gpch_tx_canton , b.descr FROM PS_GPCH_CA_STAT_S1 a , PS_STATE_TBL b WHERE b.state = a.gpch_tx_canton AND b.country = 'CHE'

  • Related Language Record: GPCH_CA_SRCH_LN

    • # 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