Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
9287 lines (9241 sloc) 269 KB
CREATE TABLE sf1_01 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P001001 INTEGER NOT NULL
);
CREATE TABLE sf1_02 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P002001 INTEGER NOT NULL,
P002002 INTEGER NOT NULL,
P002003 INTEGER NOT NULL,
P002004 INTEGER NOT NULL,
P002005 INTEGER NOT NULL,
P002006 INTEGER NOT NULL
);
CREATE TABLE sf1_03 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P003001 INTEGER NOT NULL,
P003002 INTEGER NOT NULL,
P003003 INTEGER NOT NULL,
P003004 INTEGER NOT NULL,
P003005 INTEGER NOT NULL,
P003006 INTEGER NOT NULL,
P003007 INTEGER NOT NULL,
P003008 INTEGER NOT NULL,
P004001 INTEGER NOT NULL,
P004002 INTEGER NOT NULL,
P004003 INTEGER NOT NULL,
P005001 INTEGER NOT NULL,
P005002 INTEGER NOT NULL,
P005003 INTEGER NOT NULL,
P005004 INTEGER NOT NULL,
P005005 INTEGER NOT NULL,
P005006 INTEGER NOT NULL,
P005007 INTEGER NOT NULL,
P005008 INTEGER NOT NULL,
P005009 INTEGER NOT NULL,
P005010 INTEGER NOT NULL,
P005011 INTEGER NOT NULL,
P005012 INTEGER NOT NULL,
P005013 INTEGER NOT NULL,
P005014 INTEGER NOT NULL,
P005015 INTEGER NOT NULL,
P005016 INTEGER NOT NULL,
P005017 INTEGER NOT NULL,
P006001 INTEGER NOT NULL,
P006002 INTEGER NOT NULL,
P006003 INTEGER NOT NULL,
P006004 INTEGER NOT NULL,
P006005 INTEGER NOT NULL,
P006006 INTEGER NOT NULL,
P006007 INTEGER NOT NULL,
P007001 INTEGER NOT NULL,
P007002 INTEGER NOT NULL,
P007003 INTEGER NOT NULL,
P007004 INTEGER NOT NULL,
P007005 INTEGER NOT NULL,
P007006 INTEGER NOT NULL,
P007007 INTEGER NOT NULL,
P007008 INTEGER NOT NULL,
P007009 INTEGER NOT NULL,
P007010 INTEGER NOT NULL,
P007011 INTEGER NOT NULL,
P007012 INTEGER NOT NULL,
P007013 INTEGER NOT NULL,
P007014 INTEGER NOT NULL,
P007015 INTEGER NOT NULL,
P008001 INTEGER NOT NULL,
P008002 INTEGER NOT NULL,
P008003 INTEGER NOT NULL,
P008004 INTEGER NOT NULL,
P008005 INTEGER NOT NULL,
P008006 INTEGER NOT NULL,
P008007 INTEGER NOT NULL,
P008008 INTEGER NOT NULL,
P008009 INTEGER NOT NULL,
P008010 INTEGER NOT NULL,
P008011 INTEGER NOT NULL,
P008012 INTEGER NOT NULL,
P008013 INTEGER NOT NULL,
P008014 INTEGER NOT NULL,
P008015 INTEGER NOT NULL,
P008016 INTEGER NOT NULL,
P008017 INTEGER NOT NULL,
P008018 INTEGER NOT NULL,
P008019 INTEGER NOT NULL,
P008020 INTEGER NOT NULL,
P008021 INTEGER NOT NULL,
P008022 INTEGER NOT NULL,
P008023 INTEGER NOT NULL,
P008024 INTEGER NOT NULL,
P008025 INTEGER NOT NULL,
P008026 INTEGER NOT NULL,
P008027 INTEGER NOT NULL,
P008028 INTEGER NOT NULL,
P008029 INTEGER NOT NULL,
P008030 INTEGER NOT NULL,
P008031 INTEGER NOT NULL,
P008032 INTEGER NOT NULL,
P008033 INTEGER NOT NULL,
P008034 INTEGER NOT NULL,
P008035 INTEGER NOT NULL,
P008036 INTEGER NOT NULL,
P008037 INTEGER NOT NULL,
P008038 INTEGER NOT NULL,
P008039 INTEGER NOT NULL,
P008040 INTEGER NOT NULL,
P008041 INTEGER NOT NULL,
P008042 INTEGER NOT NULL,
P008043 INTEGER NOT NULL,
P008044 INTEGER NOT NULL,
P008045 INTEGER NOT NULL,
P008046 INTEGER NOT NULL,
P008047 INTEGER NOT NULL,
P008048 INTEGER NOT NULL,
P008049 INTEGER NOT NULL,
P008050 INTEGER NOT NULL,
P008051 INTEGER NOT NULL,
P008052 INTEGER NOT NULL,
P008053 INTEGER NOT NULL,
P008054 INTEGER NOT NULL,
P008055 INTEGER NOT NULL,
P008056 INTEGER NOT NULL,
P008057 INTEGER NOT NULL,
P008058 INTEGER NOT NULL,
P008059 INTEGER NOT NULL,
P008060 INTEGER NOT NULL,
P008061 INTEGER NOT NULL,
P008062 INTEGER NOT NULL,
P008063 INTEGER NOT NULL,
P008064 INTEGER NOT NULL,
P008065 INTEGER NOT NULL,
P008066 INTEGER NOT NULL,
P008067 INTEGER NOT NULL,
P008068 INTEGER NOT NULL,
P008069 INTEGER NOT NULL,
P008070 INTEGER NOT NULL,
P008071 INTEGER NOT NULL,
P009001 INTEGER NOT NULL,
P009002 INTEGER NOT NULL,
P009003 INTEGER NOT NULL,
P009004 INTEGER NOT NULL,
P009005 INTEGER NOT NULL,
P009006 INTEGER NOT NULL,
P009007 INTEGER NOT NULL,
P009008 INTEGER NOT NULL,
P009009 INTEGER NOT NULL,
P009010 INTEGER NOT NULL,
P009011 INTEGER NOT NULL,
P009012 INTEGER NOT NULL,
P009013 INTEGER NOT NULL,
P009014 INTEGER NOT NULL,
P009015 INTEGER NOT NULL,
P009016 INTEGER NOT NULL,
P009017 INTEGER NOT NULL,
P009018 INTEGER NOT NULL,
P009019 INTEGER NOT NULL,
P009020 INTEGER NOT NULL,
P009021 INTEGER NOT NULL,
P009022 INTEGER NOT NULL,
P009023 INTEGER NOT NULL,
P009024 INTEGER NOT NULL,
P009025 INTEGER NOT NULL,
P009026 INTEGER NOT NULL,
P009027 INTEGER NOT NULL,
P009028 INTEGER NOT NULL,
P009029 INTEGER NOT NULL,
P009030 INTEGER NOT NULL,
P009031 INTEGER NOT NULL,
P009032 INTEGER NOT NULL,
P009033 INTEGER NOT NULL,
P009034 INTEGER NOT NULL,
P009035 INTEGER NOT NULL,
P009036 INTEGER NOT NULL,
P009037 INTEGER NOT NULL,
P009038 INTEGER NOT NULL,
P009039 INTEGER NOT NULL,
P009040 INTEGER NOT NULL,
P009041 INTEGER NOT NULL,
P009042 INTEGER NOT NULL,
P009043 INTEGER NOT NULL,
P009044 INTEGER NOT NULL,
P009045 INTEGER NOT NULL,
P009046 INTEGER NOT NULL,
P009047 INTEGER NOT NULL,
P009048 INTEGER NOT NULL,
P009049 INTEGER NOT NULL,
P009050 INTEGER NOT NULL,
P009051 INTEGER NOT NULL,
P009052 INTEGER NOT NULL,
P009053 INTEGER NOT NULL,
P009054 INTEGER NOT NULL,
P009055 INTEGER NOT NULL,
P009056 INTEGER NOT NULL,
P009057 INTEGER NOT NULL,
P009058 INTEGER NOT NULL,
P009059 INTEGER NOT NULL,
P009060 INTEGER NOT NULL,
P009061 INTEGER NOT NULL,
P009062 INTEGER NOT NULL,
P009063 INTEGER NOT NULL,
P009064 INTEGER NOT NULL,
P009065 INTEGER NOT NULL,
P009066 INTEGER NOT NULL,
P009067 INTEGER NOT NULL,
P009068 INTEGER NOT NULL,
P009069 INTEGER NOT NULL,
P009070 INTEGER NOT NULL,
P009071 INTEGER NOT NULL,
P009072 INTEGER NOT NULL,
P009073 INTEGER NOT NULL
);
CREATE TABLE sf1_04 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P010001 INTEGER NOT NULL,
P010002 INTEGER NOT NULL,
P010003 INTEGER NOT NULL,
P010004 INTEGER NOT NULL,
P010005 INTEGER NOT NULL,
P010006 INTEGER NOT NULL,
P010007 INTEGER NOT NULL,
P010008 INTEGER NOT NULL,
P010009 INTEGER NOT NULL,
P010010 INTEGER NOT NULL,
P010011 INTEGER NOT NULL,
P010012 INTEGER NOT NULL,
P010013 INTEGER NOT NULL,
P010014 INTEGER NOT NULL,
P010015 INTEGER NOT NULL,
P010016 INTEGER NOT NULL,
P010017 INTEGER NOT NULL,
P010018 INTEGER NOT NULL,
P010019 INTEGER NOT NULL,
P010020 INTEGER NOT NULL,
P010021 INTEGER NOT NULL,
P010022 INTEGER NOT NULL,
P010023 INTEGER NOT NULL,
P010024 INTEGER NOT NULL,
P010025 INTEGER NOT NULL,
P010026 INTEGER NOT NULL,
P010027 INTEGER NOT NULL,
P010028 INTEGER NOT NULL,
P010029 INTEGER NOT NULL,
P010030 INTEGER NOT NULL,
P010031 INTEGER NOT NULL,
P010032 INTEGER NOT NULL,
P010033 INTEGER NOT NULL,
P010034 INTEGER NOT NULL,
P010035 INTEGER NOT NULL,
P010036 INTEGER NOT NULL,
P010037 INTEGER NOT NULL,
P010038 INTEGER NOT NULL,
P010039 INTEGER NOT NULL,
P010040 INTEGER NOT NULL,
P010041 INTEGER NOT NULL,
P010042 INTEGER NOT NULL,
P010043 INTEGER NOT NULL,
P010044 INTEGER NOT NULL,
P010045 INTEGER NOT NULL,
P010046 INTEGER NOT NULL,
P010047 INTEGER NOT NULL,
P010048 INTEGER NOT NULL,
P010049 INTEGER NOT NULL,
P010050 INTEGER NOT NULL,
P010051 INTEGER NOT NULL,
P010052 INTEGER NOT NULL,
P010053 INTEGER NOT NULL,
P010054 INTEGER NOT NULL,
P010055 INTEGER NOT NULL,
P010056 INTEGER NOT NULL,
P010057 INTEGER NOT NULL,
P010058 INTEGER NOT NULL,
P010059 INTEGER NOT NULL,
P010060 INTEGER NOT NULL,
P010061 INTEGER NOT NULL,
P010062 INTEGER NOT NULL,
P010063 INTEGER NOT NULL,
P010064 INTEGER NOT NULL,
P010065 INTEGER NOT NULL,
P010066 INTEGER NOT NULL,
P010067 INTEGER NOT NULL,
P010068 INTEGER NOT NULL,
P010069 INTEGER NOT NULL,
P010070 INTEGER NOT NULL,
P010071 INTEGER NOT NULL,
P011001 INTEGER NOT NULL,
P011002 INTEGER NOT NULL,
P011003 INTEGER NOT NULL,
P011004 INTEGER NOT NULL,
P011005 INTEGER NOT NULL,
P011006 INTEGER NOT NULL,
P011007 INTEGER NOT NULL,
P011008 INTEGER NOT NULL,
P011009 INTEGER NOT NULL,
P011010 INTEGER NOT NULL,
P011011 INTEGER NOT NULL,
P011012 INTEGER NOT NULL,
P011013 INTEGER NOT NULL,
P011014 INTEGER NOT NULL,
P011015 INTEGER NOT NULL,
P011016 INTEGER NOT NULL,
P011017 INTEGER NOT NULL,
P011018 INTEGER NOT NULL,
P011019 INTEGER NOT NULL,
P011020 INTEGER NOT NULL,
P011021 INTEGER NOT NULL,
P011022 INTEGER NOT NULL,
P011023 INTEGER NOT NULL,
P011024 INTEGER NOT NULL,
P011025 INTEGER NOT NULL,
P011026 INTEGER NOT NULL,
P011027 INTEGER NOT NULL,
P011028 INTEGER NOT NULL,
P011029 INTEGER NOT NULL,
P011030 INTEGER NOT NULL,
P011031 INTEGER NOT NULL,
P011032 INTEGER NOT NULL,
P011033 INTEGER NOT NULL,
P011034 INTEGER NOT NULL,
P011035 INTEGER NOT NULL,
P011036 INTEGER NOT NULL,
P011037 INTEGER NOT NULL,
P011038 INTEGER NOT NULL,
P011039 INTEGER NOT NULL,
P011040 INTEGER NOT NULL,
P011041 INTEGER NOT NULL,
P011042 INTEGER NOT NULL,
P011043 INTEGER NOT NULL,
P011044 INTEGER NOT NULL,
P011045 INTEGER NOT NULL,
P011046 INTEGER NOT NULL,
P011047 INTEGER NOT NULL,
P011048 INTEGER NOT NULL,
P011049 INTEGER NOT NULL,
P011050 INTEGER NOT NULL,
P011051 INTEGER NOT NULL,
P011052 INTEGER NOT NULL,
P011053 INTEGER NOT NULL,
P011054 INTEGER NOT NULL,
P011055 INTEGER NOT NULL,
P011056 INTEGER NOT NULL,
P011057 INTEGER NOT NULL,
P011058 INTEGER NOT NULL,
P011059 INTEGER NOT NULL,
P011060 INTEGER NOT NULL,
P011061 INTEGER NOT NULL,
P011062 INTEGER NOT NULL,
P011063 INTEGER NOT NULL,
P011064 INTEGER NOT NULL,
P011065 INTEGER NOT NULL,
P011066 INTEGER NOT NULL,
P011067 INTEGER NOT NULL,
P011068 INTEGER NOT NULL,
P011069 INTEGER NOT NULL,
P011070 INTEGER NOT NULL,
P011071 INTEGER NOT NULL,
P011072 INTEGER NOT NULL,
P011073 INTEGER NOT NULL,
P012001 INTEGER NOT NULL,
P012002 INTEGER NOT NULL,
P012003 INTEGER NOT NULL,
P012004 INTEGER NOT NULL,
P012005 INTEGER NOT NULL,
P012006 INTEGER NOT NULL,
P012007 INTEGER NOT NULL,
P012008 INTEGER NOT NULL,
P012009 INTEGER NOT NULL,
P012010 INTEGER NOT NULL,
P012011 INTEGER NOT NULL,
P012012 INTEGER NOT NULL,
P012013 INTEGER NOT NULL,
P012014 INTEGER NOT NULL,
P012015 INTEGER NOT NULL,
P012016 INTEGER NOT NULL,
P012017 INTEGER NOT NULL,
P012018 INTEGER NOT NULL,
P012019 INTEGER NOT NULL,
P012020 INTEGER NOT NULL,
P012021 INTEGER NOT NULL,
P012022 INTEGER NOT NULL,
P012023 INTEGER NOT NULL,
P012024 INTEGER NOT NULL,
P012025 INTEGER NOT NULL,
P012026 INTEGER NOT NULL,
P012027 INTEGER NOT NULL,
P012028 INTEGER NOT NULL,
P012029 INTEGER NOT NULL,
P012030 INTEGER NOT NULL,
P012031 INTEGER NOT NULL,
P012032 INTEGER NOT NULL,
P012033 INTEGER NOT NULL,
P012034 INTEGER NOT NULL,
P012035 INTEGER NOT NULL,
P012036 INTEGER NOT NULL,
P012037 INTEGER NOT NULL,
P012038 INTEGER NOT NULL,
P012039 INTEGER NOT NULL,
P012040 INTEGER NOT NULL,
P012041 INTEGER NOT NULL,
P012042 INTEGER NOT NULL,
P012043 INTEGER NOT NULL,
P012044 INTEGER NOT NULL,
P012045 INTEGER NOT NULL,
P012046 INTEGER NOT NULL,
P012047 INTEGER NOT NULL,
P012048 INTEGER NOT NULL,
P012049 INTEGER NOT NULL,
P013001 FLOAT NOT NULL,
P013002 FLOAT NOT NULL,
P013003 FLOAT NOT NULL,
P014001 INTEGER NOT NULL,
P014002 INTEGER NOT NULL,
P014003 INTEGER NOT NULL,
P014004 INTEGER NOT NULL,
P014005 INTEGER NOT NULL,
P014006 INTEGER NOT NULL,
P014007 INTEGER NOT NULL,
P014008 INTEGER NOT NULL,
P014009 INTEGER NOT NULL,
P014010 INTEGER NOT NULL,
P014011 INTEGER NOT NULL,
P014012 INTEGER NOT NULL,
P014013 INTEGER NOT NULL,
P014014 INTEGER NOT NULL,
P014015 INTEGER NOT NULL,
P014016 INTEGER NOT NULL,
P014017 INTEGER NOT NULL,
P014018 INTEGER NOT NULL,
P014019 INTEGER NOT NULL,
P014020 INTEGER NOT NULL,
P014021 INTEGER NOT NULL,
P014022 INTEGER NOT NULL,
P014023 INTEGER NOT NULL,
P014024 INTEGER NOT NULL,
P014025 INTEGER NOT NULL,
P014026 INTEGER NOT NULL,
P014027 INTEGER NOT NULL,
P014028 INTEGER NOT NULL,
P014029 INTEGER NOT NULL,
P014030 INTEGER NOT NULL,
P014031 INTEGER NOT NULL,
P014032 INTEGER NOT NULL,
P014033 INTEGER NOT NULL,
P014034 INTEGER NOT NULL,
P014035 INTEGER NOT NULL,
P014036 INTEGER NOT NULL,
P014037 INTEGER NOT NULL,
P014038 INTEGER NOT NULL,
P014039 INTEGER NOT NULL,
P014040 INTEGER NOT NULL,
P014041 INTEGER NOT NULL,
P014042 INTEGER NOT NULL,
P014043 INTEGER NOT NULL
);
CREATE TABLE sf1_05 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P015001 INTEGER NOT NULL,
P015002 INTEGER NOT NULL,
P015003 INTEGER NOT NULL,
P015004 INTEGER NOT NULL,
P015005 INTEGER NOT NULL,
P015006 INTEGER NOT NULL,
P015007 INTEGER NOT NULL,
P015008 INTEGER NOT NULL,
P015009 INTEGER NOT NULL,
P015010 INTEGER NOT NULL,
P015011 INTEGER NOT NULL,
P015012 INTEGER NOT NULL,
P015013 INTEGER NOT NULL,
P015014 INTEGER NOT NULL,
P015015 INTEGER NOT NULL,
P015016 INTEGER NOT NULL,
P015017 INTEGER NOT NULL,
P016001 INTEGER NOT NULL,
P016002 INTEGER NOT NULL,
P016003 INTEGER NOT NULL,
P017001 FLOAT NOT NULL,
P017002 FLOAT NOT NULL,
P017003 FLOAT NOT NULL,
P018001 INTEGER NOT NULL,
P018002 INTEGER NOT NULL,
P018003 INTEGER NOT NULL,
P018004 INTEGER NOT NULL,
P018005 INTEGER NOT NULL,
P018006 INTEGER NOT NULL,
P018007 INTEGER NOT NULL,
P018008 INTEGER NOT NULL,
P018009 INTEGER NOT NULL,
P019001 INTEGER NOT NULL,
P019002 INTEGER NOT NULL,
P019003 INTEGER NOT NULL,
P019004 INTEGER NOT NULL,
P019005 INTEGER NOT NULL,
P019006 INTEGER NOT NULL,
P019007 INTEGER NOT NULL,
P019008 INTEGER NOT NULL,
P019009 INTEGER NOT NULL,
P019010 INTEGER NOT NULL,
P019011 INTEGER NOT NULL,
P019012 INTEGER NOT NULL,
P019013 INTEGER NOT NULL,
P019014 INTEGER NOT NULL,
P019015 INTEGER NOT NULL,
P019016 INTEGER NOT NULL,
P019017 INTEGER NOT NULL,
P019018 INTEGER NOT NULL,
P019019 INTEGER NOT NULL,
P020001 INTEGER NOT NULL,
P020002 INTEGER NOT NULL,
P020003 INTEGER NOT NULL,
P020004 INTEGER NOT NULL,
P020005 INTEGER NOT NULL,
P020006 INTEGER NOT NULL,
P020007 INTEGER NOT NULL,
P020008 INTEGER NOT NULL,
P020009 INTEGER NOT NULL,
P020010 INTEGER NOT NULL,
P020011 INTEGER NOT NULL,
P020012 INTEGER NOT NULL,
P020013 INTEGER NOT NULL,
P020014 INTEGER NOT NULL,
P020015 INTEGER NOT NULL,
P020016 INTEGER NOT NULL,
P020017 INTEGER NOT NULL,
P020018 INTEGER NOT NULL,
P020019 INTEGER NOT NULL,
P020020 INTEGER NOT NULL,
P020021 INTEGER NOT NULL,
P020022 INTEGER NOT NULL,
P020023 INTEGER NOT NULL,
P020024 INTEGER NOT NULL,
P020025 INTEGER NOT NULL,
P020026 INTEGER NOT NULL,
P020027 INTEGER NOT NULL,
P020028 INTEGER NOT NULL,
P020029 INTEGER NOT NULL,
P020030 INTEGER NOT NULL,
P020031 INTEGER NOT NULL,
P020032 INTEGER NOT NULL,
P020033 INTEGER NOT NULL,
P020034 INTEGER NOT NULL,
P021001 INTEGER NOT NULL,
P021002 INTEGER NOT NULL,
P021003 INTEGER NOT NULL,
P021004 INTEGER NOT NULL,
P021005 INTEGER NOT NULL,
P021006 INTEGER NOT NULL,
P021007 INTEGER NOT NULL,
P021008 INTEGER NOT NULL,
P021009 INTEGER NOT NULL,
P021010 INTEGER NOT NULL,
P021011 INTEGER NOT NULL,
P021012 INTEGER NOT NULL,
P021013 INTEGER NOT NULL,
P021014 INTEGER NOT NULL,
P021015 INTEGER NOT NULL,
P021016 INTEGER NOT NULL,
P021017 INTEGER NOT NULL,
P021018 INTEGER NOT NULL,
P021019 INTEGER NOT NULL,
P021020 INTEGER NOT NULL,
P021021 INTEGER NOT NULL,
P021022 INTEGER NOT NULL,
P021023 INTEGER NOT NULL,
P021024 INTEGER NOT NULL,
P021025 INTEGER NOT NULL,
P021026 INTEGER NOT NULL,
P021027 INTEGER NOT NULL,
P021028 INTEGER NOT NULL,
P021029 INTEGER NOT NULL,
P021030 INTEGER NOT NULL,
P021031 INTEGER NOT NULL,
P022001 INTEGER NOT NULL,
P022002 INTEGER NOT NULL,
P022003 INTEGER NOT NULL,
P022004 INTEGER NOT NULL,
P022005 INTEGER NOT NULL,
P022006 INTEGER NOT NULL,
P022007 INTEGER NOT NULL,
P022008 INTEGER NOT NULL,
P022009 INTEGER NOT NULL,
P022010 INTEGER NOT NULL,
P022011 INTEGER NOT NULL,
P022012 INTEGER NOT NULL,
P022013 INTEGER NOT NULL,
P022014 INTEGER NOT NULL,
P022015 INTEGER NOT NULL,
P022016 INTEGER NOT NULL,
P022017 INTEGER NOT NULL,
P022018 INTEGER NOT NULL,
P022019 INTEGER NOT NULL,
P022020 INTEGER NOT NULL,
P022021 INTEGER NOT NULL,
P023001 INTEGER NOT NULL,
P023002 INTEGER NOT NULL,
P023003 INTEGER NOT NULL,
P023004 INTEGER NOT NULL,
P023005 INTEGER NOT NULL,
P023006 INTEGER NOT NULL,
P023007 INTEGER NOT NULL,
P023008 INTEGER NOT NULL,
P023009 INTEGER NOT NULL,
P023010 INTEGER NOT NULL,
P023011 INTEGER NOT NULL,
P023012 INTEGER NOT NULL,
P023013 INTEGER NOT NULL,
P023014 INTEGER NOT NULL,
P023015 INTEGER NOT NULL,
P024001 INTEGER NOT NULL,
P024002 INTEGER NOT NULL,
P024003 INTEGER NOT NULL,
P024004 INTEGER NOT NULL,
P024005 INTEGER NOT NULL,
P024006 INTEGER NOT NULL,
P024007 INTEGER NOT NULL,
P024008 INTEGER NOT NULL,
P024009 INTEGER NOT NULL,
P024010 INTEGER NOT NULL,
P024011 INTEGER NOT NULL,
P025001 INTEGER NOT NULL,
P025002 INTEGER NOT NULL,
P025003 INTEGER NOT NULL,
P025004 INTEGER NOT NULL,
P025005 INTEGER NOT NULL,
P025006 INTEGER NOT NULL,
P025007 INTEGER NOT NULL,
P025008 INTEGER NOT NULL,
P025009 INTEGER NOT NULL,
P025010 INTEGER NOT NULL,
P025011 INTEGER NOT NULL,
P026001 INTEGER NOT NULL,
P026002 INTEGER NOT NULL,
P026003 INTEGER NOT NULL,
P026004 INTEGER NOT NULL,
P026005 INTEGER NOT NULL,
P026006 INTEGER NOT NULL,
P026007 INTEGER NOT NULL,
P026008 INTEGER NOT NULL,
P026009 INTEGER NOT NULL,
P026010 INTEGER NOT NULL,
P026011 INTEGER NOT NULL,
P027001 INTEGER NOT NULL,
P027002 INTEGER NOT NULL,
P027003 INTEGER NOT NULL,
P028001 INTEGER NOT NULL,
P028002 INTEGER NOT NULL,
P028003 INTEGER NOT NULL,
P028004 INTEGER NOT NULL,
P028005 INTEGER NOT NULL,
P028006 INTEGER NOT NULL,
P028007 INTEGER NOT NULL,
P028008 INTEGER NOT NULL,
P028009 INTEGER NOT NULL,
P028010 INTEGER NOT NULL,
P028011 INTEGER NOT NULL,
P028012 INTEGER NOT NULL,
P028013 INTEGER NOT NULL,
P028014 INTEGER NOT NULL,
P028015 INTEGER NOT NULL,
P028016 INTEGER NOT NULL,
P029001 INTEGER NOT NULL,
P029002 INTEGER NOT NULL,
P029003 INTEGER NOT NULL,
P029004 INTEGER NOT NULL,
P029005 INTEGER NOT NULL,
P029006 INTEGER NOT NULL,
P029007 INTEGER NOT NULL,
P029008 INTEGER NOT NULL,
P029009 INTEGER NOT NULL,
P029010 INTEGER NOT NULL,
P029011 INTEGER NOT NULL,
P029012 INTEGER NOT NULL,
P029013 INTEGER NOT NULL,
P029014 INTEGER NOT NULL,
P029015 INTEGER NOT NULL,
P029016 INTEGER NOT NULL,
P029017 INTEGER NOT NULL,
P029018 INTEGER NOT NULL,
P029019 INTEGER NOT NULL,
P029020 INTEGER NOT NULL,
P029021 INTEGER NOT NULL,
P029022 INTEGER NOT NULL,
P029023 INTEGER NOT NULL,
P029024 INTEGER NOT NULL,
P029025 INTEGER NOT NULL,
P029026 INTEGER NOT NULL,
P029027 INTEGER NOT NULL,
P029028 INTEGER NOT NULL,
P030001 INTEGER NOT NULL,
P030002 INTEGER NOT NULL,
P030003 INTEGER NOT NULL,
P030004 INTEGER NOT NULL,
P030005 INTEGER NOT NULL,
P030006 INTEGER NOT NULL,
P030007 INTEGER NOT NULL,
P030008 INTEGER NOT NULL,
P030009 INTEGER NOT NULL,
P030010 INTEGER NOT NULL,
P030011 INTEGER NOT NULL,
P030012 INTEGER NOT NULL,
P030013 INTEGER NOT NULL
);
CREATE TABLE sf1_06 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P031001 INTEGER NOT NULL,
P031002 INTEGER NOT NULL,
P031003 INTEGER NOT NULL,
P031004 INTEGER NOT NULL,
P031005 INTEGER NOT NULL,
P031006 INTEGER NOT NULL,
P031007 INTEGER NOT NULL,
P031008 INTEGER NOT NULL,
P031009 INTEGER NOT NULL,
P031010 INTEGER NOT NULL,
P031011 INTEGER NOT NULL,
P031012 INTEGER NOT NULL,
P031013 INTEGER NOT NULL,
P031014 INTEGER NOT NULL,
P031015 INTEGER NOT NULL,
P031016 INTEGER NOT NULL,
P032001 INTEGER NOT NULL,
P032002 INTEGER NOT NULL,
P032003 INTEGER NOT NULL,
P032004 INTEGER NOT NULL,
P032005 INTEGER NOT NULL,
P032006 INTEGER NOT NULL,
P032007 INTEGER NOT NULL,
P032008 INTEGER NOT NULL,
P032009 INTEGER NOT NULL,
P032010 INTEGER NOT NULL,
P032011 INTEGER NOT NULL,
P032012 INTEGER NOT NULL,
P032013 INTEGER NOT NULL,
P032014 INTEGER NOT NULL,
P032015 INTEGER NOT NULL,
P032016 INTEGER NOT NULL,
P032017 INTEGER NOT NULL,
P032018 INTEGER NOT NULL,
P032019 INTEGER NOT NULL,
P032020 INTEGER NOT NULL,
P032021 INTEGER NOT NULL,
P032022 INTEGER NOT NULL,
P032023 INTEGER NOT NULL,
P032024 INTEGER NOT NULL,
P032025 INTEGER NOT NULL,
P032026 INTEGER NOT NULL,
P032027 INTEGER NOT NULL,
P032028 INTEGER NOT NULL,
P032029 INTEGER NOT NULL,
P032030 INTEGER NOT NULL,
P032031 INTEGER NOT NULL,
P032032 INTEGER NOT NULL,
P032033 INTEGER NOT NULL,
P032034 INTEGER NOT NULL,
P032035 INTEGER NOT NULL,
P032036 INTEGER NOT NULL,
P032037 INTEGER NOT NULL,
P032038 INTEGER NOT NULL,
P032039 INTEGER NOT NULL,
P032040 INTEGER NOT NULL,
P032041 INTEGER NOT NULL,
P032042 INTEGER NOT NULL,
P032043 INTEGER NOT NULL,
P032044 INTEGER NOT NULL,
P032045 INTEGER NOT NULL,
P033001 INTEGER NOT NULL,
P033002 INTEGER NOT NULL,
P033003 INTEGER NOT NULL,
P033004 INTEGER NOT NULL,
P033005 INTEGER NOT NULL,
P033006 INTEGER NOT NULL,
P033007 INTEGER NOT NULL,
P034001 INTEGER NOT NULL,
P034002 INTEGER NOT NULL,
P034003 INTEGER NOT NULL,
P034004 INTEGER NOT NULL,
P034005 INTEGER NOT NULL,
P034006 INTEGER NOT NULL,
P034007 INTEGER NOT NULL,
P034008 INTEGER NOT NULL,
P034009 INTEGER NOT NULL,
P034010 INTEGER NOT NULL,
P034011 INTEGER NOT NULL,
P034012 INTEGER NOT NULL,
P034013 INTEGER NOT NULL,
P034014 INTEGER NOT NULL,
P034015 INTEGER NOT NULL,
P034016 INTEGER NOT NULL,
P034017 INTEGER NOT NULL,
P034018 INTEGER NOT NULL,
P034019 INTEGER NOT NULL,
P034020 INTEGER NOT NULL,
P034021 INTEGER NOT NULL,
P034022 INTEGER NOT NULL,
P035001 INTEGER NOT NULL,
P036001 INTEGER NOT NULL,
P036002 INTEGER NOT NULL,
P036003 INTEGER NOT NULL,
P037001 FLOAT NOT NULL,
P037002 FLOAT NOT NULL,
P037003 FLOAT NOT NULL,
P038001 INTEGER NOT NULL,
P038002 INTEGER NOT NULL,
P038003 INTEGER NOT NULL,
P038004 INTEGER NOT NULL,
P038005 INTEGER NOT NULL,
P038006 INTEGER NOT NULL,
P038007 INTEGER NOT NULL,
P038008 INTEGER NOT NULL,
P038009 INTEGER NOT NULL,
P038010 INTEGER NOT NULL,
P038011 INTEGER NOT NULL,
P038012 INTEGER NOT NULL,
P038013 INTEGER NOT NULL,
P038014 INTEGER NOT NULL,
P038015 INTEGER NOT NULL,
P038016 INTEGER NOT NULL,
P038017 INTEGER NOT NULL,
P038018 INTEGER NOT NULL,
P038019 INTEGER NOT NULL,
P038020 INTEGER NOT NULL,
P039001 INTEGER NOT NULL,
P039002 INTEGER NOT NULL,
P039003 INTEGER NOT NULL,
P039004 INTEGER NOT NULL,
P039005 INTEGER NOT NULL,
P039006 INTEGER NOT NULL,
P039007 INTEGER NOT NULL,
P039008 INTEGER NOT NULL,
P039009 INTEGER NOT NULL,
P039010 INTEGER NOT NULL,
P039011 INTEGER NOT NULL,
P039012 INTEGER NOT NULL,
P039013 INTEGER NOT NULL,
P039014 INTEGER NOT NULL,
P039015 INTEGER NOT NULL,
P039016 INTEGER NOT NULL,
P039017 INTEGER NOT NULL,
P039018 INTEGER NOT NULL,
P039019 INTEGER NOT NULL,
P039020 INTEGER NOT NULL,
P040001 INTEGER NOT NULL,
P040002 INTEGER NOT NULL,
P040003 INTEGER NOT NULL,
P040004 INTEGER NOT NULL,
P040005 INTEGER NOT NULL,
P040006 INTEGER NOT NULL,
P040007 INTEGER NOT NULL,
P040008 INTEGER NOT NULL,
P040009 INTEGER NOT NULL,
P040010 INTEGER NOT NULL,
P040011 INTEGER NOT NULL,
P040012 INTEGER NOT NULL,
P040013 INTEGER NOT NULL,
P040014 INTEGER NOT NULL,
P040015 INTEGER NOT NULL,
P040016 INTEGER NOT NULL,
P040017 INTEGER NOT NULL,
P040018 INTEGER NOT NULL,
P040019 INTEGER NOT NULL,
P040020 INTEGER NOT NULL,
P041001 INTEGER NOT NULL,
P041002 INTEGER NOT NULL,
P041003 INTEGER NOT NULL,
P041004 INTEGER NOT NULL,
P041005 INTEGER NOT NULL,
P041006 INTEGER NOT NULL,
P042001 INTEGER NOT NULL,
P042002 INTEGER NOT NULL,
P042003 INTEGER NOT NULL,
P042004 INTEGER NOT NULL,
P042005 INTEGER NOT NULL,
P042006 INTEGER NOT NULL,
P042007 INTEGER NOT NULL,
P042008 INTEGER NOT NULL,
P042009 INTEGER NOT NULL,
P042010 INTEGER NOT NULL,
P043001 INTEGER NOT NULL,
P043002 INTEGER NOT NULL,
P043003 INTEGER NOT NULL,
P043004 INTEGER NOT NULL,
P043005 INTEGER NOT NULL,
P043006 INTEGER NOT NULL,
P043007 INTEGER NOT NULL,
P043008 INTEGER NOT NULL,
P043009 INTEGER NOT NULL,
P043010 INTEGER NOT NULL,
P043011 INTEGER NOT NULL,
P043012 INTEGER NOT NULL,
P043013 INTEGER NOT NULL,
P043014 INTEGER NOT NULL,
P043015 INTEGER NOT NULL,
P043016 INTEGER NOT NULL,
P043017 INTEGER NOT NULL,
P043018 INTEGER NOT NULL,
P043019 INTEGER NOT NULL,
P043020 INTEGER NOT NULL,
P043021 INTEGER NOT NULL,
P043022 INTEGER NOT NULL,
P043023 INTEGER NOT NULL,
P043024 INTEGER NOT NULL,
P043025 INTEGER NOT NULL,
P043026 INTEGER NOT NULL,
P043027 INTEGER NOT NULL,
P043028 INTEGER NOT NULL,
P043029 INTEGER NOT NULL,
P043030 INTEGER NOT NULL,
P043031 INTEGER NOT NULL,
P043032 INTEGER NOT NULL,
P043033 INTEGER NOT NULL,
P043034 INTEGER NOT NULL,
P043035 INTEGER NOT NULL,
P043036 INTEGER NOT NULL,
P043037 INTEGER NOT NULL,
P043038 INTEGER NOT NULL,
P043039 INTEGER NOT NULL,
P043040 INTEGER NOT NULL,
P043041 INTEGER NOT NULL,
P043042 INTEGER NOT NULL,
P043043 INTEGER NOT NULL,
P043044 INTEGER NOT NULL,
P043045 INTEGER NOT NULL,
P043046 INTEGER NOT NULL,
P043047 INTEGER NOT NULL,
P043048 INTEGER NOT NULL,
P043049 INTEGER NOT NULL,
P043050 INTEGER NOT NULL,
P043051 INTEGER NOT NULL,
P043052 INTEGER NOT NULL,
P043053 INTEGER NOT NULL,
P043054 INTEGER NOT NULL,
P043055 INTEGER NOT NULL,
P043056 INTEGER NOT NULL,
P043057 INTEGER NOT NULL,
P043058 INTEGER NOT NULL,
P043059 INTEGER NOT NULL,
P043060 INTEGER NOT NULL,
P043061 INTEGER NOT NULL,
P043062 INTEGER NOT NULL,
P043063 INTEGER NOT NULL,
P044001 INTEGER NOT NULL,
P044002 INTEGER NOT NULL,
P044003 INTEGER NOT NULL,
P045001 INTEGER NOT NULL,
P045002 INTEGER NOT NULL,
P045003 INTEGER NOT NULL,
P046001 INTEGER NOT NULL,
P046002 INTEGER NOT NULL,
P046003 INTEGER NOT NULL,
P047001 INTEGER NOT NULL,
P047002 INTEGER NOT NULL,
P047003 INTEGER NOT NULL,
P048001 INTEGER NOT NULL,
P048002 INTEGER NOT NULL,
P048003 INTEGER NOT NULL,
P049001 INTEGER NOT NULL,
P049002 INTEGER NOT NULL,
P049003 INTEGER NOT NULL
);
CREATE TABLE sf1_07 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P050001 INTEGER NOT NULL,
P050002 INTEGER NOT NULL,
P050003 INTEGER NOT NULL,
P051001 INTEGER NOT NULL,
P051002 INTEGER NOT NULL,
P051003 INTEGER NOT NULL,
P012A001 INTEGER NOT NULL,
P012A002 INTEGER NOT NULL,
P012A003 INTEGER NOT NULL,
P012A004 INTEGER NOT NULL,
P012A005 INTEGER NOT NULL,
P012A006 INTEGER NOT NULL,
P012A007 INTEGER NOT NULL,
P012A008 INTEGER NOT NULL,
P012A009 INTEGER NOT NULL,
P012A010 INTEGER NOT NULL,
P012A011 INTEGER NOT NULL,
P012A012 INTEGER NOT NULL,
P012A013 INTEGER NOT NULL,
P012A014 INTEGER NOT NULL,
P012A015 INTEGER NOT NULL,
P012A016 INTEGER NOT NULL,
P012A017 INTEGER NOT NULL,
P012A018 INTEGER NOT NULL,
P012A019 INTEGER NOT NULL,
P012A020 INTEGER NOT NULL,
P012A021 INTEGER NOT NULL,
P012A022 INTEGER NOT NULL,
P012A023 INTEGER NOT NULL,
P012A024 INTEGER NOT NULL,
P012A025 INTEGER NOT NULL,
P012A026 INTEGER NOT NULL,
P012A027 INTEGER NOT NULL,
P012A028 INTEGER NOT NULL,
P012A029 INTEGER NOT NULL,
P012A030 INTEGER NOT NULL,
P012A031 INTEGER NOT NULL,
P012A032 INTEGER NOT NULL,
P012A033 INTEGER NOT NULL,
P012A034 INTEGER NOT NULL,
P012A035 INTEGER NOT NULL,
P012A036 INTEGER NOT NULL,
P012A037 INTEGER NOT NULL,
P012A038 INTEGER NOT NULL,
P012A039 INTEGER NOT NULL,
P012A040 INTEGER NOT NULL,
P012A041 INTEGER NOT NULL,
P012A042 INTEGER NOT NULL,
P012A043 INTEGER NOT NULL,
P012A044 INTEGER NOT NULL,
P012A045 INTEGER NOT NULL,
P012A046 INTEGER NOT NULL,
P012A047 INTEGER NOT NULL,
P012A048 INTEGER NOT NULL,
P012A049 INTEGER NOT NULL,
P012B001 INTEGER NOT NULL,
P012B002 INTEGER NOT NULL,
P012B003 INTEGER NOT NULL,
P012B004 INTEGER NOT NULL,
P012B005 INTEGER NOT NULL,
P012B006 INTEGER NOT NULL,
P012B007 INTEGER NOT NULL,
P012B008 INTEGER NOT NULL,
P012B009 INTEGER NOT NULL,
P012B010 INTEGER NOT NULL,
P012B011 INTEGER NOT NULL,
P012B012 INTEGER NOT NULL,
P012B013 INTEGER NOT NULL,
P012B014 INTEGER NOT NULL,
P012B015 INTEGER NOT NULL,
P012B016 INTEGER NOT NULL,
P012B017 INTEGER NOT NULL,
P012B018 INTEGER NOT NULL,
P012B019 INTEGER NOT NULL,
P012B020 INTEGER NOT NULL,
P012B021 INTEGER NOT NULL,
P012B022 INTEGER NOT NULL,
P012B023 INTEGER NOT NULL,
P012B024 INTEGER NOT NULL,
P012B025 INTEGER NOT NULL,
P012B026 INTEGER NOT NULL,
P012B027 INTEGER NOT NULL,
P012B028 INTEGER NOT NULL,
P012B029 INTEGER NOT NULL,
P012B030 INTEGER NOT NULL,
P012B031 INTEGER NOT NULL,
P012B032 INTEGER NOT NULL,
P012B033 INTEGER NOT NULL,
P012B034 INTEGER NOT NULL,
P012B035 INTEGER NOT NULL,
P012B036 INTEGER NOT NULL,
P012B037 INTEGER NOT NULL,
P012B038 INTEGER NOT NULL,
P012B039 INTEGER NOT NULL,
P012B040 INTEGER NOT NULL,
P012B041 INTEGER NOT NULL,
P012B042 INTEGER NOT NULL,
P012B043 INTEGER NOT NULL,
P012B044 INTEGER NOT NULL,
P012B045 INTEGER NOT NULL,
P012B046 INTEGER NOT NULL,
P012B047 INTEGER NOT NULL,
P012B048 INTEGER NOT NULL,
P012B049 INTEGER NOT NULL,
P012C001 INTEGER NOT NULL,
P012C002 INTEGER NOT NULL,
P012C003 INTEGER NOT NULL,
P012C004 INTEGER NOT NULL,
P012C005 INTEGER NOT NULL,
P012C006 INTEGER NOT NULL,
P012C007 INTEGER NOT NULL,
P012C008 INTEGER NOT NULL,
P012C009 INTEGER NOT NULL,
P012C010 INTEGER NOT NULL,
P012C011 INTEGER NOT NULL,
P012C012 INTEGER NOT NULL,
P012C013 INTEGER NOT NULL,
P012C014 INTEGER NOT NULL,
P012C015 INTEGER NOT NULL,
P012C016 INTEGER NOT NULL,
P012C017 INTEGER NOT NULL,
P012C018 INTEGER NOT NULL,
P012C019 INTEGER NOT NULL,
P012C020 INTEGER NOT NULL,
P012C021 INTEGER NOT NULL,
P012C022 INTEGER NOT NULL,
P012C023 INTEGER NOT NULL,
P012C024 INTEGER NOT NULL,
P012C025 INTEGER NOT NULL,
P012C026 INTEGER NOT NULL,
P012C027 INTEGER NOT NULL,
P012C028 INTEGER NOT NULL,
P012C029 INTEGER NOT NULL,
P012C030 INTEGER NOT NULL,
P012C031 INTEGER NOT NULL,
P012C032 INTEGER NOT NULL,
P012C033 INTEGER NOT NULL,
P012C034 INTEGER NOT NULL,
P012C035 INTEGER NOT NULL,
P012C036 INTEGER NOT NULL,
P012C037 INTEGER NOT NULL,
P012C038 INTEGER NOT NULL,
P012C039 INTEGER NOT NULL,
P012C040 INTEGER NOT NULL,
P012C041 INTEGER NOT NULL,
P012C042 INTEGER NOT NULL,
P012C043 INTEGER NOT NULL,
P012C044 INTEGER NOT NULL,
P012C045 INTEGER NOT NULL,
P012C046 INTEGER NOT NULL,
P012C047 INTEGER NOT NULL,
P012C048 INTEGER NOT NULL,
P012C049 INTEGER NOT NULL,
P012D001 INTEGER NOT NULL,
P012D002 INTEGER NOT NULL,
P012D003 INTEGER NOT NULL,
P012D004 INTEGER NOT NULL,
P012D005 INTEGER NOT NULL,
P012D006 INTEGER NOT NULL,
P012D007 INTEGER NOT NULL,
P012D008 INTEGER NOT NULL,
P012D009 INTEGER NOT NULL,
P012D010 INTEGER NOT NULL,
P012D011 INTEGER NOT NULL,
P012D012 INTEGER NOT NULL,
P012D013 INTEGER NOT NULL,
P012D014 INTEGER NOT NULL,
P012D015 INTEGER NOT NULL,
P012D016 INTEGER NOT NULL,
P012D017 INTEGER NOT NULL,
P012D018 INTEGER NOT NULL,
P012D019 INTEGER NOT NULL,
P012D020 INTEGER NOT NULL,
P012D021 INTEGER NOT NULL,
P012D022 INTEGER NOT NULL,
P012D023 INTEGER NOT NULL,
P012D024 INTEGER NOT NULL,
P012D025 INTEGER NOT NULL,
P012D026 INTEGER NOT NULL,
P012D027 INTEGER NOT NULL,
P012D028 INTEGER NOT NULL,
P012D029 INTEGER NOT NULL,
P012D030 INTEGER NOT NULL,
P012D031 INTEGER NOT NULL,
P012D032 INTEGER NOT NULL,
P012D033 INTEGER NOT NULL,
P012D034 INTEGER NOT NULL,
P012D035 INTEGER NOT NULL,
P012D036 INTEGER NOT NULL,
P012D037 INTEGER NOT NULL,
P012D038 INTEGER NOT NULL,
P012D039 INTEGER NOT NULL,
P012D040 INTEGER NOT NULL,
P012D041 INTEGER NOT NULL,
P012D042 INTEGER NOT NULL,
P012D043 INTEGER NOT NULL,
P012D044 INTEGER NOT NULL,
P012D045 INTEGER NOT NULL,
P012D046 INTEGER NOT NULL,
P012D047 INTEGER NOT NULL,
P012D048 INTEGER NOT NULL,
P012D049 INTEGER NOT NULL,
P012E001 INTEGER NOT NULL,
P012E002 INTEGER NOT NULL,
P012E003 INTEGER NOT NULL,
P012E004 INTEGER NOT NULL,
P012E005 INTEGER NOT NULL,
P012E006 INTEGER NOT NULL,
P012E007 INTEGER NOT NULL,
P012E008 INTEGER NOT NULL,
P012E009 INTEGER NOT NULL,
P012E010 INTEGER NOT NULL,
P012E011 INTEGER NOT NULL,
P012E012 INTEGER NOT NULL,
P012E013 INTEGER NOT NULL,
P012E014 INTEGER NOT NULL,
P012E015 INTEGER NOT NULL,
P012E016 INTEGER NOT NULL,
P012E017 INTEGER NOT NULL,
P012E018 INTEGER NOT NULL,
P012E019 INTEGER NOT NULL,
P012E020 INTEGER NOT NULL,
P012E021 INTEGER NOT NULL,
P012E022 INTEGER NOT NULL,
P012E023 INTEGER NOT NULL,
P012E024 INTEGER NOT NULL,
P012E025 INTEGER NOT NULL,
P012E026 INTEGER NOT NULL,
P012E027 INTEGER NOT NULL,
P012E028 INTEGER NOT NULL,
P012E029 INTEGER NOT NULL,
P012E030 INTEGER NOT NULL,
P012E031 INTEGER NOT NULL,
P012E032 INTEGER NOT NULL,
P012E033 INTEGER NOT NULL,
P012E034 INTEGER NOT NULL,
P012E035 INTEGER NOT NULL,
P012E036 INTEGER NOT NULL,
P012E037 INTEGER NOT NULL,
P012E038 INTEGER NOT NULL,
P012E039 INTEGER NOT NULL,
P012E040 INTEGER NOT NULL,
P012E041 INTEGER NOT NULL,
P012E042 INTEGER NOT NULL,
P012E043 INTEGER NOT NULL,
P012E044 INTEGER NOT NULL,
P012E045 INTEGER NOT NULL,
P012E046 INTEGER NOT NULL,
P012E047 INTEGER NOT NULL,
P012E048 INTEGER NOT NULL,
P012E049 INTEGER NOT NULL
);
CREATE TABLE sf1_08 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P012F001 INTEGER NOT NULL,
P012F002 INTEGER NOT NULL,
P012F003 INTEGER NOT NULL,
P012F004 INTEGER NOT NULL,
P012F005 INTEGER NOT NULL,
P012F006 INTEGER NOT NULL,
P012F007 INTEGER NOT NULL,
P012F008 INTEGER NOT NULL,
P012F009 INTEGER NOT NULL,
P012F010 INTEGER NOT NULL,
P012F011 INTEGER NOT NULL,
P012F012 INTEGER NOT NULL,
P012F013 INTEGER NOT NULL,
P012F014 INTEGER NOT NULL,
P012F015 INTEGER NOT NULL,
P012F016 INTEGER NOT NULL,
P012F017 INTEGER NOT NULL,
P012F018 INTEGER NOT NULL,
P012F019 INTEGER NOT NULL,
P012F020 INTEGER NOT NULL,
P012F021 INTEGER NOT NULL,
P012F022 INTEGER NOT NULL,
P012F023 INTEGER NOT NULL,
P012F024 INTEGER NOT NULL,
P012F025 INTEGER NOT NULL,
P012F026 INTEGER NOT NULL,
P012F027 INTEGER NOT NULL,
P012F028 INTEGER NOT NULL,
P012F029 INTEGER NOT NULL,
P012F030 INTEGER NOT NULL,
P012F031 INTEGER NOT NULL,
P012F032 INTEGER NOT NULL,
P012F033 INTEGER NOT NULL,
P012F034 INTEGER NOT NULL,
P012F035 INTEGER NOT NULL,
P012F036 INTEGER NOT NULL,
P012F037 INTEGER NOT NULL,
P012F038 INTEGER NOT NULL,
P012F039 INTEGER NOT NULL,
P012F040 INTEGER NOT NULL,
P012F041 INTEGER NOT NULL,
P012F042 INTEGER NOT NULL,
P012F043 INTEGER NOT NULL,
P012F044 INTEGER NOT NULL,
P012F045 INTEGER NOT NULL,
P012F046 INTEGER NOT NULL,
P012F047 INTEGER NOT NULL,
P012F048 INTEGER NOT NULL,
P012F049 INTEGER NOT NULL,
P012G001 INTEGER NOT NULL,
P012G002 INTEGER NOT NULL,
P012G003 INTEGER NOT NULL,
P012G004 INTEGER NOT NULL,
P012G005 INTEGER NOT NULL,
P012G006 INTEGER NOT NULL,
P012G007 INTEGER NOT NULL,
P012G008 INTEGER NOT NULL,
P012G009 INTEGER NOT NULL,
P012G010 INTEGER NOT NULL,
P012G011 INTEGER NOT NULL,
P012G012 INTEGER NOT NULL,
P012G013 INTEGER NOT NULL,
P012G014 INTEGER NOT NULL,
P012G015 INTEGER NOT NULL,
P012G016 INTEGER NOT NULL,
P012G017 INTEGER NOT NULL,
P012G018 INTEGER NOT NULL,
P012G019 INTEGER NOT NULL,
P012G020 INTEGER NOT NULL,
P012G021 INTEGER NOT NULL,
P012G022 INTEGER NOT NULL,
P012G023 INTEGER NOT NULL,
P012G024 INTEGER NOT NULL,
P012G025 INTEGER NOT NULL,
P012G026 INTEGER NOT NULL,
P012G027 INTEGER NOT NULL,
P012G028 INTEGER NOT NULL,
P012G029 INTEGER NOT NULL,
P012G030 INTEGER NOT NULL,
P012G031 INTEGER NOT NULL,
P012G032 INTEGER NOT NULL,
P012G033 INTEGER NOT NULL,
P012G034 INTEGER NOT NULL,
P012G035 INTEGER NOT NULL,
P012G036 INTEGER NOT NULL,
P012G037 INTEGER NOT NULL,
P012G038 INTEGER NOT NULL,
P012G039 INTEGER NOT NULL,
P012G040 INTEGER NOT NULL,
P012G041 INTEGER NOT NULL,
P012G042 INTEGER NOT NULL,
P012G043 INTEGER NOT NULL,
P012G044 INTEGER NOT NULL,
P012G045 INTEGER NOT NULL,
P012G046 INTEGER NOT NULL,
P012G047 INTEGER NOT NULL,
P012G048 INTEGER NOT NULL,
P012G049 INTEGER NOT NULL,
P012H001 INTEGER NOT NULL,
P012H002 INTEGER NOT NULL,
P012H003 INTEGER NOT NULL,
P012H004 INTEGER NOT NULL,
P012H005 INTEGER NOT NULL,
P012H006 INTEGER NOT NULL,
P012H007 INTEGER NOT NULL,
P012H008 INTEGER NOT NULL,
P012H009 INTEGER NOT NULL,
P012H010 INTEGER NOT NULL,
P012H011 INTEGER NOT NULL,
P012H012 INTEGER NOT NULL,
P012H013 INTEGER NOT NULL,
P012H014 INTEGER NOT NULL,
P012H015 INTEGER NOT NULL,
P012H016 INTEGER NOT NULL,
P012H017 INTEGER NOT NULL,
P012H018 INTEGER NOT NULL,
P012H019 INTEGER NOT NULL,
P012H020 INTEGER NOT NULL,
P012H021 INTEGER NOT NULL,
P012H022 INTEGER NOT NULL,
P012H023 INTEGER NOT NULL,
P012H024 INTEGER NOT NULL,
P012H025 INTEGER NOT NULL,
P012H026 INTEGER NOT NULL,
P012H027 INTEGER NOT NULL,
P012H028 INTEGER NOT NULL,
P012H029 INTEGER NOT NULL,
P012H030 INTEGER NOT NULL,
P012H031 INTEGER NOT NULL,
P012H032 INTEGER NOT NULL,
P012H033 INTEGER NOT NULL,
P012H034 INTEGER NOT NULL,
P012H035 INTEGER NOT NULL,
P012H036 INTEGER NOT NULL,
P012H037 INTEGER NOT NULL,
P012H038 INTEGER NOT NULL,
P012H039 INTEGER NOT NULL,
P012H040 INTEGER NOT NULL,
P012H041 INTEGER NOT NULL,
P012H042 INTEGER NOT NULL,
P012H043 INTEGER NOT NULL,
P012H044 INTEGER NOT NULL,
P012H045 INTEGER NOT NULL,
P012H046 INTEGER NOT NULL,
P012H047 INTEGER NOT NULL,
P012H048 INTEGER NOT NULL,
P012H049 INTEGER NOT NULL,
P012I001 INTEGER NOT NULL,
P012I002 INTEGER NOT NULL,
P012I003 INTEGER NOT NULL,
P012I004 INTEGER NOT NULL,
P012I005 INTEGER NOT NULL,
P012I006 INTEGER NOT NULL,
P012I007 INTEGER NOT NULL,
P012I008 INTEGER NOT NULL,
P012I009 INTEGER NOT NULL,
P012I010 INTEGER NOT NULL,
P012I011 INTEGER NOT NULL,
P012I012 INTEGER NOT NULL,
P012I013 INTEGER NOT NULL,
P012I014 INTEGER NOT NULL,
P012I015 INTEGER NOT NULL,
P012I016 INTEGER NOT NULL,
P012I017 INTEGER NOT NULL,
P012I018 INTEGER NOT NULL,
P012I019 INTEGER NOT NULL,
P012I020 INTEGER NOT NULL,
P012I021 INTEGER NOT NULL,
P012I022 INTEGER NOT NULL,
P012I023 INTEGER NOT NULL,
P012I024 INTEGER NOT NULL,
P012I025 INTEGER NOT NULL,
P012I026 INTEGER NOT NULL,
P012I027 INTEGER NOT NULL,
P012I028 INTEGER NOT NULL,
P012I029 INTEGER NOT NULL,
P012I030 INTEGER NOT NULL,
P012I031 INTEGER NOT NULL,
P012I032 INTEGER NOT NULL,
P012I033 INTEGER NOT NULL,
P012I034 INTEGER NOT NULL,
P012I035 INTEGER NOT NULL,
P012I036 INTEGER NOT NULL,
P012I037 INTEGER NOT NULL,
P012I038 INTEGER NOT NULL,
P012I039 INTEGER NOT NULL,
P012I040 INTEGER NOT NULL,
P012I041 INTEGER NOT NULL,
P012I042 INTEGER NOT NULL,
P012I043 INTEGER NOT NULL,
P012I044 INTEGER NOT NULL,
P012I045 INTEGER NOT NULL,
P012I046 INTEGER NOT NULL,
P012I047 INTEGER NOT NULL,
P012I048 INTEGER NOT NULL,
P012I049 INTEGER NOT NULL,
P013A001 FLOAT NOT NULL,
P013A002 FLOAT NOT NULL,
P013A003 FLOAT NOT NULL,
P013B001 FLOAT NOT NULL,
P013B002 FLOAT NOT NULL,
P013B003 FLOAT NOT NULL,
P013C001 FLOAT NOT NULL,
P013C002 FLOAT NOT NULL,
P013C003 FLOAT NOT NULL,
P013D001 FLOAT NOT NULL,
P013D002 FLOAT NOT NULL,
P013D003 FLOAT NOT NULL,
P013E001 FLOAT NOT NULL,
P013E002 FLOAT NOT NULL,
P013E003 FLOAT NOT NULL,
P013F001 FLOAT NOT NULL,
P013F002 FLOAT NOT NULL,
P013F003 FLOAT NOT NULL,
P013G001 FLOAT NOT NULL,
P013G002 FLOAT NOT NULL,
P013G003 FLOAT NOT NULL,
P013H001 FLOAT NOT NULL,
P013H002 FLOAT NOT NULL,
P013H003 FLOAT NOT NULL,
P013I001 FLOAT NOT NULL,
P013I002 FLOAT NOT NULL,
P013I003 FLOAT NOT NULL,
P016A001 INTEGER NOT NULL,
P016A002 INTEGER NOT NULL,
P016A003 INTEGER NOT NULL,
P016B001 INTEGER NOT NULL,
P016B002 INTEGER NOT NULL,
P016B003 INTEGER NOT NULL,
P016C001 INTEGER NOT NULL,
P016C002 INTEGER NOT NULL,
P016C003 INTEGER NOT NULL,
P016D001 INTEGER NOT NULL,
P016D002 INTEGER NOT NULL,
P016D003 INTEGER NOT NULL,
P016E001 INTEGER NOT NULL,
P016E002 INTEGER NOT NULL,
P016E003 INTEGER NOT NULL,
P016F001 INTEGER NOT NULL,
P016F002 INTEGER NOT NULL,
P016F003 INTEGER NOT NULL,
P016G001 INTEGER NOT NULL,
P016G002 INTEGER NOT NULL,
P016G003 INTEGER NOT NULL,
P016H001 INTEGER NOT NULL,
P016H002 INTEGER NOT NULL,
P016H003 INTEGER NOT NULL,
P016I001 INTEGER NOT NULL,
P016I002 INTEGER NOT NULL,
P016I003 INTEGER NOT NULL,
P017A001 FLOAT NOT NULL,
P017A002 FLOAT NOT NULL,
P017A003 FLOAT NOT NULL
);
CREATE TABLE sf1_09 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P017B001 FLOAT NOT NULL,
P017B002 FLOAT NOT NULL,
P017B003 FLOAT NOT NULL,
P017C001 FLOAT NOT NULL,
P017C002 FLOAT NOT NULL,
P017C003 FLOAT NOT NULL,
P017D001 FLOAT NOT NULL,
P017D002 FLOAT NOT NULL,
P017D003 FLOAT NOT NULL,
P017E001 FLOAT NOT NULL,
P017E002 FLOAT NOT NULL,
P017E003 FLOAT NOT NULL,
P017F001 FLOAT NOT NULL,
P017F002 FLOAT NOT NULL,
P017F003 FLOAT NOT NULL,
P017G001 FLOAT NOT NULL,
P017G002 FLOAT NOT NULL,
P017G003 FLOAT NOT NULL,
P017H001 FLOAT NOT NULL,
P017H002 FLOAT NOT NULL,
P017H003 FLOAT NOT NULL,
P017I001 FLOAT NOT NULL,
P017I002 FLOAT NOT NULL,
P017I003 FLOAT NOT NULL,
P018A001 INTEGER NOT NULL,
P018A002 INTEGER NOT NULL,
P018A003 INTEGER NOT NULL,
P018A004 INTEGER NOT NULL,
P018A005 INTEGER NOT NULL,
P018A006 INTEGER NOT NULL,
P018A007 INTEGER NOT NULL,
P018A008 INTEGER NOT NULL,
P018A009 INTEGER NOT NULL,
P018B001 INTEGER NOT NULL,
P018B002 INTEGER NOT NULL,
P018B003 INTEGER NOT NULL,
P018B004 INTEGER NOT NULL,
P018B005 INTEGER NOT NULL,
P018B006 INTEGER NOT NULL,
P018B007 INTEGER NOT NULL,
P018B008 INTEGER NOT NULL,
P018B009 INTEGER NOT NULL,
P018C001 INTEGER NOT NULL,
P018C002 INTEGER NOT NULL,
P018C003 INTEGER NOT NULL,
P018C004 INTEGER NOT NULL,
P018C005 INTEGER NOT NULL,
P018C006 INTEGER NOT NULL,
P018C007 INTEGER NOT NULL,
P018C008 INTEGER NOT NULL,
P018C009 INTEGER NOT NULL,
P018D001 INTEGER NOT NULL,
P018D002 INTEGER NOT NULL,
P018D003 INTEGER NOT NULL,
P018D004 INTEGER NOT NULL,
P018D005 INTEGER NOT NULL,
P018D006 INTEGER NOT NULL,
P018D007 INTEGER NOT NULL,
P018D008 INTEGER NOT NULL,
P018D009 INTEGER NOT NULL,
P018E001 INTEGER NOT NULL,
P018E002 INTEGER NOT NULL,
P018E003 INTEGER NOT NULL,
P018E004 INTEGER NOT NULL,
P018E005 INTEGER NOT NULL,
P018E006 INTEGER NOT NULL,
P018E007 INTEGER NOT NULL,
P018E008 INTEGER NOT NULL,
P018E009 INTEGER NOT NULL,
P018F001 INTEGER NOT NULL,
P018F002 INTEGER NOT NULL,
P018F003 INTEGER NOT NULL,
P018F004 INTEGER NOT NULL,
P018F005 INTEGER NOT NULL,
P018F006 INTEGER NOT NULL,
P018F007 INTEGER NOT NULL,
P018F008 INTEGER NOT NULL,
P018F009 INTEGER NOT NULL,
P018G001 INTEGER NOT NULL,
P018G002 INTEGER NOT NULL,
P018G003 INTEGER NOT NULL,
P018G004 INTEGER NOT NULL,
P018G005 INTEGER NOT NULL,
P018G006 INTEGER NOT NULL,
P018G007 INTEGER NOT NULL,
P018G008 INTEGER NOT NULL,
P018G009 INTEGER NOT NULL,
P018H001 INTEGER NOT NULL,
P018H002 INTEGER NOT NULL,
P018H003 INTEGER NOT NULL,
P018H004 INTEGER NOT NULL,
P018H005 INTEGER NOT NULL,
P018H006 INTEGER NOT NULL,
P018H007 INTEGER NOT NULL,
P018H008 INTEGER NOT NULL,
P018H009 INTEGER NOT NULL,
P018I001 INTEGER NOT NULL,
P018I002 INTEGER NOT NULL,
P018I003 INTEGER NOT NULL,
P018I004 INTEGER NOT NULL,
P018I005 INTEGER NOT NULL,
P018I006 INTEGER NOT NULL,
P018I007 INTEGER NOT NULL,
P018I008 INTEGER NOT NULL,
P018I009 INTEGER NOT NULL,
P028A001 INTEGER NOT NULL,
P028A002 INTEGER NOT NULL,
P028A003 INTEGER NOT NULL,
P028A004 INTEGER NOT NULL,
P028A005 INTEGER NOT NULL,
P028A006 INTEGER NOT NULL,
P028A007 INTEGER NOT NULL,
P028A008 INTEGER NOT NULL,
P028A009 INTEGER NOT NULL,
P028A010 INTEGER NOT NULL,
P028A011 INTEGER NOT NULL,
P028A012 INTEGER NOT NULL,
P028A013 INTEGER NOT NULL,
P028A014 INTEGER NOT NULL,
P028A015 INTEGER NOT NULL,
P028A016 INTEGER NOT NULL,
P028B001 INTEGER NOT NULL,
P028B002 INTEGER NOT NULL,
P028B003 INTEGER NOT NULL,
P028B004 INTEGER NOT NULL,
P028B005 INTEGER NOT NULL,
P028B006 INTEGER NOT NULL,
P028B007 INTEGER NOT NULL,
P028B008 INTEGER NOT NULL,
P028B009 INTEGER NOT NULL,
P028B010 INTEGER NOT NULL,
P028B011 INTEGER NOT NULL,
P028B012 INTEGER NOT NULL,
P028B013 INTEGER NOT NULL,
P028B014 INTEGER NOT NULL,
P028B015 INTEGER NOT NULL,
P028B016 INTEGER NOT NULL,
P028C001 INTEGER NOT NULL,
P028C002 INTEGER NOT NULL,
P028C003 INTEGER NOT NULL,
P028C004 INTEGER NOT NULL,
P028C005 INTEGER NOT NULL,
P028C006 INTEGER NOT NULL,
P028C007 INTEGER NOT NULL,
P028C008 INTEGER NOT NULL,
P028C009 INTEGER NOT NULL,
P028C010 INTEGER NOT NULL,
P028C011 INTEGER NOT NULL,
P028C012 INTEGER NOT NULL,
P028C013 INTEGER NOT NULL,
P028C014 INTEGER NOT NULL,
P028C015 INTEGER NOT NULL,
P028C016 INTEGER NOT NULL,
P028D001 INTEGER NOT NULL,
P028D002 INTEGER NOT NULL,
P028D003 INTEGER NOT NULL,
P028D004 INTEGER NOT NULL,
P028D005 INTEGER NOT NULL,
P028D006 INTEGER NOT NULL,
P028D007 INTEGER NOT NULL,
P028D008 INTEGER NOT NULL,
P028D009 INTEGER NOT NULL,
P028D010 INTEGER NOT NULL,
P028D011 INTEGER NOT NULL,
P028D012 INTEGER NOT NULL,
P028D013 INTEGER NOT NULL,
P028D014 INTEGER NOT NULL,
P028D015 INTEGER NOT NULL,
P028D016 INTEGER NOT NULL,
P028E001 INTEGER NOT NULL,
P028E002 INTEGER NOT NULL,
P028E003 INTEGER NOT NULL,
P028E004 INTEGER NOT NULL,
P028E005 INTEGER NOT NULL,
P028E006 INTEGER NOT NULL,
P028E007 INTEGER NOT NULL,
P028E008 INTEGER NOT NULL,
P028E009 INTEGER NOT NULL,
P028E010 INTEGER NOT NULL,
P028E011 INTEGER NOT NULL,
P028E012 INTEGER NOT NULL,
P028E013 INTEGER NOT NULL,
P028E014 INTEGER NOT NULL,
P028E015 INTEGER NOT NULL,
P028E016 INTEGER NOT NULL,
P028F001 INTEGER NOT NULL,
P028F002 INTEGER NOT NULL,
P028F003 INTEGER NOT NULL,
P028F004 INTEGER NOT NULL,
P028F005 INTEGER NOT NULL,
P028F006 INTEGER NOT NULL,
P028F007 INTEGER NOT NULL,
P028F008 INTEGER NOT NULL,
P028F009 INTEGER NOT NULL,
P028F010 INTEGER NOT NULL,
P028F011 INTEGER NOT NULL,
P028F012 INTEGER NOT NULL,
P028F013 INTEGER NOT NULL,
P028F014 INTEGER NOT NULL,
P028F015 INTEGER NOT NULL,
P028F016 INTEGER NOT NULL,
P028G001 INTEGER NOT NULL,
P028G002 INTEGER NOT NULL,
P028G003 INTEGER NOT NULL,
P028G004 INTEGER NOT NULL,
P028G005 INTEGER NOT NULL,
P028G006 INTEGER NOT NULL,
P028G007 INTEGER NOT NULL,
P028G008 INTEGER NOT NULL,
P028G009 INTEGER NOT NULL,
P028G010 INTEGER NOT NULL,
P028G011 INTEGER NOT NULL,
P028G012 INTEGER NOT NULL,
P028G013 INTEGER NOT NULL,
P028G014 INTEGER NOT NULL,
P028G015 INTEGER NOT NULL,
P028G016 INTEGER NOT NULL,
P028H001 INTEGER NOT NULL,
P028H002 INTEGER NOT NULL,
P028H003 INTEGER NOT NULL,
P028H004 INTEGER NOT NULL,
P028H005 INTEGER NOT NULL,
P028H006 INTEGER NOT NULL,
P028H007 INTEGER NOT NULL,
P028H008 INTEGER NOT NULL,
P028H009 INTEGER NOT NULL,
P028H010 INTEGER NOT NULL,
P028H011 INTEGER NOT NULL,
P028H012 INTEGER NOT NULL,
P028H013 INTEGER NOT NULL,
P028H014 INTEGER NOT NULL,
P028H015 INTEGER NOT NULL,
P028H016 INTEGER NOT NULL,
P028I001 INTEGER NOT NULL,
P028I002 INTEGER NOT NULL,
P028I003 INTEGER NOT NULL,
P028I004 INTEGER NOT NULL,
P028I005 INTEGER NOT NULL,
P028I006 INTEGER NOT NULL,
P028I007 INTEGER NOT NULL,
P028I008 INTEGER NOT NULL,
P028I009 INTEGER NOT NULL,
P028I010 INTEGER NOT NULL,
P028I011 INTEGER NOT NULL,
P028I012 INTEGER NOT NULL,
P028I013 INTEGER NOT NULL,
P028I014 INTEGER NOT NULL,
P028I015 INTEGER NOT NULL,
P028I016 INTEGER NOT NULL
);
CREATE TABLE sf1_10 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P029A001 INTEGER NOT NULL,
P029A002 INTEGER NOT NULL,
P029A003 INTEGER NOT NULL,
P029A004 INTEGER NOT NULL,
P029A005 INTEGER NOT NULL,
P029A006 INTEGER NOT NULL,
P029A007 INTEGER NOT NULL,
P029A008 INTEGER NOT NULL,
P029A009 INTEGER NOT NULL,
P029A010 INTEGER NOT NULL,
P029A011 INTEGER NOT NULL,
P029A012 INTEGER NOT NULL,
P029A013 INTEGER NOT NULL,
P029A014 INTEGER NOT NULL,
P029A015 INTEGER NOT NULL,
P029A016 INTEGER NOT NULL,
P029A017 INTEGER NOT NULL,
P029A018 INTEGER NOT NULL,
P029A019 INTEGER NOT NULL,
P029A020 INTEGER NOT NULL,
P029A021 INTEGER NOT NULL,
P029A022 INTEGER NOT NULL,
P029A023 INTEGER NOT NULL,
P029A024 INTEGER NOT NULL,
P029A025 INTEGER NOT NULL,
P029A026 INTEGER NOT NULL,
P029A027 INTEGER NOT NULL,
P029A028 INTEGER NOT NULL,
P029B001 INTEGER NOT NULL,
P029B002 INTEGER NOT NULL,
P029B003 INTEGER NOT NULL,
P029B004 INTEGER NOT NULL,
P029B005 INTEGER NOT NULL,
P029B006 INTEGER NOT NULL,
P029B007 INTEGER NOT NULL,
P029B008 INTEGER NOT NULL,
P029B009 INTEGER NOT NULL,
P029B010 INTEGER NOT NULL,
P029B011 INTEGER NOT NULL,
P029B012 INTEGER NOT NULL,
P029B013 INTEGER NOT NULL,
P029B014 INTEGER NOT NULL,
P029B015 INTEGER NOT NULL,
P029B016 INTEGER NOT NULL,
P029B017 INTEGER NOT NULL,
P029B018 INTEGER NOT NULL,
P029B019 INTEGER NOT NULL,
P029B020 INTEGER NOT NULL,
P029B021 INTEGER NOT NULL,
P029B022 INTEGER NOT NULL,
P029B023 INTEGER NOT NULL,
P029B024 INTEGER NOT NULL,
P029B025 INTEGER NOT NULL,
P029B026 INTEGER NOT NULL,
P029B027 INTEGER NOT NULL,
P029B028 INTEGER NOT NULL,
P029C001 INTEGER NOT NULL,
P029C002 INTEGER NOT NULL,
P029C003 INTEGER NOT NULL,
P029C004 INTEGER NOT NULL,
P029C005 INTEGER NOT NULL,
P029C006 INTEGER NOT NULL,
P029C007 INTEGER NOT NULL,
P029C008 INTEGER NOT NULL,
P029C009 INTEGER NOT NULL,
P029C010 INTEGER NOT NULL,
P029C011 INTEGER NOT NULL,
P029C012 INTEGER NOT NULL,
P029C013 INTEGER NOT NULL,
P029C014 INTEGER NOT NULL,
P029C015 INTEGER NOT NULL,
P029C016 INTEGER NOT NULL,
P029C017 INTEGER NOT NULL,
P029C018 INTEGER NOT NULL,
P029C019 INTEGER NOT NULL,
P029C020 INTEGER NOT NULL,
P029C021 INTEGER NOT NULL,
P029C022 INTEGER NOT NULL,
P029C023 INTEGER NOT NULL,
P029C024 INTEGER NOT NULL,
P029C025 INTEGER NOT NULL,
P029C026 INTEGER NOT NULL,
P029C027 INTEGER NOT NULL,
P029C028 INTEGER NOT NULL,
P029D001 INTEGER NOT NULL,
P029D002 INTEGER NOT NULL,
P029D003 INTEGER NOT NULL,
P029D004 INTEGER NOT NULL,
P029D005 INTEGER NOT NULL,
P029D006 INTEGER NOT NULL,
P029D007 INTEGER NOT NULL,
P029D008 INTEGER NOT NULL,
P029D009 INTEGER NOT NULL,
P029D010 INTEGER NOT NULL,
P029D011 INTEGER NOT NULL,
P029D012 INTEGER NOT NULL,
P029D013 INTEGER NOT NULL,
P029D014 INTEGER NOT NULL,
P029D015 INTEGER NOT NULL,
P029D016 INTEGER NOT NULL,
P029D017 INTEGER NOT NULL,
P029D018 INTEGER NOT NULL,
P029D019 INTEGER NOT NULL,
P029D020 INTEGER NOT NULL,
P029D021 INTEGER NOT NULL,
P029D022 INTEGER NOT NULL,
P029D023 INTEGER NOT NULL,
P029D024 INTEGER NOT NULL,
P029D025 INTEGER NOT NULL,
P029D026 INTEGER NOT NULL,
P029D027 INTEGER NOT NULL,
P029D028 INTEGER NOT NULL,
P029E001 INTEGER NOT NULL,
P029E002 INTEGER NOT NULL,
P029E003 INTEGER NOT NULL,
P029E004 INTEGER NOT NULL,
P029E005 INTEGER NOT NULL,
P029E006 INTEGER NOT NULL,
P029E007 INTEGER NOT NULL,
P029E008 INTEGER NOT NULL,
P029E009 INTEGER NOT NULL,
P029E010 INTEGER NOT NULL,
P029E011 INTEGER NOT NULL,
P029E012 INTEGER NOT NULL,
P029E013 INTEGER NOT NULL,
P029E014 INTEGER NOT NULL,
P029E015 INTEGER NOT NULL,
P029E016 INTEGER NOT NULL,
P029E017 INTEGER NOT NULL,
P029E018 INTEGER NOT NULL,
P029E019 INTEGER NOT NULL,
P029E020 INTEGER NOT NULL,
P029E021 INTEGER NOT NULL,
P029E022 INTEGER NOT NULL,
P029E023 INTEGER NOT NULL,
P029E024 INTEGER NOT NULL,
P029E025 INTEGER NOT NULL,
P029E026 INTEGER NOT NULL,
P029E027 INTEGER NOT NULL,
P029E028 INTEGER NOT NULL,
P029F001 INTEGER NOT NULL,
P029F002 INTEGER NOT NULL,
P029F003 INTEGER NOT NULL,
P029F004 INTEGER NOT NULL,
P029F005 INTEGER NOT NULL,
P029F006 INTEGER NOT NULL,
P029F007 INTEGER NOT NULL,
P029F008 INTEGER NOT NULL,
P029F009 INTEGER NOT NULL,
P029F010 INTEGER NOT NULL,
P029F011 INTEGER NOT NULL,
P029F012 INTEGER NOT NULL,
P029F013 INTEGER NOT NULL,
P029F014 INTEGER NOT NULL,
P029F015 INTEGER NOT NULL,
P029F016 INTEGER NOT NULL,
P029F017 INTEGER NOT NULL,
P029F018 INTEGER NOT NULL,
P029F019 INTEGER NOT NULL,
P029F020 INTEGER NOT NULL,
P029F021 INTEGER NOT NULL,
P029F022 INTEGER NOT NULL,
P029F023 INTEGER NOT NULL,
P029F024 INTEGER NOT NULL,
P029F025 INTEGER NOT NULL,
P029F026 INTEGER NOT NULL,
P029F027 INTEGER NOT NULL,
P029F028 INTEGER NOT NULL,
P029G001 INTEGER NOT NULL,
P029G002 INTEGER NOT NULL,
P029G003 INTEGER NOT NULL,
P029G004 INTEGER NOT NULL,
P029G005 INTEGER NOT NULL,
P029G006 INTEGER NOT NULL,
P029G007 INTEGER NOT NULL,
P029G008 INTEGER NOT NULL,
P029G009 INTEGER NOT NULL,
P029G010 INTEGER NOT NULL,
P029G011 INTEGER NOT NULL,
P029G012 INTEGER NOT NULL,
P029G013 INTEGER NOT NULL,
P029G014 INTEGER NOT NULL,
P029G015 INTEGER NOT NULL,
P029G016 INTEGER NOT NULL,
P029G017 INTEGER NOT NULL,
P029G018 INTEGER NOT NULL,
P029G019 INTEGER NOT NULL,
P029G020 INTEGER NOT NULL,
P029G021 INTEGER NOT NULL,
P029G022 INTEGER NOT NULL,
P029G023 INTEGER NOT NULL,
P029G024 INTEGER NOT NULL,
P029G025 INTEGER NOT NULL,
P029G026 INTEGER NOT NULL,
P029G027 INTEGER NOT NULL,
P029G028 INTEGER NOT NULL,
P029H001 INTEGER NOT NULL,
P029H002 INTEGER NOT NULL,
P029H003 INTEGER NOT NULL,
P029H004 INTEGER NOT NULL,
P029H005 INTEGER NOT NULL,
P029H006 INTEGER NOT NULL,
P029H007 INTEGER NOT NULL,
P029H008 INTEGER NOT NULL,
P029H009 INTEGER NOT NULL,
P029H010 INTEGER NOT NULL,
P029H011 INTEGER NOT NULL,
P029H012 INTEGER NOT NULL,
P029H013 INTEGER NOT NULL,
P029H014 INTEGER NOT NULL,
P029H015 INTEGER NOT NULL,
P029H016 INTEGER NOT NULL,
P029H017 INTEGER NOT NULL,
P029H018 INTEGER NOT NULL,
P029H019 INTEGER NOT NULL,
P029H020 INTEGER NOT NULL,
P029H021 INTEGER NOT NULL,
P029H022 INTEGER NOT NULL,
P029H023 INTEGER NOT NULL,
P029H024 INTEGER NOT NULL,
P029H025 INTEGER NOT NULL,
P029H026 INTEGER NOT NULL,
P029H027 INTEGER NOT NULL,
P029H028 INTEGER NOT NULL,
P029I001 INTEGER NOT NULL,
P029I002 INTEGER NOT NULL,
P029I003 INTEGER NOT NULL,
P029I004 INTEGER NOT NULL,
P029I005 INTEGER NOT NULL,
P029I006 INTEGER NOT NULL,
P029I007 INTEGER NOT NULL,
P029I008 INTEGER NOT NULL,
P029I009 INTEGER NOT NULL,
P029I010 INTEGER NOT NULL,
P029I011 INTEGER NOT NULL,
P029I012 INTEGER NOT NULL,
P029I013 INTEGER NOT NULL,
P029I014 INTEGER NOT NULL,
P029I015 INTEGER NOT NULL,
P029I016 INTEGER NOT NULL,
P029I017 INTEGER NOT NULL,
P029I018 INTEGER NOT NULL,
P029I019 INTEGER NOT NULL,
P029I020 INTEGER NOT NULL,
P029I021 INTEGER NOT NULL,
P029I022 INTEGER NOT NULL,
P029I023 INTEGER NOT NULL,
P029I024 INTEGER NOT NULL,
P029I025 INTEGER NOT NULL,
P029I026 INTEGER NOT NULL,
P029I027 INTEGER NOT NULL,
P029I028 INTEGER NOT NULL
);
CREATE TABLE sf1_11 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P031A001 INTEGER NOT NULL,
P031A002 INTEGER NOT NULL,
P031A003 INTEGER NOT NULL,
P031A004 INTEGER NOT NULL,
P031A005 INTEGER NOT NULL,
P031A006 INTEGER NOT NULL,
P031A007 INTEGER NOT NULL,
P031A008 INTEGER NOT NULL,
P031A009 INTEGER NOT NULL,
P031A010 INTEGER NOT NULL,
P031A011 INTEGER NOT NULL,
P031A012 INTEGER NOT NULL,
P031A013 INTEGER NOT NULL,
P031A014 INTEGER NOT NULL,
P031A015 INTEGER NOT NULL,
P031A016 INTEGER NOT NULL,
P031B001 INTEGER NOT NULL,
P031B002 INTEGER NOT NULL,
P031B003 INTEGER NOT NULL,
P031B004 INTEGER NOT NULL,
P031B005 INTEGER NOT NULL,
P031B006 INTEGER NOT NULL,
P031B007 INTEGER NOT NULL,
P031B008 INTEGER NOT NULL,
P031B009 INTEGER NOT NULL,
P031B010 INTEGER NOT NULL,
P031B011 INTEGER NOT NULL,
P031B012 INTEGER NOT NULL,
P031B013 INTEGER NOT NULL,
P031B014 INTEGER NOT NULL,
P031B015 INTEGER NOT NULL,
P031B016 INTEGER NOT NULL,
P031C001 INTEGER NOT NULL,
P031C002 INTEGER NOT NULL,
P031C003 INTEGER NOT NULL,
P031C004 INTEGER NOT NULL,
P031C005 INTEGER NOT NULL,
P031C006 INTEGER NOT NULL,
P031C007 INTEGER NOT NULL,
P031C008 INTEGER NOT NULL,
P031C009 INTEGER NOT NULL,
P031C010 INTEGER NOT NULL,
P031C011 INTEGER NOT NULL,
P031C012 INTEGER NOT NULL,
P031C013 INTEGER NOT NULL,
P031C014 INTEGER NOT NULL,
P031C015 INTEGER NOT NULL,
P031C016 INTEGER NOT NULL,
P031D001 INTEGER NOT NULL,
P031D002 INTEGER NOT NULL,
P031D003 INTEGER NOT NULL,
P031D004 INTEGER NOT NULL,
P031D005 INTEGER NOT NULL,
P031D006 INTEGER NOT NULL,
P031D007 INTEGER NOT NULL,
P031D008 INTEGER NOT NULL,
P031D009 INTEGER NOT NULL,
P031D010 INTEGER NOT NULL,
P031D011 INTEGER NOT NULL,
P031D012 INTEGER NOT NULL,
P031D013 INTEGER NOT NULL,
P031D014 INTEGER NOT NULL,
P031D015 INTEGER NOT NULL,
P031D016 INTEGER NOT NULL,
P031E001 INTEGER NOT NULL,
P031E002 INTEGER NOT NULL,
P031E003 INTEGER NOT NULL,
P031E004 INTEGER NOT NULL,
P031E005 INTEGER NOT NULL,
P031E006 INTEGER NOT NULL,
P031E007 INTEGER NOT NULL,
P031E008 INTEGER NOT NULL,
P031E009 INTEGER NOT NULL,
P031E010 INTEGER NOT NULL,
P031E011 INTEGER NOT NULL,
P031E012 INTEGER NOT NULL,
P031E013 INTEGER NOT NULL,
P031E014 INTEGER NOT NULL,
P031E015 INTEGER NOT NULL,
P031E016 INTEGER NOT NULL,
P031F001 INTEGER NOT NULL,
P031F002 INTEGER NOT NULL,
P031F003 INTEGER NOT NULL,
P031F004 INTEGER NOT NULL,
P031F005 INTEGER NOT NULL,
P031F006 INTEGER NOT NULL,
P031F007 INTEGER NOT NULL,
P031F008 INTEGER NOT NULL,
P031F009 INTEGER NOT NULL,
P031F010 INTEGER NOT NULL,
P031F011 INTEGER NOT NULL,
P031F012 INTEGER NOT NULL,
P031F013 INTEGER NOT NULL,
P031F014 INTEGER NOT NULL,
P031F015 INTEGER NOT NULL,
P031F016 INTEGER NOT NULL,
P031G001 INTEGER NOT NULL,
P031G002 INTEGER NOT NULL,
P031G003 INTEGER NOT NULL,
P031G004 INTEGER NOT NULL,
P031G005 INTEGER NOT NULL,
P031G006 INTEGER NOT NULL,
P031G007 INTEGER NOT NULL,
P031G008 INTEGER NOT NULL,
P031G009 INTEGER NOT NULL,
P031G010 INTEGER NOT NULL,
P031G011 INTEGER NOT NULL,
P031G012 INTEGER NOT NULL,
P031G013 INTEGER NOT NULL,
P031G014 INTEGER NOT NULL,
P031G015 INTEGER NOT NULL,
P031G016 INTEGER NOT NULL,
P031H001 INTEGER NOT NULL,
P031H002 INTEGER NOT NULL,
P031H003 INTEGER NOT NULL,
P031H004 INTEGER NOT NULL,
P031H005 INTEGER NOT NULL,
P031H006 INTEGER NOT NULL,
P031H007 INTEGER NOT NULL,
P031H008 INTEGER NOT NULL,
P031H009 INTEGER NOT NULL,
P031H010 INTEGER NOT NULL,
P031H011 INTEGER NOT NULL,
P031H012 INTEGER NOT NULL,
P031H013 INTEGER NOT NULL,
P031H014 INTEGER NOT NULL,
P031H015 INTEGER NOT NULL,
P031H016 INTEGER NOT NULL,
P031I001 INTEGER NOT NULL,
P031I002 INTEGER NOT NULL,
P031I003 INTEGER NOT NULL,
P031I004 INTEGER NOT NULL,
P031I005 INTEGER NOT NULL,
P031I006 INTEGER NOT NULL,
P031I007 INTEGER NOT NULL,
P031I008 INTEGER NOT NULL,
P031I009 INTEGER NOT NULL,
P031I010 INTEGER NOT NULL,
P031I011 INTEGER NOT NULL,
P031I012 INTEGER NOT NULL,
P031I013 INTEGER NOT NULL,
P031I014 INTEGER NOT NULL,
P031I015 INTEGER NOT NULL,
P031I016 INTEGER NOT NULL,
P034A001 INTEGER NOT NULL,
P034A002 INTEGER NOT NULL,
P034A003 INTEGER NOT NULL,
P034A004 INTEGER NOT NULL,
P034A005 INTEGER NOT NULL,
P034A006 INTEGER NOT NULL,
P034A007 INTEGER NOT NULL,
P034A008 INTEGER NOT NULL,
P034A009 INTEGER NOT NULL,
P034A010 INTEGER NOT NULL,
P034A011 INTEGER NOT NULL,
P034A012 INTEGER NOT NULL,
P034A013 INTEGER NOT NULL,
P034A014 INTEGER NOT NULL,
P034A015 INTEGER NOT NULL,
P034A016 INTEGER NOT NULL,
P034A017 INTEGER NOT NULL,
P034A018 INTEGER NOT NULL,
P034A019 INTEGER NOT NULL,
P034A020 INTEGER NOT NULL,
P034A021 INTEGER NOT NULL,
P034A022 INTEGER NOT NULL,
P034B001 INTEGER NOT NULL,
P034B002 INTEGER NOT NULL,
P034B003 INTEGER NOT NULL,
P034B004 INTEGER NOT NULL,
P034B005 INTEGER NOT NULL,
P034B006 INTEGER NOT NULL,
P034B007 INTEGER NOT NULL,
P034B008 INTEGER NOT NULL,
P034B009 INTEGER NOT NULL,
P034B010 INTEGER NOT NULL,
P034B011 INTEGER NOT NULL,
P034B012 INTEGER NOT NULL,
P034B013 INTEGER NOT NULL,
P034B014 INTEGER NOT NULL,
P034B015 INTEGER NOT NULL,
P034B016 INTEGER NOT NULL,
P034B017 INTEGER NOT NULL,
P034B018 INTEGER NOT NULL,
P034B019 INTEGER NOT NULL,
P034B020 INTEGER NOT NULL,
P034B021 INTEGER NOT NULL,
P034B022 INTEGER NOT NULL,
P034C001 INTEGER NOT NULL,
P034C002 INTEGER NOT NULL,
P034C003 INTEGER NOT NULL,
P034C004 INTEGER NOT NULL,
P034C005 INTEGER NOT NULL,
P034C006 INTEGER NOT NULL,
P034C007 INTEGER NOT NULL,
P034C008 INTEGER NOT NULL,
P034C009 INTEGER NOT NULL,
P034C010 INTEGER NOT NULL,
P034C011 INTEGER NOT NULL,
P034C012 INTEGER NOT NULL,
P034C013 INTEGER NOT NULL,
P034C014 INTEGER NOT NULL,
P034C015 INTEGER NOT NULL,
P034C016 INTEGER NOT NULL,
P034C017 INTEGER NOT NULL,
P034C018 INTEGER NOT NULL,
P034C019 INTEGER NOT NULL,
P034C020 INTEGER NOT NULL,
P034C021 INTEGER NOT NULL,
P034C022 INTEGER NOT NULL,
P034D001 INTEGER NOT NULL,
P034D002 INTEGER NOT NULL,
P034D003 INTEGER NOT NULL,
P034D004 INTEGER NOT NULL,
P034D005 INTEGER NOT NULL,
P034D006 INTEGER NOT NULL,
P034D007 INTEGER NOT NULL,
P034D008 INTEGER NOT NULL,
P034D009 INTEGER NOT NULL,
P034D010 INTEGER NOT NULL,
P034D011 INTEGER NOT NULL,
P034D012 INTEGER NOT NULL,
P034D013 INTEGER NOT NULL,
P034D014 INTEGER NOT NULL,
P034D015 INTEGER NOT NULL,
P034D016 INTEGER NOT NULL,
P034D017 INTEGER NOT NULL,
P034D018 INTEGER NOT NULL,
P034D019 INTEGER NOT NULL,
P034D020 INTEGER NOT NULL,
P034D021 INTEGER NOT NULL,
P034D022 INTEGER NOT NULL,
P034E001 INTEGER NOT NULL,
P034E002 INTEGER NOT NULL,
P034E003 INTEGER NOT NULL,
P034E004 INTEGER NOT NULL,
P034E005 INTEGER NOT NULL,
P034E006 INTEGER NOT NULL,
P034E007 INTEGER NOT NULL,
P034E008 INTEGER NOT NULL,
P034E009 INTEGER NOT NULL,
P034E010 INTEGER NOT NULL,
P034E011 INTEGER NOT NULL,
P034E012 INTEGER NOT NULL,
P034E013 INTEGER NOT NULL,
P034E014 INTEGER NOT NULL,
P034E015 INTEGER NOT NULL,
P034E016 INTEGER NOT NULL,
P034E017 INTEGER NOT NULL,
P034E018 INTEGER NOT NULL,
P034E019 INTEGER NOT NULL,
P034E020 INTEGER NOT NULL,
P034E021 INTEGER NOT NULL,
P034E022 INTEGER NOT NULL
);
CREATE TABLE sf1_12 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P034F001 INTEGER NOT NULL,
P034F002 INTEGER NOT NULL,
P034F003 INTEGER NOT NULL,
P034F004 INTEGER NOT NULL,
P034F005 INTEGER NOT NULL,
P034F006 INTEGER NOT NULL,
P034F007 INTEGER NOT NULL,
P034F008 INTEGER NOT NULL,
P034F009 INTEGER NOT NULL,
P034F010 INTEGER NOT NULL,
P034F011 INTEGER NOT NULL,
P034F012 INTEGER NOT NULL,
P034F013 INTEGER NOT NULL,
P034F014 INTEGER NOT NULL,
P034F015 INTEGER NOT NULL,
P034F016 INTEGER NOT NULL,
P034F017 INTEGER NOT NULL,
P034F018 INTEGER NOT NULL,
P034F019 INTEGER NOT NULL,
P034F020 INTEGER NOT NULL,
P034F021 INTEGER NOT NULL,
P034F022 INTEGER NOT NULL,
P034G001 INTEGER NOT NULL,
P034G002 INTEGER NOT NULL,
P034G003 INTEGER NOT NULL,
P034G004 INTEGER NOT NULL,
P034G005 INTEGER NOT NULL,
P034G006 INTEGER NOT NULL,
P034G007 INTEGER NOT NULL,
P034G008 INTEGER NOT NULL,
P034G009 INTEGER NOT NULL,
P034G010 INTEGER NOT NULL,
P034G011 INTEGER NOT NULL,
P034G012 INTEGER NOT NULL,
P034G013 INTEGER NOT NULL,
P034G014 INTEGER NOT NULL,
P034G015 INTEGER NOT NULL,
P034G016 INTEGER NOT NULL,
P034G017 INTEGER NOT NULL,
P034G018 INTEGER NOT NULL,
P034G019 INTEGER NOT NULL,
P034G020 INTEGER NOT NULL,
P034G021 INTEGER NOT NULL,
P034G022 INTEGER NOT NULL,
P034H001 INTEGER NOT NULL,
P034H002 INTEGER NOT NULL,
P034H003 INTEGER NOT NULL,
P034H004 INTEGER NOT NULL,
P034H005 INTEGER NOT NULL,
P034H006 INTEGER NOT NULL,
P034H007 INTEGER NOT NULL,
P034H008 INTEGER NOT NULL,
P034H009 INTEGER NOT NULL,
P034H010 INTEGER NOT NULL,
P034H011 INTEGER NOT NULL,
P034H012 INTEGER NOT NULL,
P034H013 INTEGER NOT NULL,
P034H014 INTEGER NOT NULL,
P034H015 INTEGER NOT NULL,
P034H016 INTEGER NOT NULL,
P034H017 INTEGER NOT NULL,
P034H018 INTEGER NOT NULL,
P034H019 INTEGER NOT NULL,
P034H020 INTEGER NOT NULL,
P034H021 INTEGER NOT NULL,
P034H022 INTEGER NOT NULL,
P034I001 INTEGER NOT NULL,
P034I002 INTEGER NOT NULL,
P034I003 INTEGER NOT NULL,
P034I004 INTEGER NOT NULL,
P034I005 INTEGER NOT NULL,
P034I006 INTEGER NOT NULL,
P034I007 INTEGER NOT NULL,
P034I008 INTEGER NOT NULL,
P034I009 INTEGER NOT NULL,
P034I010 INTEGER NOT NULL,
P034I011 INTEGER NOT NULL,
P034I012 INTEGER NOT NULL,
P034I013 INTEGER NOT NULL,
P034I014 INTEGER NOT NULL,
P034I015 INTEGER NOT NULL,
P034I016 INTEGER NOT NULL,
P034I017 INTEGER NOT NULL,
P034I018 INTEGER NOT NULL,
P034I019 INTEGER NOT NULL,
P034I020 INTEGER NOT NULL,
P034I021 INTEGER NOT NULL,
P034I022 INTEGER NOT NULL,
P035A001 INTEGER NOT NULL,
P035B001 INTEGER NOT NULL,
P035C001 INTEGER NOT NULL,
P035D001 INTEGER NOT NULL,
P035E001 INTEGER NOT NULL,
P035F001 INTEGER NOT NULL,
P035G001 INTEGER NOT NULL,
P035H001 INTEGER NOT NULL,
P035I001 INTEGER NOT NULL,
P036A001 INTEGER NOT NULL,
P036A002 INTEGER NOT NULL,
P036A003 INTEGER NOT NULL,
P036B001 INTEGER NOT NULL,
P036B002 INTEGER NOT NULL,
P036B003 INTEGER NOT NULL,
P036C001 INTEGER NOT NULL,
P036C002 INTEGER NOT NULL,
P036C003 INTEGER NOT NULL,
P036D001 INTEGER NOT NULL,
P036D002 INTEGER NOT NULL,
P036D003 INTEGER NOT NULL,
P036E001 INTEGER NOT NULL,
P036E002 INTEGER NOT NULL,
P036E003 INTEGER NOT NULL,
P036F001 INTEGER NOT NULL,
P036F002 INTEGER NOT NULL,
P036F003 INTEGER NOT NULL,
P036G001 INTEGER NOT NULL,
P036G002 INTEGER NOT NULL,
P036G003 INTEGER NOT NULL,
P036H001 INTEGER NOT NULL,
P036H002 INTEGER NOT NULL,
P036H003 INTEGER NOT NULL,
P036I001 INTEGER NOT NULL,
P036I002 INTEGER NOT NULL,
P036I003 INTEGER NOT NULL,
P037A001 FLOAT NOT NULL,
P037A002 FLOAT NOT NULL,
P037A003 FLOAT NOT NULL,
P037B001 FLOAT NOT NULL,
P037B002 FLOAT NOT NULL,
P037B003 FLOAT NOT NULL,
P037C001 FLOAT NOT NULL,
P037C002 FLOAT NOT NULL,
P037C003 FLOAT NOT NULL,
P037D001 FLOAT NOT NULL,
P037D002 FLOAT NOT NULL,
P037D003 FLOAT NOT NULL,
P037E001 FLOAT NOT NULL,
P037E002 FLOAT NOT NULL,
P037E003 FLOAT NOT NULL,
P037F001 FLOAT NOT NULL,
P037F002 FLOAT NOT NULL,
P037F003 FLOAT NOT NULL,
P037G001 FLOAT NOT NULL,
P037G002 FLOAT NOT NULL,
P037G003 FLOAT NOT NULL,
P037H001 FLOAT NOT NULL,
P037H002 FLOAT NOT NULL,
P037H003 FLOAT NOT NULL,
P037I001 FLOAT NOT NULL,
P037I002 FLOAT NOT NULL,
P037I003 FLOAT NOT NULL,
P038A001 INTEGER NOT NULL,
P038A002 INTEGER NOT NULL,
P038A003 INTEGER NOT NULL,
P038A004 INTEGER NOT NULL,
P038A005 INTEGER NOT NULL,
P038A006 INTEGER NOT NULL,
P038A007 INTEGER NOT NULL,
P038A008 INTEGER NOT NULL,
P038A009 INTEGER NOT NULL,
P038A010 INTEGER NOT NULL,
P038A011 INTEGER NOT NULL,
P038A012 INTEGER NOT NULL,
P038A013 INTEGER NOT NULL,
P038A014 INTEGER NOT NULL,
P038A015 INTEGER NOT NULL,
P038A016 INTEGER NOT NULL,
P038A017 INTEGER NOT NULL,
P038A018 INTEGER NOT NULL,
P038A019 INTEGER NOT NULL,
P038A020 INTEGER NOT NULL,
P038B001 INTEGER NOT NULL,
P038B002 INTEGER NOT NULL,
P038B003 INTEGER NOT NULL,
P038B004 INTEGER NOT NULL,
P038B005 INTEGER NOT NULL,
P038B006 INTEGER NOT NULL,
P038B007 INTEGER NOT NULL,
P038B008 INTEGER NOT NULL,
P038B009 INTEGER NOT NULL,
P038B010 INTEGER NOT NULL,
P038B011 INTEGER NOT NULL,
P038B012 INTEGER NOT NULL,
P038B013 INTEGER NOT NULL,
P038B014 INTEGER NOT NULL,
P038B015 INTEGER NOT NULL,
P038B016 INTEGER NOT NULL,
P038B017 INTEGER NOT NULL,
P038B018 INTEGER NOT NULL,
P038B019 INTEGER NOT NULL,
P038B020 INTEGER NOT NULL,
P038C001 INTEGER NOT NULL,
P038C002 INTEGER NOT NULL,
P038C003 INTEGER NOT NULL,
P038C004 INTEGER NOT NULL,
P038C005 INTEGER NOT NULL,
P038C006 INTEGER NOT NULL,
P038C007 INTEGER NOT NULL,
P038C008 INTEGER NOT NULL,
P038C009 INTEGER NOT NULL,
P038C010 INTEGER NOT NULL,
P038C011 INTEGER NOT NULL,
P038C012 INTEGER NOT NULL,
P038C013 INTEGER NOT NULL,
P038C014 INTEGER NOT NULL,
P038C015 INTEGER NOT NULL,
P038C016 INTEGER NOT NULL,
P038C017 INTEGER NOT NULL,
P038C018 INTEGER NOT NULL,
P038C019 INTEGER NOT NULL,
P038C020 INTEGER NOT NULL,
P038D001 INTEGER NOT NULL,
P038D002 INTEGER NOT NULL,
P038D003 INTEGER NOT NULL,
P038D004 INTEGER NOT NULL,
P038D005 INTEGER NOT NULL,
P038D006 INTEGER NOT NULL,
P038D007 INTEGER NOT NULL,
P038D008 INTEGER NOT NULL,
P038D009 INTEGER NOT NULL,
P038D010 INTEGER NOT NULL,
P038D011 INTEGER NOT NULL,
P038D012 INTEGER NOT NULL,
P038D013 INTEGER NOT NULL,
P038D014 INTEGER NOT NULL,
P038D015 INTEGER NOT NULL,
P038D016 INTEGER NOT NULL,
P038D017 INTEGER NOT NULL,
P038D018 INTEGER NOT NULL,
P038D019 INTEGER NOT NULL,
P038D020 INTEGER NOT NULL,
P038E001 INTEGER NOT NULL,
P038E002 INTEGER NOT NULL,
P038E003 INTEGER NOT NULL,
P038E004 INTEGER NOT NULL,
P038E005 INTEGER NOT NULL,
P038E006 INTEGER NOT NULL,
P038E007 INTEGER NOT NULL,
P038E008 INTEGER NOT NULL,
P038E009 INTEGER NOT NULL,
P038E010 INTEGER NOT NULL,
P038E011 INTEGER NOT NULL,
P038E012 INTEGER NOT NULL,
P038E013 INTEGER NOT NULL,
P038E014 INTEGER NOT NULL,
P038E015 INTEGER NOT NULL,
P038E016 INTEGER NOT NULL,
P038E017 INTEGER NOT NULL,
P038E018 INTEGER NOT NULL,
P038E019 INTEGER NOT NULL,
P038E020 INTEGER NOT NULL
);
CREATE TABLE sf1_13 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P038F001 INTEGER NOT NULL,
P038F002 INTEGER NOT NULL,
P038F003 INTEGER NOT NULL,
P038F004 INTEGER NOT NULL,
P038F005 INTEGER NOT NULL,
P038F006 INTEGER NOT NULL,
P038F007 INTEGER NOT NULL,
P038F008 INTEGER NOT NULL,
P038F009 INTEGER NOT NULL,
P038F010 INTEGER NOT NULL,
P038F011 INTEGER NOT NULL,
P038F012 INTEGER NOT NULL,
P038F013 INTEGER NOT NULL,
P038F014 INTEGER NOT NULL,
P038F015 INTEGER NOT NULL,
P038F016 INTEGER NOT NULL,
P038F017 INTEGER NOT NULL,
P038F018 INTEGER NOT NULL,
P038F019 INTEGER NOT NULL,
P038F020 INTEGER NOT NULL,
P038G001 INTEGER NOT NULL,
P038G002 INTEGER NOT NULL,
P038G003 INTEGER NOT NULL,
P038G004 INTEGER NOT NULL,
P038G005 INTEGER NOT NULL,
P038G006 INTEGER NOT NULL,
P038G007 INTEGER NOT NULL,
P038G008 INTEGER NOT NULL,
P038G009 INTEGER NOT NULL,
P038G010 INTEGER NOT NULL,
P038G011 INTEGER NOT NULL,
P038G012 INTEGER NOT NULL,
P038G013 INTEGER NOT NULL,
P038G014 INTEGER NOT NULL,
P038G015 INTEGER NOT NULL,
P038G016 INTEGER NOT NULL,
P038G017 INTEGER NOT NULL,
P038G018 INTEGER NOT NULL,
P038G019 INTEGER NOT NULL,
P038G020 INTEGER NOT NULL,
P038H001 INTEGER NOT NULL,
P038H002 INTEGER NOT NULL,
P038H003 INTEGER NOT NULL,
P038H004 INTEGER NOT NULL,
P038H005 INTEGER NOT NULL,
P038H006 INTEGER NOT NULL,
P038H007 INTEGER NOT NULL,
P038H008 INTEGER NOT NULL,
P038H009 INTEGER NOT NULL,
P038H010 INTEGER NOT NULL,
P038H011 INTEGER NOT NULL,
P038H012 INTEGER NOT NULL,
P038H013 INTEGER NOT NULL,
P038H014 INTEGER NOT NULL,
P038H015 INTEGER NOT NULL,
P038H016 INTEGER NOT NULL,
P038H017 INTEGER NOT NULL,
P038H018 INTEGER NOT NULL,
P038H019 INTEGER NOT NULL,
P038H020 INTEGER NOT NULL,
P038I001 INTEGER NOT NULL,
P038I002 INTEGER NOT NULL,
P038I003 INTEGER NOT NULL,
P038I004 INTEGER NOT NULL,
P038I005 INTEGER NOT NULL,
P038I006 INTEGER NOT NULL,
P038I007 INTEGER NOT NULL,
P038I008 INTEGER NOT NULL,
P038I009 INTEGER NOT NULL,
P038I010 INTEGER NOT NULL,
P038I011 INTEGER NOT NULL,
P038I012 INTEGER NOT NULL,
P038I013 INTEGER NOT NULL,
P038I014 INTEGER NOT NULL,
P038I015 INTEGER NOT NULL,
P038I016 INTEGER NOT NULL,
P038I017 INTEGER NOT NULL,
P038I018 INTEGER NOT NULL,
P038I019 INTEGER NOT NULL,
P038I020 INTEGER NOT NULL,
P039A001 INTEGER NOT NULL,
P039A002 INTEGER NOT NULL,
P039A003 INTEGER NOT NULL,
P039A004 INTEGER NOT NULL,
P039A005 INTEGER NOT NULL,
P039A006 INTEGER NOT NULL,
P039A007 INTEGER NOT NULL,
P039A008 INTEGER NOT NULL,
P039A009 INTEGER NOT NULL,
P039A010 INTEGER NOT NULL,
P039A011 INTEGER NOT NULL,
P039A012 INTEGER NOT NULL,
P039A013 INTEGER NOT NULL,
P039A014 INTEGER NOT NULL,
P039A015 INTEGER NOT NULL,
P039A016 INTEGER NOT NULL,
P039A017 INTEGER NOT NULL,
P039A018 INTEGER NOT NULL,
P039A019 INTEGER NOT NULL,
P039A020 INTEGER NOT NULL,
P039B001 INTEGER NOT NULL,
P039B002 INTEGER NOT NULL,
P039B003 INTEGER NOT NULL,
P039B004 INTEGER NOT NULL,
P039B005 INTEGER NOT NULL,
P039B006 INTEGER NOT NULL,
P039B007 INTEGER NOT NULL,
P039B008 INTEGER NOT NULL,
P039B009 INTEGER NOT NULL,
P039B010 INTEGER NOT NULL,
P039B011 INTEGER NOT NULL,
P039B012 INTEGER NOT NULL,
P039B013 INTEGER NOT NULL,
P039B014 INTEGER NOT NULL,
P039B015 INTEGER NOT NULL,
P039B016 INTEGER NOT NULL,
P039B017 INTEGER NOT NULL,
P039B018 INTEGER NOT NULL,
P039B019 INTEGER NOT NULL,
P039B020 INTEGER NOT NULL,
P039C001 INTEGER NOT NULL,
P039C002 INTEGER NOT NULL,
P039C003 INTEGER NOT NULL,
P039C004 INTEGER NOT NULL,
P039C005 INTEGER NOT NULL,
P039C006 INTEGER NOT NULL,
P039C007 INTEGER NOT NULL,
P039C008 INTEGER NOT NULL,
P039C009 INTEGER NOT NULL,
P039C010 INTEGER NOT NULL,
P039C011 INTEGER NOT NULL,
P039C012 INTEGER NOT NULL,
P039C013 INTEGER NOT NULL,
P039C014 INTEGER NOT NULL,
P039C015 INTEGER NOT NULL,
P039C016 INTEGER NOT NULL,
P039C017 INTEGER NOT NULL,
P039C018 INTEGER NOT NULL,
P039C019 INTEGER NOT NULL,
P039C020 INTEGER NOT NULL,
P039D001 INTEGER NOT NULL,
P039D002 INTEGER NOT NULL,
P039D003 INTEGER NOT NULL,
P039D004 INTEGER NOT NULL,
P039D005 INTEGER NOT NULL,
P039D006 INTEGER NOT NULL,
P039D007 INTEGER NOT NULL,
P039D008 INTEGER NOT NULL,
P039D009 INTEGER NOT NULL,
P039D010 INTEGER NOT NULL,
P039D011 INTEGER NOT NULL,
P039D012 INTEGER NOT NULL,
P039D013 INTEGER NOT NULL,
P039D014 INTEGER NOT NULL,
P039D015 INTEGER NOT NULL,
P039D016 INTEGER NOT NULL,
P039D017 INTEGER NOT NULL,
P039D018 INTEGER NOT NULL,
P039D019 INTEGER NOT NULL,
P039D020 INTEGER NOT NULL,
P039E001 INTEGER NOT NULL,
P039E002 INTEGER NOT NULL,
P039E003 INTEGER NOT NULL,
P039E004 INTEGER NOT NULL,
P039E005 INTEGER NOT NULL,
P039E006 INTEGER NOT NULL,
P039E007 INTEGER NOT NULL,
P039E008 INTEGER NOT NULL,
P039E009 INTEGER NOT NULL,
P039E010 INTEGER NOT NULL,
P039E011 INTEGER NOT NULL,
P039E012 INTEGER NOT NULL,
P039E013 INTEGER NOT NULL,
P039E014 INTEGER NOT NULL,
P039E015 INTEGER NOT NULL,
P039E016 INTEGER NOT NULL,
P039E017 INTEGER NOT NULL,
P039E018 INTEGER NOT NULL,
P039E019 INTEGER NOT NULL,
P039E020 INTEGER NOT NULL,
P039F001 INTEGER NOT NULL,
P039F002 INTEGER NOT NULL,
P039F003 INTEGER NOT NULL,
P039F004 INTEGER NOT NULL,
P039F005 INTEGER NOT NULL,
P039F006 INTEGER NOT NULL,
P039F007 INTEGER NOT NULL,
P039F008 INTEGER NOT NULL,
P039F009 INTEGER NOT NULL,
P039F010 INTEGER NOT NULL,
P039F011 INTEGER NOT NULL,
P039F012 INTEGER NOT NULL,
P039F013 INTEGER NOT NULL,
P039F014 INTEGER NOT NULL,
P039F015 INTEGER NOT NULL,
P039F016 INTEGER NOT NULL,
P039F017 INTEGER NOT NULL,
P039F018 INTEGER NOT NULL,
P039F019 INTEGER NOT NULL,
P039F020 INTEGER NOT NULL,
P039G001 INTEGER NOT NULL,
P039G002 INTEGER NOT NULL,
P039G003 INTEGER NOT NULL,
P039G004 INTEGER NOT NULL,
P039G005 INTEGER NOT NULL,
P039G006 INTEGER NOT NULL,
P039G007 INTEGER NOT NULL,
P039G008 INTEGER NOT NULL,
P039G009 INTEGER NOT NULL,
P039G010 INTEGER NOT NULL,
P039G011 INTEGER NOT NULL,
P039G012 INTEGER NOT NULL,
P039G013 INTEGER NOT NULL,
P039G014 INTEGER NOT NULL,
P039G015 INTEGER NOT NULL,
P039G016 INTEGER NOT NULL,
P039G017 INTEGER NOT NULL,
P039G018 INTEGER NOT NULL,
P039G019 INTEGER NOT NULL,
P039G020 INTEGER NOT NULL,
P039H001 INTEGER NOT NULL,
P039H002 INTEGER NOT NULL,
P039H003 INTEGER NOT NULL,
P039H004 INTEGER NOT NULL,
P039H005 INTEGER NOT NULL,
P039H006 INTEGER NOT NULL,
P039H007 INTEGER NOT NULL,
P039H008 INTEGER NOT NULL,
P039H009 INTEGER NOT NULL,
P039H010 INTEGER NOT NULL,
P039H011 INTEGER NOT NULL,
P039H012 INTEGER NOT NULL,
P039H013 INTEGER NOT NULL,
P039H014 INTEGER NOT NULL,
P039H015 INTEGER NOT NULL,
P039H016 INTEGER NOT NULL,
P039H017 INTEGER NOT NULL,
P039H018 INTEGER NOT NULL,
P039H019 INTEGER NOT NULL,
P039H020 INTEGER NOT NULL
);
CREATE TABLE sf1_14 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P039I001 INTEGER NOT NULL,
P039I002 INTEGER NOT NULL,
P039I003 INTEGER NOT NULL,
P039I004 INTEGER NOT NULL,
P039I005 INTEGER NOT NULL,
P039I006 INTEGER NOT NULL,
P039I007 INTEGER NOT NULL,
P039I008 INTEGER NOT NULL,
P039I009 INTEGER NOT NULL,
P039I010 INTEGER NOT NULL,
P039I011 INTEGER NOT NULL,
P039I012 INTEGER NOT NULL,
P039I013 INTEGER NOT NULL,
P039I014 INTEGER NOT NULL,
P039I015 INTEGER NOT NULL,
P039I016 INTEGER NOT NULL,
P039I017 INTEGER NOT NULL,
P039I018 INTEGER NOT NULL,
P039I019 INTEGER NOT NULL,
P039I020 INTEGER NOT NULL
);
CREATE TABLE sf1_15 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
PCT001001 INTEGER NOT NULL,
PCT001002 INTEGER NOT NULL,
PCT001003 INTEGER NOT NULL,
PCT001004 INTEGER NOT NULL,
PCT001005 INTEGER NOT NULL,
PCT001006 INTEGER NOT NULL,
PCT001007 INTEGER NOT NULL,
PCT001008 INTEGER NOT NULL,
PCT001009 INTEGER NOT NULL,
PCT001010 INTEGER NOT NULL,
PCT001011 INTEGER NOT NULL,
PCT001012 INTEGER NOT NULL,
PCT001013 INTEGER NOT NULL,
PCT001014 INTEGER NOT NULL,
PCT001015 INTEGER NOT NULL,
PCT001016 INTEGER NOT NULL,
PCT001017 INTEGER NOT NULL,
PCT001018 INTEGER NOT NULL,
PCT001019 INTEGER NOT NULL,
PCT001020 INTEGER NOT NULL,
PCT001021 INTEGER NOT NULL,
PCT001022 INTEGER NOT NULL,
PCT001023 INTEGER NOT NULL,
PCT001024 INTEGER NOT NULL,
PCT001025 INTEGER NOT NULL,
PCT001026 INTEGER NOT NULL,
PCT001027 INTEGER NOT NULL,
PCT001028 INTEGER NOT NULL,
PCT001029 INTEGER NOT NULL,
PCT001030 INTEGER NOT NULL,
PCT001031 INTEGER NOT NULL,
PCT001032 INTEGER NOT NULL,
PCT001033 INTEGER NOT NULL,
PCT001034 INTEGER NOT NULL,
PCT001035 INTEGER NOT NULL,
PCT001036 INTEGER NOT NULL,
PCT001037 INTEGER NOT NULL,
PCT001038 INTEGER NOT NULL,
PCT001039 INTEGER NOT NULL,
PCT001040 INTEGER NOT NULL,
PCT001041 INTEGER NOT NULL,
PCT001042 INTEGER NOT NULL,
PCT001043 INTEGER NOT NULL,
PCT001044 INTEGER NOT NULL,
PCT001045 INTEGER NOT NULL,
PCT001046 INTEGER NOT NULL,
PCT001047 INTEGER NOT NULL,
PCT001048 INTEGER NOT NULL,
PCT001049 INTEGER NOT NULL,
PCT001050 INTEGER NOT NULL,
PCT001051 INTEGER NOT NULL,
PCT001052 INTEGER NOT NULL,
PCT001053 INTEGER NOT NULL,
PCT001054 INTEGER NOT NULL,
PCT002001 INTEGER NOT NULL,
PCT002002 INTEGER NOT NULL,
PCT002003 INTEGER NOT NULL,
PCT002004 INTEGER NOT NULL,
PCT002005 INTEGER NOT NULL,
PCT002006 INTEGER NOT NULL,
PCT002007 INTEGER NOT NULL,
PCT002008 INTEGER NOT NULL,
PCT002009 INTEGER NOT NULL,
PCT002010 INTEGER NOT NULL,
PCT002011 INTEGER NOT NULL,
PCT002012 INTEGER NOT NULL,
PCT002013 INTEGER NOT NULL,
PCT002014 INTEGER NOT NULL,
PCT002015 INTEGER NOT NULL,
PCT002016 INTEGER NOT NULL,
PCT002017 INTEGER NOT NULL,
PCT002018 INTEGER NOT NULL,
PCT002019 INTEGER NOT NULL,
PCT002020 INTEGER NOT NULL,
PCT002021 INTEGER NOT NULL,
PCT002022 INTEGER NOT NULL,
PCT002023 INTEGER NOT NULL,
PCT002024 INTEGER NOT NULL,
PCT002025 INTEGER NOT NULL,
PCT002026 INTEGER NOT NULL,
PCT002027 INTEGER NOT NULL,
PCT002028 INTEGER NOT NULL,
PCT002029 INTEGER NOT NULL,
PCT002030 INTEGER NOT NULL,
PCT002031 INTEGER NOT NULL,
PCT002032 INTEGER NOT NULL,
PCT002033 INTEGER NOT NULL,
PCT002034 INTEGER NOT NULL,
PCT002035 INTEGER NOT NULL,
PCT002036 INTEGER NOT NULL,
PCT002037 INTEGER NOT NULL,
PCT002038 INTEGER NOT NULL,
PCT002039 INTEGER NOT NULL,
PCT002040 INTEGER NOT NULL,
PCT002041 INTEGER NOT NULL,
PCT002042 INTEGER NOT NULL,
PCT002043 INTEGER NOT NULL,
PCT002044 INTEGER NOT NULL,
PCT002045 INTEGER NOT NULL,
PCT002046 INTEGER NOT NULL,
PCT002047 INTEGER NOT NULL,
PCT002048 INTEGER NOT NULL,
PCT002049 INTEGER NOT NULL,
PCT002050 INTEGER NOT NULL,
PCT002051 INTEGER NOT NULL,
PCT002052 INTEGER NOT NULL,
PCT002053 INTEGER NOT NULL,
PCT002054 INTEGER NOT NULL,
PCT003001 INTEGER NOT NULL,
PCT003002 INTEGER NOT NULL,
PCT003003 INTEGER NOT NULL,
PCT003004 INTEGER NOT NULL,
PCT003005 INTEGER NOT NULL,
PCT003006 INTEGER NOT NULL,
PCT003007 INTEGER NOT NULL,
PCT003008 INTEGER NOT NULL,
PCT003009 INTEGER NOT NULL,
PCT003010 INTEGER NOT NULL,
PCT003011 INTEGER NOT NULL,
PCT003012 INTEGER NOT NULL,
PCT003013 INTEGER NOT NULL,
PCT003014 INTEGER NOT NULL,
PCT003015 INTEGER NOT NULL,
PCT003016 INTEGER NOT NULL,
PCT003017 INTEGER NOT NULL,
PCT003018 INTEGER NOT NULL,
PCT003019 INTEGER NOT NULL,
PCT003020 INTEGER NOT NULL,
PCT003021 INTEGER NOT NULL,
PCT003022 INTEGER NOT NULL,
PCT003023 INTEGER NOT NULL,
PCT003024 INTEGER NOT NULL,
PCT003025 INTEGER NOT NULL,
PCT003026 INTEGER NOT NULL,
PCT003027 INTEGER NOT NULL,
PCT003028 INTEGER NOT NULL,
PCT003029 INTEGER NOT NULL,
PCT003030 INTEGER NOT NULL,
PCT003031 INTEGER NOT NULL,
PCT003032 INTEGER NOT NULL,
PCT003033 INTEGER NOT NULL,
PCT003034 INTEGER NOT NULL,
PCT003035 INTEGER NOT NULL,
PCT003036 INTEGER NOT NULL,
PCT003037 INTEGER NOT NULL,
PCT003038 INTEGER NOT NULL,
PCT003039 INTEGER NOT NULL,
PCT003040 INTEGER NOT NULL,
PCT003041 INTEGER NOT NULL,
PCT003042 INTEGER NOT NULL,
PCT003043 INTEGER NOT NULL,
PCT003044 INTEGER NOT NULL,
PCT003045 INTEGER NOT NULL,
PCT003046 INTEGER NOT NULL,
PCT003047 INTEGER NOT NULL,
PCT003048 INTEGER NOT NULL,
PCT003049 INTEGER NOT NULL,
PCT003050 INTEGER NOT NULL,
PCT003051 INTEGER NOT NULL,
PCT003052 INTEGER NOT NULL,
PCT003053 INTEGER NOT NULL,
PCT003054 INTEGER NOT NULL,
PCT004001 INTEGER NOT NULL,
PCT004002 INTEGER NOT NULL,
PCT004003 INTEGER NOT NULL,
PCT004004 INTEGER NOT NULL,
PCT004005 INTEGER NOT NULL,
PCT004006 INTEGER NOT NULL,
PCT004007 INTEGER NOT NULL,
PCT004008 INTEGER NOT NULL,
PCT004009 INTEGER NOT NULL,
PCT005001 INTEGER NOT NULL,
PCT005002 INTEGER NOT NULL,
PCT005003 INTEGER NOT NULL,
PCT005004 INTEGER NOT NULL,
PCT005005 INTEGER NOT NULL,
PCT005006 INTEGER NOT NULL,
PCT005007 INTEGER NOT NULL,
PCT005008 INTEGER NOT NULL,
PCT005009 INTEGER NOT NULL,
PCT005010 INTEGER NOT NULL,
PCT005011 INTEGER NOT NULL,
PCT005012 INTEGER NOT NULL,
PCT005013 INTEGER NOT NULL,
PCT005014 INTEGER NOT NULL,
PCT005015 INTEGER NOT NULL,
PCT005016 INTEGER NOT NULL,
PCT005017 INTEGER NOT NULL,
PCT005018 INTEGER NOT NULL,
PCT005019 INTEGER NOT NULL,
PCT005020 INTEGER NOT NULL,
PCT005021 INTEGER NOT NULL,
PCT005022 INTEGER NOT NULL,
PCT006001 INTEGER NOT NULL,
PCT006002 INTEGER NOT NULL,
PCT006003 INTEGER NOT NULL,
PCT006004 INTEGER NOT NULL,
PCT006005 INTEGER NOT NULL,
PCT006006 INTEGER NOT NULL,
PCT006007 INTEGER NOT NULL,
PCT006008 INTEGER NOT NULL,
PCT006009 INTEGER NOT NULL,
PCT006010 INTEGER NOT NULL,
PCT006011 INTEGER NOT NULL,
PCT006012 INTEGER NOT NULL,
PCT006013 INTEGER NOT NULL,
PCT006014 INTEGER NOT NULL,
PCT006015 INTEGER NOT NULL,
PCT006016 INTEGER NOT NULL,
PCT006017 INTEGER NOT NULL,
PCT006018 INTEGER NOT NULL,
PCT006019 INTEGER NOT NULL,
PCT006020 INTEGER NOT NULL,
PCT006021 INTEGER NOT NULL,
PCT006022 INTEGER NOT NULL,
PCT007001 INTEGER NOT NULL,
PCT007002 INTEGER NOT NULL,
PCT007003 INTEGER NOT NULL,
PCT007004 INTEGER NOT NULL,
PCT007005 INTEGER NOT NULL,
PCT007006 INTEGER NOT NULL,
PCT007007 INTEGER NOT NULL,
PCT007008 INTEGER NOT NULL,
PCT007009 INTEGER NOT NULL,
PCT007010 INTEGER NOT NULL,
PCT007011 INTEGER NOT NULL,
PCT007012 INTEGER NOT NULL,
PCT007013 INTEGER NOT NULL,
PCT007014 INTEGER NOT NULL,
PCT007015 INTEGER NOT NULL,
PCT007016 INTEGER NOT NULL,
PCT007017 INTEGER NOT NULL,
PCT007018 INTEGER NOT NULL,
PCT007019 INTEGER NOT NULL,
PCT007020 INTEGER NOT NULL,
PCT007021 INTEGER NOT NULL,
PCT007022 INTEGER NOT NULL,
PCT008001 INTEGER NOT NULL,
PCT008002 INTEGER NOT NULL,
PCT008003 INTEGER NOT NULL,
PCT008004 INTEGER NOT NULL,
PCT008005 INTEGER NOT NULL,
PCT008006 INTEGER NOT NULL,
PCT008007 INTEGER NOT NULL,
PCT008008 INTEGER NOT NULL,
PCT008009 INTEGER NOT NULL,
PCT008010 INTEGER NOT NULL,
PCT008011 INTEGER NOT NULL,
PCT008012 INTEGER NOT NULL,
PCT008013 INTEGER NOT NULL,
PCT008014 INTEGER NOT NULL
);
CREATE TABLE sf1_16 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
PCT009001 INTEGER NOT NULL,
PCT009002 INTEGER NOT NULL,
PCT009003 INTEGER NOT NULL,
PCT009004 INTEGER NOT NULL,
PCT009005 INTEGER NOT NULL,
PCT009006 INTEGER NOT NULL,
PCT009007 INTEGER NOT NULL,
PCT009008 INTEGER NOT NULL,
PCT009009 INTEGER NOT NULL,
PCT009010 INTEGER NOT NULL,
PCT009011 INTEGER NOT NULL,
PCT009012 INTEGER NOT NULL,
PCT009013 INTEGER NOT NULL,
PCT009014 INTEGER NOT NULL,
PCT010001 INTEGER NOT NULL,
PCT010002 INTEGER NOT NULL,
PCT010003 INTEGER NOT NULL,
PCT010004 INTEGER NOT NULL,
PCT010005 INTEGER NOT NULL,
PCT010006 INTEGER NOT NULL,
PCT010007 INTEGER NOT NULL,
PCT010008 INTEGER NOT NULL,
PCT010009 INTEGER NOT NULL,
PCT010010 INTEGER NOT NULL,
PCT010011 INTEGER NOT NULL,
PCT010012 INTEGER NOT NULL,
PCT010013 INTEGER NOT NULL,
PCT010014 INTEGER NOT NULL,
PCT011001 INTEGER NOT NULL,
PCT011002 INTEGER NOT NULL,
PCT011003 INTEGER NOT NULL,
PCT011004 INTEGER NOT NULL,
PCT011005 INTEGER NOT NULL,
PCT011006 INTEGER NOT NULL,
PCT011007 INTEGER NOT NULL,
PCT011008 INTEGER NOT NULL,
PCT011009 INTEGER NOT NULL,
PCT011010 INTEGER NOT NULL,
PCT011011 INTEGER NOT NULL,
PCT011012 INTEGER NOT NULL,
PCT011013 INTEGER NOT NULL,
PCT011014 INTEGER NOT NULL,
PCT011015 INTEGER NOT NULL,
PCT011016 INTEGER NOT NULL,
PCT011017 INTEGER NOT NULL,
PCT011018 INTEGER NOT NULL,
PCT011019 INTEGER NOT NULL,
PCT011020 INTEGER NOT NULL,
PCT011021 INTEGER NOT NULL,
PCT011022 INTEGER NOT NULL,
PCT011023 INTEGER NOT NULL,
PCT011024 INTEGER NOT NULL,
PCT011025 INTEGER NOT NULL,
PCT011026 INTEGER NOT NULL,
PCT011027 INTEGER NOT NULL,
PCT011028 INTEGER NOT NULL,
PCT011029 INTEGER NOT NULL,
PCT011030 INTEGER NOT NULL,
PCT011031 INTEGER NOT NULL
);
CREATE TABLE sf1_17 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
PCT012001 INTEGER NOT NULL,
PCT012002 INTEGER NOT NULL,
PCT012003 INTEGER NOT NULL,
PCT012004 INTEGER NOT NULL,
PCT012005 INTEGER NOT NULL,
PCT012006 INTEGER NOT NULL,
PCT012007 INTEGER NOT NULL,
PCT012008 INTEGER NOT NULL,
PCT012009 INTEGER NOT NULL,
PCT012010 INTEGER NOT NULL,
PCT012011 INTEGER NOT NULL,
PCT012012 INTEGER NOT NULL,
PCT012013 INTEGER NOT NULL,
PCT012014 INTEGER NOT NULL,
PCT012015 INTEGER NOT NULL,
PCT012016 INTEGER NOT NULL,
PCT012017 INTEGER NOT NULL,
PCT012018 INTEGER NOT NULL,
PCT012019 INTEGER NOT NULL,
PCT012020 INTEGER NOT NULL,
PCT012021 INTEGER NOT NULL,
PCT012022 INTEGER NOT NULL,
PCT012023 INTEGER NOT NULL,
PCT012024 INTEGER NOT NULL,
PCT012025 INTEGER NOT NULL,
PCT012026 INTEGER NOT NULL,
PCT012027 INTEGER NOT NULL,
PCT012028 INTEGER NOT NULL,
PCT012029 INTEGER NOT NULL,
PCT012030 INTEGER NOT NULL,
PCT012031 INTEGER NOT NULL,
PCT012032 INTEGER NOT NULL,
PCT012033 INTEGER NOT NULL,
PCT012034 INTEGER NOT NULL,
PCT012035 INTEGER NOT NULL,
PCT012036 INTEGER NOT NULL,
PCT012037 INTEGER NOT NULL,
PCT012038 INTEGER NOT NULL,
PCT012039 INTEGER NOT NULL,
PCT012040 INTEGER NOT NULL,
PCT012041 INTEGER NOT NULL,
PCT012042 INTEGER NOT NULL,
PCT012043 INTEGER NOT NULL,
PCT012044 INTEGER NOT NULL,
PCT012045 INTEGER NOT NULL,
PCT012046 INTEGER NOT NULL,
PCT012047 INTEGER NOT NULL,
PCT012048 INTEGER NOT NULL,
PCT012049 INTEGER NOT NULL,
PCT012050 INTEGER NOT NULL,
PCT012051 INTEGER NOT NULL,
PCT012052 INTEGER NOT NULL,
PCT012053 INTEGER NOT NULL,
PCT012054 INTEGER NOT NULL,
PCT012055 INTEGER NOT NULL,
PCT012056 INTEGER NOT NULL,
PCT012057 INTEGER NOT NULL,
PCT012058 INTEGER NOT NULL,
PCT012059 INTEGER NOT NULL,
PCT012060 INTEGER NOT NULL,
PCT012061 INTEGER NOT NULL,
PCT012062 INTEGER NOT NULL,
PCT012063 INTEGER NOT NULL,
PCT012064 INTEGER NOT NULL,
PCT012065 INTEGER NOT NULL,
PCT012066 INTEGER NOT NULL,
PCT012067 INTEGER NOT NULL,
PCT012068 INTEGER NOT NULL,
PCT012069 INTEGER NOT NULL,
PCT012070 INTEGER NOT NULL,
PCT012071 INTEGER NOT NULL,
PCT012072 INTEGER NOT NULL,
PCT012073 INTEGER NOT NULL,
PCT012074 INTEGER NOT NULL,
PCT012075 INTEGER NOT NULL,
PCT012076 INTEGER NOT NULL,
PCT012077 INTEGER NOT NULL,
PCT012078 INTEGER NOT NULL,
PCT012079 INTEGER NOT NULL,
PCT012080 INTEGER NOT NULL,
PCT012081 INTEGER NOT NULL,
PCT012082 INTEGER NOT NULL,
PCT012083 INTEGER NOT NULL,
PCT012084 INTEGER NOT NULL,
PCT012085 INTEGER NOT NULL,
PCT012086 INTEGER NOT NULL,
PCT012087 INTEGER NOT NULL,
PCT012088 INTEGER NOT NULL,
PCT012089 INTEGER NOT NULL,
PCT012090 INTEGER NOT NULL,
PCT012091 INTEGER NOT NULL,
PCT012092 INTEGER NOT NULL,
PCT012093 INTEGER NOT NULL,
PCT012094 INTEGER NOT NULL,
PCT012095 INTEGER NOT NULL,
PCT012096 INTEGER NOT NULL,
PCT012097 INTEGER NOT NULL,
PCT012098 INTEGER NOT NULL,
PCT012099 INTEGER NOT NULL,
PCT012100 INTEGER NOT NULL,
PCT012101 INTEGER NOT NULL,
PCT012102 INTEGER NOT NULL,
PCT012103 INTEGER NOT NULL,
PCT012104 INTEGER NOT NULL,
PCT012105 INTEGER NOT NULL,
PCT012106 INTEGER NOT NULL,
PCT012107 INTEGER NOT NULL,
PCT012108 INTEGER NOT NULL,
PCT012109 INTEGER NOT NULL,
PCT012110 INTEGER NOT NULL,
PCT012111 INTEGER NOT NULL,
PCT012112 INTEGER NOT NULL,
PCT012113 INTEGER NOT NULL,
PCT012114 INTEGER NOT NULL,
PCT012115 INTEGER NOT NULL,
PCT012116 INTEGER NOT NULL,
PCT012117 INTEGER NOT NULL,
PCT012118 INTEGER NOT NULL,
PCT012119 INTEGER NOT NULL,
PCT012120 INTEGER NOT NULL,
PCT012121 INTEGER NOT NULL,
PCT012122 INTEGER NOT NULL,
PCT012123 INTEGER NOT NULL,
PCT012124 INTEGER NOT NULL,
PCT012125 INTEGER NOT NULL,
PCT012126 INTEGER NOT NULL,
PCT012127 INTEGER NOT NULL,
PCT012128 INTEGER NOT NULL,
PCT012129 INTEGER NOT NULL,
PCT012130 INTEGER NOT NULL,
PCT012131 INTEGER NOT NULL,
PCT012132 INTEGER NOT NULL,
PCT012133 INTEGER NOT NULL,
PCT012134 INTEGER NOT NULL,
PCT012135 INTEGER NOT NULL,
PCT012136 INTEGER NOT NULL,
PCT012137 INTEGER NOT NULL,
PCT012138 INTEGER NOT NULL,
PCT012139 INTEGER NOT NULL,
PCT012140 INTEGER NOT NULL,
PCT012141 INTEGER NOT NULL,
PCT012142 INTEGER NOT NULL,
PCT012143 INTEGER NOT NULL,
PCT012144 INTEGER NOT NULL,
PCT012145 INTEGER NOT NULL,
PCT012146 INTEGER NOT NULL,
PCT012147 INTEGER NOT NULL,
PCT012148 INTEGER NOT NULL,
PCT012149 INTEGER NOT NULL,
PCT012150 INTEGER NOT NULL,
PCT012151 INTEGER NOT NULL,
PCT012152 INTEGER NOT NULL,
PCT012153 INTEGER NOT NULL,
PCT012154 INTEGER NOT NULL,
PCT012155 INTEGER NOT NULL,
PCT012156 INTEGER NOT NULL,
PCT012157 INTEGER NOT NULL,
PCT012158 INTEGER NOT NULL,
PCT012159 INTEGER NOT NULL,
PCT012160 INTEGER NOT NULL,
PCT012161 INTEGER NOT NULL,
PCT012162 INTEGER NOT NULL,
PCT012163 INTEGER NOT NULL,
PCT012164 INTEGER NOT NULL,
PCT012165 INTEGER NOT NULL,
PCT012166 INTEGER NOT NULL,
PCT012167 INTEGER NOT NULL,
PCT012168 INTEGER NOT NULL,
PCT012169 INTEGER NOT NULL,
PCT012170 INTEGER NOT NULL,
PCT012171 INTEGER NOT NULL,
PCT012172 INTEGER NOT NULL,
PCT012173 INTEGER NOT NULL,
PCT012174 INTEGER NOT NULL,
PCT012175 INTEGER NOT NULL,
PCT012176 INTEGER NOT NULL,
PCT012177 INTEGER NOT NULL,
PCT012178 INTEGER NOT NULL,
PCT012179 INTEGER NOT NULL,
PCT012180 INTEGER NOT NULL,
PCT012181 INTEGER NOT NULL,
PCT012182 INTEGER NOT NULL,
PCT012183 INTEGER NOT NULL,
PCT012184 INTEGER NOT NULL,
PCT012185 INTEGER NOT NULL,
PCT012186 INTEGER NOT NULL,
PCT012187 INTEGER NOT NULL,
PCT012188 INTEGER NOT NULL,
PCT012189 INTEGER NOT NULL,
PCT012190 INTEGER NOT NULL,
PCT012191 INTEGER NOT NULL,
PCT012192 INTEGER NOT NULL,
PCT012193 INTEGER NOT NULL,
PCT012194 INTEGER NOT NULL,
PCT012195 INTEGER NOT NULL,
PCT012196 INTEGER NOT NULL,
PCT012197 INTEGER NOT NULL,
PCT012198 INTEGER NOT NULL,
PCT012199 INTEGER NOT NULL,
PCT012200 INTEGER NOT NULL,
PCT012201 INTEGER NOT NULL,
PCT012202 INTEGER NOT NULL,
PCT012203 INTEGER NOT NULL,
PCT012204 INTEGER NOT NULL,
PCT012205 INTEGER NOT NULL,
PCT012206 INTEGER NOT NULL,
PCT012207 INTEGER NOT NULL,
PCT012208 INTEGER NOT NULL,
PCT012209 INTEGER NOT NULL
);
CREATE TABLE sf1_18 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
PCT013001 INTEGER NOT NULL,
PCT013002 INTEGER NOT NULL,
PCT013003 INTEGER NOT NULL,
PCT013004 INTEGER NOT NULL,
PCT013005 INTEGER NOT NULL,
PCT013006 INTEGER NOT NULL,
PCT013007 INTEGER NOT NULL,
PCT013008 INTEGER NOT NULL,
PCT013009 INTEGER NOT NULL,
PCT013010 INTEGER NOT NULL,
PCT013011 INTEGER NOT NULL,
PCT013012 INTEGER NOT NULL,
PCT013013 INTEGER NOT NULL,
PCT013014 INTEGER NOT NULL,
PCT013015 INTEGER NOT NULL,
PCT013016 INTEGER NOT NULL,
PCT013017 INTEGER NOT NULL,
PCT013018 INTEGER NOT NULL,
PCT013019 INTEGER NOT NULL,
PCT013020 INTEGER NOT NULL,
PCT013021 INTEGER NOT NULL,
PCT013022 INTEGER NOT NULL,
PCT013023 INTEGER NOT NULL,
PCT013024 INTEGER NOT NULL,
PCT013025 INTEGER NOT NULL,
PCT013026 INTEGER NOT NULL,
PCT013027 INTEGER NOT NULL,
PCT013028 INTEGER NOT NULL,
PCT013029 INTEGER NOT NULL,
PCT013030 INTEGER NOT NULL,
PCT013031 INTEGER NOT NULL,
PCT013032 INTEGER NOT NULL,
PCT013033 INTEGER NOT NULL,
PCT013034 INTEGER NOT NULL,
PCT013035 INTEGER NOT NULL,
PCT013036 INTEGER NOT NULL,
PCT013037 INTEGER NOT NULL,
PCT013038 INTEGER NOT NULL,
PCT013039 INTEGER NOT NULL,
PCT013040 INTEGER NOT NULL,
PCT013041 INTEGER NOT NULL,
PCT013042 INTEGER NOT NULL,
PCT013043 INTEGER NOT NULL,
PCT013044 INTEGER NOT NULL,
PCT013045 INTEGER NOT NULL,
PCT013046 INTEGER NOT NULL,
PCT013047 INTEGER NOT NULL,
PCT013048 INTEGER NOT NULL,
PCT013049 INTEGER NOT NULL,
PCT014001 INTEGER NOT NULL,
PCT014002 INTEGER NOT NULL,
PCT014003 INTEGER NOT NULL,
PCT015001 INTEGER NOT NULL,
PCT015002 INTEGER NOT NULL,
PCT015003 INTEGER NOT NULL,
PCT015004 INTEGER NOT NULL,
PCT015005 INTEGER NOT NULL,
PCT015006 INTEGER NOT NULL,
PCT015007 INTEGER NOT NULL,
PCT015008 INTEGER NOT NULL,
PCT015009 INTEGER NOT NULL,
PCT015010 INTEGER NOT NULL,
PCT015011 INTEGER NOT NULL,
PCT015012 INTEGER NOT NULL,
PCT015013 INTEGER NOT NULL,
PCT015014 INTEGER NOT NULL,
PCT015015 INTEGER NOT NULL,
PCT015016 INTEGER NOT NULL,
PCT015017 INTEGER NOT NULL,
PCT015018 INTEGER NOT NULL,
PCT015019 INTEGER NOT NULL,
PCT015020 INTEGER NOT NULL,
PCT015021 INTEGER NOT NULL,
PCT015022 INTEGER NOT NULL,
PCT015023 INTEGER NOT NULL,
PCT015024 INTEGER NOT NULL,
PCT015025 INTEGER NOT NULL,
PCT015026 INTEGER NOT NULL,
PCT015027 INTEGER NOT NULL,
PCT015028 INTEGER NOT NULL,
PCT015029 INTEGER NOT NULL,
PCT015030 INTEGER NOT NULL,
PCT015031 INTEGER NOT NULL,
PCT015032 INTEGER NOT NULL,
PCT015033 INTEGER NOT NULL,
PCT015034 INTEGER NOT NULL,
PCT016001 INTEGER NOT NULL,
PCT016002 INTEGER NOT NULL,
PCT016003 INTEGER NOT NULL,
PCT016004 INTEGER NOT NULL,
PCT016005 INTEGER NOT NULL,
PCT016006 INTEGER NOT NULL,
PCT016007 INTEGER NOT NULL,
PCT016008 INTEGER NOT NULL,
PCT016009 INTEGER NOT NULL,
PCT016010 INTEGER NOT NULL,
PCT016011 INTEGER NOT NULL,
PCT016012 INTEGER NOT NULL,
PCT016013 INTEGER NOT NULL,
PCT016014 INTEGER NOT NULL,
PCT016015 INTEGER NOT NULL,
PCT016016 INTEGER NOT NULL,
PCT016017 INTEGER NOT NULL,
PCT016018 INTEGER NOT NULL,
PCT016019 INTEGER NOT NULL,
PCT016020 INTEGER NOT NULL,
PCT016021 INTEGER NOT NULL,
PCT016022 INTEGER NOT NULL,
PCT016023 INTEGER NOT NULL,
PCT016024 INTEGER NOT NULL,
PCT016025 INTEGER NOT NULL,
PCT016026 INTEGER NOT NULL,
PCT017001 INTEGER NOT NULL,
PCT017002 INTEGER NOT NULL,
PCT017003 INTEGER NOT NULL,
PCT017004 INTEGER NOT NULL,
PCT017005 INTEGER NOT NULL,
PCT017006 INTEGER NOT NULL,
PCT017007 INTEGER NOT NULL,
PCT017008 INTEGER NOT NULL,
PCT017009 INTEGER NOT NULL,
PCT017010 INTEGER NOT NULL,
PCT017011 INTEGER NOT NULL,
PCT017012 INTEGER NOT NULL,
PCT017013 INTEGER NOT NULL,
PCT017014 INTEGER NOT NULL,
PCT017015 INTEGER NOT NULL,
PCT017016 INTEGER NOT NULL,
PCT017017 INTEGER NOT NULL,
PCT017018 INTEGER NOT NULL,
PCT018001 INTEGER NOT NULL,
PCT018002 INTEGER NOT NULL,
PCT018003 INTEGER NOT NULL,
PCT018004 INTEGER NOT NULL,
PCT018005 INTEGER NOT NULL,
PCT018006 INTEGER NOT NULL,
PCT018007 INTEGER NOT NULL,
PCT018008 INTEGER NOT NULL,
PCT018009 INTEGER NOT NULL,
PCT018010 INTEGER NOT NULL,
PCT018011 INTEGER NOT NULL,
PCT018012 INTEGER NOT NULL,
PCT018013 INTEGER NOT NULL,
PCT018014 INTEGER NOT NULL,
PCT018015 INTEGER NOT NULL,
PCT019001 INTEGER NOT NULL,
PCT019002 INTEGER NOT NULL,
PCT019003 INTEGER NOT NULL,
PCT019004 INTEGER NOT NULL,
PCT019005 INTEGER NOT NULL,
PCT019006 INTEGER NOT NULL,
PCT019007 INTEGER NOT NULL,
PCT019008 INTEGER NOT NULL,
PCT019009 INTEGER NOT NULL,
PCT019010 INTEGER NOT NULL,
PCT019011 INTEGER NOT NULL,
PCT020001 INTEGER NOT NULL,
PCT020002 INTEGER NOT NULL,
PCT020003 INTEGER NOT NULL,
PCT020004 INTEGER NOT NULL,
PCT020005 INTEGER NOT NULL,
PCT020006 INTEGER NOT NULL,
PCT020007 INTEGER NOT NULL,
PCT020008 INTEGER NOT NULL,
PCT020009 INTEGER NOT NULL,
PCT020010 INTEGER NOT NULL,
PCT020011 INTEGER NOT NULL,
PCT020012 INTEGER NOT NULL,
PCT020013 INTEGER NOT NULL,
PCT020014 INTEGER NOT NULL,
PCT020015 INTEGER NOT NULL,
PCT020016 INTEGER NOT NULL,
PCT020017 INTEGER NOT NULL,
PCT020018 INTEGER NOT NULL,
PCT020019 INTEGER NOT NULL,
PCT020020 INTEGER NOT NULL,
PCT020021 INTEGER NOT NULL,
PCT020022 INTEGER NOT NULL,
PCT020023 INTEGER NOT NULL,
PCT020024 INTEGER NOT NULL,
PCT020025 INTEGER NOT NULL,
PCT020026 INTEGER NOT NULL,
PCT020027 INTEGER NOT NULL,
PCT020028 INTEGER NOT NULL,
PCT020029 INTEGER NOT NULL,
PCT020030 INTEGER NOT NULL,
PCT020031 INTEGER NOT NULL,
PCT020032 INTEGER NOT NULL
);
CREATE TABLE sf1_19 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
PCT021001 INTEGER NOT NULL,
PCT021002 INTEGER NOT NULL,
PCT021003 INTEGER NOT NULL,
PCT021004 INTEGER NOT NULL,
PCT021005 INTEGER NOT NULL,
PCT021006 INTEGER NOT NULL,
PCT021007 INTEGER NOT NULL,
PCT021008 INTEGER NOT NULL,
PCT021009 INTEGER NOT NULL,
PCT021010 INTEGER NOT NULL,
PCT021011 INTEGER NOT NULL,
PCT021012 INTEGER NOT NULL,
PCT021013 INTEGER NOT NULL,
PCT021014 INTEGER NOT NULL,
PCT021015 INTEGER NOT NULL,
PCT021016 INTEGER NOT NULL,
PCT021017 INTEGER NOT NULL,
PCT021018 INTEGER NOT NULL,
PCT021019 INTEGER NOT NULL,
PCT021020 INTEGER NOT NULL,
PCT021021 INTEGER NOT NULL,
PCT021022 INTEGER NOT NULL,
PCT021023 INTEGER NOT NULL,
PCT021024 INTEGER NOT NULL,
PCT021025 INTEGER NOT NULL,
PCT021026 INTEGER NOT NULL,
PCT021027 INTEGER NOT NULL,
PCT021028 INTEGER NOT NULL,
PCT021029 INTEGER NOT NULL,
PCT021030 INTEGER NOT NULL,
PCT021031 INTEGER NOT NULL,
PCT021032 INTEGER NOT NULL,
PCT021033 INTEGER NOT NULL,
PCT021034 INTEGER NOT NULL,
PCT021035 INTEGER NOT NULL,
PCT021036 INTEGER NOT NULL,
PCT021037 INTEGER NOT NULL,
PCT021038 INTEGER NOT NULL,
PCT021039 INTEGER NOT NULL,
PCT021040 INTEGER NOT NULL,
PCT021041 INTEGER NOT NULL,
PCT021042 INTEGER NOT NULL,
PCT021043 INTEGER NOT NULL,
PCT021044 INTEGER NOT NULL,
PCT021045 INTEGER NOT NULL,
PCT021046 INTEGER NOT NULL,
PCT021047 INTEGER NOT NULL,
PCT021048 INTEGER NOT NULL,
PCT021049 INTEGER NOT NULL,
PCT021050 INTEGER NOT NULL,
PCT021051 INTEGER NOT NULL,
PCT021052 INTEGER NOT NULL,
PCT021053 INTEGER NOT NULL,
PCT021054 INTEGER NOT NULL,
PCT021055 INTEGER NOT NULL,
PCT021056 INTEGER NOT NULL,
PCT021057 INTEGER NOT NULL,
PCT021058 INTEGER NOT NULL,
PCT021059 INTEGER NOT NULL,
PCT021060 INTEGER NOT NULL,
PCT021061 INTEGER NOT NULL,
PCT021062 INTEGER NOT NULL,
PCT021063 INTEGER NOT NULL,
PCT021064 INTEGER NOT NULL,
PCT021065 INTEGER NOT NULL,
PCT021066 INTEGER NOT NULL,
PCT021067 INTEGER NOT NULL,
PCT021068 INTEGER NOT NULL,
PCT021069 INTEGER NOT NULL,
PCT021070 INTEGER NOT NULL,
PCT021071 INTEGER NOT NULL,
PCT021072 INTEGER NOT NULL,
PCT021073 INTEGER NOT NULL,
PCT021074 INTEGER NOT NULL,
PCT021075 INTEGER NOT NULL,
PCT021076 INTEGER NOT NULL,
PCT021077 INTEGER NOT NULL,
PCT021078 INTEGER NOT NULL,
PCT021079 INTEGER NOT NULL,
PCT021080 INTEGER NOT NULL,
PCT021081 INTEGER NOT NULL,
PCT021082 INTEGER NOT NULL,
PCT021083 INTEGER NOT NULL,
PCT021084 INTEGER NOT NULL,
PCT021085 INTEGER NOT NULL,
PCT021086 INTEGER NOT NULL,
PCT021087 INTEGER NOT NULL,
PCT021088 INTEGER NOT NULL,
PCT021089 INTEGER NOT NULL,
PCT021090 INTEGER NOT NULL,
PCT021091 INTEGER NOT NULL,
PCT021092 INTEGER NOT NULL,
PCT021093 INTEGER NOT NULL,
PCT021094 INTEGER NOT NULL,
PCT021095 INTEGER NOT NULL,
PCT021096 INTEGER NOT NULL,
PCT021097 INTEGER NOT NULL,
PCT021098 INTEGER NOT NULL,
PCT021099 INTEGER NOT NULL,
PCT021100 INTEGER NOT NULL,
PCT021101 INTEGER NOT NULL,
PCT021102 INTEGER NOT NULL,
PCT021103 INTEGER NOT NULL,
PCT021104 INTEGER NOT NULL,
PCT021105 INTEGER NOT NULL,
PCT021106 INTEGER NOT NULL,
PCT021107 INTEGER NOT NULL,
PCT021108 INTEGER NOT NULL,
PCT021109 INTEGER NOT NULL,
PCT021110 INTEGER NOT NULL,
PCT021111 INTEGER NOT NULL,
PCT021112 INTEGER NOT NULL,
PCT021113 INTEGER NOT NULL,
PCT021114 INTEGER NOT NULL,
PCT021115 INTEGER NOT NULL,
PCT021116 INTEGER NOT NULL,
PCT021117 INTEGER NOT NULL,
PCT021118 INTEGER NOT NULL,
PCT021119 INTEGER NOT NULL,
PCT021120 INTEGER NOT NULL,
PCT021121 INTEGER NOT NULL,
PCT021122 INTEGER NOT NULL,
PCT021123 INTEGER NOT NULL,
PCT021124 INTEGER NOT NULL,
PCT021125 INTEGER NOT NULL,
PCT021126 INTEGER NOT NULL,
PCT021127 INTEGER NOT NULL,
PCT021128 INTEGER NOT NULL,
PCT021129 INTEGER NOT NULL,
PCT021130 INTEGER NOT NULL,
PCT021131 INTEGER NOT NULL,
PCT021132 INTEGER NOT NULL,
PCT021133 INTEGER NOT NULL,
PCT021134 INTEGER NOT NULL,
PCT021135 INTEGER NOT NULL,
PCT021136 INTEGER NOT NULL,
PCT021137 INTEGER NOT NULL,
PCT021138 INTEGER NOT NULL,
PCT021139 INTEGER NOT NULL,
PCT021140 INTEGER NOT NULL,
PCT021141 INTEGER NOT NULL,
PCT021142 INTEGER NOT NULL,
PCT021143 INTEGER NOT NULL,
PCT021144 INTEGER NOT NULL,
PCT021145 INTEGER NOT NULL,
PCT021146 INTEGER NOT NULL,
PCT021147 INTEGER NOT NULL,
PCT021148 INTEGER NOT NULL,
PCT021149 INTEGER NOT NULL,
PCT021150 INTEGER NOT NULL,
PCT021151 INTEGER NOT NULL,
PCT021152 INTEGER NOT NULL,
PCT021153 INTEGER NOT NULL,
PCT021154 INTEGER NOT NULL,
PCT021155 INTEGER NOT NULL,
PCT021156 INTEGER NOT NULL,
PCT021157 INTEGER NOT NULL,
PCT021158 INTEGER NOT NULL,
PCT021159 INTEGER NOT NULL,
PCT021160 INTEGER NOT NULL,
PCT021161 INTEGER NOT NULL,
PCT021162 INTEGER NOT NULL,
PCT021163 INTEGER NOT NULL,
PCT021164 INTEGER NOT NULL,
PCT021165 INTEGER NOT NULL,
PCT021166 INTEGER NOT NULL,
PCT021167 INTEGER NOT NULL,
PCT021168 INTEGER NOT NULL,
PCT021169 INTEGER NOT NULL,
PCT021170 INTEGER NOT NULL,
PCT021171 INTEGER NOT NULL,
PCT021172 INTEGER NOT NULL,
PCT021173 INTEGER NOT NULL,
PCT021174 INTEGER NOT NULL,
PCT021175 INTEGER NOT NULL,
PCT021176 INTEGER NOT NULL,
PCT021177 INTEGER NOT NULL,
PCT021178 INTEGER NOT NULL,
PCT021179 INTEGER NOT NULL,
PCT021180 INTEGER NOT NULL,
PCT021181 INTEGER NOT NULL,
PCT021182 INTEGER NOT NULL,
PCT021183 INTEGER NOT NULL,
PCT021184 INTEGER NOT NULL,
PCT021185 INTEGER NOT NULL,
PCT021186 INTEGER NOT NULL,
PCT021187 INTEGER NOT NULL,
PCT021188 INTEGER NOT NULL,
PCT021189 INTEGER NOT NULL,
PCT021190 INTEGER NOT NULL,
PCT021191 INTEGER NOT NULL,
PCT021192 INTEGER NOT NULL,
PCT021193 INTEGER NOT NULL,
PCT021194 INTEGER NOT NULL,
PCT021195 INTEGER NOT NULL,
PCT022001 INTEGER NOT NULL,
PCT022002 INTEGER NOT NULL,
PCT022003 INTEGER NOT NULL,
PCT022004 INTEGER NOT NULL,
PCT022005 INTEGER NOT NULL,
PCT022006 INTEGER NOT NULL,
PCT022007 INTEGER NOT NULL,
PCT022008 INTEGER NOT NULL,
PCT022009 INTEGER NOT NULL,
PCT022010 INTEGER NOT NULL,
PCT022011 INTEGER NOT NULL,
PCT022012 INTEGER NOT NULL,
PCT022013 INTEGER NOT NULL,
PCT022014 INTEGER NOT NULL,
PCT022015 INTEGER NOT NULL,
PCT022016 INTEGER NOT NULL,
PCT022017 INTEGER NOT NULL,
PCT022018 INTEGER NOT NULL,
PCT022019 INTEGER NOT NULL,
PCT022020 INTEGER NOT NULL,
PCT022021 INTEGER NOT NULL
);
CREATE TABLE sf1_20 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(3) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
PCT012A001 INTEGER NOT NULL,
PCT012A002 INTEGER NOT NULL,
PCT012A003 INTEGER NOT NULL,
PCT012A004 INTEGER NOT NULL,
PCT012A005 INTEGER NOT NULL,
PCT012A006 INTEGER NOT NULL,
PCT012A007 INTEGER NOT NULL,
PCT012A008 INTEGER NOT NULL,
PCT012A009 INTEGER NOT NULL,
PCT012A010 INTEGER NOT NULL,
PCT012A011 INTEGER NOT NULL,
PCT012A012 INTEGER NOT NULL,
PCT012A013 INTEGER NOT NULL,
PCT012A014 INTEGER NOT NULL,
PCT012A015 INTEGER NOT NULL,
PCT012A016 INTEGER NOT NULL,
PCT012A017 INTEGER NOT NULL,
PCT012A018 INTEGER NOT NULL,
PCT012A019 INTEGER NOT NULL,
PCT012A020 INTEGER NOT NULL,
PCT012A021 INTEGER NOT NULL,
PCT012A022 INTEGER NOT NULL,
PCT012A023 INTEGER NOT NULL,
PCT012A024 INTEGER NOT NULL,
PCT012A025 INTEGER NOT NULL,
PCT012A026 INTEGER NOT NULL,
PCT012A027 INTEGER NOT NULL,
PCT012A028 INTEGER NOT NULL,
PCT012A029 INTEGER NOT NULL,
PCT012A030 INTEGER NOT NULL,
PCT012A031 INTEGER NOT NULL,
PCT012A032 INTEGER NOT NULL,
PCT012A033 INTEGER NOT NULL,
PCT012A034 INTEGER NOT NULL,
PCT012A035 INTEGER NOT NULL,
PCT012A036 INTEGER NOT NULL,
PCT012A037 INTEGER NOT NULL,
PCT012A038 INTEGER NOT NULL,
PCT012A039 INTEGER NOT NULL,
PCT012A040 INTEGER NOT NULL,
PCT012A041 INTEGER NOT NULL,
PCT012A042 INTEGER NOT NULL,
PCT012A043 INTEGER NOT NULL,
PCT012A044 INTEGER NOT NULL,
PCT012A045 INTEGER NOT NULL,
PCT012A046 INTEGER NOT NULL,
PCT012A047 INTEGER NOT NULL,
PCT012A048 INTEGER NOT NULL,
PCT012A049 INTEGER NOT NULL,
PCT012A050 INTEGER NOT NULL,
PCT012A051 INTEGER NOT NULL,
PCT012A052 INTEGER NOT NULL,
PCT012A053 INTEGER NOT NULL,
PCT012A054 INTEGER NOT NULL,
PCT012A055 INTEGER NOT NULL,
PCT012A056 INTEGER NOT NULL,
PCT012A057 INTEGER NOT NULL,
PCT012A058 INTEGER NOT NULL,
PCT012A059 INTEGER NOT NULL,
PCT012A060 INTEGER NOT NULL,
PCT012A061 INTEGER NOT NULL,
PCT012A062 INTEGER NOT NULL,
PCT012A063 INTEGER NOT NULL,
PCT012A064 INTEGER NOT NULL,
PCT012A065 INTEGER NOT NULL,
PCT012A066 INTEGER NOT NULL,
PCT012A067 INTEGER NOT NULL,
PCT012A068 INTEGER NOT NULL,
PCT012A069 INTEGER NOT NULL,
PCT012A070 INTEGER NOT NULL,
PCT012A071 INTEGER NOT NULL,
PCT012A072 INTEGER NOT NULL,
PCT012A073 INTEGER NOT NULL,
PCT012A074 INTEGER NOT NULL,
PCT012A075 INTEGER NOT NULL,
PCT012A076 INTEGER NOT NULL,
PCT012A077 INTEGER NOT NULL,
PCT012A078 INTEGER NOT NULL,
PCT012A079 INTEGER NOT NULL,
PCT012A080 INTEGER NOT NULL,
PCT012A081 INTEGER NOT NULL,
PCT012A082 INTEGER NOT NULL,
PCT012A083 INTEGER NOT NULL,
PCT012A084 INTEGER NOT NULL,
PCT012A085 INTEGER NOT NULL,
PCT012A086 INTEGER NOT NULL,