aurora_standard.lngdrg

Field Type Null Default Key Extra Comment
ndc_code varchar(13) YES MUL
record_change_indi varchar(1) YES
record_change_date date YES
price_change_date date YES
add_flag varchar(1) YES
add_date date YES
deactivate_flag varchar(1) YES
deactivate_dt date YES
reactivate_flag varchar(1) YES
reactivate_dt date YES
prev_ndc_awp_eff_d date YES
prev_ndc_awp decimal(7,2) YES
prev_ndc_disco_dt date YES
ndc_config varchar(1) YES
ndc_fmt10 varchar(10) YES
ndc_change_flag varchar(1) YES
prev_ndc_code varchar(13) YES
prev_ndc_config varchar(1) YES
prev_ndc_fmt10 varchar(10) YES
roa_code varchar(2) YES
master_form_code varchar(3) YES
prod_name varchar(80) YES MUL
additional_desc varchar(25) YES
mfg_name varchar(35) YES
prod_cat varchar(2) YES
solid_liquid_flag varchar(1) YES
form_code varchar(3) YES
metric_size varchar(20) YES
strn_name varchar(25) YES
orange_book_code varchar(3) YES
orange_book_stg_fl varchar(1) YES
unit_dose_flag varchar(1) YES
dispensing_unit_fl varchar(1) YES
pkg_size decimal(5,0) YES
pkg_quantity_code varchar(3) YES
prod_weight_vol decimal(13,6) YES
measure_code varchar(1) YES
top_vol_rank decimal(3,0) YES
single_source_flag varchar(1) YES
maint_drug_flag varchar(1) YES
exceptional_drug_f varchar(2) YES
dea_class_code varchar(5) YES
desi_drug_flag varchar(1) YES
desi_eff_dt date YES
thera_code varchar(10) YES
generic_class_code decimal(8,0) YES
gcr_code decimal(6,0) YES
gfc decimal(6,0) YES
std_pkg_size decimal(8,3) YES
std_unit_of_measur varchar(2) YES
mfg_code varchar(6) YES
wac_start_flag varchar(2) YES
wac_cur_price decimal(7,2) YES
wac_cur_unit_price decimal(9,5) YES
wac_cur_eff_dt date YES
wac_first_prev_pri decimal(7,2) YES
wac_first_prev_uni decimal(9,5) YES
wac_first_prev_eff date YES
wac_second_prev_pr decimal(7,2) YES
wac_second_prev_un decimal(9,5) YES
wac_second_prev_ef date YES
awp_start_flag varchar(2) YES
awp_cur_price decimal(8,2) YES
awp_cur_unit_price decimal(9,5) YES
awp_curr_eff_dt date YES
awp_first_prev_pri decimal(7,2) YES
awp_first_prev_uni decimal(9,5) YES
awp_first_prev_eff date YES
awp_second_prev_pr decimal(7,2) YES
awp_second_prev_un decimal(9,5) YES
awp_second_prev_ef date YES
dp_start_flag varchar(2) YES
dp_cur_price decimal(7,2) YES
dp_cur_unit_price decimal(9,5) YES
dp_cur_eff_dt date YES
dp_first_prev_pric decimal(7,2) YES
dp_first_prev_uni decimal(9,5) YES
dp_first_prev_eff date YES
dp_second_prev_pri decimal(7,2) YES
dp_second_prev_uni decimal(9,5) YES
dp_second_prev_eff date YES
ful_start_flag varchar(2) YES
ful_cur_price decimal(7,2) YES
ful_cur_unit_price decimal(9,5) YES
fur_cur_eff_dt date YES
ful_first_prev_pri decimal(7,2) YES
ful_first_prev_uni decimal(9,5) YES
ful_first_prev_eff date YES
ful_second_prev_pr decimal(7,2) YES
ful_second_prev_un decimal(9,5) YES
ful_second_prev_ef date YES
srp_start_flag varchar(2) YES
srp_cur_price decimal(7,2) YES
srp_cur_unit_price decimal(9,5) YES
srp_curr_eff_dt date YES
srp_first_prev_pri decimal(7,2) YES
srp_first_prev_uni decimal(9,5) YES
srp_first_prev_eff date YES
srp_second_prev_pr decimal(7,2) YES
srp_second_pref_un decimal(9,5) YES
srp_second_prev_ef date YES
modified_ndc_label varchar(40) YES
filler_1 varchar(1) YES
filler_2 varchar(1) YES
strn_code varchar(7) YES
route_code varchar(6) YES
package_desc_code varchar(3) YES
gcr_name varchar(50) YES MUL
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
route_code
TableColumn
HSPI_Bastrop.medication_requestsdosage_route_code
HSPI_CURES2015_B1.medication_requestsdosage_route_code
HSPI_Central_Hospital.medication_requestsdosage_route_code
HSPI_Dewitt.medication_requestsdosage_route_code
HSPI_Fulton.medication_requestsdosage_route_code
HSPI_Inferno.medication_requestsdosage_route_code
HSPI_MU2015_E1.medication_requestsdosage_route_code
HSPI_MU2015_G2.medication_requestsdosage_route_code
HSPI_MU2015_G9.medication_requestsdosage_route_code
HSPI_Sandbox.medication_requestsdosage_route_code
HSPI_Summit_General.medication_requestsdosage_route_code
HSPI_United_Physicians.medication_requestsdosage_route_code
MPI.medication_requestsdosage_route_code
ndc_code
TableColumn
_1.clients_fee_schedules_mapcfsm_ndc_code
_1.clinical_interventions_medications_mapcimm_ndc_code
_1.cptcpt_ndc_code
_1.inventoryinv_ndc_code
_1.patients_inventorypinv_ndc_code
_1.patients_responsibility_estimates_servicesprests_ndc_code
_1188.clients_fee_schedules_mapcfsm_ndc_code
_1188.clinical_interventions_medications_mapcimm_ndc_code
_1188.cptcpt_ndc_code
_1188.inventoryinv_ndc_code
_1188.patients_inventorypinv_ndc_code
_1188.patients_responsibility_estimates_servicesprests_ndc_code
_1218.clients_fee_schedules_mapcfsm_ndc_code
_1218.clinical_interventions_medications_mapcimm_ndc_code
_1218.cptcpt_ndc_code
_1218.inventoryinv_ndc_code
_1218.patients_inventorypinv_ndc_code
_1218.patients_responsibility_estimates_servicesprests_ndc_code
_1548.clients_fee_schedules_mapcfsm_ndc_code
_1548.clinical_interventions_medications_mapcimm_ndc_code
_1548.cptcpt_ndc_code
_1548.inventoryinv_ndc_code
_1548.patients_inventorypinv_ndc_code
_1548.patients_responsibility_estimates_servicesprests_ndc_code
_435.clients_fee_schedules_mapcfsm_ndc_code
_435.clinical_interventions_medications_mapcimm_ndc_code
_435.cptcpt_ndc_code
_435.inventoryinv_ndc_code
_435.patients_inventorypinv_ndc_code
_435.patients_responsibility_estimates_servicesprests_ndc_code
_436.clients_fee_schedules_mapcfsm_ndc_code
_436.clinical_interventions_medications_mapcimm_ndc_code
_436.cptcpt_ndc_code
_436.inventoryinv_ndc_code
_436.patients_inventorypinv_ndc_code
_436.patients_responsibility_estimates_servicesprests_ndc_code
_436_archive_testing.clients_fee_schedules_mapcfsm_ndc_code
_436_archive_testing.clinical_interventions_medications_mapcimm_ndc_code
_436_archive_testing.cptcpt_ndc_code
_436_archive_testing.inventoryinv_ndc_code
_436_archive_testing.patients_inventorypinv_ndc_code
_436_archive_testing.patients_responsibility_estimates_servicesprests_ndc_code
_437.clients_fee_schedules_mapcfsm_ndc_code
_437.clinical_interventions_medications_mapcimm_ndc_code
_437.cptcpt_ndc_code
_437.inventoryinv_ndc_code
_437.patients_inventorypinv_ndc_code
_437.patients_responsibility_estimates_servicesprests_ndc_code
_8.clients_fee_schedules_mapcfsm_ndc_code
_8.clinical_interventions_medications_mapcimm_ndc_code
_8.cptcpt_ndc_code
_8.inventoryinv_ndc_code
_8.patients_inventorypinv_ndc_code
_8.patients_responsibility_estimates_servicesprests_ndc_code
_81.clients_fee_schedules_mapcfsm_ndc_code
_81.clinical_interventions_medications_mapcimm_ndc_code
_81.cptcpt_ndc_code
_81.inventoryinv_ndc_code
_81.patients_inventorypinv_ndc_code
_81.patients_responsibility_estimates_servicesprests_ndc_code
_999.clients_fee_schedules_mapcfsm_ndc_code
_999.clinical_interventions_medications_mapcimm_ndc_code
_999.cptcpt_ndc_code
_999.inventoryinv_ndc_code
_999.patients_inventorypinv_ndc_code
_999.patients_responsibility_estimates_servicesprests_ndc_code
template_library.cptcpt_ndc_code