aurora_standard.styinccr

Field Type Null Default Key Extra Comment
inc_code varchar(6) YES UNI
description varchar(30) YES
dflt_num decimal(18,8) YES
dflt_rate decimal(18,8) YES
dflt_hours decimal(12,2) YES
dflt_acct int(11) YES
dflt_dept varchar(3) YES
inc_type varchar(1) YES
dflt_lo_inc_amt decimal(12,2) YES
dflt_hi_inc_amt decimal(12,2) YES
non_qual varchar(1) YES
accrue varchar(1) YES
acru_lia_acct int(11) YES
acru_lia_dept varchar(3) YES
productive varchar(1) YES
over_time varchar(1) YES
ot_base_inc_code varchar(6) YES
ot_percnt_incr decimal(6,3) YES
ot_shift_amount decimal(6,2) YES
pto_flag varchar(1) YES
dep_care varchar(1) YES
misc_box varchar(2) YES
misc_label varchar(14) YES
ot_calc varchar(1) YES
pension varchar(1) YES
min_increase decimal(3,2) YES
max_increase decimal(3,2) YES
pto_code varchar(1) YES
active varchar(1) 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
description
TableColumn
HSPI_Bastrop.devicesdevice_description
HSPI_CURES2015_B1.devicesdevice_description
HSPI_Central_Hospital.devicesdevice_description
HSPI_Dewitt.devicesdevice_description
HSPI_Fulton.devicesdevice_description
HSPI_Inferno.devicesdevice_description
HSPI_MU2015_E1.devicesdevice_description
HSPI_MU2015_G2.devicesdevice_description
HSPI_MU2015_G9.devicesdevice_description
HSPI_Sandbox.devicesdevice_description
HSPI_Summit_General.devicesdevice_description
HSPI_United_Physicians.devicesdevice_description
MPI.devicesdevice_description
_1.adjustment_rulesar_description
_1.cqm_errorscqmer_description
_1.encounters_alert_rulesear_description
_1.patients_implantable_devicespid_device_description
_1188.cqm_errorscqmer_description
_1188.encounters_alert_rulesear_description
_1188.patients_implantable_devicespid_device_description
_1218.adjustment_rulesar_description
_1218.cqm_errorscqmer_description
_1218.encounters_alert_rulesear_description
_1218.patients_implantable_devicespid_device_description
_1548.adjustment_rulesar_description
_1548.cqm_errorscqmer_description
_1548.encounters_alert_rulesear_description
_1548.patients_implantable_devicespid_device_description
_435.adjustment_rulesar_description
_435.cqm_errorscqmer_description
_435.encounters_alert_rulesear_description
_435.patients_implantable_devicespid_device_description
_436.adjustment_rulesar_description
_436.cqm_errorscqmer_description
_436.encounters_alert_rulesear_description
_436.patients_implantable_devicespid_device_description
_436_archive_testing.adjustment_rulesar_description
_436_archive_testing.cqm_errorscqmer_description
_436_archive_testing.encounters_alert_rulesear_description
_436_archive_testing.patients_implantable_devicespid_device_description
_437.adjustment_rulesar_description
_437.cqm_errorscqmer_description
_437.encounters_alert_rulesear_description
_437.patients_implantable_devicespid_device_description
_8.adjustment_rulesar_description
_8.cqm_errorscqmer_description
_8.encounters_alert_rulesear_description
_8.patients_implantable_devicespid_device_description
_81.cqm_errorscqmer_description
_81.encounters_alert_rulesear_description
_81.patients_implantable_devicespid_device_description
_999.adjustment_rulesar_description
_999.cqm_errorscqmer_description
_999.encounters_alert_rulesear_description
_999.patients_implantable_devicespid_device_description
ahiWiki.filearchivefa_description
ahiWiki.imageimg_description
ahiWiki.oldimageoi_description
aurora_standard.medgenix_modulesmodule_description
aurora_standard.stfclondasst_description
aurora_standard.stpapckvacct_description
aurora_standard.stultyprupdate_description
aurora_standard.stxparmdval_description
aurora_standard.stydeddvhome_description
aurora_standard.styincdvhome_description
aurora_standard.styintfcsource_description
aurora_standard.styjobtcjob_description
aurora_standard.styobldvhome_description
aurora_standard.styptodvhome_description
common.data_import_optionsdio_description
common.data_import_value_typesdivt_description
common.dev_requestsdev_description
common.dev_requests_screencastsdrs_description
common.insurances_claim_indicatorsinsci_description
common.smoking_statusesss_description
common.test_codestco_x_specimen_description
common.test_codes_profilestcp_description
inc_code
TableColumn
aurora_standard.chtclokdpaid_inc_code
aurora_standard.chteshtdshift_inc_code
aurora_standard.chteshtdother_inc_code
aurora_standard.chteshtdhol_inc_code
aurora_standard.chtshftcshift_inc_code
aurora_standard.chtshftcother_inc_code
aurora_standard.chtshftcholiday_inc_code
aurora_standard.hhtclokdpaid_inc_code
aurora_standard.jkyemppdaccr_inc_code
aurora_standard.stycincdpy_inc_code
aurora_standard.stycntrcbase_inc_code
aurora_standard.styemppdaccr_inc_code
aurora_standard.styptodvhrs_used_inc_code
aurora_standard.timetablpaid_inc_code