/
all_2000_sf1_tables.sql
8424 lines (8386 loc) · 269 KB
/
all_2000_sf1_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
CREATE TABLE sf1_01 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(2) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
P001001 INTEGER NOT NULL,
P002001 INTEGER NOT NULL,
P002002 INTEGER NOT NULL,
P002003 INTEGER NOT NULL,
P002004 INTEGER NOT NULL,
P002005 INTEGER NOT NULL,
P002006 INTEGER NOT NULL,
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,
P003009 INTEGER NOT NULL,
P003010 INTEGER NOT NULL,
P003011 INTEGER NOT NULL,
P003012 INTEGER NOT NULL,
P003013 INTEGER NOT NULL,
P003014 INTEGER NOT NULL,
P003015 INTEGER NOT NULL,
P003016 INTEGER NOT NULL,
P003017 INTEGER NOT NULL,
P003018 INTEGER NOT NULL,
P003019 INTEGER NOT NULL,
P003020 INTEGER NOT NULL,
P003021 INTEGER NOT NULL,
P003022 INTEGER NOT NULL,
P003023 INTEGER NOT NULL,
P003024 INTEGER NOT NULL,
P003025 INTEGER NOT NULL,
P003026 INTEGER NOT NULL,
P003027 INTEGER NOT NULL,
P003028 INTEGER NOT NULL,
P003029 INTEGER NOT NULL,
P003030 INTEGER NOT NULL,
P003031 INTEGER NOT NULL,
P003032 INTEGER NOT NULL,
P003033 INTEGER NOT NULL,
P003034 INTEGER NOT NULL,
P003035 INTEGER NOT NULL,
P003036 INTEGER NOT NULL,
P003037 INTEGER NOT NULL,
P003038 INTEGER NOT NULL,
P003039 INTEGER NOT NULL,
P003040 INTEGER NOT NULL,
P003041 INTEGER NOT NULL,
P003042 INTEGER NOT NULL,
P003043 INTEGER NOT NULL,
P003044 INTEGER NOT NULL,
P003045 INTEGER NOT NULL,
P003046 INTEGER NOT NULL,
P003047 INTEGER NOT NULL,
P003048 INTEGER NOT NULL,
P003049 INTEGER NOT NULL,
P003050 INTEGER NOT NULL,
P003051 INTEGER NOT NULL,
P003052 INTEGER NOT NULL,
P003053 INTEGER NOT NULL,
P003054 INTEGER NOT NULL,
P003055 INTEGER NOT NULL,
P003056 INTEGER NOT NULL,
P003057 INTEGER NOT NULL,
P003058 INTEGER NOT NULL,
P003059 INTEGER NOT NULL,
P003060 INTEGER NOT NULL,
P003061 INTEGER NOT NULL,
P003062 INTEGER NOT NULL,
P003063 INTEGER NOT NULL,
P003064 INTEGER NOT NULL,
P003065 INTEGER NOT NULL,
P003066 INTEGER NOT NULL,
P003067 INTEGER NOT NULL,
P003068 INTEGER NOT NULL,
P003069 INTEGER NOT NULL,
P003070 INTEGER NOT NULL,
P003071 INTEGER NOT NULL,
P004001 INTEGER NOT NULL,
P004002 INTEGER NOT NULL,
P004003 INTEGER NOT NULL,
P004004 INTEGER NOT NULL,
P004005 INTEGER NOT NULL,
P004006 INTEGER NOT NULL,
P004007 INTEGER NOT NULL,
P004008 INTEGER NOT NULL,
P004009 INTEGER NOT NULL,
P004010 INTEGER NOT NULL,
P004011 INTEGER NOT NULL,
P004012 INTEGER NOT NULL,
P004013 INTEGER NOT NULL,
P004014 INTEGER NOT NULL,
P004015 INTEGER NOT NULL,
P004016 INTEGER NOT NULL,
P004017 INTEGER NOT NULL,
P004018 INTEGER NOT NULL,
P004019 INTEGER NOT NULL,
P004020 INTEGER NOT NULL,
P004021 INTEGER NOT NULL,
P004022 INTEGER NOT NULL,
P004023 INTEGER NOT NULL,
P004024 INTEGER NOT NULL,
P004025 INTEGER NOT NULL,
P004026 INTEGER NOT NULL,
P004027 INTEGER NOT NULL,
P004028 INTEGER NOT NULL,
P004029 INTEGER NOT NULL,
P004030 INTEGER NOT NULL,
P004031 INTEGER NOT NULL,
P004032 INTEGER NOT NULL,
P004033 INTEGER NOT NULL,
P004034 INTEGER NOT NULL,
P004035 INTEGER NOT NULL,
P004036 INTEGER NOT NULL,
P004037 INTEGER NOT NULL,
P004038 INTEGER NOT NULL,
P004039 INTEGER NOT NULL,
P004040 INTEGER NOT NULL,
P004041 INTEGER NOT NULL,
P004042 INTEGER NOT NULL,
P004043 INTEGER NOT NULL,
P004044 INTEGER NOT NULL,
P004045 INTEGER NOT NULL,
P004046 INTEGER NOT NULL,
P004047 INTEGER NOT NULL,
P004048 INTEGER NOT NULL,
P004049 INTEGER NOT NULL,
P004050 INTEGER NOT NULL,
P004051 INTEGER NOT NULL,
P004052 INTEGER NOT NULL,
P004053 INTEGER NOT NULL,
P004054 INTEGER NOT NULL,
P004055 INTEGER NOT NULL,
P004056 INTEGER NOT NULL,
P004057 INTEGER NOT NULL,
P004058 INTEGER NOT NULL,
P004059 INTEGER NOT NULL,
P004060 INTEGER NOT NULL,
P004061 INTEGER NOT NULL,
P004062 INTEGER NOT NULL,
P004063 INTEGER NOT NULL,
P004064 INTEGER NOT NULL,
P004065 INTEGER NOT NULL,
P004066 INTEGER NOT NULL,
P004067 INTEGER NOT NULL,
P004068 INTEGER NOT NULL,
P004069 INTEGER NOT NULL,
P004070 INTEGER NOT NULL,
P004071 INTEGER NOT NULL,
P004072 INTEGER NOT NULL,
P004073 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,
P005018 INTEGER NOT NULL,
P005019 INTEGER NOT NULL,
P005020 INTEGER NOT NULL,
P005021 INTEGER NOT NULL,
P005022 INTEGER NOT NULL,
P005023 INTEGER NOT NULL,
P005024 INTEGER NOT NULL,
P005025 INTEGER NOT NULL,
P005026 INTEGER NOT NULL,
P005027 INTEGER NOT NULL,
P005028 INTEGER NOT NULL,
P005029 INTEGER NOT NULL,
P005030 INTEGER NOT NULL,
P005031 INTEGER NOT NULL,
P005032 INTEGER NOT NULL,
P005033 INTEGER NOT NULL,
P005034 INTEGER NOT NULL,
P005035 INTEGER NOT NULL,
P005036 INTEGER NOT NULL,
P005037 INTEGER NOT NULL,
P005038 INTEGER NOT NULL,
P005039 INTEGER NOT NULL,
P005040 INTEGER NOT NULL,
P005041 INTEGER NOT NULL,
P005042 INTEGER NOT NULL,
P005043 INTEGER NOT NULL,
P005044 INTEGER NOT NULL,
P005045 INTEGER NOT NULL,
P005046 INTEGER NOT NULL,
P005047 INTEGER NOT NULL,
P005048 INTEGER NOT NULL,
P005049 INTEGER NOT NULL,
P005050 INTEGER NOT NULL,
P005051 INTEGER NOT NULL,
P005052 INTEGER NOT NULL,
P005053 INTEGER NOT NULL,
P005054 INTEGER NOT NULL,
P005055 INTEGER NOT NULL,
P005056 INTEGER NOT NULL,
P005057 INTEGER NOT NULL,
P005058 INTEGER NOT NULL,
P005059 INTEGER NOT NULL,
P005060 INTEGER NOT NULL,
P005061 INTEGER NOT NULL,
P005062 INTEGER NOT NULL,
P005063 INTEGER NOT NULL,
P005064 INTEGER NOT NULL,
P005065 INTEGER NOT NULL,
P005066 INTEGER NOT NULL,
P005067 INTEGER NOT NULL,
P005068 INTEGER NOT NULL,
P005069 INTEGER NOT NULL,
P005070 INTEGER NOT NULL,
P005071 INTEGER NOT NULL
);
CREATE TABLE sf1_02 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(2) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
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,
P006008 INTEGER NOT NULL,
P006009 INTEGER NOT NULL,
P006010 INTEGER NOT NULL,
P006011 INTEGER NOT NULL,
P006012 INTEGER NOT NULL,
P006013 INTEGER NOT NULL,
P006014 INTEGER NOT NULL,
P006015 INTEGER NOT NULL,
P006016 INTEGER NOT NULL,
P006017 INTEGER NOT NULL,
P006018 INTEGER NOT NULL,
P006019 INTEGER NOT NULL,
P006020 INTEGER NOT NULL,
P006021 INTEGER NOT NULL,
P006022 INTEGER NOT NULL,
P006023 INTEGER NOT NULL,
P006024 INTEGER NOT NULL,
P006025 INTEGER NOT NULL,
P006026 INTEGER NOT NULL,
P006027 INTEGER NOT NULL,
P006028 INTEGER NOT NULL,
P006029 INTEGER NOT NULL,
P006030 INTEGER NOT NULL,
P006031 INTEGER NOT NULL,
P006032 INTEGER NOT NULL,
P006033 INTEGER NOT NULL,
P006034 INTEGER NOT NULL,
P006035 INTEGER NOT NULL,
P006036 INTEGER NOT NULL,
P006037 INTEGER NOT NULL,
P006038 INTEGER NOT NULL,
P006039 INTEGER NOT NULL,
P006040 INTEGER NOT NULL,
P006041 INTEGER NOT NULL,
P006042 INTEGER NOT NULL,
P006043 INTEGER NOT NULL,
P006044 INTEGER NOT NULL,
P006045 INTEGER NOT NULL,
P006046 INTEGER NOT NULL,
P006047 INTEGER NOT NULL,
P006048 INTEGER NOT NULL,
P006049 INTEGER NOT NULL,
P006050 INTEGER NOT NULL,
P006051 INTEGER NOT NULL,
P006052 INTEGER NOT NULL,
P006053 INTEGER NOT NULL,
P006054 INTEGER NOT NULL,
P006055 INTEGER NOT NULL,
P006056 INTEGER NOT NULL,
P006057 INTEGER NOT NULL,
P006058 INTEGER NOT NULL,
P006059 INTEGER NOT NULL,
P006060 INTEGER NOT NULL,
P006061 INTEGER NOT NULL,
P006062 INTEGER NOT NULL,
P006063 INTEGER NOT NULL,
P006064 INTEGER NOT NULL,
P006065 INTEGER NOT NULL,
P006066 INTEGER NOT NULL,
P006067 INTEGER NOT NULL,
P006068 INTEGER NOT NULL,
P006069 INTEGER NOT NULL,
P006070 INTEGER NOT NULL,
P006071 INTEGER NOT NULL,
P006072 INTEGER NOT NULL,
P006073 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,
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,
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,
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,
P011001 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,
P015001 INTEGER NOT NULL,
P016001 INTEGER NOT NULL,
P017001 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,
P018010 INTEGER NOT NULL,
P018011 INTEGER NOT NULL,
P018012 INTEGER NOT NULL,
P018013 INTEGER NOT NULL,
P018014 INTEGER NOT NULL,
P018015 INTEGER NOT NULL,
P018016 INTEGER NOT NULL,
P018017 INTEGER NOT NULL,
P018018 INTEGER NOT NULL,
P018019 INTEGER NOT NULL
);
CREATE TABLE sf1_03 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(2) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
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,
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,
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,
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,
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,
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,
P026012 INTEGER NOT NULL,
P026013 INTEGER NOT NULL,
P026014 INTEGER NOT NULL,
P026015 INTEGER NOT NULL,
P026016 INTEGER NOT NULL,
P027001 INTEGER NOT NULL,
P027002 INTEGER NOT NULL,
P027003 INTEGER NOT NULL,
P027004 INTEGER NOT NULL,
P027005 INTEGER NOT NULL,
P027006 INTEGER NOT NULL,
P027007 INTEGER NOT NULL,
P027008 INTEGER NOT NULL,
P027009 INTEGER NOT NULL,
P027010 INTEGER NOT NULL,
P027011 INTEGER NOT NULL,
P027012 INTEGER NOT NULL,
P027013 INTEGER NOT NULL,
P027014 INTEGER NOT NULL,
P027015 INTEGER NOT NULL,
P027016 INTEGER NOT NULL,
P027017 INTEGER NOT NULL,
P027018 INTEGER NOT NULL,
P027019 INTEGER NOT NULL,
P027020 INTEGER NOT NULL,
P027021 INTEGER NOT NULL,
P027022 INTEGER NOT NULL,
P027023 INTEGER NOT NULL,
P027024 INTEGER NOT NULL,
P027025 INTEGER NOT NULL,
P027026 INTEGER NOT NULL,
P027027 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,
P028017 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,
P029029 INTEGER NOT NULL,
P029030 INTEGER NOT NULL,
P029031 INTEGER NOT NULL,
P029032 INTEGER NOT NULL,
P029033 INTEGER NOT NULL,
P029034 INTEGER NOT NULL,
P029035 INTEGER NOT NULL,
P029036 INTEGER NOT NULL,
P029037 INTEGER NOT NULL,
P029038 INTEGER NOT NULL,
P029039 INTEGER NOT NULL,
P029040 INTEGER NOT NULL,
P029041 INTEGER NOT NULL,
P029042 INTEGER NOT NULL,
P029043 INTEGER NOT NULL,
P029044 INTEGER NOT NULL,
P029045 INTEGER NOT NULL,
P029046 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,
P030014 INTEGER NOT NULL,
P030015 INTEGER NOT NULL,
P030016 INTEGER NOT NULL,
P030017 INTEGER NOT NULL,
P030018 INTEGER NOT NULL,
P030019 INTEGER NOT NULL,
P030020 INTEGER NOT NULL,
P030021 INTEGER NOT NULL,
P030022 INTEGER NOT NULL,
P031001 FLOAT NOT NULL,
P032001 FLOAT NOT NULL,
P033001 FLOAT NOT NULL
);
CREATE TABLE sf1_04 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(2) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
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,
P035001 INTEGER NOT NULL,
P035002 INTEGER NOT NULL,
P035003 INTEGER NOT NULL,
P035004 INTEGER NOT NULL,
P035005 INTEGER NOT NULL,
P035006 INTEGER NOT NULL,
P035007 INTEGER NOT NULL,
P035008 INTEGER NOT NULL,
P035009 INTEGER NOT NULL,
P035010 INTEGER NOT NULL,
P035011 INTEGER NOT NULL,
P035012 INTEGER NOT NULL,
P035013 INTEGER NOT NULL,
P035014 INTEGER NOT NULL,
P035015 INTEGER NOT NULL,
P035016 INTEGER NOT NULL,
P035017 INTEGER NOT NULL,
P035018 INTEGER NOT NULL,
P035019 INTEGER NOT NULL,
P035020 INTEGER NOT NULL,
P036001 INTEGER NOT NULL,
P036002 INTEGER NOT NULL,
P036003 INTEGER NOT NULL,
P036004 INTEGER NOT NULL,
P036005 INTEGER NOT NULL,
P036006 INTEGER NOT NULL,
P036007 INTEGER NOT NULL,
P036008 INTEGER NOT NULL,
P036009 INTEGER NOT NULL,
P036010 INTEGER NOT NULL,
P036011 INTEGER NOT NULL,
P036012 INTEGER NOT NULL,
P036013 INTEGER NOT NULL,
P036014 INTEGER NOT NULL,
P036015 INTEGER NOT NULL,
P036016 INTEGER NOT NULL,
P036017 INTEGER NOT NULL,
P036018 INTEGER NOT NULL,
P036019 INTEGER NOT NULL,
P036020 INTEGER NOT NULL,
P037001 INTEGER NOT NULL,
P037002 INTEGER NOT NULL,
P037003 INTEGER NOT NULL,
P037004 INTEGER NOT NULL,
P037005 INTEGER NOT NULL,
P037006 INTEGER NOT NULL,
P037007 INTEGER NOT NULL,
P037008 INTEGER NOT NULL,
P037009 INTEGER 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,
P038021 INTEGER NOT NULL,
P038022 INTEGER NOT NULL,
P038023 INTEGER NOT NULL,
P038024 INTEGER NOT NULL,
P038025 INTEGER NOT NULL,
P038026 INTEGER NOT NULL,
P038027 INTEGER NOT NULL,
P038028 INTEGER NOT NULL,
P038029 INTEGER NOT NULL,
P038030 INTEGER NOT NULL,
P038031 INTEGER NOT NULL,
P038032 INTEGER NOT NULL,
P038033 INTEGER NOT NULL,
P038034 INTEGER NOT NULL,
P038035 INTEGER NOT NULL,
P038036 INTEGER NOT NULL,
P038037 INTEGER NOT NULL,
P038038 INTEGER NOT NULL,
P038039 INTEGER NOT NULL,
P038040 INTEGER NOT NULL,
P038041 INTEGER NOT NULL,
P038042 INTEGER NOT NULL,
P038043 INTEGER NOT NULL,
P038044 INTEGER NOT NULL,
P038045 INTEGER NOT NULL,
P038046 INTEGER NOT NULL,
P038047 INTEGER NOT NULL,
P038048 INTEGER NOT NULL,
P038049 INTEGER NOT NULL,
P038050 INTEGER NOT NULL,
P038051 INTEGER NOT NULL,
P038052 INTEGER NOT NULL,
P038053 INTEGER NOT NULL,
P038054 INTEGER NOT NULL,
P038055 INTEGER NOT NULL,
P038056 INTEGER NOT NULL,
P038057 INTEGER NOT NULL,
P039001 INTEGER NOT NULL,
P039002 INTEGER NOT NULL,
P039003 INTEGER NOT NULL,
P039004 INTEGER NOT NULL,
P039005 INTEGER NOT NULL,
P040001 INTEGER NOT NULL,
P040002 INTEGER NOT NULL,
P040003 INTEGER NOT NULL,
P041001 INTEGER NOT NULL,
P041002 INTEGER NOT NULL,
P041003 INTEGER NOT NULL,
P042001 INTEGER NOT NULL,
P042002 INTEGER NOT NULL,
P042003 INTEGER NOT NULL,
P043001 INTEGER NOT NULL,
P043002 INTEGER NOT NULL,
P043003 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
);
CREATE TABLE sf1_05 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(2) NOT NULL,
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
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,