Tables:

Table: WisaardSignUp (0)

Name: WisaardSignUp

Display Field: firstname

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 302c51ed685942a1bd4108abaac99a74

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• firstname ( type: esriFieldTypeString, alias: First Name, length: 250 )
• middlename ( type: esriFieldTypeString, alias: Middle Name, length: 250 )
• lastname ( type: esriFieldTypeString, alias: Last Name, length: 250 )
• phonenumber ( type: esriFieldTypeString, alias: Phone Number, length: 15 )
• emailaddress ( type: esriFieldTypeString, alias: Email, length: 250 )
• secondaryemailaddress ( type: esriFieldTypeString, alias: Email, length: 250 )
• sawname ( type: esriFieldTypeString, alias: SAW Name, length: 250 )
• archaeology_access ( type: esriFieldTypeString, alias: Archaeology Access, length: 3 , Coded Values: [yes: Yes] , [no: No] )
• archaeology_access_qual ( type: esriFieldTypeString, alias: Qualifications for Archaeology Access, length: 255 )
• previous_access ( type: esriFieldTypeString, alias: Previous Access, length: 3 , Coded Values: [yes: Yes] , [no: No] )
• ez2_access ( type: esriFieldTypeString, alias: EZ2 Access, length: 3 , Coded Values: [yes: Yes] , [no: No] )
• status ( type: esriFieldTypeString, alias: status, length: 50 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 128 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 128 )
• person_id ( type: esriFieldTypeInteger, alias: Person ID )
• org1_new ( type: esriFieldTypeString, alias: New Primary Orgainzation, length: 255 )
• org2_new ( type: esriFieldTypeString, alias: New Secondary Organization, length: 255 )
• organization1 ( type: esriFieldTypeInteger, alias: organization1 )
• organization2 ( type: esriFieldTypeInteger, alias: organization2 )
• archaeology_access_qual_pro ( type: esriFieldTypeInteger, alias: archaeology_access_qual_pro , Coded Values: [1: Yes] , [0: No] )
• archaeology_access_qual_tribe ( type: esriFieldTypeInteger, alias: archaeology_access_qual_tribe )
• archaeology_access_qual_sec ( type: esriFieldTypeInteger, alias: archaeology_access_qual_sec )
• archaeology_access_qual_106 ( type: esriFieldTypeInteger, alias: archaeology_access_qual_106 )
• archaeology_access_qual_ba ( type: esriFieldTypeInteger, alias: archaeology_access_qual_ba )
• archaeology_access_qual_m ( type: esriFieldTypeInteger, alias: archaeology_access_qual_m )
• archaeology_access_qual_s ( type: esriFieldTypeInteger, alias: archaeology_access_qual_s )
• archaeology_access_qual_r ( type: esriFieldTypeInteger, alias: archaeology_access_qual_r )

Relationships:

• (0) -- Related To: WisaardSignUpRequestDetails (1)

Table: WisaardSignUpRequestDetails (1)

Name: WisaardSignUpRequestDetails

Display Field: request_status

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 302c51ed685942a1bd4108abaac99a74

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• request_status ( type: esriFieldTypeString, alias: Request Status, length: 50 , Coded Values: [1: Asked for archaeology no paperwork] , [2: Archaeology, expired agreement] , [3: Archaeology complete] , ...5 more... )
• request_notes ( type: esriFieldTypeString, alias: Notes, length: 1000 )
• request_date ( type: esriFieldTypeDate, alias: Request Date, length: 8 )
• parentglobalid ( type: esriFieldTypeGUID, alias: ParentGlobalID, length: 38 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 128 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 128 )

Relationships:

• (0) -- Related To: WisaardSignUp (0)