ORG_LOC_ASOFLNG

(SQL View)
Index Back

Organization Location Table

Organizaiton Location As Of Related Language Record.

SELECT A.EXT_ORG_ID , A.ORG_LOCATION , B.LANGUAGE_CD , A.DESCR , A.DESCRSHORT FROM PS_ORG_LOCATION A , PS_ORG_LOC_LANG B WHERE A.EXT_ORG_ID = B.EXT_ORG_ID AND A.ORG_LOCATION = B.ORG_LOCATION AND %EffdtCheck(ORG_LOCATION A1, A, %CurrentDateIn) AND A.EFFDT = B.EFFDT

  • Related Language Record for ORG_LOC_ASOF
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    2 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description