SADBPVORGVWLNG

(SQL View)
Index Back

Table external organization

Table external organization

SELECT EXT_ORG_ID , ORG_LOCATION , EFFDT , LANGUAGE_CD , DESCR FROM PS_ORG_LOC_LANG

  • Related Language Record for SAD_BPV_ORG_VW
  • # 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 EFFDT Date(10) DATE Effective Date
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description