Definition of table course-catalog

Course Catalog , Table Dump Name crs-cat

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 and/or description for this course

coop-voc-ed-flag: (LOGC) Is this a coop vocational education course

course-blocks-by: (CHAR) Schedule course blocks as None, One, Some, All or Sequence

course-code: (CHAR) Course Code/Number

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

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

course-group-id: (INTG) Group this course is associated with

course-id: (INTG) [DEFINE KEY]

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

course-priority: (CHAR) Default Course Priority for student requests

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

dept-id: (INTG) Department course is associated with

description: (CHAR) Description of this course

distance-learning-id: (INTG) Distance learning code that this course is associated with

dual-credit-flag: (LOGC) Does the course count for both college and school credit?

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

grade-level-begin-id: (INTG) Grade Level Begin ID

grade-level-end-id: (INTG) Grade Level End ID

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

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

include-conflict: (LOGC) Yes to print on conflict matrix, No to omit from this report

include-gpa: (LOGC) Yes if this 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-simple-tally: (LOGC) Yes to include on the simple tally, No to omit

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

instruction-setting-id: (INTG) Instructional setting ID

master-course-id: (INTG) ID of course-catalog this code is tied to

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

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

max-section-cnt: (INTG) Maximum # of sections 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

min-section-cnt: (INTG) Minimum # of sections expected for this course

pep-indicator-flag: (LOGC) Is this a PEP (pegnancy related) course?

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

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

population-served-id: (INTG) Population Served ID

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

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

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

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

request-total-fte: (DECM) Total FTE of requests for this course

request-total-seat: (INTG) Total number of requests for this course

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

role-code-id: (INTG) Internally Assigned Id

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

state-course-code-id: (INTG) Internally Assigned ID

table-code-id[10]: (INTG) Internally Assigned ID

table-name-id[10]: (INTG) Internally assigned id

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

use-any-section: (LOGC) Yes to allow any section of course, No to force same section

user-value[10]: (CHAR) Enter the value

Alphabetical Index Summary

course-code: school-year-id, bldg-id, course-code

course-department: school-year-id, bldg-id, dept-id, course-id

course-id: (UNIQUE, PRIMARY) school-year-id, bldg-id, course-id

course-priority: school-year-id, bldg-id, course-priority, course-id

description: school-year-id, bldg-id, description

extern-guid: extern-guid

state-course-code: school-year-id, state-course-code-id, course-id

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference course-catalog

assign-category - (no description available)

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

course-alternate - Course Alternative entries

course-block - Course Blocking Defaults

course-distrib - Course Costs Distributions

course-group-alternate - Alternate course for a course group

course-stats - Course Request statistics

course-study-area - Course Study Area

credential-area-course - (no description available)

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

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-request - Student Requests File

stu-schedule - Student Schedule

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

Tables course-catalog references

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

course-group - Course Groups

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

course-stats - Course Request statistics

credential-area-course - (no description available)

department - Department Classifications

distance-learning - Distance learning codes

email-info - (no description available)

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

honor-roll-group - List of course gourps that are required or forbidden from th

instruction-setting - Instruction settings for students and courses

population-served - Population served by a course

role-code - The role code associated with a course

school-year - School year file

site-table-code - Site Table Codes

site-table-name - Site Table Names

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

state-course-code - State Course Codes

user-bldg - User Restricted to building list

user-department - User Department Level Restrictions

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 and/or description for this course

coop-voc-ed-flag Data type: LOGICAL
Format: yes/no (Initial Value: no)
Description: Is this a coop vocational education course

course-blocks-by Data type: CHARACTER
Format: x(8)
Help: Schedule course blocks as None, One, Some, All or Sequence

course-code Data type: CHARACTER
Format: x(6)
Help: Course Code/Number
Attributes: Index Component

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-group-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Group this course is associated with

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

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

course-priority Data type: CHARACTER
Format: x(10)
Help: Default Course Priority for student requests
Attributes: Index Component

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

dept-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Department course is associated with
Attributes: Index Component

description Data type: CHARACTER
Format: x(28)
Help: Description of this course
Attributes: Index Component

distance-learning-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Distance learning code that this course is associated with

dual-credit-flag Data type: LOGICAL
Format: yes/no (Initial Value: no)
Help: Does the course count for both college and school credit?

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

grade-level-begin-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Grade Level Begin ID

grade-level-end-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Grade Level End ID

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-conflict Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes to print on conflict matrix, No to omit from this report

include-gpa Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if this 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-simple-tally Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes to include on the simple tally, No to omit

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

instruction-setting-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Instructional setting ID

master-course-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: ID of course-catalog this code is tied to

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

max-section-cnt Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Maximum # of sections 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

min-section-cnt Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Minimum # of sections expected for this course

pep-indicator-flag Data type: LOGICAL
Format: yes/no (Initial Value: no)
Help: Is this a PEP (pegnancy related) course?

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

population-served-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Population Served ID

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

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

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

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

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

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

role-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally Assigned Id

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

state-course-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally Assigned ID
Attributes: Index Component

table-code-id Data type: INTEGER (Extent: 10)
Format: zzzzzzzzzzz9
Description: Internally Assigned ID

table-name-id Data type: INTEGER (Extent: 10)
Format: zzzzzzzzzzz9
Description: Internally assigned id

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

use-any-section Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to allow any section of course, No to force same section

user-value Data type: CHARACTER (Extent: 10)
Format: x(8)
Help: Enter the value

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