Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
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 |
INTERVENTION_NO | varchar(6) | not null | Intervention Number |
CURRENT_INTERVEN | varchar(3) | not null | Current Intervention |
PERSON_NUMBER | varchar(16) | null | Identifies a Patient uniquely across multiple sites for a single enterprise |
PTMEDREC | varchar(12) | null | Medical Record Number |
STATUS | varchar(1) | null | Status(O=Open, C=Closed) |
ENTRY_DATE | varchar(8) | null | Entry Date(YYYYMMDD) |
ENTRY_TIME | varchar(5) | null | Entry Time(HH:MM) |
INITIALS | varchar(6) | null | Initials |
DRUG_CODE | varchar(5) | null | Drug Code |
GENERIC_NAME | varchar(30) | null | Generic Name of Drug |
PROBLEM_1 | varchar(6) | null | Problem 1 Code |
PROBLEM_1_DESC | varchar(30) | null | Problem 1 Code Description |
PROBLEM_CHARGE | varchar(8) | null | Problem Charge |
FUTURE | varchar(6) | null | Future use |
CLIN_SIGNIF_1 | varchar(6) | null | Clinical Significance 1 Code |
CLIN_SIGNIF_1_DESC | varchar(30) | null | Clinical Significance 1 Code Description |
ACTION_1 | varchar(6) | null | Action 1 Code |
ACTION_1_DESC | varchar(30) | null | Action 1 Code Description |
ACTION_2 | varchar(6) | null | Action 2 Code |
ACTION_2_DESC | varchar(30) | null | Action 2 Code Description |
ACTION_3 | varchar(6) | null | Action 3 Code |
ACTION_3_DESC | varchar(30) | null | Action 3 Code Description |
DR_NUM | varchar(6) | null | Doctor Number |
CONTACT | varchar(30) | null | Contact |
INTERVENTION_1 | varchar(6) | null | Intervention 1 Code |
INTERVENTION1_DESC | varchar(30) | null | Intervention 1 Code Description |
ACCEPT_1 | varchar(6) | null | Acceptance 1 Code |
ACCEPT_1_DESC | varchar(30) | null | Acceptance 1 Code Description |
OUTCOME_1 | varchar(6) | null | Outcome 1 Code |
OUTCOME_1_DESC | varchar(30) | null | Outcome 1 Code Description |
COMMENT_1 | varchar(65) | null | Comment 1 |
COMMENT_2 | varchar(65) | null | Comment 2 |
COMMENT_3 | varchar(65) | null | Comment 3 |
USER_FLD_1 | varchar(65) | null | User Field 1 |
USER_FLD_2 | varchar(65) | null | User Field 2 |
USER_FLD_3 | varchar(65) | null | User Field 3 |
USER_FLD_4 | varchar(65) | null | User Field 4 |
REVIEW_DATE | varchar(8) | null | Review Date(YYYYMMDD) |
DIAGNOSIS_1 | varchar(64) | null | Diagnosis 1 |
DIAGNOSIS_2 | varchar(64) | null | Diagnosis 2 |
TRANS_APP | varchar(8) | null | App which generated Transaction |
OWNER_APP | varchar(8) | null | App which owns intervention(Pharmacy or MAK) |
APP_ACCESS | varchar(6) | null | Access to this intervention granted to the other applications(None, View, Update) |
NRS_VERIFICATION | varchar(3) | null | Nurse Verification?(YES or NO) |
USERNAME | varchar(64) | null | Username |
SITE | varchar(2) | null | Hospital Site |
NDC_NUMBER | varchar(14) | null | NDC(National Drug Code) Number |
REVISED | varchar(1) | null | Revised?(R = YES, Null = No) |
IN_ACTIVE | varchar(3) | null | Is this record in the Active Patient Clinical Interventions Table(PHM_CLIN_INTERVS) Also?(YES or NO) |
GENERIC_NAME_TM_FLAG | varchar(3) | null | Generic Name Tall Man Flag(YES or NO) |
GCS | FLOAT | null | GCS(Generic Code Sequence Number) |
GENERIC_NAME_TM | varchar(30) | null | Generic Name of Drug in Tall Man Format |
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. |
|
|
|