Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
IMR | varchar(12) | not null | Internal Number used to create a Unique Key for Historical Files |
PAT_NUM | varchar(12) | not null | Patient Number |
SEQ | varchar(12) | not null | Sequence Number |
CODE_AS_RECEIVED_OR_ENTERED | varchar(8) | null | ICD9(International Classification of Diseases, Ninth Revision Code) Code as Received or Entered.(Link to PHM_ICD9_CODES.ICD9_CM) |
CONDITION_DESCRIPTION | varchar(80) | null | Condition Description |
CONDITION_ONSET_DATTIM | varchar(30) | null | Condition Onset Date/Time(YYYYMMDDHHMM or Free Text) |
CONDITION_RESOLUTION_DATTIM | varchar(12) | null | Condition Resolution Date/Time(YYYYMMDDHHMM) |
DATTIM_ENTERED | varchar(12) | null | Date/Time Entered(YYYYMMDDHHMM) |
CONDITION_STATUS | varchar(15) | null | Condition Status(NOT REVIEWED, REVIEWED, INACTIVE, ERRONEOUS, UNKNOWN) |
MERGE_COMMENT | varchar(80) | null | Merge Comment |
DIAGNOSIS_AS_RECEIVED | varchar(80) | null | Diagnosis as Received |
ONGOING_COND_INDICATOR | varchar(20) | null | Ongoing Condition Indicator(ADMISSION SPECIFIC, ONGOING CONDITION, UNKNOWN) |
ENTER_USER_ID | varchar(12) | null | Enter User ID |
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. |
|
|
|