SQL Tables and their Relationships for Time Keeper Plus 11.0

 

You shouldn’t need these definitions because the data is maintained by Academic Programmers.  If you want to create your own reports, contact Academic Programmers and we will email you these files.  These files are not password protected.

 

           

Organization Chart

 

The Session Data table contains many fields. The primary key column called Number is an autoincrement field starting at one.  This key is used to identify the session number. There are no restrictions as to how many records will be in this table.

 

The resources, ethnicities, groups, and labs tables contain the descriptions for each of the resources, ethnicities, groups, and labs available in the system.

 

Each of these tables has a primary key column called Number which is an autoincrement field starting at one.  The secondary key, called SessionNumber, identifies the session that it belongs to.  There are no restrictions as to how many records will be in each table.

 

 

Organization Chart

 

The Courses table contains the list of courses in the system.  The primary key column is called Number is an autoincrement field.  The secondary key, called SessionNumber, identifies the session that it belongs to.  There is no restriction on how many courses can be added to the system.

 

Each of the subordinate files listed uses the Number column of the courses table to relate the resources, grades, grade descriptions, grade values, grade groups, attendance dates, course notes, and valid course hours.

 

Each of these tables contains a column called CourseNumber to indicate this relationship and a column called SessionNumber to identify the session it belongs to.

 

 

Organization Chart

 

The Students table contains all of the students in the system.  Each student record contains a primary key column called AccessCode.  This column can be an autoincrement field or an assigned field.  Each record also contains a CourseNumber column to indicate which course the student belongs to and SessionNumber to indicate which session it belongs to.

 

The Student scores and student notes tables have a column called AccessCode that relates each record to the particular student.

 

 

Organization Chart

 

The stations table is a stand-alone table that contains the accumulated totals for all stations on the network.  It contains an autoincrement field and a SessionNumber column.

 

 

Organization Chart

 

The exacts table contains the exact clockins for all students.  The table has a column called AccessCode which relates each student to this file and SessionNumber to indicate which session it belongs to.

 

 

Organization Chart

 

The modified logs table contains the times modified by the system administrator for a student.  The table has a column called AccessCode which relates each student to this file and SessionNumber to indicate which session it belongs to.

 

 

Organization Chart

 

The clocked in_ file contains the students currently clocked in.  The table has a column called AccessCode which relates each student to this file and SessionNumber to indicate which session it belongs to.

 

 

Click Here to view full table definitions