RECNAMEPrompt Table: PSRECDEFN
Prompt Table: PSRECDEFN
PSTRIGGERDEFN(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 2 | AUDITRECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Audit Record Name
Prompt Table: PSRECDEFN |
| 3 | TRIGGERNAME | Character(18) | VARCHAR2(18) NOT NULL | Trigger Name |
| 4 | TR_ADD | Character(1) | VARCHAR2(1) NOT NULL | Add Trigger |
| 5 | TR_CHANGE | Character(1) | VARCHAR2(1) NOT NULL | Change Trigger |
| 6 | TR_DELETE | Character(1) | VARCHAR2(1) NOT NULL | Delete Trigger |
| 7 | TRIGGERCODE | Long Character | CLOB | Create Trigger Statement |