Name: TIF_Quarterly_Report_Properties

Display Field: Grantee

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 33f6e0f15fc8458dbf79d14ba19601a7

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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• ParentUniqueID ( type: esriFieldTypeGUID, alias: ParentUniqueID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ParentUniqueID )
• Grantee ( type: esriFieldTypeString, alias: Grantee, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Grantee )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Blocklot ( type: esriFieldTypeString, alias: Blocklot, editable: true, nullable: true, length: 9, defaultValue: null, modelName: Blocklot )
• Project_Name ( type: esriFieldTypeString, alias: Project_Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project_Name )
• Num_Prop ( type: esriFieldTypeInteger, alias: Num_Prop, editable: true, nullable: true, defaultValue: null, modelName: Num_Prop )
• Rep_Period_Qtr ( type: esriFieldTypeInteger, alias: Rep_Period_Qtr, editable: true, nullable: true, defaultValue: null, modelName: Rep_Period_Qtr )
• Total_Award ( type: esriFieldTypeDouble, alias: Total_Award, editable: true, nullable: true, defaultValue: null, modelName: Total_Award )
• Quarterly_Exp ( type: esriFieldTypeDouble, alias: Quarterly_Exp, editable: true, nullable: true, defaultValue: null, modelName: Quarterly_Exp )
• New_Total_Exp ( type: esriFieldTypeDouble, alias: New_Total_Exp, editable: true, nullable: true, defaultValue: null, modelName: New_Total_Exp )
• Zoning_Approvals ( type: esriFieldTypeString, alias: Zoning_Approvals, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Zoning_Approvals )
• Fin_Close ( type: esriFieldTypeString, alias: Fin_Close, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Fin_Close )
• Fin_Close_Date ( type: esriFieldTypeDate, alias: Fin_Close_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Fin_Close_Date )
• Site_Control ( type: esriFieldTypeString, alias: Site_Control, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Site_Control )
• BVRI_Agrmt ( type: esriFieldTypeString, alias: BVRI_Agrmt, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BVRI_Agrmt )
• Other_Grants ( type: esriFieldTypeString, alias: Other_Grants, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Other_Grants )
• Pct_Complete ( type: esriFieldTypeInteger, alias: Pct_Complete, editable: true, nullable: true, defaultValue: null, modelName: Pct_Complete )
• Use_Permit ( type: esriFieldTypeString, alias: Use_Permit, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Use_Permit )
• Use_Permit_No ( type: esriFieldTypeString, alias: Use_Permit_No, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Use_Permit_No )
• MBE_Num ( type: esriFieldTypeInteger, alias: MBE_Num, editable: true, nullable: true, defaultValue: null, modelName: MBE_Num )
• MBE_Pct ( type: esriFieldTypeInteger, alias: MBE_Pct, editable: true, nullable: true, defaultValue: null, modelName: MBE_Pct )
• WBE_Num ( type: esriFieldTypeInteger, alias: WBE_Num, editable: true, nullable: true, defaultValue: null, modelName: WBE_Num )
• WBE_Pct ( type: esriFieldTypeInteger, alias: WBE_Pct, editable: true, nullable: true, defaultValue: null, modelName: WBE_Pct )
• Rent_Lease_Pd ( type: esriFieldTypeInteger, alias: Rent_Lease_Pd, editable: true, nullable: true, defaultValue: null, modelName: Rent_Lease_Pd )
• Rent_Total_Units ( type: esriFieldTypeInteger, alias: Rent_Total_Units, editable: true, nullable: true, defaultValue: null, modelName: Rent_Total_Units )
• Rent_AMI_60 ( type: esriFieldTypeInteger, alias: Rent_AMI_60, editable: true, nullable: true, defaultValue: null, modelName: Rent_AMI_60 )
• Rent_Legacy_60 ( type: esriFieldTypeInteger, alias: Rent_Legacy_60, editable: true, nullable: true, defaultValue: null, modelName: Rent_Legacy_60 )
• Rent_AMI_80 ( type: esriFieldTypeInteger, alias: Rent_AMI_80, editable: true, nullable: true, defaultValue: null, modelName: Rent_AMI_80 )
• Rent_Legacy_80 ( type: esriFieldTypeInteger, alias: Rent_Legacy_80, editable: true, nullable: true, defaultValue: null, modelName: Rent_Legacy_80 )
• Rent_AMI_115 ( type: esriFieldTypeInteger, alias: Rent_AMI_115, editable: true, nullable: true, defaultValue: null, modelName: Rent_AMI_115 )
• Rent_Legacy_115 ( type: esriFieldTypeInteger, alias: Rent_Legacy_115, editable: true, nullable: true, defaultValue: null, modelName: Rent_Legacy_115 )
• Home_Total_Units ( type: esriFieldTypeInteger, alias: Home_Total_Units, editable: true, nullable: true, defaultValue: null, modelName: Home_Total_Units )
• Home_AMI_60 ( type: esriFieldTypeInteger, alias: Home_AMI_60, editable: true, nullable: true, defaultValue: null, modelName: Home_AMI_60 )
• Home_AMI_80 ( type: esriFieldTypeInteger, alias: Home_AMI_80, editable: true, nullable: true, defaultValue: null, modelName: Home_AMI_80 )
• Home_AMI_115 ( type: esriFieldTypeInteger, alias: Home_AMI_115, editable: true, nullable: true, defaultValue: null, modelName: Home_AMI_115 )
• Rep_Period_Year ( type: esriFieldTypeInteger, alias: Rep_Period_Year, editable: true, nullable: true, defaultValue: null, modelName: Rep_Period_Year )
• Created_Date ( type: esriFieldTypeDate, alias: Created_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Created_Date )

Templates:

• Name: TIF_Quarterly_Report_Properties
  Description:
  Prototype:
  Rep_Period_Year: null
  ParentUniqueID: null
  Grantee: null
  Address: null
  Created_Date: null
  Home_AMI_115: null
  Blocklot: null
  Project_Name: null
  Num_Prop: null
  Rep_Period_Qtr: null
  Total_Award: null
  Quarterly_Exp: null
  New_Total_Exp: null
  Zoning_Approvals: null
  Fin_Close: null
  Fin_Close_Date: null
  Site_Control: null
  BVRI_Agrmt: null
  Other_Grants: null
  Pct_Complete: null
  Use_Permit: null
  Use_Permit_No: null
  MBE_Num: null
  MBE_Pct: null
  WBE_Num: null
  WBE_Pct: null
  Rent_Lease_Pd: null
  Rent_Total_Units: null
  Rent_AMI_60: null
  Rent_Legacy_60: null
  Rent_AMI_80: null
  Rent_Legacy_80: null
  Rent_AMI_115: null
  Rent_Legacy_115: null
  Home_Total_Units: null
  Home_AMI_60: null
  Home_AMI_80: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• housing.HOUSING.TIF_Quarterly_Report_Main (0) -- Related To: TIF_Quarterly_Report_Main (0)

Capabilities: Query,Create,Update,Uploads,Editing,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata