aurora_standard.chtemplr

Field	Type	Null	Key	Extra
empl_code	varchar(6)	YES	MUL
password	varchar(20)	YES
dflt_shift	varchar(6)	YES
dflt_dept	varchar(3)	YES
earliest_time	smallint(6)	YES
latest_time	smallint(6)	YES
add_oncall_pay	varchar(1)	YES
transfer_funct	varchar(1)	YES
add_inservice_hour	varchar(1)	YES
review_hours	varchar(1)	YES
add_vac_hours	varchar(1)	YES
message	varchar(70)	YES
lunch_time	time	YES
empl_supervisor	varchar(6)	YES
distribute_hours	varchar(1)	YES
current_status	varchar(1)	YES
login_id	varchar(8)	YES
ot_calc_meth	varchar(2)	YES
msg_date	date	YES
max_hours	decimal(8,4)	YES
no_options	varchar(1)	YES
shift_length	decimal(6,0)	YES
trans_rule	varchar(1)	YES
card_no	varchar(20)	YES
dflt_fac_no	varchar(3)	YES
fac_no	varchar(1)	YES
special_superv	varchar(6)	YES
dflt_input_device	varchar(15)	YES
dflt_on_call_code	varchar(6)	YES
dflt_on_call_time	int(11)	YES
alt_input_device	varchar(15)	YES
msg_end_date	date	YES
last_clokd_rowID	bigint(20)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

message

Table	Column
API.oauth_auth_requests	error_message
HSPI_System.report_queues	status_message
_1.encounters_alert_rules	ear_message
_1.immunization_reported	imrp_error_message
_1.patient_statements_messages	pstmsg_message
_1.patients_statements	pst_message
_1.tasks	task_transaction_message
_1188.encounters_alert_rules	ear_message
_1188.immunization_reported	imrp_error_message
_1188.patient_statements_messages	pstmsg_message
_1188.patients_statements	pst_message
_1188.tasks	task_transaction_message
_1218.encounters_alert_rules	ear_message
_1218.immunization_reported	imrp_error_message
_1218.patient_statements_messages	pstmsg_message
_1218.patients_statements	pst_message
_1218.tasks	task_transaction_message
_1548.encounters_alert_rules	ear_message
_1548.immunization_reported	imrp_error_message
_1548.patient_statements_messages	pstmsg_message
_1548.patients_statements	pst_message
_1548.tasks	task_transaction_message
_435.encounters_alert_rules	ear_message
_435.immunization_reported	imrp_error_message
_435.patient_statements_messages	pstmsg_message
_435.patients_statements	pst_message
_435.tasks	task_transaction_message
_436.encounters_alert_rules	ear_message
_436.immunization_reported	imrp_error_message
_436.patient_statements_messages	pstmsg_message
_436.patients_statements	pst_message
_436.tasks	task_transaction_message
_436_archive_testing.encounters_alert_rules	ear_message
_436_archive_testing.immunization_reported	imrp_error_message
_436_archive_testing.patient_statements_messages	pstmsg_message
_436_archive_testing.patients_statements	pst_message
_436_archive_testing.tasks	task_transaction_message
_437.encounters_alert_rules	ear_message
_437.immunization_reported	imrp_error_message
_437.patient_statements_messages	pstmsg_message
_437.patients_statements	pst_message
_437.tasks	task_transaction_message
_8.encounters_alert_rules	ear_message
_8.immunization_reported	imrp_error_message
_8.patient_statements_messages	pstmsg_message
_8.patients_statements	pst_message
_8.tasks	task_transaction_message
_81.encounters_alert_rules	ear_message
_81.immunization_reported	imrp_error_message
_81.patient_statements_messages	pstmsg_message
_81.patients_statements	pst_message
_81.tasks	task_transaction_message
_999.encounters_alert_rules	ear_message
_999.immunization_reported	imrp_error_message
_999.patient_statements_messages	pstmsg_message
_999.patients_statements	pst_message
_999.tasks	task_transaction_message
aurora_standard.chhl7adt	error_message
common.data_import_errors	die_error_message
common.interface_status	ifs_last_message
xlnt.pipeline_test_stage	error_message

password

Table	Column
HSPI_System.organization_links	chart_access_password
MPI.organization_links	chart_access_password
SSO.common_passwords	cpw_password
ahiWiki.bot_passwords	bp_password
ahiWiki.user	user_password
common.clients	cli_gateway_password
common.clients	cli_medassets_password
common.common_passwords	cpw_password
common.fax_accounts	fxa_password
common.phi_mail_users	pmu_password
common.users	usr_password
common.users_passwords	upwd_salt_password
common.users_passwords	upwd_password
common.users_simplifymd	usmd_password

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no

empl_code

Table	Column
aurora_standard.chtsupvc	supv_empl_code
aurora_standard.stypddrd	adj_empl_code

login_id

Table	Column
aurora_standard.chtsupvc	alt1_login_id

card_no

Table	Column
aurora_standard.stpvendr	credit_card_no
aurora_standard.styrtimd	rec_card_no
aurora_standard.styrtime	rec_card_no