Name: HIV_Reporting_Form

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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":"HIV Case Investigation Form","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:

Name : objectid

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)
• logo (type: esriFieldTypeString, alias: logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• form_name (type: esriFieldTypeString, alias: Welcome to the HIV/AIDS Confidential Reporting Form, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SurveyID (type: esriFieldTypeString, alias: Please enter your notification form credentials, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ID_Ref (type: esriFieldTypeString, alias: ID_Ref, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• welcome (type: esriFieldTypeString, alias: Success!. You now have access to the entire HIV/AIDS Confidential Reporting Form. Please click Next to continue. , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• recordID (type: esriFieldTypeString, alias: RecordID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date1 (type: esriFieldTypeDate, alias: Date of Report, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• notifierFirstName (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• notifierLastName (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• notifierPhone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• laboratoryName (type: esriFieldTypeString, alias: Name of Reporting Facility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AndrewsMemorialLaboratory: Andrews Memorial Laboratory], [BaywestWellnessClinic: Baywest Wellness Clinic], [BaywestWellnessHospital: Baywest Wellness Hospital], ... 35 more ...)
• laboratoryName_other (type: esriFieldTypeString, alias: Specify other., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• username (type: esriFieldTypeString, alias: username, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• signed_in_user (type: esriFieldTypeString, alias: Signed in username, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email1 (type: esriFieldTypeString, alias: email1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• signed_in_email (type: esriFieldTypeString, alias: Signed in email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• otherFacility (type: esriFieldTypeString, alias: Enter Name of Lab, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• patientID_Type (type: esriFieldTypeString, alias: Patient's ID Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [driverslicense: Drivers License], [medical_number: Medical Record Number], [passport: Passport], ... 1 more ...)
• patientID (type: esriFieldTypeString, alias: Patient's ID Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• firstName (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastName (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• middleName (type: esriFieldTypeString, alias: Middle Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• petName (type: esriFieldTypeString, alias: Pet Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sex (type: esriFieldTypeString, alias: Sex at Birth, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [sexMale: Male], [sexFemale: Female])
• gender (type: esriFieldTypeString, alias: Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [genderMale: Male], [genderFemale: Female], [MoMFTransgender: Female to Male Transgender], ... 2 more ...)
• genderOther (type: esriFieldTypeString, alias: If Other, Specify, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• birthdate (type: esriFieldTypeDate, alias: Date of Birth, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• age1 (type: esriFieldTypeString, alias: age1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• age2 (type: esriFieldTypeString, alias: age2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• age_years (type: esriFieldTypeString, alias: age_years, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• age_months (type: esriFieldTypeString, alias: age_months, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pregnant (type: esriFieldTypeString, alias: Is patient pregnant?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• gestational_age (type: esriFieldTypeInteger, alias: Estimated gestational age (weeks), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Estimated_date_delivery (type: esriFieldTypeDate, alias: Estimated date of delivery, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• clinic_site (type: esriFieldTypeString, alias: Clinic Site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parishes_HIVpregnant (type: esriFieldTypeString, alias: Confirm Parish, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [clarendon: Clarendon], [hanover: Hanover], [kingston: Kingston], ... 11 more ...)
• Clinic_MRN (type: esriFieldTypeString, alias: Clinic MRN Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Facilityreferred (type: esriFieldTypeString, alias: Referred Facility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_of_referral_appointment (type: esriFieldTypeDate, alias: Date of referral appointment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Post_test_counselling (type: esriFieldTypeString, alias: Post Test Counsellor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_Post_test_counselling (type: esriFieldTypeDate, alias: Date of Post Test Counselling, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• occupation (type: esriFieldTypeString, alias: Occupation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [airline_worker: Airline worker], [carehome: Care home/institution], [cruise_ship_worker: Cruise ship worker], ... 18 more ...)
• marital_status (type: esriFieldTypeString, alias: Marital Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [legally_married: Legally married], [common_law: Common law], [visiting_union: Visiting union], ... 1 more ...)
• countryofResidence (type: esriFieldTypeString, alias: Country of Residence, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Jamaica: Jamaica], [usa: United States of America], [uk: United Kingdom], ... 246 more ...)
• parishes (type: esriFieldTypeString, alias: Parish of Residence in Jamaica, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [clarendon: Clarendon], [hanover: Hanover], [kingston: Kingston], ... 11 more ...)
• communities (type: esriFieldTypeString, alias: Name of community in parish where patient lives?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• latitude (type: esriFieldTypeString, alias: latitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• longitude (type: esriFieldTypeString, alias: longitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• community_lat (type: esriFieldTypeString, alias: community_lat, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• community_long (type: esriFieldTypeString, alias: community_long, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address1 (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address_latitude (type: esriFieldTypeString, alias: address_latitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address_Longitude (type: esriFieldTypeString, alias: address_Longitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• homeless (type: esriFieldTypeString, alias: If full address isn't provided, is patient homeless?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• phone (type: esriFieldTypeString, alias: Patient's Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• highestEducation (type: esriFieldTypeString, alias: Highest Level of Education (Completed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_formal_schooling: No formal schooling], [Basic: Basic], [Primary_AllAge: Primary/All Age], ... 4 more ...)
• educationOther (type: esriFieldTypeString, alias: Specify your education type., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• numberOfChildren (type: esriFieldTypeInteger, alias: Number of children under 15 years of age?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deported (type: esriFieldTypeString, alias: Were you ever deported?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• country (type: esriFieldTypeString, alias: Which country were you deported from?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [usa: United States of America], [uk: United Kingdom], [Canada: Canada], ... 245 more ...)
• kinFirstName (type: esriFieldTypeString, alias: Emergency Contact's First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• kinLastName (type: esriFieldTypeString, alias: Emergency Contact's Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nextofKin (type: esriFieldTypeString, alias: Relationship to Emergency Contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Mother: Mother], [Father: Father], [Brother: Brother], ... 6 more ...)
• kinPhone (type: esriFieldTypeString, alias: Emergency Contact's Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• kinEmail (type: esriFieldTypeString, alias: Emergency Contact's Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BloodtransfusionEver (type: esriFieldTypeString, alias: Did patient ever have a blood transfusion?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• BloodtransfusionLastYear (type: esriFieldTypeString, alias: Did patient have a blood transfusion in the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Crack_Cocaine_hospital (type: esriFieldTypeString, alias: Has patient ever used crack/cocaine?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Crack_Cocaine_Ever (type: esriFieldTypeString, alias: Has patient used crack/cocaine during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• intravenousdrug_ever (type: esriFieldTypeString, alias: Has patient ever used intravenous drugs?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Intravenousdrug_lastYear (type: esriFieldTypeString, alias: Has patient used Intravenous drugs in the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Sex_TransmittedInfection_ever (type: esriFieldTypeString, alias: Has patient ever had a sexually transmitted infection?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Sex_TransmittedInfection_lastyear (type: esriFieldTypeString, alias: Has patient had a sexually transmitted infection during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Genital_Ulcers_sores_ever (type: esriFieldTypeString, alias: Has patient ever had genital/ulcer sores?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Genital_Ulcers_sores_lastyear (type: esriFieldTypeString, alias: Has patient had genital/ulcer sores during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Sex_with_CSW_ever (type: esriFieldTypeString, alias: Has patient ever had sex with a commercial sex worker (CSW)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Sex_with_CSW_lastyear (type: esriFieldTypeString, alias: Has patient had sex with a CSW during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• csw_ever (type: esriFieldTypeString, alias: Has patient ever been a commercial sex worker?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• csw_lastyear (type: esriFieldTypeString, alias: Was patient a commercial worker during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• unprotectedanalsex_ever (type: esriFieldTypeString, alias: Has patient ever had unprotected anal sex?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• unprotectedanalsex_lastyear (type: esriFieldTypeString, alias: Did patient have unprotected anal sex during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• multiplepartners_ever (type: esriFieldTypeString, alias: Has patient ever had multiple sex partners?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• multiple_partners_lastyear (type: esriFieldTypeString, alias: Has patient had multiple partners during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• everinprison_ever (type: esriFieldTypeString, alias: Was patient ever imprisoned?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• everinprison_lastyear (type: esriFieldTypeString, alias: Was patient imprisoned during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• victim_of_sexual_assault_ever (type: esriFieldTypeString, alias: Was patient ever a victim of sexual assault?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• victim_of_sexual_assault_lastyear (type: esriFieldTypeString, alias: Was patient a victim of sexual assault during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• sexknownPLHIV_ever (type: esriFieldTypeString, alias: Has patient ever had sex with a known person living with HIV (PLHIV)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• sexknownPLHIV_lastyear (type: esriFieldTypeString, alias: Did patient have sex with a known PLHIV during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• transactionalsex_ever (type: esriFieldTypeString, alias: Has patient ever had a sexually transmitted infection?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• transactionalsex_lastyear (type: esriFieldTypeString, alias: Did patient have a sexually transmitted infection during the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• perinatalexposuretoHIV_ever (type: esriFieldTypeString, alias: Did patient have prenatal exposure to HIV?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• perinatalexposuretoHIV_lastyear (type: esriFieldTypeString, alias: Did patient had prenatal exposure to HIV during last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• clinical_status_date (type: esriFieldTypeDate, alias: Date of Clinical Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reportType (type: esriFieldTypeString, alias: Diagnosis, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [InitialHIVDiagnosis: Initial HIV Diagnosis], [ARTInitiation: ART Initiation], [Pregnancy_HIV_Woman: Pregnancy of HIV+ Woman], ... 3 more ...)
• weightloss (type: esriFieldTypeString, alias: Has patient experienced involuntary weight loss of less than 10% of body weight?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• cough (type: esriFieldTypeString, alias: Has patient experienced persistent cough for more than 4 weeks?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fever (type: esriFieldTypeString, alias: Has patient experienced fever for more than one month?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• PCP (type: esriFieldTypeString, alias: Has patient experienced PCP?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Recurrent_Pneumonia (type: esriFieldTypeString, alias: Has patient experienced recurrent pneumonia?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Tuberculosis (type: esriFieldTypeString, alias: Does patient have tuberculosis?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Pulmonary (type: esriFieldTypeString, alias: Does patient have pulmonary tubercolosis?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ExtraPulmonary (type: esriFieldTypeString, alias: Does patient have extra pulmonary / disseminated?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• CNS_involvement (type: esriFieldTypeString, alias: Does patient have episodes of CNS involvement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• severe_bacterial_infection (type: esriFieldTypeString, alias: Does patient have severe bacterial Infection?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• bacterial_infection_specify (type: esriFieldTypeString, alias: If yes, specify, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Gen_Dermatitis (type: esriFieldTypeString, alias: Does patient have Gen. Dermatitis?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Diarrhoea (type: esriFieldTypeString, alias: Does patient have diarrhoea?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Kaposi_Sarcoma (type: esriFieldTypeString, alias: Does patient have Kaposi's Sarcoma?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Shingles (type: esriFieldTypeString, alias: Does patient have shingles?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• candidiasis (type: esriFieldTypeString, alias: Does patient have candidiasis?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• candidiasis_type (type: esriFieldTypeString, alias: What type of candidiasis does patient have?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Candidiasis_oral: Oral Candidiasis], [Candidiasis_Oesophageal: Oesophageal Candidiasis], [Candidiasis_Vaginal: Vaginal Candidiasis])
• Invasive_cervical_cancer (type: esriFieldTypeString, alias: Does patient have Invasive cervical cancer?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Chronic_Herpes (type: esriFieldTypeString, alias: Does patient have chronic herpes simplex that is more than 1 month?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• HIVScreeningdate (type: esriFieldTypeDate, alias: Date of Test, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HIV_TestType (type: esriFieldTypeString, alias: HIV Test Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [rapid_self_tests: Rapid Self Test], [mail-in self-tests: Mail-in Self Tests])
• how_was_test_Initiated (type: esriFieldTypeString, alias: How was test initiated?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Provider _Initiated: Provider Initiated], [Self_referral: Self-referral])
• location_of_test (type: esriFieldTypeString, alias: Where was test done?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Homebased_self-test: Homebased/self-test], [Antenatal_Clinic: Antenatal Clinic], [PrivateAntenatal: Private Antenatal], ... 9 more ...)
• location_of_test_Other_Specify (type: esriFieldTypeString, alias: If other, please specify, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• screeningTestResults (type: esriFieldTypeString, alias: HIV Screening Test Results, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [hiv_screening_positive: Positive], [hiv_screening_negative: Negative])
• confirmatoryHIVTestDate (type: esriFieldTypeDate, alias: Confirmatory HIV Test Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• confimatory_hiv_testtype (type: esriFieldTypeString, alias: Confirmatory HIV Test Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [nucleic_acid_tests: Nucleic Acid Tests (NAT)], [antigen_antibody_tests: Antigen/ Antibody Tests], [antibody_tests: Antibody Tests])
• ConfirmatoryHIVResult (type: esriFieldTypeString, alias: Confirmatory HIV Test Result, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ConfirmatoryHIVResult_Positive: Positive], [ConfirmatoryHIVResult_Negative: Negative])
• CD4_count (type: esriFieldTypeInteger, alias: CD4 Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CD4_CD8_ratio (type: esriFieldTypeInteger, alias: CD4/CD8 Ratio, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Date_of_CD4count (type: esriFieldTypeDate, alias: Date of CD4 Count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Viral_Load (type: esriFieldTypeInteger, alias: Viral Load, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Date_Viral_Load (type: esriFieldTypeDate, alias: Date of Viral Load, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EVER_TAKEN_ARVs (type: esriFieldTypeString, alias: Ever Taken ARVs?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ARVStartDate (type: esriFieldTypeDate, alias: ARV Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PreP_LastDate (type: esriFieldTypeDate, alias: Prep Last Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ARVLine (type: esriFieldTypeString, alias: ARV Line, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1stline: 1st Line], [2ndline: 2nd Line], [Salvagetherapy: Salvage Therapy], ... 1 more ...)
• currentStatusofPT (type: esriFieldTypeString, alias: Current Status of Patient, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [HIV: HIV], [Advanced_HIV: Advanced HIV (CD4 count 201 –350)], [AIDS: AIDS], ... 1 more ...)
• date_of_onset_symptons (type: esriFieldTypeDate, alias: Date of Onset of Symptons, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_diagnosed_as_Advanced_HIV_AIDS (type: esriFieldTypeDate, alias: Date Diagnosed as Advanced HIV/AIDS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HIVDate_of_Death (type: esriFieldTypeDate, alias: Date of Death, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HIVCause_of_Death (type: esriFieldTypeString, alias: Cause of Death, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sex_partner_gender (type: esriFieldTypeString, alias: With whom does patient have sex?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Men_only: Men only], [Women_only: Women only], [men_and_women: Both men and women], ... 1 more ...)
• keyPopulationCharacteristics (type: esriFieldTypeString, alias: Key Population Characteristics of Patient (check all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tramsmission_category (type: esriFieldTypeString, alias: Tramsmission Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• end_of_survey (type: esriFieldTypeString, alias: End of Survey , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• mo_comments (type: esriFieldTypeString, alias: mo_comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_status (type: esriFieldTypeString, alias: report_status, 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:

Attributes:

Relationships:

• HIV_Case_Investigation_Form_sexualContacts (1) -- Related To: sexualContacts (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/18/2021 9:49:21 PM

Schema Last Edit Date: 10/18/2021 9:49:21 PM

Data Last Edit Date: 10/18/2021 9:49:21 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat