rcmroi.dev__specialties

Field Type Null Default Key Extra Comment
master_id int(11) NO UNI auto_increment
master_guid varchar(36) NO UNI
master_opid varchar(36) NO
master_enabled tinyint(1) YES 1
master_status varchar(1) YES
master_created datetime YES CURRENT_TIMESTAMP
master_modified datetime NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
master_expires datetime YES
specialty varchar(36) NO PRI
api_name varchar(36) YES
avg_collections_per_fte varchar(6) YES

References

Local Column References
master_id
TableColumn
HSPI_Bastrop.charge_master_codescharge_master_id
HSPI_CURES2015_B1.charge_master_codescharge_master_id
HSPI_Central_Hospital.charge_master_codescharge_master_id
HSPI_Dewitt.charge_master_codescharge_master_id
HSPI_Fulton.charge_master_codescharge_master_id
HSPI_Inferno.charge_master_codescharge_master_id
HSPI_MU2015_E1.charge_master_codescharge_master_id
HSPI_MU2015_G2.charge_master_codescharge_master_id
HSPI_MU2015_G9.charge_master_codescharge_master_id
HSPI_Ness.charge_master_codescharge_master_id
HSPI_Sandbox.charge_master_codescharge_master_id
HSPI_Summit_General.charge_master_codescharge_master_id
HSPI_United_Physicians.charge_master_codescharge_master_id
MPI.charge_master_codescharge_master_id