Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
BATCH_ID | varchar(14) | not null | Batch ID |
IMR | varchar(16) | not null | Internal Number used to create a Unique Key for Historical Files |
PT_NUMBER | varchar(12) | not null | Patient Number |
PMP_NUMB | varchar(5) | not null | Pharmacy Order Number |
NDC_NUMB | varchar(78) | not null | NDC Number |
INCLUDE | varchar(1) | null | Include Number |
QUANTITY | varchar(5) | null | Quantity |
DAYS_SUPPLY | varchar(3) | null | Days Supply |
DRUG_DESC | varchar(30) | null | Drug Desc |
ROLLED_UP_CHG | varchar(10) | null | Rolled Up Charge |
PT_NAME | varchar(32) | null | Patient Name |
ORD_DATE | varchar(8) | null | Order Date(YYYYMMDD) |
RX_NUMB | varchar(7) | null | Rx Number |
SIG | varchar(15) | null | SIG(Latin Code) |
CHG_COUNT | varchar(3) | null | Charge Count |
PLAN_CODE | varchar(10) | null | Plan Code |
REFERENCE | varchar(13) | null | Reference Number |
DOCTOR | varchar(6) | null | Doctor Number |
CLARIFICATION_CODE | varchar(10) | null | Clarification Code |
PRIOR_AUTHORIZATION | varchar(10) | null | Prior Authorization |
DUR_CONFLICT_CODE | varchar(10) | null | DUR(Drug Utilization Review) Conflict Code |
DUR_INTERVENTION_CODE | varchar(10) | null | DUR(Drug Utilization Review) Intervention Code |
DUR_OUTCOME_CODE | varchar(10) | null | DUR(Drug Utilization Review) Outcome Code |
COMPOUND_DOSAGE_FORM | varchar(10) | null | Compound Dosage Form |
COMPOUND_DISPENSING_UNIT | varchar(10) | null | Compound Dispensing Unit |
COMPOUND_TYPE | varchar(10) | null | Compound Type |
COMPOUND_ROUTE_OF_ADMIN | varchar(10) | null | Compound Route of Admin |
COMPOUND_PRIMARY_NDC | varchar(11) | null | Compound Primary NDC |
PORTION_OF_TOTAL_CHARGE_ASSOC | varchar(10) | null | Portion of Total Charge Associated to Fee |
PORTION_OF_TOTAL_CHARGE_ASSOC2 | varchar(10) | null | Portion of Total Charge Associated to Drug Cost |
PT_SITE | varchar(2) | null | Patient Site |
COMPOUND_INGR_1_NDC | varchar(11) | null | Compound Ingredient 1 NDC Number |
COMPOUND_INGR_1_CLAIM_QTY | varchar(5) | null | Compound Ingredient 1 Claim Quantity |
COMPOUND_INGR_1_DAYS_SUPPLY | varchar(3) | null | Compound Ingredient 1 Days Supply |
COMPOUND_INGR_1_TOTAL_COST | varchar(10) | null | Compound Ingredient 1 Total Cost |
COMPOUND_INGR_1_FEE | varchar(10) | null | Compound Ingredient 1 Fee |
COMPOUND_INGR_1_DRUG_COST | varchar(10) | null | Compound Ingredient 1 Drug Cost |
COMPOUND_INGR_2_NDC | varchar(11) | null | Compound Ingredient 2 NDC Number |
COMPOUND_INGR_2_CLAIM_QTY | varchar(5) | null | Compound Ingredient 2 Claim Quantity |
COMPOUND_INGR_2_DAYS_SUPPLY | varchar(3) | null | Compound Ingredient 2 Days Supply |
COMPOUND_INGR_2_TOTAL_COST | varchar(10) | null | Compound Ingredient 2 Total Cost |
COMPOUND_INGR_2_FEE | varchar(10) | null | Compound Ingredient 2 Fee |
COMPOUND_INGR_2_DRUG_COST | varchar(10) | null | Compound Ingredient 2 Drug Cost |
COMPOUND_INGR_3_NDC | varchar(11) | null | Compound Ingredient 3 NDC Number |
COMPOUND_INGR_3_CLAIM_QTY | varchar(5) | null | Compound Ingredient 3 Claim Quantity |
COMPOUND_INGR_3_DAYS_SUPPLY | varchar(3) | null | Compound Ingredient 3 Days Supply |
COMPOUND_INGR_3_TOTAL_COST | varchar(10) | null | Compound Ingredient 3 Total Cost |
COMPOUND_INGR_3_FEE | varchar(10) | null | Compound Ingredient 3 Fee |
COMPOUND_INGR_3_DRUG_COST | varchar(10) | null | Compound Ingredient 3 Drug Cost |
COMPOUND_INGR_4_NDC | varchar(11) | null | Compound Ingredient 4 NDC Number |
COMPOUND_INGR_4_CLAIM_QTY | varchar(5) | null | Compound Ingredient 4 Claim Quantity |
COMPOUND_INGR_4_DAYS_SUPPLY | varchar(3) | null | Compound Ingredient 4 Days Supply |
COMPOUND_INGR_4_TOTAL_COST | varchar(10) | null | Compound Ingredient 4 Total Cost |
COMPOUND_INGR_4_FEE | varchar(10) | null | Compound Ingredient 4 Fee |
COMPOUND_INGR_4_DRUG_COST | varchar(10) | null | Compound Ingredient 4 Drug Cost |
COMPOUND_INGR_5_NDC | varchar(11) | null | Compound Ingredient 5 NDC Number |
COMPOUND_INGR_5_CLAIM_QTY | varchar(5) | null | Compound Ingredient 5 Claim Quantity |
COMPOUND_INGR_5_DAYS_SUPPLY | varchar(3) | null | Compound Ingredient 5 Days Supply |
COMPOUND_INGR_5_TOTAL_COST | varchar(10) | null | Compound Ingredient 5 Total Cost |
COMPOUND_INGR_5_FEE | varchar(10) | null | Compound Ingredient 5 Fee |
COMPOUND_INGR_5_DRUG_COST | varchar(10) | null | Compound Ingredient 5 Drug Cost |
COMPOUND_INGR_6_NDC | varchar(11) | null | Compound Ingredient 6 NDC Number |
COMPOUND_INGR_6_CLAIM_QTY | varchar(5) | null | Compound Ingredient 6 Claim Quantity |
COMPOUND_INGR_6_DAYS_SUPPLY | varchar(3) | null | Compound Ingredient 6 Days Supply |
COMPOUND_INGR_6_TOTAL_COST | varchar(10) | null | Compound Ingredient 6 Total Cost |
COMPOUND_INGR_6_FEE | varchar(10) | null | Compound Ingredient 6 Fee |
COMPOUND_INGR_6_DRUG_COST | varchar(10) | null | Compound Ingredient 6 Drug Cost |
PATIENT_OID | INT | not null | Soarian Clinicals Patient OID. Not valued on Pharmacy system. Only used by Soarian Clinicals as part of EHI(Electronic Health Information) Export. |
|
|
|