DP_CNTL_REF_LNS

(SQL Table)
 Index Back

DP_CNTL_REF_LNS

DP_CNTL_REF_LNS

  • Parent record: DP_RUN_CNTL_REF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET

    Prompt Table: DP_POLS2USER_VW

    4 DP_ROWNUMBER Number(5,0) INTEGER NOT NULL DP_ROWNUMBER
    5 DP_SELECTIONFLD Character(24) VARCHAR2(24) NOT NULL DP_SELECTIONFLD

    Prompt Table: DP_BUITEMFLD_VW

    6 DP_SELECT_OPERATOR Character(4) VARCHAR2(4) NOT NULL Field selection operator
    <=<
    <==<=
    <>=<>
    ===
    >=>
    >==>=
    BTWN=BETWEEN
    IN=IN
    LIKE=LIKE
    NBTN=NOT BETWEEN
    NLIK=NOT LIKE
    NOTI=NOT IN
    7 DP_DESCRIPTION Character(120) VARCHAR2(120) NOT NULL Description

    Prompt Table: %EDITTABLE2

    8 DP_NEXTOPER Character(4) VARCHAR2(4) NOT NULL DP_NEXTOPER
    AND=And
    OR=Or
    9 DP_DATATYPE Character(1) VARCHAR2(1) NOT NULL DP_DATATYPE
    0=Character
    1=Long Character
    2=Number
    3=Signed Number
    4=Date
    10 DP_DATE Date(10) DATE DP_DATE
    11 DP_OPEN_PARENS Character(1) VARCHAR2(1) NOT NULL Open Parenthesis
    (=(
    12 DP_CLOSE_PARENS Character(1) VARCHAR2(1) NOT NULL Close Parenthesis
    )=)