Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
SITE | varchar(2) | not null | Hospital Site |
TID | varchar(3) | null | Terminal ID |
NAME | varchar(30) | null | Site Name |
ADDRESS | varchar(64) | null | Address |
CITY | varchar(32) | null | City |
STATE | varchar(2) | null | State |
ZIP | varchar(12) | null | Zip Code |
PHONE | varchar(24) | null | Phone |
ENHANCED_RX_CHARGING | varchar(3) | null | Enhanced RX Charging(YES or NO) |
SERVICE_PROVIDER_ID | varchar(32) | null | Service Provider Id |
MAC_RECOVERY_FROM_DATTIM | varchar(18) | null | Med Administration Check Recovery From Date/Time(MM/DD/YYYY HH:MM or MM/DD/YYYY HH:MMxx) |
MAC_RECOVERY_THROUGH_DATTIM | varchar(18) | null | Med Administration Check Recovery Through Date/Time(MM/DD/YYYY HH:MM or MM/DD/YYYY HH:MMxx) |
CCOW_SUFFIX | varchar(10) | null | CCOW(Clinical Context Object Workgroup) Suffix |
MS4_SITE_ID | varchar(12) | null | MS4 Site Id |
CHARGE_RECORD_TYPE | varchar(8) | null | Charge Record Type(HL7 or 48/49) |
FACILITY_URL | varchar(128) | null | Facility URL |
FIN_HIS_FOR_JCODE_WASTE | varchar(12) | null | Financial Hospital Information System for JCode Waste(MS4, SOARIAN, or INVISION) |
VXU_OBJ_IDENTIFIER | varchar(32) | null | VXU(Vaccination Record Update) Object Identifier |
VXU_MEANINGFUL_USE_STAGE | varchar(2) | null | VXU(Vaccination Record Update) Meaningful Use Stage |
LTC_PROCESSING | varchar(3) | null | Long Term Care Processing?(YES or NO) |
CLIN_SYS_ORG_CODE | varchar(10) | null | Clinical System Organization Code. This value is only used by the 'Pharmacy to Cerner DSS(Data Wharehouse) Extract' processing. |
IMMUNIZ_QUERIES | varchar(7) | null | Immunization Queries(AIS or IIS) |
NHSN_FACILITY_OID | varchar(60) | null | NHSN_FACILITY_OID(National Healthcare Safety Network) |
NHSN_FACILITY_ID | varchar(60) | null | NHSN_FACILITY_ID(National Healthcare Safety Network) |
|
|
|