EXT_ORG_PRI_VW

(SQL View)
Index Back

External Org Primary View

External organization with an outer join to it's primary location.

SELECT A.EXT_ORG_ID , A.EFFDT , A.EFF_STATUS , A.OTH_NAME_SORT_SRCH , A.EXT_ORG_TYPE , %subrec(ADDRESS_NPC_SBR, B) , A.DESCR , A.DESCR50 , A.DESCRSHORT , A.ORG_CONTACT , A.ORG_LOCATION , A.ORG_DEPARTMENT , A.PROPRIETORSHIP , A.SETID , A.VENDOR_ID , A.TAXPAYER_ID_NO FROM PS_EXT_ORG_TBL A LEFT OUTER JOIN PS_ORG_LOC_ASOF B ON A.EXT_ORG_ID = B.EXT_ORG_ID AND A.ORG_LOCATION = B.ORG_LOCATION

  • Related Language Record: EXT_ORG_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name
    5 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

    Prompt Table: SCC_ORG_TYP_TBL

    6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: OPR_DEF_TBL_HR.COUNTRY

    Prompt Table: COUNTRY_TBL

    7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    13 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    14 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    15 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    16 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    17 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    18 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    19 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    21 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    22 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
    23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    24 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    25 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    26 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr

    Prompt Table: ORG_CONTACT

    27 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr

    Prompt Table: ORG_LOCATION

    28 ORG_DEPARTMENT Number(3,0) SMALLINT NOT NULL Department Nbr

    Prompt Table: ORG_DEPT

    29 PROPRIETORSHIP Character(4) VARCHAR2(4) NOT NULL Proprietorship
    OTHR=Other
    PRIV=Private
    PUBL=Public
    RELG=Religious
    30 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    31 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    32 TAXPAYER_ID_NO Character(9) VARCHAR2(9) NOT NULL Taxpayer ID Number