Definition of table Note

Student Notes , Table Dump Name res-0009

Alphabetical Field Summary

birth-date: (DATE) Students Birthdate

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

counselor: (CHAR) Name of this person (last name first)

current-year: (LOGC) (no description available)

dw-valid-from: (DATE) (no description available)

dw-valid-to: (DATE) (no description available)

dw-version: (INTG) (no description available)

enrolled: (LOGC) Yes if this status code means the student is enrolled

ethnic-code: (CHAR) Ethnic code name

gender: (LOGC) Gender or student, Male or Female

grade: (CHAR) Name of this Grade (i.e. K, 1, 10, 12, etc)

home-room: (CHAR) Room # or name

house-code: (CHAR) Short name for this house

house-description: (CHAR) Description of the house

note-code: (CHAR) Name of note code

note-code-date-label: (CHAR) Label for this notes date field

note-code-description: (CHAR) Description of the note code

note-code-flag-label: (CHAR) Label for this notes Yes/No Flag field

note-code-group-code: (CHAR) Name of note group

note-code-group-description: (CHAR) Description of the note group

note-code-table-label: (CHAR) Label for the table field

note-comments: (CHAR) Comments for this note

note-cre-date: (DATE) Date record was created

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

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

note-date: (DATE) Date to attach to this student's note

note-end-date: (DATE) Ending Date to attach to this student's note

note-flag: (LOGC) Yes or No for this student's note

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

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

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

promotion-path-name: (CHAR) Name of this promotion path

school-year-name: (CHAR) Name for school year (i.e. 1993/94, etc)

sped-code: (CHAR) Name of student special education code

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

state-ethnic-code: (CHAR) State Assigned ethnic code

status-code: (CHAR) Name of student status code

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

stu-id: (CHAR) Students assigned ID #

stu-name: (CHAR) Name of student, Last name first

stu-ssn: (CHAR) Students SSN (if available)

table-code: (CHAR) Name of this table code entry

table-code-description: (CHAR) Description of this table code entry

table-code-level-data[10]: (CHAR) Enter the level related data

table-name: (CHAR) Name of this table

table-name-description: (CHAR) Description of this table

year-of-grad: (INTG) Expected year of graduation for a student in this grade

Alphabetical Index Summary

bldg-code: (PRIMARY) bldg-code

counselor: counselor

ethnic-code: ethnic-code

grade: grade

home-room: home-room

house-code: house-code

house-description: house-description

note-code: note-code

note-code-description: note-code-description

note-code-group-code: note-code-group-code

note-code-group-description: note-code-group-description

note-date: note-date

promotion-path-name: promotion-path-name

school-year-name: school-year-name

sped-code: sped-code

status-code: status-code

stu-id: stu-id

stu-name: stu-name

stu-ssn: stu-ssn

table-code: table-code

table-code-description: table-code-description

table-name: table-name

table-name-description: table-name-description

year-of-grad: year-of-grad

Tables Note references

Contact - Student Contacts

Course_Request - Course Request Record

Daily_Attendance - Daily Attendance

GPA_Rank - Student GPAs

Honor_Roll - Student Awarded Honor Rolls

Medical_Record - Medical Notes

Report_Card - Report Card Data

Scheduled_Course - Scheduled Student Course

Student - Basic Student Data

Transcript_Course - Transcript Course

Transcript_Year - Student Transcript Year data

Detailed Alphabetical Field Listing
birth-date Data type: DATE
Format: 99/99/9999
Description: Students Birthdate

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

counselor Data type: CHARACTER
Format: x(32)
Description: Name of this person (last name first)
Attributes: Index Component

current-year Data type: LOGICAL
Format: yes/no (Initial Value: no)

dw-valid-from Data type: DATE
Format: 99/99/9999

dw-valid-to Data type: DATE
Format: 99/99/9999

dw-version Data type: INTEGER
Format: zzzzzzzzzzz9 (Initial Value: 0)

enrolled Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes if this status code means the student is enrolled

ethnic-code Data type: CHARACTER
Format: x(8)
Description: Ethnic code name
Attributes: Index Component

gender Data type: LOGICAL
Format: Male/Female (Initial Value: no)
Description: Gender or student, Male or Female

grade Data type: CHARACTER
Format: x(3)
Description: Name of this Grade (i.e. K, 1, 10, 12, etc)
Attributes: Index Component

home-room Data type: CHARACTER
Format: x(6)
Description: Room # or name
Attributes: Index Component

house-code Data type: CHARACTER
Format: x(8)
Description: Short name for this house
Attributes: Index Component

house-description Data type: CHARACTER
Format: x(28)
Description: Description of the house
Attributes: Index Component

note-code Data type: CHARACTER
Format: x(8)
Description: Name of note code
Attributes: Index Component

note-code-date-label Data type: CHARACTER
Format: x(16)
Description: Label for this notes date field

note-code-description Data type: CHARACTER
Format: x(28)
Description: Description of the note code
Attributes: Index Component

note-code-flag-label Data type: CHARACTER
Format: x(16)
Description: Label for this notes Yes/No Flag field

note-code-group-code Data type: CHARACTER
Format: x(8)
Description: Name of note group
Attributes: Index Component

note-code-group-description Data type: CHARACTER
Format: x(28)
Description: Description of the note group
Attributes: Index Component

note-code-table-label Data type: CHARACTER
Format: x(16)
Description: Label for the table field

note-comments Data type: CHARACTER
Format: x(68)
Description: Comments for this note

note-cre-date Data type: DATE
Format: 99/99/9999
Description: Date record was created

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

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

note-date Data type: DATE
Format: 99/99/9999
Description: Date to attach to this student's note
Attributes: Index Component

note-end-date Data type: DATE
Format: 99/99/9999
Description: Ending Date to attach to this student's note

note-flag Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes or No for this student's note

note-upd-date Data type: DATE
Format: 99/99/9999
Description: Date record was last updated

note-upd-time Data type: CHARACTER
Format: x(8)
Description: Time this record was last updated at

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

promotion-path-name Data type: CHARACTER
Format: x(8)
Description: Name of this promotion path
Attributes: Index Component

school-year-name Data type: CHARACTER
Format: x(9)
Description: Name for school year (i.e. 1993/94, etc)
Attributes: Index Component

sped-code Data type: CHARACTER
Format: x(8)
Description: Name of student special education code
Attributes: Index Component

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

state-ethnic-code Data type: CHARACTER
Format: x(8)
Description: State Assigned ethnic code

status-code Data type: CHARACTER
Format: x(8)
Description: Name of student status code
Attributes: Index Component

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

stu-id Data type: CHARACTER
Format: x(9)
Description: Students assigned ID #
Attributes: Index Component

stu-name Data type: CHARACTER
Format: x(32)
Description: Name of student, Last name first
Attributes: Index Component

stu-ssn Data type: CHARACTER
Format: xxx-xx-xxxx
Description: Students SSN (if available)
Attributes: Index Component

table-code Data type: CHARACTER
Format: x(8)
Description: Name of this table code entry
Attributes: Index Component

table-code-description Data type: CHARACTER
Format: x(28)
Description: Description of this table code entry
Attributes: Index Component

table-code-level-data Data type: CHARACTER (Extent: 10)
Format: x(28)
Description: Enter the level related data

table-name Data type: CHARACTER
Format: x(8)
Description: Name of this table
Attributes: Index Component

table-name-description Data type: CHARACTER
Format: x(28)
Description: Description of this table
Attributes: Index Component

year-of-grad Data type: INTEGER
Format: 9999 (Initial Value: 0)
Description: Expected year of graduation for a student in this grade
Attributes: Index Component

Created on 02/08/2008 by DBHTML V1.2