Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PHM_CHARGES_LTC_BATCHED Pharmacy Long Term Care Charges Batched Claims
Column Name Column Datatype Column Null Option Column Comment
BATCH_IDvarchar(14)not null Batch ID
IMRvarchar(16)not null Internal Number used to create a Unique Key for Historical Files
PT_NUMBERvarchar(12)not null Patient Number
PMP_NUMBvarchar(5)not null Pharmacy Order Number
NDC_NUMBvarchar(78)not null NDC Number
INCLUDEvarchar(1)null Include Number
QUANTITYvarchar(5)null Quantity
DAYS_SUPPLYvarchar(3)null Days Supply
DRUG_DESCvarchar(30)null Drug Desc
ROLLED_UP_CHGvarchar(10)null Rolled Up Charge
PT_NAMEvarchar(32)null Patient Name
ORD_DATEvarchar(8)null Order Date(YYYYMMDD)
RX_NUMBvarchar(7)null Rx Number
SIGvarchar(15)null SIG(Latin Code)
CHG_COUNTvarchar(3)null Charge Count
PLAN_CODEvarchar(10)null Plan Code
REFERENCEvarchar(13)null Reference Number
DOCTORvarchar(6)null Doctor Number
CLARIFICATION_CODEvarchar(10)null Clarification Code
PRIOR_AUTHORIZATIONvarchar(10)null Prior Authorization
DUR_CONFLICT_CODEvarchar(10)null DUR(Drug Utilization Review) Conflict Code
DUR_INTERVENTION_CODEvarchar(10)null DUR(Drug Utilization Review) Intervention Code
DUR_OUTCOME_CODEvarchar(10)null DUR(Drug Utilization Review) Outcome Code
COMPOUND_DOSAGE_FORMvarchar(10)null Compound Dosage Form
COMPOUND_DISPENSING_UNITvarchar(10)null Compound Dispensing Unit
COMPOUND_TYPEvarchar(10)null Compound Type
COMPOUND_ROUTE_OF_ADMINvarchar(10)null Compound Route of Admin
COMPOUND_PRIMARY_NDCvarchar(11)null Compound Primary NDC
PORTION_OF_TOTAL_CHARGE_ASSOCvarchar(10)null Portion of Total Charge Associated to Fee
PORTION_OF_TOTAL_CHARGE_ASSOC2varchar(10)null Portion of Total Charge Associated to Drug Cost
PT_SITEvarchar(2)null Patient Site
COMPOUND_INGR_1_NDCvarchar(11)null Compound Ingredient 1 NDC Number
COMPOUND_INGR_1_CLAIM_QTYvarchar(5)null Compound Ingredient 1 Claim Quantity
COMPOUND_INGR_1_DAYS_SUPPLYvarchar(3)null Compound Ingredient 1 Days Supply
COMPOUND_INGR_1_TOTAL_COSTvarchar(10)null Compound Ingredient 1 Total Cost
COMPOUND_INGR_1_FEEvarchar(10)null Compound Ingredient 1 Fee
COMPOUND_INGR_1_DRUG_COSTvarchar(10)null Compound Ingredient 1 Drug Cost
COMPOUND_INGR_2_NDCvarchar(11)null Compound Ingredient 2 NDC Number
COMPOUND_INGR_2_CLAIM_QTYvarchar(5)null Compound Ingredient 2 Claim Quantity
COMPOUND_INGR_2_DAYS_SUPPLYvarchar(3)null Compound Ingredient 2 Days Supply
COMPOUND_INGR_2_TOTAL_COSTvarchar(10)null Compound Ingredient 2 Total Cost
COMPOUND_INGR_2_FEEvarchar(10)null Compound Ingredient 2 Fee
COMPOUND_INGR_2_DRUG_COSTvarchar(10)null Compound Ingredient 2 Drug Cost
COMPOUND_INGR_3_NDCvarchar(11)null Compound Ingredient 3 NDC Number
COMPOUND_INGR_3_CLAIM_QTYvarchar(5)null Compound Ingredient 3 Claim Quantity
COMPOUND_INGR_3_DAYS_SUPPLYvarchar(3)null Compound Ingredient 3 Days Supply
COMPOUND_INGR_3_TOTAL_COSTvarchar(10)null Compound Ingredient 3 Total Cost
COMPOUND_INGR_3_FEEvarchar(10)null Compound Ingredient 3 Fee
COMPOUND_INGR_3_DRUG_COSTvarchar(10)null Compound Ingredient 3 Drug Cost
COMPOUND_INGR_4_NDCvarchar(11)null Compound Ingredient 4 NDC Number
COMPOUND_INGR_4_CLAIM_QTYvarchar(5)null Compound Ingredient 4 Claim Quantity
COMPOUND_INGR_4_DAYS_SUPPLYvarchar(3)null Compound Ingredient 4 Days Supply
COMPOUND_INGR_4_TOTAL_COSTvarchar(10)null Compound Ingredient 4 Total Cost
COMPOUND_INGR_4_FEEvarchar(10)null Compound Ingredient 4 Fee
COMPOUND_INGR_4_DRUG_COSTvarchar(10)null Compound Ingredient 4 Drug Cost
COMPOUND_INGR_5_NDCvarchar(11)null Compound Ingredient 5 NDC Number
COMPOUND_INGR_5_CLAIM_QTYvarchar(5)null Compound Ingredient 5 Claim Quantity
COMPOUND_INGR_5_DAYS_SUPPLYvarchar(3)null Compound Ingredient 5 Days Supply
COMPOUND_INGR_5_TOTAL_COSTvarchar(10)null Compound Ingredient 5 Total Cost
COMPOUND_INGR_5_FEEvarchar(10)null Compound Ingredient 5 Fee
COMPOUND_INGR_5_DRUG_COSTvarchar(10)null Compound Ingredient 5 Drug Cost
COMPOUND_INGR_6_NDCvarchar(11)null Compound Ingredient 6 NDC Number
COMPOUND_INGR_6_CLAIM_QTYvarchar(5)null Compound Ingredient 6 Claim Quantity
COMPOUND_INGR_6_DAYS_SUPPLYvarchar(3)null Compound Ingredient 6 Days Supply
COMPOUND_INGR_6_TOTAL_COSTvarchar(10)null Compound Ingredient 6 Total Cost
COMPOUND_INGR_6_FEEvarchar(10)null Compound Ingredient 6 Fee
COMPOUND_INGR_6_DRUG_COSTvarchar(10)null Compound Ingredient 6 Drug Cost
PATIENT_OIDINTnot null Soarian Clinicals Patient OID. Not valued on Pharmacy system. Only used by Soarian Clinicals as part of EHI(Electronic Health Information) Export.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates