SPB_TASKTOGROUP

(SQL Table)
Index Back

Logistical Task Configuration

11/08/2001 Assign individual Logistical Tasks to a particular Task Group, which will be used later when assigning Task Groups to Role Types. A Logistical Task Group may contain a single task or multiple tasks.

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SETID_TBL

    2 SP_GROUPID Number(15,0) DECIMAL(15) NOT NULL Groupid field
    3 SP_TASKID Number(15,0) DECIMAL(15) NOT NULL Logistical Task ID

    Prompt Table: SPB_TASK