AVRELATEEVWLNG

(SQL View)
 Index Back

Ext Org Relationships

Use AV_RELATE_E_VW to record information about an Orgs relationship to other Organizations. ======================================================== modified view 2/20/01 for hr merge address_sbr impact, old sql below. I added addr_field1, 2 and 3. SELECT ORG_RELATE_NBR , EXT_ORG_ID , ORG_RELATION , EXT_ORG_ID_RELATED , ORG_RELATE_RCP , ORG_RELATE_NBR_RCP , 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 ORG_RELATE_NBR , EXT_ORG_ID ,LANGUAGE_CD , DESCR , SRC_DESCR FROM PS_AVRELATEELNG

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