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
1=1-High
2=2-Medium
3=3-Low
WM_INALT_UPD_VW(SQL View) |
Index Back |
|---|---|
Inspect Alert Msg UpdtSrch VwInspection Alert Message Update-Search View |
| SELECT SETID , WO_INSP_ALERT_ID , WO_INSP_ALERT_TYPE , DESCR50 , EFF_STATUS , WL_PRIORITY , WL_SUBJECT FROM PS_WM_INSP_ALT_HDR |
| # | 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_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Worklist Priority
1=1-High 2=2-Medium 3=3-Low |
| 7 | WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |