Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
SERVICE_DATE | varchar(8) | not null | Service Date(YYYYMMDD) |
IMR | varchar(16) | not null | Internal Number used to create a Unique Key for Historical Files |
PAT_NUM | varchar(12) | not null | Patient Number |
PMP | varchar(5) | not null | Pharmacy Order Number |
SEQ | varchar(2) | not null | Sequence Number |
FUNCTION | varchar(3) | null | Function Code(Link to TRANFUNCTION_MASTER.FUNCTION) |
CHGTYPE | varchar(3) | null | Charge Type(Null=Order Ingredient Charge, INT=Intervention Charge, MCC=Mini Charge/Credit, MCS=Miscellaneous Charge, MTD=Method Charge) |
QTY | varchar(6) | null | Quantity |
AMOUNT | varchar(10) | null | Amount |
CHG_DESC | varchar(30) | null | Charge Code Description |
CHG_CODE | varchar(6) | null | Charge Code |
CDM_CODE | varchar(8) | null | CDM(Charge Description Master) Code |
NDC_NUMBER | varchar(14) | null | NDC(National Drug Code) Number |
RX_NUMBER | varchar(12) | null | RX Number |
COMP | varchar(4) | null | Component |
DAYS_SUPPLY | varchar(2) | null | Days Supply |
DR_NPI | varchar(10) | null | Doctor NPI Number |
DR | varchar(6) | null | Doctor Number |
DR_NAME | varchar(23) | null | Doctor Name |
PT_NAME | varchar(31) | null | Patient Name |
PT_BIRTHDATE | varchar(10) | null | Patient BirthDate |
PT_SEX | varchar(1) | null | Patient Sex |
PT_SITE | varchar(1) | null | Patient Site |
PT_CLASS | varchar(1) | null | Patient Class(I=Inpatient,O=Outpatient,E=EmergencyPatient) |
PAT_TYPE | varchar(1) | null | Patient Type |
PAT_SERVICE | varchar(3) | null | Patient Service |
PT_LOCATION | varchar(13) | null | Patient Location |
PLAN_CD | varchar(15) | null | Plan Code |
GROUP_ID | varchar(15) | null | Group Id |
PT_ID | varchar(15) | null | Patient ID Number |
CLAIM_REF | varchar(13) | null | Claim Reference Number |
BATCH_ID | varchar(13) | null | Batch Id |
PC_KEY | varchar(27) | null | PC Key |
ORDER_TYPE | varchar(3) | null | Order Type(MED,IV,CXM) |
SIG | varchar(15) | null | SIG(Latin Code) |
PCK1 | varchar(8) | null | Key 1(ITN) into Active Pharmacy Charging File(PHM_CHARGES) |
PCK2 | varchar(5) | null | Key 2(KEY2 - PMP or 'I=Interventions' or 'M=Misc Adjust') into Active Pharmacy Charging File(PHM_CHARGES) |
PCK3 | varchar(8) | null | Key 3(DATETIME_OF_ENTRY) into Active Pharmacy Charging File(PHM_CHARGES) |
PCK4 | varchar(4) | null | Key 4(SEQ) into Active Pharmacy Charging File(PHM_CHARGES) |
CLM_REF_NUM | varchar(20) | null | Claim Reference Number |
PLAN_DESC | varchar(30) | null | Plan Description |
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. |
|
|
|