BUSINESS_UNITWORK_ORDER_IDSP_TASKIDSP_GROUPIDSEQNUMN=No
Y=Yes
Default Value: %DateTime
Default Value: %DateTime
SPF_DELTSK_ASGN(SQL Table) |
Index Back |
|---|---|
tasks for deletionrecord to store details of the original assigned to user for tasks |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 3 | SP_TASKID |
Number(15,0) | DECIMAL(15) NOT NULL | Logistical Task ID |
| 4 | SP_GROUPID |
Number(15,0) | DECIMAL(15) NOT NULL | Groupid field |
| 5 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | ASSIGNED_TO | Character(30) | VARCHAR2(30) NOT NULL | Assigned To |
| 7 | EODI_TRANS_ID | Number(15,0) | DECIMAL(15) NOT NULL | Transaction ID |
| 8 | SP_IS_DEL_IN_OTLK | Character(1) | VARCHAR2(1) NOT NULL |
is deleted in outlook flag
N=No Y=Yes |
| 9 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP |
Row Creation Date Time
Default Value: %DateTime |
| 10 | ROW_MODIFY_DATE | DateTime(26) | TIMESTAMP |
Modified Date Time
Default Value: %DateTime |
| 11 | ROW_CREATE_USER | Character(30) | VARCHAR2(30) NOT NULL | Row Added By |
| 12 | ROW_MODIFY_USER | Character(30) | VARCHAR2(30) NOT NULL | Modified User |