SSR_APT_REQUEST_IDM=Message Catalog
T=Text Catalog
SSR_APT_LOG_VW(SQL View) |
Index Back |
|---|---|
APT Request Log and Param ViewView of APT Request message log entries and their parameters |
| SELECT A.SSR_APT_REQUEST_ID , A.MESSAGE_SEQ , A.SSR_MSGTYPE , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.TEXT_ID , B.PARM_SEQ , B.SA_MESSAGE_PARM FROM %Table(SSR_APT_REQ_LOG) A , %Table(SSR_APT_REQ_PRM) B WHERE %Join(COMMON_KEYS, SSR_APT_REQ_LOG A, SSR_APT_REQ_PRM B) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_APT_REQUEST_ID |
Character(12) | VARCHAR2(12) NOT NULL | APT Request ID |
| 2 | MESSAGE_SEQ | Number(9,0) | DECIMAL(9) NOT NULL | Message Sequence |
| 3 | SSR_MSGTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Message type
M=Message Catalog T=Text Catalog |
| 4 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 5 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 6 | TEXT_ID | Character(18) | VARCHAR2(18) NOT NULL | Text ID |
| 7 | PARM_SEQ | Number(3,0) | SMALLINT NOT NULL | Message Parameter Sequence |
| 8 | SA_MESSAGE_PARM | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter Text |