PNLGRPNAMERECNAMEDTTM_CREATED1=New
2=Delete
3=Change Key
4=Change Attribute
00=Error
10=Unexpanded
20=Expanded
30=Triggers Generated
GP_MT_TRIGGER(SQL Table) |
Index Back |
|---|---|
Mass Trigger EventsThis record serves for storing the mass trigger events. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | DTTM_CREATED |
DateTime(26) | TIMESTAMP | Datetime Created |
| 4 | GP_MT_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Action causing a Mass Trigger to be created
1=New 2=Delete 3=Change Key 4=Change Attribute |
| 5 | GP_MT_EVT_STAT | Character(2) | VARCHAR2(2) NOT NULL |
Status of a Mass Trigger Event
00=Error 10=Unexpanded 20=Expanded 30=Triggers Generated |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |