Table Contents

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

The Workforce database has the four following tables:

  • Employee table
  • Department table
  • Project table
  • Charges table
Contents of the Employee Table 
EmpNo Name DeptNo JobTitle Salary Yrs
Exp DOB Sex Race Mstat EdLev HCap
10001 Peterson J 100 Payroll Ck 25,000.00 5 Mar 27, 1942 M C M 12 0
10002 Moffit H 100 Recruiter 35,000.00 3 Nov 16, 1945 F B W 18 0
10003 Leidner P 300 Secretary 23,000.00 13 Jul 12, 1948 F C M 16 0
10004 Smith T 500 Engineer 42,000.00 10 Oct 31, 1951 M C M 18 0
10006 Kemper R 600 Assembler 29,000.00 7 Sep 12, 1947 M C M 12 0
10007 Aguilar J 600 Manager 45,000.00 11 Jul 09, 1949 M S M 16 0
10008 Phan A 300 Vice Pres 55,000.00 12 Jun 07, 1947 F A M 18 0
10009 Marston A 500 Secretary 22,000.00 12 Jun 07, 1947 F A M 18 0
10010 Reed C 500 Technician 30,000.00 4 Apr 08, 1949 M C D 16 0
10011 Chin M 100 Controller 38,000.00 11 Nov 29 1955 F A M 16 0
10012 Watson L 500 Vice Pres 56,000.00 8 Oct 03, 1943 M C S 20 0
10013 Regan R 600 Purchaser 44,000.00 10 Oct 20, 1948 F C M 16 0
10014 Inglis C 500 Tech Writer 34,000.00 5 Mar 07, 1938 M C S 16 0
10015 Omura H 500 Programmer 40,000.00 8 Apr 24, 1954 M A S 16 0
10016 Carter J 500 Engineer 44,000.00 20 Mar 12, 1935 M C M 20 0
10017 Greene W 100 Payroll Ck 32,500.00 15 Nov 27, 1955 M N M 16 0
10018 Russell S 300 President 65,000.00 25 Jun 05, 1932 M B D 16 0
10019 Newman P 600 Test Tech 28,600.00 6 Aug 29 1956 F C M 12 0
10020 Brangle B 700 Salesperson 30,000.00 5 Oct 15, 1947 F C S 16 0
10021 Smith T 700 Manager 45,000.00 10 Jul 29, 1946 F B S 16 0
10022 Clements D 700 Salesperson 38,000.00 9 Aug 23, 1944 M C M 16 0
Contents of the Department Table 
DeptNo DeptName Loc MgrNo
100 Administration NYC 10011
300 Exec Office NYC 10018
500 Engineering ATL 10012
600 Manufacturing CHI 10007
700 Marketing NYC 10021
Contents of the Project Table 
Project Id Project Description Received Date Due Date Compl Date
AP1-0001 A/P Payable DB Design 82/08/09 83/04/10 83/04/10
AP1-0002 A/P Payable Online System 82/08/09 83/04/10 83/04/21
AP1-0003 A/P Payable Batch System 82/08/09 83/04/10 83/04/21
AP2-0001 A/P Payable DB Design 82/08/09 83/04/10 83/04/10
AP2-0002 A/P Payable Online System 82/08/09 83/04/10 83/04/10
AP2-0003 A/P Payable Batch System 82/08/09 83/04/10 83/04/10
AR1-0001 A/R RECV Data Base Design 82/08/09 83/04/10 83/04/21
AR1-0002 A/R RECV Online System 82/08/09 83/04/10 83/04/10
AR1-0003 A/R RECV Batch System 82/08/09 83/04/10 83/04/20
AR2-0001 A/R RECV Data Base Design 82/08/09 83/04/10 83/04/10
AR2-0002 A/R RECV Online System 82/08/09 83/04/10 83/04/10
AR2-0003 A/R RECV Batch System 82/08/09 83/04/10 83/04/10
ENG-0001 Design Widget Boards 78/01/02 78/12/31 78/12/06
ENG-0002 Design Widget Pwr Supply 78/01/02 79/07/19 78/08/08
ENG-0003 Design Widget Frame 78/01/02 80/10/27 81/05/05
ENG-0004 Assemble and Test Widget 81/04/10 81/10/27 81/10/26
OE1-0001 O/E Data Base Design 82/11/21 83/10/27 83/10/27
OE1-0002 O/E Online System 82/11/21 83/10/27 83/10/27
OE1-0003 O/E Batch System 82/11/21 83/10/27 83/10/27
OE2-0001 O/E Data Base Design 82/11/21 83/10/27 83/10/27
OE2-0002 O/E Online System 82/11/21 83/10/27 83/11/10
OE2-0003 O/E Batch System 82/11/21 83/10/27 83/11/15
PAY-0002 Payroll File Maintenance 83/01/01 83/12/31 84/01/31
PAY-0001 Payroll System Data Entry 83/01/01 83/12/31 84/01/10
Contents of the Charges Table 
Employee Id Project Id Week Ending Hours
10001 PAY-0002 83/10/21 34.5
10001 PAY-0001 83/11/18  4.5
10001 PAY-0001 83/09/30  5.0
10002 OE1-0001 83/03/11 12.0
10002 OE1-0001 83/04/15 33.5
10003 OE1-0001 83/03/18 23.0
10003 OE1-0001 83/02/25 10.5
10004 ENG-0003 83/11/18 40.0
10004 ENG-0002 83/07/29 53.0
10010 AP1-0002 83/02/18 10.0
10010 EO1-0001 83/10/07 10.0
10010 AR1-0001 83/02/18 12.5
10014 OE1-0001 83/01/28 30.0
10014 OE1-0001 83/01/21 30.5
10014 OE1-0002 83/01/14 20.0
10015 AP1-0001 83/02/18 30.5
10015 AR1-0002 83/02/25 24.0
10016 ENG-0003 83/02/25  2.5
10016 ENG-0002 83/01/14 32.0
10016 ENG-0002 83/05/20 32.0
10017 PAY-0001 83/08/26 33.0
10017 PAY-0001 83/04/15 37.0
10019 AR1-0003 83/02/04 28.0
10019 AP1-0003 83/02/11 20.5