aurora_standard.stmmastr

Field Type Null Default Key Extra Comment
property_code char(20) YES
type_code char(30) YES
serial_no char(20) YES
active char(1) YES
desc1 char(60) YES
desc2 char(60) YES
warr_desc1 char(60) YES
warr_desc2 char(60) YES
warr_date date YES
purch_vendor char(6) YES
purch_date date YES
purch_po char(10) YES
purch_cost decimal(14,2) YES
fa_code char(6) YES
maint_vendor char(6) YES
added_by char(10) YES
added_date date YES
warr_end_date date YES
model_no char(30) YES
location_code char(3) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
active
TableColumn
HSPI_Bastrop.charge_mastersis_active
HSPI_CURES2015_B1.charge_mastersis_active
HSPI_Central_Hospital.charge_mastersis_active
HSPI_Dewitt.charge_mastersis_active
HSPI_Fulton.charge_mastersis_active
HSPI_Inferno.charge_mastersis_active
HSPI_MU2015_E1.charge_mastersis_active
HSPI_MU2015_G2.charge_mastersis_active
HSPI_MU2015_G9.charge_mastersis_active
HSPI_Ness.charge_mastersis_active
HSPI_Sandbox.charge_mastersis_active
HSPI_Summit_General.charge_mastersis_active
HSPI_United_Physicians.charge_mastersis_active
Icd.icd10_snomed_mapi10snom_active
MPI.charge_mastersis_active
SSO.user_passwordsis_active
_1.encounter_soap_labels_values_groupseslvg_is_active
_1218.encounter_soap_labels_values_groupseslvg_is_active
_1548.encounter_soap_labels_values_groupseslvg_is_active
_435.encounter_soap_labels_values_groupseslvg_is_active
_436.encounter_soap_labels_values_groupseslvg_is_active
_436_archive_testing.encounter_soap_labels_values_groupseslvg_is_active
_437.encounter_soap_labels_values_groupseslvg_is_active
_8.encounter_soap_labels_values_groupseslvg_is_active
_999.encounter_soap_labels_values_groupseslvg_is_active
aurora_standard.apsarcur_active
aurora_standard.apsar0cur_active
aurora_standard.apsarbdcur_active
aurora_standard.apsarhistcur_active
aurora_standard.chmopercusr_active
aurora_standard.stuctlgdcontract_active
aurora_standard.stxautorauto_active
common.users_passwordsupwd_active
type_code
TableColumn
_1.hl7_accessionsacc_type_code
_1.patients_icd9_problems_dx_modifierspipdm_type_code
_1188.hl7_accessionsacc_type_code
_1188.patients_icd9_problems_dx_modifierspipdm_type_code
_1218.hl7_accessionsacc_type_code
_1218.patients_icd9_problems_dx_modifierspipdm_type_code
_1548.hl7_accessionsacc_type_code
_1548.patients_icd9_problems_dx_modifierspipdm_type_code
_435.hl7_accessionsacc_type_code
_435.patients_icd9_problems_dx_modifierspipdm_type_code
_436.hl7_accessionsacc_type_code
_436.patients_icd9_problems_dx_modifierspipdm_type_code
_436_archive_testing.hl7_accessionsacc_type_code
_436_archive_testing.patients_icd9_problems_dx_modifierspipdm_type_code
_437.hl7_accessionsacc_type_code
_437.patients_icd9_problems_dx_modifierspipdm_type_code
_8.hl7_accessionsacc_type_code
_8.patients_icd9_problems_dx_modifierspipdm_type_code
_81.hl7_accessionsacc_type_code
_81.patients_icd9_problems_dx_modifierspipdm_type_code
_999.hl7_accessionsacc_type_code
_999.patients_icd9_problems_dx_modifierspipdm_type_code
aurora_standard.stmaintdmaint_type_code
aurora_standard.stmnotednote_type_code
aurora_standard.stmwarrdwarr_type_code
common.clientscli_service_type_code
added_by
TableColumn
_1.labs_orderslo_added_by
_1188.labs_orderslo_added_by
_1218.labs_orderslo_added_by
_1548.labs_orderslo_added_by
_435.labs_orderslo_added_by
_436.labs_orderslo_added_by
_436_archive_testing.labs_orderslo_added_by
_437.labs_orderslo_added_by
_8.labs_orderslo_added_by
_81.labs_orderslo_added_by
_999.labs_orderslo_added_by
location_code
TableColumn
_1.patients_implantable_devicespid_location_code
_1188.patients_implantable_devicespid_location_code
_1218.patients_implantable_devicespid_location_code
_1548.patients_implantable_devicespid_location_code
_435.patients_implantable_devicespid_location_code
_436.patients_implantable_devicespid_location_code
_436_archive_testing.patients_implantable_devicespid_location_code
_437.patients_implantable_devicespid_location_code
_8.patients_implantable_devicespid_location_code
_81.patients_implantable_devicespid_location_code
_999.patients_implantable_devicespid_location_code
serial_no
TableColumn
aurora_standard.chhcntrcneic_serial_no
aurora_standard.chmcntrcneic_serial_no
aurora_standard.stmaintdmaint_serial_no
aurora_standard.stmnotednote_serial_no
aurora_standard.stmwarrdwarr_serial_no
desc1
TableColumn
aurora_standard.chrschdrlabel_desc1
aurora_standard.chshotlrprob_desc1
aurora_standard.chsmodsrprob_desc1
aurora_standard.styocovccoverage_desc1
aurora_standard.styosafcsafe_desc1
desc2
TableColumn
aurora_standard.chrschdrlabel_desc2
aurora_standard.chshotlrprob_desc2
aurora_standard.chsmodsrprob_desc2
aurora_standard.stmaintdmaint_desc2
aurora_standard.sturondcrounding_desc2
aurora_standard.stymesgcmessage_desc2
aurora_standard.styocovccoverage_desc2
aurora_standard.styosafcsafe_desc2