aurora_standard.stpvconr

Field Type Null Default Key Extra Comment
vend_code varchar(6) YES
contract_no varchar(12) YES
contract_tier varchar(3) YES
rebate_pct decimal(8,4) YES
effective_date date YES
expire_date date YES
note1 varchar(65) YES
note2 varchar(65) YES
note3 varchar(65) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
effective_date
TableColumn
Icd.icd10_snomed_mapi10snom_effective_date
_1.patients_smoking_statuspss_effective_date
_1188.patients_smoking_statuspss_effective_date
_1218.patients_smoking_statuspss_effective_date
_1548.patients_smoking_statuspss_effective_date
_435.patients_smoking_statuspss_effective_date
_436.patients_smoking_statuspss_effective_date
_436_archive_testing.patients_smoking_statuspss_effective_date
_437.patients_smoking_statuspss_effective_date
_8.patients_smoking_statuspss_effective_date
_81.patients_smoking_statuspss_effective_date
_999.patients_smoking_statuspss_effective_date
note2
TableColumn
_1.appointmentsapt_note2
_1188.appointmentsapt_note2
_1218.appointmentsapt_note2
_1548.appointmentsapt_note2
_435.appointmentsapt_note2
_436.appointmentsapt_note2
_436_archive_testing.appointmentsapt_note2
_437.appointmentsapt_note2
_8.appointmentsapt_note2
_81.appointmentsapt_note2
_999.appointmentsapt_note2
expire_date
TableColumn
aurora_standard.chhl7in1plan_expire_date
aurora_standard.hl7in1plan_expire_date
aurora_standard.hl7in1adplan_expire_date
vend_code
TableColumn
aurora_standard.vndxrefold_vend_code
aurora_standard.vndxrefnew_vend_code