EQUATION_NAMEEFFDTPROCESS_INSTANCEMESSAGE_SEQPARM_SEQEQTN_MSGPARM_VW(SQL View) |
Index Back |
|---|---|
Equation Runtime MessagesEquation Processor Runtime Instance Messages |
| SELECT A.EQUATION_NAME ,A.EFFDT ,A.PROCESS_INSTANCE ,A.MESSAGE_SEQ ,B.PARM_SEQ ,B.MESSAGE_PARM FROM PS_EQTN_MSGINFO_VW A , PS_MESSAGE_LOGPARM B WHERE A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND A.MESSAGE_SEQ = B.MESSAGE_SEQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EQUATION_NAME |
Character(12) | VARCHAR2(12) NOT NULL | Equation Name |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | MESSAGE_SEQ |
Number(9,0) | DECIMAL(9) NOT NULL | Message Sequence |
| 5 | PARM_SEQ |
Number(3,0) | SMALLINT NOT NULL | Message Parameter Sequence |
| 6 | MESSAGE_PARM | Character(254) | VARCHAR2(254) NOT NULL | Message Parameter Text |