AVRELATEEPVWLNG

(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 is below. SELECT ORG_RELATE_NBR , EXT_ORG_ID , ORG_RELATION , EXT_ORG_ID_RELATED , ORG_RELATE_RCP , ORG_RELATE_NBR_RCP , 'xx' , ' ' , ' ' , 'O' , ' ' , DESCR , COUNTRY , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , NUM1 , NUM2 , HOUSE_TYPE , COUNTY , STATE , POSTAL , GEO_CODE , IN_CITY_LIMIT , PHONE_DAY , PHONE_EVE , PHONE_FAX , EMAILID , URL_ADDRESS , BEGIN_DT , END_DT , SRC_DESCR , COMMENTS FROM PS_AV_RELATE_E ========================================================

SELECT A.ORG_RELATE_NBR , A.EXT_ORG_ID , A.LANGUAGE_CD , A.DESCR , A.SRC_DESCR FROM PS_AVRELATEELNG A

  • Related Language Record for AV_RELATE_EP_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