Definition of table stu-history
Student Activity History , Table Dump Name stu-hist

Alphabetical Field Summary

  • at-risk-flag: (LOGC) Is the student at risk of failing?
  • atnd-eligibility-id: (INTG) Attendance Eligibility ID
  • bilingual-flag: (LOGC) Is the student bilingual?
  • birth-date: (DATE) Students Birthdate
  • bldg-id: (INTG) Building student is now assigned to
  • cell-phone: (CHAR) Cellular Phone number (if any)
  • cell-provider: (CHAR) Name of cell phone provider to send messages through, or "N/
  • comments: (CHAR) Comments for this historical entry
  • 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
  • economically-disadvantaged-id: (INTG) Economically disadvantaged ID
  • email-addr: (CHAR) Email address, if any
  • email-direct-connect: (LOGC) 'Yes' to send direct connect messages to this email address
  • english-proficiency-id: (INTG) Limited English Proficiency ID
  • english-second-language-flag: (LOGC) Does the student speak english as a second language?
  • ethnic-code-id: (INTG) Ethnicity of this student
  • extern-guid: (CHAR) External Global Unique ID for this record
  • first-name: (CHAR) First Name
  • gender: (LOGC) Gender or student, Male or Female
  • generation-name: (CHAR) Generation (e.g. Jr, III, etc)
  • gifted-talented-flag: (LOGC) Is this student gifted/talented?
  • grade-id: (INTG) Grade is student is now assigned to
  • history-code-id: (INTG) History code ID identifying the reason for this entry
  • history-date: (DATE) Effective date of this history entry
  • history-seq: (INTG) Internally assigned history sequence value [DEFINE KEY]
  • home-language-id: (INTG) Home Language ID
  • house-id: (INTG) House (if any) this student is now asigned to
  • immigrant-flag: (LOGC) Is the student an immigrant?
  • instruction-setting-id: (INTG) Instructional Setting ID
  • last-name: (CHAR) Last Name
  • middle-name: (CHAR) Middle Name
  • migrant-flag: (LOGC) Is the student a migrant?
  • misc-fld-data: (CHAR) Miscellaneous field data/contents at history change
  • misc-fld-name: (CHAR) Name of the miscellaneous field that changed
  • nickname: (CHAR) Nickname or preferred name
  • personnel-id: (INTG) Counselor this student reports to
  • primary-key: (INTG) Unique, Primary key for record
  • room-id: (INTG) Home room this student is currently reporting to
  • school-year-id: (INTG) School year for this record
  • sped-code-id: (INTG) Special Ed Code ID
  • sped-fte: (DECM) Special Education FTE of student
  • status-code-id: (INTG) Student Status Code
  • stu-city: (CHAR) Students City of residence
  • stu-fte: (DECM) Student's FTE equivilency
  • stu-id: (CHAR) Students assigned ID #
  • stu-is-hisp: (LOGC) (no description available)
  • stu-name: (CHAR) Name of student, Last name first
  • stu-phone: (CHAR) Student's home phone #
  • stu-seq: (INTG) Internally assigned Student Sequence #
  • stu-ssn: (CHAR) Students SSN (if available)
  • stu-state: (CHAR) Students State of residency
  • stu-street: (CHAR) Steet of students address (do not include # or apartment)
  • stu-street-apt: (CHAR) Students Apartment # (if any)
  • stu-street-num: (CHAR) Students Street Address number
  • stu-zip: (CHAR) Student residence zip/postal code
  • teacher-of-record-id: (INTG) Internally Assigned ID
  • 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
  • vocational-classification-id: (INTG) Vocational classification ID

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • grade-id: school-year-id, bldg-id, grade-id
  • history-by-bldg: school-year-id, bldg-id, history-date, history-seq
  • history-by-code: school-year-id, history-code-id, history-date, history-seq
  • history-by-date: school-year-id, history-date, history-seq
  • house-id: school-year-id, bldg-id, house-id
  • lister-history: stu-seq, school-year-id, -history-date, -history-seq
  • personnel-id: school-year-id, personnel-id
  • room-id: school-year-id, bldg-id, room-id
  • sped-code-id: sped-code-id
  • status-code: school-year-id, status-code-id
  • stu-hist-by-bldg: stu-seq, school-year-id, bldg-id, history-date, history-seq
  • stu-hist-by-code: stu-seq, school-year-id, history-code-id, history-date, history-seq
  • stu-hist-by-date: stu-seq, school-year-id, history-date, history-seq
  • stu-history: (PRIMARY) stu-seq, history-seq
  • stu-id: stu-id
  • stu-ssn: stu-ssn

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-sth.p (SOURCE NOT AVAILABLE)
  • DELETE: Overridable, Procedure is tr-d-sth.p (SOURCE NOT AVAILABLE)
  • REPLICATION-CREATE: Procedure is rp-c-sth.p (SOURCE NOT AVAILABLE)
  • REPLICATION-DELETE: Procedure is rp-d-sth.p (SOURCE NOT AVAILABLE)
  • REPLICATION-WRITE: Procedure is rp-u-sth.p (SOURCE NOT AVAILABLE)
  • WRITE: Overridable, Procedure is tr-u-sth.p (SOURCE NOT AVAILABLE)

    Tables stu-history references

  • atnd-eligibility - Attendance Eligibility Codes
  • building - One record for each building, for each scheduling version, f
  • econ-disadvantaged - Economically disadvantaged codes
  • email-info - (no description available)
  • english-proficiency - English Proficiency Codes
  • ethnic-code - Ethnic Codes files
  • grade-catalog - Grades Catalog
  • grading-setup - Grading setup controls building level setup/policy issues wi
  • history-code - Student History Activity Codes
  • home-language - Home Language Identifiers
  • house - Houses for buildings
  • instruction-setting - Instruction settings for students and courses
  • personnel - Schools District personnel
  • promotion-path-grade - Promotion Grade/Bldg list for promotion paths
  • room-catalog - Rooms catalog, within a building
  • school-year - School year file
  • sped-code - Special Ed Codes
  • spm-prof - SPM Profile/Base record. Only 1 per system!
  • status-code - Student Status Codes
  • stu-assign - (no description available)
  • stu-base - Student Base record
  • stu-request-master - Student Request Master Controls
  • 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-grade - User Grade level restriction
  • user-personnel - User Personnel level restrictions
  • vocational-classification - Vocational Classification codes


    Detailed Alphabetical Field Listing
    at-risk-flag Data type: LOGICAL
    Format: yes/no (Initial Value: no)
    Help: Is the student at risk of failing?

    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