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 |
PAT_ADDRESS | varchar(64) | null | Patient Address |
PAT_CITY | varchar(32) | null | Patient City |
PAT_STATE | varchar(2) | null | Patient State |
PAT_ZIP | varchar(12) | null | Patient Zip Code |
PTBIRTH | varchar(10) | null | Patient Birthdate(MM/DD/YYYY) |
PTBIRTH_ORDER | varchar(2) | null | Patient Birth Order |
PTBIRTH_PLACE | varchar(24) | null | Patient Birth Place |
COUNTRY_CODE | varchar(3) | null | Country Code |
COUNTRY_NAME | varchar(25) | null | Country Name |
COLLECTED_BY_ACCOUNT_NAME | varchar(12) | null | Collected By Account Name |
COLLECTED_BY_NAME | varchar(64) | null | Collected By Name |
ETHNIC_GROUP | varchar(50) | null | Ethnic Group |
PAT_EMAIL | varchar(60) | null | Patient Email |
ENTERED_BY_ACCOUNT_NAME | varchar(12) | null | Entered By Account Name |
ENTERED_DATE_TIME | varchar(12) | null | Entered Date/Time(YYYYMMDDHHMM) |
LOCATION | varchar(13) | null | Location(Nurse Station or Clinic) |
MULTIPLE_BIRTH | varchar(3) | null | Multiple Birth?(YES or NO) |
MOTHER_MAIDEN_NAME | varchar(30) | null | Mother's Maiden Name |
PTNAME | varchar(32) | null | Patient Name |
PTSEX | varchar(1) | null | Patient Sex. Allowable values: M - Male, F - Female, U - Unknown. |
PAT_PHONE | varchar(24) | null | Patient Phone |
PAT_RACE | varchar(50) | null | Patient Race |
PAT_SOC_SEC | varchar(11) | null | Patient Social Security Number |
SITE | varchar(2) | null | Hospital Site |
TID | varchar(3) | null | Terminal 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. |
|
|
|