SETIDMESSAGE_CDOPRIDAR_HOLD_CD_VW(SQL View) |
Index Back |
|---|---|
Credit Hold Codes |
| SELECT DISTINCT B.SETID , B.MESSAGE_CD , D.OPRID , B.HOLD_CD , B.DESCR FROM PS_MESSAGE_TBL B , PS_SET_CNTRL_REC C , PS_MSGHOLD_SEC_VW D WHERE C.RECNAME='MESSAGE_TBL' AND C.SETCNTRLVALUE=B.SETID AND B.SETID = C.SETID AND B.MESSAGE_CD_TYPE = '01' AND B.MESSAGE_ACTION = 'H' AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_MESSAGE_TBL BE WHERE BE.SETID = B.SETID AND BE.MESSAGE_CD = B.MESSAGE_CD AND BE.EFFDT <= %CurrentDateIn ) AND D.SETID = B.SETID AND D.MESSAGE_CD=B.MESSAGE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | MESSAGE_CD |
Character(6) | VARCHAR2(6) NOT NULL | Message Code |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL | Hold Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |