Alphabetical Field Summary
Alphabetical Index Summary
Alphabetical Trigger Summary
Tables stu-history references
atnd-eligibility-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Attendance Eligibility ID
bilingual-flag Data type: LOGICAL
Format: yes/no (Initial Value: no)
Help: Is the student bilingual?
birth-date Data type: DATE
Format: 99/99/9999
Help: Students Birthdate
bldg-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Building student is now 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/
comments Data type: CHARACTER
Format: x(68)
Help: Comments for this historical entry
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
economically-disadvantaged-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Economically disadvantaged ID
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: Limited English Proficiency ID
english-second-language-flag Data type: LOGICAL
Format: yes/no (Initial Value: no)
Help: Does the student speak english as a second language?
ethnic-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Ethnicity of this student
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
gender Data type: LOGICAL
Format: Male/Female (Initial Value: no)
Help: Gender or student, Male or Female
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?
grade-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Grade is student is now assigned to
Attributes: Index Component
history-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: History code ID identifying the reason for this entry
Attributes: Index Component
history-date Data type: DATE
Format: 99/99/9999
Help: Effective date of this history entry
Attributes: Index Component
history-seq Data type: INTEGER
Format: zzzzzzzzz9
Description: Internally assigned history sequence value [DEFINE KEY]
Attributes: Index Component
home-language-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Home Language ID
house-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: House (if any) this student is now asigned to
Attributes: Index Component
immigrant-flag Data type: LOGICAL
Format: yes/no (Initial Value: no)
Help: Is the student an immigrant?
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
migrant-flag Data type: LOGICAL
Format: yes/no (Initial Value: no)
Description: Is the student a migrant?
misc-fld-data Data type: CHARACTER
Format: x(32)
Help: Miscellaneous field data/contents at history change
misc-fld-name Data type: CHARACTER
Format: x(16)
Help: Name of the miscellaneous field that changed
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
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
Attributes: Index Component
sped-fte Data type: DECIMAL (Decimals: 3)
Format: 9.999
Help: Special Education FTE of student
status-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Student Status Code
Attributes: Index Component
stu-city Data type: CHARACTER
Format: x(25)
Help: Students City of residence
stu-fte Data type: DECIMAL (Decimals: 3)
Format: 9.999
Help: Student's FTE equivilency
stu-id Data type: CHARACTER
Format: 9(6)
Help: Students assigned ID #
Attributes: Index Component
stu-is-hisp Data type: LOGICAL
Format: Yes/No
stu-name Data type: CHARACTER
Format: x(32)
Help: Name of student, Last name first
stu-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx
Help: Student's home phone #
stu-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Student Sequence #
Attributes: Index Component
stu-ssn Data type: CHARACTER
Format: xxx-xx-xxxx
Help: Students SSN (if available)
Attributes: Index Component
stu-state Data type: CHARACTER
Format: !!
Help: Students State of residency
stu-street Data type: CHARACTER
Format: x(20)
Help: Steet of students address (do not include # or apartment)
stu-street-apt Data type: CHARACTER
Format: x(8)
Help: Students Apartment # (if any)
stu-street-num Data type: CHARACTER
Format: x(8)
Help: Students Street Address number
stu-zip Data type: CHARACTER
Format: xxxxx-xxxx
Help: Student residence zip/postal code
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