Definition of table master-schd

Master Schedule records One entry per course, per section for the course. , Table Dump Name mastschd

Alphabetical Field Summary

allow-conflicts: (LOGC) Yes to allow this course to conflict with another course

balance-by-age: (LOGC) Yes to attempt to balance course requests by students age

balance-by-age-high: (INTG) Highest age of students preferred in this course

balance-by-age-low: (INTG) Lowest age of students preferred in this course

balance-by-gender: (LOGC) Yes to attempt to balance course requests by gender

balance-by-gender-male-pct: (DECM) Preferred percentage of males to allow in the course

balance-by-grade: (LOGC) Yes to attempt to balance course requests by grade

balance-by-grade-high-id: (INTG) Highest grade of students preferred in this course

balance-by-grade-low-id: (INTG) Lowest grade of students preferred in this course

balance-retakes: (LOGC) Yes to attempt to balance out students retaking a course

bldg-id: (INTG) Internally assigned building number

comments: (CHAR) Comments for/about this course/section

conflict-needs-rebuild: (LOGC) Does conflicts table for this section need rebuilding?

course-cost: (DECM) Base cost of the course for the district

course-fee: (DECM) Fee (if any) for this course

course-id: (INTG) Course Catalog entry for this course

course-level-id: (INTG) Course Level this course is associated with

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

credits: (DECM) Credits awarded for successful completion of course

enforce-fte-limit: (LOGC) Yes to enforce FTE limits, No to ignore them

enforce-seat-limit: (LOGC) Yes to enforce seat limits, No to ignore them

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

gpa-multiplier: (DECM) Grade Point multiplier for this course used when figuring GP

grading-policy: (CHAR) Grading policy for course (Pass/Fail, Numeric, Letter, etc)

include-attend: (LOGC) Yes if course should be considered for attendance

include-gpa: (LOGC) Yes if course should be included in GPA calculations

include-honor: (LOGC) Yes if this course should be considered for honor rolls

include-progress: (LOGC) Yes if this course should appear on student progress reports

include-rank: (LOGC) Yes if course should be considered when ranking students

include-report-card: (LOGC) Yes if this course should appear on students report cards

include-transcript: (LOGC) Yes to have course recorded in transcripts

max-fte: (DECM) Maximum Student FTE for this course

max-seat-cnt: (INTG) Maximum # of seats for this course

min-fte: (DECM) Minimum expected student FTE for this course

min-seat-cnt: (INTG) Minimum number of seats to for a section (this is not enforc

per-fte-cost: (DECM) Additional costs per FTE for this course

per-seat-cost: (DECM) Additional cost per seat for this course

preferred-fte: (DECM) Preferred student FTE for this course

preferred-seat-cnt: (INTG) Preferred # of seats for this course

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

retake-credit: (LOGC) Yes if students retaking this course can receive credit

schd-group-id: (INTG) Internally assigned scheduling group ID

schd-total-fte: (DECM) Total FTE of students scheduled for this course

schd-total-seat: (INTG) Total number of students scheduled for this course

schd-version-id: (INTG) Schedule Version we are associated with

school-year-id: (INTG) School year for this record

section-id: (INTG) [DEFINE KEY]

section-num: (INTG) Section #

section-sequence-id: (INTG) Index component

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

extern-guid: extern-guid

master-schd: (UNIQUE, PRIMARY) school-year-id, bldg-id, schd-version-id, course-id, section-id

section-num: school-year-id, bldg-id, schd-version-id, course-id, section-num

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference master-schd

assign-category - (no description available)

behave-incident - Behavior Incidents, if the distict is tracking them

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

scan-form-sheet - Scan Form Sheets

stu-assign - (no description available)

stu-assign-totals - (no description available)

stu-atnd-letter-item - This has one entry for each 'item' that appears on a letter.

stu-behave - Student behaviour records

stu-course-atnd - Course Based student attendance

stu-edp-course - (no description available)

stu-grade - Student Grades file.

stu-progress - Progress reports. One record per course per comment

stu-schedule - Student Schedule

stu-transcript-course - Student transcript courses. One per student/transcript/year/

Tables master-schd references

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

course-catalog - Course Catalog

course-level - Course Level header file. This has little content and mostly

course-stats - Course Request statistics

credential-area-course - (no description available)

email-info - (no description available)

grading-setup - Grading setup controls building level setup/policy issues wi

master-schd-display - This is a transient table used for master schedule display s

schd-group - Scheduling Group

school-year - School year file

section-sequence - (no description available)

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

user-bldg - User Restricted to building list

Detailed Alphabetical Field Listing
allow-conflicts Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to allow this course to conflict with another course

balance-by-age Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to attempt to balance course requests by students age

balance-by-age-high Data type: INTEGER
Format: z9 (Initial Value: 0)
Help: Highest age of students preferred in this course

balance-by-age-low Data type: INTEGER
Format: z9 (Initial Value: 0)
Help: Lowest age of students preferred in this course

balance-by-gender Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to attempt to balance course requests by gender

balance-by-gender-male-pct Data type: DECIMAL (Decimals: 2)
Format: zz9.99% (Initial Value: 50)
Help: Preferred percentage of males to allow in the course

balance-by-grade Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to attempt to balance course requests by grade

balance-by-grade-high-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Highest grade of students preferred in this course

balance-by-grade-low-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Lowest grade of students preferred in this course

balance-retakes Data type: LOGICAL
Format: Yes/No (Initial Value: NO)
Help: Yes to attempt to balance out students retaking a course

bldg-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Internally assigned building number
Attributes: Index Component

comments Data type: CHARACTER
Format: x(68)
Help: Comments for/about this course/section

conflict-needs-rebuild Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Does conflicts table for this section need rebuilding?

course-cost Data type: DECIMAL (Decimals: 2)
Format: zz,zz9.99 (Initial Value: 0)
Help: Base cost of the course for the district

course-fee Data type: DECIMAL (Decimals: 2)
Format: zz,zz9.99 (Initial Value: 0)
Help: Fee (if any) for this course

course-id Data type: INTEGER
Format: zzzzzzzzz9
Help: Course Catalog entry for this course
Attributes: Index Component

course-level-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Course Level this course is associated with

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

credits Data type: DECIMAL (Decimals: 3)
Format: z9.999 (Initial Value: 1.0)
Help: Credits awarded for successful completion of course

enforce-fte-limit Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to enforce FTE limits, No to ignore them

enforce-seat-limit Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes to enforce seat limits, No to ignore them

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

gpa-multiplier Data type: DECIMAL (Decimals: 3)
Format: 9.999 (Initial Value: 1)
Help: Grade Point multiplier for this course used when figuring GP

grading-policy Data type: CHARACTER
Format: x(9) (Initial Value: Letter)
Help: Grading policy for course (Pass/Fail, Numeric, Letter, etc)

include-attend Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if course should be considered for attendance

include-gpa Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if course should be included in GPA calculations

include-honor Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if this course should be considered for honor rolls

include-progress Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if this course should appear on student progress reports

include-rank Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if course should be considered when ranking students

include-report-card Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if this course should appear on students report cards

include-transcript Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes to have course recorded in transcripts

max-fte Data type: DECIMAL (Decimals: 3)
Format: zzz9.999 (Initial Value: 0)
Help: Maximum Student FTE for this course

max-seat-cnt Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Maximum # of seats for this course

min-fte Data type: DECIMAL (Decimals: 3)
Format: zzz9.999 (Initial Value: 0)
Help: Minimum expected student FTE for this course

min-seat-cnt Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Minimum number of seats to for a section (this is not enforc

per-fte-cost Data type: DECIMAL (Decimals: 2)
Format: zz,zz9.99 (Initial Value: 0)
Help: Additional costs per FTE for this course

per-seat-cost Data type: DECIMAL (Decimals: 2)
Format: zz,zz9.99 (Initial Value: 0)
Help: Additional cost per seat for this course

preferred-fte Data type: DECIMAL (Decimals: 3)
Format: zzz9.999 (Initial Value: 0)
Help: Preferred student FTE for this course

preferred-seat-cnt Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Preferred # of seats for this course

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

retake-credit Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if students retaking this course can receive credit

schd-group-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Internally assigned scheduling group ID

schd-total-fte Data type: DECIMAL (Decimals: 3)
Format: zzz9.999 (Initial Value: 0)
Help: Total FTE of students scheduled for this course

schd-total-seat Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Total number of students scheduled for this course

schd-version-id Data type: INTEGER
Format: zzzzzzzzz9
Help: Schedule Version we are associated with
Attributes: Index Component

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

section-id Data type: INTEGER
Format: zzzzzzzz9
Description: [DEFINE KEY]
Help: Internally assigned section ID
Attributes: Index Component

section-num Data type: INTEGER
Format: 99 (Initial Value: 0)
Help: Section #
Attributes: Index Component

section-sequence-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Index component
Help: Section Sequence for this section

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