Table Detail Report

HF_D_ORDER_STOP_TYPE



Column Section Top of Page


Table-level Detail

Description: HF_D_ORDER_STOP_TYPE
Definition: This is the HealthFacts dimension table that contains standard values for order stop type
Table Type: REFERENCE





Column Detail - HF_D_ORDER_STOP_TYPE


Column Name Type Null? Definition
ORDER_STOP_TYPE_DESC VARCHAR(60) Y Primary key to the table. Uniquely defines an order stop type
ORDER_STOP_TYPE_ID DOUBLE Y The description for the order stop type
UPDT_DT_TM DATETIME Y The date/time that this record was updated.
UPDT_TASK VARCHAR(40) Y The application that performed the insert or update on this record. If this was done manually, 'MANUAL' should be entered.
UPDT_USER VARCHAR(40) Y The user id that performed the update or insert on this record.


HF_D_ORDER_TYPE



Column Section Top of Page


Table-level Detail

Description: HF_D_ORDER_TYPE
Definition: This is the HealthFacts dimension table that contains standard values for order type
Table Type: REFERENCE





Column Detail - HF_D_ORDER_TYPE


Column Name Type Null? Definition
ORDER_TYPE_DESC VARCHAR(60) Y The description for the order type
ORDER_TYPE_ID DOUBLE Y Primary key to the table. Uniquely defines a order type
UPDT_DT_TM DATETIME Y The date/time that this record was updated.
UPDT_TASK VARCHAR(40) Y The application that performed the insert or update on this record. If this was done manually, 'MANUAL' should be entered.
UPDT_USER VARCHAR(40) Y The user id that performed the update or insert on this record.


HF_D_PATIENT



Column Section Top of Page


Table-level Detail

Description: HF_D_PATIENT
Definition: This is the HealthFacts dimension table that contains a patient
Table Type: REFERENCE





Column Detail - HF_D_PATIENT


Column Name Type Null? Definition
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.


HF_D_PATIENT_TYPE



Column Section Top of Page


Table-level Detail

Description: HF_D_PATIENT_TYPE
Definition: This is the HealthFacts dimension table that contains standard values for patient types
Table Type: REFERENCE





Column Detail - HF_D_PATIENT_TYPE


Column Name Type Null? Definition
PATIENT_TYPE_DESC VARCHAR(60) Y A description of the patient type. Defines the type of visit made
PATIENT_TYPE_ID DOUBLE Y Primary key to the table. Uniquely defines a patient type
UPDT_DT_TM DATETIME Y The date/time that this record was updated.
UPDT_TASK VARCHAR(40) Y The application that performed the insert or update on this record. If this was done manually, 'MANUAL' should be entered.
UPDT_USER VARCHAR(40) Y The user id that performed the update or insert on this record.


HF_D_PAYER



Column Section Top of Page


Table-level Detail

Description: HF_D_PAYER
Definition: The dimension table of the possible payers.
Table Type: REFERENCE





Column Detail - HF_D_PAYER


Column Name Type Null? Definition
CO_DISPLAY VARCHAR(100) Y This is the Critical Outcomes description they want to see in the Critical Outcome Business Objects reports.
CO_IND DOUBLE Y This is an indicator 0 (no) or 1 (yes) if this is to be used for Critical Outcomes mappings. Some CO values are combinations and HF are separate or vice versa.
HF_IND DOUBLE Y Indicates if the record was generated via the Health Facts solution.
PAYER_CODE VARCHAR(30) Y The two character standard code found in the UB-04 billing file format.
PAYER_CODE_DESC VARCHAR(60) Y The long description for the primary payer.
PAYER_ID DOUBLE Y PRIMARY KEY
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.