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. |