Name: OCConstruction.DBO.JOC_Add_Proj_Info

Display Field: Budget_BFAST_Num

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Project_Number ( type: esriFieldTypeDouble, alias: Project Number, editable: true, nullable: true, defaultValue: null, modelName: Project_Number )
• Budget_BFAST_Num ( type: esriFieldTypeString, alias: Budget/BFAST Numbers, editable: true, nullable: true, length: 12, defaultValue: null, modelName: Budget_BFAST_Num )
• Cost ( type: esriFieldTypeDouble, alias: Cost of Contrat/% Completed (Prog Pay), editable: true, nullable: true, defaultValue: null, modelName: Cost )
• Fiscal_Year ( type: esriFieldTypeString, alias: Fiscal Year, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Fiscal_Year )
• SWPP_Risk_Level ( type: esriFieldTypeString, alias: SWPP Risk Level, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SWPP_Risk_Level )
• Construction_Milestones ( type: esriFieldTypeString, alias: Construction Milestones, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Construction_Milestones )
• Development_Milestones ( type: esriFieldTypeString, alias: Development Milestones (PM Section), editable: true, nullable: true, length: 500, defaultValue: null, modelName: Development_Milestones )
• Planning_Initiation_Milestones ( type: esriFieldTypeString, alias: Planning/Initiation Milestones (Engineering Section), editable: true, nullable: true, length: 500, defaultValue: null, modelName: Planning_Initiation_Milestones )
• Project_Status ( type: esriFieldTypeString, alias: Project Status, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Project_Status )
• Jan1_Jan5_18 ( type: esriFieldTypeSingle, alias: Jan 1 - Jan 5 2018, editable: true, nullable: true, defaultValue: null, modelName: Jan1_Jan5_18 )
• Jan8_Jan12_18 ( type: esriFieldTypeSingle, alias: Jan 8 - Jan 12 2018, editable: true, nullable: true, defaultValue: null, modelName: Jan8_Jan12_18 )
• Jan15_Jan19_18 ( type: esriFieldTypeSingle, alias: Jan 15 - Jan 19 2018, editable: true, nullable: true, defaultValue: null, modelName: Jan15_Jan19_18 )
• Jan22_Jan26_18 ( type: esriFieldTypeSingle, alias: Jan 22 - Jan 26 2018, editable: true, nullable: true, defaultValue: null, modelName: Jan22_Jan26_18 )
• Jan29_Feb2_18 ( type: esriFieldTypeSingle, alias: Jan 29 - Feb 2 2018, editable: true, nullable: true, defaultValue: null, modelName: Jan29_Feb2_18 )
• Feb5_Feb9_18 ( type: esriFieldTypeSingle, alias: Feb 5 - Feb 9 2018, editable: true, nullable: true, defaultValue: null, modelName: Feb5__Feb9_18 )
• Feb12_Feb16_18 ( type: esriFieldTypeSingle, alias: Feb12 - Feb 16 2018, editable: true, nullable: true, defaultValue: null, modelName: Feb12__Feb16_18 )
• Feb19_Feb23_18 ( type: esriFieldTypeSingle, alias: Feb 19 - Feb 23 2018, editable: true, nullable: true, defaultValue: null, modelName: Feb19__Feb23_18 )
• Feb26_Mar2_18 ( type: esriFieldTypeSingle, alias: Feb 26 - Mar 2 2018, editable: true, nullable: true, defaultValue: null, modelName: Feb26__Mar2_18 )
• Mar5_Mar9_18 ( type: esriFieldTypeSingle, alias: Mar 5 - Mar 9 2018, editable: true, nullable: true, defaultValue: null, modelName: Mar5_Mar9_18 )
• Mar12_Mar16_18 ( type: esriFieldTypeSingle, alias: Mar 12 - Mar 16 2018, editable: true, nullable: true, defaultValue: null, modelName: Mar12_Mar16_18 )
• Mar19_Mar23_18 ( type: esriFieldTypeSingle, alias: Mar 19 - Mar 23 2018, editable: true, nullable: true, defaultValue: null, modelName: Mar19_Mar23_18 )
• Mar26_Mar30_18 ( type: esriFieldTypeSingle, alias: Mar 26 - Mar 30 2018, editable: true, nullable: true, defaultValue: null, modelName: Mar26_Mar30_18 )
• Apr2_Apr6_18 ( type: esriFieldTypeSingle, alias: Apr 2 - Apr 6 2018, editable: true, nullable: true, defaultValue: null, modelName: Apr2_Apr6_18 )
• Apr9_Apr13_18 ( type: esriFieldTypeSingle, alias: Apr 9 - Apr 13 2018, editable: true, nullable: true, defaultValue: null, modelName: Apr9_Apr13_18 )
• Apr16_Apr20_18 ( type: esriFieldTypeSingle, alias: Apr 16 - Apr 20 2018, editable: true, nullable: true, defaultValue: null, modelName: Apr16_Apr20_18 )
• Apr23_Apr27_18 ( type: esriFieldTypeSingle, alias: Apr 23 - Apr 27 2018, editable: true, nullable: true, defaultValue: null, modelName: Apr23_Apr27_18 )
• Apr30_May4_18 ( type: esriFieldTypeSingle, alias: Apr 30 - May 4 2018, editable: true, nullable: true, defaultValue: null, modelName: Apr30_May4_18 )
• May7_May11_18 ( type: esriFieldTypeSingle, alias: May 7 - May 11 2018, editable: true, nullable: true, defaultValue: null, modelName: May7_May11_18 )
• May14_May18_18 ( type: esriFieldTypeSingle, alias: May 14 - May 18 2018, editable: true, nullable: true, defaultValue: null, modelName: May14_May18_18 )
• May21_May25_18 ( type: esriFieldTypeSingle, alias: May 21 - May 25 2018, editable: true, nullable: true, defaultValue: null, modelName: May21_May25_18 )
• May28_Jun1_18 ( type: esriFieldTypeSingle, alias: May 28 - Jun 1 2018, editable: true, nullable: true, defaultValue: null, modelName: May28_Jun1_18 )
• Jun4_Jun8_18 ( type: esriFieldTypeSingle, alias: Jun 4 - Jun 8 2018, editable: true, nullable: true, defaultValue: null, modelName: Jun4_Jun8_18 )
• Jun11_Jun15_18 ( type: esriFieldTypeSingle, alias: Jun 11 - Jun 15 2018, editable: true, nullable: true, defaultValue: null, modelName: Jun11_Jun15_18 )
• Jun18_Jun22_18 ( type: esriFieldTypeSingle, alias: Jun 18 - Jun 22 2018, editable: true, nullable: true, defaultValue: null, modelName: Jun18_Jun22_18 )
• Jun25_Jun29_18 ( type: esriFieldTypeSingle, alias: Jun 25 - Jun 29 2018, editable: true, nullable: true, defaultValue: null, modelName: Jun25_Jun29_18 )
• Jul2_Jul6_18 ( type: esriFieldTypeSingle, alias: Jul 2 - Jul 6 2018, editable: true, nullable: true, defaultValue: null, modelName: Jul2_Jul6_18 )
• Jul9_Jul13_18 ( type: esriFieldTypeSingle, alias: Jul 9 - Jul 13 2018, editable: true, nullable: true, defaultValue: null, modelName: Jul9_Jul13_18 )
• Jul16_Jul20_18 ( type: esriFieldTypeSingle, alias: Jul 16 - Jul 20 2018, editable: true, nullable: true, defaultValue: null, modelName: Jul16_Jul20_18 )
• Jul23_Jul27_18 ( type: esriFieldTypeSingle, alias: Jul 23 - Jul 27 2018, editable: true, nullable: true, defaultValue: null, modelName: Jul23_Jul27_18 )
• Jul30_Aug3_18 ( type: esriFieldTypeSingle, alias: Jul 30 - Aug 3 2018, editable: true, nullable: true, defaultValue: null, modelName: Jul30_Aug3_18 )
• Aug6_Aug10_18 ( type: esriFieldTypeSingle, alias: Aug 6 - Aug 10 2018, editable: true, nullable: true, defaultValue: null, modelName: Aug6_Aug10_18 )
• Aug13_Aug17_18 ( type: esriFieldTypeSingle, alias: Aug 13 - Aug 17 2018, editable: true, nullable: true, defaultValue: null, modelName: Aug13_Aug17_18 )
• Aug20_Aug24_18 ( type: esriFieldTypeSingle, alias: Aug 20 - Aug 24 2018, editable: true, nullable: true, defaultValue: null, modelName: Aug20_Aug24_18 )
• Aug27_Aug31_18 ( type: esriFieldTypeSingle, alias: Aug 27 - Aug 31 2018, editable: true, nullable: true, defaultValue: null, modelName: Aug27_Aug31_18 )
• Sep3_Sep7_18 ( type: esriFieldTypeSingle, alias: Sep 3 - Sep 7 2018, editable: true, nullable: true, defaultValue: null, modelName: Sep3_Sep7_18 )
• Sep10_Sep14_18 ( type: esriFieldTypeSingle, alias: Sep 10 - Sep 14 2018, editable: true, nullable: true, defaultValue: null, modelName: Sep10_Sep14_18 )
• Sep17_Sep21_18 ( type: esriFieldTypeSingle, alias: Sep 17 - Sep 21 2018, editable: true, nullable: true, defaultValue: null, modelName: Sep17_Sep21_18 )
• Sep24_Sep28_18 ( type: esriFieldTypeSingle, alias: Sep 24 - Sep 28 2018, editable: true, nullable: true, defaultValue: null, modelName: Sep24_Sep28_18 )
• Oct1_Oct5_18 ( type: esriFieldTypeSingle, alias: Oct 1 - Oct 5 2018, editable: true, nullable: true, defaultValue: null, modelName: Oct1_Oct5_18 )
• Oct8_Oct12_18 ( type: esriFieldTypeSingle, alias: Oct 8 - Oct 12 2018, editable: true, nullable: true, defaultValue: null, modelName: Oct8_Oct12_18 )
• Oct15_Oct19_18 ( type: esriFieldTypeSingle, alias: Oct 15 - Oct 19 2018, editable: true, nullable: true, defaultValue: null, modelName: Oct15_Oct19_18 )
• Oct22_Oct26_18 ( type: esriFieldTypeSingle, alias: Oct 22 - Oct 26 2018, editable: true, nullable: true, defaultValue: null, modelName: Oct22_Oct26_18 )
• Oct29_Nov2_18 ( type: esriFieldTypeSingle, alias: Oct 29 - Nov 2 2018, editable: true, nullable: true, defaultValue: null, modelName: Oct29_Nov2_18 )
• Nov5_Nov9_18 ( type: esriFieldTypeSingle, alias: Nov 5 - Nov 9 2018, editable: true, nullable: true, defaultValue: null, modelName: Nov5_Nov9_18 )
• Nov12_Nov16_18 ( type: esriFieldTypeSingle, alias: Nov 12 - Nov 16 2018, editable: true, nullable: true, defaultValue: null, modelName: Nov12_Nov16_18 )
• Nov19_Nov23_18 ( type: esriFieldTypeSingle, alias: Nov 19 - Nov 23 2018, editable: true, nullable: true, defaultValue: null, modelName: Nov19_Nov23_18 )
• Nov26_Nov30_18 ( type: esriFieldTypeSingle, alias: Nov 26 - Nov 30 2018, editable: true, nullable: true, defaultValue: null, modelName: Nov26_Nov30_18 )
• Dec3_Dec7_18 ( type: esriFieldTypeSingle, alias: Dec 3 - Dec 7 2018, editable: true, nullable: true, defaultValue: null, modelName: Dec3_Dec7_18 )
• Dec10_Dec14_18 ( type: esriFieldTypeSingle, alias: Dec 10 - Dec 14 2018, editable: true, nullable: true, defaultValue: null, modelName: Dec10_Dec14_18 )
• Dec17_Dec21_18 ( type: esriFieldTypeSingle, alias: Dec 17 - Dec 21 2018, editable: true, nullable: true, defaultValue: null, modelName: Dec17_Dec21_18 )
• Dec24_Dec28_18 ( type: esriFieldTypeSingle, alias: Dec 24 - Dec 28 2018, editable: true, nullable: true, defaultValue: null, modelName: Dec24_Dec28_18 )
• Project_Name ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Project_Name )
• Cost_1 ( type: esriFieldTypeString, alias: Cost_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Cost_1 )
• Phase ( type: esriFieldTypeSmallInteger, alias: Phase, editable: true, nullable: true, defaultValue: null, modelName: Phase , Coded Values: [1: Initial/Planning] , [2: Active Construction/Development] , [3: Closeout] , ...3 more... )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Contractor )
• Job_Code ( type: esriFieldTypeString, alias: Job_Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Job_Code )
• District_Project_Sponsor ( type: esriFieldTypeString, alias: District_Project_Sponsor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: District_Project_Sponsor )
• PM_INSP ( type: esriFieldTypeString, alias: PM_INSP, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PM_INSP )
• Active_1 ( type: esriFieldTypeSmallInteger, alias: Active_1, editable: true, nullable: false, defaultValue: 1, modelName: Active_1 , Coded Values: [0: No] , [1: Yes] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: OCConstruction.DBO.JOC_Add_Proj_Info
  Description:
  Prototype:
  last_edited_user: null
  last_edited_date: null
  Project_Number: null
  Budget_BFAST_Num: null
  Cost: null
  Fiscal_Year: null
  SWPP_Risk_Level: null
  Construction_Milestones: null
  Development_Milestones: null
  Planning_Initiation_Milestones: null
  Project_Status: null
  Jan1_Jan5_18: null
  Jan8_Jan12_18: null
  Jan15_Jan19_18: null
  Jan22_Jan26_18: null
  Jan29_Feb2_18: null
  Feb5_Feb9_18: null
  Feb12_Feb16_18: null
  Feb19_Feb23_18: null
  Feb26_Mar2_18: null
  Mar5_Mar9_18: null
  Mar12_Mar16_18: null
  Mar19_Mar23_18: null
  Mar26_Mar30_18: null
  Apr2_Apr6_18: null
  Apr9_Apr13_18: null
  Apr16_Apr20_18: null
  Apr23_Apr27_18: null
  Apr30_May4_18: null
  May7_May11_18: null
  May14_May18_18: null
  May21_May25_18: null
  May28_Jun1_18: null
  Jun4_Jun8_18: null
  Jun11_Jun15_18: null
  Jun18_Jun22_18: null
  Jun25_Jun29_18: null
  Jul2_Jul6_18: null
  Jul9_Jul13_18: null
  Jul16_Jul20_18: null
  Jul23_Jul27_18: null
  Jul30_Aug3_18: null
  Aug6_Aug10_18: null
  Aug13_Aug17_18: null
  Aug20_Aug24_18: null
  Aug27_Aug31_18: null
  Sep3_Sep7_18: null
  Sep10_Sep14_18: null
  Sep17_Sep21_18: null
  Sep24_Sep28_18: null
  Oct1_Oct5_18: null
  Oct8_Oct12_18: null
  Oct15_Oct19_18: null
  Oct22_Oct26_18: null
  Oct29_Nov2_18: null
  Nov5_Nov9_18: null
  Nov12_Nov16_18: null
  Nov19_Nov23_18: null
  Nov26_Nov30_18: null
  Dec3_Dec7_18: null
  Dec10_Dec14_18: null
  Dec17_Dec21_18: null
  Dec24_Dec28_18: null
  Project_Name: null
  Cost_1: null
  Phase: null
  Contractor: null
  Job_Code: null
  District_Project_Sponsor: null
  PM_INSP: null
  Active_1: 1
  created_user: null
  created_date: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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