EMPLOYEE Table |Teradata Preprocessor2 for Embedded SQL (PP2) - EMPLOYEE Table - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide - 20.00
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Preprocessor2
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-11-20
dita:mapPath
nyr1691484085721.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
xfi1470440464166
Product Category
Teradata Tools and Utilities

Data for the new EMPLOYEE table is shown in the following table. This information is in the LABSDATA file.

EMPLOYEE NUMBER MANAGER EMPLOYEE NUMBER DEPARTMENT NUMBER JOB CODE LAST NAME FIRST NAME HIRE DATE BIRTH DATE SALARY AMOUNT
1001 1003 401 412101 Hoover William 76/06/18 50/01/14 25525.00
1002 1003 401 413201 Brown Alan 76/07/31 44/08/09 43100.00
1003 801 401 411100 Trader James 76/07/31 47/06/19 37850.00
1004 1003 401 412101 Johnson Darlene 76/10/15 46/04/23 36300.00
1005 801 403 431100 Ryan Loretta 76/10/15 55/09/10 31200.00
1006 1019 301 312101 Stein John 76/10/15 53/10/15 29450.00
1007 1005 403 432101 Villegas Arnando 77/01/02 37/01/31 49700.00
1008 1019 301 312102 Kanieski Carol 77/02/01 58/05/17 29250.00
1009 1005 403 432101 Lombardo Domingus 77/02/01 45/11/15 31000.00
1010 1003 401 412101 Rogers Frank 77/03/01 35/04/23 46000.00
1011 801 402 421100 Daly James 77/03/15 49/12/11 52500.00
1012 1005 403 432101 Hopkins Paulene 77/03/15 42/02/18 37900.00
1013 1003 401 412102 Phillips Charles 77/04/01 63/08/10 24500.00
1014 1011 402 422101 Crane Robert 78/01/15 60/07/04 24500.00
1015 1017 501 512101 Wilson Edward 78/03/01 57/03/04 53625.00
1016 801 302 321100 Rogers Nora 78/03/01 59/09/04 56500.00
1017 801 501 511100 Runyon Irene 78/05/01 51/11/10 66000.00
1018 1017 501 512101 Ratzlaff Larry 78/07/15 54/05/31 54000.00
1019 801 301 311100 Kubic Ron 78/08/01 42/12/11 57700.00
1020 1005 403 432101 Charles John 78/10/01 49/06/21 39500.00
1021 1025 201 222101 Morrissey Jim 78/10/01 43/04/29 38750.00
1022 1003 401 412102 Machado Albert 79/03/01 57/07/14 32300.00
1023 1017 501 512101 Greene Peter 79/03/01 62/10/29 26500.00
1024 1005 403 432101 Brown Allen 79/05/01 54/01/16 43700.00
1025 801 201 211100 Short Michael 79/05/01 47/07/07 34700.00