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'
1=1-High
2=2-Medium
3=3-Low
WM_INALT_EFF_VW(SQL View) |
Index Back |
|---|---|
Inspect Alert Msg Eff ViewInspection Alert Message Effective View |
| SELECT SETID , WO_INSP_ALERT_ID , WO_INSP_ALERT_TYPE , DESCR50 , WL_PRIORITY , WL_SUBJECT FROM PS_WM_INSP_ALT_HDR WHERE EFF_STATUS = 'A' |
| # | 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 | WL_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Worklist Priority
1=1-High 2=2-Medium 3=3-Low |
| 6 | WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |