HRS_EXTSRCH_VW

(SQL View)
Index Back

External Search Suppliers

Search view to return active external resume search suppliers

SELECT A.MERCHANTID ,A.EFFDT ,A.DESCR ,A.DESCRSHORT ,A.MERCHINSTALLED ,A.MRCHUIDTYPE ,A.COMPANYID ,A.CMPAUTHNTCTNTOKEN ,A.MERCHWSITEURL ,A.MRCHIMAGENAME ,%Substring(C.MRCHAPPATTRVALUE,1,1) FROM PSMERCHANTID A , PSMERCHANTCAT B , PSMERCHANTAPP C WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PSMERCHANTID WHERE MERCHANTID = A.MERCHANTID AND EFFDT <= %CurrentDateIn) AND A.MERCHANTID = B.MERCHANTID AND A.EFFDT = B.EFFDT AND B.MERCHANTCAT = 'EXT_SRCH' AND A.MERCHINSTALLED = 'Y' AND A.MERCHANTID = C.MERCHANTID AND A.EFFDT = C.EFFDT AND C.MRCHAPPATTRNAME = 'PREFERRED_SUPPLIER'

  • Related Language Record: PSMERCHANTIDLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 MERCHINSTALLED Character(1) VARCHAR2(1) NOT NULL Merchant Enabled

    Y/N Table Edit

    6 MRCHUIDTYPE Character(3) VARCHAR2(3) NOT NULL Merchant User ID Type
    CID=Company Identifier
    EID=Employee ID + Company ID
    EML=EMail Address
    OID=Operator ID + Company ID
    7 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
    8 CMPAUTHNTCTNTOKEN Character(64) VARCHAR2(64) NOT NULL Company Authentication Token
    9 MERCHWSITEURL Character(254) VARCHAR2(254) NOT NULL Merchant Website URL
    10 MRCHIMAGENAME Character(30) VARCHAR2(30) NOT NULL Merchant Logo
    11 PREFERRED_SUPPLIER Character(1) VARCHAR2(1) NOT NULL Preferred Supplier
    N=No
    Y=Yes