Definition of table stu-request-master

Student Request Master Controls , Table Dump Name stu-reqm

Alphabetical Field Summary

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 to exclude/require

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

low-section-num: (INTG) Lowest section number to exclude/require

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

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

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

request-group-id: (INTG) Request Group to schedule student in

request-priority: (CHAR) Priority students requests should be scheduled at

requests-needs-schd: (LOGC) Set to yes when changes require all requests to be reschedul

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

verify-letter-returned: (LOGC) Yes if verification letter has been returned

verify-letter-sent: (LOGC) Yes if a verification letter has been sent

Alphabetical Index Summary

extern-guid: extern-guid

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

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference stu-request-master

imported-item -

imported-record - (no description available)

scan-form-line - Scan Form Line info

scan-form-sheet - Scan Form Sheets

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-base - Student Base record

stu-behave - Student behaviour records

stu-behave-event - Student Behaviour Events

stu-contact - Student Contacts file

stu-contact-mailing - Student Contact Mailing definitions. For stu-contact records

stu-counseling - (no description available)

stu-course-atnd - Course Based student attendance

stu-credential - (no description available)

stu-credential-area - (no description available)

stu-credential-assessment - (no description available)

stu-credential-outcome - (no description available)

stu-credential-standard - (no description available)

stu-credential-year - (no description available)

stu-daily-atnd - Daily student attendance entries

stu-edp - (no description available)

stu-edp-course - (no description available)

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-medical - Student Medical information

stu-note - Student Notes file

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-site - Site Specific Student data file

stu-state-item - Describes a students state record entry

stu-title1-service - Student Title 1 Service

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

Tables stu-request-master references

email-info - (no description available)

personnel - Schools District personnel

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

school-year - School year file

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

stu-assign - (no description available)

stu-base - Student Base record

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

user-personnel - User Personnel level restrictions

Detailed Alphabetical Field Listing
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 to exclude/require

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

low-section-num Data type: INTEGER
Format: 99 (Initial Value: 0)
Help: Lowest section number to exclude/require

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

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

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

request-group-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Request Group to schedule student in

request-priority Data type: CHARACTER
Format: x(10)
Help: Priority students requests should be scheduled at

requests-needs-schd Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Set to yes when changes require all requests to be reschedul

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

verify-letter-returned Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Description: Yes if verification letter has been returned

verify-letter-sent Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Description: Yes if a verification letter has been sent

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