aurora_standard.ohoemppd

Field Type Null Default Key Extra Comment
empl_code varchar(6) YES
accr_code varchar(6) YES
usable decimal(8,2) YES
accr_ytd decimal(8,2) YES
active varchar(1) YES
use_date date 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
empl_code
TableColumn
aurora_standard.chtsupvcsupv_empl_code
aurora_standard.stypddrdadj_empl_code
accr_code
TableColumn
aurora_standard.styemplrsick_accr_code
aurora_standard.styemplrvac_accr_code
aurora_standard.stytypersick_accr_code
aurora_standard.stytypervac_accr_code
use_date
TableColumn
aurora_standard.styptodvbeginning_use_date