WM_WO_INSPL_EVL

(SQL Table)
 Index Back

Insp Plan Activity Evaluate

  • Parent record: WM_WO_INSPL_ACT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: WM_WO_INSPL_ACT.SETID

    Prompt Table: SP_SETID_NONVW

    2 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID

    Default Value: WM_WO_INSPL_ACT.WO_TEMPLATE_ID

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: WM_WO_INSPL_ACT.EFFDT

    4 INSP_ACTIVITY_NBR Number(5,0) INTEGER NOT NULL Activity Number

    Default Value: WM_WO_INSPL_ACT.INSP_ACTIVITY_NBR

    5 INSP_STEP_NBR Number(5,0) INTEGER NOT NULL Step Number

    Default Value: 1

    6 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long
    7 INSPECTION_CODE Character(20) VARCHAR2(20) NOT NULL Trigger Condition

    Prompt Table: WM_WO_IPCLC_DVW

    8 EVAL_BREAK_FLG Character(1) VARCHAR2(1) NOT NULL Halt Further Evaluation
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    9 INSP_RSLT_STAT_CD Character(20) VARCHAR2(20) NOT NULL Result Status Code

    Prompt Table: WM_WO_IPOBS_DVW

    10 INSP_RSLT_STAT_VAL Character(10) VARCHAR2(10) NOT NULL Result Status Value

    Prompt Table: WM_WO_IPRSVL_VW

    11 EVAL_WRK_RESP_OPTN Character(1) VARCHAR2(1) NOT NULL Work Response Option
    0=None
    1=Create Service Request
    2=Create Work Order
    3=Schedule 1-Time PM

    Default Value: 0

    12 EVAL_WRK_RESP_TYPE Character(2) VARCHAR2(2) NOT NULL Work Response Type
    00=None
    11=Agent Service Request
    12=Service Request (1-Page)
    21=Work Order (Regular)
    22=Express Work Order
    31=Asset Schedule
    32=Maintenance Loop Schedule
    33=Location Schedule

    Default Value: 00

    13 WR_PRIORITY Character(1) VARCHAR2(1) NOT NULL Service Request Priority
    1=1-Critical
    2=2-Urgent
    3=3-Standard
    4=4-Low
    14 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

    Prompt Table: WM_WO_IPPRB_DVW

    15 WR_SUBJECT Character(60) VARCHAR2(60) NOT NULL Subject
    16 DESCRLONG Long Character CLOB Long Description
    17 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

    Prompt Table: WM_WO_TYPE

    18 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

    Prompt Table: WM_PRIORITY

    19 WO_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
    1=Pre-Approved
    3=Workflow Approval
    20 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    21 CAUSE_CD Character(15) VARCHAR2(15) NOT NULL Cause Code

    Prompt Table: WM_PCR_CSEAC_VW

    22 RESOLUTION_CD Character(15) VARCHAR2(15) NOT NULL Resolution code

    Prompt Table: WM_PCR_RESAC_VW

    23 PM_SCHD_TYPE Character(1) VARCHAR2(1) NOT NULL PM Schedule Type
    1=Asset
    2=Maintenance Loop
    3=Location
    24 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

    Default Value: OPR_DEF_TBL_WM.SRVC_GRP_ID

    Prompt Table: WM_SRVC_GRP

    25 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

    Prompt Table: WM_MNTTP_EFF_VW

    26 WO_JOB_TMPLT_ID Character(25) VARCHAR2(25) NOT NULL WO Job Template ID (specific field)

    Prompt Table: WM_WO_JTMPL_DVW

    27 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

    Prompt Table: WM_PCR_CLSF_DVW

    28 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code

    Prompt Table: WM_PCR_PRBAC_VW

    29 EVAL_ALRT_MSG_OPTN Character(1) VARCHAR2(1) NOT NULL Alert Message Option
    0=None
    1=Evaluate 'True' (only)
    2=Evaluate 'Error' (only)
    3=Both ('True', 'Error')

    Default Value: 0

    30 EVAL_ALERT_TRGR_E1 Character(25) VARCHAR2(25) NOT NULL Trigger Alert - Result 'True'

    Prompt Table: WM_INALT_EFF_DV

    31 EVAL_ALERT_TRGR_E2 Character(25) VARCHAR2(25) NOT NULL Trigger Alert - Result 'Error'

    Prompt Table: WM_INALT_EFF_DV