DP_RUN_CNTL_POP

(SQL Table)
Index Back

DP_RUN_CNTL_POP

DP_RUN_CNTL_POP

  • Parent Record Of DP_CNTL_POP_LNS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRID_VW

    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_SI_PS1UIN_VW

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DP_POLICYCONTROL Character(20) VARCHAR2(20) NOT NULL DP_POLICYCONTROL

    Prompt Table: DP_POLCTRLS1_VW

    6 DP_STATUS_CURRENT Character(1) VARCHAR2(1) NOT NULL DP_STATUS_CURRENT
    1=Active
    5=Pending Approval
    9=Both

    Default Value: 1

    7 DP_INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL DP_INVENTORY_ITEM
    B=Both
    N=No
    Y=Yes

    Default Value: Y

    8 DP_DELETEDATA Character(1) VARCHAR2(1) NOT NULL DP_DELETEDATA

    Y/N Table Edit

    Default Value: N