aurora_standard.chpskild

Field Type Null Default Key Extra Comment
empl_code varchar(6) YES
skill_code varchar(6) YES
expire_date date YES
active varchar(1) YES
issue_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
expire_date
TableColumn
aurora_standard.chhl7in1plan_expire_date
aurora_standard.hl7in1plan_expire_date
aurora_standard.hl7in1adplan_expire_date
empl_code
TableColumn
aurora_standard.chtsupvcsupv_empl_code
aurora_standard.stypddrdadj_empl_code