| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 2 |
WORK_ORDER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order ID
Prompt Table:
SPF_WORDERREC
|
| 3 |
SP_TASKID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Logistical Task ID
Prompt Table:
SPB_TASK
|
| 4 |
SP_GROUPID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Groupid field
Prompt Table:
SPB_TASK_GROUP
|
| 5 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 6 |
WO_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Status
A=Approved
C=Closed
D=Denied
F=Finalize
L=Released
N=Canceled
O=Open
P=Pending Terminate
S=Submitted
T=Terminated
|
| 7 |
ROLE_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Service Type
APR=Approver
MGR=Manager
OPR=Operator
|
| 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_TYPE_OF_EXECUTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Task Execution
A=Automatic
M=Mandatory
O=Optional
|
| 10 |
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
|
| 11 |
ASSIGNED_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Assigned To
Prompt Table:
SPF_REQAPPVR_VW
|
| 12 |
EXEC_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
To indicate the status of task execution
N=No
Y=Yes
Y/N Table Edit
|
| 13 |
COMPLETE_DATE |
Date(10) |
DATE |
To save the task execution complete date
|
| 14 |
SP_NOTIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to indicate notification status
N=No
Y=Yes
Y/N Table Edit
|
| 15 |
SP_NOTIFY_DATES |
Date(10) |
DATE |
Notification Dates
|
| 16 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 17 |
ROW_CREATE_DATE |
DateTime(26) |
TIMESTAMP |
Row Creation Date Time
Default Value: %DateTime
|
| 18 |
ROW_MODIFY_DATE |
DateTime(26) |
TIMESTAMP |
Modified Date Time
Default Value: %DateTime
|
| 19 |
ROW_CREATE_USER |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added By
|
| 20 |
ROW_MODIFY_USER |
Character(30) |
VARCHAR2(30) NOT NULL |
Modified User
|
| 21 |
EODI_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Transaction ID
Default Value: 0
|
| 22 |
SPF_TASK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
task status
C=Completed
D=Deferred
I=In Progress
N=Not Started
W=Waiting on someone else
Default Value: N
|
| 23 |
SP_IS_DEL_IN_OTLK |
Character(1) |
VARCHAR2(1) NOT NULL |
is deleted in outlook flag
N=No
Y=Yes
Default Value: N
|
| 24 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 25 |
EXPECTED_DATE |
Date(10) |
DATE |
Expected By
|