Name: PTD_Sales

Display Field: name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f9520b7bcb754479936979b2aceccea1

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
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:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• name ( modelName: name, nullable: true, editable: true, defaultValue: null, length: 50, alias: Name, type: esriFieldTypeString )
• bookpage ( modelName: bookpage, nullable: true, editable: true, defaultValue: null, length: 50, alias: BookPage, type: esriFieldTypeString )
• statecamaid ( modelName: StateCamaId, nullable: false, editable: true, defaultValue: null, length: 36, alias: StateCamaId, type: esriFieldTypeString )
• camajoinid ( modelName: CamaJoinId, nullable: false, editable: true, defaultValue: null, length: 49, alias: CamaJoinId, type: esriFieldTypeString )
• saleid ( modelName: SaleId, nullable: false, editable: true, defaultValue: null, length: 35, alias: SaleId, type: esriFieldTypeString )
• countyfips ( modelName: CountyFIPS, nullable: false, editable: true, defaultValue: null, length: 5, alias: CountyFIPS, type: esriFieldTypeString )
• camalinkstatus ( modelName: CamaLinkStatus, nullable: false, editable: true, defaultValue: null, length: 3, alias: CamaLinkStatus, type: esriFieldTypeString )
• accountnumber_sale ( modelName: accountnumber_sale, nullable: true, editable: true, defaultValue: null, length: 255, alias: AccountNumber_Sale, type: esriFieldTypeString )
• upc_sale ( modelName: upc_sale, nullable: true, editable: true, defaultValue: null, length: 255, alias: UPC_Sale, type: esriFieldTypeString )
• taxyear ( modelName: TaxYear, nullable: false, editable: true, defaultValue: null, alias: TaxYear, type: esriFieldTypeInteger )
• supplementalyn ( modelName: SupplementalYN, nullable: false, editable: true, defaultValue: null, alias: SupplementalYN, type: esriFieldTypeSmallInteger )
• saledate ( modelName: saledate, nullable: true, editable: true, defaultValue: null, length: 29, alias: SaleDate, type: esriFieldTypeDate )
• saleprice ( modelName: saleprice, nullable: true, editable: true, defaultValue: null, alias: SalePrice, type: esriFieldTypeInteger )
• bookin ( modelName: bookin, nullable: true, editable: true, defaultValue: null, length: 50, alias: BookIn, type: esriFieldTypeString )
• pagein ( modelName: pagein, nullable: true, editable: true, defaultValue: null, length: 50, alias: PageIn, type: esriFieldTypeString )
• affidavityn ( modelName: AffidavitYN, nullable: false, editable: true, defaultValue: null, alias: AffidavitYN, type: esriFieldTypeSmallInteger )
• salevalidyn ( modelName: SaleValidYN, nullable: false, editable: true, defaultValue: null, alias: SaleValidYN, type: esriFieldTypeSmallInteger )
• exclusioncode ( modelName: exclusioncode, nullable: true, editable: true, defaultValue: null, alias: ExclusionCode, type: esriFieldTypeInteger )
• exclusioncodename ( modelName: exclusioncodename, nullable: true, editable: true, defaultValue: null, length: 255, alias: ExclusionCodeName, type: esriFieldTypeString )
• stateexclusioncode ( modelName: stateexclusioncode, nullable: true, editable: true, defaultValue: null, length: 1, alias: StateExclusionCode, type: esriFieldTypeString )
• exclusioncomment ( modelName: exclusioncomment, nullable: true, editable: true, defaultValue: null, length: 255, alias: ExclusionComment, type: esriFieldTypeString )
• priorassessedvalueland ( modelName: priorassessedvalueland, nullable: true, editable: true, defaultValue: null, alias: PriorAssessedValueLand, type: esriFieldTypeInteger )
• priorassessedvaluebuilding ( modelName: priorassessedvaluebuilding, nullable: true, editable: true, defaultValue: null, alias: PriorAssessedValueBuilding, type: esriFieldTypeInteger )
• priorassessedvaluemisc ( modelName: priorassessedvaluemisc, nullable: true, editable: true, defaultValue: null, alias: PriorAssessedValueMisc, type: esriFieldTypeInteger )
• priorassessedvaluetotal ( modelName: priorassessedvaluetotal, nullable: true, editable: true, defaultValue: null, alias: PriorAssessedValueTotal, type: esriFieldTypeInteger )
• priorratio ( modelName: priorratio, nullable: true, editable: true, defaultValue: null, alias: PriorRatio, type: esriFieldTypeDouble )
• assessedvalueland ( modelName: assessedvalueland, nullable: true, editable: true, defaultValue: null, alias: AssessedValueLand, type: esriFieldTypeInteger )
• assessedvaluebuilding ( modelName: assessedvaluebuilding, nullable: true, editable: true, defaultValue: null, alias: AssessedValueBuilding, type: esriFieldTypeInteger )
• assessedvaluemisc ( modelName: assessedvaluemisc, nullable: true, editable: true, defaultValue: null, alias: AssessedValueMisc, type: esriFieldTypeInteger )
• assessedvaluetotal ( modelName: assessedvaluetotal, nullable: true, editable: true, defaultValue: null, alias: AssessedValueTotal, type: esriFieldTypeInteger )
• saleratio ( modelName: saleratio, nullable: true, editable: true, defaultValue: null, alias: SaleRatio, type: esriFieldTypeDouble )

Templates:

• Name: PTD_Sales
  Description:
  Prototype:
  exclusioncomment: null
  taxyear: 0
  bookin: null
  assessedvaluebuilding: null
  priorratio: null
  saleprice: null
  assessedvaluemisc: null
  priorassessedvaluetotal: null
  camalinkstatus:
  pagein: null
  stateexclusioncode: null
  accountnumber_sale: null
  assessedvalueland: null
  statecamaid:
  camajoinid:
  saledate: null
  saleratio: null
  exclusioncode: null
  exclusioncodename: null
  affidavityn: 0
  saleid:
  salevalidyn: 0
  countyfips:
  priorassessedvalueland: null
  assessedvaluetotal: null
  bookpage: null
  priorassessedvaluebuilding: null
  priorassessedvaluemisc: null
  name: null
  supplementalyn: 0
  upc_sale: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SALE (2) -- Related To: PTD_CAMA (3)
• SALE (0) -- Related To: PTD_Parcels_CAMA (1)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata