Definition of table stu-year

One record for each year a student exists in the district , Table Dump Name stu-year

Alphabetical Field Summary

at-risk-flag: (LOGC) Is the student at risk of failing?

atnd-eligibility-id: (INTG) Attendance Eligibility ID

bldg-id: (INTG) Building student is currently assigned to

cell-phone: (CHAR) Cellular Phone number (if any)

cell-provider: (CHAR) Name of cell phone provider to send messages through, or "N/

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

email-addr: (CHAR) Email address, if any

email-direct-connect: (LOGC) 'Yes' to send direct connect messages to this email address

english-proficiency-id: (INTG) English proficiency ID

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

first-name: (CHAR) First Name

generation-name: (CHAR) Generation (e.g. Jr, III, etc)

gifted-talented-flag: (LOGC) Is this student gifted/talented?

grad-requirement-id: (INTG) Graduation Requirement for this student, if not default

grade-id: (INTG) Grade is student is currently assigned to

house-id: (INTG) House (if any) this student is currently assigned to

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

last-name: (CHAR) Last Name

middle-name: (CHAR) Middle Name

nickname: (CHAR) Nickname or preferred name

personnel-id: (INTG) Counselor this student reports to

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

promotion-path-id: (INTG) Promotion Path ID for this student

room-id: (INTG) Home room this student is currently reporting to

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

sped-code-id: (INTG) Special Ed Code ID

sped-fte: (DECM) Special Education FTE of student

status-code-id: (INTG) Student Status Code

stu-fte: (DECM) Student's FTE equivilency

stu-id: (CHAR) This is READ-ONLY and update by triggers. Use stu-base for u

stu-name: (CHAR) This is READ-ONLY & updated by triggers. Use stu-base for up

stu-seq: (INTG) Internally assigned Student Sequence #

teacher-of-record-id: (INTG) Internally Assigned ID

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

vocational-classification-id: (INTG) Vocational Classification ID

Alphabetical Index Summary

extern-guid: extern-guid

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

stu-counselor: school-year-id, personnel-id, stu-seq

stu-grade: school-year-id, bldg-id, grade-id, stu-seq

stu-homeroom: school-year-id, bldg-id, room-id, stu-seq

stu-house: school-year-id, bldg-id, house-id

stu-id: school-year-id, bldg-id, stu-id

stu-name: school-year-id, bldg-id, stu-name

stu-seq: stu-seq, school-year-id

stu-status: school-year-id, status-code-id, stu-seq

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

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference stu-year

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-request-master - Student Request Master Controls

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

Tables stu-year references

atnd-eligibility - Attendance Eligibility Codes

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

email-info - (no description available)

english-proficiency - English Proficiency Codes

grad-requirement-name - Graduation Requirements Names

grade-catalog - Grades Catalog

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

house - Houses for buildings

instruction-setting - Instruction settings for students and courses

personnel - Schools District personnel

promotion-path-grade - Promotion Grade/Bldg list for promotion paths

promotion-path-name - List of possible promotion paths

room-catalog - Rooms catalog, within a building

school-year - School year file

sped-code - Special Ed Codes

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

status-code - Student Status Codes

stu-assign - (no description available)

stu-base - Student Base record

stu-request-master - Student Request Master Controls

stu-transcript-year - Student Transcript Year record. One per student, per transcr

transcript-grade - List of grades/buildings that are considered for transcripts

user-bldg - User Restricted to building list

user-grade - User Grade level restriction

user-personnel - User Personnel level restrictions

vocational-classification - Vocational Classification codes

Detailed Alphabetical Field Listing
at-risk-flag Data type: LOGICAL
Format: yes/no (Initial Value: no)
Help: Is the student at risk of failing?

atnd-eligibility-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Attendance Eligibility ID

bldg-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Building student is currently assigned to
Attributes: Index Component

cell-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Help: Cellular Phone number (if any)

cell-provider Data type: CHARACTER
Format: x(16)
Help: Name of cell phone provider to send messages through, or "N/

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

email-addr Data type: CHARACTER
Format: x(40)
Description: Email address, if any

email-direct-connect Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: 'Yes' to send direct connect messages to this email address

english-proficiency-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: English proficiency ID

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

first-name Data type: CHARACTER
Format: x(24)
Description: First Name

generation-name Data type: CHARACTER
Format: x(16)
Description: Generation (e.g. Jr, III, etc)

gifted-talented-flag Data type: LOGICAL
Format: yes/no (Initial Value: no)
Help: Is this student gifted/talented?

grad-requirement-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Graduation Requirement for this student, if not default

grade-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Grade is student is currently assigned to
Attributes: Index Component

house-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: House (if any) this student is currently assigned to
Attributes: Index Component

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

last-name Data type: CHARACTER
Format: x(24)
Description: Last Name

middle-name Data type: CHARACTER
Format: x(24)
Description: Middle Name

nickname Data type: CHARACTER
Format: x(32)
Description: Nickname or preferred name

personnel-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Counselor this student reports to
Attributes: Index Component

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

promotion-path-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Promotion Path ID for this student

room-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Home room this student is currently reporting to
Attributes: Index Component

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

sped-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Special Ed Code ID

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

status-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Student Status Code
Attributes: Index Component

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

stu-id Data type: CHARACTER
Format: x(9)
Description: This is READ-ONLY and update by triggers. Use stu-base for u
Help: Students assigned ID #
Attributes: Index Component

stu-name Data type: CHARACTER
Format: x(32)
Description: This is READ-ONLY & updated by triggers. Use stu-base for up
Help: Name of student, Last name first
Attributes: Index Component

stu-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Student Sequence #
Attributes: Index Component

teacher-of-record-id Data type: INTEGER
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: Time this record was last updated at

upd-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user record was updated by

vocational-classification-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Vocational Classification ID

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