SPB_TASK

(SQL Table)
 Index Back

Logistical Task Record

11/08/2001 Logistical Task is a piece of work or assignment that needs to be executed based on Work Order status.

  • Related Language Record: SPB_TASK_LANG

  • Parent record: SETID_TBL

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

    Prompt Table: SP_SETID_NONVW
    Set Control Field: SETID

    2 SP_TASKID Number(15,0) DECIMAL(15) NOT NULL Logistical Task ID

    Default Value: 1

    3 SP_TASK_DSCR_SHRT Character(30) VARCHAR2(30) NOT NULL Task Short Description
    4 SP_TYPE_OF_EXECUTN Character(1) VARCHAR2(1) NOT NULL Type of Task Execution
    A=Automatic
    M=Mandatory
    O=Optional
    5 SP_APPROVAL_TYPE Character(1) VARCHAR2(1) NOT NULL Field to indicate the approval tasks
    O=Off-Board
    R=Pre-Approval
    T=Post-Approval
    X=Terminate
    6 SP_LOG_WO_TYPE Character(1) VARCHAR2(1) NOT NULL 02/19/2002 Used to define characteristics of logistical task that should be used based on Work Order Type.
    B=Both
    E=Extension
    O=Original
    R=Reassignment
    7 SP_DEFLT_ASSIGD_TO Character(1) VARCHAR2(1) NOT NULL 02/19/2002 Used to define the logistical task "assigned to" person dynamically at run time.
    D=Default
    I=Invoice Approver
    R=Requester
    S=Service Provider Contact
    8 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To

    Prompt Table: SPF_REQAPPVR_VW

    9 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    10 SP_TASK_DESCR_LONG Character(250) VARCHAR2(250) NOT NULL Task Long Description