EXTORGPRSVWLNG

(SQL View)
 Index Back

External Org Search View

This search view is used to include the city, state, and country address fields as alternate search keys. It was created to be used on external organization summary panels.

SELECT A.EXT_ORG_ID ,A.LANGUAGE_CD ,A.DESCR FROM PS_EXT_ORG_LANG A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EXT_ORG_LANG A1 WHERE A.EXT_ORG_ID = A1.EXT_ORG_ID AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record for EXT_ORG_PRS_VW

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

    Default Value: 0

    Prompt Table: EXT_ORG_TBL

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description