VNDR_CNTCT_P_VW

(SQL View)
 Index Back

Supplier Contact Telephone Nbr

Supplier Contact Telephone Nbrs

SELECT SETID , VENDOR_ID , EFFDT , PHONE_TYPE , COUNTRY_CODE , PHONE , CASE WHEN COUNTRY_CODE = ' ' THEN PHONE ELSE COUNTRY_CODE %Concat '-' %Concat PHONE END FROM PS_VNDR_CNTCT_PHN P WHERE EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_VNDR_CNTCT_PHN Z WHERE P.SETID = Z.SETID AND P.VENDOR_ID = Z.VENDOR_ID AND P.CNTCT_SEQ_NUM = Z.CNTCT_SEQ_NUM AND Z.EFFDT <=%CurrentDateIn) AND PHONE_TYPE NOT IN ('FAX','PGR2','PGR1','TELX')

  • Parent record: VENDOR_CNTCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
    BUSN=Business Phone
    CAMP=Campus Phone
    CELL=Cellular Phone
    DORM=Dormitory Phone
    FAX=FAX
    HOME=Home Phone
    MAIN=Main
    OTR=Other
    PGR1=Pager 1
    PGR2=Pager 2
    TELX=Telex

    Default Value: BUSN

    5 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
    6 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    7 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description