Definition of table stu-base
Student Base record , Table Dump Name stu-base

Alphabetical Field Summary

  • bilingual-flag: (LOGC) Is the student bilingual?
  • birth-date: (DATE) Students Birthdate
  • carrier-route-id: (INTG) Carrier route for this address
  • cell-phone: (CHAR) Cellular Phone number (if any)
  • cell-provider: (CHAR) Name of cell phone provider to send messages through, or "N/
  • 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-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
  • family-id: (INTG) Family code for student
  • first-name: (CHAR) First Name
  • gender: (LOGC) Gender or student, Male or Female
  • generation-name: (CHAR) Generation (e.g. Jr, III, etc)
  • home-language-id: (INTG) Home Language ID
  • ignore-student: (LOGC) Set only for proto-type student records - always ignored!
  • immigrant-flag: (LOGC) Is the student an immigrant?
  • last-name: (CHAR) Last Name
  • middle-name: (CHAR) Middle Name
  • migrant-flag: (LOGC) Is the student a migrant?
  • nickname: (CHAR) Nickname or preferred name
  • stu-city: (CHAR) Students City of residence
  • 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 # [DEFINE KEY]
  • 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/Lot/Box (optional)
  • stu-street-num: (CHAR) Students Street Address number
  • stu-UIC: (CHAR) Student UIC, as assigned by the state
  • stu-zip: (CHAR) Student residence zip/postal code
  • transcript-needs-calc: (LOGC) Yes if transcripts data needs to be (re)calculated
  • unlisted-addr: (LOGC) Yes if student's address is considered 'unlisted'
  • unlisted-phone: (LOGC) Yes if the student's phone # is considered 'unlisted'
  • 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

    Alphabetical Index Summary

  • carrier-route: carrier-route-id, stu-seq
  • extern-guid: extern-guid
  • family-id: family-id
  • first-name: first-name
  • first-name-word: first-name
  • last-name: last-name
  • last-name-word: last-name
  • mid-name-word: middle-name
  • middle-name: middle-name
  • nickname: nickname
  • stu-address: stu-street, stu-street-num, stu-street-apt, stu-zip, stu-seq
  • stu-id: stu-id
  • stu-ignore: ignore-student, stu-id, stu-seq
  • stu-name: stu-name
  • stu-seq: (UNIQUE, PRIMARY) stu-seq
  • stu-ssn: stu-ssn
  • stu-uic: stu-UIC
  • suffix-name: generation-name
  • suffix-name-word: generation-name
  • uic-word: stu-UIC

    Alphabetical Trigger Summary

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

    Other tables who reference stu-base

  • imported-item -
  • imported-record - (no description available)
  • scan-form-line - Scan Form Line info
  • scan-form-sheet - Scan Form Sheets
  • 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-contact - Student Contacts file
  • stu-contact-mailing - Student Contact Mailing definitions. For stu-contact records
  • stu-counseling - (no description available)
  • stu-course-atnd - Course Based student attendance
  • stu-credential - (no description available)
  • stu-credential-area - (no description available)
  • stu-credential-assessment - (no description available)
  • stu-credential-outcome - (no description available)
  • stu-credential-standard - (no description available)
  • stu-credential-year - (no description available)
  • stu-daily-atnd - Daily student attendance entries
  • stu-edp - (no description available)
  • stu-edp-course - (no description available)
  • 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-medical - Student Medical information
  • stu-note - Student Notes file
  • 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-request-master - Student Request Master Controls
  • stu-schedule - Student Schedule
  • stu-site - Site Specific Student data file
  • stu-state-item - Describes a students state record entry
  • stu-title1-service - Student Title 1 Service
  • 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

    Tables stu-base references

  • carrier-route - Carrier Route definitions
  • econ-disadvantaged - Economically disadvantaged codes
  • ethnic-code - Ethnic Codes files
  • home-language - Home Language Identifiers
  • stu-assign - (no description available)
  • stu-request-master - Student Request Master Controls
  • stu-year - One record for each year a student exists in the district

    Detailed Alphabetical Field Listing
    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

    carrier-route-id Data type: INTEGER
    Format: zzzzzzzzzz9
    Description: Carrier route for this address
    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/

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

    family-id Data type: INTEGER
    Format: zzzzz9 (Initial Value: 0)
    Help: Family code for student
    Attributes: Index Component

    first-name Data type: CHARACTER
    Format: x(24)
    Description: First Name
    Attributes: Index Component

    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)
    Attributes: Index Component

    home-language-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Home Language ID

    ignore-student Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Set only for proto-type student records - always ignored!
    Attributes: Index Component

    immigrant-flag Data type: LOGICAL
    Format: yes/no (Initial Value: no)
    Help: Is the student an immigrant?

    last-name Data type: CHARACTER
    Format: x(24)
    Description: Last Name
    Attributes: Index Component

    middle-name Data type: CHARACTER
    Format: x(24)
    Description: Middle Name
    Attributes: Index Component

    migrant-flag Data type: LOGICAL
    Format: yes/no (Initial Value: no)
    Description: Is the student a migrant?

    nickname Data type: CHARACTER
    Format: x(32)
    Description: Nickname or preferred name
    Attributes: Index Component

    stu-city Data type: CHARACTER
    Format: x(25)
    Help: Students City of residence

    stu-id Data type: CHARACTER
    Format: x(9)
    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
    Attributes: Index Component

    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 # [DEFINE KEY]
    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)
    Attributes: Index Component

    stu-street-apt Data type: CHARACTER
    Format: x(14)
    Help: Students Apartment/Lot/Box (optional)
    Attributes: Index Component

    stu-street-num Data type: CHARACTER
    Format: x(8)
    Help: Students Street Address number
    Attributes: Index Component

    stu-UIC Data type: CHARACTER
    Format: x(10)
    Help: Student UIC, as assigned by the state
    Attributes: Index Component

    stu-zip Data type: CHARACTER
    Format: xxxxx-xxxx
    Help: Student residence zip/postal code
    Attributes: Index Component

    transcript-needs-calc Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes if transcripts data needs to be (re)calculated

    unlisted-addr Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if student's address is considered 'unlisted'

    unlisted-phone Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if the student's phone # is considered 'unlisted'

    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

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