All Layers and Tables (Hosted/service_332715ceffba429394aafd866581671b)

Layers:

Layer: Referral_Repeats (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
confirmation_understanding ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Under California State Law (Health and Safety Code Sections 7100 and 7103), it is the responsibility of the deceased's relatives to arrange for the disposition of the remains. The San Bernardino County Sheriff-Coroner Indigent Interment Program is intended for individuals who have no family, have been abandoned, or whose families face financial hardship and cannot manage the disposition. By requesting or allowing the County to take responsibility, the Next-of-Kin gives up their legal rights to make decisions regarding the disposition. By clicking the 'YES' below, you confirm that you understand the above information., type: esriFieldTypeString , Coded Values: [YES: YES] )
curr_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Name, type: esriFieldTypeString )
curr_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Where is the current location of the remains?, type: esriFieldTypeString , Coded Values: [HOSPITAL: HOSPITAL] , [MORTUARY: MORTUARY] , [FACILITY: FACILITY] , ...2 more... )
curr_phone ( nullable: true, editable: true, defaultValue: null, length: 15, alias: Phone, type: esriFieldTypeString )
deced_first ( nullable: true, editable: true, defaultValue: null, length: 255, alias: First, type: esriFieldTypeString )
deced_middle ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Middle, type: esriFieldTypeString )
deced_last ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Last, type: esriFieldTypeString )
deced_aka ( nullable: true, editable: true, defaultValue: null, length: 255, alias: AKA, type: esriFieldTypeString )
deced_ss ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Social Security Number, type: esriFieldTypeString )
deced_sex ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sex, type: esriFieldTypeString , Coded Values: [MALE: MALE] , [FEMALE: FEMALE] , [UNKNOWN: UNKNOWN] )
deced_age ( nullable: true, editable: true, defaultValue: null, alias: Age, type: esriFieldTypeInteger )
deced_dob ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Date of Birth, type: esriFieldTypeDate )
deced_military ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Military Status, type: esriFieldTypeString )
deced_dl_num ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Driver's License #, type: esriFieldTypeString )
deced_dl_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Driver's License State, type: esriFieldTypeString , Coded Values: [AL: ALABAMA] , [AK: ALASKA] , [AZ: ARIZONA] , ...56 more... )
deced_dod ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Date and Time of Death, type: esriFieldTypeDate )
deced_pod_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Place of Death (POD) Address, type: esriFieldTypeString )
deced_pod_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: POD City, type: esriFieldTypeString )
deced_pod_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: POD State, type: esriFieldTypeString )
deced_pod_zip ( nullable: true, editable: true, defaultValue: null, length: 255, alias: POD Zip Code, type: esriFieldTypeString )
deced_ms ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Marital Status, type: esriFieldTypeString , Coded Values: [MARRIED: MARRIED] , [NEVER MARRIED: NEVER MARRIED] , [DIVORCED: DIVORCED] , ...3 more... )
deced_ms_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: What 'OTHER" marital status?, type: esriFieldTypeString )
deced_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Decedent's Address, type: esriFieldTypeString )
deced_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: City, type: esriFieldTypeString )
deced_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: State, type: esriFieldTypeString , Coded Values: [AL: ALABAMA] , [AK: ALASKA] , [AZ: ARIZONA] , ...56 more... )
deced_zip ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Zip, type: esriFieldTypeString )
deced_county ( nullable: true, editable: true, defaultValue: null, length: 255, alias: County, type: esriFieldTypeString )
deced_phone ( nullable: true, editable: true, defaultValue: null, length: 15, alias: Phone, type: esriFieldTypeString )
deced_identify ( nullable: true, editable: true, defaultValue: null, length: 255, alias: How did you identify the decedent?, type: esriFieldTypeString )
deced_transported ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Where was the decedent transported from?, type: esriFieldTypeString )
deced_death_cert_filed ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Was a death certificate filed?, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
narrative ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Additional notes or documentation you would like an investigator to be aware of, type: esriFieldTypeString )
confir_num ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Confirmation Number:, type: esriFieldTypeString )
cod ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Cause of Death, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
next_of_kin ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Next of Kin, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
preneed ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Pre-Need, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
preneed_where ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Where at?, type: esriFieldTypeString )
letters_mailed ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Letters Mailed, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
letters_date ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Date, type: esriFieldTypeDate )
signed_auth_received ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Signed Authorizations Received, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
dis_completed_by ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Disposition Compleeted by, type: esriFieldTypeString , Coded Values: [NOK: NOK] , [INDIGENT: INDIGENT] , [PA: PA] , ...1 more... )
assigned_to ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Assigned to, type: esriFieldTypeString , Coded Values: [vmartinez@sbcsd.org: vmartinez@sbcsd.org] , [cholton@sbcsd.org: cholton@sbcsd.org] , [aacevedo@sbcsd.org: aacevedo@sbcsd.org] , ...2 more... )
created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date ( nullable: true, editable: false, defaultValue: null, 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, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
death_cert2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Was a death certificate filed?, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
death_cert_filed ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Was a death certificate filed?, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
curr_search_address ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Type the current address or location of the remains in the field below and press ENTER., type: esriFieldTypeString )
curr_remian_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Current Remains Address, type: esriFieldTypeString )
deced_datetime_hhmm ( nullable: true, editable: true, defaultValue: null, length: 255, alias: ToD (Military Time), type: esriFieldTypeString )
add_con_firstname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: First Name, type: esriFieldTypeString )
add_con_lastname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Last Name, type: esriFieldTypeString )
add_con_relationship ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Relationship, type: esriFieldTypeString )
add_con_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
add_con_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: City, type: esriFieldTypeString )
add_con_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: State, type: esriFieldTypeString , Coded Values: [AL: ALABAMA] , [AK: ALASKA] , [AZ: ARIZONA] , ...56 more... )
add_con_phone ( nullable: true, editable: true, defaultValue: null, length: 15, alias: Phone, type: esriFieldTypeString )
add_con_notes ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Notes, type: esriFieldTypeString )

Name: New Feature
Description:
Prototype:
Drawing Tool: N/A

Relationships:

Referral_Repeats_r_indiv (0) -- Related To: r_indiv (1)
Referral_Repeats_kin (1) -- Related To: kin (2)
Referral_Repeats_med (2) -- Related To: med (3)

Layer: r_indiv (1)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
refer_date ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Date, type: esriFieldTypeDate )
refer_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Name, type: esriFieldTypeString )
refer_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Telephone Number, type: esriFieldTypeString )
refer_agency_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Referring Agency Address, type: esriFieldTypeString )
refer_email ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Referral Email Address, type: esriFieldTypeString )
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, 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, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
search_address ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Type the property address in the field below and press ENTER., type: esriFieldTypeString )
refer_search_address ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Type the referring agency address in the field below and press ENTER., type: esriFieldTypeString )
refer_person ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Person Making Referral, type: esriFieldTypeString )
refer_phone_exten ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Extension, type: esriFieldTypeString )
test_time ( nullable: true, editable: true, defaultValue: null, length: 255, alias: test_time, type: esriFieldTypeString )

Name: New Feature
Description:
Prototype:
Drawing Tool: N/A

Relationships:

Referral_Repeats_r_indiv (0) -- Related To: Referral_Repeats (0)

Tables:

Table: kin (2)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
safety_ ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Next-of-kin/right to control disposition or remains line of consanguinity I CA Health & Safety 7100(a), type: esriFieldTypeString , Coded Values: [7100_a_1: 7100 (a) (1) DURRABLE POWER OF ATTORNEY] , [7100_a_2: 7100 (a) (2) SPOUSE] , [7100_a_3: 7100 (a) (3) ADULT CHILD/CHILDREN] , ...5 more... )
kin_first ( nullable: true, editable: true, defaultValue: null, length: 255, alias: First Name, type: esriFieldTypeString )
kin_last ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Last Name, type: esriFieldTypeString )
kin_relationship ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Relationship, type: esriFieldTypeString )
kin_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
kin_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: City, type: esriFieldTypeString )
kin_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: State, type: esriFieldTypeString , Coded Values: [AL: ALABAMA] , [AK: ALASKA] , [AZ: ARIZONA] , ...56 more... )
kin_phone ( nullable: true, editable: true, defaultValue: null, length: 15, alias: Phone, type: esriFieldTypeString )
kin_notified ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Notified of Death?, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
kin_notified_not ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Why?, type: esriFieldTypeString )
kin_notified_when ( nullable: true, editable: true, defaultValue: null, length: 29, alias: When?, type: esriFieldTypeDate )
kin_dosp_date_ ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Date, type: esriFieldTypeDate )
kin_dispo ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Waived Right to Control Disposition, type: esriFieldTypeString , Coded Values: [YES: YES] , [NO: NO] )
kin_dispo_who ( nullable: true, editable: true, defaultValue: null, length: 255, alias: to Who? And why?, type: esriFieldTypeString )
kin_notes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes, type: esriFieldTypeString )
kpar_refer_agency_add ( nullable: true, editable: true, defaultValue: null, length: 255, alias: kpar_refer_agency_add, type: esriFieldTypeString )
kpar_refer_date ( nullable: true, editable: true, defaultValue: null, length: 255, alias: kpar_refer_date, type: esriFieldTypeString )
kpar_deced_first ( nullable: true, editable: true, defaultValue: null, length: 255, alias: kpar_deced_first, type: esriFieldTypeString )
kpar_deced_middle ( nullable: true, editable: true, defaultValue: null, length: 255, alias: kpar_deced_middle, type: esriFieldTypeString )
kpar_deced_last ( nullable: true, editable: true, defaultValue: null, length: 255, alias: kpar_deced_last, type: esriFieldTypeString )
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, 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, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
kin_datetime_hhmm ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Time of Death (Military Time), type: esriFieldTypeString )

Relationships:

Referral_Repeats_kin (1) -- Related To: Referral_Repeats (0)

Table: med (3)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
par_refer_agency ( nullable: true, editable: true, defaultValue: null, length: 255, alias: par_refer_agency, type: esriFieldTypeString )
par_refer_date ( nullable: true, editable: true, defaultValue: null, length: 255, alias: par_refer_date, type: esriFieldTypeString )
par_deced_first ( nullable: true, editable: true, defaultValue: null, length: 255, alias: par_deced_first, type: esriFieldTypeString )
par_deced_middle ( nullable: true, editable: true, defaultValue: null, length: 255, alias: par_deced_middle, type: esriFieldTypeString )
par_deced_last ( nullable: true, editable: true, defaultValue: null, length: 255, alias: par_deced_last, type: esriFieldTypeString )
med_facility ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Medical History, type: esriFieldTypeString , Coded Values: [ATTENDING CARE PHY: ATTENDING CARE PHYSICIAN] , [HOSPITAL: HOSPITAL] , [NURSING HOME: NURSING HOME] , ...4 more... )
med_facility_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: What other unknown?, type: esriFieldTypeString )
med_facility_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Facility Name, type: esriFieldTypeString )
med_rec_numb ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Medical Record #, type: esriFieldTypeString )
med_dr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Doctor, type: esriFieldTypeString )
med_main_num ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Main Number, type: esriFieldTypeString )
med_other_num ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Other Number, type: esriFieldTypeString )
med_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Address, type: esriFieldTypeString )
med_city ( nullable: true, editable: true, defaultValue: null, length: 255, alias: City, type: esriFieldTypeString )
med_state ( nullable: true, editable: true, defaultValue: null, length: 255, alias: State, type: esriFieldTypeString )
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, 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, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Relationships:

Referral_Repeats_med (2) -- Related To: Referral_Repeats (0)