SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
INSP_RSLT_STAT_CDPrompt Table: WM_WO_IPOBS_DVW
INSP_RSLT_STAT_VALPrompt Table: WM_INSP_OBS_CDL
WM_WO_IPRSVL_VW(SQL View) |
Index Back |
|---|---|
Insp Plan Status Rslt Value Vw |
| SELECT SETID , INSPECTION_CODE AS INSP_RSLT_STAT_CD , INSP_OBSRVN_CODE AS INSP_RLST_STAT_VAL , OBSRVN_CODE_RANK FROM PS_WM_INSP_OBS_CDL |
| # | 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 | INSP_RSLT_STAT_CD |
Character(20) | VARCHAR2(20) NOT NULL |
Result Status Code
Prompt Table: WM_WO_IPOBS_DVW |
| 3 | INSP_RSLT_STAT_VAL |
Character(10) | VARCHAR2(10) NOT NULL |
Result Status Value
Prompt Table: WM_INSP_OBS_CDL |
| 4 | OBSRVN_CODE_RANK | Number(2,0) | SMALLINT NOT NULL | Observation Code Rank |