aurora_standard.chlswbdd

Field Type Null Default Key Extra Comment
rec_id varchar(2) YES
rec_type varchar(2) YES
cnt_filler varchar(32) YES
vrsn_cd1 varchar(5) YES
vrsn_cd2 varchar(5) YES
sftwr_id varchar(9) YES
sftwr_vrsn varchar(5) YES
fac_id varchar(16) YES
res_id varchar(14) YES
filler varchar(52) YES
sb_sub_req varchar(1) YES
sb11c varchar(1) YES
sb11d varchar(1) YES
sb11e varchar(1) YES
sb11f varchar(1) YES
sb5a varchar(1) YES
sb5b varchar(1) YES
sb5c varchar(1) YES
sb5d varchar(1) YES
sb5e varchar(1) YES
sb5f varchar(1) YES
sb1a varchar(12) YES
sb1b varchar(1) YES
sb1c varchar(18) YES
sb1d varchar(3) YES
sb2 varchar(1) YES
sb3 varchar(8) YES
filler2 varchar(1) YES
sb7a varchar(9) YES
sb7b varchar(12) YES
sb9a varchar(15) YES
sb9b varchar(6) YES
filler3 varchar(6) YES
sb8 varchar(14) YES
sb11a varchar(2) YES
sb11b varchar(1) YES
sb13 varchar(8) YES
filler4 varchar(2) YES
sb6 varchar(5) YES
filler5 varchar(83) YES
sb10a varchar(8) YES
filler6 varchar(1) YES
sb16 varchar(8) YES
filler7 varchar(1) YES
sb4 varchar(1) YES
filler8 varchar(38) YES
sb17 varchar(1) YES
sb18 varchar(1) YES
filler9 varchar(6) YES
sb19 varchar(1) YES
filler10 varchar(19) YES
sb20 varchar(1) YES
filler11 varchar(8) YES
sb21a varchar(1) YES
sb21b varchar(1) YES
sb21c varchar(1) YES
sb21d varchar(1) YES
sb21e varchar(1) YES
sb21f varchar(1) YES
sb21g varchar(1) YES
sb21h varchar(1) YES
sb21i varchar(1) YES
sb21j varchar(1) YES
sb21k varchar(1) YES
sb21l varchar(1) YES
sb21m varchar(1) YES
sb21n varchar(1) YES
sb21o varchar(1) YES
sb21p varchar(1) YES
filler12 varchar(2) YES
sb22a varchar(1) YES
filler13 varchar(1) YES
sb22b varchar(1) YES
filler14 varchar(1) YES
sb22c varchar(1) YES
filler15 varchar(1) YES
sb22d varchar(1) YES
filler16 varchar(1) YES
sb22e varchar(1) YES
filler17 varchar(21) YES
sb23aa varchar(1) YES
sb23ab varchar(1) YES
sb23ba varchar(1) YES
sb23bb varchar(1) YES
filler18 varchar(10) YES
sb23ca varchar(1) YES
sb23cb varchar(1) YES
sb23da varchar(1) YES
sb23db varchar(1) YES
filler19 varchar(43) YES
sb24a varchar(1) YES
sb24b varchar(1) YES
filler20 varchar(9) YES
sb25a varchar(1) YES
filler21 varchar(16) YES
sb25b varchar(1) YES
sb25c varchar(1) YES
filler22 varchar(2) YES
sb25d varchar(1) YES
sb25e varchar(1) YES
filler23 varchar(2) YES
sb25f varchar(1) YES
filler24 varchar(22) YES
sb26a varchar(1) YES
filler25 varchar(1) YES
sb26b varchar(1) YES
filler26 varchar(43) YES
sb27a varchar(1) YES
filler27 varchar(1) YES
sb27b varchar(1) YES
filler28 varchar(2) YES
sb27c varchar(2) YES
sb27d varchar(1) YES
sb27e varchar(1) YES
filler29 varchar(4) YES
sb27f varchar(1) YES
filler30 varchar(31) YES
sb28 varchar(1) YES
filler31 varchar(5) YES
sb29a varchar(1) YES
sb29b varchar(1) YES
filler32 varchar(7) YES
sb30a varchar(1) YES
sb30b varchar(1) YES
filler33 varchar(7) YES
sb31a varchar(1) YES
sb31b varchar(1) YES
sb31c varchar(1) YES
sb31d varchar(1) YES
sb32 varchar(1) YES
filler34 varchar(3) YES
sb33a varchar(1) YES
sb33b varchar(1) YES
filler35 varchar(3) YES
sb33c varchar(1) YES
filler36 varchar(1) YES
sb34a varchar(1) YES
sb34b varchar(1) YES
sb34c varchar(1) YES
sb34d varchar(1) YES
sb34e varchar(1) YES
sb34f varchar(1) YES
sb34g varchar(1) YES
sb34h varchar(1) YES
filler37 varchar(3) YES
sb35a varchar(1) YES
sb35b varchar(1) YES
filler38 varchar(2) YES
sb35c varchar(1) YES
filler39 varchar(1) YES
sb36a varchar(1) YES
sb36b varchar(1) YES
sb36c varchar(1) YES
sb36d varchar(1) YES
filler40 varchar(25) YES
sb37 varchar(1) YES
filler41 varchar(5) YES
sb38aa varchar(1) YES
sb38ab varchar(1) YES
sb38ac varchar(1) YES
filler42 varchar(3) YES
sb38ad varchar(1) YES
sb38ae varchar(1) YES
sb38af varchar(1) YES
sb38ag varchar(1) YES
sb38ah varchar(1) YES
sb38ai varchar(1) YES
filler43 varchar(7) YES
sb38baa varchar(1) YES
sb38bab varchar(4) YES
sb38bba varchar(1) YES
sb38bbb varchar(4) YES
sb38bca varchar(1) YES
sb38bcb varchar(4) YES
sb38bda varchar(1) YES
sb38bdb varchar(4) YES
filler44 varchar(11) YES
sb39a varchar(1) YES
sb39b varchar(1) YES
sb39c varchar(1) YES
sb39d varchar(1) YES
sb39e varchar(1) YES
sb39f varchar(1) YES
sb39g varchar(1) YES
sb39h varchar(1) YES
sb39i varchar(1) YES
sb39j varchar(1) YES
filler45 varchar(10) YES
sb40 varchar(2) YES
sb41 varchar(2) YES
filler46 varchar(8) YES
sb45b varchar(8) YES
filler47 varchar(2) YES
sb15 varchar(8) YES
filler48a varchar(200) YES
filler48b varchar(105) YES
sb42a varchar(1) YES
sb42b varchar(2) YES
sb42c varchar(4) YES
filler49 varchar(5) YES
sb43medicare varchar(5) YES
sb43state varchar(5) YES
filler50a varchar(200) YES
filler50b varchar(200) YES
filler50c varchar(132) YES
sb12 varchar(8) YES
sb14a varchar(2) YES
sb14b varchar(2) YES
sb14c varchar(2) YES
sb44 varchar(5) YES
sb10b varchar(2) YES
filler51 varchar(29) YES
data_end varchar(1) YES
crg_rtn varchar(1) YES
ln_fd varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
res_id
TableColumn
_1.auditsaud_rad_res_id
_1.audits_archiveaud_rad_res_id
_1.cpoe_responsescpoe_res_id
_1.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_1.cqm_entriescqme_res_id
_1.encounters_edi_errorseep_res_id
_1.hl7_notesnot_res_id
_1.radiology_ordersrad_rad_res_id
_1.radiology_orders_test_codes_maprtcm_rad_res_id
_1.radiology_resultsrad_res_id
_1.radiology_results_docsrrdoc_rad_res_id
_1.radiology_results_notesrrnot_rad_res_id
_1.radiology_results_signedrrsig_rad_res_id
_1.radiology_results_test_codes_maprrtcm_rad_res_id
_1.radiology_results_test_codes_resultsrrtcres_rad_res_id
_1188.auditsaud_rad_res_id
_1188.audits_archiveaud_rad_res_id
_1188.cpoe_responsescpoe_res_id
_1188.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_1188.cqm_entriescqme_res_id
_1188.encounters_edi_errorseep_res_id
_1188.hl7_notesnot_res_id
_1188.radiology_ordersrad_rad_res_id
_1188.radiology_orders_test_codes_maprtcm_rad_res_id
_1188.radiology_resultsrad_res_id
_1188.radiology_results_docsrrdoc_rad_res_id
_1188.radiology_results_notesrrnot_rad_res_id
_1188.radiology_results_signedrrsig_rad_res_id
_1188.radiology_results_test_codes_maprrtcm_rad_res_id
_1188.radiology_results_test_codes_resultsrrtcres_rad_res_id
_1218.auditsaud_rad_res_id
_1218.audits_archiveaud_rad_res_id
_1218.cpoe_responsescpoe_res_id
_1218.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_1218.cqm_entriescqme_res_id
_1218.encounters_edi_errorseep_res_id
_1218.hl7_notesnot_res_id
_1218.radiology_ordersrad_rad_res_id
_1218.radiology_orders_test_codes_maprtcm_rad_res_id
_1218.radiology_resultsrad_res_id
_1218.radiology_results_docsrrdoc_rad_res_id
_1218.radiology_results_notesrrnot_rad_res_id
_1218.radiology_results_signedrrsig_rad_res_id
_1218.radiology_results_test_codes_maprrtcm_rad_res_id
_1218.radiology_results_test_codes_resultsrrtcres_rad_res_id
_1548.auditsaud_rad_res_id
_1548.audits_archiveaud_rad_res_id
_1548.cpoe_responsescpoe_res_id
_1548.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_1548.cqm_entriescqme_res_id
_1548.encounters_edi_errorseep_res_id
_1548.hl7_notesnot_res_id
_1548.radiology_ordersrad_rad_res_id
_1548.radiology_orders_test_codes_maprtcm_rad_res_id
_1548.radiology_resultsrad_res_id
_1548.radiology_results_docsrrdoc_rad_res_id
_1548.radiology_results_notesrrnot_rad_res_id
_1548.radiology_results_signedrrsig_rad_res_id
_1548.radiology_results_test_codes_maprrtcm_rad_res_id
_1548.radiology_results_test_codes_resultsrrtcres_rad_res_id
_435.auditsaud_rad_res_id
_435.audits_archiveaud_rad_res_id
_435.cpoe_responsescpoe_res_id
_435.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_435.cqm_entriescqme_res_id
_435.encounters_edi_errorseep_res_id
_435.hl7_notesnot_res_id
_435.radiology_ordersrad_rad_res_id
_435.radiology_orders_test_codes_maprtcm_rad_res_id
_435.radiology_resultsrad_res_id
_435.radiology_results_docsrrdoc_rad_res_id
_435.radiology_results_notesrrnot_rad_res_id
_435.radiology_results_signedrrsig_rad_res_id
_435.radiology_results_test_codes_maprrtcm_rad_res_id
_435.radiology_results_test_codes_resultsrrtcres_rad_res_id
_436.auditsaud_rad_res_id
_436.audits_archiveaud_rad_res_id
_436.cpoe_responsescpoe_res_id
_436.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_436.cqm_entriescqme_res_id
_436.encounters_edi_errorseep_res_id
_436.hl7_notesnot_res_id
_436.radiology_ordersrad_rad_res_id
_436.radiology_orders_test_codes_maprtcm_rad_res_id
_436.radiology_resultsrad_res_id
_436.radiology_results_docsrrdoc_rad_res_id
_436.radiology_results_notesrrnot_rad_res_id
_436.radiology_results_signedrrsig_rad_res_id
_436.radiology_results_test_codes_maprrtcm_rad_res_id
_436.radiology_results_test_codes_resultsrrtcres_rad_res_id
_436_archive_testing.auditsaud_rad_res_id
_436_archive_testing.audits_archiveaud_rad_res_id
_436_archive_testing.cpoe_responsescpoe_res_id
_436_archive_testing.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_436_archive_testing.cqm_entriescqme_res_id
_436_archive_testing.encounters_edi_errorseep_res_id
_436_archive_testing.hl7_notesnot_res_id
_436_archive_testing.radiology_ordersrad_rad_res_id
_436_archive_testing.radiology_orders_test_codes_maprtcm_rad_res_id
_436_archive_testing.radiology_resultsrad_res_id
_436_archive_testing.radiology_results_docsrrdoc_rad_res_id
_436_archive_testing.radiology_results_notesrrnot_rad_res_id
_436_archive_testing.radiology_results_signedrrsig_rad_res_id
_436_archive_testing.radiology_results_test_codes_maprrtcm_rad_res_id
_436_archive_testing.radiology_results_test_codes_resultsrrtcres_rad_res_id
_437.auditsaud_rad_res_id
_437.audits_archiveaud_rad_res_id
_437.cpoe_responsescpoe_res_id
_437.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_437.cqm_entriescqme_res_id
_437.encounters_edi_errorseep_res_id
_437.hl7_notesnot_res_id
_437.radiology_ordersrad_rad_res_id
_437.radiology_orders_test_codes_maprtcm_rad_res_id
_437.radiology_resultsrad_res_id
_437.radiology_results_docsrrdoc_rad_res_id
_437.radiology_results_notesrrnot_rad_res_id
_437.radiology_results_signedrrsig_rad_res_id
_437.radiology_results_test_codes_maprrtcm_rad_res_id
_437.radiology_results_test_codes_resultsrrtcres_rad_res_id
_8.auditsaud_rad_res_id
_8.audits_archiveaud_rad_res_id
_8.cpoe_responsescpoe_res_id
_8.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_8.cqm_entriescqme_res_id
_8.encounters_edi_errorseep_res_id
_8.hl7_notesnot_res_id
_8.radiology_ordersrad_rad_res_id
_8.radiology_orders_test_codes_maprtcm_rad_res_id
_8.radiology_resultsrad_res_id
_8.radiology_results_docsrrdoc_rad_res_id
_8.radiology_results_notesrrnot_rad_res_id
_8.radiology_results_signedrrsig_rad_res_id
_8.radiology_results_test_codes_maprrtcm_rad_res_id
_8.radiology_results_test_codes_resultsrrtcres_rad_res_id
_81.auditsaud_rad_res_id
_81.audits_archiveaud_rad_res_id
_81.cpoe_responsescpoe_res_id
_81.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_81.cqm_entriescqme_res_id
_81.encounters_edi_errorseep_res_id
_81.hl7_notesnot_res_id
_81.radiology_ordersrad_rad_res_id
_81.radiology_orders_test_codes_maprtcm_rad_res_id
_81.radiology_resultsrad_res_id
_81.radiology_results_docsrrdoc_rad_res_id
_81.radiology_results_notesrrnot_rad_res_id
_81.radiology_results_signedrrsig_rad_res_id
_81.radiology_results_test_codes_maprrtcm_rad_res_id
_81.radiology_results_test_codes_resultsrrtcres_rad_res_id
_999.auditsaud_rad_res_id
_999.audits_archiveaud_rad_res_id
_999.cpoe_responsescpoe_res_id
_999.cpoe_responses_test_codes_mapcpoe_restc_cpoe_res_id
_999.cqm_entriescqme_res_id
_999.encounters_edi_errorseep_res_id
_999.hl7_notesnot_res_id
_999.radiology_ordersrad_rad_res_id
_999.radiology_orders_test_codes_maprtcm_rad_res_id
_999.radiology_resultsrad_res_id
_999.radiology_results_docsrrdoc_rad_res_id
_999.radiology_results_notesrrnot_rad_res_id
_999.radiology_results_signedrrsig_rad_res_id
_999.radiology_results_test_codes_maprrtcm_rad_res_id
_999.radiology_results_test_codes_resultsrrtcres_rad_res_id
filler
TableColumn
aurora_standard.chlmdssds_filler
aurora_standard.chltrnsdcnt_filler
aurora_standard.chltrnsds_filler
aurora_standard.chmhaapypy_filler
aurora_standard.drg_workw_filler
aurora_standard.workdescw_filler