HRS_EXTSRCH_VW(SQL View) |
Index Back |
---|---|
External Search SuppliersSearch 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' |
# | 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 |