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

Analyzed at Thu Jul 20 12:13 PDT 2017

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
 
Confidential and Proprietary to BDNA