Definition of table stu-request

Student Requests File , Table Dump Name stu-requ

Alphabetical Field Summary

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

alternate-course-id: (INTG) Alternate course (if any) for this request

bldg-id: (INTG) This is not always the same as stu-year.bldg-id (multi-bldg

comments: (CHAR) Comments for this request

course-credit: (DECM) Course credits (if different from the normal course)

course-id: (INTG) Course Requested by the student

cre-date: (DATE) Date record was created

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

cre-user-name: (CHAR) Name of user who created the record

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

high-section-num: (INTG) Highest section number of range

high-time: (CHAR) Latest time of day to schedule request for

low-section-num: (INTG) Lowest section number of range

low-time: (CHAR) Earliest time of day to schedule request for

override-credit: (LOGC) Yes to override default credit for this students request

override-priority: (LOGC) Yes to override the default course priority for this request

personnel-id: (INTG) Teacher ID of the teacher for request (if any)

request-attempt-cnt: (INTG) Number of attempts the scheduler made to schedule this reque

request-fte: (DECM) FTE for this requested course

request-needs-schd: (LOGC) Set to yes when changes require the request be rescheduled

request-priority: (CHAR) Request priority

request-schd-status: (CHAR) Result of last scheduling attempt for this request

request-seq: (INTG) Internally assigned request Seq# for schedule tracking [DEFI

retake-flag: (LOGC) Yes if this request if for a course the student has had befo

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

section-control: (CHAR) Section Controls for requests (N/A,Prefer,Require,Avoid,Reje

stu-seq: (INTG) Student Seq# for this request

teacher-control: (CHAR) Teacher Controls for requests (N/A,Prefer,Require,Avoid,Reje

time-control: (CHAR) Time Controls for requests (N/A,Prefer,Require,Avoid,Reject)

upd-date: (DATE) Date record was last updated

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

upd-user-name: (CHAR) Name of user record was updated by

Alphabetical Index Summary

extern-guid: extern-guid

request-course: school-year-id, bldg-id, course-id, stu-seq

request-needed: school-year-id, bldg-id, request-needs-schd, request-priority, course-id

stu-request: (UNIQUE, PRIMARY) school-year-id, stu-seq, request-seq

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference stu-request

stu-schedule - Student Schedule

Tables stu-request references

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

course-alternate - Course Alternative entries

course-catalog - Course Catalog

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

course-stats - Course Request statistics

credential-area-course - (no description available)

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

personnel - Schools District personnel

school-year - School year file

stu-assign - (no description available)

stu-base - Student Base record

stu-request-master - Student Request Master Controls

stu-year - One record for each year a student exists in the district

user-bldg - User Restricted to building list

user-personnel - User Personnel level restrictions

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

alternate-course-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Alternate course (if any) for this request

bldg-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: This is not always the same as stu-year.bldg-id (multi-bldg
Help: Building this course is offered in
Attributes: Index Component

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

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

course-id Data type: INTEGER
Format: zzzzzzzzz9
Help: Course Requested by the student
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 this record was created at

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

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

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

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

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

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

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

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

personnel-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Teacher ID of the teacher for request (if any)

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

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

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

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

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

request-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned request Seq# for schedule tracking [DEFI
Attributes: Index Component

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

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

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

stu-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Student Seq# for this request
Attributes: Index Component

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

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

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: Time this record was 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