Name: OCConstruction.DBO.JOC_Add_Proj_Info

Display Field: Budget_BFAST_Num

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: 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:

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

Relationships:

• JOC_Project_Updates (0) -- Related To: OCConstruction.DBO.JOC_Project_Updates (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata