Name: CAEEngineeringLookup.dbo.vw_ContractWithUserSelectionFields
Display Field: CategoryName
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, PBF
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:
-
ContractID
(
type: esriFieldTypeOID, alias: ContractID
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 50
)
-
CategoryName
(
type: esriFieldTypeString, alias: CategoryName, length: 100
)
-
ContractName
(
type: esriFieldTypeString, alias: ContractName, length: 255
)
-
Department
(
type: esriFieldTypeString, alias: Department, length: 100
)
-
ContractSignedDate
(
type: esriFieldTypeDate, alias: ContractSignedDate, length: 8
)
-
ExpirationDate
(
type: esriFieldTypeDate, alias: ExpirationDate, length: 8
)
-
LastRevised
(
type: esriFieldTypeDate, alias: LastRevised, length: 8
)
-
ReviewBy
(
type: esriFieldTypeDate, alias: ReviewBy, length: 8
)
-
POReq
(
type: esriFieldTypeString, alias: POReq, length: 100
)
-
CompanyNameWith
(
type: esriFieldTypeString, alias: CompanyNameWith, length: 255
)
-
ProjectName
(
type: esriFieldTypeString, alias: ProjectName, length: 255
)
-
CityJobNumber
(
type: esriFieldTypeString, alias: CityJobNumber, length: 255
)
-
ProjectCode
(
type: esriFieldTypeString, alias: ProjectCode, length: 255
)
-
UserField4
(
type: esriFieldTypeString, alias: UserField4, length: 255
)
-
AwardedDesignContract
(
type: esriFieldTypeString, alias: AwardedDesignContract, length: 255
)
-
CompleteDesign
(
type: esriFieldTypeString, alias: CompleteDesign, length: 255
)
-
BeginConstruction
(
type: esriFieldTypeString, alias: BeginConstruction, length: 255
)
-
Advertise
(
type: esriFieldTypeString, alias: Advertise, length: 255
)
-
BidOpen
(
type: esriFieldTypeString, alias: BidOpen, length: 255
)
-
UserField10
(
type: esriFieldTypeString, alias: UserField10, length: 255
)
-
CompanyName
(
type: esriFieldTypeString, alias: CompanyName, length: 255
)
-
CouncilDate
(
type: esriFieldTypeDate, alias: CouncilDate, length: 8
)
-
ProfLiabilityIns
(
type: esriFieldTypeDate, alias: ProfLiabilityIns, length: 8
)
-
GenLiabilityIns
(
type: esriFieldTypeDate, alias: GenLiabilityIns, length: 8
)
-
PerformanceBondExpDate
(
type: esriFieldTypeDate, alias: PerformanceBondExpDate, length: 8
)
-
UserDate5
(
type: esriFieldTypeDate, alias: UserDate5, length: 8
)
-
UserSelectionType
(
type: esriFieldTypeString, alias: UserSelectionType, length: 24
)
-
UserSelectionValue
(
type: esriFieldTypeString, alias: UserSelectionValue, length: 255
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata