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) |
|