SPF_TSKCKLST_VW(SQL View) |
Index Back |
|---|---|
Task Checklist viewWork Order Task Checklist |
| SELECT A.SP_TASKID ,C.SP_GROUPID , A.ASSIGNED_TO , A.EMAIL_ADDR , A.SP_TYPE_OF_EXECUTN , A.SP_TASK_DSCR_SHRT ,A.SP_LOG_WO_TYPE ,A.SP_DEFLT_ASSIGD_TO ,A.SP_APPROVAL_TYPE , A.SETID FROM PS_SPB_TASKTOGROUP C , PS_SPB_TASK A , PS_SPB_TASK_GROUP B WHERE C.SP_TASKID = A.SP_TASKID AND C.SP_GROUPID = B. SP_GROUPID AND A.SETID = B.SETID AND B.SETID = C.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SP_TASKID |
Number(15,0) | DECIMAL(15) NOT NULL | Logistical Task ID |
| 2 | SP_GROUPID |
Number(15,0) | DECIMAL(15) NOT NULL | Groupid field |
| 3 | ASSIGNED_TO | Character(30) | VARCHAR2(30) NOT NULL |
Assigned To
Prompt Table: REQUESTOR_TBL |
| 4 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 5 | SP_TYPE_OF_EXECUTN | Character(1) | VARCHAR2(1) NOT NULL |
Type of Task Execution
A=Automatic M=Mandatory O=Optional |
| 6 | SP_TASK_DSCR_SHRT | Character(30) | VARCHAR2(30) NOT NULL | Task Short Description |
| 7 | 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 |
| 8 | 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 |
| 9 | 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 |
| 10 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |