190 likes | 327 Views
Aspen Data Dictionary Management ADM02. Jeff Uva Sarah Wood. Agenda. Data Dictionary Basics User-defined fields Relationships Data utilization Reference tables Basics Creating codes Managing codes. Data Dictionary Basics. Table Details. Agenda. Data Dictionary Basics
E N D
Aspen Data Dictionary ManagementADM02 Jeff Uva Sarah Wood
Agenda • Data Dictionary • Basics • User-defined fields • Relationships • Data utilization • Reference tables • Basics • Creating codes • Managing codes
Data Dictionary Basics • Table Details
Agenda • Data Dictionary • Basics • User-defined fields • Relationships • Data utilization • Reference tables • Basics • Creating codes • Managing codes
User-Defined Fields • Field Types • System-defined fields • User-defined fields
User-Defined Fields • Field Types • Field details
Agenda • Data Dictionary • Basics • User-defined fields • Relationships • Data utilization • Reference tables • Basics • Creating codes • Managing codes
Relationships • Define relationships between tables • Visible right through the Data Dictionary • Helpful in many areas of Aspen RelStdPsnOid Student table Object Identifier Relationship Person table
Agenda • Data Dictionary • Basics • User-defined fields • Relationships • Data utilization • Reference tables • Basics • Creating codes • Managing codes
Data Utilization • What data is in your fields?
Agenda • Data Dictionary • Basics • User-defined fields • Relationships • Data utilization • Reference tables • Basics • Creating codes • Managing codes
Reference Table Basics • Creating reference tables • Creating reference codes • State/local/federal codes • Attaching reference tables to fields
Utilizing Codes • Are reference codes being used?
Agenda • Data Dictionary • Basics • User-defined fields • Relationships • Data utilization • Reference tables • Basics • Creating codes • Managing codes
Utilizing Tables • Are reference tables being used?
Managing Codes • Deleting codes • Make sure you know what you are doing! • Disabling codes
Thank you. juva@x2dev.com swood@x2dev.com