This diagram shows the main relationships between the person and facility tables, including their meta-data and audit log (ACD) tables. ER Diagram for Contacts and Facilities (PDF, 23 KB) - The person table contains the SEER*DMS Contact List.Record Audit Log ER Diagram (PDF, 17 KB) - A diagram of the tables that store the audit log of changes to record fields.
"Record" is a VIEW in the SEER*DMS database that can be used instead of querying or joining record_base and record_extended. Record data are stored in two tables (record_base and record_extended) to optimize performance in SEER*DMS processes. Record ER Diagram (PDF, 21 KB) - This diagram shows the two tables that store record data and their relationships with tables that store import data, AFL data, follow-back data, etc.These tables store tracking information for each change to a Patient Set field this includes data items in all Patient Set tables (patient, ctc, facility_admission, treatment_procedure, all tables with registry fields, etc). Patient Set Audit Log ER Diagram (PDF, 29 KB) - All changes to Patient Set data items are tracked in the "ACD" tables.Data items are not shown within each table because of the large number of tables and data items. It does not include recurring tables (e.g, patient_cause_of_death). Patient Set ER Diagram (PDF, 44 KB) - This diagram includes most of the database tables that store SEER*DMS Patient Set data.Additional database documentation will be made available upon request. The diagrams below describe core SEER*DMS tables and the relationships between those tables. Change Control Advisory Board for SEER*DMS.SEER Application Programming Interface (API).
0 kommentar(er)
