BDNA Data Platform 5.4 July 2017 (Oracle) CAT_MDS2 - Manufacturer Disclosure Statement for Medical Device Security (MDS2) Info
|
View Definition:
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 "CAT_MDS2_ID","CREATE_DATE","LAST_MODIFIED_DATE","EPHI_MANAGEMENT","EPHI_TYPE_DEMOGRAPHIC","EPHI_TYPE_MEDICAL_RECORD","EPHI_TYPE_DIAGNOSTIC","EPHI_TYPE_USER_ENTERED_TEXT","EPHI_TYPE_BIOMETRIC_DATA","EPHI_TYPE_PERSONAL_FINANCIAL","EPHI_MAINT_TEMP_MEMORY","EPHI_MAINT_PERSIS_LOCALMEDIA","EPHI_MAINT_IMPORT_EXPORT","EPHI_MAINT_POWER_INTERRUPTION","EPHI_TRANS_DISPLAY","EPHI_TRANS_HARDCOPY","EPHI_TRANS_REMOVABLE_MEDIA","EPHI_TRANS_CABLE","EPHI_TRANS_WIRED_NETWORK","EPHI_TRANS_WIRELESS_NETWORK","EPHI_TRANS_SCANNING","EPHI_TRANS_OTHER","ALOF_INACTIVITY_LOCK","ALOF_INACTIVITY_LENGTH","ALOF_MANUAL_LOCK","AUDT_AUDIT_TRAIL","AUDT_TYPE_LOGIN_LOGOUT","AUDT_TYPE_DATA_DISPLAY","AUDT_TYPE_DATA_CHANGES","AUDT_TYPE_DATA_IMPORT_EXPORT","AUDT_TYPE_DATA_TRANS","AUDT_TYPE_REMOTE_ACTIVITY","AUDT_TYPE_OTHER","AUDT_IDENTIFIER_USERID","AUDT_IDENTIFIER_DATE","AUTH_UNAUTHORIZED_ACCESS","AUTH_ROLEBASED_PRIVILEGES","AUTH_ADMIN_PRIVILEGE","CNFS_CONFIGURABLE","CSUP_OS_SECURITY_PATCHES","CSUP_REMOTE_PATCHES","DIDT_DEIDENTIFY_CAPABILITY","DTBK_BACKUP_CAPABILITY","EMRG_EMERGENCY_ACCESS","IGAU_DATA_INTEGRITY","MLDP_ANTI_MALWARE_SUPPORT","MLDP_USER_CONFIGURABLE","MLDP_NOTIFICATION","MDLP_MFR_REPAIR_ONLY","MDLP_OWNER_INSTALL_UPDATE","MDLP_OWNER_AV_DEF_UPATE","NAUT_NODE_AUTH_SUPPORT","PAUT_SINGLE_USER","PAUT_MULTI_USER","PAUT_EXT_AUTH_SERVICE","PAUT_UNSUCCESS_LOGON_LOCK","PAUT_CHANGE_DEFAULT_PWD","PAUT_SHARED_USERID","PAUT_PWD_COMPLEXITY_RULES","PAUT_PWD_EXPIRATION","PLOCK_PHYSICAL_LOCKS","RDMP_OS","RDMP_LIST_AVAILABLE","SAHD_HARDENING_MEASURES","SAHD_MFR_UPDATE_ONLY","SAHD_EXT_COMMUNICATION","SAHD_FILE_LEVEL_ACL","SAHD_ACOUNT_DISABLED","SAHD_SHARED_RESOURCES_DISABLED","SAHD_PORTS_DISABLED","SAHD_SERVICES_DISABLED","SAHD_APPLICATIONS_DISABLED","SAHD_BOOT_FR_REMOVABLE_MEDIA","SAHD_INST_NON_AUTH_SW_HW","SGUD_SECURITY_USER_DOC","SGUD_SANITIZATION_DOC","STCF_DATA_ENCRYPTED_AT_REST","TXCF_DEDICATED_CABLE_DATA","TXCF_ENCRYPT_DATA","TXCF_FIXED_LIST_DEST","TXIG_DATA_INTEGRITY","OTHR_REMOTE_SERVICE","OTHR_REMOTE_ACL","OTHR_REMOTE_ACCEPT_INITIATE","MDS2_DOCUMENT_DATE","MDS2_DOCUMENT_URL","NOTES_AVAILABLE","MDS2_DOCUMENT_ID","COMPANY_NAME","REPRESENTATIVE","MFR_CONTACT","INTENDED_USE","NEMA_VERSION","TO_BE_DELETED","TO_BE_DELETED_ON","DELETE_REASON","PRIVATE_FLAG","IS_PRIVATE","PRIVATE_TYPE","REPLACEMENT_ID" FROM ( SELECT COALESCE(tpc.CAT_MDS2_ID,tcat.CAT_MDS2_ID) CAT_MDS2_ID,COALESCE(tpc.CREATE_DATE,tcat.CREATE_DATE) CREATE_DATE,GREATEST(NVL(tpc.LAST_MODIFIED_DATE,TO_DATE('31-DEC-1900','DD-MON-YYYY')),tcat.LAST_MODIFIED_DATE) 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_TYPE_PERSONAL_FINANCIAL,COALESCE(tpc.EPHI_MAINT_TEMP_MEMORY,tcat.EPHI_MAINT_TEMP_MEMORY) EPHI_MAINT_TEMP_MEMORY,COALESCE(tpc.EPHI_MAINT_PERSIS_LOCALMEDIA,tcat.EPHI_MAINT_PERSIS_LOCALMEDIA) EPHI_MAINT_PERSIS_LOCALMEDIA,COALESCE(tpc.EPHI_MAINT_IMPORT_EXPORT,tcat.EPHI_MAINT_IMPORT_EXPORT) EPHI_MAINT_IMPORT_EXPORT,COALESCE(tpc.EPHI_MAINT_POWER_INTERRUPTION,tcat.EPHI_MAINT_POWER_INTERRUPTION) EPHI_MAINT_POWER_INTERRUPTION,COALESCE(tpc.EPHI_TRANS_DISPLAY,tcat.EPHI_TRANS_DISPLAY) EPHI_TRANS_DISPLAY,COALESCE(tpc.EPHI_TRANS_HARDCOPY,tcat.EPHI_TRANS_HARDCOPY) EPHI_TRANS_HARDCOPY,COALESCE(tpc.EPHI_TRANS_REMOVABLE_MEDIA,tcat.EPHI_TRANS_REMOVABLE_MEDIA) EPHI_TRANS_REMOVABLE_MEDIA,COALESCE(tpc.EPHI_TRANS_CABLE,tcat.EPHI_TRANS_CABLE) EPHI_TRANS_CABLE,COALESCE(tpc.EPHI_TRANS_WIRED_NETWORK,tcat.EPHI_TRANS_WIRED_NETWORK) EPHI_TRANS_WIRED_NETWORK,COALESCE(tpc.EPHI_TRANS_WIRELESS_NETWORK,tcat.EPHI_TRANS_WIRELESS_NETWORK) EPHI_TRANS_WIRELESS_NETWORK,COALESCE(tpc.EPHI_TRANS_SCANNING,tcat.EPHI_TRANS_SCANNING) EPHI_TRANS_SCANNING,COALESCE(tpc.EPHI_TRANS_OTHER,tcat.EPHI_TRANS_OTHER) EPHI_TRANS_OTHER,COALESCE(tpc.ALOF_INACTIVITY_LOCK,tcat.ALOF_INACTIVITY_LOCK) ALOF_INACTIVITY_LOCK,COALESCE(tpc.ALOF_INACTIVITY_LENGTH,tcat.ALOF_INACTIVITY_LENGTH) ALOF_INACTIVITY_LENGTH,COALESCE(tpc.ALOF_MANUAL_LOCK,tcat.ALOF_MANUAL_LOCK) ALOF_MANUAL_LOCK,COALESCE(tpc.AUDT_AUDIT_TRAIL,tcat.AUDT_AUDIT_TRAIL) AUDT_AUDIT_TRAIL,COALESCE(tpc.AUDT_TYPE_LOGIN_LOGOUT,tcat.AUDT_TYPE_LOGIN_LOGOUT) AUDT_TYPE_LOGIN_LOGOUT,COALESCE(tpc.AUDT_TYPE_DATA_DISPLAY,tcat.AUDT_TYPE_DATA_DISPLAY) AUDT_TYPE_DATA_DISPLAY,COALESCE(tpc.AUDT_TYPE_DATA_CHANGES,tcat.AUDT_TYPE_DATA_CHANGES) AUDT_TYPE_DATA_CHANGES,COALESCE(tpc.AUDT_TYPE_DATA_IMPORT_EXPORT,tcat.AUDT_TYPE_DATA_IMPORT_EXPORT) AUDT_TYPE_DATA_IMPORT_EXPORT,COALESCE(tpc.AUDT_TYPE_DATA_TRANS,tcat.AUDT_TYPE_DATA_TRANS) AUDT_TYPE_DATA_TRANS,COALESCE(tpc.AUDT_TYPE_REMOTE_ACTIVITY,tcat.AUDT_TYPE_REMOTE_ACTIVITY) AUDT_TYPE_REMOTE_ACTIVITY,COALESCE(tpc.AUDT_TYPE_OTHER,tcat.AUDT_TYPE_OTHER) AUDT_TYPE_OTHER,COALESCE(tpc.AUDT_IDENTIFIER_USERID,tcat.AUDT_IDENTIFIER_USERID) AUDT_IDENTIFIER_USERID,COALESCE(tpc.AUDT_IDENTIFIER_DATE,tcat.AUDT_IDENTIFIER_DATE) AUDT_IDENTIFIER_DATE,COALESCE(tpc.AUTH_UNAUTHORIZED_ACCESS,tcat.AUTH_UNAUTHORIZED_ACCESS) AUTH_UNAUTHORIZED_ACCESS,COALESCE(tpc.AUTH_ROLEBASED_PRIVILEGES,tcat.AUTH_ROLEBASED_PRIVILEGES) AUTH_ROLEBASED_PRIVILEGES,COALESCE(tpc.AUTH_ADMIN_PRIVILEGE,tcat.AUTH_ADMIN_PRIVILEGE) AUTH_ADMIN_PRIVILEGE,COALESCE(tpc.CNFS_CONFIGURABLE,tcat.CNFS_CONFIGURABLE) CNFS_CONFIGURABLE,COALESCE(tpc.CSUP_OS_SECURITY_PATCHES,tcat.CSUP_OS_SECURITY_PATCHES) CSUP_OS_SECURITY_PATCHES,COALESCE(tpc.CSUP_REMOTE_PATCHES,tcat.CSUP_REMOTE_PATCHES) CSUP_REMOTE_PATCHES,COALESCE(tpc.DIDT_DEIDENTIFY_CAPABILITY,tcat.DIDT_DEIDENTIFY_CAPABILITY) DIDT_DEIDENTIFY_CAPABILITY,COALESCE(tpc.DTBK_BACKUP_CAPABILITY,tcat.DTBK_BACKUP_CAPABILITY) DTBK_BACKUP_CAPABILITY,COALESCE(tpc.EMRG_EMERGENCY_ACCESS,tcat.EMRG_EMERGENCY_ACCESS) EMRG_EMERGENCY_ACCESS,COALESCE(tpc.IGAU_DATA_INTEGRITY,tcat.IGAU_DATA_INTEGRITY) IGAU_DATA_INTEGRITY,COALESCE(tpc.MLDP_ANTI_MALWARE_SUPPORT,tcat.MLDP_ANTI_MALWARE_SUPPORT) MLDP_ANTI_MALWARE_SUPPORT,COALESCE(tpc.MLDP_USER_CONFIGURABLE,tcat.MLDP_USER_CONFIGURABLE) MLDP_USER_CONFIGURABLE,COALESCE(tpc.MLDP_NOTIFICATION,tcat.MLDP_NOTIFICATION) MLDP_NOTIFICATION,COALESCE(tpc.MDLP_MFR_REPAIR_ONLY,tcat.MDLP_MFR_REPAIR_ONLY) MDLP_MFR_REPAIR_ONLY,COALESCE(tpc.MDLP_OWNER_INSTALL_UPDATE,tcat.MDLP_OWNER_INSTALL_UPDATE) MDLP_OWNER_INSTALL_UPDATE,COALESCE(tpc.MDLP_OWNER_AV_DEF_UPATE,tcat.MDLP_OWNER_AV_DEF_UPATE) MDLP_OWNER_AV_DEF_UPATE,COALESCE(tpc.NAUT_NODE_AUTH_SUPPORT,tcat.NAUT_NODE_AUTH_SUPPORT) NAUT_NODE_AUTH_SUPPORT,COALESCE(tpc.PAUT_SINGLE_USER,tcat.PAUT_SINGLE_USER) PAUT_SINGLE_USER,COALESCE(tpc.PAUT_MULTI_USER,tcat.PAUT_MULTI_USER) PAUT_MULTI_USER,COALESCE(tpc.PAUT_EXT_AUTH_SERVICE,tcat.PAUT_EXT_AUTH_SERVICE) PAUT_EXT_AUTH_SERVICE,COALESCE(tpc.PAUT_UNSUCCESS_LOGON_LOCK,tcat.PAUT_UNSUCCESS_LOGON_LOCK) PAUT_UNSUCCESS_LOGON_LOCK,COALESCE(tpc.PAUT_CHANGE_DEFAULT_PWD,tcat.PAUT_CHANGE_DEFAULT_PWD) PAUT_CHANGE_DEFAULT_PWD,COALESCE(tpc.PAUT_SHARED_USERID,tcat.PAUT_SHARED_USERID) PAUT_SHARED_USERID,COALESCE(tpc.PAUT_PWD_COMPLEXITY_RULES,tcat.PAUT_PWD_COMPLEXITY_RULES) PAUT_PWD_COMPLEXITY_RULES,COALESCE(tpc.PAUT_PWD_EXPIRATION,tcat.PAUT_PWD_EXPIRATION) PAUT_PWD_EXPIRATION,COALESCE(tpc.PLOCK_PHYSICAL_LOCKS,tcat.PLOCK_PHYSICAL_LOCKS) PLOCK_PHYSICAL_LOCKS,COALESCE(tpc.RDMP_OS,tcat.RDMP_OS) RDMP_OS,COALESCE(tpc.RDMP_LIST_AVAILABLE,tcat.RDMP_LIST_AVAILABLE) RDMP_LIST_AVAILABLE,COALESCE(tpc.SAHD_HARDENING_MEASURES,tcat.SAHD_HARDENING_MEASURES) SAHD_HARDENING_MEASURES,COALESCE(tpc.SAHD_MFR_UPDATE_ONLY,tcat.SAHD_MFR_UPDATE_ONLY) SAHD_MFR_UPDATE_ONLY,COALESCE(tpc.SAHD_EXT_COMMUNICATION,tcat.SAHD_EXT_COMMUNICATION) SAHD_EXT_COMMUNICATION,COALESCE(tpc.SAHD_FILE_LEVEL_ACL,tcat.SAHD_FILE_LEVEL_ACL) SAHD_FILE_LEVEL_ACL,COALESCE(tpc.SAHD_ACOUNT_DISABLED,tcat.SAHD_ACOUNT_DISABLED) SAHD_ACOUNT_DISABLED,COALESCE(tpc.SAHD_SHARED_RESOURCES_DISABLED,tcat.SAHD_SHARED_RESOURCES_DISABLED) SAHD_SHARED_RESOURCES_DISABLED,COALESCE(tpc.SAHD_PORTS_DISABLED,tcat.SAHD_PORTS_DISABLED) SAHD_PORTS_DISABLED,COALESCE(tpc.SAHD_SERVICES_DISABLED,tcat.SAHD_SERVICES_DISABLED) SAHD_SERVICES_DISABLED,COALESCE(tpc.SAHD_APPLICATIONS_DISABLED,tcat.SAHD_APPLICATIONS_DISABLED) SAHD_APPLICATIONS_DISABLED,COALESCE(tpc.SAHD_BOOT_FR_REMOVABLE_MEDIA,tcat.SAHD_BOOT_FR_REMOVABLE_MEDIA) SAHD_BOOT_FR_REMOVABLE_MEDIA,COALESCE(tpc.SAHD_INST_NON_AUTH_SW_HW,tcat.SAHD_INST_NON_AUTH_SW_HW) SAHD_INST_NON_AUTH_SW_HW,COALESCE(tpc.SGUD_SECURITY_USER_DOC,tcat.SGUD_SECURITY_USER_DOC) SGUD_SECURITY_USER_DOC,COALESCE(tpc.SGUD_SANITIZATION_DOC,tcat.SGUD_SANITIZATION_DOC) SGUD_SANITIZATION_DOC,COALESCE(tpc.STCF_DATA_ENCRYPTED_AT_REST,tcat.STCF_DATA_ENCRYPTED_AT_REST) STCF_DATA_ENCRYPTED_AT_REST,COALESCE(tpc.TXCF_DEDICATED_CABLE_DATA,tcat.TXCF_DEDICATED_CABLE_DATA) TXCF_DEDICATED_CABLE_DATA,COALESCE(tpc.TXCF_ENCRYPT_DATA,tcat.TXCF_ENCRYPT_DATA) TXCF_ENCRYPT_DATA,COALESCE(tpc.TXCF_FIXED_LIST_DEST,tcat.TXCF_FIXED_LIST_DEST) TXCF_FIXED_LIST_DEST,COALESCE(tpc.TXIG_DATA_INTEGRITY,tcat.TXIG_DATA_INTEGRITY) TXIG_DATA_INTEGRITY,COALESCE(tpc.OTHR_REMOTE_SERVICE,tcat.OTHR_REMOTE_SERVICE) OTHR_REMOTE_SERVICE,COALESCE(tpc.OTHR_REMOTE_ACL,tcat.OTHR_REMOTE_ACL) OTHR_REMOTE_ACL,COALESCE(tpc.OTHR_REMOTE_ACCEPT_INITIATE,tcat.OTHR_REMOTE_ACCEPT_INITIATE) OTHR_REMOTE_ACCEPT_INITIATE,COALESCE(tpc.MDS2_DOCUMENT_DATE,tcat.MDS2_DOCUMENT_DATE) MDS2_DOCUMENT_DATE,COALESCE(tpc.MDS2_DOCUMENT_URL,tcat.MDS2_DOCUMENT_URL) MDS2_DOCUMENT_URL,COALESCE(tpc.NOTES_AVAILABLE,tcat.NOTES_AVAILABLE) NOTES_AVAILABLE,COALESCE(tpc.MDS2_DOCUMENT_ID,tcat.MDS2_DOCUMENT_ID) MDS2_DOCUMENT_ID,COALESCE(tpc.COMPANY_NAME,tcat.COMPANY_NAME) COMPANY_NAME,COALESCE(tpc.REPRESENTATIVE,tcat.REPRESENTATIVE) REPRESENTATIVE,COALESCE(tpc.MFR_CONTACT,tcat.MFR_CONTACT) MFR_CONTACT,COALESCE(tpc.INTENDED_USE,tcat.INTENDED_USE) INTENDED_USE,COALESCE(tpc.NEMA_VERSION,tcat.NEMA_VERSION) NEMA_VERSION,COALESCE(tpc.TO_BE_DELETED,tcat.TO_BE_DELETED) TO_BE_DELETED,COALESCE(tpc.TO_BE_DELETED_ON,tcat.TO_BE_DELETED_ON) TO_BE_DELETED_ON,COALESCE(tpc.DELETE_REASON,tcat.DELETE_REASON) DELETE_REASON,COALESCE(uuid.PRIVATE_FLAG,tcat.PRIVATE_FLAG) PRIVATE_FLAG, COALESCE(uuid.IS_PRIVATE,tcat.IS_PRIVATE) IS_PRIVATE, COALESCE(uuid.PRIVATE_TYPE,tcat.PRIVATE_TYPE) PRIVATE_TYPE, COALESCE(tpc.REPLACEMENT_ID,tcat.REPLACEMENT_ID) REPLACEMENT_ID FROM TPC_MDS2 tpc LEFT JOIN TCAT_MDS2 tcat ON tcat.CAT_MDS2_ID = tpc.CAT_MDS2_ID inner JOIN TPC_UUID uuid ON tpc.CAT_MDS2_ID = uuid.CAT_UUID_ID AND SIGN(tpc.CAT_MDS2_ID )!= -1 ) cat_tab UNION ALL SELECT tpc.CAT_MDS2_ID,tpc.CREATE_DATE,tpc.LAST_MODIFIED_DATE,tpc.EPHI_MANAGEMENT,tpc.EPHI_TYPE_DEMOGRAPHIC,tpc.EPHI_TYPE_MEDICAL_RECORD,tpc.EPHI_TYPE_DIAGNOSTIC,tpc.EPHI_TYPE_USER_ENTERED_TEXT,tpc.EPHI_TYPE_BIOMETRIC_DATA,tpc.EPHI_TYPE_PERSONAL_FINANCIAL,tpc.EPHI_MAINT_TEMP_MEMORY,tpc.EPHI_MAINT_PERSIS_LOCALMEDIA,tpc.EPHI_MAINT_IMPORT_EXPORT,tpc.EPHI_MAINT_POWER_INTERRUPTION,tpc.EPHI_TRANS_DISPLAY,tpc.EPHI_TRANS_HARDCOPY,tpc.EPHI_TRANS_REMOVABLE_MEDIA,tpc.EPHI_TRANS_CABLE,tpc.EPHI_TRANS_WIRED_NETWORK,tpc.EPHI_TRANS_WIRELESS_NETWORK,tpc.EPHI_TRANS_SCANNING,tpc.EPHI_TRANS_OTHER,tpc.ALOF_INACTIVITY_LOCK,tpc.ALOF_INACTIVITY_LENGTH,tpc.ALOF_MANUAL_LOCK,tpc.AUDT_AUDIT_TRAIL,tpc.AUDT_TYPE_LOGIN_LOGOUT,tpc.AUDT_TYPE_DATA_DISPLAY,tpc.AUDT_TYPE_DATA_CHANGES,tpc.AUDT_TYPE_DATA_IMPORT_EXPORT,tpc.AUDT_TYPE_DATA_TRANS,tpc.AUDT_TYPE_REMOTE_ACTIVITY,tpc.AUDT_TYPE_OTHER,tpc.AUDT_IDENTIFIER_USERID,tpc.AUDT_IDENTIFIER_DATE,tpc.AUTH_UNAUTHORIZED_ACCESS,tpc.AUTH_ROLEBASED_PRIVILEGES,tpc.AUTH_ADMIN_PRIVILEGE,tpc.CNFS_CONFIGURABLE,tpc.CSUP_OS_SECURITY_PATCHES,tpc.CSUP_REMOTE_PATCHES,tpc.DIDT_DEIDENTIFY_CAPABILITY,tpc.DTBK_BACKUP_CAPABILITY,tpc.EMRG_EMERGENCY_ACCESS,tpc.IGAU_DATA_INTEGRITY,tpc.MLDP_ANTI_MALWARE_SUPPORT,tpc.MLDP_USER_CONFIGURABLE,tpc.MLDP_NOTIFICATION,tpc.MDLP_MFR_REPAIR_ONLY,tpc.MDLP_OWNER_INSTALL_UPDATE,tpc.MDLP_OWNER_AV_DEF_UPATE,tpc.NAUT_NODE_AUTH_SUPPORT,tpc.PAUT_SINGLE_USER,tpc.PAUT_MULTI_USER,tpc.PAUT_EXT_AUTH_SERVICE,tpc.PAUT_UNSUCCESS_LOGON_LOCK,tpc.PAUT_CHANGE_DEFAULT_PWD,tpc.PAUT_SHARED_USERID,tpc.PAUT_PWD_COMPLEXITY_RULES,tpc.PAUT_PWD_EXPIRATION,tpc.PLOCK_PHYSICAL_LOCKS,tpc.RDMP_OS,tpc.RDMP_LIST_AVAILABLE,tpc.SAHD_HARDENING_MEASURES,tpc.SAHD_MFR_UPDATE_ONLY,tpc.SAHD_EXT_COMMUNICATION,tpc.SAHD_FILE_LEVEL_ACL,tpc.SAHD_ACOUNT_DISABLED,tpc.SAHD_SHARED_RESOURCES_DISABLED,tpc.SAHD_PORTS_DISABLED,tpc.SAHD_SERVICES_DISABLED,tpc.SAHD_APPLICATIONS_DISABLED,tpc.SAHD_BOOT_FR_REMOVABLE_MEDIA,tpc.SAHD_INST_NON_AUTH_SW_HW,tpc.SGUD_SECURITY_USER_DOC,tpc.SGUD_SANITIZATION_DOC,tpc.STCF_DATA_ENCRYPTED_AT_REST,tpc.TXCF_DEDICATED_CABLE_DATA,tpc.TXCF_ENCRYPT_DATA,tpc.TXCF_FIXED_LIST_DEST,tpc.TXIG_DATA_INTEGRITY,tpc.OTHR_REMOTE_SERVICE,tpc.OTHR_REMOTE_ACL,tpc.OTHR_REMOTE_ACCEPT_INITIATE,tpc.MDS2_DOCUMENT_DATE,tpc.MDS2_DOCUMENT_URL,tpc.NOTES_AVAILABLE,tpc.MDS2_DOCUMENT_ID,tpc.COMPANY_NAME,tpc.REPRESENTATIVE,tpc.MFR_CONTACT,tpc.INTENDED_USE,tpc.NEMA_VERSION,tpc.TO_BE_DELETED,tpc.TO_BE_DELETED_ON,tpc.DELETE_REASON,tpc.PRIVATE_FLAG,tpc.IS_PRIVATE,tpc.PRIVATE_TYPE,tpc.REPLACEMENT_ID FROM TPC_MDS2 tpc WHERE SIGN(tpc.CAT_MDS2_ID )= -1