Chapter Contents

Previous

Next
SAS/ACCESS Software for Relational Databases: Reference

DBMS Tables (Airline Data)

The following data was created for a fictitious international airline. The code that creates these tables is contained in the GENSQL.SAS file that is included with your SAS software.


DELAY Table

The data in the DELAY table is shown in DELAY Table.

DELAY Table
FLIGHT DATES ORIG DEST DELAYCAT DESTTYPE DELAY
114 01MAR1998 LGA LAX 1-10 Minutes Domestic 8
202 01MAR1998 LGA ORD No Delay Domestic -5
219 01MAR1998 LGA LON 11+ Minutes International 18
622 01MAR1998 LGA FRA No Delay International -5
132 01MAR1998 LGA YYZ 11+ Minutes International 14
271 01MAR1998 LGA PAR 1-10 Minutes International 5
302 01MAR1998 LGA WAS No Delay Domestic -2
114 02MAR1998 LGA LAX No Delay Domestic 0
202 02MAR1998 LGA ORD 1-10 Minutes Domestic 5
219 02MAR1998 LGA LON 11+ Minutes International 18
622 02MAR1998 LGA FRA No Delay International 0
132 02MAR1998 LGA YYZ 1-10 Minutes International 5
271 02MAR1998 LGA PAR 1-10 Minutes International 4
302 02MAR1998 LGA WAS No Delay Domestic 0
114 03MAR1998 LGA LAX No Delay Domestic -1
202 03MAR1998 LGA ORD No Delay Domestic -1
219 03MAR1998 LGA LON 1-10 Minutes International 4
622 03MAR1998 LGA FRA No Delay International -2
132 03MAR1998 LGA YYZ 1-10 Minutes International 6
271 03MAR1998 LGA PAR 1-10 Minutes International 2
302 03MAR1998 LGA WAS 1-10 Minutes Domestic 5
114 04MAR1998 LGA LAX 11+ Minutes Domestic 15
202 04MAR1998 LGA ORD No Delay Domestic -5
219 04MAR1998 LGA LON 1-10 Minutes International 3
622 04MAR1998 LGA FRA 11+ Minutes International 30
132 04MAR1998 LGA YYZ No Delay International -5
271 04MAR1998 LGA PAR 1-10 Minutes International 5
302 04MAR1998 LGA WAS 1-10 Minutes Domestic 7
114 05MAR1998 LGA LAX No Delay Domestic -2
202 05MAR1998 LGA ORD 1-10 Minutes Domestic 2
219 05MAR1998 LGA LON 1-10 Minutes International 3
622 05MAR1998 LGA FRA No Delay International -6
132 05MAR1998 LGA YYZ 1-10 Minutes International 3
271 05MAR1998 LGA PAR 1-10 Minutes International 5
114 06MAR1998 LGA LAX No Delay Domestic -1
202 06MAR1998 LGA ORD No Delay Domestic -3
219 06MAR1998 LGA LON 11+ Minutes International 27
132 06MAR1998 LGA YYZ 1-10 Minutes International 7
302 06MAR1998 LGA PAR 1-10 Minutes Domestic 1
114 07MAR1998 LGA LAX No Delay Domestic -1
202 07MAR1998 LGA ORD No Delay Domestic -2
219 07MAR1998 LGA LON 11+ Minutes International 15
622 07MAR1998 LGA FRA 11+ Minutes International 21
132 07MAR1998 LGA YYZ No Delay International -2
271 07MAR1998 LGA PAR 1-10 Minutes International 4
302 07MAR1998 LGA WAS No Delay Domestic 0


INTERNAT Table

The data in the INTERNAT table is shown in INTERNAT Table.

INTERNAT Table
FLIGHT DATES DEST BOARDED
219 01MAR1998 LON 198
622 01MAR1998 FRA 207
132 01MAR1998 YYZ 115
271 01MAR1998 PAR 138
219 02MAR1998 LON 147
622 02MAR1998 FRA 176
132 02MAR1998 YYZ 106
271 02MAR1998 PAR 172
219 03MAR1998 LON 197
622 03MAR1998 FRA 180
132 03MAR1998 YYZ 75
271 03MAR1998 PAR 147
219 04MAR1998 LON 232
622 04MAR1998 FRA 137
132 04MAR1998 YYZ 117
271 04MAR1998 PAR 146
219 05MAR1998 LON 160
622 05MAR1998 FRA 185
132 05MAR1998 YYZ 157
271 05MAR1998 PAR 177
219 06MAR1998 LON 163
132 06MAR1998 YYZ 150
219 07MAR1998 LON 241
622 07MAR1998 FRA 210
132 07MAR1998 YYZ 164
271 07MAR1998 PAR 155


MARCH Table

The data in the MARCH table is shown in MARCH Table.

MARCH Table
FLIGHT DATES DEPART ORIG DEST MILES BOARDED CAPACITY
114 01MAR1998 7:10 LGA LAX 2475 172 210
202 01MAR1998 10:43 LGA ORD 740 151 210
219 01MAR1998 9:31 LGA LON 3442 198 250
622 01MAR1998 12:19 LGA FRA 3857 207 250
132 01MAR1998 15:35 LGA YYZ 366 115 178
271 01MAR1998 13:17 LGA PAR 3635 138 250
302 01MAR1998 20:22 LGA WAS 229 105 180
114 02MAR1998 7:10 LGA LAX 2475 119 210
202 02MAR1998 10:43 LGA ORD 740 120 210
219 02MAR1998 9:31 LGA LON 3442 147 250
622 02MAR1998 12:19 LGA FRA 3857 176 250
132 02MAR1998 15:35 LGA YYZ 366 106 178
302 02MAR1998 20:22 LGA WAS 229 78 180
271 02MAR1998 13:17 LGA PAR 3635 104 250
114 03MAR1998 7:10 LGA LAX 2475 197 210
202 03MAR1998 10:43 LGA ORD 740 118 210
219 03MAR1998 9:31 LGA LON 3442 197 250
622 03MAR1998 12:19 LGA FRA 3857 180 250
132 03MAR1998 15:35 LGA YYZ 366 75 178
271 03MAR1998 13:17 LGA PAR 3635 147 250
302 03MAR1998 20:22 LGA WAS 229 123 180
114 04MAR1998 7:10 LGA LAX 2475 178 210
202 04MAR1998 10:43 LGA ORD 740 148 210
219 04MAR1998 9:31 LGA LON 3442 232 250
622 04MAR1998 12:19 LGA FRA 3857 137 250
132 04MAR1998 15:35 LGA YYZ 366 117 178
271 04MAR1998 13:17 LGA PAR 3635 146 250
302 04MAR1998 20:22 LGA WAS 229 115 180
114 05MAR1998 7:10 LGA LAX 2475 117 210
202 05MAR1998 10:43 LGA ORD 740 104 210
219 05MAR1998 9:31 LGA LON 3442 160 250
622 05MAR1998 12:19 LGA FRA 3857 185 250
132 05MAR1998 15:35 LGA YYZ 366 157 178
271 05MAR1998 13:17 LGA PAR 3635 177 250
114 06MAR1998 7:10 LGA LAX 2475 128 210
202 06MAR1998 10:43 LGA ORD 740 115 210
219 06MAR1998 9:31 LGA LON 3442 163 250
132 06MAR1998 15:35 LGA YYZ 366 150 178
302 06MAR1998 20:22 LGA WAS 229 66 180
114 07MAR1998 7:10 LGA LAX 2475 160 210
202 07MAR1998 10:43 LGA ORD 740 175 210
219 07MAR1998 9:31 LGA LON 3442 241 250
622 07MAR1998 12:19 LGA FRA 3857 210 250
132 07MAR1998 15:35 LGA YYZ 366 164 178
271 07MAR1998 13:17 LGA PAR 3635 155 250
302 07MAR1998 20:22 LGA WAS 229 135 180


STAFF Table

The data in the STAFF table is shown in STAFF Table.

STAFF Table
IDNUM SEX JOBCODE SALARY BIRTH HIRED
1919 M TA2 34376 12SEP1960 04JUN1987
1653 F ME2 35108 15OCT1964 09AUG1990
1400 M ME1 29769 05NOV1967 16OCT1990
1350 F FA3 32886 31AUG1965 29JUL1990
1401 M TA3 38822 13DEC1950 17NOV1985
1499 M ME3 43025 26APR1954 07JUN1980
1101 M SCP 18723 06JUN1962 01OCT1990
1333 M PT2 88606 30MAR1961 10FEB1981
1402 M TA2 32615 17JAN1963 02DEC1990
1479 F TA3 38785 22DEC1968 05OCT1989
1403 M ME1 28072 28JAN1969 21DEC1991
1739 M PT1 66517 25DEC1964 27JAN1991
1658 M SCP 17943 08APR1967 29FEB1992
1428 F PT1 68767 04APR1960 16NOV1991
1782 M ME2 35345 04DEC1970 22FEB1992
1244 M ME2 36925 31AUG1963 17JAN1988
1383 M BCK 25823 25JAN1968 20OCT1992
1574 M FA2 28572 27APR1960 20DEC1992
1789 M SCP 18326 25JAN1957 11APR1978
1404 M PT2 91376 24FEB1953 01JAN1980
1437 F FA3 33104 20SEP1960 31AUG1984
1639 F TA3 40260 26JUN1957 28JAN1984
1269 M NA1 41690 03MAY1972 28NOV1992
1065 M ME2 35090 26JAN1944 07JAN1987
1876 M TA3 39675 20MAY1958 27APR1985
1037 F TA1 28558 10APR1964 13SEP1992
1129 F ME2 34929 08DEC1961 17AUG1991
1988 M FA3 32217 30NOV1959 18SEP1984
1405 M SCP 18056 05MAR1966 26JAN1992
1430 F TA2 32925 28FEB1962 27APR1987
1983 F FA3 33419 28FEB1962 27APR1987
1134 F TA2 33462 05MAR1969 21DEC1988
1118 M PT3 11379 16JAN1944 18DEC1980
1438 F TA3 39223 15MAR1965 18NOV1987
1125 F FA2 28888 08NOV1968 11DEC1987
1475 F FA2 27787 15DEC1961 13JUL1990
1117 M TA3 39771 05JUN1963 13AUG1992
1935 F NA2 51081 28MAR1954 16OCT1981
1124 F FA1 23177 10JUL1958 01OCT1990
1422 F FA1 22454 04JUN1964 06APR1991
1616 F TA2 34137 01MAR1970 04JUN1993
1406 M ME2 35185 08MAR1961 17FEB1987
1120 M ME1 28619 11SEP1972 07OCT1993
1094 M FA1 22268 02APR1970 17APR1991
1389 M BCK 25028 15JUL1959 18AUG1990
1905 M PT1 65111 16APR1972 29MAY1992
1407 M PT1 68096 23MAR1969 18MAR1990
1114 F TA2 32928 18SEP1969 27JUN1987
1410 M PT2 84685 03MAY1967 07NOV1986
1439 F PT1 70736 06MAR1964 10SEP1990
1409 M ME3 41551 19APR1950 22OCT1981
1408 M TA2 34138 29MAR1960 14OCT1987
1121 M ME1 29112 26SEP1971 07DEC1991
1991 F TA1 27645 07MAY1972 12DEC1992
1102 M TA2 34542 01OCT1959 15APR1991
1356 M ME2 36869 26SEP1957 22FEB1983
1545 M PT1 66130 12AUG1959 29MAY1990
1292 F ME2 366991 28OCT1964 02JUL1989
1440 F ME2 35757 27SEP1962 09APR1991
1368 M FA2 27808 11JUN1961 03NOV1984
1369 M TA2 33705 28DEC1961 13MAR1987
1411 M FA2 27265 27MAY1961 01DEC1989
1113 F FA1 22367 15JAN1968 17OCT1991
1704 M BCK 25465 30AUG1966 28JUN1987
1900 M ME2 35105 25MAY1962 27OCT1987
1126 F TA3 40899 28MAY1963 21NOV1980
1677 M BCK 26007 05NOV1963 27MAR1989
1441 F FA2 27158 19NOV1969 23MAR1991
1421 M TA2 33155 08JAN1959 28FEB1990
1119 M TA1 26924 20JUN1962 06SEP1988
1834 M BCK 26896 08FEB1972 02JUL1992
1777 M PT3 9630 23SEP1951 21JUN1981
1663 M BCK 26452 11JAN1967 11AUG1991
1106 M PT2 89632 06NOV1957 16AUG1984
1103 F FA1 23738 16FEB1968 23JUL1992
1477 M FA2 28566 21MAR1964 07MAR1988
1476 F TA2 34803 30MAY1966 17MAR1987
1379 M ME3 42264 08AUG1961 10JUN1984
1104 M SCP 17946 25APR1963 10JUN1991
1009 M TA1 28880 02MAR1959 26MAR1992
1412 M ME1 27799 18JUN1956 05DEC1991
1115 F FA3 32699 22AUG1960 29FEB1980
1128 F TA2 32777 23MAY1965 20OCT1990
1442 F PT2 84536 05SEP1966 12APR1988
1417 M NA2 52270 27JUN1964 07MAR1989
1478 M PT2 84203 09AUG1959 24OCT1990
1673 M BCK 25477 27FEB1970 15JUL1991
1839 F NA1 43433 29NOV1970 03JUL1993
1347 M TA3 40079 21SEP1967 06SEP1984
1423 F ME2 35773 14MAY1968 19AUG1990
1200 F ME1 27816 10JAN1971 14AUG1992
1970 F FA1 22615 25SEP1964 12MAR1991
1521 M ME3 41526 12APR1963 13JUL1988
1354 F SCP 18335 29MAY1971 16JUN1992
1424 F FA2 28978 04AUG1969 11DEC1989
1132 F FA1 22413 30MAY1972 22OCT1993
1845 M BCK 25996 20NOV1959 22MAR1980
1556 M PT1 71349 22JUN1964 11DEC1991
1413 M FA2 27435 16SEP1965 02JAN1990
1123 F TA1 28407 31OCT1972 05DEC1992
1907 M TA2 33329 15NOV1960 06JUL1987
1436 F TA2 34475 11JUN1964 12MAR1987
1385 M ME3 43900 16JAN1962 01APR1986
1432 F ME2 35327 03NOV1961 10FEB1985
1111 M NA1 40586 14JUL1973 31OCT1992
1116 F FA1 22862 28SEP1969 21MAR1991
1352 M NA2 53798 02DEC1960 16OCT1986
1555 F FA2 27499 16MAR1968 04JUL1992
1038 F TA1 26533 09NOV1969 23NOV1991
1420 M ME3 43071 19FEB1965 22JUL1987
1561 M TA2 34514 30NOV1963 07OCT1987
1434 F FA2 28622 11JUL1962 28OCT1990
1414 M FA1 23644 24MAR1972 12APR1992
1112 M TA1 26905 29NOV1964 07DEC1992
1390 M FA2 27761 19FEB1965 23JUN1991
1332 M NA1 42178 17SEP1970 04JUN1991
1890 M PT2 91908 20JUL1951 25NOV1979
1429 F TA1 27939 28FEB1960 07AUG1992
1107 M PT2 89977 09JUN1954 10FEB1979
1908 F TA2 32995 10DEC1969 23APR1990
1830 F PT2 84471 27MAY1957 29JAN1983
1882 M ME3 41538 10JUL1957 21NOV1978
1050 M ME2 35167 14JUL1963 24AUG1986
1425 F FA1 23979 28DEC1971 28FEB1993
1928 M PT2 89858 16SEP1954 13JUL1990
1480 F TA3 39583 03SEP1957 25MAR1981
1100 M BCK 25004 01DEC1960 07MAY1988
1995 F ME1 28810 24AUG1973 19SEP1993
1135 F FA2 27321 20SEP1960 31MAR1990
1415 M FA2 28278 09MAR1958 12FEB1988
1076 M PT1 66558 14OCT1955 03OCT1991
1426 F TA2 32991 05DEC1966 25JUN1990
1564 F SCP 18833 12APR1962 01JUL1992
1221 F FA2 27896 22SEP1967 04OCT1991
1133 M TA1 27701 13JUL1966 12FEB1992
1435 F TA3 38808 12MAY1959 08FEB1980
1418 M ME1 28005 29MAR1957 06JAN1992
1017 M TA3 40858 28DEC1957 16OCT1981
1443 F NA1 42274 17NOV1968 29AUG1991
1131 F TA2 32575 26DEC1971 19APR1991
1427 F TA2 34046 31OCT1970 30JAN1990
1036 F TA3 39362 19MAY1965 23OCT1984
1130 F FA1 23916 16MAY1971 05JUN1992
1127 F TA2 33011 09NOV1964 07DEC1986
1433 F FA3 32982 08JUL1966 17JAN1987
1431 F FA3 33230 09JUN1964 05APR1988
1122 F FA2 27956 01MAY1963 27NOV1988
1105 M ME2 34805 01MAR1962 13AUG1990
1639 F TA3 42260 26JUN1957 28JAN1984
1065 M ME3 38090 26JAN1944 07JAN1987
1561 M TA3 36514 30NOV1963 07OCT1987
1221 F FA3 29896 22SEP1967 04OCT1991
1447 F FA1 22123 07AUG1972 29OCT1992
1998 M SCP 23100 10SEP1970 02NOV1992
1036 F TA3 42465 19MAY1965 23OCT1984
1106 M PT3 94039 06NOV1957 16AUG1984
1129 F ME3 36758 08DEC1961 17AUG1991
1350 F FA3 36098 31AUG1965 29JUL1990
1369 M TA3 36598 28DEC1961 13MAR1987
1076 M PT1 69742 14OCT1955 03OCT1991

The data in the STAFF table continues with additional columns, as shown in STAFF Table.

STAFF Table
IDNUM LNAME FNAME CITY STATE HPHONE
1919 ADAMS GERALD STAMFORD CT 203/781-1255
1653 ALIBRANDI MARIA BRIDGEPORT CT 203/675-7715
1400 ALHERTANI ABDULLAH NEW YORK NY 212/586-0808
1350 ALVAREZ MERCEDES NEW YORK NY 718/383-1549
1401 ALVAREZ CARLOS PATERSON NJ 201/732-8787
1499 BAREFOOT JOSEPH PRINCETON NJ 201/812-5665
1101 BAUCOM WALTER NEW YORK NY 212/586-8060
1333 BANADYGA JUSTIN STAMFORD CT 203/781-1777
1402 BLALOCK RALPH NEW YORK NY 718/384-2849
1479 BALLETTI MARIE NEW YORK NY 718/384-8816
1403 BOWDEN EARL BRIDGEPORT CT 203/675-3434
1739 BRANCACCIO JOSEPH NEW YORK NY 212/587-1247
1658 BREUHAUS JEREMY NEW YORK NY 212/587-3622
1428 BRADY CHRISTINE STAMFORD CT 203/781-1212
1782 BRECZAK JAKOB STAMFORD CT 203/781-0019
1244 BUCCI ANTHONY NEW YORK NY 718/383-3334
1383 BURNETTE THOMAS NEW YORK NY 718/384-3569
1574 CAHILL MARSHALL NEW YORK NY 718/383-2338
1789 CARAWAY DAVIS NEW YORK NY 212/587-9000
1404 COHEN LEE NEW YORK NY 718/384-2946
1437 CARTER DOROTHY BRIDGEPORT CT 203/675-4117
1639 CARTER-COHEN KAREN STAMFORD CT 203/781-8839
1269 CASTON FRANKLIN STAMFORD CT 203/781-3335
1065 COPAS FREDERICO NEW YORK NY 718/384-5618
1876 CHIN JACK NEW YORK NY 212/588-5634
1037 CHOW JANE STAMFORD CT 203/781-8868
1129 COUNIHAN BRENDA NEW YORK NY 718/383-2313
1988 COOPER ANTHONY NEW YORK NY 212/587-1228
1405 DACKO JASON PATERSON NJ 201/732-2323
1430 DABROWSKI SANDRA BRIDGEPORT CT 203/675-1647
1983 DEAN SHARON NEW YORK NY 718/384-1647
1134 DELGADO MARIA STAMFORD CT 203/781-1528
1118 DENNIS ROGER NEW YORK NY 718/383-1122
1438 DABBOUSSI KAMILLA STAMFORD CT 203/781-2229
1125 DUNLAP DONNA NEW YORK NY 718/383-2094
1475 ELGES MARGARETE NEW YORK NY 718/383-2828
1117 EDGERTON JOSHUA NEW YORK NY 212/588-1239
1935 FERNANDEZ KATRINA BRIDGEPORT CT 203/675-2962
1124 FIELDS DIANA WHITE PLAINS NY 914/455-2998
1422 FUJIHARA KYOKO PRINCETON NJ 201/812-0902
1616 FUENTAS CARLA NEW YORK NY 718/384-3329
1406 FOSTER GERALD BRIDGEPORT CT 203/675-6363
1120 GARCIA JACK NEW YORK NY 718/384-4930
1094 GOMEZ ALAN BRIDGEPORT CT 203/675-7181
1389 GOLDSTEIN LEVI NEW YORK NY 718/384-9326
1905 GRAHAM ALVIN NEW YORK NY 212/586-8815
1407 GREGORSKI DANIEL MT. VERNON NY 914/468-1616
1114 GREENWALD JANICE NEW YORK NY 212/588-1092
1410 HARRIS CHARLES STAMFORD CT 203/781-0937
1439 HASENHAUER CHRISTINA BRIDGEPORT CT 203/675-4987
1409 HAVELKA RAYMOND STAMFORD CT 203/781-9697
1408 HENDERSON WILLIAM PRINCETON NJ 201/812-4789
1121 HERNANDEZ ROBERTO NEW YORK NY 718/384-3313
1991 HOWARD GRETCHEN BRIDGEPORT CT 203/675-0007
1102 HERMANN JOACHIM WHITE PLAINS NY 914/455-0976
1356 HOWARD MICHAEL NEW YORK NY 212/586-8411
1545 HERRERO CLYDE STAMFORD CT 203/781-1119
1292 HUNTER HELEN BRIDGEPORT CT 203/675-4830
1440 JACKSON LAURA STAMFORD CT 203/781-0088
1368 JEPSON RONALD STAMFORD CT 203/781-8413
1369 JONSON ANTHONY NEW YORK NY 212/587-5385
1411 JOHNSON JACKSON PATERSON NJ 201/732-3678
1113 JONES LESLIE NEW YORK NY 718/383-3003
1704 JONES NATHAN NEW YORK NY 718/384-0049
1900 KING WILLIAM NEW YORK NY 718/383-3698
1126 KIMANI ANNE NEW YORK NY 212/586-1229
1677 KRAMER JACKSON BRIDGEPORT CT 203/675-7432
1441 LAWRENCE KATHY PRINCETON NJ 201/812-3337
1421 LEE RUSSELL MT. VERNON NY 914/468-9143
1119 LI JEFF NEW YORK NY 212/586-2344
1834 LEBLANC RUSSELL NEW YORK NY 718/384-0040
1777 LUFKIN ROY NEW YORK NY 718/383-4413
1663 MARKS JOHN NEW YORK NY 212/587-7742
1106 MARSHBURN JASPER STAMFORD CT 203/781-1457
1103 MCDANIEL RONDA NEW YORK NY 212/586-0013
1477 MEYERS PRESTON BRIDGEPORT CT 203/675-8125
1476 MONROE JOYCE STAMFORD CT 203/781-2837
1379 MORGAN ALFRED STAMFORD CT 203/781-2216
1104 MORGAN CHRISTOPHER NEW YORK NY 718/383-9740
1009 MORGAN GEORGE NEW YORK NY 212/586-7753
1412 MURPHEY JOHN PRINCETON NJ 201/812-4414
1115 MURPHY ALICE NEW YORK NY 718/384-1982
1128 NELSON FELICIA BRIDGEPORT CT 203/675-1166
1442 NEWKIRK SANDRA PRINCETON NJ 201/812-3331
1417 NEWKIRK WILLIAM PATERSON NJ 201/732-6611
1478 NEWTON JAMES NEW YORK NY 212/587-5549
1673 NICHOLLS HENRY STAMFORD CT 203/781-7770
1839 NORRIS DIANE NEW YORK NY 718/384-1767
1347 O'NEAL BRYAN NEW YORK NY 718/384-0230
1423 OSWALD LESLIE MT. VERNON NY 914/468-9171
1200 OVERMAN MICHELLE STAMFORD CT 203/781-1835
1970 PARKER ANNE NEW YORK NY 718/383-3895
1521 PARKER JAY NEW YORK NY 212/587-7603
1354 PARKER MARY WHITE PLAINS NY 914/455-2337
1424 PATTERSON RENEE NEW YORK NY 212/587-8991
1132 PEARCE CAROL NEW YORK NY 718/384-1986
1845 PEARSON JAMES NEW YORK NY 718/384-2311
1556 PENNINGTON MICHAEL NEW YORK NY 718/383-5681
1413 PETERS RANDALL PRINCETON NJ 201/812-2478
1123 PETERSON SUZANNE NEW YORK NY 718/383-0077
1907 PHELPS WILLIAM STAMFORD CT 203/781-1118
1436 PORTER SUSAN NEW YORK NY 718/383-5777
1385 RAYNOR MILTON BRIDGEPORT CT 203/675-2846
1432 REED MARILYN MT. VERNON NY 914/468-5454
1111 RHODES JEREMY PRINCETON NJ 201/812-1837
1116 RICHARDS CASEY NEW YORK NY 212/587-1224
1352 RIVERS SIMON NEW YORK NY 718/383-3345
1555 RODRIGUEZ JULIA BRIDGEPORT CT 203/675-2401
1038 RODRIGUEZ MARIA BRIDGEPORT CT 203/675-2048
1420 ROUSE JEREMY PATERSON NJ 201/732-9834
1561 SANDERS RAYMOND NEW YORK NY 212/588-6615
1434 SANDERSON EDITH STAMFORD CT 203/781-1333
1414 SANDERSON NATHAN BRIDGEPORT CT 203/675-1715
1112 SAYERS RANDY NEW YORK NY 718/384-4895
1390 SMART JONATHAN NEW YORK NY 718/383-1141
1332 STEPHENSON ADAM BRIDGEPORT CT 203/675-1497
1890 STEPHENSON ROBERT NEW YORK NY 718/384-9874
1429 THOMPSON ALICE STAMFORD CT 203/781-3857
1107 THOMPSON WAYNE NEW YORK NY 718/384-3785
1908 TRENTON MELISSA NEW YORK NY 212/586-6262
1830 TRIPP KATHY BRIDGEPORT CT 203/675-2479
1882 TUCKER ALAN NEW YORK NY 718/384-0216
1050 TUTTLE THOMAS WHITE PLAINS NY 914/455-2119
1425 UNDERWOOD JENNY STAMFORD CT 203/781-0978
1928 UPCHURCH LARRY WHITE PLAINS NY 914/455-5009
1480 UPDIKE THERESA NEW YORK NY 212/587-8729
1100 VANDEUSEN RCHARD NEW YORK NY 212/586-2531
1995 VARNER ELIZABETH NEW YORK NY 718/384-7113
1135 VEGA ANNA NEW YORK NY 718/384-5913
1415 VEGA FRANKLIN NEW YORK NY 718/384-2823
1076 VENTER RANDALL NEW YORK NY 718/383-2321
1426 VICK THERESA PRINCETON NJ 201/812-2424
1564 WALTERS ANNE NEW YORK NY 212/587-3257
1221 WALTERS DIANE NEW YORK NY 718/384-1918
1133 WANG CHIN NEW YORK NY 212/587-1956
1435 WARD ELAINE NEW YORK NY 718/383-4987
1418 WATSON BERNARD NEW YORK NY 718/383-1298
1017 WELCH DARIUS NEW YORK NY 212/586-5535
1443 WELLS AGNES STAMFORD CT 203/781-5546
1131 WELLS NADINE NEW YORK NY 718/383-1045
1427 WHALEY CAROLYN MT. VERNON NY 914/468-4528
1036 WONG LESLIE NEW YORK NY 212/587-2570
1130 WOOD DEBORAH NEW YORK NY 212/587-0013
1127 WOOD SANDRA NEW YORK NY 212/587-2881
1433 YANCEY ROBIN PRINCETON NJ 201/812-1874
1431 YOUNG DEBORAH STAMFORD CT 203/781-2987
1122 YOUNG JOANN NEW YORK NY 718/384-2021
1105 YOUNG LAWRENCE NEW YORK NY 718/384-0008


PAYROLL2 Table

The data in the PAYROLL2 table is shown in PAYROLL2 Table.

PAYROLL2 Table
IDNUM SEX JOBCODE SALARY BIRTH HIRED
1639 F TA3 42260 26JUN1957 28JAN1984
1065 M ME3 38090 26JAN1944 07JAN1987
1561 M TA3 36514 30NOV1963 07OCT1987
1221 F FA3 29896 22SEP1967 04OCT1991
1447 F FA1 22123 07AUG1972 29OCT1992
1998 M SCP 23100 10SEP1970 02NOV1992
1036 F TA3 42465 19MAY1965 23OCT1984
1106 M PT3 94039 06NOV1957 16AUG1984
1129 F ME3 36758 08DEC1961 17AUG1991
1350 F FA3 36098 31AUG1965 29JUL1990
1369 M TA3 36598 28DEC1961 13MAR1987
1076 M PT1 69742 14OCT1955 03OCT1991


SCHEDULE Table

The data in the SCHEDULE table is shown in SCHEDULE Table.

SCHEDULE Table
FLIGHT DATES DEST IDNUM
132 01MAR1998 YYZ 1739
132 01MAR1998 YYZ 1478
132 01MAR1998 YYZ 1130
132 01MAR1998 YYZ 1390
132 01MAR1998 YYZ 1983
132 01MAR1998 YYZ 1111
219 01MAR1998 LON 1407
219 01MAR1998 LON 1777
219 01MAR1998 LON 1103
219 01MAR1998 LON 1125
219 01MAR1998 LON 1350
219 01MAR1998 LON 1332
271 01MAR1998 PAR 1439
271 01MAR1998 PAR 1442
271 01MAR1998 PAR 1132
271 01MAR1998 PAR 1411
271 01MAR1998 PAR 1988
271 01MAR1998 PAR 1443
622 01MAR1998 FRA 1545
622 01MAR1998 FRA 1890
622 01MAR1998 FRA 1116
622 01MAR1998 FRA 1221
622 01MAR1998 FRA 1433
622 01MAR1998 FRA 1352
132 02MAR1998 YYZ 1556
132 02MAR1998 YYZ 1478
132 02MAR1998 YYZ 1113
132 02MAR1998 YYZ 1411
132 02MAR1998 YYZ 1574
132 02MAR1998 YYZ 1111
219 02MAR1998 LON 1407
219 02MAR1998 LON 1118
219 02MAR1998 LON 1132
219 02MAR1998 LON 1135
219 02MAR1998 LON 1441
219 02MAR1998 LON 1332
271 02MAR1998 PAR 1739
271 02MAR1998 PAR 1442
271 02MAR1998 PAR 1103
271 02MAR1998 PAR 1413
271 02MAR1998 PAR 1115
271 02MAR1998 PAR 1443
622 02MAR1998 FRA 1439
622 02MAR1998 FRA 1890
622 02MAR1998 FRA 1124
622 02MAR1998 FRA 1368
622 02MAR1998 FRA 1477
622 02MAR1998 FRA 1352
132 03MAR1998 YYZ 1739
132 03MAR1998 YYZ 1928
132 03MAR1998 YYZ 1425
132 03MAR1998 YYZ 1135
132 03MAR1998 YYZ 1437
132 03MAR1998 YYZ 1111
219 03MAR1998 LON 1428
219 03MAR1998 LON 1442
219 03MAR1998 LON 1130
219 03MAR1998 LON 1411
219 03MAR1998 LON 1115
219 03MAR1998 LON 1332
271 03MAR1998 PAR 1905
271 03MAR1998 PAR 1118
271 03MAR1998 PAR 1970
271 03MAR1998 PAR 1125
271 03MAR1998 PAR 1983
271 03MAR1998 PAR 1443
622 03MAR1998 FRA 1545
622 03MAR1998 FRA 1830
622 03MAR1998 FRA 1414
622 03MAR1998 FRA 1368
622 03MAR1998 FRA 1431
622 03MAR1998 FRA 1352
132 04MAR1998 YYZ 1428
132 04MAR1998 YYZ 1118
132 04MAR1998 YYZ 1103
132 04MAR1998 YYZ 1390
132 04MAR1998 YYZ 1350
132 04MAR1998 YYZ 1111
219 04MAR1998 LON 1739
219 04MAR1998 LON 1478
219 04MAR1998 LON 1130
219 04MAR1998 LON 1125
219 04MAR1998 LON 1983
219 04MAR1998 LON 1332
271 04MAR1998 PAR 1407
271 04MAR1998 PAR 1410
271 04MAR1998 PAR 1094
271 04MAR1998 PAR 1411
271 04MAR1998 PAR 1115
271 04MAR1998 PAR 1443
622 04MAR1998 FRA 1545
622 04MAR1998 FRA 1890
622 04MAR1998 FRA 1116
622 04MAR1998 FRA 1221
622 04MAR1998 FRA 1433
622 04MAR1998 FRA 1352
132 05MAR1998 YYZ 1556
132 05MAR1998 YYZ 1890
132 05MAR1998 YYZ 1113
132 05MAR1998 YYZ 1475
132 05MAR1998 YYZ 1431
132 05MAR1998 YYZ 1111
219 05MAR1998 LON 1428
219 05MAR1998 LON 1442
219 05MAR1998 LON 1422
219 05MAR1998 LON 1413
219 05MAR1998 LON 1574
219 05MAR1998 LON 1332
271 05MAR1998 PAR 1739
271 05MAR1998 PAR 1928
271 05MAR1998 PAR 1103
271 05MAR1998 PAR 1477
271 05MAR1998 PAR 1433
271 05MAR1998 PAR 1443
622 05MAR1998 FRA 1545
622 05MAR1998 FRA 1830
622 05MAR1998 FRA 1970
622 05MAR1998 FRA 1441
622 05MAR1998 FRA 1350
622 05MAR1998 FRA 1352
132 06MAR1998 YYZ 1333
132 06MAR1998 YYZ 1890
132 06MAR1998 YYZ 1414
132 06MAR1998 YYZ 1475
132 06MAR1998 YYZ 1437
132 06MAR1998 YYZ 1111
219 06MAR1998 LON 1106
219 06MAR1998 LON 1118
219 06MAR1998 LON 1425
219 06MAR1998 LON 1434
219 06MAR1998 LON 1555
219 06MAR1998 LON 1332
132 07MAR1998 YYZ 1407
132 07MAR1998 YYZ 1118
132 07MAR1998 YYZ 1094
132 07MAR1998 YYZ 1555
132 07MAR1998 YYZ 1350
132 07MAR1998 YYZ 1111
219 07MAR1998 LON 1905
219 07MAR1998 LON 1478
219 07MAR1998 LON 1124
219 07MAR1998 LON 1434
219 07MAR1998 LON 1983
219 07MAR1998 LON 1332
271 07MAR1998 PAR 1410
271 07MAR1998 PAR 1777
271 07MAR1998 PAR 1103
271 07MAR1998 PAR 1574
271 07MAR1998 PAR 1115
271 07MAR1998 PAR 1443
622 07MAR1998 FRA 1107
622 07MAR1998 FRA 1890
622 07MAR1998 FRA 1425
622 07MAR1998 FRA 1475
622 07MAR1998 FRA 1433
622 07MAR1998 FRA 1352


SUPERV Table

The data in the SUPERV table is shown in SUPERV Table.

SUPERV Table
SUPERVISOR ID STATE JOB CATEGORY
1677 CT BC
1834 NY BC
1431 CT FA
1433 NJ FA
1983 NY FA
1385 CT ME
1420 NJ ME
1882 NY ME
1935 CT NA
1417 NJ NA
1352 NY NA
1106 CT PT
1442 NJ PT
1118 NY PT
1405 NJ SC
1564 NY SC
1639 CT TA
1401 NJ TA
1126 NY TA


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.