Definition of table honor-roll

Honor roll setup/defitions , Table Dump Name honrroll

Alphabetical Field Summary

atnd-based-on: (CHAR) Attendance Based on (Period, School Year, Transcript)

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

calc-order: (INTG) Calculation order of this honor roll

comments: (CHAR) Comments for/about this honor roll

course-atnd-check: (LOGC) Yes to restrict this honor roll by course attendance

course-atnd-class-id: (INTG) Course atnd-class to use for restriction checks

course-high-range: (INTG) High range for course restrictions checking

course-low-range: (INTG) Low range for course restrictions checking

cre-date: (DATE) Date record was created

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

cre-user-name: (CHAR) User name of user who creatd this record

daily-atnd-check: (LOGC) Yes to restrict this honor roll by daily attendance

daily-atnd-class-id: (INTG) daily atnd-class to use for restriction checks

daily-high-range: (INTG) High range for daily restrictions checking

daily-low-range: (INTG) Low range for daily restrictions checking

description: (CHAR) Description of this honor roll

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

high-gpa: (DECM) Highest GPA in this honor roll

honor-roll-id: (INTG) Internally assigned honor roll ID [DEFINE KEY]

honor-roll-name: (CHAR) Name of this honor roll

low-gpa: (DECM) Lowest GPA in this honor roll

mark-id: (INTG) Mark ID honor roll is calculated on

period-atnd-check: (LOGC) Yes to restrict this honor roll by period attendance

period-atnd-class-id: (INTG) Period atnd-class to use for restriction checks

period-high-range: (INTG) High range for period restrictions checking

period-low-range: (INTG) Low range for period restrictions checking

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

schd-group-id: (INTG) Schd Group used for attendance calculations

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

upd-date: (DATE) Date this records was last updated on

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

upd-user-name: (CHAR) Name of user who last updated this record

Alphabetical Index Summary

extern-guid: extern-guid

honor-by-calc: school-year-id, calc-order, honor-roll-id

honor-roll: (UNIQUE, PRIMARY) school-year-id, bldg-id, honor-roll-id

honor-roll-name: school-year-id, bldg-id, honor-roll-name, honor-roll-id

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference honor-roll

grading-period-honor - Honor rolls enabled for a given grading period

honor-roll-comment - Comment codes required or forbidden from this honor roll

honor-roll-exclude - Honor rolls you can't already have if you want to get this o

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

honor-roll-group - List of course gourps that are required or forbidden from th

stu-honor-roll - List of honor rolls a student has achieved

Tables honor-roll references

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

email-info - (no description available)

grading-bldg-xlate - Support for translating between grading periods/marks of bui

grading-mark - List of possible marks (not grades) for this building

grading-period-honor - Honor rolls enabled for a given grading period

grading-period-mark - List of marks enabled for this grading period

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

schd-group - Scheduling Group

school-year - School year file

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

stu-rank-gpa-by-mark - Ranking and GPA by period mark

stu-transcript-mark - Student transcript marks

user-bldg - User Restricted to building list

Detailed Alphabetical Field Listing
atnd-based-on Data type: CHARACTER
Format: x(12) (Initial Value: School Year)
Help: Attendance Based on (Period, School Year, Transcript)

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

calc-order Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Calculation order of this honor roll
Attributes: Index Component

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

course-atnd-check Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to restrict this honor roll by course attendance

course-atnd-class-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Course atnd-class to use for restriction checks

course-high-range Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Description: High range for course restrictions checking

course-low-range Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Low range for course restrictions checking

cre-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Help: Date record was created

cre-time Data type: CHARACTER
Format: x(8)
Help: Time record was created at

cre-user-name Data type: CHARACTER
Format: x(16)
Help: User name of user who creatd this record

daily-atnd-check Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to restrict this honor roll by daily attendance

daily-atnd-class-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: daily atnd-class to use for restriction checks

daily-high-range Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Description: High range for daily restrictions checking

daily-low-range Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Low range for daily restrictions checking

description Data type: CHARACTER
Format: x(28)
Help: Description of this honor roll

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

high-gpa Data type: DECIMAL (Decimals: 3)
Format: z9.999 (Initial Value: 0)
Help: Highest GPA in this honor roll

honor-roll-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned honor roll ID [DEFINE KEY]
Attributes: Index Component

honor-roll-name Data type: CHARACTER
Format: x(8)
Help: Name of this honor roll
Attributes: Index Component

low-gpa Data type: DECIMAL (Decimals: 3)
Format: z9.999 (Initial Value: 0)
Help: Lowest GPA in this honor roll

mark-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Mark ID honor roll is calculated on

period-atnd-check Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to restrict this honor roll by period attendance

period-atnd-class-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Period atnd-class to use for restriction checks

period-high-range Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Description: High range for period restrictions checking

period-low-range Data type: INTEGER
Format: zzz9 (Initial Value: 0)
Help: Low range for period restrictions checking

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

schd-group-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Schd Group used for attendance calculations

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

upd-date Data type: DATE
Format: 99/99/9999
Help: Date this records was last updated on

upd-time Data type: CHARACTER
Format: x(8)
Help: Time the record was last updated at

upd-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who last updated this record

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