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) | null | Patient Number |
PTNAME | varchar(32) | null | Patient Name |
PT_NRSTA | varchar(6) | null | Nurse Station(For EHI-EXPORT, for values please refer to Soarian Clinical's table HHealthCareUnit; columns HealthCareUnitName or Abbreviation.) |
BED_CODE | varchar(6) | null | Bed |
PTAGE | varchar(6) | null | Patient Age |
PTBIRTH | varchar(10) | null | Patient Date of Birth(MM/DD/YYYY) |
PTSEX | varchar(1) | null | Patient Sex |
PT_HEADER_DOC_NA | varchar(30) | null | Patient Header Doctor Name |
HEIGHT | varchar(32) | null | Patient Height |
WEIGHT | varchar(32) | null | Patient Weight |
PTTYPE | varchar(1) | null | Patient Type(Link to PTM.PTTYPE) |
PTSERV | varchar(3) | null | Patient Service(For EHI-EXPORT, for values please refer to Soarian Clinical's table HHealthCareUnit; columns HealthCareUnitName or Abbreviation.) |
PTAGE_IN_DAYS | FLOAT | null | Patient Age Displayed in Number of Days |
PERSON_NUMBER | varchar(16) | null | Identifies a Patient uniquely across multiple sites for a single enterprise |
PTMEDREC | varchar(16) | null | Medical Record Number |
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. |
|
|
|