Custom
The Custom Data Type be specified within the body of the Import Specification.
Sample Data Specification
|
Field Name |
Requires Value? |
Max Length |
Related Table |
|
|
TaskCode |
String |
Yes |
32 |
|
|
TaskName |
String |
Yes |
128 |
|
|
TaskDescription |
String |
No |
255 |
|
|
CurrentRevisionNumber |
Numeric |
Yes |
Min: 0 Max: 9999 |
|
|
RevisionDate |
Date |
Yes |
- |
|
|
StartDate |
Date |
No |
- |
|
|
EndDate |
Date |
No |
- |
|
|
Status |
Custom StatusType |
Yes |
Min: 0 Max: 13 |
|
|
CLIN |
String |
No |
16 |
|
|
Custom1 |
String |
No |
64 |
|
|
Custom2 |
String |
No |
64 |
|
|
Custom3 |
String |
No |
64 |
|
|
Custom4 |
String |
No |
64 |
|
|
Custom5 |
String |
No |
64 |
|
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:1602-1920-7701