Definition of table school-year
School year file , Table Dump Name schlyear

Alphabetical Field Summary

  • comments: (CHAR) Comments for/about this school year
  • cre-date: (DATE) Date record was created
  • cre-time: (CHAR) Time record was created
  • cre-user-name: (CHAR) Name of user who created the record
  • current-year: (LOGC) Is this considered the current, active school year?
  • extern-guid: (CHAR) External Global Unique ID for this record
  • last-master-schd-change: (INTG) Last Master schd change sequence (for comparison)
  • school-year-id: (INTG) [DEFINE KEY]
  • school-year-name: (CHAR) Name for school year (i.e. 1993/94, etc)
  • sy-end: (DATE) Date school year end on
  • sy-start: (DATE) Date school year begins on
  • time-needs-rebuild: (LOGC) Set Yes if the time tables need to be rebuilt
  • upd-date: (DATE) Date record was last updated
  • upd-time: (CHAR) Record last updated at
  • upd-user-name: (CHAR) Name of user record was updated by

    Alphabetical Index Summary

  • current-year: current-year, school-year-id
  • extern-guid: extern-guid
  • school-year-by-date: sy-start, sy-end, school-year-id
  • school-year-id: (UNIQUE, PRIMARY) school-year-id
  • school-year-name: school-year-name

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-scy.p (SOURCE NOT AVAILABLE)
  • DELETE: Overridable, Procedure is tr-d-scy.p (SOURCE NOT AVAILABLE)
  • REPLICATION-CREATE: Procedure is rp-c-scy.p (SOURCE NOT AVAILABLE)
  • REPLICATION-DELETE: Procedure is rp-d-scy.p (SOURCE NOT AVAILABLE)
  • REPLICATION-WRITE: Procedure is rp-u-scy.p (SOURCE NOT AVAILABLE)
  • WRITE: Overridable, Procedure is tr-u-scy.p (SOURCE NOT AVAILABLE)

    Other tables who reference school-year

  • 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
  • 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
  • english-proficiency - English Proficiency Codes
  • 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
  • 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
  • instruction-setting - Instruction settings for students and courses
  • interleave-code - Scheduler Interleave codes
  • interleave-group - Interleave code groups
  • 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
  • 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
  • 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
  • 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
  • section-sequence - (no description available)
  • state-course-code - State Course Codes
  • status-code - Student Status Codes
  • status-group - Status groups are collections of status codes. Status groups
  • std-test-date - One record for each instance of a standardized test
  • 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-behave - Student behaviour records
  • stu-behave-event - Student Behaviour Events
  • stu-counseling - (no description available)
  • stu-course-atnd - Course Based student attendance
  • stu-credential-year - (no description available)
  • stu-daily-atnd - Daily student attendance entries
  • 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-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-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
  • title1-fund - Title 1 funds
  • title1-service - Title 1 Service
  • transcript-grade - List of grades/buildings that are considered for 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

    Detailed Alphabetical Field Listing
    comments Data type: CHARACTER
    Format: x(68)
    Help: Comments for/about this school year

    cre-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Description: Time record was created

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user who created the record

    current-year Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Is this considered the current, active school year?
    Attributes: Index Component

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    Attributes: Index Component

    last-master-schd-change Data type: INTEGER
    Format: zzzzzzzzzzzz
    Help: Last Master schd change sequence (for comparison)

    school-year-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: [DEFINE KEY]
    Help: Internally assigned school year
    Attributes: Index Component

    school-year-name Data type: CHARACTER
    Format: x(9)
    Help: Name for school year (i.e. 1993/94, etc)
    Attributes: Index Component

    sy-end Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Help: Date school year end on
    Attributes: Index Component

    sy-start Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Help: Date school year begins on
    Attributes: Index Component

    time-needs-rebuild Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Set Yes if the time tables need to be rebuilt

    upd-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Description: Record last updated at

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user record was updated by

    Created on 05/07/2012 by DBHTML V1.2