Definition of table Course_Request
Course Request Record , Table Dump Name res-0004

Alphabetical Field Summary

  • birth-date: (DATE) Students Birthdate
  • bldg-code: (CHAR) Short name for this building
  • counselor: (CHAR) Name of this person (last name first)
  • current-year: (LOGC) (no description available)
  • dw-valid-from: (DATE) (no description available)
  • dw-valid-to: (DATE) (no description available)
  • dw-version: (INTG) (no description available)
  • enrolled: (LOGC) Yes if this status code means the student is enrolled
  • ethnic-code: (CHAR) Ethnic code name
  • gender: (LOGC) Gender or student, Male or Female
  • grade: (CHAR) Name of this Grade (i.e. K, 1, 10, 12, etc)
  • home-room: (CHAR) Room # or name
  • house-code: (CHAR) Short name for this house
  • house-description: (CHAR) Description of the house
  • promotion-path-name: (CHAR) Name of this promotion path
  • request-allow-conflicts: (LOGC) Yes to allow this request to conflict with another request
  • request-alt-course-code: (CHAR) Course Code/Number
  • request-alt-description: (CHAR) Description of this course
  • request-bldg-code: (CHAR) Short name for this building
  • request-comments: (CHAR) Comments for this request
  • request-course-code: (CHAR) Course Code/Number
  • request-course-credits: (DECM) Credits awarded for successful completion of course
  • request-course-dept-name: (CHAR) Department Code/Short Name
  • request-course-description: (CHAR) Description of this course
  • request-course-group-code: (CHAR) Name of this course group
  • request-course-level-code: (CHAR) Short name for this course level
  • request-fte: (DECM) FTE for this requested course
  • request-high-section-num: (INTG) Highest section number of range
  • request-high-time: (CHAR) Latest time of day to schedule request for
  • request-low-section-num: (INTG) Lowest section number of range
  • request-low-time: (CHAR) Earliest time of day to schedule request for
  • request-needs-schd: (LOGC) Set to yes when changes require the request be rescheduled
  • request-override-credit: (DECM) Course credits (if different from the normal course)
  • request-override-credit-flag: (LOGC) Yes to override default credit for this students request
  • request-override-priority: (CHAR) Request priority
  • request-override-priority-flag: (LOGC) Yes to override the default course priority for this request
  • request-retake-flag: (LOGC) Yes if this request if for a course the student has had befo
  • request-schd-attempt-cnt: (INTG) Number of attempts the scheduler made to schedule this reque
  • request-schd-status: (CHAR) Result of last scheduling attempt for this request
  • request-section-control-flag: (CHAR) Section Controls for requests (N/A,Prefer,Require,Avoid,Reje
  • request-teacher-control-flag: (CHAR) Teacher Controls for requests (N/A,Prefer,Require,Avoid,Reje
  • request-time-control-flag: (CHAR) Time Controls for requests (N/A,Prefer,Require,Avoid,Reject)
  • school-year-name: (CHAR) Name for school year (i.e. 1993/94, etc)
  • sped-code: (CHAR) Name of student special education code
  • sped-fte: (DECM) Special Education FTE of student
  • state-ethnic-code: (CHAR) State Assigned ethnic code
  • status-code: (CHAR) Name of student status code
  • stu-fte: (DECM) Student's FTE equivilency
  • stu-id: (CHAR) Students assigned ID #
  • stu-name: (CHAR) Name of student, Last name first
  • stu-ssn: (CHAR) Students SSN (if available)
  • year-of-grad: (INTG) Expected year of graduation for a student in this grade

    Alphabetical Index Summary

  • bldg-code: (PRIMARY) bldg-code
  • counselor: counselor
  • ethnic-code: ethnic-code
  • grade: grade
  • home-room: home-room
  • house-code: house-code
  • house-description: house-description
  • promotion-path-name: promotion-path-name
  • request-alt-course-code: request-alt-course-code
  • request-alt-description: request-alt-description
  • request-bldg-code: request-bldg-code
  • request-course-code: request-course-code
  • request-course-dept-name: request-course-dept-name
  • request-course-description: request-course-description
  • request-course-group-code: request-course-group-code
  • request-course-level-code: request-course-level-code
  • request-needs-schd: request-needs-schd
  • request-override-priority: request-override-priority
  • school-year-name: school-year-name
  • sped-code: sped-code
  • status-code: status-code
  • stu-id: stu-id
  • stu-name: stu-name
  • stu-ssn: stu-ssn
  • year-of-grad: year-of-grad

    Tables Course_Request references

  • Contact - Student Contacts
  • Daily_Attendance - Daily Attendance
  • GPA_Rank - Student GPAs
  • Honor_Roll - Student Awarded Honor Rolls
  • Medical_Record - Medical Notes
  • Note - Student Notes
  • Report_Card - Report Card Data
  • Scheduled_Course - Scheduled Student Course
  • Student - Basic Student Data
  • Transcript_Course - Transcript Course
  • Transcript_Year - Student Transcript Year data

    Detailed Alphabetical Field Listing
    birth-date Data type: DATE
    Format: 99/99/9999
    Description: Students Birthdate

    bldg-code Data type: CHARACTER
    Format: x(8)
    Description: Short name for this building
    Attributes: Index Component

    counselor Data type: CHARACTER
    Format: x(32)
    Description: Name of this person (last name first)
    Attributes: Index Component

    current-year Data type: LOGICAL
    Format: yes/no (Initial Value: no)

    dw-valid-from Data type: DATE
    Format: 99/99/9999

    dw-valid-to Data type: DATE
    Format: 99/99/9999

    dw-version Data type: INTEGER
    Format: zzzzzzzzzzz9 (Initial Value: 0)

    enrolled Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if this status code means the student is enrolled

    ethnic-code Data type: CHARACTER
    Format: x(8)
    Description: Ethnic code name
    Attributes: Index Component

    gender Data type: LOGICAL
    Format: Male/Female (Initial Value: no)
    Description: Gender or student, Male or Female

    grade Data type: CHARACTER
    Format: x(3)
    Description: Name of this Grade (i.e. K, 1, 10, 12, etc)
    Attributes: Index Component

    home-room Data type: CHARACTER
    Format: x(6)
    Description: Room # or name
    Attributes: Index Component

    house-code Data type: CHARACTER
    Format: x(8)
    Description: Short name for this house
    Attributes: Index Component

    house-description Data type: CHARACTER
    Format: x(28)
    Description: Description of the house
    Attributes: Index Component

    promotion-path-name Data type: CHARACTER
    Format: x(8)
    Description: Name of this promotion path
    Attributes: Index Component

    request-allow-conflicts Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes to allow this request to conflict with another request

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

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

    request-bldg-code Data type: CHARACTER
    Format: x(8)
    Description: Short name for this building
    Attributes: Index Component

    request-comments Data type: CHARACTER
    Format: x(68)
    Description: Comments for this request

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

    request-course-credits Data type: DECIMAL (Decimals: 2)
    Format: z9.999 (Initial Value: 0)
    Description: Credits awarded for successful completion of course

    request-course-dept-name Data type: CHARACTER
    Format: x(8)
    Description: Department Code/Short Name
    Attributes: Index Component

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

    request-course-group-code Data type: CHARACTER
    Format: x(8)
    Description: Name of this course group
    Attributes: Index Component

    request-course-level-code Data type: CHARACTER
    Format: x(8)
    Description: Short name for this course level
    Attributes: Index Component

    request-fte Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Description: FTE for this requested course

    request-high-section-num Data type: INTEGER
    Format: 99 (Initial Value: 0)
    Description: Highest section number of range

    request-high-time Data type: CHARACTER
    Format: x(8)
    Description: Latest time of day to schedule request for

    request-low-section-num Data type: INTEGER
    Format: 99 (Initial Value: 0)
    Description: Lowest section number of range

    request-low-time Data type: CHARACTER
    Format: x(8)
    Description: Earliest time of day to schedule request for

    request-needs-schd Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Set to yes when changes require the request be rescheduled
    Attributes: Index Component

    request-override-credit Data type: DECIMAL (Decimals: 3)
    Format: z9.999 (Initial Value: 0)
    Description: Course credits (if different from the normal course)

    request-override-credit-flag Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes to override default credit for this students request

    request-override-priority Data type: CHARACTER
    Format: x(10)
    Description: Request priority
    Attributes: Index Component

    request-override-priority-flag Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes to override the default course priority for this request

    request-retake-flag Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if this request if for a course the student has had befo

    request-schd-attempt-cnt Data type: INTEGER
    Format: zzzzz9 (Initial Value: 0)
    Description: Number of attempts the scheduler made to schedule this reque

    request-schd-status Data type: CHARACTER
    Format: x(16)
    Description: Result of last scheduling attempt for this request

    request-section-control-flag Data type: CHARACTER
    Format: x(8)
    Description: Section Controls for requests (N/A,Prefer,Require,Avoid,Reje

    request-teacher-control-flag Data type: CHARACTER
    Format: x(8)
    Description: Teacher Controls for requests (N/A,Prefer,Require,Avoid,Reje

    request-time-control-flag Data type: CHARACTER
    Format: x(8)
    Description: Time Controls for requests (N/A,Prefer,Require,Avoid,Reject)

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

    sped-code Data type: CHARACTER
    Format: x(8)
    Description: Name of student special education code
    Attributes: Index Component

    sped-fte Data type: DECIMAL (Decimals: 2)
    Format: 9.999 (Initial Value: 0)
    Description: Special Education FTE of student

    state-ethnic-code Data type: CHARACTER
    Format: x(8)
    Description: State Assigned ethnic code

    status-code Data type: CHARACTER
    Format: x(8)
    Description: Name of student status code
    Attributes: Index Component

    stu-fte Data type: DECIMAL (Decimals: 3)
    Format: 9.999 (Initial Value: 0)
    Description: Student's FTE equivilency

    stu-id Data type: CHARACTER
    Format: x(9)
    Description: Students assigned ID #
    Attributes: Index Component

    stu-name Data type: CHARACTER
    Format: x(32)
    Description: Name of student, Last name first
    Attributes: Index Component

    stu-ssn Data type: CHARACTER
    Format: xxx-xx-xxxx
    Description: Students SSN (if available)
    Attributes: Index Component

    year-of-grad Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Expected year of graduation for a student in this grade
    Attributes: Index Component

    Created on 02/08/2008 by DBHTML V1.2