$PBExportHeader$d_employees.srd release 10; datawindow(units=0 timer_interval=0 color=1073741824 processing=0 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no ) header(height=152 color="536870912" ) summary(height=0 color="536870912" ) footer(height=0 color="536870912" ) detail(height=72 color="536870912" ) table(column=(type=long update=yes updatewhereclause=yes key=yes name=emp_id dbname="employee.emp_id" ) column=(type=long update=yes updatewhereclause=yes name=manager_id dbname="employee.manager_id" ) column=(type=char(20) update=yes updatewhereclause=yes name=emp_fname dbname="employee.emp_fname" ) column=(type=char(20) update=yes updatewhereclause=yes name=emp_lname dbname="employee.emp_lname" ) column=(type=long update=yes updatewhereclause=yes name=dept_id dbname="employee.dept_id" ) column=(type=char(40) update=yes updatewhereclause=yes name=street dbname="employee.street" ) column=(type=char(20) update=yes updatewhereclause=yes name=city dbname="employee.city" ) column=(type=char(4) update=yes updatewhereclause=yes name=state dbname="employee.state" ) column=(type=char(9) update=yes updatewhereclause=yes name=zip_code dbname="employee.zip_code" ) column=(type=char(10) update=yes updatewhereclause=yes name=phone dbname="employee.phone" ) column=(type=char(1) update=yes updatewhereclause=yes name=status dbname="employee.status" initial="A" values="Active A/Terminated T/On Leave L/" validation="match( gettext() , ~"^[ALT]$~")" ) column=(type=char(11) update=yes updatewhereclause=yes name=ss_number dbname="employee.ss_number" ) column=(type=decimal(3) update=yes updatewhereclause=yes name=salary dbname="employee.salary" validation=" real(gettext()) > 0" validationmsg="'Sorry! The value must be greater than zero.'" ) column=(type=date update=yes updatewhereclause=yes name=start_date dbname="employee.start_date" ) column=(type=date update=yes updatewhereclause=yes name=termination_date dbname="employee.termination_date" ) column=(type=date update=yes updatewhereclause=yes name=birth_date dbname="employee.birth_date" ) column=(type=char(1) update=yes updatewhereclause=yes name=bene_health_ins dbname="employee.bene_health_ins" values="Health Insurance Y/Health Insurance N" validation="match( gettext() , ~"^[YNyn]$~")" ) column=(type=char(1) update=yes updatewhereclause=yes name=bene_life_ins dbname="employee.bene_life_ins" values="Life Insurance Y/Life Insurance N" validation="match( gettext() , ~"^[YNyn]$~")" ) column=(type=char(1) update=yes updatewhereclause=yes name=bene_day_care dbname="employee.bene_day_care" values="Day Care Y/Day Care N" validation="match( gettext() , ~"^[YNyn]$~")" ) column=(type=char(1) update=yes updatewhereclause=yes name=sex dbname="employee.sex" values="Male M/Female F/" ) retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"employee~" ) COLUMN(NAME=~"employee.emp_id~") COLUMN(NAME=~"employee.manager_id~") COLUMN(NAME=~"employee.emp_fname~") COLUMN(NAME=~"employee.emp_lname~") COLUMN(NAME=~"employee.dept_id~") COLUMN(NAME=~"employee.street~") COLUMN(NAME=~"employee.city~") COLUMN(NAME=~"employee.state~") COLUMN(NAME=~"employee.zip_code~") COLUMN(NAME=~"employee.phone~") COLUMN(NAME=~"employee.status~") COLUMN(NAME=~"employee.ss_number~") COLUMN(NAME=~"employee.salary~") COLUMN(NAME=~"employee.start_date~") COLUMN(NAME=~"employee.termination_date~") COLUMN(NAME=~"employee.birth_date~") COLUMN(NAME=~"employee.bene_health_ins~") COLUMN(NAME=~"employee.bene_life_ins~") COLUMN(NAME=~"employee.bene_day_care~") COLUMN(NAME=~"employee.sex~")) " update="employee" updatewhere=1 updatekeyinplace=no sort="emp_lname A " ) data( 102, 501,"Fran","Whitney", 100,"49 East Washington Street","Needham","MA","02192 ","6175553985","A","017349033", 45700.000,1990-02-26,null 1962-06-05,"Y","Y","N","F", 105, 501,"Matthew","Cobb", 100,"77 Pleasant Street","Waltham","MA","02154 ","6175553840","A","052345739", 62000.000,1990-07-02,null 1964-12-04,"Y","Y","N","M", 129, 902,"Philip","Chin", 200,"59 Pond Street","Atlanta","GA","30339 ","4045552341","A","024608923", 38500.000,2001-08-04,null 1970-10-30,"Y","Y","N","M", 148, 1293,"Julie","Jordan", 300,"144 Great Plain Avenue","Winchester","MA","01890 ","6175557835","A","501704733", 51432.000,2000-10-04,null 1955-12-13,"Y","Y","N","F", 160, 501,"Robert","Breault", 100,"58 Cherry Street","Milton","MA","02186 ","6175553099","A","025487623", 57490.000,1990-12-16,null 1951-05-13,"Y","Y","Y","M", 184, 1576,"Melissa","Espinoza", 400,"112 Apple Tree Way","Stow","MA","01775 ","5085552319","A","025481943", 36490.000,1991-04-18,null 1943-12-14,"Y","Y","N","F", 191, 703,"Jeannette","Bertrand", 500,"209 Concord Street","Acton","MA","01720 ","5085558138","A","017348821", 32780.000,1993-05-20,null 1968-12-21,"Y","Y","Y","F", 195, 902,"Marc","Dill", 200,"89 Hancock Street","Milton","MA","02186 ","6175552144","A","079486634", 54800.000,1991-06-06,null 1967-07-19,"Y","Y","N","M", 207, 1576,"Jane","Francis", 400,"12 Hawthorne Drive","Concord","MA","01742 ","5085559022","A","501708992", 53870.000,1998-08-04,null 1975-09-12,"Y","Y","N","F", 243, 501,"Natasha","Shishov", 100,"15 Milk Street ","Waltham","MA","02154 ","6175552755","A","043216799", 72995.000,1991-12-06,null 1953-04-22,"Y","Y","N","F", 247, 501,"Kurt","Driscoll", 100,"154 School Street","Waltham","MA","02154","6175551234","L","024601768", 48023.690,1999-12-30,null 1959-03-05,"Y","Y","Y","M", 249, 501,"Rodrigo","Guevara", 100,"East Main Street","Framingham","MA","01701 ","5085550029","A","084329990", 42998.000,2002-01-01,null 1960-11-23,"Y","Y","N","M", 266, 501,"Ram","Gowda", 100,"79 Page Street","Natick","MA","01760 ","5085558722","A","017346122", 59840.000,1994-05-30,null 1951-10-18,"N","Y","N","M", 278, 501,"Terry","Melkisetian", 100,"87 Oxford Road","Watertown","MA","02172 ","6175555188","A","087602311", 48500.000,1992-06-05,null 1970-05-17,"Y","Y","Y","F", 299, 902,"Rollin","Overbey", 200,"1915 Companion Ct.","Emeryville","CA","94608 ","5105557255","A","025487133", 39300.000,1992-08-19,null 1968-03-15,"Y","Y","N","M", 316, 501,"Lynn","Pastor", 100,"14 Cricklewood Drive","Burlington","MA","01803 ","6175552001","A","048667211", 74500.000,1992-10-24,null 1966-07-14,"Y","Y","Y","F", 318, 1576,"John","Crow", 400,"531 Main Street","Watertown","MA","02172","6175553332","A","079349168", 41700.750,1992-11-20,null 1966-04-24,"Y","Y","N","M", 390, 1293,"Jo Ann","Davidson", 300,"27 Mount Vernon Road","Needham","MA","02192 ","6175553870","A","027341657", 57090.000,1992-11-30,null 1961-02-17,"N","Y","Y","F", 409, 1576,"Bruce","Weaver", 400,"19 Westmoreland Street","Lexington","MA","02173 ","6175554444","A","048781192", 46550.000,1992-12-08,null 1950-04-05,"Y","Y","N","M", 445, 501,"Kim","Lull", 100,"199 Lincoln Street","Concord","MA","01742 ","5085554444","A","017508821", 87900.000,1992-12-13,null 1979-01-19,"Y","Y","N","M", 453, 501,"Andrew","Rabkin", 100,"44 Birds Hill Way","Burlington","MA","01803 ","6175554444","A","029458129", 64500.000,1992-12-13,null 1961-08-10,"Y","Y","N","M", 467, 902,"James","Klobucher", 200,"18 Corning Street","Houston","TX","77079 ","7135558627","A","034281032", 49500.000,1993-01-07,null 1956-11-09,"Y","Y","N","M", 479, 501,"Linda","Siperstein", 100,"341 Hillside Avenue","Newton","MA","02164 ","6175556588","L","022415639", 39875.500,1993-01-20,null 1971-09-21,"Y","Y","N","F", 501, 501,"David","Scott", 100,"21 Riverdale Drive","Belmont","MA","02178 ","6175553246","A","064983327", 96300.000,1993-02-01,null 1951-03-01,"Y","Y","Y","M", 529, 501,"Dorothy","Sullivan", 100,"124 Minuteman Drive","Lexington","MA","02173 ","6175553947","A","501324492", 67890.000,1993-08-03,null 1954-04-19,"Y","Y","N","F", 582, 501,"Peter","Samuels", 100,"54 Woodlawn Street","Newton","MA","02164 ","6175558342","A","038218867", 37400.000,1993-09-21,null 1972-02-28,"Y","Y","N","M", 586, 1293,"James","Coleman", 300,"57 Heather Hill Drive","Acton","MA","01720 ","5085554735","L","031281245", 42300.000,1993-10-04,null 1970-03-04,"Y","Y","N","M", 591, 1576,"Irene","Barletta", 400,"37 Gleason Street","Bedford","MA","01730 ","6175558345","A","056872399", 45450.000,1994-01-16,null 1961-01-30,"Y","Y","Y","F", 604, 501,"Albert","Wang", 100,"48 Edwin Street","Waltham","MA","02154 ","6175558741","A","023486621", 68400.000,1994-03-30,null 1962-12-25,"Y","Y","N","M", 641, 902,"Thomas","Powell", 200,"48 Kennedy Court","Newton","MA","02162 ","6175551956","A","038726633", 54600.000,1994-04-14,null 1955-10-31,"Y","Y","N","M", 667, 902,"Mary","Garcia", 200,"98 Purvis Street","Houston","TX","77079 ","7135553431","A","042706188", 39800.000,1994-05-23,null 1967-01-23,"N","Y","Y","F", 690, 902,"Kathleen","Poitras", 200,"50 The Fenway","Boston","MA","02118 ","6175553920","A","087236702", 46200.000,1994-05-29,null 1969-09-29,"N","Y","N","F", 703, 902,"Jose","Martinez", 500,"123 Washington Street","Westwood","MA","02090 ","6175557114","A","012896755", 61050.880,1995-06-01,null 1957-07-22,"Y","Y","N","M", 750, 703,"Jane","Braun", 500,"45 Wood Street","Cambridge","MA","02140 ","6175557857","A","012459381", 37730.000,1995-07-04,null 1943-08-09,"Y","Y","N","F", 757, 1293,"Denis","Higgins", 300,"1033 Massachusetts Avenue","Lexington","MA","02173 ","6175553985","A","067829311", 43700.000,1995-08-24,null 1972-05-12,"Y","Y","N","F", 839, 501,"Dean","Marshall", 100,"44 Mount Pleasant Street","Belmont","MA","02178 ","6175553707","A","034629123", 42500.000,1995-10-19,null 1970-05-21,"Y","Y","N","M", 856, 902,"Samuel","Singer", 200,"187 Orchard Road","Stow","MA","01775 ","5085553255","A","011349786", 34892.000,1995-11-30,null 1963-04-07,"Y","Y","N","M", 862, 501,"John","Sheffield", 100,"45 Belleview Drive","Houston","TX","77079 ","7135553877","A","018458291", 87900.000,1995-12-14,null 1959-09-25,"Y","Y","Y","M", 868, 703,"Felicia","Kuo", 500,"79 Oak Street","Cambridge","MA","02140 ","6175552385","A","043592831", 28200.000,1996-01-10,null 1972-07-24,"Y","Y","N","F", 879, 1293,"Kristen","Coe", 300,"30 Rainbow Road","West Roxbury","MA","02132 ","6175559192","A","027581035", 36500.000,1996-01-16,null 1969-11-11,"Y","Y","N","F", 888, 1576,"Doug","Charlton", 400,"57 Webster Street","Concord","MA","01742 ","5085559246","A","036102935", 28300.000,1996-03-10,null 1970-01-23,"N","Y","N","M", 902, 1293,"Judy","Snow", 200,"12 Fountain Road","Marblehead","MA","01945","5085553769","A","015923467", 87500.000,1996-04-01,null 1954-08-16,"Y","Y","N","F", 913, 902,"Ken","Martel", 200,"23 Lincoln Street","Needham","MA","02192 ","6175558474","A","022783569", 55700.000,1996-04-16,null 1947-04-23,"N","Y","N","M", 921, 703,"Charles","Crowley", 500,"421 Beacon Street","Belmont","MA","02178 ","6175559425","A","034568789", 41700.000,1996-04-22,null 1964-09-11,"Y","Y","N","M", 930, 902,"Ann","Taylor", 200,"25 Westminster Street","Atlanta","GA","30339 ","4045551515","A","062890293", 46890.000,1996-05-08,null 1966-06-06,"Y","Y","Y","F", 1013, 703,"Joseph","Barker", 500,"58 West Drive","Bedford","MA","01730 ","6175558021","A","023470756", 27290.000,1996-09-10,null 1973-02-14,"N","Y","N","M", 949, 902,"Pamela","Savarino", 200,"112 Beach Street","Long Beach","CA","90806 ","3105551857","A","018762936", 72300.000,1996-05-08,null 1974-07-28,"Y","Y","N","F", 958, 501,"Thomas","Sisson", 100,"54 School Street","Houston","TX","77079 ","7135558390","A","017283997", 42100.000,1996-07-16,null 1973-10-02,"Y","Y","N","M", 992, 1576,"Joyce","Butterfield", 400,"119 Adams Street","Cambridge","MA","02140 ","6175552232","A","023487085", 34011.000,1996-08-13,null 1964-04-15,"Y","Y","N","F", 1021, 902,"Paul","Sterling", 200,"112 Endicott Street","Concord","MA","01742 ","5085550295","A","037846595", 64900.000,1996-10-28,null 1954-02-27,"Y","Y","Y","M", 1039, 902,"Shih Lin","Chao", 200,"59 Holyoke Street","Lexington","MA","02173 ","6175555921","A","046973741", 33890.000,1996-11-11,null 1973-12-12,"N","Y","Y","M", 1062, 1576,"Barbara","Blaikie", 400,"66 Beaumont Terrace","Needham","MA","02192 ","6175559345","A","019887257", 54900.000,1996-11-20,null 1957-11-14,"Y","Y","Y","F", 1090, 501,"Susan","Smith", 100,"177 Johnson Street","Houston","TX","77079 ","7135556613","A","013558813", 51411.000,1996-12-13,null 1954-11-30,"N","Y","Y","F", 1101, 902,"Mark","Preston", 200,"49 Constitution Road","Boston","MA","02124 ","6175555862","A","027663454", 37803.000,1997-01-09,null 1970-09-14,"Y","Y","N","M", 1142, 902,"Alison","Clark", 200,"56 Carver Street","Emeryville","CA","94608 ","5105559437","A","055913622", 45000.000,1997-01-19,null 1961-05-04,"N","Y","Y","F", 1157, 501,"Hing","Soo", 100,"19 Glenmeadow Street","Needham","MA","02192 ","6175558748","A","023434587", 39075.000,1997-01-29,null 1974-03-07,"Y","Y","N","M", 1162, 902,"Kevin","Goggin", 200,"12 Wachusett Road","Wellesley","MA","02181 ","6175553785","A","075679377", 37900.000,1997-02-03,null 1956-04-18,"Y","Y","N","M", 1191, 1576,"Matthew","Bucceri", 400,"57 Taylor Place","Lexington","MA","02173 ","6175555336","A","023749270", 45900.000,1997-02-12,null 1948-11-19,"Y","Y","N","M", 1250, 501,"Emilio","Diaz", 100,"112 Evergreen Street","Wellesley","MA","02181 ","6175553567","A","023476492", 54900.000,1997-02-17,null 1940-01-02,"Y","Y","N","M", 1293, 1293,"Mary Anne","Shea", 300,"197 Camden Road","Lexington","MA","02173","6175554616","A","019641485", 138948.000,1997-03-01,null 1959-03-13,"Y","Y","N","F", 1336, 1293,"Janet","Bigelow", 300,"84 Lunda Street","Waltham","MA","02154","6175551493","A","017326112", 31200.000,1998-08-25,null 1954-07-21,"Y","Y","Y","F", 1390, 1293,"Jennifer","Litton", 300,"17 Downing Street","Concord","MA","01742 ","5085553495","A","034786565", 58930.000,1998-10-05,null 1952-04-05,"N","Y","N","F", 1446, 902,"Caroline","Yeung", 200,"52 Cypress Street","Atlanta","GA","30339 ","4045558347","A","038475825", 32300.000,1999-04-29,null 1975-06-21,"N","Y","N","F", 1483, 1293,"John","Letiecq", 300,"149 Vista Drive","Burlington","MA","01803 ","6175551167","L","079372285", 75400.000,1999-08-30,null 1943-04-27,"Y","Y","N","M", 1507, 1576,"Ruth","Wetherby", 400,"82 Aberdeen Road","Needham","MA","02192 ","6175555465","A","035673688", 35745.000,1999-10-11,null 1963-07-19,"Y","Y","N","F", 1570, 703,"Anthony","Rebeiro", 500,"39 Moody Street","Waltham","MA","02154 ","6175555737","A","034576347", 34576.000,1999-11-27,null 1967-04-12,"Y","Y","N","M", 1576, 902,"Scott","Evans", 400,"10-A Sunrise Circle","Concord","MA","01742 ","5085550096","A","017429926", 68940.000,1999-12-30,null 1964-11-15,"Y","Y","N","M", 1596, 902,"Catherine","Pickett", 200,"45 Appleton Road","Bedford","MA","01730 ","6175553478","T","028375086", 47653.000,2000-02-10,2002-01-10,1963-11-18,"Y","Y","Y","F", 1607, 1576,"Mark ","Morris", 400,"1 Example Way ","Waltham","MA","02154 ","6175558344","A","501787474", 61300.000,2000-04-13,null 1945-01-08,"Y","Y","N","M", 1615, 703,"Sheila","Romero", 500,"1 Oakview Terrace","Bedford","MA","01730 ","6175558138","A","501175874", 27500.000,2000-05-20,null 1976-09-12,"Y","Y","Y","F", 1643, 1576,"Elizabeth","Lambert", 400,"29 Union Street","Burlington","MA","01803 ","6175552357","A","023857807", 29384.000,2000-06-15,null 1972-09-12,"Y","Y","N","F", 1658, 703,"Michael","Lynch", 500,"76 Brookside Road","Waltham","MA","02154 ","6175558348","A","023850840", 24903.000,2000-08-28,null 1977-01-18,"Y","Y","N","M", 1684, 1576,"Janet","Hildebrand", 400,"47 Hilltop Street","Waltham ","MA","02154 ","6175553845","A","038957036", 45829.000,2000-09-13,null 1973-10-31,"Y","Y","N","F", 1740, 1576,"Robert","Nielsen", 400,"55 Sargent Avenue","Bedford","MA","01730 ","6175558757","A","037534650", 34889.000,2000-12-23,null 1969-06-19,"Y","Y","N","M", 1751, 1576,"Alex","Ahmed", 400,"114 Cushing Street","Needham","MA","02192 ","6175558748","A","032547384", 34992.000,2001-01-10,null 1967-12-12,"Y","Y","N","M",) text(band=header alignment="2" text="Salary" border="0" color="33554432" x="5298" y="4" height="52" width="343" html.valueishtml="0" name=salary_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="Start Date" border="0" color="33554432" x="5646" y="4" height="52" width="311" html.valueishtml="0" name=start_date_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="Termination Date" border="0" color="33554432" x="5874" y="4" height="52" width="535" html.valueishtml="0" name=termination_date_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="Birth Date" border="0" color="33554432" x="6322" y="4" height="52" width="306" html.valueishtml="0" name=birth_date_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="Health Insurance" border="0" color="33554432" x="6633" y="4" height="52" width="539" html.valueishtml="0" name=bene_health_ins_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="Life Insurance" border="0" color="33554432" x="7177" y="4" height="52" width="498" html.valueishtml="0" name=bene_life_ins_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="Day Care" border="0" color="33554432" x="7680" y="4" height="52" width="498" html.valueishtml="0" name=bene_day_care_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="Sex" border="0" color="33554432" x="8183" y="4" height="52" width="329" html.valueishtml="0" name=sex_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="SSN" border="0" color="33554432" x="4928" y="4" height="52" width="366" html.valueishtml="0" name=ss_number_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="Employee ID" border="0" color="33554432" x="0" y="4" height="52" width="393" html.valueishtml="0" name=emp_id_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="Manager ID" border="0" color="33554432" x="402" y="4" height="52" width="366" html.valueishtml="0" name=manager_id_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="First Name" border="0" color="33554432" x="718" y="4" height="52" width="553" html.valueishtml="0" name=emp_fname_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="Last Name" border="0" color="33554432" x="1134" y="4" height="52" width="526" html.valueishtml="0" name=emp_lname_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="Department ID" border="0" color="33554432" x="1609" y="4" height="52" width="453" html.valueishtml="0" name=dept_id_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="Street" border="0" color="33554432" x="2085" y="4" height="52" width="873" html.valueishtml="0" name=street_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="City" border="0" color="33554432" x="2962" y="4" height="52" width="526" html.valueishtml="0" name=city_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="State" border="0" color="33554432" x="3493" y="4" height="52" width="169" html.valueishtml="0" name=state_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="Zip Code" border="0" color="33554432" x="3666" y="4" height="52" width="347" html.valueishtml="0" name=zip_code_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="Phone" border="0" color="33554432" x="4018" y="4" height="52" width="398" html.valueishtml="0" name=phone_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header alignment="0" text="Status" border="0" color="33554432" x="4421" y="4" height="52" width="503" html.valueishtml="0" name=status_t visible="1" font.face="Tahoma" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=1 alignment="1" tabsequence=10 border="0" color="33554432" x="5" y="4" height="60" width="206" format="[general]" html.valueishtml="0" name=emp_id tag="Identification Number of the employee" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=2 alignment="1" tabsequence=20 border="0" color="33554432" x="457" y="4" height="60" width="206" format="[general]" html.valueishtml="0" name=manager_id tag="Identification number of the employee's manager" visible="1" dddw.name=dddw_1 dddw.displaycolumn=test dddw.datacolumn=test dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=5 alignment="1" tabsequence=50 border="0" color="33554432" x="1664" y="4" height="60" width="206" format="[general]" html.valueishtml="0" name=dept_id tag="Identification Number for the department where the employee works" visible="1" edit.name="Department List" dddw.name=dddw_1 dddw.displaycolumn=test dddw.datacolumn=test dddw.percentwidth=300 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.vscrollbar=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=8 alignment="0" tabsequence=80 border="0" color="33554432" x="3493" y="4" height="60" width="169" format="[general]" html.valueishtml="0" name=state tag="State where the employee resides" visible="1" edit.name="StateCode" dddw.name=d_dddw_states dddw.displaycolumn=state_id dddw.datacolumn=state_id dddw.percentwidth=550 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.vscrollbar=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=11 alignment="0" tabsequence=110 border="0" color="33554432" x="4421" y="4" height="56" width="503" format="[general]" html.valueishtml="0" name=status tag="Status of the employee (active, on leave, or terminated)" visible="1" edit.name="Employee Status" radiobuttons.columns=3 radiobuttons.scale=no radiobuttons.threed=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=12 alignment="0" tabsequence=120 border="0" color="33554432" x="4928" y="4" height="60" width="366" format="[general]" html.valueishtml="0" name=ss_number tag="Social Security Number of the employee" visible="1" edit.name="SocSecNumber" editmask.mask="###-##-####" editmask.focusrectangle=no font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=14 alignment="0" tabsequence=140 border="0" color="33554432" x="5646" y="4" height="60" width="306" format="[general]" html.valueishtml="0" name=start_date tag="Date the employee began working" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=15 alignment="0" tabsequence=150 border="0" color="33554432" x="5966" y="4" height="60" width="306" format="[general]" html.valueishtml="0" name=termination_date tag="Date the employee was terminated" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=16 alignment="0" tabsequence=160 border="0" color="33554432" x="6322" y="4" height="60" width="306" format="[general]" html.valueishtml="0" name=birth_date tag="Birth Date of the employee" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=17 alignment="0" tabsequence=170 border="0" color="33554432" x="6633" y="4" height="60" width="539" format="[general]" html.valueishtml="0" name=bene_health_ins tag="Determines if the employee has health insurance" visible="1" edit.name="Health Insurance" checkbox.text="Health Insurance" checkbox.on="Y" checkbox.off="N" checkbox.scale=no checkbox.threed=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=18 alignment="0" tabsequence=180 border="0" color="33554432" x="7177" y="4" height="60" width="498" format="[general]" html.valueishtml="0" name=bene_life_ins tag="Determines if the employee has life insurance" visible="1" edit.name="Life Insurance" checkbox.text="Life Insurance" checkbox.on="Y" checkbox.off="N" checkbox.scale=no checkbox.threed=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=19 alignment="0" tabsequence=190 border="0" color="33554432" x="7680" y="4" height="60" width="498" format="[general]" html.valueishtml="0" name=bene_day_care tag="Determines if the employee is entitled to day care insurance" visible="1" edit.name="Day Care" checkbox.text="Day Care" checkbox.on="Y" checkbox.off="N" checkbox.scale=no checkbox.threed=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=20 alignment="0" tabsequence=200 border="0" color="33554432" x="8183" y="4" height="60" width="585" format="[general]" html.valueishtml="0" name=sex tag="Male or Female" visible="1" edit.name="sex" radiobuttons.columns=2 radiobuttons.scale=no radiobuttons.threed=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=9 alignment="0" tabsequence=90 border="0" color="33554432" x="3666" y="4" height="60" width="347" format="[general]" html.valueishtml="0" name=zip_code tag="Zip Code where the employee resides" visible="1" edit.name="ZipCode" editmask.mask="#####-####" editmask.focusrectangle=no font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=10 alignment="0" tabsequence=100 border="0" color="33554432" x="4018" y="4" height="60" width="398" format="[general]" html.valueishtml="0" name=phone tag="Phone number of the employee" visible="1" edit.name="TelephoneNumber" editmask.mask="(###) ###-####" editmask.focusrectangle=no font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=13 alignment="1" tabsequence=130 border="0" color="33554432" x="5298" y="4" height="60" width="343" format="$###,##0.00" html.valueishtml="0" name=salary tag="Annual salary of the employee" visible="1" edit.name="Dollars with cents" editmask.mask="$###,###,###.00" editmask.focusrectangle=no font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=3 alignment="0" tabsequence=30 border="0" color="33554432" x="718" y="4" height="60" width="411" format="[general]" html.valueishtml="0" name=emp_fname tag="First name of the employee" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.required=yes edit.autohscroll=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=4 alignment="0" tabsequence=40 border="0" color="33554432" x="1134" y="4" height="60" width="526" format="[general]" html.valueishtml="0" name=emp_lname tag="Last name of the employee" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=6 alignment="0" tabsequence=60 border="0" color="33554432" x="2085" y="4" height="60" width="873" format="[general]" html.valueishtml="0" name=street tag="Street address of the employee" visible="1" edit.limit=40 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=7 alignment="0" tabsequence=70 border="0" color="33554432" x="2962" y="4" height="60" width="526" format="[general]" html.valueishtml="0" name=city tag="City where the employee resides" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) htmltable(border="1" ) htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" ) xhtmlgen() cssgen(sessionspecific="0" ) xmlgen(inline="0" ) xsltgen() jsgen() export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 ) import.xml() export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" ) export.xhtml()
- Sources
- Kodigo
- OpenExplorer
- d_employees.srd
File: d_employees.srd
Size: 33152
Date: Mon, 07 Apr 2008 21:33:06 +0200
Size: 33152
Date: Mon, 07 Apr 2008 21:33:06 +0200