BDNA Data Platform 5.4 July 2017 (SQL Server) CAT_MDS2 - Manufacturer Disclosure Statement for Medical Device Security (MDS2) Info
|
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: