Layers:

Layer: ROW_Submittal_Master_v3 (0)

Name: ROW_Submittal_Master_v3

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0e2320903e624dffbe52810716aca1e9

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
XMin: -180.0
YMin: -90.0
XMax: 180.0
YMax: 90.0
Spatial Reference: 4326  (0)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 0, 255] Width: 1
Label: ROW Submittal Master v3
Description: Survey Data Locations
Transparency: 0
Labeling Info:
Feature Draw Order:
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
• projname ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Project Name, type: esriFieldTypeString )
• projno ( nullable: true, editable: true, defaultValue: null, length: 30, alias: Project Number, type: esriFieldTypeString )
• pin ( nullable: true, editable: true, defaultValue: null, length: 7, alias: PIN, type: esriFieldTypeString )
• summaryno ( nullable: true, editable: true, defaultValue: null, alias: Summary Number, type: esriFieldTypeInteger )
• summarytype ( nullable: true, editable: true, defaultValue: null, length: 15, alias: Summary Type, type: esriFieldTypeString , Coded Values: [Partial: Partial] , [Final: Final] , [Supplemental: Supplemental] , ...1 more... )
• numparcels ( nullable: true, editable: true, defaultValue: null, alias: Number of Parcels, type: esriFieldTypeInteger )
• designerfirm ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Designer Firm, type: esriFieldTypeString )
• originatoremail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Your Email, type: esriFieldTypeString )
• originatorname ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Originator Name, type: esriFieldTypeString )
• regionno ( nullable: true, editable: true, defaultValue: null, length: 1, alias: Region, type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• regionreview ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Region Review, type: esriFieldTypeString , Coded Values: [Region: Region] , [Consultant: Consultant] )
• consultrevfirmname ( nullable: true, editable: true, defaultValue: null, length: 150, alias: Enter Consultant Reviewer Firm Name, type: esriFieldTypeString )
• consultrevname ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Name of Consultant Reviewer, type: esriFieldTypeString )
• consultrevemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Email of Consultant Reviewer, type: esriFieldTypeString )
• carboncopy ( nullable: true, editable: true, defaultValue: null, length: 400, alias: Carbon Copy Emails, type: esriFieldTypeString )
• pmemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Project Manager Email, type: esriFieldTypeString )
• centralemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Central ROW Lead Agent Email, type: esriFieldTypeString )
• conformityemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Conformity Reviewer Email, type: esriFieldTypeString )
• pwlink ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Projectwise Link, type: esriFieldTypeString )
• subcommentsflat ( nullable: true, editable: true, defaultValue: null, length: 3000, alias: Comments for Submittal, type: esriFieldTypeString )
• origsubmittaldatetime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date and Time of Original Submittal, type: esriFieldTypeDate )
• approvedrejectedflat ( nullable: true, editable: true, defaultValue: null, length: 8, alias: Approved or Rejected, type: esriFieldTypeString , Coded Values: [Approved: Approved] , [Upload: Upload] , [Rejected: Rejected] )
• approvcommentsflat ( nullable: true, editable: true, defaultValue: null, length: 3000, alias: Approval or Rejection Comments, type: esriFieldTypeString )
• resubcommentsflat ( nullable: true, editable: true, defaultValue: null, length: 3000, alias: Comments for Resubmission, type: esriFieldTypeString )
• status ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Status, type: esriFieldTypeString , Coded Values: [Acquisition: Acquisition] , [Consultant Submitted, Initial Region Review: Consultant Submitted, Initial Region Review] , [Consultant Re-submitted, Conformity Review: Consultant Re-submitted, Conformity Review] , ...18 more... )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• preconformityemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Pre-conformity Reviewer Email Address, type: esriFieldTypeString )
• postconformityemail ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Post-conformity Reviewer Email Address, type: esriFieldTypeString )
• reviewlink ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Link to Review Page, type: esriFieldTypeString )
• numownerships ( nullable: true, editable: true, defaultValue: null, alias: Number of Ownerships, type: esriFieldTypeInteger )
• daysincelaststatuschg ( nullable: true, editable: true, defaultValue: null, alias: Days Since Sent to You, type: esriFieldTypeInteger )
• lststatuschgdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Status Change Date, type: esriFieldTypeDate )
• completesumlink ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Link to Complete Summary in ProjectWise, type: esriFieldTypeString )
• conformrevlink ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Link to Assign Conformity Reviewer, type: esriFieldTypeString )
• rejectionreason ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Reason for Rejection, type: esriFieldTypeString )
• regionemail ( nullable: true, editable: true, defaultValue: null, length: 2000, alias: Region Reviewer's Email Address, type: esriFieldTypeString )
• toemail ( nullable: true, editable: true, defaultValue: null, length: 2000, alias: Receiver Email, type: esriFieldTypeString )
• resublink ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Resubmittal Link, type: esriFieldTypeString )
Templates:
• Name: New Feature
  Description:
  Prototype:
  daysincelaststatuschg: null
  rejectionreason: null
  numownerships: null
  reviewlink: null
  completesumlink: null
  regionemail: null
  preconformityemail: null
  conformrevlink: null
  postconformityemail: null
  lststatuschgdate: null
  toemail: null
  
  Drawing Tool: N/A

Relationships:

• ROW_Submittal_Master_v3_approvals (0) -- Related To: approvals (1)
• ROW_Submittal_Master_v3_resubmissions (1) -- Related To: resubmissions (2)
• ROW_Submittal_Master_v3_statustrack (2) -- Related To: statustrack (3)

Tables:

Table: approvals (1)

Name: approvals

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 0e2320903e624dffbe52810716aca1e9

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

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
Feature Draw Order:
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: 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
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:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• approvedrejected ( nullable: true, editable: true, defaultValue: null, length: 8, alias: Approved or Rejected, type: esriFieldTypeString )
• apprejcomments ( nullable: true, editable: true, defaultValue: null, length: 3000, alias: Comments, type: esriFieldTypeString )
• apprejname ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Name of Approver, type: esriFieldTypeString )
• apprejdatetime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date and Time of Approval/Rejection, type: esriFieldTypeDate )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• rejectionreason ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Reason for Rejection, type: esriFieldTypeString )

Relationships:

• ROW_Submittal_Master_v3_approvals (0) -- Related To: ROW_Submittal_Master_v3 (0)

Table: resubmissions (2)

Name: resubmissions

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 0e2320903e624dffbe52810716aca1e9

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

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
Feature Draw Order:
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: 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
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:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• resubmittalcomments ( nullable: true, editable: true, defaultValue: null, length: 3000, alias: Comments with Resubmission, type: esriFieldTypeString )
• resubdatetime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date and Time of Resubmission, type: esriFieldTypeDate )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• resubname ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Name of Resubmitter, type: esriFieldTypeString )

Relationships:

• ROW_Submittal_Master_v3_resubmissions (1) -- Related To: ROW_Submittal_Master_v3 (0)

Table: statustrack (3)

Name: statustrack

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 0e2320903e624dffbe52810716aca1e9

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

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
Feature Draw Order:
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: 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
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:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• statusname ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Status Name, type: esriFieldTypeString )
• comments ( nullable: true, editable: true, defaultValue: null, length: 3000, alias: Comments, type: esriFieldTypeString )
• statusdatetime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Status Assignment Date and Time, type: esriFieldTypeDate )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• rreviewdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Region Review, type: esriFieldTypeInteger )
• precreviewdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Pre-conformity Review, type: esriFieldTypeInteger )
• ccreviewdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Central Conformity Review, type: esriFieldTypeInteger )
• pocreview ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Post-conformity Review, type: esriFieldTypeInteger )
• resubdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Resubmittal, type: esriFieldTypeInteger )
• username ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Name of User Who Submitted the Review or Submittal, type: esriFieldTypeString )
• conrreviewdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Consultant Region Review, type: esriFieldTypeInteger )
• concreviewdays ( nullable: true, editable: true, defaultValue: null, alias: Number of Days for Consultant Conformity Review, type: esriFieldTypeInteger )

Relationships:

• ROW_Submittal_Master_v3_statustrack (2) -- Related To: ROW_Submittal_Master_v3 (0)