ACUTE_IND |
DOUBLE |
Y |
Indicates if the facility is an acute or non-acute care facility |
ACUTE_STATUS |
VARCHAR(20) |
Y |
Indicated whether the facility is an acute or non-acute care facility. |
ALT_HEALTH_SYSTEM_ID |
DOUBLE |
Y |
The unique Health System Identifier for the alternative hospital. |
ALT_HOSPITAL_ID |
DOUBLE |
Y |
The unique identifier for the alternative hospital. |
BED_SIZE_RANGE |
VARCHAR(10) |
Y |
Gives the approximate number of beds in a hospital. |
CATH_LAB_DIAGNOSTIC_IND |
DOUBLE |
Y |
Indicates whether the facility has a diagnostic Catheterization laboratory |
CATH_LAB_FULL_IND |
DOUBLE |
Y |
Indicates whether the facility has a full Catheterization laboratory |
CENSUS_DIVISION |
VARCHAR(40) |
Y |
Specifies which of the 9 census divisions (New England, Middle Atlantic, West North Central, East North Central, East South Central, South Atlantic, West South Central, Mountain, Pacific) the facility is located in |
CENSUS_REGION |
VARCHAR(40) |
Y |
Specifies which of the four census regions (Northeast, Midwest, South, West) the facility is located in |
CLIA_NBR |
VARCHAR(10) |
Y |
The CLIA number associated with the facility |
COUNTY_FIPS_CODE |
VARCHAR(10) |
Y |
The FIPS county code is a three-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies counties and county equivalents in the United States, certain U.S. possessions, and certain freely associated states. The first two digits are the FIPS state code and the last three are the county code within the state or possession. |
CREATE_PSP_REPORT_IND |
DOUBLE |
Y |
Indicates if the facility should have PSP reports created |
DEFAULT_FACILITY_IND |
DOUBLE |
Y |
Indicates that this is the default facility for the hospital. |
DIRECTOR_FIRST_NAME |
VARCHAR(100) |
Y |
The first name of the Director of the hospital. |
DIRECTOR_LAST_NAME |
VARCHAR(100) |
Y |
The last name of the Director of the hospital. |
DIRECTOR_MIDDLE_NAME |
VARCHAR(100) |
Y |
The middle name of the Director of the hospital. |
DIRECTOR_PREFIX |
VARCHAR(10) |
Y |
The prefix of the Director of the hospital. |
DIRECTOR_SUFFIX |
VARCHAR(10) |
Y |
The suffix of the Director of the hospital. |
DIRECTOR_TITLE |
VARCHAR(10) |
Y |
The title of the Director of the hospital. |
HEALTHFACTS_IND |
DOUBLE |
Y |
This is an indicator 0 (no) or 1 (yes) if this is to be used for Health Data (Health Facts or HealthSentry) mapping purposes. |
HEALTHSENTRY_IND |
DOUBLE |
Y |
This is an indicator 0 (no) or 1 (yes) if this is to be used for Health Data (Health Facts or HealthSentry) mapping purposes. |
HEALTH_SYSTEM_ID |
DOUBLE |
Y |
The health system that the hospital belongs to |
HOSPITAL_ADDRESS |
VARCHAR(100) |
Y |
Address of the hospital |
HOSPITAL_ADDRESS_2 |
VARCHAR(100) |
Y |
The second line of address for the hospital. |
HOSPITAL_CALL_INSTRUCTIONS |
VARCHAR(300) |
Y |
The documented instructions for how to contact the hospital. |
HOSPITAL_CBSA |
VARCHAR(25) |
Y |
Core Based Statistical Area for the hospital. http://www.zip-codes.com/. Look up the zip code to find the CBSA. |
HOSPITAL_CITY |
VARCHAR(100) |
Y |
City of the hospital |
HOSPITAL_CODE |
DOUBLE |
Y |
A Millennium identifier for the hospital |
HOSPITAL_COUNTRY |
VARCHAR(100) |
Y |
The country in which the hospital resides. |
HOSPITAL_COUNTY |
VARCHAR(100) |
Y |
The county in which the hospital resides. |
HOSPITAL_DISPLAY |
VARCHAR(30) |
Y |
The display value of the hospital. |
HOSPITAL_EXTENSION |
VARCHAR(100) |
Y |
The phone extension for the hospital. |
HOSPITAL_ID |
DOUBLE |
Y |
Primary key to the table. Uniquely defines an isolate |
HOSPITAL_NAME |
VARCHAR(255) |
Y |
Name of the hospital |
HOSPITAL_OID |
VARCHAR(100) |
Y |
The OID of the hospital. |
HOSPITAL_PHONE |
VARCHAR(30) |
Y |
Phone number for the hospital |
HOSPITAL_STATE |
VARCHAR(50) |
Y |
State of the hospital |
HOSPITAL_ZIP |
VARCHAR(25) |
Y |
Zipcode of the hospital |
INSTITUTION_REF |
VARCHAR(40) |
Y |
Code value that defines that institution. This field is used in conjunction with Health_System_ID to join activity data to this table. |
NPI |
VARCHAR(10) |
Y |
National Provider Identifier (NPI) is a Health Insurance Portability and Accountability Act (HIPAA) Administrative Simplification Standard. The NPI is a unique identification number for covered health care providers. |
PERFORM_FACILITY_IND |
DOUBLE |
Y |
Indicates that this is a performing facility for the hospital. |
STATE_FIPS_CODE |
VARCHAR(10) |
Y |
The FIPS State code is a two-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies States and State equivalents in the United States, certain U.S. possessions, and certain freely associated states. |
TEACHING_FACILITY_IND |
DOUBLE |
Y |
Indicates if the facility is a teaching facility |
TOTAL_BEDS |
DOUBLE |
Y |
Number of beds in a hospital. Only populated for HealthSentry |
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. |
URBAN_RURAL_STATUS |
VARCHAR(20) |
Y |
Urban or rural indicator for this facility. U (Urban), R (Rural) |
URBAN_RURAL_STATUS_IND |
DOUBLE |
Y |
Indicates if the facility is in an urban or rural area |