aurora_standard.chmguard

Field Type Null Default Key Extra Comment
guar_no int(11) YES
stmnt_date date YES
stmnt_count smallint(6) YES
actual_date date YES
input_by int(11) YES
visits varchar(76) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
visits
TableColumn
_1.encountersenc_ins1_referral_num_visits
_1.insurances_repositoryirep_ins_referral_num_visits
_1.patientspat_ins1_referral_num_visits
_1.patients_authorization_numberspan_num_visits
_1.patients_demographics_snapshotspds_ins1_referral_num_visits
_1.precertspre_ins1_referral_num_visits
_1188.encountersenc_ins1_referral_num_visits
_1188.insurances_repositoryirep_ins_referral_num_visits
_1188.patientspat_ins1_referral_num_visits
_1188.patients_authorization_numberspan_num_visits
_1188.patients_demographics_snapshotspds_ins1_referral_num_visits
_1188.precertspre_ins1_referral_num_visits
_1218.encountersenc_ins1_referral_num_visits
_1218.insurances_repositoryirep_ins_referral_num_visits
_1218.patientspat_ins1_referral_num_visits
_1218.patients_authorization_numberspan_num_visits
_1218.patients_demographics_snapshotspds_ins1_referral_num_visits
_1218.precertspre_ins1_referral_num_visits
_1548.encountersenc_ins1_referral_num_visits
_1548.insurances_repositoryirep_ins_referral_num_visits
_1548.patientspat_ins1_referral_num_visits
_1548.patients_authorization_numberspan_num_visits
_1548.patients_demographics_snapshotspds_ins1_referral_num_visits
_1548.precertspre_ins1_referral_num_visits
_435.encountersenc_ins1_referral_num_visits
_435.insurances_repositoryirep_ins_referral_num_visits
_435.patientspat_ins1_referral_num_visits
_435.patients_authorization_numberspan_num_visits
_435.patients_demographics_snapshotspds_ins1_referral_num_visits
_435.precertspre_ins1_referral_num_visits
_436.encountersenc_ins1_referral_num_visits
_436.insurances_repositoryirep_ins_referral_num_visits
_436.patientspat_ins1_referral_num_visits
_436.patients_authorization_numberspan_num_visits
_436.patients_demographics_snapshotspds_ins1_referral_num_visits
_436.precertspre_ins1_referral_num_visits
_436_archive_testing.encountersenc_ins1_referral_num_visits
_436_archive_testing.insurances_repositoryirep_ins_referral_num_visits
_436_archive_testing.patientspat_ins1_referral_num_visits
_436_archive_testing.patients_authorization_numberspan_num_visits
_436_archive_testing.patients_demographics_snapshotspds_ins1_referral_num_visits
_436_archive_testing.precertspre_ins1_referral_num_visits
_437.encountersenc_ins1_referral_num_visits
_437.insurances_repositoryirep_ins_referral_num_visits
_437.patientspat_ins1_referral_num_visits
_437.patients_authorization_numberspan_num_visits
_437.patients_demographics_snapshotspds_ins1_referral_num_visits
_437.precertspre_ins1_referral_num_visits
_8.encountersenc_ins1_referral_num_visits
_8.insurances_repositoryirep_ins_referral_num_visits
_8.patientspat_ins1_referral_num_visits
_8.patients_authorization_numberspan_num_visits
_8.patients_demographics_snapshotspds_ins1_referral_num_visits
_8.precertspre_ins1_referral_num_visits
_81.encountersenc_ins1_referral_num_visits
_81.insurances_repositoryirep_ins_referral_num_visits
_81.patientspat_ins1_referral_num_visits
_81.patients_authorization_numberspan_num_visits
_81.patients_demographics_snapshotspds_ins1_referral_num_visits
_81.precertspre_ins1_referral_num_visits
_999.encountersenc_ins1_referral_num_visits
_999.insurances_repositoryirep_ins_referral_num_visits
_999.patientspat_ins1_referral_num_visits
_999.patients_authorization_numberspan_num_visits
_999.patients_demographics_snapshotspds_ins1_referral_num_visits
_999.precertspre_ins1_referral_num_visits
aurora_standard.anotesrtot_visits
aurora_standard.bdfilertot_visits
aurora_standard.chltrandphys_visits
aurora_standard.chm835prtot_visits
guar_no
TableColumn
aurora_standard.anmpinew_guar_no
aurora_standard.apsmpinew_guar_no
aurora_standard.bs2mpinew_guar_no
aurora_standard.bsmpinew_guar_no
stmnt_date
TableColumn
aurora_standard.chmgstmrprev_stmnt_date