Table Detail Report

HF_D_PERSONNEL



Column Section Top of Page


Table-level Detail

Description: HF_D_PERSONNEL
Definition: HF_D_PERSONNEL table
Table Type: REFERENCE





Column Detail - HF_D_PERSONNEL


Column Name Type Null? Definition
MEDICAL_SPECIALTY VARCHAR(40) Y The physician medical specialty
PERSONNEL_ADDRESS VARCHAR(255) Y The personnel address
PERSONNEL_CITY VARCHAR(100) Y The personnel city
PERSONNEL_ID DOUBLE N Primary key to the table. Uniquely defines a personnel record
PERSONNEL_NAME VARCHAR(200) Y The personnel name
PERSONNEL_PHONE VARCHAR(50) Y The personnel's phone number
PERSONNEL_POSITION VARCHAR(40) Y The personnel's position
PERSONNEL_STATE VARCHAR(40) Y The personnel state
PERSONNEL_ZIP_CODE VARCHAR(25) Y The personnel's zip code
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or 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_PERSONNEL_POSITION



Column Section Top of Page


Table-level Detail

Description: HF_D_PERSONNEL_POSITION
Definition: HF_D_PERSONNEL_POSITION table
Table Type: REFERENCE





Column Detail - HF_D_PERSONNEL_POSITION


Column Name Type Null? Definition
PERSONNEL_POSITION_DESC VARCHAR(60) Y The description for the personnel position.
PERSONNEL_POSITION_ID DOUBLE N Primary key to the table. Uniquely defines a personnel position record
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or 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_PERSON_RELTN



Column Section Top of Page


Table-level Detail

Description: HF_D_PERSON_RELTN
Definition: This is the HealthFacts dimension table that contains standard values for person relationships
Table Type: REFERENCE





Column Detail - HF_D_PERSON_RELTN


Column Name Type Null? Definition
PERSON_RELTN_DESC VARCHAR(60) Y A description of the type of relationship between two people
PERSON_RELTN_DISPLAY VARCHAR(40) Y A short display value for the type of relationship between two people
PERSON_RELTN_ID DOUBLE N Primary key to the table.
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_PHYSICIAN



Column Section Top of Page


Table-level Detail

Description: HF_D_PHYSICIAN
Definition: A dimension table that contains the physicians' information.
Table Type: REFERENCE





Column Detail - HF_D_PHYSICIAN


Column Name Type Null? Definition
MEDICAL_SPECIALTY VARCHAR(40) Y The medical specialty of a physician. A NULL means the physician id field was blank and therefore no medical specialty was provided.
NPI VARCHAR(200) Y The Physician's NPI (National Provider Identifier).
PHYSICIAN_ADDRESS VARCHAR(255) Y The full address of the physician.
PHYSICIAN_ADDRESS_2 VARCHAR(255) Y The second line of the address for the ordering physician.
PHYSICIAN_CALL_INSTRUCTIONS VARCHAR(300) Y Text field to be used to indicate any specific protocol or instructions to be followed when calling the physician number.
PHYSICIAN_CITY VARCHAR(100) Y The city of the physician.
PHYSICIAN_COUNTRY VARCHAR(100) Y The country of the physician.
PHYSICIAN_COUNTY VARCHAR(100) Y The county of the physician.
PHYSICIAN_EMAIL VARCHAR(100) Y The physician email address.
PHYSICIAN_EXTENSION VARCHAR(100) Y The physician's phone extension.
PHYSICIAN_FAX VARCHAR(50) Y The primary phone number of the physician.
PHYSICIAN_FIRST_NAME VARCHAR(100) Y The first name of the physician.
PHYSICIAN_ID DOUBLE Y PRIMARY KEY
PHYSICIAN_INITIALS VARCHAR(100) Y The initials of the physician.
PHYSICIAN_LAST_NAME VARCHAR(100) Y The last name of the physician.
PHYSICIAN_MIDDLE_NAME VARCHAR(100) Y The middle name of the physician.
PHYSICIAN_MOBILE VARCHAR(100) Y The primary phone number of the physician.
PHYSICIAN_NAME VARCHAR(200) Y The full name of the physician.
PHYSICIAN_PHONE VARCHAR(50) Y The full phone of the physician.
PHYSICIAN_PREFIX VARCHAR(100) Y The prefix of the physician.
PHYSICIAN_STATE VARCHAR(40) Y The state of the physician.
PHYSICIAN_SUFFIX VARCHAR(100) Y The suffix of the physician.
PHYSICIAN_TITLE VARCHAR(100) Y The title of the physician.
PHYSICIAN_ZIP_CODE VARCHAR(25) Y The full code of the physician_zip.
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.


HF_D_PHYSICIAN_TYPE



Column Section Top of Page


Table-level Detail

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





Column Detail - HF_D_PHYSICIAN_TYPE


Column Name Type Null? Definition
PHYSICIAN_TYPE_DESC VARCHAR(60) Y The description for the physician type
PHYSICIAN_TYPE_ID DOUBLE Y Primary key to the table. Uniquely defines a physician 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.