HRS_DM_VERITY_3

(SQL View)
 Index Back

Datamapping Verity

Search through the alternate langauge key data

SELECT A.HRS_DM_CAT_ID , A.HRS_DM_SUBCAT , A.HRS_DM_KEY_ID , B.LANGUAGE_CD , B.HRS_DM_DESCR FROM PS_HRS_DM_KEY A , PS_HRS_DM_KEY_LNG B WHERE A.HRS_DM_KEY_ID=B.HRS_DM_KEY_ID

  • Parent record: HRS_DM_VERITY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_DM_CAT_ID Number(15,0) DECIMAL(15) NOT NULL Data Mapping Category ID

    Prompt Table: HRS_DM_CAT

    2 HRS_DM_SUBCAT Character(50) VARCHAR2(50) NOT NULL SubCategory
    3 HRS_DM_KEY_ID Number(15,0) DECIMAL(15) NOT NULL Data Mapping Key ID
    4 HRS_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    MAY=Bhasa Malay
    POL=Polish
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    5 HRS_DM_DESCR Character(254) VARCHAR2(254) NOT NULL Data Mapping Object Description