ALT_PATIENT_ADDRESS_1 |
VARCHAR(100) |
Y |
The patient alternative first address. |
ALT_PATIENT_ADDRESS_2 |
VARCHAR(100) |
Y |
The patient alternative second address. |
ALT_PATIENT_CITY |
VARCHAR(100) |
Y |
The patient alternative city. |
ALT_PATIENT_COUNTRY |
VARCHAR(100) |
Y |
The patient alternative country. |
ALT_PATIENT_COUNTY |
VARCHAR(100) |
Y |
The patient alternative county. |
ALT_PATIENT_FIRST_NAME |
VARCHAR(100) |
Y |
The patient alternative first name. |
ALT_PATIENT_LAST_NAME |
VARCHAR(100) |
Y |
The patient alternative last name. |
ALT_PATIENT_NAME_INITIALS |
VARCHAR(100) |
Y |
The patient's alternative initials. |
ALT_PATIENT_NAME_PREFIX |
VARCHAR(100) |
Y |
The patient alternative name prefix. |
ALT_PATIENT_NAME_SUFFIX |
VARCHAR(100) |
Y |
The patient alternative name suffix. |
ALT_PATIENT_NAME_TITLE |
VARCHAR(100) |
Y |
The patient alternative name title. |
ALT_PATIENT_STATE |
VARCHAR(100) |
Y |
The patient alternative state. |
ALT_PATIENT_ZIP_CODE |
VARCHAR(25) |
Y |
The patient alternative zip code. |
ARCHIVE_IND |
DOUBLE |
Y |
An Indicator to show the which is the active, or most recent, record. |
BIRTH_DT_TM |
DATETIME |
Y |
Patient's birth date and time |
BUSINESS_CALL_INSTRUCTIONS |
VARCHAR(300) |
Y |
Text field to be used to indicate any specific protocol or instructions to be followed when calling the business phone number. |
BUSINESS_PHONE |
VARCHAR(100) |
Y |
The patient's business phone number. |
BUSINESS_PHONE_EXTENSION |
VARCHAR(100) |
Y |
The patient's business phone number extension. |
CALL_INSTRUCTION |
VARCHAR(300) |
Y |
Text field to be used to indicate any specific protocol or instructions to be followed when calling the business phone number. |
COMM_MED_RECORD_NBR_RAW |
VARCHAR(20) |
Y |
The raw community medical record number |
COMM_MED_RECORD_NUMBER |
VARCHAR(40) |
Y |
Patient community medical record number |
COUNTY_CODE |
VARCHAR(40) |
Y |
The source key of the county from the source system |
DECEASED_DT_TM |
DATETIME |
Y |
The date and time in which the patient expired. |
EMAIL_ADDRESS |
VARCHAR(100) |
Y |
The patient's email address. |
ETHNICITY |
VARCHAR(40) |
Y |
Identifies a religious national racial or cultural group of the person. |
EXTRACT_DT_TM |
DATETIME |
Y |
The date/time that the record was extracted from the source system. |
GENDER |
VARCHAR(40) |
Y |
Patient's gender |
LANGUAGE |
VARCHAR(120) |
Y |
The dialect of the primary language spoken by the person. |
MARITAL_STATUS |
VARCHAR(40) |
Y |
Patient's marital status |
MOTHER_MAIDEN_FIRST_NAME |
VARCHAR(200) |
Y |
The patient's mother's maiden first name. |
MOTHER_MAIDEN_LAST_NAME |
VARCHAR(200) |
Y |
The patient's mother's maiden last name. |
MOTHER_MAIDEN_NAME_INITIALS |
VARCHAR(100) |
Y |
The patient's mother's maiden name initials. |
MOTHER_MAIDEN_NAME_PREFIX |
VARCHAR(100) |
Y |
The patient's mother's maiden name prefix. |
MOTHER_MAIDEN_NAME_SUFFIX |
VARCHAR(100) |
Y |
The patient's mother's maiden name suffix. |
MOTHER_MAIDIN_NAME_TITLE |
VARCHAR(100) |
Y |
The patient's mother's maiden name title. |
NAME_INITIALS |
VARCHAR(100) |
Y |
The patient's initials. |
NAME_PREFIX |
VARCHAR(100) |
Y |
The prefix of the patient name. |
NAME_SUFFIX |
VARCHAR(100) |
Y |
The suffix of the patient name. |
NAME_TITLE |
VARCHAR(100) |
Y |
The title of the patient. |
NEXT_OF_KIN_ADDRESS_1 |
VARCHAR(100) |
Y |
The address of the patient's closest living blood relative or relatives |
NEXT_OF_KIN_ADDRESS_2 |
VARCHAR(100) |
Y |
The address of the patient's closest living blood relative or relatives |
NEXT_OF_KIN_CALL_INSTRUCTIONS |
VARCHAR(300) |
Y |
Text field to be used to indicate any specific protocol or instructions to be followed when calling the next of kin number. |
NEXT_OF_KIN_CITY |
VARCHAR(100) |
Y |
The city where the patient's closest living blood relative or relatives live |
NEXT_OF_KIN_FIRST_NAME |
VARCHAR(100) |
Y |
The first name of the patient's closest living blood relative or relatives |
NEXT_OF_KIN_LAST_NAME |
VARCHAR(100) |
Y |
The last name of the patient's closest living blood relative or relatives |
NEXT_OF_KIN_MIDDLE_NAME |
VARCHAR(100) |
Y |
The middle name of the patient's closest living blood relative or relatives |
NEXT_OF_KIN_NAME |
VARCHAR(200) |
Y |
The person name of the patient's closest living blood relative or relatives |
NEXT_OF_KIN_PHONE |
VARCHAR(50) |
Y |
The phone number of the patient's closest living blood relative or relatives live |
NEXT_OF_KIN_PHONE_EXTENSION |
VARCHAR(100) |
Y |
The patient's next of kin's phone extension. |
NEXT_OF_KIN_RELATION |
VARCHAR(40) |
Y |
The relationship type of the patient's closest living blood relative to the patient |
NEXT_OF_KIN_RELATION_CODE |
VARCHAR(40) |
Y |
The relationship of the next of kin to the patient. |
NEXT_OF_KIN_STATE |
VARCHAR(50) |
Y |
The state where the patient's closest living blood relative or relatives live |
NEXT_OF_KIN_ZIP_CODE |
VARCHAR(25) |
Y |
The zip code where the patient's closest living blood relative or relatives live |
NOK_COUNTRY |
VARCHAR(50) |
Y |
The country of the patient's next of kin. |
NOK_COUNTY |
VARCHAR(50) |
Y |
The county of the patient's next of kin. |
NOK_EMAIL_ADDRESS |
VARCHAR(100) |
Y |
The email of the patient's next of kin. |
NOK_NAME_INITIALS |
VARCHAR(100) |
Y |
The patient's next of kin initials. |
NOK_NAME_PREFIX |
VARCHAR(100) |
Y |
The patient's next of kin's name prefix. |
NOK_NAME_SUFFIX |
VARCHAR(100) |
Y |
The patient's next of kin's name suffix. |
NOK_NAME_TITLE |
VARCHAR(100) |
Y |
The patient's next of kin's title. |
PATIENT_ADDRESS_1 |
VARCHAR(100) |
Y |
Patient's home address |
PATIENT_ADDRESS_2 |
VARCHAR(100) |
Y |
Patient's home address |
PATIENT_CITY |
VARCHAR(100) |
Y |
City of the patient's home |
PATIENT_COUNTRY |
VARCHAR(50) |
Y |
Country of the patient's home |
PATIENT_COUNTY |
VARCHAR(50) |
Y |
County of the patient's home |
PATIENT_FIRST_NAME |
VARCHAR(100) |
Y |
Patient's first name |
PATIENT_ID |
DOUBLE |
Y |
Primary key to the table. Unique defines a physician |
PATIENT_LAST_NAME |
VARCHAR(100) |
Y |
Patient's last name |
PATIENT_MAIDEN_LAST_NAME |
VARCHAR(100) |
Y |
The patient's maiden last name. |
PATIENT_MIDDLE_NAME |
VARCHAR(100) |
Y |
Patient's middle name |
PATIENT_MOBILE |
VARCHAR(100) |
Y |
The patient's mobile phone number. |
PATIENT_NAME |
VARCHAR(200) |
Y |
Patient's name |
PATIENT_PHONE |
VARCHAR(50) |
Y |
Patient's phone number |
PATIENT_SK |
VARCHAR(45) |
Y |
This is the value of the unique primary identifier of the patient table. It is an internal system assigned number. |
PATIENT_SSN |
VARCHAR(40) |
Y |
Patient's social security number |
PATIENT_STATE |
VARCHAR(50) |
Y |
State of the patient's home |
PATIENT_ZIP_CODE |
VARCHAR(25) |
Y |
Zipcode of the patient's home |
PHONE_EXTENSION |
VARCHAR(100) |
Y |
The patient's phone extension. |
RACE |
VARCHAR(40) |
Y |
Patient's race |
RELIGION |
VARCHAR(120) |
Y |
The religion of the patient registered (I.e. Baptist Catholic Methodist etc.) |
REMARK |
VARCHAR(100) |
Y |
REMARKS |
TEST_PATIENT_IND |
DOUBLE |
Y |
This field indicates if the record is a test patient based on internal logic on the patient name. |
UPDT_DT_TM |
DATETIME |
Y |
The date and time the row was last inserted or updated. |
UPDT_TASK |
VARCHAR(40) |
Y |
The registered (assigned) task number for the process that inserted or updated the row. |
UPDT_USER |
VARCHAR(40) |
Y |
The user id that performed the update or insert on this record. |
VIP_IND |
DOUBLE |
Y |
An indicator to flag persons as VIPs or not. 0 no and 1 yes. |
VITAL_STATUS |
VARCHAR(60) |
Y |
A field that identifies alive, deceased status. |