Service Unit Views

Service Unit View: Service Unit

View name: rpt.service_unit

Type: Record

Description: Service Unit Core Information

Field	Data Type
service_unit_id	integer
service_unit_name	character varying(40)

Service Unit View: Service Unit Profile

View name: rpt.service_unit_profile

Type: Profile

Description: Service Unit Detail Information

Field	Data Type	Notes
service_unit_id	integer	References service_unit_id in rpt.service_unit
service_unit_name	character varying(40)
service_unit_short_name	character varying(10)
service_unit_is_active	boolean
service_unit_type_id	integer
service_unit_type	character varying(20)
service_unit_class_id	integer
service_unit_class	character varying(25)
unit_of_measure_id	integer	References unit_of_measure_id in rpt.unit_of_measure
service_unit_contact_type_id	integer
service_unit_contact_type	text
service_unit_procedure_code	character varying
service_unit_drop_down_1_id	integer
service_unit_drop_down_1	character varying(25)
service_unit_drop_down_2_id	integer
service_unit_drop_down_2	character varying(25)
service_unit_fee_amt	numeric(10,2)
tax_schedule_id	integer	References tax_schedule_id in rpt.tax_schedule
service_unit_disable_sliding_scale	boolean
service_unit_notes	text

Service Unit View: Unit Of Measure

View name: rpt.unit_of_measure

Type: Record

Description: Unit of Measure Information

Field	Data Type	Notes
unit_of_measure_id	integer
unit_of_measure_name	character varying(10)
unit_of_measure_equivalency	numeric(10,2)
unit_of_measure_schedule_id	integer	References unit_of_measure_schedule_id in rpt.unit_of_measure_schedule

Service Unit View: Unit of Measure Schedule

View name: rpt.unit_of_measure_schedule

Type: Record

Description: Unit of Measure Schedule Information

Field	Data Type
unit_of_measure_schedule_id	integer
unit_of_measure_schedule_name	character varying(30)
unit_of_measure_class_id	integer
unit_of_measure_class	text
unit_of_measure_is_time	boolean

Service Unit View: Service Unit Site Fees

View name: rpt.service_unit_site_fees

Type: Cross Reference

Description: Service Unit Site Fees

Field	Data Type	Notes
service_unit_id	integer	References service_unit_id in rpt.service_unit
site_id	integer	References site_id in rpt.site
service_unit_site_fee_amt	numeric(10,2)

Views and Standard Views