aurora_standard.chlatter

Field Type Null Default Key Extra Comment
ssn varchar(11) YES
assessment_no smallint(6) YES
at1 varchar(2) YES
at2 varchar(1) YES
at3a varchar(1) YES
at3b varchar(1) YES
at3c varchar(1) YES
at3d varchar(1) YES
at3e varchar(1) YES
at4a varchar(1) YES
at4b varchar(1) YES
at4c varchar(1) YES
at4d varchar(1) YES
at5a varchar(12) YES
at5b varchar(18) YES
at6 date YES
at_src varchar(1) YES
sub_req varchar(1) YES
other_3e varchar(20) YES
other_4d varchar(20) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
ssn
TableColumn
Azalea.employeesemp_ssn
_1.chartschrt_ssn
_1.cpoe_responsescpoe_res_ssn
_1.encountersenc_ssn
_1.encountersenc_guarantor_ssn
_1.encountersenc_ins1_insured_ssn
_1.encountersenc_ins2_insured_ssn
_1.encountersenc_ins3_insured_ssn
_1.examplesexa_ssn
_1.hl7_accessionsacc_ssn
_1.insurances_repositoryirep_ins_insured_ssn
_1.non_patientsnpat_ssn
_1.ordersord_ssn
_1.patientspat_ssn
_1.patientspat_guarantor_ssn
_1.patientspat_ins1_insured_ssn
_1.patientspat_ins2_insured_ssn
_1.patientspat_ins3_insured_ssn
_1.patients_demographics_snapshotspds_ssn
_1.patients_demographics_snapshotspds_guarantor_ssn
_1.patients_demographics_snapshotspds_ins1_insured_ssn
_1.patients_demographics_snapshotspds_ins2_insured_ssn
_1.patients_demographics_snapshotspds_ins3_insured_ssn
_1.patients_responsibility_estimatesprest_ssn
_1.precertspre_ssn
_1.precertspre_guarantor_ssn
_1.precertspre_ins1_insured_ssn
_1.precertspre_ins2_insured_ssn
_1.radiology_ordersrad_ssn
_1.radiology_resultsrad_res_ssn
_1188.chartschrt_ssn
_1188.cpoe_responsescpoe_res_ssn
_1188.encountersenc_ssn
_1188.encountersenc_guarantor_ssn
_1188.encountersenc_ins1_insured_ssn
_1188.encountersenc_ins2_insured_ssn
_1188.encountersenc_ins3_insured_ssn
_1188.examplesexa_ssn
_1188.hl7_accessionsacc_ssn
_1188.insurances_repositoryirep_ins_insured_ssn
_1188.non_patientsnpat_ssn
_1188.ordersord_ssn
_1188.patientspat_ssn
_1188.patientspat_guarantor_ssn
_1188.patientspat_ins1_insured_ssn
_1188.patientspat_ins2_insured_ssn
_1188.patientspat_ins3_insured_ssn
_1188.patients_demographics_snapshotspds_ssn
_1188.patients_demographics_snapshotspds_guarantor_ssn
_1188.patients_demographics_snapshotspds_ins1_insured_ssn
_1188.patients_demographics_snapshotspds_ins2_insured_ssn
_1188.patients_demographics_snapshotspds_ins3_insured_ssn
_1188.patients_responsibility_estimatesprest_ssn
_1188.precertspre_ssn
_1188.precertspre_guarantor_ssn
_1188.precertspre_ins1_insured_ssn
_1188.precertspre_ins2_insured_ssn
_1188.radiology_ordersrad_ssn
_1188.radiology_resultsrad_res_ssn
_1218.chartschrt_ssn
_1218.cpoe_responsescpoe_res_ssn
_1218.encountersenc_ssn
_1218.encountersenc_guarantor_ssn
_1218.encountersenc_ins1_insured_ssn
_1218.encountersenc_ins2_insured_ssn
_1218.encountersenc_ins3_insured_ssn
_1218.examplesexa_ssn
_1218.hl7_accessionsacc_ssn
_1218.insurances_repositoryirep_ins_insured_ssn
_1218.non_patientsnpat_ssn
_1218.ordersord_ssn
_1218.patientspat_ssn
_1218.patientspat_guarantor_ssn
_1218.patientspat_ins1_insured_ssn
_1218.patientspat_ins2_insured_ssn
_1218.patientspat_ins3_insured_ssn
_1218.patients_demographics_snapshotspds_ssn
_1218.patients_demographics_snapshotspds_guarantor_ssn
_1218.patients_demographics_snapshotspds_ins1_insured_ssn
_1218.patients_demographics_snapshotspds_ins2_insured_ssn
_1218.patients_demographics_snapshotspds_ins3_insured_ssn
_1218.patients_responsibility_estimatesprest_ssn
_1218.precertspre_ssn
_1218.precertspre_guarantor_ssn
_1218.precertspre_ins1_insured_ssn
_1218.precertspre_ins2_insured_ssn
_1218.radiology_ordersrad_ssn
_1218.radiology_resultsrad_res_ssn
_1548.chartschrt_ssn
_1548.cpoe_responsescpoe_res_ssn
_1548.encountersenc_ssn
_1548.encountersenc_guarantor_ssn
_1548.encountersenc_ins1_insured_ssn
_1548.encountersenc_ins2_insured_ssn
_1548.encountersenc_ins3_insured_ssn
_1548.examplesexa_ssn
_1548.hl7_accessionsacc_ssn
_1548.insurances_repositoryirep_ins_insured_ssn
_1548.non_patientsnpat_ssn
_1548.ordersord_ssn
_1548.patientspat_ssn
_1548.patientspat_guarantor_ssn
_1548.patientspat_ins1_insured_ssn
_1548.patientspat_ins2_insured_ssn
_1548.patientspat_ins3_insured_ssn
_1548.patients_demographics_snapshotspds_ssn
_1548.patients_demographics_snapshotspds_guarantor_ssn
_1548.patients_demographics_snapshotspds_ins1_insured_ssn
_1548.patients_demographics_snapshotspds_ins2_insured_ssn
_1548.patients_demographics_snapshotspds_ins3_insured_ssn
_1548.patients_responsibility_estimatesprest_ssn
_1548.precertspre_ssn
_1548.precertspre_guarantor_ssn
_1548.precertspre_ins1_insured_ssn
_1548.precertspre_ins2_insured_ssn
_1548.radiology_ordersrad_ssn
_1548.radiology_resultsrad_res_ssn
_435.chartschrt_ssn
_435.cpoe_responsescpoe_res_ssn
_435.encountersenc_ssn
_435.encountersenc_guarantor_ssn
_435.encountersenc_ins1_insured_ssn
_435.encountersenc_ins2_insured_ssn
_435.encountersenc_ins3_insured_ssn
_435.examplesexa_ssn
_435.hl7_accessionsacc_ssn
_435.insurances_repositoryirep_ins_insured_ssn
_435.non_patientsnpat_ssn
_435.ordersord_ssn
_435.patientspat_ssn
_435.patientspat_guarantor_ssn
_435.patientspat_ins1_insured_ssn
_435.patientspat_ins2_insured_ssn
_435.patientspat_ins3_insured_ssn
_435.patients_demographics_snapshotspds_ssn
_435.patients_demographics_snapshotspds_guarantor_ssn
_435.patients_demographics_snapshotspds_ins1_insured_ssn
_435.patients_demographics_snapshotspds_ins2_insured_ssn
_435.patients_demographics_snapshotspds_ins3_insured_ssn
_435.patients_responsibility_estimatesprest_ssn
_435.precertspre_ssn
_435.precertspre_guarantor_ssn
_435.precertspre_ins1_insured_ssn
_435.precertspre_ins2_insured_ssn
_435.radiology_ordersrad_ssn
_435.radiology_resultsrad_res_ssn
_436.chartschrt_ssn
_436.cpoe_responsescpoe_res_ssn
_436.encountersenc_ssn
_436.encountersenc_guarantor_ssn
_436.encountersenc_ins1_insured_ssn
_436.encountersenc_ins2_insured_ssn
_436.encountersenc_ins3_insured_ssn
_436.examplesexa_ssn
_436.hl7_accessionsacc_ssn
_436.insurances_repositoryirep_ins_insured_ssn
_436.non_patientsnpat_ssn
_436.ordersord_ssn
_436.patientspat_ssn
_436.patientspat_guarantor_ssn
_436.patientspat_ins1_insured_ssn
_436.patientspat_ins2_insured_ssn
_436.patientspat_ins3_insured_ssn
_436.patients_demographics_snapshotspds_ssn
_436.patients_demographics_snapshotspds_guarantor_ssn
_436.patients_demographics_snapshotspds_ins1_insured_ssn
_436.patients_demographics_snapshotspds_ins2_insured_ssn
_436.patients_demographics_snapshotspds_ins3_insured_ssn
_436.patients_responsibility_estimatesprest_ssn
_436.precertspre_ssn
_436.precertspre_guarantor_ssn
_436.precertspre_ins1_insured_ssn
_436.precertspre_ins2_insured_ssn
_436.radiology_ordersrad_ssn
_436.radiology_resultsrad_res_ssn
_436_archive_testing.chartschrt_ssn
_436_archive_testing.cpoe_responsescpoe_res_ssn
_436_archive_testing.encountersenc_ssn
_436_archive_testing.encountersenc_guarantor_ssn
_436_archive_testing.encountersenc_ins1_insured_ssn
_436_archive_testing.encountersenc_ins2_insured_ssn
_436_archive_testing.encountersenc_ins3_insured_ssn
_436_archive_testing.examplesexa_ssn
_436_archive_testing.hl7_accessionsacc_ssn
_436_archive_testing.insurances_repositoryirep_ins_insured_ssn
_436_archive_testing.non_patientsnpat_ssn
_436_archive_testing.ordersord_ssn
_436_archive_testing.patientspat_ssn
_436_archive_testing.patientspat_guarantor_ssn
_436_archive_testing.patientspat_ins1_insured_ssn
_436_archive_testing.patientspat_ins2_insured_ssn
_436_archive_testing.patientspat_ins3_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ssn
_436_archive_testing.patients_demographics_snapshotspds_guarantor_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins1_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins2_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins3_insured_ssn
_436_archive_testing.patients_responsibility_estimatesprest_ssn
_436_archive_testing.precertspre_ssn
_436_archive_testing.precertspre_guarantor_ssn
_436_archive_testing.precertspre_ins1_insured_ssn
_436_archive_testing.precertspre_ins2_insured_ssn
_436_archive_testing.radiology_ordersrad_ssn
_436_archive_testing.radiology_resultsrad_res_ssn
_437.chartschrt_ssn
_437.cpoe_responsescpoe_res_ssn
_437.encountersenc_ssn
_437.encountersenc_guarantor_ssn
_437.encountersenc_ins1_insured_ssn
_437.encountersenc_ins2_insured_ssn
_437.encountersenc_ins3_insured_ssn
_437.examplesexa_ssn
_437.hl7_accessionsacc_ssn
_437.insurances_repositoryirep_ins_insured_ssn
_437.non_patientsnpat_ssn
_437.ordersord_ssn
_437.patientspat_ssn
_437.patientspat_guarantor_ssn
_437.patientspat_ins1_insured_ssn
_437.patientspat_ins2_insured_ssn
_437.patientspat_ins3_insured_ssn
_437.patients_demographics_snapshotspds_ssn
_437.patients_demographics_snapshotspds_guarantor_ssn
_437.patients_demographics_snapshotspds_ins1_insured_ssn
_437.patients_demographics_snapshotspds_ins2_insured_ssn
_437.patients_demographics_snapshotspds_ins3_insured_ssn
_437.patients_responsibility_estimatesprest_ssn
_437.precertspre_ssn
_437.precertspre_guarantor_ssn
_437.precertspre_ins1_insured_ssn
_437.precertspre_ins2_insured_ssn
_437.radiology_ordersrad_ssn
_437.radiology_resultsrad_res_ssn
_8.chartschrt_ssn
_8.cpoe_responsescpoe_res_ssn
_8.encountersenc_ssn
_8.encountersenc_guarantor_ssn
_8.encountersenc_ins1_insured_ssn
_8.encountersenc_ins2_insured_ssn
_8.encountersenc_ins3_insured_ssn
_8.examplesexa_ssn
_8.hl7_accessionsacc_ssn
_8.insurances_repositoryirep_ins_insured_ssn
_8.non_patientsnpat_ssn
_8.ordersord_ssn
_8.patientspat_ssn
_8.patientspat_guarantor_ssn
_8.patientspat_ins1_insured_ssn
_8.patientspat_ins2_insured_ssn
_8.patientspat_ins3_insured_ssn
_8.patients_demographics_snapshotspds_ssn
_8.patients_demographics_snapshotspds_guarantor_ssn
_8.patients_demographics_snapshotspds_ins1_insured_ssn
_8.patients_demographics_snapshotspds_ins2_insured_ssn
_8.patients_demographics_snapshotspds_ins3_insured_ssn
_8.patients_responsibility_estimatesprest_ssn
_8.precertspre_ssn
_8.precertspre_guarantor_ssn
_8.precertspre_ins1_insured_ssn
_8.precertspre_ins2_insured_ssn
_8.radiology_ordersrad_ssn
_8.radiology_resultsrad_res_ssn
_81.chartschrt_ssn
_81.cpoe_responsescpoe_res_ssn
_81.encountersenc_ssn
_81.encountersenc_guarantor_ssn
_81.encountersenc_ins1_insured_ssn
_81.encountersenc_ins2_insured_ssn
_81.encountersenc_ins3_insured_ssn
_81.examplesexa_ssn
_81.hl7_accessionsacc_ssn
_81.insurances_repositoryirep_ins_insured_ssn
_81.non_patientsnpat_ssn
_81.ordersord_ssn
_81.patientspat_ssn
_81.patientspat_guarantor_ssn
_81.patientspat_ins1_insured_ssn
_81.patientspat_ins2_insured_ssn
_81.patientspat_ins3_insured_ssn
_81.patients_demographics_snapshotspds_ssn
_81.patients_demographics_snapshotspds_guarantor_ssn
_81.patients_demographics_snapshotspds_ins1_insured_ssn
_81.patients_demographics_snapshotspds_ins2_insured_ssn
_81.patients_demographics_snapshotspds_ins3_insured_ssn
_81.patients_responsibility_estimatesprest_ssn
_81.precertspre_ssn
_81.precertspre_guarantor_ssn
_81.precertspre_ins1_insured_ssn
_81.precertspre_ins2_insured_ssn
_81.radiology_ordersrad_ssn
_81.radiology_resultsrad_res_ssn
_999.chartschrt_ssn
_999.cpoe_responsescpoe_res_ssn
_999.encountersenc_ssn
_999.encountersenc_guarantor_ssn
_999.encountersenc_ins1_insured_ssn
_999.encountersenc_ins2_insured_ssn
_999.encountersenc_ins3_insured_ssn
_999.examplesexa_ssn
_999.hl7_accessionsacc_ssn
_999.insurances_repositoryirep_ins_insured_ssn
_999.non_patientsnpat_ssn
_999.ordersord_ssn
_999.patientspat_ssn
_999.patientspat_guarantor_ssn
_999.patientspat_ins1_insured_ssn
_999.patientspat_ins2_insured_ssn
_999.patientspat_ins3_insured_ssn
_999.patients_demographics_snapshotspds_ssn
_999.patients_demographics_snapshotspds_guarantor_ssn
_999.patients_demographics_snapshotspds_ins1_insured_ssn
_999.patients_demographics_snapshotspds_ins2_insured_ssn
_999.patients_demographics_snapshotspds_ins3_insured_ssn
_999.patients_responsibility_estimatesprest_ssn
_999.precertspre_ssn
_999.precertspre_guarantor_ssn
_999.precertspre_ins1_insured_ssn
_999.precertspre_ins2_insured_ssn
_999.radiology_ordersrad_ssn
_999.radiology_resultsrad_res_ssn
aurora_standard.abmmpigu_ssn
aurora_standard.abmvisgu_ssn
aurora_standard.adupguguar_ssn
aurora_standard.aswguarguar_ssn
aurora_standard.b2baddp_ssn
aurora_standard.b2mrdrp_ssn
aurora_standard.bdallvispat_ssn
aurora_standard.bdguarguar_ssn
aurora_standard.bdmpip_ssn
aurora_standard.bdmpisp_ssn
aurora_standard.bdvispat_ssn
aurora_standard.bevisp_ssn
aurora_standard.bevisbdp_ssn
aurora_standard.bevisbd2p_ssn
aurora_standard.bharp_ssn
aurora_standard.bharnew_ssn
aurora_standard.bharg_ssn
aurora_standard.bhbaddp_ssn
aurora_standard.bhguarguar_ssn
aurora_standard.bhldgrp_ssn
aurora_standard.bhldgrguar_ssn
aurora_standard.bhmrdrp_ssn
aurora_standard.bhppatp_ssn
aurora_standard.bhtguarguar_ssn
aurora_standard.bhtldgrp_ssn
aurora_standard.bhtldgrguar_ssn
aurora_standard.bhtmrdrp_ssn
aurora_standard.bhtppatp_ssn
aurora_standard.bmguarguar_ssn
aurora_standard.bmmpip_ssn
aurora_standard.bmnkinn_ssn
aurora_standard.bmpactp_ssn
aurora_standard.bmpatp_ssn
aurora_standard.bparp_ssn
aurora_standard.bparnew_ssn
aurora_standard.bparg_ssn
aurora_standard.bpar2p_ssn
aurora_standard.bpar2new_ssn
aurora_standard.bpar2g_ssn
aurora_standard.bpmpip_ssn
aurora_standard.bpmpi2p_ssn
aurora_standard.bpmrp_ssn
aurora_standard.bpmr2p_ssn
aurora_standard.bsguarguar_ssn
aurora_standard.bsinsurspouse_ssn
aurora_standard.bsvispat_ssn
aurora_standard.bsvisbdpat_ssn
aurora_standard.bvguargu_ssn
aurora_standard.bvmpip_ssn
aurora_standard.bvmpi2p_ssn
aurora_standard.c7guarrguar_ssn
aurora_standard.c7mpip_ssn
aurora_standard.c7mpigu_ssn
aurora_standard.c7vispat_ssn
aurora_standard.c8dtlsp_ssn
aurora_standard.c8guarguar_ssn
aurora_standard.c8guar2guar_ssn
aurora_standard.c9mpip_ssn
aurora_standard.c9visp_ssn
aurora_standard.cafcpat_ssn
aurora_standard.caguarrguar_ssn
aurora_standard.campispouse_ssn
aurora_standard.cavispat_ssn
aurora_standard.cavishpat_ssn
aurora_standard.chhl7in2ins_ssn
aurora_standard.chlmdssdprev_ssn
aurora_standard.chltrnsdprev_ssn
aurora_standard.chmarcnbfg_ssn
aurora_standard.chmarcnbfp_ssn
aurora_standard.chmarsipat_ssn
aurora_standard.chmarsigu_ssn
aurora_standard.chmarsisp_ssn
aurora_standard.chmazstdpat_ssn
aurora_standard.chmazstipat_ssn
aurora_standard.chmazstopat_ssn
aurora_standard.chmcampipat_ssn
aurora_standard.chmcampigu_ssn
aurora_standard.chmcampisp_ssn
aurora_standard.chmcmheddebtor_1_ssn
aurora_standard.chmcmheddebtor_2_ssn
aurora_standard.chmcmhedpat_ssn
aurora_standard.chmcssndnew_ssn
aurora_standard.chmcssndold_ssn
aurora_standard.chmexmpipat_ssn
aurora_standard.chmexmpigu_ssn
aurora_standard.chmexmpisp_ssn
aurora_standard.chmexvispat_ssn
aurora_standard.chmguarrguar_ssn
aurora_standard.chmhistpp_ssn
aurora_standard.chmlastrpat_ssn
aurora_standard.chmmhastpat_ssn
aurora_standard.chmokipdpat_ssn
aurora_standard.chmokopdpat_ssn
aurora_standard.chmopercauto_ssn
aurora_standard.chmozpcddebtor_1_ssn
aurora_standard.chmozpcddebtor_2_ssn
aurora_standard.chmpatmrspouse_ssn
aurora_standard.chmpatwcmom_ssn
aurora_standard.chmpatwcdad_ssn
aurora_standard.chmpdemop_ssn
aurora_standard.chmpdemosp_ssn
aurora_standard.chmpdemogu_ssn
aurora_standard.chmradexpat_ssn
aurora_standard.chmradexgu_ssn
aurora_standard.chmradexsp_ssn
aurora_standard.chmtxstrpat_ssn
aurora_standard.chpcobdddep_ssn
aurora_standard.chpdepeddepend_ssn
aurora_standard.chpempddperson_ssn
aurora_standard.chxcntrcid_is_ssn
aurora_standard.hl7gt1guar_ssn
aurora_standard.hl7gt1adguar_ssn
aurora_standard.hl7in2ins_ssn
aurora_standard.hl7in2adins_ssn
aurora_standard.hl7pidpat_ssn
aurora_standard.hl7pidadpat_ssn
aurora_standard.kcvispat_ssn
aurora_standard.kcvisitpat_ssn
aurora_standard.nbspousespouse_ssn
aurora_standard.ncexmpipat_ssn
aurora_standard.oddpayddempl_ssn
aurora_standard.oddpayidempl_ssn
aurora_standard.oddpayodempl_ssn
aurora_standard.oddpayreempl_ssn
aurora_standard.odhpayddempl_ssn
aurora_standard.odhpayidempl_ssn
aurora_standard.odhpayodempl_ssn
aurora_standard.odhpayreempl_ssn
aurora_standard.styoempddepend_ssn
common.customerscus_require_ssn
sub_req
TableColumn
aurora_standard.chlswbddsb_sub_req
aurora_standard.chlswbedsb_sub_req