MERCHANTIDSI_SUP_JOBBOARD(SQL View) |
Index Back |
|---|
| SELECT MI.MERCHANTID , MI.DESCR , MI.DESCRSHORT FROM PSMERCHANTID MI WHERE MI.EFFDT = ( SELECT MAX(MI2.EFFDT) FROM PSMERCHANTID MI2 WHERE MI.MERCHANTID = MI2.MERCHANTID AND MI2.EFFDT <= %CurrentDateIn) AND MI.MERCHINSTALLED = 'Y' AND EXISTS ( SELECT 'X' FROM PSMERCHANTCAT MC WHERE MC.MERCHANTID = MI.MERCHANTID AND MC.EFFDT = MI.EFFDT AND MC.MERCHANTCAT = 'JOBBOARD') AND MI.MERCHANTID <> 'RECRUITUSA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MERCHANTID |
Character(30) | VARCHAR2(30) NOT NULL | Merchant ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |