PTAFAW_TXN_LVL(SQL Table) |
Index Back |
|---|---|
Approval Transaction LevelsDefines the approval levels the transaction supports. Some application transactions only support Header level. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID | |
| 2 | Number(1,0) | SMALLINT NOT NULL |
Level e.g. Header = 0, Line = 1.
0=Header 1=Line |
|
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | WL_TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL | Template Name |