Definition of table grading-setup

Grading setup controls building level setup/policy issues with grading , Table Dump Name grad-set

Alphabetical Field Summary

bldg-id: (INTG) Building ID associated with this record

comments: (CHAR) Comments for/about this buildings grading policy/setup

course-absence-atnd-class-id: (INTG) Atnd Class ID to use for course absences

course-tardy-atnd-class-id: (INTG) Atnd Class ID to use for course tardies

cre-date: (DATE) Date record was created

cre-time: (CHAR) Time record was created at

cre-user-name: (CHAR) User name of user who creatd this record

daily-absence-atnd-class-id: (INTG) Atnd Class ID to use for daily absences

daily-tardy-atnd-class-id: (INTG) Atnd Class ID to use for daily tardies

extern-guid: (CHAR) External Global Unique ID for this record

grade-comment-cnt: (INTG) Number of comments to allow in grade reporting (0-99)

period-absence-atnd-class-id: (INTG) Atnd Class ID to use for period absences

period-tardy-atnd-class-id: (INTG) Atnd Class ID to use for period tardies

primary-key: (INTG) Unique, Primary key for record

report-course-absence: (LOGC) Yes to include course absence data on report cards

report-course-tardy: (LOGC) Yes to include course tardy data on report cards

report-daily-absence: (LOGC) Yes to include daily absence data on report cards

report-daily-tardy: (LOGC) Yes to include daily tardy data on report cards

report-period-absence: (LOGC) Yes to include period absence data on report cards

report-period-tardy: (LOGC) Yes to include period tardy data on report cards

school-year-id: (INTG) School year ID associated with this record

upd-date: (DATE) Date this records was last updated on

upd-time: (CHAR) Time the record was last updated at

upd-user-name: (CHAR) Name of user who last updated this record

Alphabetical Index Summary

extern-guid: extern-guid

grading-setup: (UNIQUE, PRIMARY) school-year-id, bldg-id

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-gsm.p (SOURCE NOT AVAILABLE)

DELETE: Overridable, Procedure is tr-d-gsm.p (SOURCE NOT AVAILABLE)

REPLICATION-CREATE: Procedure is rp-c-gsm.p (SOURCE NOT AVAILABLE)

REPLICATION-DELETE: Procedure is rp-d-gsm.p (SOURCE NOT AVAILABLE)

REPLICATION-WRITE: Procedure is rp-u-gsm.p (SOURCE NOT AVAILABLE)

WRITE: Overridable, Procedure is tr-u-gsm.p (SOURCE NOT AVAILABLE)

Other tables who reference grading-setup

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-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-incident - Behavior Incidents, if the distict is tracking them

behave-variance - Table to describe variances between official and actual days

building - One record for each building, for each scheduling version, f

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-area-course - (no description available)

daily-atnd-post-log - Log file of postings on a date/room basis

department - Department Classifications

form-bldg - Form definitions, on a per building level

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

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

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-bldg - Personnel/Building Linkage file

progress-comment - Progress Report Comments

progress-period - Progress reporting periods

promotion-path-grade - Promotion Grade/Bldg list for promotion paths

request-group - Request Groups. These are arbitrary groups students are assi

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-version - Master Schedule Versions

section-sequence - (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-behave - Student behaviour records

stu-behave-event - Student Behaviour Events

stu-course-atnd - Course Based student attendance

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-schedule - Student Schedule

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

transcript-grade - List of grades/buildings that are considered for transcripts

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

Tables grading-setup references

building - One record for each building, for each scheduling version, f

email-info - (no description available)

school-year - School year file

spm-prof - SPM Profile/Base record. Only 1 per system!

user-bldg - User Restricted to building list

Detailed Alphabetical Field Listing
bldg-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Building ID associated with this record
Attributes: Index Component

comments Data type: CHARACTER
Format: x(68)
Help: Comments for/about this buildings grading policy/setup

course-absence-atnd-class-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Atnd Class ID to use for course absences

course-tardy-atnd-class-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Atnd Class ID to use for course tardies

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

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

cre-user-name Data type: CHARACTER
Format: x(16)
Help: User name of user who creatd this record

daily-absence-atnd-class-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Atnd Class ID to use for daily absences

daily-tardy-atnd-class-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Atnd Class ID to use for daily tardies

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

grade-comment-cnt Data type: INTEGER
Format: z9 (Initial Value: 5)
Help: Number of comments to allow in grade reporting (0-99)

period-absence-atnd-class-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Atnd Class ID to use for period absences

period-tardy-atnd-class-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Atnd Class ID to use for period tardies

primary-key Data type: INTEGER
Format: zzzzzzzzzzzz
Help: Unique, Primary key for record

report-course-absence Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to include course absence data on report cards

report-course-tardy Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to include course tardy data on report cards

report-daily-absence Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to include daily absence data on report cards

report-daily-tardy Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to include daily tardy data on report cards

report-period-absence Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to include period absence data on report cards

report-period-tardy Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to include period tardy data on report cards

school-year-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: School year ID associated with this record
Attributes: Index Component

upd-date Data type: DATE
Format: 99/99/9999
Help: Date this records was last updated on

upd-time Data type: CHARACTER
Format: x(8)
Help: Time the record was last updated at

upd-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who last updated this record

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