SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
WO_INSP_ALERT_IDE1=Eval Trigger - Result 'True'
E2=Eval Trigger - Result 'Error'
A=Active
I=Inactive
Default Value: A
Prompt Table: WL_TEMPLATE_GEN
1=1-High
2=2-Medium
3=3-Low
WM_INSP_ALT_HDR(SQL Table) |
Index Back |
|---|---|
Inspection Alert Msg Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | WO_INSP_ALERT_ID |
Character(25) | VARCHAR2(25) NOT NULL | WO Inspection Alert ID |
| 3 | WO_INSP_ALERT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
WO Inspection Alert Type
E1=Eval Trigger - Result 'True' E2=Eval Trigger - Result 'Error' |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | WL_TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Template Name
Prompt Table: WL_TEMPLATE_GEN |
| 7 | WL_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Worklist Priority
1=1-High 2=2-Medium 3=3-Low |
| 8 | WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 9 | COMMENTS | Long Character | CLOB | Comment |