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 |
NEXTOFKIN_NAME | varchar(32) | null | Next of Kin Name |
RELATIONSHIP_CODE | varchar(3) | null | Relationship Code |
RELATIONSHIP_NAME | varchar(25) | null | Relationship Name |
NEXTOFKIN_ADDRESS | varchar(64) | null | Next of Kin Address |
NEXTOFKIN_CITY | varchar(32) | null | Next of Kin City |
NEXTOFKIN_STATE | varchar(2) | null | Next of Kin State |
NEXTOFKIN_ZIP | varchar(12) | null | Next of Kin Zip Code |
COUNTRY_CODE | varchar(3) | null | Country Code |
COUNTRY_NAME | varchar(25) | null | Country Name |
NEXTOFKIN_PHONE | varchar(24) | null | Next of Kin Phone |
NEXTOFKIN_LANGUAGE | varchar(17) | null | Next of Kin Language |
NEXTOFKIN_EMAIL | varchar(60) | null | Next of Kin Email |
COLLECTED_BY_ACCOUNT_NAME | varchar(12) | null | Collected By Account Name |
COLLECTED_BY_NAME | varchar(64) | null | Collected By Name |
ENTERED_BY_ACCOUNT_NAME | varchar(12) | null | Entered By Account Name |
ENTERED_DATE_TIME | varchar(12) | null | Entered Date/Time(YYYYMMDDHHMM) |
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. |
|
|
|