WM_INSP_CLC_DTL

(SQL Table)
 Index Back

Inspection Calculation Detail

  • Parent record: WM_INSP_CLC_HDR

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

    Default Value: WM_INSP_CLC_HDR.SETID

    Prompt Table: SP_SETID_NONVW

    2 INSPECTION_CODE Character(20) VARCHAR2(20) NOT NULL Inspection Code

    Default Value: WM_INSP_CLC_HDR.INSPECTION_CODE

    3 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long
    4 INSP_LOGICAL_OPER Character(1) VARCHAR2(1) NOT NULL Logical Operator
    1=AND
    2=OR
    3=NOT
    4=AND NOT
    5=OR NOT
    5 INSP_LPAREN_OPT Character(1) VARCHAR2(1) NOT NULL Left-Parenthesis Option
    1=(
    2=((
    3=(((
    4=((((
    5=(((((
    6 INSP_OPERAND_TYPE Character(1) VARCHAR2(1) NOT NULL Operand Type
    1=Insp Code
    2=Constant
    3=CodeList
    4=Function

    Default Value: 1

    7 CALCLT_PARM_CODE Character(20) VARCHAR2(20) NOT NULL Calculation Parameter Code

    Prompt Table: WM_INCLC_CP_DV

    8 INSP_CONSTANT_TEXT Character(50) VARCHAR2(50) NOT NULL Constant Text
    9 INSP_FUNCTION_OPT Character(2) VARCHAR2(2) NOT NULL Function Option
    10=Collection-Based Functions
    11=%LAST - Last 'N' Entries
    12=%PREV - Previous 'N' Entries
    10 INSP_FN_ROWCNT_OPT Character(1) VARCHAR2(1) NOT NULL Row Count Option
    #=Specify (# Rows)
    *=All Rows (*)
    11 INSP_FN_ROWCNT_NBR Number(7,0) INTEGER NOT NULL Number of Rows
    12 INSP_FN_AGGREG_OPT Character(2) VARCHAR2(2) NOT NULL Aggregate/Compare Option
    10=Aggregate Options
    11=Average
    12=Count
    13=Maximum
    14=Minimum
    15=Sum
    20=Comnarison Options
    21=All
    22=Any
    13 INSP_RPAREN_OPT Character(1) VARCHAR2(1) NOT NULL Right-Parenthesis Option
    1=)
    2=))
    3=)))
    4=))))
    5=)))))
    14 INSP_BINARY_OPER Character(2) VARCHAR2(2) NOT NULL Binary Operator
    10=Arithmetic Operators
    11=Add (+)
    12=Subtract (-)
    13=Multiply (*)
    14=Divide (/)
    20=Relational Operators
    21=Equal To (=)
    22=Not Equal To (<>)
    23=Greater Than (>)
    24=Less Than (<)
    25=Greater Than or Equal To (>=)
    26=Less Than or Equal To (<=)
    27=Is a Member Of (IN)
    28=Is Not a Member Of (NOT IN)