Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
ITN | varchar(12) | not null | Internal Number used to create a Unique Key for Active Patient Files |
EDM_DOCUMENT_ID | varchar(64) | not null | EDM(Enterprise Document Management) Document ID |
EDM_VERSION | varchar(1) | null | EDM(Enterprise Document Management) Version |
EDM_OBJECT_TYPE | varchar(1) | null | EDM(Enterprise Document Management) Object Type |
EDM_DB_ID | varchar(4) | null | EDM(Enterprise Document Management) Database Id |
EDM_USER_ID | varchar(20) | null | EDM(Enterprise Document Management) User Id |
RECEIVED_DATE_TIME | varchar(12) | null | Received Date/Time(YYYYMMDDHHMM) |
DOCUMENT_STATUS | varchar(1) | null | Document Status(0 = HOLD, 1 = INCOMPLETE, 2 = COMPLETE) |
DOCUMENT_STATUS_DESC | varchar(12) | null | Document Status Description |
STAT | varchar(3) | null | Stat?(YES or NO) |
EDM_DOCUMENT_NAME | varchar(30) | null | EDM(Enterprise Document Management) Document Name |
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. |
|
|
|