TEAM Database Viewer


school
MassDOE

Field Name Type Format Extent Default Description
DOE001 character X(32) 1   Was student.doe-misc[35] with labels from profile.doe-misc-names Labels are now incorporated here
DOE002 character X(10) 1   Was student.doe-misc[35] with labels from profile.doe-misc-names Labels are now incorporated here
DOE003 character X(32) 1   Was student.doe-misc[35] with labels from profile.doe-misc-names Labels are now incorporated here
DOE004 character X(32) 1    
DOE005 character X(50) 1    
DOE006 date 99/99/9999 1    
DOE007 character X(3) 1 D10 Fixed value "D10"
DOE008 character X(50) 1    
DOE009 character X(1) 1 F Must M or F, but must also be an alphanumeris field, cannt be set as a logical.
DOE010 character X(3) 1   Must be 01, 02, 03, 05, 99 or 555 >From
DOE011 character X(2) 1   Must be 01, 02 or 03
DOE012 character X(2) 1   Must be 01, 02, 03, 04, 05, 06, 07 or 08
DOE013 character X(2) 1   Must be 00, 01, 02, 03, 04, 05, 06, 07, 08, 09 or 10
DOE014 character X(3) 1    
DOE015 character X(6) 1    
DOE016 character X(2) 1   Must be 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, KF, KP, PG or PK
DOE017 integer 999 1 0  
DOE018 integer 999 1 0  
DOE019 character X(3) 1   Must be 00, 01 or 555
DOE020 character X(3) 1   Must be 00, 01 or 555
DOE021 character X(3) 1   Must be 00, 01 or 555
DOE022 character X(3) 1   Must be 00, 01 or 555
DOE023 character X(3) 1    
DOE024 character X(3) 1    
DOE025 character X(3) 1   Must be 00, 01 or 555
DOE026 character X(3) 1   Must be 00, 01, 02, 03, 04, 05 or 555
DOE027 character X(3) 1   Must be 01, 02, 03, 04, 500 or 555
DOE028 character X(3) 1    
DOE029 integer 999 1 0 Must be 0-100 or 500 or 555
DOE030 integer 999 1 0 Must be 0-100 or 500 or 555
DOE031 decimal >>9.9 1 0 Must be 0 - 20.0 or 500 or 555
DOE032 character X(3) 1   Must be 01, 02, 500 or 555
DOE033 character X(3) 1   Must be 01, 02, 03, 04, 05, 06, 07, 08, 09, 500 or 555
DOE034 character X(2) 1   Must be 00, 01, 10, 20, 30, 40, 4i, 50, 60, 70, 80 or 90
DOE035 character X(3) 1   Must be 00, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 13, 14 or 555
StudentID integer ZZZZZZZ9 1 0 was student.stu-id Was six digits. Should be expanded to 6 or 8 digits Must be both system generated or user-defined without duplication within the district.


Primary Unique pukey StudentID


Last updated 09/22/2001 2:00:01 am
* Regenerate Schema Pages with /appl/script/htmldict.ksh