Schema for SPM Version V1.0
Alphabetical Table Summary
assign-category - (no description available)
atnd-calendar-day - Building Attendance calendar
atnd-calendar-group - Attendance calendar group
atnd-class - Attendance Code Classes
atnd-class-link - Links between the attendance codes and class files
atnd-code - Attendance Code definitions
atnd-eligibility - Attendance Eligibility Codes
atnd-letter - One entry per attendance letter
atnd-letter-mailing - One record per selected mailing class for this letter
atnd-letter-relation - Attendance letter relationships. There is an entry for any l
behave-action - Behaviour Actions
behave-class - Behaviour class codes allow various behave-codes to be colle
behave-class-link - This file is used to link each behave-class to it's associat
behave-code - Behviour Codes
behave-follow-up - (no description available)
behave-incident - Behavior Incidents, if the distict is tracking them
behave-location - (no description available)
behave-variance - Table to describe variances between official and actual days
behave-victim - (no description available)
building - One record for each building, for each scheduling version, f
carrier-route - Carrier Route definitions
contact-code - Contact Codes file
contact-device - (no description available)
counseling-code - (no description available)
course-alternate - Course Alternative entries
course-block - Course Blocking Defaults
course-catalog - Course Catalog
course-disposition - Holds disposition codes for transciptable marks
course-distrib - Course Costs Distributions
course-group - Course Groups
course-group-alternate - Alternate course for a course group
course-level - Course Level header file. This has little content and mostly
course-level-grade - Course Level grade file. One entry in here for each possible
course-stats - Course Request statistics
course-study-area - Course Study Area
course-to-daily - Transalations for student course based attendance to daily b
credential - Credential Table
credential-area - (no description available)
credential-area-course - (no description available)
credential-area-study -
credential-assessment - (no description available)
credential-outcome - (no description available)
credential-standard -
daily-atnd-post-log - Log file of postings on a date/room basis
department - Department Classifications
distance-learning - Distance learning codes
econ-disadvantaged - Economically disadvantaged codes
edp-path - (no description available)
email-info - (no description available)
english-proficiency - English Proficiency Codes
ethnic-code - Ethnic Codes files
form-bldg - Form definitions, on a per building level
form-def - Forms Definitions
grad-requirement-item - Graduation Requirement Item
grad-requirement-name - Graduation Requirements Names
grad-requirement-study - Graduation Requirement Study Area Controls
grad-study-requirement - Graduation Study Requirement
grade-catalog - Grades Catalog
grading-bldg-xlate - Support for translating between grading periods/marks of bui
grading-comment - Grading Comments. These are comments that teachers can assig
grading-mark - List of possible marks (not grades) for this building
grading-period - Grading period file holds a list of grading periods for a gi
grading-period-honor - Honor rolls enabled for a given grading period
grading-period-mark - List of marks enabled for this grading period
grading-setup - Grading setup controls building level setup/policy issues wi
history-code - Student History Activity Codes
home-language - Home Language Identifiers
honor-roll - Honor roll setup/defitions
honor-roll-comment - Comment codes required or forbidden from this honor roll
honor-roll-exclude - Honor rolls you can't already have if you want to get this o
honor-roll-grade - List of required or forbidden grades for this honor roll
honor-roll-group - List of course gourps that are required or forbidden from th
house - Houses for buildings
imported-item -
imported-record - (no description available)
instruction-setting - Instruction settings for students and courses
interleave-code - Scheduler Interleave codes
interleave-group - Interleave code groups
mail-class - List of possible mailing classes
master-schd - Master Schedule records One entry per course, per section fo
master-schd-assign - (no description available)
master-schd-conflict - One entry per master schd record that conflicts with a cours
master-schd-display - This is a transient table used for master schedule display s
master-schd-distrib - Master Schedule Distributions files
master-schd-mark - List of marks to record for each grading period with this se
master-schd-meets - Course meets entry. There may be many of these for each c
master-schd-note - (no description available)
master-schd-post-log - Log file of postings on a per-section basis
master-schd-stats - Master Schedule Statistics
medical-code - Medical Code definitions
note-code - Note Code record definitions
note-group - Note Grouping Code. Each note group appears as a seperate
period-catalog - Period Name catalog
personnel - Schools District personnel
personnel-bldg - Personnel/Building Linkage file
personnel-class - Personnel CLassifications (teacher, vice-principle, etc)
population-served - Population served by a course
progress-comment - Progress Report Comments
progress-period - Progress reporting periods
promotion-path-grade - Promotion Grade/Bldg list for promotion paths
promotion-path-name - List of possible promotion paths
replicate-queue - (no description available)
request-group - Request Groups. These are arbitrary groups students are assi
role-code - The role code associated with a course
room-catalog - Rooms catalog, within a building
scan-form-batch - Scan form batch. Each set of scan forms printed becomes a 'b
scan-form-dataset - Scan form datasets. Many forms are simple and only have one
scan-form-line - Scan Form Line info
scan-form-sheet - Scan Form Sheets
scanner-device - Scanner device file
scanner-model - Scanner model definitions file
schd-group - Scheduling Group
schd-period - These define the minimum period a course can be scheduled fo
schd-status - Student Schedule Status Code
schd-version - Master Schedule Versions
school-year - School year file
section-sequence - (no description available)
site-fld-define - Site Field definitions
site-fld-group - Site field to user group mapping file. This is the interface
site-frame - Site Defined frame definitions
site-table-code - Site Table Codes
site-table-name - Site Table Names
sped-code - Special Ed Codes
spm-prof - SPM Profile/Base record. Only 1 per system!
state-course-code - State Course Codes
status-code - Student Status Codes
status-group - Status groups are collections of status codes. Status groups
std-test - Define a standardized test
std-test-date - One record for each instance of a standardized test
std-test-item - (no description available)
std-test-record - (no description available)
stu-assign - (no description available)
stu-assign-totals - (no description available)
stu-atnd-letter - One entry per letter a student receives
stu-atnd-letter-event - Events that comprise a student attendance letter
stu-atnd-letter-item - This has one entry for each 'item' that appears on a letter.
stu-base - Student Base record
stu-behave - Student behaviour records
stu-behave-event - Student Behaviour Events
stu-contact - Student Contacts file
stu-contact-mailing - Student Contact Mailing definitions. For stu-contact records
stu-counseling - (no description available)
stu-course-atnd - Course Based student attendance
stu-credential - (no description available)
stu-credential-area - (no description available)
stu-credential-assessment - (no description available)
stu-credential-outcome - (no description available)
stu-credential-standard - (no description available)
stu-credential-year - (no description available)
stu-daily-atnd - Daily student attendance entries
stu-edp - (no description available)
stu-edp-course - (no description available)
stu-grade - Student Grades file.
stu-grade-comment - Student Grade comments
stu-grade-mark - One entry for each mark a student received for the associate
stu-history - Student Activity History
stu-honor-roll - List of honor rolls a student has achieved
stu-makeup-event - (no description available)
stu-makeup-summary - (no description available)
stu-medical - Student Medical information
stu-note - Student Notes file
stu-progress - Progress reports. One record per course per comment
stu-rank-gpa - Ranking and GPA data for a grading-period for a student
stu-rank-gpa-by-mark - Ranking and GPA by period mark
stu-request - Student Requests File
stu-request-master - Student Request Master Controls
stu-schedule - Student Schedule
stu-site - Site Specific Student data file
stu-state-item - Describes a students state record entry
stu-title1-service - Student Title 1 Service
stu-transcript-course - Student transcript courses. One per student/transcript/year/
stu-transcript-mark - Student transcript marks
stu-transcript-year - Student Transcript Year record. One per student, per transcr
stu-year - One record for each year a student exists in the district
study-area - Study Areas for courses
test-record-layout - (no description available)
title1-fund - Title 1 funds
title1-service - Title 1 Service
transcript-grade - List of grades/buildings that are considered for transcripts
transcript-name - Listing of transcripts
user-access - User Access/Permissions file
user-bldg - User Restricted to building list
user-department - User Department Level Restrictions
user-grade - User Grade level restriction
user-personnel - User Personnel level restrictions
vocational-classification - Vocational Classification codes
Alphabetical Sequence Summary
assignments: Min is 0, Init to 0, Increment by 1, Cycle at limit
atnd-change-log: Min is 1, Init to 1, Increment by 1, Cycle at limit
attendance: Min is 1, Init to 1, Increment by 1, Cycle at limit
cred-upd: Min is 0, Init to 0, Increment by 1, Cycle at limit
credential: Min is 0, Init to 0, Increment by 1, Cycle at limit
daily-post-log: Min is 0, Init to 0, Increment by 1, Cycle at limit
edp: Min is 0, Init to 0, Increment by 1, Cycle at limit
generic: Min is 1, Init to 1, Increment by 1, Stop at limit
grades: Min is 1, Init to 1, Increment by 1, Cycle at limit
history: Min is 1, Init to 1, Increment by 1, Cycle at limit
honor-roll: Min is 1, Init to 1, Increment by 1, Cycle at limit
incident: Min is 1, Init to 1, Increment by 1, Cycle at limit
letters: Min is 1, Init to 1, Increment by 1, Cycle at limit
master-schd-change: Min is 0, Init to 0, Increment by 1, Cycle at limit
outcome: Min is 0, Init to 0, Increment by 1, Cycle at limit
progress-report: Min is 1, Init to 1, Increment by 1, Cycle at limit
replicate-seq: Min is 0, Init to 0, Increment by 1, Cycle at limit
scanner: Min is 1, Init to 1, Increment by 1, Stop at limit
schd-change-log: Min is 1, Init to 1, Increment by 1, Cycle at limit
schedules: Min is 1, Init to 1, Increment by 1, Cycle at limit
state-change-log: Min is 1, Init to 1, Increment by 1, Cycle at limit
std-test: Min is 0, Init to 0, Increment by 1, Cycle at limit
stu-cred: Min is 0, Init to 0, Increment by 1, Cycle at limit
stu-misc: Min is 0, Init to 0, Increment by 1, Stop at limit
stu-state: Min is 1, Init to 1, Increment by 1, Cycle at limit
student-num: Min is 1, Max is 999999999, Init to 1, Increment by 1, Cycle at limit
students: Min is 1, Init to 1, Increment by 1, Stop at limit
test-data: Min is 0, Init to 0, Increment by 1, Cycle at limit
title1: Min is 0, Init to 0, Increment by 1, Cycle at limit
transcripts: Min is 1, Init to 1, Increment by 1, Cycle at limit
Created on 05/07/2012 by DBHTML V1.2