SPB_SERVICE_COD

(SQL Table)
 Index Back

Service Coordinator definition

Stores additional information for Service Coordinators

  • Parent record: SPB_PERSON_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Prompt Table: SPB_PERSON_TBL

    2 SC_FUNCTION_TYPE Character(4) VARCHAR2(4) NOT NULL Function Type
    COOD=Coordinator

    Default Value: COOD

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

    Default Value: R

    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_SP_VW3
    Set Control Field: VENDOR_SETID

    9 SPB_AUTHORIZED Character(1) VARCHAR2(1) NOT NULL Authorized to Delegate

    Y/N Table Edit

    Default Value: N

    10 SPB_AUTHORIZE Character(1) VARCHAR2(1) NOT NULL Authorized to Change Sourcing

    Y/N Table Edit

    Default Value: N

    11 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

    Default Value: %DateTime

    12 ROW_MODIFY_DATE DateTime(26) TIMESTAMP Modified Date Time

    Default Value: %DateTime

    13 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
    14 ROW_MODIFY_USER Character(30) VARCHAR2(30) NOT NULL Modified User
    15 NOTIFY_BY Character(4) VARCHAR2(4) NOT NULL Notification Method
    EM=Email and Worklist
    WL=WorkList Only
    16 BUS_UNIT_PROJECTS Character(5) VARCHAR2(5) NOT NULL Projects Business Unit

    Prompt Table: SP_BU_PC_NONVW

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

    Prompt Table: %EDITTABLE16
    Set Control Field: BUSINESS_UNIT

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

    Prompt Table: %EDITTABLE
    Set Control Field: SETID

    19 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

    Prompt Table: REQUESTOR_TBL

    20 TE_APPROVER Character(30) VARCHAR2(30) NOT NULL Time Approver
    21 INVAPPROVER Character(30) VARCHAR2(30) NOT NULL Invoice Approver

    Prompt Table: SPF_INVAPRVR_VW

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

    Prompt Table: SPB_PROJECT_VW
    Set Control Field: BUS_UNIT_PROJECTS

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

    Prompt Table: SPF_APPROVER_VW

    24 TIME_EXP_TOL_PER Number(3,0) SMALLINT NOT NULL Time & Expense Tolerance Percent
    25 WO_NOTIFY_BY Character(2) VARCHAR2(2) NOT NULL WorkOrder Alert Notification Method
    EM=Email and Worklist
    WL=Worklist Only
    26 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID

    Prompt Table: SP_OPERATOR_VW1

    27 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: SPB_LOCATION_VW
    Set Control Field: VENDOR_SETID

    28 SPB_IS_ADMIN Character(1) VARCHAR2(1) NOT NULL field used in spro user setup to flag user as supplier administrator

    Y/N Table Edit

    Default Value: N

    29 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

    30 SP_EXP_APPROVER Character(30) VARCHAR2(30) NOT NULL Expense Approver
    31 SP_COOD_STATUS Character(1) VARCHAR2(1) NOT NULL sPro coordinator status
    A=Active
    I=Inactive

    Default Value: A