Tasks
Import Specification: Tasks
Table Name: TaskManagementTasks
Table Type: Task Management
Current Import Version: 1.0
Data Specification
|
Field Name |
Requires Value? |
Max Length |
Related Table |
Precision |
|
|
TaskCode |
String |
Yes |
50 |
|
|
|
TaskName |
String |
Yes |
150 |
|
|
|
TaskDescription |
String |
No |
300 |
|
|
|
CurrentRevisionNumber |
Numeric |
Yes |
Min: 0 Max: 9999 |
|
|
|
RevisionDate |
Date |
Yes |
- |
|
|
|
StartDate |
Date |
No |
- |
|
|
|
EndDate |
Date |
No |
- |
|
|
|
Status |
Custom StatusType |
Yes |
Min: 0 Max: 13 |
|
0 |
|
CLIN |
String |
No |
16 |
|
|
|
IsContractTask |
Boolean |
Yes |
- |
|
|
|
Custom1 |
String |
No |
100 |
|
|
|
Custom2 |
String |
No |
100 |
|
|
|
Custom3 |
String |
No |
100 |
|
|
|
Custom4 |
String |
No |
100 |
|
|
|
Custom5 |
String |
No |
100 |
|
|
|
+ |
+ |
+ |
+ |
|
|
+ All Custom Attributes of Object Type "Task" will be shown at the end of the import spec. Each attribute will be in the format of CUSTOM:(attribute name).
Available Import Header Commands
- Append *
- ReplaceByKey
- Available Fields
- TaskCode
* This is the default behavior for file import processing of this table.
StatusType Values
The Status Column must be a number between 0 and 13 which represents the Status for the Task. iSite provides 4 static Status Codes and also provides up to 10 additional Custom Status Codes which are managed via the iSite interface. See Datawarehouse Settings for more information on specifying Custom Status Codes.
The following values are valid for the Status Column for Tasks:
- 0 = Draft
- 1 = In Performance
- 2 = Completed
- 3 = Canceled
- 4 = Custom 1
- 5 = Custom 2
- 6 = Custom 3
- 7 = Custom 4
- 8 = Custom 5
- 9 = Custom 6
- 10 = Custom 7
- 11 = Custom 8
- 12 = Custom 9
- 13 = Custom 10
Page ID:6313-5635-1497