Name: EasyProjects.dbo.TT_Tasks
Display Field: Name
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
AccountId
(
type: esriFieldTypeInteger, alias: AccountId
)
-
TaskID
(
type: esriFieldTypeInteger, alias: TaskID
)
-
ProjectID
(
type: esriFieldTypeInteger, alias: ProjectID
)
-
ParentID
(
type: esriFieldTypeInteger, alias: ParentID
)
-
Name
(
type: esriFieldTypeString, alias: Name, length: 400
)
-
TaskTypeID
(
type: esriFieldTypeInteger, alias: TaskTypeID
)
-
TaskStatusID
(
type: esriFieldTypeInteger, alias: TaskStatusID
)
-
CreationDate
(
type: esriFieldTypeDate, alias: CreationDate, length: 8
)
-
StartDate
(
type: esriFieldTypeDate, alias: StartDate, length: 8
)
-
EndDate
(
type: esriFieldTypeDate, alias: EndDate, length: 8
)
-
Duration
(
type: esriFieldTypeInteger, alias: Duration
)
-
EstimatedHours
(
type: esriFieldTypeDouble, alias: EstimatedHours
)
-
CreatorID
(
type: esriFieldTypeInteger, alias: CreatorID
)
-
CategoryID
(
type: esriFieldTypeInteger, alias: CategoryID
)
-
BillingType
(
type: esriFieldTypeInteger, alias: BillingType
)
-
BillingAmount
(
type: esriFieldTypeDouble, alias: BillingAmount
)
-
Progress
(
type: esriFieldTypeInteger, alias: Progress
)
-
PriorityID
(
type: esriFieldTypeInteger, alias: PriorityID
)
-
ActualCompletionDate
(
type: esriFieldTypeDate, alias: ActualCompletionDate, length: 8
)
-
IsMilestone
(
type: esriFieldTypeSmallInteger, alias: IsMilestone
)
-
Approved
(
type: esriFieldTypeSmallInteger, alias: Approved
)
-
Description
(
type: esriFieldTypeString, alias: Description, length: 1073741822
)
-
LastModificationDate
(
type: esriFieldTypeDate, alias: LastModificationDate, length: 8
)
-
Budget
(
type: esriFieldTypeDouble, alias: Budget
)
-
HoursLeft
(
type: esriFieldTypeDouble, alias: HoursLeft
)
-
WBSNumber
(
type: esriFieldTypeDouble, alias: WBSNumber
)
-
IsEndDateSelected
(
type: esriFieldTypeSmallInteger, alias: IsEndDateSelected
)
-
Billed
(
type: esriFieldTypeSmallInteger, alias: Billed
)
-
HasDescription
(
type: esriFieldTypeSmallInteger, alias: HasDescription
)
-
StartDateForGantt
(
type: esriFieldTypeDate, alias: StartDateForGantt, length: 8
)
-
EndDateForGantt
(
type: esriFieldTypeDate, alias: EndDateForGantt, length: 8
)
-
DurationHours
(
type: esriFieldTypeSingle, alias: DurationHours
)
-
StartDateLag
(
type: esriFieldTypeSingle, alias: StartDateLag
)
-
EndDateLag
(
type: esriFieldTypeSingle, alias: EndDateLag
)
-
LagForGantt
(
type: esriFieldTypeSingle, alias: LagForGantt
)
-
BaselineStartDate
(
type: esriFieldTypeDate, alias: BaselineStartDate, length: 8
)
-
BaselineEndDate
(
type: esriFieldTypeDate, alias: BaselineEndDate, length: 8
)
-
BaselineStartLag
(
type: esriFieldTypeSingle, alias: BaselineStartLag
)
-
BaselineEndLag
(
type: esriFieldTypeSingle, alias: BaselineEndLag
)
-
StartDateVariance
(
type: esriFieldTypeInteger, alias: StartDateVariance
)
-
EndDateVariance
(
type: esriFieldTypeInteger, alias: EndDateVariance
)
-
SourceRepeatTaskId
(
type: esriFieldTypeInteger, alias: SourceRepeatTaskId
)
-
IsRepeatSource
(
type: esriFieldTypeSmallInteger, alias: IsRepeatSource
)
-
RepeatWrapperForTaskId
(
type: esriFieldTypeInteger, alias: RepeatWrapperForTaskId
)
-
CustomFields
(
type: esriFieldTypeString, alias: CustomFields, length: 1073741822
)
-
BaselineBudget
(
type: esriFieldTypeDouble, alias: BaselineBudget
)
-
BaselineOwnEstimatedHours
(
type: esriFieldTypeDouble, alias: BaselineOwnEstimatedHours
)
-
RateCardId
(
type: esriFieldTypeInteger, alias: RateCardId
)
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata