Name: TEST_V1_Patient_Registration
Display Field: objectid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)
Drawing Info:
{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"TEST V1_Patient Registration","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: objectid
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
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: sqlTypeGUID, length: 38, nullable: false, editable: false)
- checkout (type: esriFieldTypeString, alias: checkout, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- registered (type: esriFieldTypeString, alias: registered, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contact (type: esriFieldTypeString, alias: In the last month, have you been in contact with omeone who was confirmed or suspected to have coronovirus/COVID-19, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No_Unsure: No/Unsure], [Unable_to_assess: Unable to assess])
- test (type: esriFieldTypeString, alias: Have you had a COVID-19 viral test in the last 14 days?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes_Positive_result: Yes-Positive result], [Yes_Pending_result: Yes-Pending result], [Yes_Negatiev_result: Yes-Negative result], ... 2 more ...)
- symptoms (type: esriFieldTypeString, alias: Do you have any of the following new or worsening symptoms?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- international (type: esriFieldTypeString, alias: Have you traveled internationally in the last month?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unable_to_assess: Unable to assess])
- location (type: esriFieldTypeString, alias: Location traveled to?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- first_name (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- last_name (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- social (type: esriFieldTypeString, alias: Social Security Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- dob (type: esriFieldTypeDate, alias: Date of Birth, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- sex (type: esriFieldTypeString, alias: Sex, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Female: Female], [Male: Male], [Unknown: Unknown])
- pt_type (type: esriFieldTypeString, alias: Are you a New or Return Patient to Harris County Public Health?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [New: New Patient], [return: Return Patient])
- address (type: esriFieldTypeString, alias: Home Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- zip (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- home_phone (type: esriFieldTypeString, alias: Home Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- mobile_phone (type: esriFieldTypeString, alias: Mobile Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- email (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- marital (type: esriFieldTypeString, alias: Marital Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Divorced: Divorced], [Life_Partner: Life Partner], [Married: Married], ... 4 more ...)
- pref_language (type: esriFieldTypeString, alias: Preferred Language, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- interpreter (type: esriFieldTypeString, alias: Need Interpreter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- religion (type: esriFieldTypeString, alias: Religion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- residency (type: esriFieldTypeString, alias: Residency Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [American_Born: American-Born in USA], [American_Citizen: American Citizen-Naturalized], [Legal_Immigrant: Legal Immigrant-Green Card], ... 3 more ...)
- country (type: esriFieldTypeString, alias: Country of Origin/Nationality, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ethnicity (type: esriFieldTypeString, alias: Ethnicity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [black: Black/African American], [cuban: Cuban], [hispanic: Hispanic/Latino], ... 6 more ...)
- race (type: esriFieldTypeString, alias: Race, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [American_Indian: American Indian], [black: Black/African American], [Chinese: Chinese], ... 14 more ...)
- military (type: esriFieldTypeString, alias: Military Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [active: Active Duty], [declined: Declined to Answer], [national: National Guard], ... 5 more ...)
- branch (type: esriFieldTypeString, alias: Branch of Service, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Air_Force: Air Force], [Army: Army], [Coast_Guard: Coast Guard], ... 3 more ...)
- employment (type: esriFieldTypeString, alias: Employment Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ft: Full Time], [no: Not Employed/School Base], [active: On Active Military Duty], ... 6 more ...)
- employer (type: esriFieldTypeString, alias: Employer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- emergency (type: esriFieldTypeString, alias: Would you like to add an emergency contact?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- first_name_ec (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- last_name_ec (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- relationship_ec (type: esriFieldTypeString, alias: Relationship to Patient, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- pri_phone_ec (type: esriFieldTypeString, alias: Primary Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- interpreter2_ec (type: esriFieldTypeString, alias: Interpreter Needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- guardian_ec (type: esriFieldTypeString, alias: Legal Guardian, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- notify_ec (type: esriFieldTypeString, alias: Notify on Admission, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- same_ec (type: esriFieldTypeString, alias: Same Household, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- minor (type: esriFieldTypeString, alias: Is patient a minor (under 18 years of age)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- responsible (type: esriFieldTypeString, alias: Who is responsible for this guarantor account?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [mother: Mother], [father: Father], [spouse: Spouse])
- gua_name (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- gua_last (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- gua_social (type: esriFieldTypeString, alias: Social Security Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- gua_sex (type: esriFieldTypeString, alias: Sex, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Female: Female], [Male: Male], [Unknown: Unknown])
- gua_dob (type: esriFieldTypeDate, alias: Date of Birth, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- gua_phone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- cov (type: esriFieldTypeString, alias: Medical Coverage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Medicaid: Medicaid], [Medicare: Medicare], [Family_Planning: Family Planning], ... 2 more ...)
- family_size (type: esriFieldTypeString, alias: Family Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- income (type: esriFieldTypeString, alias: Annual Income, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- event (type: esriFieldTypeString, alias: Preferred Appointment Event, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- appt_date (type: esriFieldTypeDate, alias: Preferred Appointment Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- appt_time (type: esriFieldTypeString, alias: Preferred Appointment Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- comments (type: esriFieldTypeString, alias: Comments, 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)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/22/2020 5:35:50 PM
Schema Last Edit Date: 10/22/2020 5:35:50 PM
Data Last Edit Date: 10/22/2020 5:35:50 PM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat