All Layers and Tables (service_76796a833f2a4999a2378d23ae63870a)

Layers:

Layer: ProjectTracking (0)

Name:

Display Field:

Type:

Geometry Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[255,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
logo (type: esriFieldTypeString, alias: logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
header (type: esriFieldTypeString, alias: Project Tracking, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_name (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
scdot_pin (type: esriFieldTypeString, alias: SCDOT PIN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
contract_id (type: esriFieldTypeString, alias: Contract ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_lat (type: esriFieldTypeDouble, alias: Latitude of Project Center Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
project_long (type: esriFieldTypeDouble, alias: Longitude of Project Center Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
subregion (type: esriFieldTypeString, alias: subregion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
county (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
district (type: esriFieldTypeInteger, alias: District, SQL Type: sqlTypeOther, nullable: true, editable: true)
scdot_rce (type: esriFieldTypeString, alias: SCDOT RCE Representative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
other_rce (type: esriFieldTypeString, alias: Other RCE Representative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [emergency: Emergency Project], [safety: Safety Project], [interstate: Interstate Upgrades/Widening], ... 3 more ...)
initial_date (type: esriFieldTypeDate, alias: Initial Letting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
revisied_date (type: esriFieldTypeDate, alias: Revised Letting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
scdot_issue (type: esriFieldTypeString, alias: Issue(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
notes_issue (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 1000000000, nullable: true, editable: true)
issue_summary (type: esriFieldTypeString, alias: Summary, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
issue_resolved (type: esriFieldTypeString, alias: Issue(s) Resolved?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Not Applicable])
review_date (type: esriFieldTypeDate, alias: Latest Review Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
checklist_complete (type: esriFieldTypeString, alias: Checklist Complete?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [quick: Quick Review], [partial: Partial], ... 1 more ...)
actual_date (type: esriFieldTypeDate, alias: Actual Letting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
usace_ace (type: esriFieldTypeString, alias: USACE Permit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Pending])
expiration_date (type: esriFieldTypeDate, alias: USACE Permit Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
us_ace (type: esriFieldTypeString, alias: USACE Permit Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [gp: GP], [nwp: NWP], [ip: IP])
usace_nav (type: esriFieldTypeString, alias: Navigational Permit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [pending: Pending], ... 1 more ...)
nav_date (type: esriFieldTypeDate, alias: Navigational Permit Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
us_nav (type: esriFieldTypeString, alias: Navigational Permit Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [scdhec: DES], [uscg: USCG])
usace_nepa (type: esriFieldTypeString, alias: NEPA Document?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [pending: Pending], ... 1 more ...)
nepa_date (type: esriFieldTypeDate, alias: NEPA Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
us_nepa (type: esriFieldTypeString, alias: NEPA Document Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ce: CE], [ea: EA/FONSI], [rod: ROD])
credit_complete (type: esriFieldTypeString, alias: Mitigation Credits Complete?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Not Applicable])
monitoring_required (type: esriFieldTypeString, alias: Compliance Monitoring Required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [pending: Pending], ... 1 more ...)
commitment_log (type: esriFieldTypeString, alias: Commitment Log Completed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: Not Applicable])
precon_date (type: esriFieldTypeDate, alias: Pre-construction Meeting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
contractor (type: esriFieldTypeString, alias: Prime Contractor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
visits (type: esriFieldTypeString, alias: USDA visits required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
project_status (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [precons: Pre-Construction], [active: Active (In Construction)], [near: Near Completion], ... 2 more ...)
usace_phase (type: esriFieldTypeString, alias: Phase and USACE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [both: Both], ... 1 more ...)
dot_consultant (type: esriFieldTypeString, alias: Name of the Consultant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [caitlanb: Caitlan Bell], [wadeb: Wade Biltoft], [codyc: Cody Conner], ... 12 more ...)
consultant_email (type: esriFieldTypeString, alias: Email of the Consultant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
dot_staff (type: esriFieldTypeString, alias: SCDOT Compliance Staff, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [chrisn: Chris Neely], [jessicak: Jessica Kennedy], [michaelj: Michael Queen])
email (type: esriFieldTypeString, alias: Email of the SCDOT Compliance Staff, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
links (type: esriFieldTypeString, alias: Please list the links for the ProjectWise, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
funding_source (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [federal: Federal], [state: State], [ctc: CTC], ... 1 more ...)
site_visit (type: esriFieldTypeDate, alias: Date of Last ESO Site Visit, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
second_pin (type: esriFieldTypeString, alias: Secondary PIN (if applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
initial_letting_date (type: esriFieldTypeDate, alias: Initial Letting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
revised_letting_date (type: esriFieldTypeDate, alias: Revised Letting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
actual_letting_date (type: esriFieldTypeDate, alias: Actual Letting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
latest_review_date (type: esriFieldTypeDate, alias: Latest Review Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
checklist_status (type: esriFieldTypeString, alias: Checklist Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
project_phase (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Relationships:

stop_work_order (0) -- Related To: stop_work_order (1)
(1) -- Related To: take_note (2)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

stop_work_order (1)

Name:

Display Field:

Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
stop_work_number (type: esriFieldTypeString, alias: stop_work_number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
repeat_label (type: esriFieldTypeString, alias: Stop Work, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
begin_date (type: esriFieldTypeDate, alias: Begin Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
end_date (type: esriFieldTypeDate, alias: End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
total_days (type: esriFieldTypeString, alias: Total Days of Work Stoppage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
des_stoppage (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Relationships:

ProjectTracking (0) -- Related To: ProjectTracking (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

take_note (2)

Name:

Display Field:

Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 1000000000, nullable: true, editable: true)
dates (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Relationships:

(1) -- Related To: ProjectTracking (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: