SETIDMESSAGE_CDCUST_MSG_FSS_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID , A.MESSAGE_CD FROM PS_MESSAGE_TBL A WHERE A.SANCTION_MATCH_FLG = 'Y' AND A.EFF_STATUS = 'A' AND %EffdtCheck(MESSAGE_TBL, A, %CURRENTDATEIN) |
| # | 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 |