LM_TRNG_R_STA_V

(SQL View)
 Index Back

Traning Region - State

State - Training Region Mapping

SELECT A.LM_TRNG_CD , A.COUNTRY , A.STATE FROM PS_LM_TRNG_REG_STA A , PS_LM_TRNG_REG_VW B WHERE A.LM_TRNG_CD = B.LM_TRNG_CD AND A.COUNTRY = B.COUNTRY

  • Parent record: LM_TRNG_REG_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_TRNG_CD Character(30) VARCHAR2(30) NOT NULL Description
    2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    3 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: LM_STATE_VW2