common.interfaces_types

Field Type Null Default Key Extra Comment
it_id int(11) NO PRI auto_increment
it_name varchar(40) NO
it_adapter_loc text NO
it_api_version int(5) NO 0
it_adt char(1) NO
it_dft char(1) NO
it_siu char(1) NO
it_mfn char(1) NO MUL
it_vxu char(1) NO
it_patient_sso tinyint(1) NO 0 Indicates whether an interface supports a patients actions dropdown SSO link
it_immu_pdf tinyint(1) NO 0 Indicates if an interface type supports immunization PDF generation
it_visit_num tinyint(1) NO 0 Indicates whether an interface uses the external visit number field for encounters
it_erx char(1) YES
it_health_exchange char(1) NO 0
it_lab char(1) NO
it_lab_id int(11) NO MUL
it_lab_order char(1) NO
it_lab_result char(1) NO
it_lab_tco char(1) NO
it_post_send_edit_lock char(1) NO indicates the order may not be edited after sending
it_test_code_limit int(11) NO 0 indicates the max amount of test codes allowed on an order
it_inhouse_results tinyint(1) NO 0 Indicates whether an interface supports user enterable results
it_application varchar(40) NO
it_facility varchar(40) NO
it_usr_id int(11) YES 0 The user id for the audits user associated with this interface
it_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
it_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
it_id
TableColumn
common.interfacesif_it_id
common.lab_interfaceslif_it_id
common.orders_comment_typesoct_it_id