AVRELATEE2VWLNG

(SQL View)
 Index Back

Ext Org Relationships

Use AV_RELATE_E_VW to record information about an Orgs relationship to other Organizations. ======================================================== modified on 2/16/01 for hr merge impact, old sql below. SELECT A.ORG_RELATE_NBR , A.EXT_ORG_ID , A.ORG_RELATION , B.XLATLONGNAME , A.EXT_ORG_ID_RELATED , A.ORG_RELATE_RCP , A.ORG_RELATE_NBR_RCP , A.DESCR , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.NUM1 , A.NUM2 , A.HOUSE_TYPE , A.COUNTY , A.STATE , A.POSTAL , A.GEO_CODE , A.IN_CITY_LIMIT , A.PHONE_DAY , A.PHONE_EVE , A.PHONE_FAX , A.EMAILID , A.URL_ADDRESS , A.BEGIN_DT , A.END_DT , A.SRC_DESCR , A.COMMENTS FROM PS_AV_RELATE_E A , XLATTABLE B WHERE B.FIELDNAME='ORG_RELATION' AND A.ORG_RELATION = B.FIELDVALUE ========================================================

SELECT A.ORG_RELATE_NBR , A.EXT_ORG_ID , A.LANGUAGE_CD , A.DESCR , A.SRC_DESCR FROM PS_AVRELATEELNG A ,PS_AV_RELATE_E D , PSXLATITEM B WHERE B.FIELDNAME='ORG_RELATION' AND D.ORG_RELATION = B.FIELDVALUE AND A.ORG_RELATE_NBR=D.ORG_RELATE_NBR AND A.EXT_ORG_ID=d.EXT_ORG_ID

  • Related Language Record for AV_RELATE_E2_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ORG_RELATE_NBR Character(10) VARCHAR2(10) NOT NULL Relation Nbr

    Default Value: NEW

    2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: AV_EXT_ORG_SRCH

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 SRC_DESCR Character(30) VARCHAR2(30) NOT NULL Source Description