Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
PERSON_NUMBER | varchar(16) | not null | Identifies a Patient uniquely across multiple sites for a single enterprise |
CDT | varchar(12) | not null | CDT(Cumulative Dose Tracking) Code(Link to PHCDTBL.CDT_CODE) |
PAT_NUM | varchar(12) | not null | Patient Number |
TRANS_DATE | varchar(8) | not null | Transaction Date(YYYYMMDD) |
SEQ | varchar(4) | not null | Sequence Number |
DOSE | varchar(47) | null | Dose(Normalized Dose) - this should be the dose dispensed. |
BSA | varchar(8) | null | Body Surface Area |
PAT_HEIGHT_CM | varchar(12) | null | Patient Height in Centimeters |
PAT_WEIGHT_KG | varchar(12) | null | Patient Weight in Kilograms |
PMP | varchar(6) | null | Pharmacy Order Number |
FCT | varchar(3) | null | Function which posted this transaction |
INITIALS | varchar(6) | null | Initials |
ENTERED_DATE | varchar(8) | null | Entered Date(YYYYMMDD) |
ACCUMULATED_DOSE | varchar(12) | null | This is what the system calculated as the patient's cumulative dose of this CDT after this dose was administered AT THE TIME the transaction was logged. |
DRUG_NAME | varchar(30) | null | Drug Name |
DRUG_CODE | varchar(5) | null | Drug Code |
COMMENTS | varchar(60) | null | Comments |
SITE | varchar(2) | null | Hospital Site |
PTNAME | varchar(32) | null | Patient Name |
PTBIRTH | varchar(8) | null | Patient Date of Birth(YYYYMMDD) |
PTAGE | varchar(4) | null | Patient Age |
ATTDOCNU | varchar(6) | null | Patient Attending Doctor Number |
ATTDOCNA | varchar(32) | null | Patient Attending Doctor Name |
ORD_DRNO | varchar(6) | null | Ordering Doctor Number |
ORD_DRNAME | varchar(32) | null | Ordering Doctor Name |
SIG | varchar(15) | null | SIG(Latin Directions Abbreviation) |
ROUTE | varchar(10) | null | Route of Administration |
IV_METHOD_CODE | varchar(2) | null | IV Method Code(0 to 10). See Pharmacy Method Masterfile PHM_METHOD_MF |
IV_METHOD | varchar(6) | null | IV Method Abbreviation(Ex: PUSH,LVP,TPN,...). See Pharmacy Method Masterfile PHM_METHOD_MF |
PTAGE_IN_DAYS | FLOAT | null | Patient Age Displayed in Number of Days |
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. |
|
|
|