PORTAL_NAMEPORTAL_OBJNAMEEVENT_NAMEHTML_FIELD_NAMEP=Publish
S=Subscribe
T=Server Event Sub
C=Change
F=Full Refresh
L=Click
P=Partial Refresh
PSMSGEVENTS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PORTAL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 2 | PORTAL_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 3 | EVENT_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Event Name |
| 4 | HTML_FIELD_NAME |
Character(65) | VARCHAR2(65) NOT NULL | HTML Field Name |
| 5 | MSG_EVENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Message Event Type
P=Publish S=Subscribe T=Server Event Sub |
| 6 | MSG_EVENT_DATA | Character(254) | VARCHAR2(254) NOT NULL | Message Data |
| 7 | FIELD_EVENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Field Event Type
C=Change F=Full Refresh L=Click P=Partial Refresh |
| 8 | MSG_EVENT_DATALONG | Long Character | CLOB | Message Data |