BDNA Data Platform 5.4 July 2017 (SQL Server)
CAT_MDS2 - Manufacturer Disclosure Statement for Medical Device Security (MDS2) Info

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
CAT_MDS2_ID numeric 20  √  null Unique identifier of CAT_MDS2 table
CREATE_DATE datetime 16,3  √  null The date when the row was first created in the table and column specified in TABLE_NAME and COLUMN_NAME
LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made in the table and column specified in TABLE_NAME and COLUMN_NAME
EPHI_MANAGEMENT varchar 10  √  null Private Data Management, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TYPE_DEMOGRAPHIC varchar 10  √  null Private Data Type - Demographic, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TYPE_MEDICAL_RECORD varchar 10  √  null Private Type - Medical Record, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TYPE_DIAGNOSTIC varchar 10  √  null Private Type - Diagnostic/therapeutic, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TYPE_USER_ENTERED_TEXT varchar 10  √  null Private Data Type - User-entered Text, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TYPE_BIOMETRIC_DATA varchar 10  √  null Private Data Type - Biometric Data, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TYPE_PERSONAL_FINANCIAL varchar 10  √  null Private Data Type - Personal Financial, 'No', 'Yes', 'N/A', 'See notes'
EPHI_MAINT_TEMP_MEMORY varchar 10  √  null Private Data Maintenance - Temporary memory, 'No', 'Yes', 'N/A', 'See notes'
EPHI_MAINT_PERSIS_LOCALMEDIA varchar 10  √  null Private Data Maintenance - Persistent Local Media, 'No', 'Yes', 'N/A', 'See notes'
EPHI_MAINT_IMPORT_EXPORT varchar 10  √  null Private Data Maintenance - Import/Export, 'No', 'Yes', 'N/A', 'See notes'
EPHI_MAINT_POWER_INTERRUPTION varchar 10  √  null Private Data Maintenance - Power Interruption, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TRANS_DISPLAY varchar 10  √  null Private Data Transmission - Display, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TRANS_HARDCOPY varchar 10  √  null Private Data Transmission - Hardcopy, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TRANS_REMOVABLE_MEDIA varchar 10  √  null Private Data Transmission - Removable Media, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TRANS_CABLE varchar 10  √  null Private Data Transmission - Cable, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TRANS_WIRED_NETWORK varchar 10  √  null Private Data Transmission - Wired Network, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TRANS_WIRELESS_NETWORK varchar 10  √  null Private Data Transmission - Wireless Network, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TRANS_SCANNING varchar 10  √  null Private Data Transmission - Scanning, 'No', 'Yes', 'N/A', 'See notes'
EPHI_TRANS_OTHER varchar 10  √  null Private Data Transmission - Other, 'No', 'Yes', 'N/A', 'See notes'
ALOF_INACTIVITY_LOCK varchar 10  √  null Automatic Logoff - Inactivity Lock, 'No', 'Yes', 'N/A', 'See notes'
ALOF_INACTIVITY_LENGTH varchar 10  √  null Automatic Logoff - Inactivity Length Configurable, 'No', 'Yes', 'N/A', 'See notes'
ALOF_MANUAL_LOCK varchar 10  √  null Automatic Logoff - Manual Lock, 'No', 'Yes', 'N/A', 'See notes'
AUDT_AUDIT_TRAIL varchar 10  √  null Audit Control - Audit Trail, 'No', 'Yes', 'N/A', 'See notes'
AUDT_TYPE_LOGIN_LOGOUT varchar 10  √  null Audit Control Type - Login/Logout, 'No', 'Yes', 'N/A', 'See notes'
AUDT_TYPE_DATA_DISPLAY varchar 10  √  null Audit Control Type - Data Display, 'No', 'Yes', 'N/A', 'See notes'
AUDT_TYPE_DATA_CHANGES varchar 10  √  null Audit Control Type - Data Changes, 'No', 'Yes', 'N/A', 'See notes'
AUDT_TYPE_DATA_IMPORT_EXPORT varchar 10  √  null Audit Control Type - Data Import/Export, 'No', 'Yes', 'N/A', 'See notes'
AUDT_TYPE_DATA_TRANS varchar 10  √  null Audit Control Type - Data Transmission, 'No', 'Yes', 'N/A', 'See notes'
AUDT_TYPE_REMOTE_ACTIVITY varchar 10  √  null Audit Control Type - Remote Activity, 'No', 'Yes', 'N/A', 'See notes'
AUDT_TYPE_OTHER varchar 10  √  null Audit Control Type - Other, 'No', 'Yes', 'N/A', 'See notes'
AUDT_IDENTIFIER_USERID varchar 10  √  null Audit Control Identifier - User ID, 'No', 'Yes', 'N/A', 'See notes'
AUDT_IDENTIFIER_DATE varchar 10  √  null Audit Control Identifier - Date/Time, 'No', 'Yes', 'N/A', 'See notes'
AUTH_UNAUTHORIZED_ACCESS varchar 10  √  null Authorization - Unauthorized User Prevention, 'No', 'Yes', 'N/A', 'See notes'
AUTH_ROLEBASED_PRIVILEGES varchar 10  √  null Authorization - Role-Based Privileges, 'No', 'Yes', 'N/A', 'See notes'
AUTH_ADMIN_PRIVILEGE varchar 10  √  null Authorization - Admin Privile.ge, 'No', 'Yes', 'N/A', 'See notes'
CNFS_CONFIGURABLE varchar 10  √  null Security Configuration - Configurable, 'No', 'Yes', 'N/A', 'See notes'
CSUP_OS_SECURITY_PATCHES varchar 10  √  null Product Upgrades - OS and Security Patches, 'No', 'Yes', 'N/A', 'See notes'
CSUP_REMOTE_PATCHES varchar 10  √  null Product Upgrades - Remote Patches, 'No', 'Yes', 'N/A', 'See notes'
DIDT_DEIDENTIFY_CAPABILITY varchar 10  √  null Data De-Identify Capability, 'No', 'Yes', 'N/A', 'See notes'
DTBK_BACKUP_CAPABILITY varchar 10  √  null Data backup Capability, 'No', 'Yes', 'N/A', 'See notes'
EMRG_EMERGENCY_ACCESS varchar 10  √  null Emergency Access Feature, 'No', 'Yes', 'N/A', 'See notes'
IGAU_DATA_INTEGRITY varchar 10  √  null Data Integrity - Error Detection/Correction , 'No', 'Yes', 'N/A', 'See notes'Technology
MLDP_ANTI_MALWARE_SUPPORT varchar 10  √  null Malware Protection Support, 'No', 'Yes', 'N/A', 'See notes'
MLDP_USER_CONFIGURABLE varchar 10  √  null Malware Protection - User Configurable, 'No', 'Yes', 'N/A', 'See notes'
MLDP_NOTIFICATION varchar 10  √  null Malware Protection - Notification, 'No', 'Yes', 'N/A', 'See notes'
MDLP_MFR_REPAIR_ONLY varchar 10  √  null Malware Protection - Manufacturer-Authorized Repair Only, 'No', 'Yes', 'N/A', 'See notes'
MDLP_OWNER_INSTALL_UPDATE varchar 10  √  null Malware Protection - Owner Install/Update, 'No', 'Yes', 'N/A', 'See notes'
MDLP_OWNER_AV_DEF_UPATE varchar 10  √  null Malware Protection - Owner Virus Definition Update, 'No', 'Yes', 'N/A', 'See notes'
NAUT_NODE_AUTH_SUPPORT varchar 10  √  null Node Authentication Support, 'No', 'Yes', 'N/A', 'See notes'
PAUT_SINGLE_USER varchar 10  √  null Person Authentication - Single User, 'No', 'Yes', 'N/A', 'See notes'
PAUT_MULTI_USER varchar 10  √  null Person Authentication - Multi User, 'No', 'Yes', 'N/A', 'See notes'
PAUT_EXT_AUTH_SERVICE varchar 10  √  null Person Authentication - External Authentication Service, 'No', 'Yes', 'N/A', 'See notes'
PAUT_UNSUCCESS_LOGON_LOCK varchar 10  √  null Person Authentication - Unsuccessful Logon Attempts Lock, 'No', 'Yes', 'N/A', 'See notes'
PAUT_CHANGE_DEFAULT_PWD varchar 10  √  null Person Authentication - Change Default Password, 'No', 'Yes', 'N/A', 'See notes'
PAUT_SHARED_USERID varchar 10  √  null Person Authentication - Shared User ID, 'No', 'Yes', 'N/A', 'See notes'
PAUT_PWD_COMPLEXITY_RULES varchar 10  √  null Person Authentication - Password Complexity Rules, 'No', 'Yes', 'N/A', 'See notes'
PAUT_PWD_EXPIRATION varchar 10  √  null Person Authentication - Password Expiration, 'No', 'Yes', 'N/A', 'See notes'
PLOCK_PHYSICAL_LOCKS varchar 10  √  null Whole Device Physical Locks, 'No', 'Yes', 'N/A', 'See notes'
RDMP_OS varchar 10  √  null Third-Party Support in Roadmap - Operating Systems, 'No', 'Yes', 'N/A', 'See notes'
RDMP_LIST_AVAILABLE varchar 10  √  null Third-Party Support in Roadmap - List is Provided, 'No', 'Yes', 'N/A', 'See notes'
SAHD_HARDENING_MEASURES varchar 10  √  null Hardening Measure - Employed, Conformance Level, 'No', 'Yes', 'N/A', 'See notes'
SAHD_MFR_UPDATE_ONLY varchar 10  √  null Hardening Measure - Manufacturer-Authorized Program/Update, 'No', 'Yes', 'N/A', 'See notes'
SAHD_EXT_COMMUNICATION varchar 10  √  null External Communication Capability, 'No', 'Yes', 'N/A', 'See notes'
SAHD_FILE_LEVEL_ACL varchar 10  √  null File-Level Access Control Capability, 'No', 'Yes', 'N/A', 'See notes'
SAHD_ACOUNT_DISABLED varchar 10  √  null Non-required Accounts Disabled, 'No', 'Yes', 'N/A', 'See notes'
SAHD_SHARED_RESOURCES_DISABLED varchar 10  √  null Selective Disablement of Shared Resources, 'No', 'Yes', 'N/A', 'See notes'
SAHD_PORTS_DISABLED varchar 10  √  null Selective Disablement of Communication Ports, 'No', 'Yes', 'N/A', 'See notes'
SAHD_SERVICES_DISABLED varchar 10  √  null Selective Disablement of Services, 'No', 'Yes', 'N/A', 'See notes'
SAHD_APPLICATIONS_DISABLED varchar 10  √  null Selective Disablement of Applications, 'No', 'Yes', 'N/A', 'See notes'
SAHD_BOOT_FR_REMOVABLE_MEDIA varchar 10  √  null Boot from Removable Media, 'No', 'Yes', 'N/A', 'See notes'
SAHD_INST_NON_AUTH_SW_HW varchar 10  √  null Install Non-Manufacturer Authorized Software/Hardware, 'No', 'Yes', 'N/A', 'See notes'
SGUD_SECURITY_USER_DOC varchar 10  √  null Security Features Documented, 'No', 'Yes', 'N/A', 'See notes'
SGUD_SANITIZATION_DOC varchar 10  √  null Device/Media Sanitization Instructions, 'No', 'Yes', 'N/A', 'See notes'
STCF_DATA_ENCRYPTED_AT_REST varchar 10  √  null Device Encrypt Data At Rest, 'No', 'Yes', 'N/A', 'See notes'
TXCF_DEDICATED_CABLE_DATA varchar 10  √  null Transmission Confidentiality - Dedicated Cable Data Transmission Only, 'No', 'Yes', 'N/A', 'See notes'
TXCF_ENCRYPT_DATA varchar 10  √  null Transmission Confidentiality - Encrypted Data Transmission, 'No', 'Yes', 'N/A', 'See notes'
TXCF_FIXED_LIST_DEST varchar 10  √  null Transmission Confidentiality - Fixed List Transmission Destinations, 'No', 'Yes', 'N/A', 'See notes'
TXIG_DATA_INTEGRITY varchar 10  √  null Transmission Integrity Support, 'No', 'Yes', 'N/A', 'See notes'
OTHR_REMOTE_SERVICE varchar 10  √  null Remote Service, 'No', 'Yes', 'N/A', 'See notes'
OTHR_REMOTE_ACL varchar 10  √  null Remote Access Restrictions, 'No', 'Yes', 'N/A', 'See notes'
OTHR_REMOTE_ACCEPT_INITIATE varchar 10  √  null Accept or Initiate Remote Access, 'No', 'Yes', 'N/A', 'See notes'
MDS2_DOCUMENT_DATE varchar 10  √  null MDS2 Document Date, 'No', 'Yes', 'N/A', 'See notes'
MDS2_DOCUMENT_URL varchar 255  √  null MDS2 Document URL, 'No', 'Yes', 'N/A', 'See notes'
NOTES_AVAILABLE varchar 1  √  null MDS2 Notes Available, 'No', 'Yes', 'N/A', 'See notes'
MDS2_DOCUMENT_ID varchar 1024  √  null MDS2 Document ID
COMPANY_NAME varchar 3000  √  null Company Name
REPRESENTATIVE varchar 3000  √  null Representative Name/Position
MFR_CONTACT varchar 1024  √  null Manufacturer Contact Information
INTENDED_USE varchar 1024  √  null Intented Use
NEMA_VERSION varchar 1024  √  null NEMA Version
TO_BE_DELETED varchar 1  √  null Would this record be deleted? eg: Y
TO_BE_DELETED_ON datetime 16,3  √  null The date when this record would be deleted
DELETE_REASON varchar 500  √  null The reason why the entry is marked to be deleted (Values: Duplicate,Inaccurate)
PRIVATE_FLAG numeric 20  √  null 0 = Not Modified (i.e. original Technopedia entry),1 = Modified Technopedia object, 2 = Proprietary object (those that have negative ids)
IS_PRIVATE varchar 1  √  null y = a private entry, n = original Technopedia entry
PRIVATE_TYPE varchar 500  √  null PRIVATE_TYPE = NULL if PRIVATE_FLAG = 0,PRIVATE_TYPE = Modified Technopedia entry if PRIVATE_FLAG = 1,PRIVATE_TYPE = Proprietary entry if PRIVATE_FLAG = 2
REPLACEMENT_ID numeric 20  √  null Unique identifier of the replacement entry whenever the entry is marked to be deleted for 'Duplicate' reason

Analyzed at Thu Jul 20 12:14 PDT 2017

View Definition:
CREATE VIEW CAT_MDS2 AS SELECT f_tcat.CAT_MDS2_ID,f_tcat.CREATE_DATE,f_tcat.LAST_MODIFIED_DATE,f_tcat.EPHI_MANAGEMENT,f_tcat.EPHI_TYPE_DEMOGRAPHIC,f_tcat.EPHI_TYPE_MEDICAL_RECORD,f_tcat.EPHI_TYPE_DIAGNOSTIC,f_tcat.EPHI_TYPE_USER_ENTERED_TEXT,f_tcat.EPHI_TYPE_BIOMETRIC_DATA,f_tcat.EPHI_TYPE_PERSONAL_FINANCIAL,f_tcat.EPHI_MAINT_TEMP_MEMORY,f_tcat.EPHI_MAINT_PERSIS_LOCALMEDIA,f_tcat.EPHI_MAINT_IMPORT_EXPORT,f_tcat.EPHI_MAINT_POWER_INTERRUPTION,f_tcat.EPHI_TRANS_DISPLAY,f_tcat.EPHI_TRANS_HARDCOPY,f_tcat.EPHI_TRANS_REMOVABLE_MEDIA,f_tcat.EPHI_TRANS_CABLE,f_tcat.EPHI_TRANS_WIRED_NETWORK,f_tcat.EPHI_TRANS_WIRELESS_NETWORK,f_tcat.EPHI_TRANS_SCANNING,f_tcat.EPHI_TRANS_OTHER,f_tcat.ALOF_INACTIVITY_LOCK,f_tcat.ALOF_INACTIVITY_LENGTH,f_tcat.ALOF_MANUAL_LOCK,f_tcat.AUDT_AUDIT_TRAIL,f_tcat.AUDT_TYPE_LOGIN_LOGOUT,f_tcat.AUDT_TYPE_DATA_DISPLAY,f_tcat.AUDT_TYPE_DATA_CHANGES,f_tcat.AUDT_TYPE_DATA_IMPORT_EXPORT,f_tcat.AUDT_TYPE_DATA_TRANS,f_tcat.AUDT_TYPE_REMOTE_ACTIVITY,f_tcat.AUDT_TYPE_OTHER,f_tcat.AUDT_IDENTIFIER_USERID,f_tcat.AUDT_IDENTIFIER_DATE,f_tcat.AUTH_UNAUTHORIZED_ACCESS,f_tcat.AUTH_ROLEBASED_PRIVILEGES,f_tcat.AUTH_ADMIN_PRIVILEGE,f_tcat.CNFS_CONFIGURABLE,f_tcat.CSUP_OS_SECURITY_PATCHES,f_tcat.CSUP_REMOTE_PATCHES,f_tcat.DIDT_DEIDENTIFY_CAPABILITY,f_tcat.DTBK_BACKUP_CAPABILITY,f_tcat.EMRG_EMERGENCY_ACCESS,f_tcat.IGAU_DATA_INTEGRITY,f_tcat.MLDP_ANTI_MALWARE_SUPPORT,f_tcat.MLDP_USER_CONFIGURABLE,f_tcat.MLDP_NOTIFICATION,f_tcat.MDLP_MFR_REPAIR_ONLY,f_tcat.MDLP_OWNER_INSTALL_UPDATE,f_tcat.MDLP_OWNER_AV_DEF_UPATE,f_tcat.NAUT_NODE_AUTH_SUPPORT,f_tcat.PAUT_SINGLE_USER,f_tcat.PAUT_MULTI_USER,f_tcat.PAUT_EXT_AUTH_SERVICE,f_tcat.PAUT_UNSUCCESS_LOGON_LOCK,f_tcat.PAUT_CHANGE_DEFAULT_PWD,f_tcat.PAUT_SHARED_USERID,f_tcat.PAUT_PWD_COMPLEXITY_RULES,f_tcat.PAUT_PWD_EXPIRATION,f_tcat.PLOCK_PHYSICAL_LOCKS,f_tcat.RDMP_OS,f_tcat.RDMP_LIST_AVAILABLE,f_tcat.SAHD_HARDENING_MEASURES,f_tcat.SAHD_MFR_UPDATE_ONLY,f_tcat.SAHD_EXT_COMMUNICATION,f_tcat.SAHD_FILE_LEVEL_ACL,f_tcat.SAHD_ACOUNT_DISABLED,f_tcat.SAHD_SHARED_RESOURCES_DISABLED,f_tcat.SAHD_PORTS_DISABLED,f_tcat.SAHD_SERVICES_DISABLED,f_tcat.SAHD_APPLICATIONS_DISABLED,f_tcat.SAHD_BOOT_FR_REMOVABLE_MEDIA,f_tcat.SAHD_INST_NON_AUTH_SW_HW,f_tcat.SGUD_SECURITY_USER_DOC,f_tcat.SGUD_SANITIZATION_DOC,f_tcat.STCF_DATA_ENCRYPTED_AT_REST,f_tcat.TXCF_DEDICATED_CABLE_DATA,f_tcat.TXCF_ENCRYPT_DATA,f_tcat.TXCF_FIXED_LIST_DEST,f_tcat.TXIG_DATA_INTEGRITY,f_tcat.OTHR_REMOTE_SERVICE,f_tcat.OTHR_REMOTE_ACL,f_tcat.OTHR_REMOTE_ACCEPT_INITIATE,f_tcat.MDS2_DOCUMENT_DATE,f_tcat.MDS2_DOCUMENT_URL,f_tcat.NOTES_AVAILABLE,f_tcat.MDS2_DOCUMENT_ID,f_tcat.COMPANY_NAME,f_tcat.REPRESENTATIVE,f_tcat.MFR_CONTACT,f_tcat.INTENDED_USE,f_tcat.NEMA_VERSION,f_tcat.TO_BE_DELETED,f_tcat.TO_BE_DELETED_ON,f_tcat.DELETE_REASON,f_tcat.PRIVATE_FLAG,f_tcat.IS_PRIVATE,f_tcat.PRIVATE_TYPE,f_tcat.REPLACEMENT_ID from TCAT_MDS2 f_tcat where not exists (select 1 from TPC_MDS2 tpc_tab where tpc_tab.CAT_MDS2_ID=f_tcat.CAT_MDS2_ID ) union all SELECT * FROM ( SELECT COALESCE(tpc.CAT_MDS2_ID,tcat.CAT_MDS2_ID) CAT_MDS2_ID,COALESCE(tpc.CREATE_DATE,tcat.CREATE_DATE) CREATE_DATE,CASE WHEN ISNULL(tpc.LAST_MODIFIED_DATE,'31-DEC-1900') > tcat.LAST_MODIFIED_DATE THEN tpc.LAST_MODIFIED_DATE WHEN ISNULL(tpc.LAST_MODIFIED_DATE,'31-DEC-1900') < tcat.LAST_MODIFIED_DATE THEN tcat.LAST_MODIFIED_DATE ELSE tcat.LAST_MODIFIED_DATE END LAST_MODIFIED_DATE, COALESCE(tpc.EPHI_MANAGEMENT,tcat.EPHI_MANAGEMENT) EPHI_MANAGEMENT,COALESCE(tpc.EPHI_TYPE_DEMOGRAPHIC,tcat.EPHI_TYPE_DEMOGRAPHIC) EPHI_TYPE_DEMOGRAPHIC,COALESCE(tpc.EPHI_TYPE_MEDICAL_RECORD,tcat.EPHI_TYPE_MEDICAL_RECORD) EPHI_TYPE_MEDICAL_RECORD,COALESCE(tpc.EPHI_TYPE_DIAGNOSTIC,tcat.EPHI_TYPE_DIAGNOSTIC) EPHI_TYPE_DIAGNOSTIC,COALESCE(tpc.EPHI_TYPE_USER_ENTERED_TEXT,tcat.EPHI_TYPE_USER_ENTERED_TEXT) EPHI_TYPE_USER_ENTERED_TEXT,COALESCE(tpc.EPHI_TYPE_BIOMETRIC_DATA,tcat.EPHI_TYPE_BIOMETRIC_DATA) EPHI_TYPE_BIOMETRIC_DATA,COALESCE(tpc.EPHI_TYPE_PERSONAL_FINANCIAL,tcat.EPHI_TYPE_PERSONAL_FINANCIAL) EPHI_
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA