SSR_APT_REQUEST_IDMESSAGE_SEQM=Message Catalog
T=Text Catalog
C=Cancel
E=Error
M=Message
W=Warning
SSR_APT_REQ_LOG(SQL Table) |
Index Back |
|---|---|
APT Request LogAPT Request Log |
| # | 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 | MSG_SEVERITY | Character(1) | VARCHAR2(1) NOT NULL |
Message Severity
C=Cancel E=Error M=Message W=Warning |
| 7 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 8 | HR_SSTEXT_SUB_ID | Character(4) | VARCHAR2(4) NOT NULL | The Sub ID is field that is optionally used to further partition Text Catalog entries within an Object Owner ID. For example, we might want to create a Sub ID to keep Text Catalog entries for Enrollment separate from the Text Catalog entries for the inquiry pages within the eBenefits ObjectOwnerId. |
| 9 | TEXT_ID | Character(18) | VARCHAR2(18) NOT NULL | Text ID |