VALID GRADUATION FILE_PATCH_NUMBER_11_VERSION_NUMBER_3.1.5
TBGRADUATION
#2006060511083511220060605110835
Create table #2006060511083511220060605110835([UNIT_RECNO] decimal (28,0) null default 0,[RACE_CODE] decimal (28,0) null default 0,[GENDER_CODE] decimal (28,0) null default 0,[RESERVE_GUARD_BRANCH_CODE] decimal (28,0) null default 0,[GRADUATION_CODE] decimal (28,0) null default 0,[POST_GRADUATION_CODE] decimal (28,0) null default 0,[OTHER_PLANS] varchar(79) Null Default '',[MS_COURSES_COMPLETED] decimal (28,0) null default 0,[SCHOLARSHIPS] decimal (28,0) null default 0,[SCHOLARSHIPS_VALUE] decimal (28,0) null default 0,[SUBMITTED] decimal (28,0) null default 0,[NJMIS_IMPORTED] decimal (28,0) null default 0)
|DATA|
186|5|1|0|41|0||4|0|0|0|0|
186|5|2|0|1|0||4|0|0|0|0|
186|5|1|0|39|0||4|0|0|0|0|
186|5|1|0|1|0||4|0|0|0|0|
186|5|1|0|4|0||4|0|0|0|0|
186|5|2|0|36|0||4|1|50000|0|0|
186|5|1|3|36|0||4|0|0|0|0|
186|5|2|0|42|0||4|0|0|0|0|
186|5|1|0|36|0||4|0|0|0|0|
186|5|1|0|1|0||4|0|0|0|0|
186|5|1|0|41|0||4|0|0|0|0|
186|5|1|0|41|0||3|0|0|0|0|
186|5|2|0|36|0||4|1|10000|0|0|
186|5|1|0|41|0||4|0|0|0|0|
186|5|1|0|1|0||4|0|0|0|0|
|END DATA|
TBGRADUATIONUNIT
#2006060511083521220060605110835
Create table #2006060511083521220060605110835([UNIT_RECNO] decimal (28,0) null default 0,[SCHOOL_YEAR] varchar(4) Null Default '',[SCHOLARSHIPS] decimal (28,0) null default 0,[SCHOLARSHIPS_VALUE] decimal (28,0) null default 0,[COMMUNITY_SERVICE] decimal (28,0) null default 0,[DROPOUTS_SCHOOL] decimal (28,0) null default 0,[DROPOUTS_UNIT] decimal (28,0) null default 0,[SUSPENSIONS_SCHOOL] decimal (28,0) null default 0,[SUSPENSIONS_UNIT] decimal (28,0) null default 0,[ATTENDANCE_SCHOOL] decimal (28,0) null default 0,[ATTENDANCE_UNIT] decimal (28,0) null default 0,[GPA_SCHOOL] decimal (28,0) null default 0,[GPA_UNIT] decimal (28,0) null default 0,[SAT_SCHOOL] decimal (28,0) null default 0,[SAT_UNIT] decimal (28,0) null default 0,[ACT_SCHOOL] decimal (28,0) null default 0,[ACT_UNIT] decimal (28,0) null default 0,[CONT_ED_4_YEAR] decimal (28,0) null default 0,[CONT_ED_2_YEAR] decimal (28,0) null default 0,[CONT_ED_VOCATIONAL] decimal (28,0) null default 0)
|DATA|
186|2005|2|60000|230|0|0|0|0|93|96|0|0|0|0|0|0|0|0|0|
|END DATA|
TBPOSTGRADUATION
#2006060511083531220060605110835
Create table #2006060511083531220060605110835([UNIT_RECNO] decimal (28,0) null default 0,[PROGRAM] varchar(25) Null Default '',[USAF] decimal (28,0) null default 0,[AIR] decimal (28,0) null default 0,[USA] decimal (28,0) null default 0,[USCG] decimal (28,0) null default 0,[USMC] decimal (28,0) null default 0,[NAT] decimal (28,0) null default 0,[USN] decimal (28,0) null default 0,[MMAR] decimal (28,0) null default 0,[MARI] decimal (28,0) null default 0,[SEQUENCE] decimal (28,0) null default 0)
|DATA|
186|ENLISTED|0|0|0|0|0|0|0|0|0|1|
186|DELAYED ENTRY PROGRAM|0|0|0|0|0|0|0|0|0|2|
186|ENLISTED ADVANCE PROGRAM|0|0|0|0|0|0|0|0|0|3|
186|ACADEMY APPOINTMENTS|0|0|0|0|0|0|0|0|0|4|
186|ROTC SCHOLARSHIPS|0|0|0|0|0|0|0|0|0|5|
186|ROTC NON-SCHOLARSHIPS|0|0|0|0|0|0|0|0|0|6|
186|BOOST|0|0|0|0|0|0|0|0|0|7|
|END DATA|