Definition of table stu-transcript-year

Student Transcript Year record. One per student, per transcript, per year in school , Table Dump Name stu-trny

Alphabetical Field Summary

absence-count: (DECM) Number of absences in this year

attempted-credit: (DECM) Total attempted credits this year

bldg-id: (INTG) Building ID associated with this record

comments: (CHAR) Comments for/about this transcript year

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

cumulative-absence-count: (DECM) Cumulative number of absences

cumulative-attempted-credit: (DECM) Cumulative attempted credits

cumulative-earned-credit: (DECM) Cumulative earned credits

cumulative-gpa: (DECM) Cumulative GPA for student thus far

cumulative-grade-count: (INTG) Number of grades used for cumulative GPA calculation

cumulative-grade-points: (DECM) Grade points earned cumulatively

cumulative-rank: (INTG) Cumulative Rank

cumulative-rank-gpa: (DECM) Cumulative GPA for rankable classes

cumulative-rank-grade-count: (INTG) Number of cumulative grades used for rankable GPA calculatio

cumulative-rank-grade-points: (DECM) Cumulative rankable grade points

cumulative-tardy-count: (DECM) Cumulative tardies

earned-credit: (DECM) Total earned credits this year

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

grade-id: (INTG) Grade this record is associated with

include-in-rank: (LOGC) Should this years records be included in ranking?

needs-calc: (LOGC) Does this year need to be recalculated?

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

rank-gpa: (DECM) GPA for rankable classes of this year

rank-grade-count: (INTG) Number of grades used for years rankable GPA calculation

rank-grade-points: (DECM) Rankable grade points for year

school-year-id: (INTG) School year ID associated with this record

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

tardy-count: (DECM) Number of tardies in this year

transcript-id: (INTG) Internally assigned transcript identifier

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

year-gpa: (DECM) GPA for this year

year-grade-count: (INTG) Number of grades used for years GPA calculation

year-grade-points: (DECM) Grade points earned for year

year-rank: (INTG) Rank for this year

Alphabetical Index Summary

extern-guid: extern-guid

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

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

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

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

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference stu-transcript-year

course-level-grade - Course Level grade file. One entry in here for each possible

course-stats - Course Request statistics

grade-catalog - Grades Catalog

honor-roll-grade - List of required or forbidden grades for this honor roll

master-schd-stats - Master Schedule Statistics

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

stu-edp-course - (no description available)

stu-grade-mark - One entry for each mark a student received for the associate

stu-history - Student Activity History

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

stu-transcript-mark - Student transcript marks

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

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

user-grade - User Grade level restriction

Tables stu-transcript-year references

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

email-info - (no description available)

grade-catalog - Grades Catalog

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

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

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

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

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

transcript-name - Listing of transcripts

user-bldg - User Restricted to building list

user-grade - User Grade level restriction

Detailed Alphabetical Field Listing
absence-count Data type: DECIMAL (Decimals: 2)
Format: zz9.99 (Initial Value: 0)
Help: Number of absences in this year

attempted-credit Data type: DECIMAL (Decimals: 3)
Format: z9.999 (Initial Value: 0)
Help: Total attempted credits this year

bldg-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Building ID associated with this record
Attributes: Index Component

comments Data type: CHARACTER
Format: x(68)
Help: Comments for/about this transcript year

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

cumulative-absence-count Data type: DECIMAL (Decimals: 2)
Format: zz9.99 (Initial Value: 0)
Help: Cumulative number of absences

cumulative-attempted-credit Data type: DECIMAL (Decimals: 3)
Format: z9.999 (Initial Value: 0)
Help: Cumulative attempted credits

cumulative-earned-credit Data type: DECIMAL (Decimals: 3)
Format: z9.999 (Initial Value: 0)
Help: Cumulative earned credits

cumulative-gpa Data type: DECIMAL (Decimals: 3)
Format: zz9.999 (Initial Value: 0)
Help: Cumulative GPA for student thus far

cumulative-grade-count Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Number of grades used for cumulative GPA calculation

cumulative-grade-points Data type: DECIMAL (Decimals: 3)
Format: zzz9.999 (Initial Value: 0)
Help: Grade points earned cumulatively

cumulative-rank Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Cumulative Rank

cumulative-rank-gpa Data type: DECIMAL (Decimals: 3)
Format: zz9.999 (Initial Value: 0)
Help: Cumulative GPA for rankable classes

cumulative-rank-grade-count Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Number of cumulative grades used for rankable GPA calculatio

cumulative-rank-grade-points Data type: DECIMAL (Decimals: 3)
Format: zzz9.999 (Initial Value: 0)
Help: Cumulative rankable grade points

cumulative-tardy-count Data type: DECIMAL (Decimals: 2)
Format: zz9.99 (Initial Value: 0)
Help: Cumulative tardies

earned-credit Data type: DECIMAL (Decimals: 3)
Format: z9.999 (Initial Value: 0)
Help: Total earned credits this year

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

grade-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Grade this record is associated with
Attributes: Index Component

include-in-rank Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Should this years records be included in ranking?

needs-calc Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Does this year need to be recalculated?

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

rank-gpa Data type: DECIMAL (Decimals: 3)
Format: zz9.999 (Initial Value: 0)
Help: GPA for rankable classes of this year

rank-grade-count Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Number of grades used for years rankable GPA calculation

rank-grade-points Data type: DECIMAL (Decimals: 3)
Format: zzz9.999 (Initial Value: 0)
Help: Rankable grade points for year

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

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

tardy-count Data type: DECIMAL (Decimals: 2)
Format: zz9.99 (Initial Value: 0)
Help: Number of tardies in this year

transcript-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned transcript identifier
Attributes: Index Component

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

year-gpa Data type: DECIMAL (Decimals: 3)
Format: zz9.999 (Initial Value: 0)
Help: GPA for this year

year-grade-count Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Number of grades used for years GPA calculation

year-grade-points Data type: DECIMAL (Decimals: 3)
Format: zzz9.999 (Initial Value: 0)
Help: Grade points earned for year

year-rank Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Rank for this year

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