OPR_DEF_TBL_SP

(SQL Table)
 Index Back

Operator Default table

Requester User default table for service procurement.

  • Parent Record Of SP_OPR_DEF_ALRT

    • # 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: SPB_REQUESTR_VW

    2 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
    D=Deliverable
    M=Multi Resource
    R=Resource

    Default Value: R

    3 NOTIFY_BY Character(4) VARCHAR2(4) NOT NULL Notification Method
    EM=Email and Worklist
    WL=WorkList Only
    4 BUS_UNIT_PROJECTS Character(5) VARCHAR2(5) NOT NULL Projects Business Unit

    Prompt Table: SP_BU_PC_NONVW

    5 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator

    Prompt Table: %EDITTABLE16
    Set Control Field: BUSINESS_UNIT

    6 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: %EDITTABLE
    Set Control Field: SETID_PROJROLE

    7 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator

    Prompt Table: SPF_SRVC_CRD_VW

    8 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    9 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID

    Prompt Table: SPB_TEAM_ID_VW
    Set Control Field: SETID

    10 TE_APPROVER Character(30) VARCHAR2(30) NOT NULL Time Approver
    11 INVAPPROVER Character(30) VARCHAR2(30) NOT NULL Invoice Approver

    Prompt Table: SPF_INVAPRVR_VW

    12 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SPB_PROJECT_VW
    Set Control Field: BUS_UNIT_PROJECTS

    13 APPROVER_LBL Character(30) VARCHAR2(30) NOT NULL Approver

    Prompt Table: SPF_APPROVER_VW

    14 FLAG1 Character(1) VARCHAR2(1) NOT NULL Flag1

    Y/N Table Edit

    15 FLAG2 Character(1) VARCHAR2(1) NOT NULL Flag2

    Y/N Table Edit

    16 FLAG3 Character(1) VARCHAR2(1) NOT NULL Flag3

    Y/N Table Edit

    17 TIME_EXP_TOL_PER Number(3,0) SMALLINT NOT NULL Time & Expense Tolerance Percent
    18 WO_NOTIFY_BY Character(2) VARCHAR2(2) NOT NULL WorkOrder Alert Notification Method
    EM=Email and Worklist
    WL=Worklist Only
    19 SP_USE_WO_ALERTS Character(1) VARCHAR2(1) NOT NULL Using Work Order Alerts flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    20 SP_EXP_APPROVER Character(30) VARCHAR2(30) NOT NULL Expense Approver