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

medical-code-comments Data type: CHARACTER
Format: x(68)
Description: Comments for/about this code

medical-code-date-cnt Data type: INTEGER
Format: z9 (Initial Value: 0)
Description: Number of dates for tests/vaccinations (0-10)

medical-code-date-label Data type: CHARACTER (Extent: 20)
Format: x(12)
Description: Label for this test/vaccination date

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

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

medical-code-status-list Data type: CHARACTER
Format: x(40)
Description: List of Status codes for this medical code

medical-code-type Data type: CHARACTER
Format: x(12)
Description: Type for this code (Vaccination, Test or Info)

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

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

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

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

medical-date-comment Data type: CHARACTER (Extent: 10)
Format: x(32)
Description: Comments for this vaccination/test

medical-medical-date Data type: DATE (Extent: 10)
Format: 99/99/9999
Description: Date of this test/vaccination

medical-medical-status Data type: CHARACTER
Format: x(10)
Description: Status of this entry

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

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

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

medical-waived Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Yes if student waived vaccination/tests

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

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