Definition of table building

One record for each building, for each scheduling version, for each year in the district , Table Dump Name building

Alphabetical Field Summary

bldg-addr[2]: (CHAR) Street Address of this building

bldg-city: (CHAR) City building resides in

bldg-code: (CHAR) Short name for this building

bldg-id: (INTG) [DEFINE KEY]

bldg-name: (CHAR) Full name of the building

bldg-phone: (CHAR) Main phone number for this building

bldg-state: (CHAR) State building resides in

bldg-zip: (CHAR) Zip/Postal code for this building

carnegie-unit-multiplier: (DECM) Amount to multiply credit by to convert to Carnegie Units

comments: (CHAR) Comments for/about this building

cre-date: (DATE) Date record was created

cre-time: (CHAR) Time record was created

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

drop-email: (CHAR) Email to send drop notifications

enroll-email: (CHAR) Email address to send for enrollments to this building

enrolled-count: (INTG) Number of students currently enrolled

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

grad-requirement-id: (INTG) Default Graduation Requirement for this building, if any

has-houses: (LOGC) Does the building have houses?

msds-home-room: (LOGC) Treat home rooms in this building as a course for MSDS purpo

period-desc: (CHAR) Name of periods/classes for this building (period, hour, etc

personnel-id: (INTG) Building Principal (if applicable)

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

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

request-cnt[10]: (INTG) Total number of requests at this priority

request-default[10]: (LOGC) Is this the default priority for courses/requests?

request-fte[10]: (DECM) Total request FTE for this priority

request-priority[10]: (CHAR) Course/Request Priorities (#1 is most important, #10 least)

request-required[10]: (LOGC) Courses/Requests with this priority will always be scheduled

request-total-cnt: (INTG) Total number of requests for this building

request-total-fte: (DECM) Total FTE of requests for this building

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

state-bldg-code: (CHAR) State Assigned building code

title1-indicator: (CHAR) Enter the title 1 indicator

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

upd-time: (CHAR) Record last updated at

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

web-motd: (CHAR) Message of the day, if any, for display via web

Alphabetical Index Summary

bldg-code: school-year-id, bldg-code

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

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

extern-guid: extern-guid

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference building

assign-category - (no description available)

atnd-calendar-day - Building Attendance calendar

atnd-calendar-group - Attendance calendar group

atnd-class - Attendance Code Classes

atnd-class-link - Links between the attendance codes and class files

atnd-code - Attendance Code definitions

atnd-letter - One entry per attendance letter

atnd-letter-mailing - One record per selected mailing class for this letter

atnd-letter-relation - Attendance letter relationships. There is an entry for any l

behave-action - Behaviour Actions

behave-class - Behaviour class codes allow various behave-codes to be colle

behave-class-link - This file is used to link each behave-class to it's associat

behave-code - Behviour Codes

behave-incident - Behavior Incidents, if the distict is tracking them

behave-variance - Table to describe variances between official and actual days

course-alternate - Course Alternative entries

course-block - Course Blocking Defaults

course-catalog - Course Catalog

course-disposition - Holds disposition codes for transciptable marks

course-distrib - Course Costs Distributions

course-group - Course Groups

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

course-level - Course Level header file. This has little content and mostly

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

course-stats - Course Request statistics

course-study-area - Course Study Area

course-to-daily - Transalations for student course based attendance to daily b

credential-area-course - (no description available)

daily-atnd-post-log - Log file of postings on a date/room basis

department - Department Classifications

form-bldg - Form definitions, on a per building level

grade-catalog - Grades Catalog

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

grading-comment - Grading Comments. These are comments that teachers can assig

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

grading-period - Grading period file holds a list of grading periods for a gi

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

honor-roll - Honor roll setup/defitions

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

house - Houses for buildings

interleave-code - Scheduler Interleave codes

interleave-group - Interleave code groups

master-schd - Master Schedule records One entry per course, per section fo

master-schd-assign - (no description available)

master-schd-conflict - One entry per master schd record that conflicts with a cours

master-schd-display - This is a transient table used for master schedule display s

master-schd-distrib - Master Schedule Distributions files

master-schd-mark - List of marks to record for each grading period with this se

master-schd-meets - Course meets entry. There may be many of these for each c

master-schd-note - (no description available)

master-schd-post-log - Log file of postings on a per-section basis

master-schd-stats - Master Schedule Statistics

period-catalog - Period Name catalog

personnel-bldg - Personnel/Building Linkage file

progress-comment - Progress Report Comments

progress-period - Progress reporting periods

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

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

room-catalog - Rooms catalog, within a building

scan-form-batch - Scan form batch. Each set of scan forms printed becomes a 'b

scan-form-dataset - Scan form datasets. Many forms are simple and only have one

scan-form-line - Scan Form Line info

scan-form-sheet - Scan Form Sheets

schd-group - Scheduling Group

schd-period - These define the minimum period a course can be scheduled fo

schd-version - Master Schedule Versions

section-sequence - (no description available)

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-behave - Student behaviour records

stu-behave-event - Student Behaviour Events

stu-course-atnd - Course Based student attendance

stu-daily-atnd - Daily student attendance entries

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-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-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

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

user-bldg - User Restricted to building list

user-department - User Department Level Restrictions

user-grade - User Grade level restriction

user-personnel - User Personnel level restrictions

Tables building references

email-info - (no description available)

grad-requirement-name - Graduation Requirements Names

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

personnel - Schools District personnel

promotion-path-name - List of possible promotion paths

school-year - School year file

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

user-bldg - User Restricted to building list

user-personnel - User Personnel level restrictions

Detailed Alphabetical Field Listing
bldg-addr Data type: CHARACTER (Extent: 2)
Format: x(30)
Help: Street Address of this building

bldg-city Data type: CHARACTER
Format: x(25)
Help: City building resides in

bldg-code Data type: CHARACTER
Format: x(8)
Help: Short name for this building
Attributes: Index Component

bldg-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: [DEFINE KEY]
Help: Internally assigned building number
Attributes: Index Component

bldg-name Data type: CHARACTER
Format: x(28)
Help: Full name of the building
Attributes: Index Component

bldg-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Help: Main phone number for this building

bldg-state Data type: CHARACTER
Format: !!
Help: State building resides in

bldg-zip Data type: CHARACTER
Format: xxxxx-xxxx
Help: Zip/Postal code for this building

carnegie-unit-multiplier Data type: DECIMAL (Decimals: 2)
Format: z9.99 (Initial Value: 1)
Help: Amount to multiply credit by to convert to Carnegie Units

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

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 record was created

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

drop-email Data type: CHARACTER
Format: x(128)
Help: Email to send drop notifications

enroll-email Data type: CHARACTER
Format: x(128)
Help: Email address to send for enrollments to this building

enrolled-count Data type: INTEGER
Format: zzzz9 (Initial Value: 0)
Description: Number of students currently enrolled

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

grad-requirement-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Default Graduation Requirement for this building, if any

has-houses Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Does the building have houses?

msds-home-room Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Treat home rooms in this building as a course for MSDS purpo

period-desc Data type: CHARACTER
Format: x(16) (Initial Value: Period)
Help: Name of periods/classes for this building (period, hour, etc

personnel-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Building Principal (if applicable)

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

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

request-cnt Data type: INTEGER (Extent: 10)
Format: zzzz9 (Initial Value: 0)
Help: Total number of requests at this priority

request-default Data type: LOGICAL (Extent: 10)
Format: Yes/No (Initial Value: No)
Help: Is this the default priority for courses/requests?

request-fte Data type: DECIMAL (Extent: 10, Decimals: 3)
Format: zzz9.999 (Initial Value: 0)
Help: Total request FTE for this priority

request-priority Data type: CHARACTER (Extent: 10)
Format: x(10)
Help: Course/Request Priorities (#1 is most important, #10 least)

request-required Data type: LOGICAL (Extent: 10)
Format: Yes/No (Initial Value: No)
Help: Courses/Requests with this priority will always be scheduled

request-total-cnt Data type: INTEGER
Format: zzzzz9 (Initial Value: 0)
Help: Total number of requests for this building

request-total-fte Data type: DECIMAL (Decimals: 3)
Format: zzzzz9.999 (Initial Value: 0)
Help: Total FTE of requests for this building

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

state-bldg-code Data type: CHARACTER
Format: x(8)
Help: State Assigned building code

title1-indicator Data type: CHARACTER
Format: x(8)
Help: Enter the title 1 indicator

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: Record last updated at

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

web-motd Data type: CHARACTER
Format: x(50)
Help: Message of the day, if any, for display via web

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