APEX:Project Data示例项目演示数据(EBA_PROJECTS)
APEX:Project Data示例项目演示数据(EBA_PROJECTS)
EBA_PROJECT_COMMENTS
INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (1,1,'We have decided to use the Web Listener included with the database for Dev Only and a separate Web Listener for QA and Prod.',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (2,1,'Installed latest version of Web development tool.',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (3,1,'Installed latest version of Web Listener in QA and Prod environments',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (4,2,'The exercises had some errors that need correcting ASAP.',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (5,2,'Thanks for the feedback, Exercises corrected.',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (6,3,'Bernie - I have migrated all of the projects data across, so you can start your pilot now.',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (7,3,'I'm telling you now, this Customer Tracker thing had better be good',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (8,3,'This guy Mike told me this app is brilliant.',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (9,3,'So far Customer Tracker is working out great - better than the old apps. Brocky, my boy, you are the man!',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (10,3,'Bernie, I told you that you were going to be impressed.',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_COMMENTS(ID,PROJECT_ID,COMMENT_TEXT,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (11,3,'All of the old tables and transactional logic now migrated and ready for developers to use in the new database.',SYSDATE,'-1',SYSDATE,'-1');
EBA_PROJECT_TASK_TODOS-演示数据
INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (1,1,2,'Download tool from vendor','Download the latest available version of the Web development tool from the vendor site.','Mei Yu','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (2,1,3,'Download Web Listener from vendor','Download the latest available version of the Web Listener from the vendor site.','Harold Youngblood','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (3,2,8,'Review the online examples hosted by the vendor','Run through the numerous examples available from the vendor to get course content.','Madison Smith','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (4,3,13,'Reverse engineer the legacy tables into the data modeling tool','Connect the data modeling tool to the legacy dev instance and suck in all of the required DB objects.','Tameka Hall','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (5,3,13,'Add proper integrity constraints to the entities','Add foreign keys as needed to correctly integrate referential integrity.','Tameka Hall','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (6,3,13,'Generate DDL Scripts for new tables','Generate the DDL scripts from the data modeling tool to create the DB objects in the new database.','Tameka Hall','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (7,4,22,'Meet key Partners for input','Determine the most important functionality for Partners.','Bernard Jackman','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (8,4,22,'Meet internal Partner liason reps','Determine the most important functionality for internal stakeholders.','Bernard Jackman','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (9,4,22,'Develop inital screen designs','Prototype new screens using Web development tool to get buy-in from SMEs.','Bernard Jackman','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (10,6,46,'Contact executive assitants','Get meetings scheduled for the key stakeholders.','Lucille Beatie','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (11,6,46,'Prepare presentation for executives','Prepare and practice delivering concise, high level positioning on app feasability.','Lucille Beatie','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (12,6,46,'Develop inital report designs','Mock up new dashboard screens using Web development tool to get buy-in from executives.','Mei Yu','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (13,8,70,'Contact executive assitants','Get meetings scheduled for the key stakeholders.','Miyazaki Yokohama','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (14,8,70,'Prepare presentation for executives','Determine the current functionality to present to key stakeholders.','Miyazaki Yokohama','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (15,11,105,'Contact key stakeholders','Get meetings scheduled for the key stakeholders.','Miyazaki Yokohama','Y',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_TODOS(ID,PROJECT_ID,TASK_ID,NAME,DESCRIPTION,ASSIGNEE,IS_COMPLETE_YN,CREATED,CREATED_BY,UPDATED,UPDATED_BY) VALUES (16,11,105,'Prepare presentation for stakeholders','Determine the current functionality to present to key stakeholders.','Miyazaki Yokohama','Y',SYSDATE,'-1',SYSDATE,'-1');
EBA_PROJECT_MILESTONES-演示数据
"INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (1,2,'Train the Trainers','Rather than all developers being trained centrally, a select group will be trained.
These people will then be responsible for training other developers in their group.',SYSDATE +(-89),SYSDATE,'-1',SYSDATE,'-1');"
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (2,2,'All Developers Trained','Train the Trainers will have successfully trained the remaining development team members.',SYSDATE +(-85),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (3,3,'Move Data Structures','Move all of the tables and program logic across to the new database',SYSDATE +(-19),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (4,3,'Redevelop HR Applications','Build applications to replace the HR functionality currently implemented in older technologies',SYSDATE +(-11),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (5,3,'Redevelop Project Tracking Applications','Build applications to replace the project tracking functionality currently running on legacy servers',SYSDATE +(-5),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (6,4,'Define Requirements','Work with key stakeholders to define the scope of the project, and design screen flow and data requirements.',SYSDATE +(-2),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (7,4,'Build Proof-of-Concept','Create the initial screens and populate with data so key stakeholders can review proposed solution.',SYSDATE +(5),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (8,5,'Define Production App Scope','Based on the results of the POC, define the requirements for the production app.',SYSDATE +(6),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (9,5,'Build Phase 1 of Production Partner Portal App','Develop the modules defined in the first phase of the application.',SYSDATE +(13),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (10,5,'Perform Beta testing with select Partners','Work with a few key partners to trial Phase 1 of the Partner Portal app.',SYSDATE +(21),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (11,5,'Complete Phase 1 Development of Partner Portal app','Based on the results of the Beta program, enhance the application to make production ready.',SYSDATE +(48),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (12,5,'Roll out Phase 1 of Partner Portal app','Go-Live for the Partner Portal application to all partners.',SYSDATE +(52),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (13,6,'Define Reporting Requirements`','Work with key stakeholders to define the scope of the project, and design data requirements.',SYSDATE +(-78),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (14,6,'Build First Cut of Executive Dashboard','Create the initial screens and populate with data so key executives can review the initial solution.',SYSDATE +(-70),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (15,7,'Define IT Management App Scope','Define the different apps required to meet IT requirements.',SYSDATE +(-75),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (16,7,'Build Phase 1 of IT Management Apps','Develop the modules defined in the first phase of the applications.',SYSDATE +(-70),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (17,7,'Perform Beta testing with IT staff','Work with a few key IT personnel to trial Phase 1 of the IT Management apps.',SYSDATE +(-64),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (18,7,'Complete Phase 1 Development of IT Management apps','Based on the results of the Beta program, enhance the application to make production ready.',SYSDATE +(-59),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (19,7,'Roll out Phase 1 of IT Management apps','Go-Live for the IT Management apps for IT staff.',SYSDATE +(-53),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (20,8,'Review Productivity App','Work with key stakeholders to prioritize improvements to the default Productivity App.',SYSDATE +(-51),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (21,8,'Deliver First-Cut of Customer Tracker','Create the initial screens and populate with data so key executives can review the initial solution.',SYSDATE +(-47),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (22,8,'Deliver Final Customer Tracker Application','Deliver the completed application to the business.',SYSDATE +(-39),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (23,10,'Define IT Management App Enhancement Scope','Define the updates required to improve the apps.',SYSDATE +(-34),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (24,10,'Build Final Phase of IT Management Apps','Develop the modules defined in the final phase of the applications.',SYSDATE +(-27),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (25,10,'Perform Beta testing with IT staff of revised IT Management Apps','Work with a few key IT personnel to trial the final IT Management apps.',SYSDATE +(-24),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (26,10,'Complete Final Development of IT Management apps','Enhance the application further to meet outstanding requirements.',SYSDATE +(-14),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (27,10,'Roll out final IT Management app','Go-Live for the IT Management application.',SYSDATE +(-9),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (28,11,'Review Bug Tracker Productivity App','Work with key stakeholders to prioritize improvements to the default Productivity App.',SYSDATE +(-28),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (29,11,'Deliver First-Cut of Bug Tracker','Create the initial screens and populate with data so key stakeholders can review the initial solution.',SYSDATE +(-22),SYSDATE,'-1',SYSDATE,'-1');
INSERT INTO EBA_PROJECT_MILESTONES( ID,PROJECT_ID,NAME,DESCRIPTION,DUE_DATE,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES (30,11,'Deliver Final Customer Tracker Application','Deliver the completed application to the business.',SYSDATE +(-15),SYSDATE,'-1',SYSDATE,'-1');
eba_project_status-演示数据
prompt Importing table eba_project_status... set feedback off set define off insert into eba_project_status (ID, CODE, DESCRIPTION, DISPLAY_ORDER, CREATED, CREATED_BY, UPDATED, UPDATED_BY) values (1, 'ASSIGNED', 'Assigned', 1, '18-4月 -26 08.55.42.396980 上午 +08:00', 'HR', '18-4月 -26 08.55.42.396997 上午 +08:00', 'HR'); insert into eba_project_status (ID, CODE, DESCRIPTION, DISPLAY_ORDER, CREATED, CREATED_BY, UPDATED, UPDATED_BY) values (2, 'IN-PROGRESS', 'In-Progress', 2, '18-4月 -26 08.55.42.404773 上午 +08:00', 'HR', '18-4月 -26 08.55.42.404799 上午 +08:00', 'HR'); insert into eba_project_status (ID, CODE, DESCRIPTION, DISPLAY_ORDER, CREATED, CREATED_BY, UPDATED, UPDATED_BY) values (3, 'COMPLETED', 'Completed', 3, '18-4月 -26 08.55.42.408758 上午 +08:00', 'HR', '18-4月 -26 08.55.42.408783 上午 +08:00', 'HR'); insert into eba_project_status (ID, CODE, DESCRIPTION, DISPLAY_ORDER, CREATED, CREATED_BY, UPDATED, UPDATED_BY) values (4, 'CLOSED', 'Closed', 4,current_timestamp,'HR',current_timestamp,'HR'); prompt Done.
EBA_PROJECT_TASK_LINKS
INSERT INTO EBA_PROJECT_TASK_LINKS(ID,PROJECT_ID,TASK_ID,LINK_TYPE,URL,APPLICATION_ID,APPLICATION_PAGE,DESCRIPTION,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES ( 1,1,2,'URL','http://Web-tool.download.com','','','Ficticous download page for Web development tool',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_LINKS(ID,PROJECT_ID,TASK_ID,LINK_TYPE,URL,APPLICATION_ID,APPLICATION_PAGE,DESCRIPTION,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES ( 2,1,2,'URL','http://Web-tool.install.com','','','Ficticous installation guide for Web development tool',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_LINKS(ID,PROJECT_ID,TASK_ID,LINK_TYPE,URL,APPLICATION_ID,APPLICATION_PAGE,DESCRIPTION,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES ( 3,1,3,'URL','http://Web-Listener.download.com','','','Ficticous download page for Web Listener',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_LINKS(ID,PROJECT_ID,TASK_ID,LINK_TYPE,URL,APPLICATION_ID,APPLICATION_PAGE,DESCRIPTION,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES ( 4,1,3,'URL','http://Web-Listener.install.com','','','Ficticous installation guide for Web Listener',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_LINKS(ID,PROJECT_ID,TASK_ID,LINK_TYPE,URL,APPLICATION_ID,APPLICATION_PAGE,DESCRIPTION,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES ( 5,1,4,'URL','https://Web-tool.admin.com','','','Ficticous administration guide for Web development tool',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_LINKS(ID,PROJECT_ID,TASK_ID,LINK_TYPE,URL,APPLICATION_ID,APPLICATION_PAGE,DESCRIPTION,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES ( 6,2,8,'URL','https://Web-tool.examples.com','','','Ficticous examples page for Web development tool',SYSDATE,'-1',SYSDATE,'-1'); INSERT INTO EBA_PROJECT_TASK_LINKS(ID,PROJECT_ID,TASK_ID,LINK_TYPE,URL,APPLICATION_ID,APPLICATION_PAGE,DESCRIPTION,CREATED,CREATED_BY,UPDATED,UPDATED_BY ) VALUES ( 7,3,13,'URL','http://Web-data-modeler.info.com','','','Ficticous information site for the data mdoeling tool',SYSDATE,'-1',SYSDATE,'-1');
EBA_PROJECT_TASKS
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(1,1,'','Identify Server Requirements','Determine which databases will be used to install Web development tool for Development, QA, and Production.
Also specify which Web Listeners will be used for the three environments.','Tameka Hall', SYSDATE +(-93),SYSDATE +(-92),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(2,1,'','Install Web development tool','Install the latest version of Web development tool from the vendor into the databases for Development, QA, and Production.
Note: For QA and Production, Web development tool should be configured as run time only.','Mei Yu', SYSDATE +(-91),SYSDATE +(-91),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(3,1,'','Configure Web Listeners','Configure the three Web Listeners for Web development tool to support the Dev, QA, and Prod environments.','Harold Youngblood', SYSDATE +(-91),SYSDATE +(-91),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(4,1,'','Configure Web development tool Instance Administration Settings','Set the appropriate security and configuration settings for the development instance using specified tools.
Also set instance settings for QA and Production using the available APIs.','Bernard Jackman', SYSDATE +(-90),SYSDATE +(-90),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(5,1,'','Define Workspaces','Define workspaces needed for different application development teams.
It is important that access be granted to the necessary schemas and/or new schemas created as appropriate.
Then export these workspaces and import them into QA and Production environments.','Mei Yu', SYSDATE +(-89),SYSDATE +(-89),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(6,1,'','Assign Workspace Administrators','In development assign a minimum of two Workspace administators to each workspace.
These administrators will then be responsible for maintaining developer access within their own workspaces.','Harold Youngblood', SYSDATE +(-89),SYSDATE +(-89),250,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(7,2,'1','Prepare Course Outline','Creation of the training syllabus','Madison Smith', SYSDATE +(-93),SYSDATE +(-89),5000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(8,2,'1','Write Training Guide','Produce the powerpoint deck (with notes) for the training instructor.','Madison Smith', SYSDATE +(-88),SYSDATE +(-86),3000,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(9,2,'1','Develop Training Exercises','Create scripts for sample data and problem statements with solutions.','Miyazaki Yokohama', SYSDATE +(-92),SYSDATE +(-86),5000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(10,2,'1','Conduct Train-the-Trainer session','Give the training material to the selected developers.','Madison Smith', SYSDATE +(-85),SYSDATE +(-83),2500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(11,2,'2','Train Developers I','Give the training to developers within your group.','Tyson King', SYSDATE +(-82),SYSDATE +(-80),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(12,2,'2','Train Developers II','Give the training to developers within your group.','Daniel James Lee', SYSDATE +(-80),SYSDATE +(-78),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(13,3,'3','Create New Tables','Create table scripts to replicate the legacy tables','Tameka Hall', SYSDATE +(-19),SYSDATE +(-19),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(14,3,'3','Migrate data from Legacy Server','Develop scripts to populate the new database tables from the legacy database.','Nina Herschel', SYSDATE +(-18),SYSDATE +(-15),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(15,3,'3','Convert transaction logic','Convert the legacy database transactional objects across to the new database','Tameka Hall', SYSDATE +(-18),SYSDATE +(-16),2500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(16,3,'4','Redevelop Timesheet App','Develop desktop and mobile app for entering timesheets','Eva Jelinek', SYSDATE +(-16),SYSDATE +(-11),6000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(17,3,'4','Create Shift Schedule App','Create an app for defining when people are scheduled to work different shifts.','Daniel James Lee', SYSDATE +(-16),SYSDATE +(-8),7500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(18,3,'4','Reengineer Employee App','Create an app for employee details and benefits.','Daniel James Lee', SYSDATE +(-7),SYSDATE +(-5),3000,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(19,3,'5','Customize Customer Tracker Productivity App','Install Customer Tracker and use flex fields to meet requirements.','Brock Shilling', SYSDATE +(-5),SYSDATE +(-5),750,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(20,3,'5','Migrate data into Customer Tracker tables','Move previous project tracking data into the Customer Tracker APEX$CUST_xxx tables.','Brock Shilling', SYSDATE +(-4),SYSDATE +(-3),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(21,3,'5','Pilot new Customer Tracker application','Use Customer Tracker to ensure it meets requirements.','Bernard Jackman', SYSDATE +(-2),SYSDATE +(7),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(22,4,'6','Define scope of Partner Portal App.','Meet with internal and external SMEs and define the requirements','Bernard Jackman', SYSDATE +(-5),SYSDATE +(2),4000,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(23,4,'6','Define Partner App Data Structures','Design the data model for new and existing entities required to support the Partner Portal.','Daniel James Lee', SYSDATE +(2),SYSDATE +(5),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(24,4,'6','Design User Experience','Define how partners will interact with the application.','Madison Smith', SYSDATE +(3),SYSDATE +(4),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(25,4,'7','Develop Admin Screens for Partner Portal','Develop the screens needed to maintain all of the base tables for the Partner Portal app.','Nina Herschel', SYSDATE +(6),SYSDATE +(8),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(26,4,'7','Populate Data Structures for Partner Portal','Upload sample data provided by key partner, and ensure existing tables accessible.','Harold Youngblood', SYSDATE +(6),SYSDATE +(7),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(27,4,'7','Design first-cut of main Partner Portal app','Implement the major functional areas and ensure navigation between pages is working correctly.','Madison Smith', SYSDATE +(5),SYSDATE +(9),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(28,4,'7','Present POC to Key Stakeholders','Walk key stakeholders through the proof of concept and obtain their feedback.','Bernard Jackman', SYSDATE +(10),SYSDATE +(10),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(29,5,'8','Define production scope of Partner Portal App.','Define the scope and timelines for the development of the production app.','Lucille Beatie', SYSDATE +(11),SYSDATE +(12),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(30,5,'8','Finalize Partner App Data Model','Refine the data model for new and existing entities required to support the Partner Portal','Daniel James Lee', SYSDATE +(11),SYSDATE +(12),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(31,5,'8','Finalize User Experience for Partner Portal app','Write developer standards on UX and development standards on how partners will interact with the application.','Madison Smith', SYSDATE +(11),SYSDATE +(12),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(32,5,'9','Refine Admin Screens for Partner Portal','Refine screens developed in the POC to be fully operational to maintain all of the base tables for the Partner Portal app.','Madison Smith', SYSDATE +(13),SYSDATE +(16),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(33,5,'9','Populate Data Structures for Production Partner Portal','Upload actual data provided by key partner, and ensure existing tables accessible.','Mei Yu', SYSDATE +(13),SYSDATE +(15),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(34,5,'9','Design production screens for main Partner Portal app','Implement fully functional and complete screens to cover the major functional areas in Phase 1.','Tyson King', SYSDATE +(15),SYSDATE +(21),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(35,5,'10','Train Partners','Train selected partners in how to use the Partner Portal app.','Miyazaki Yokohama', SYSDATE +(20),SYSDATE +(20),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(36,5,'10','Monitor Partners','Monitor partners selected for the Beta and provide assistance as necessary.','Eva Jelinek', SYSDATE +(21),SYSDATE +(26),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(37,5,'10','Review Beta Feedback from Partners','Analyse feedback from the partners who participated in the Beta program.','Lucille Beatie', SYSDATE +(27),SYSDATE +(27),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(38,5,'11','Improve existing feature functions based on feedback','Enhance existing features based on responses from Beta partners.','Mei Yu', SYSDATE +(30),SYSDATE +(49),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(39,5,'11','Add missing feature functions','Add missing features outlined in responses from Beta partners.','Tameka Hall', SYSDATE +(30),SYSDATE +(49),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(40,5,'11','Load full portal data','Ensure all data required for production roll out are inserted and maintained.','Harold Youngblood', SYSDATE +(44),SYSDATE +(49),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(41,5,'11','Test Production Partner Portal','Do full scale testing on the Partner Portal application.','Daniel James Lee', SYSDATE +(50),SYSDATE +(54),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(42,5,'12','Install Partner Portal app onto Production Server','Install the database objects and application(s) into the production environment.','Tameka Hall', SYSDATE +(55),SYSDATE +(55),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(43,5,'12','Configure initial data load procedures','Install and test data load procedures from internal and external data sources into production environment.','Harold Youngblood', SYSDATE +(56),SYSDATE +(57),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(44,5,'12','Provide user credentials for partners','Define user credentials for each partner to allow access to the Partner Portal app.','Lucille Beatie', SYSDATE +(57),SYSDATE +(57),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(45,5,'12','Announce Partner Portal app to all partners','Email or call partners to inform them of the new application and instructions on how to get started.','Lucille Beatie', SYSDATE +(58),SYSDATE +(58),0,'N');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(46,6,'13','Define scope of CEO Reporting','Meet with executives to define the high level requirements','Lucille Beatie', SYSDATE +(-76),SYSDATE +(-76),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(47,6,'13','Define data requirements','Specify the data sources required to support the reports.','Mei Yu', SYSDATE +(-75),SYSDATE +(-73),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(48,6,'13','Design Dashboard presentation','Define how data will be displayed in the dashboard.','Madison Smith', SYSDATE +(-73),SYSDATE +(-72),1500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(49,6,'14','Develop Admin Screens for Executive Dashboard`','Develop the screens needed to maintain all of the base tables for the executive reporting app.','Nina Herschel', SYSDATE +(-71),SYSDATE +(-71),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(50,6,'14','Populate Data Structures for Executive Dashboard','Upload reporting data from external sources into local tables.','Mei Yu', SYSDATE +(-71),SYSDATE +(-70),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(51,6,'14','Build first-cut of Executive Dashboard app','Implement the major functional areas and ensure navigation between pages is working correctly.','Madison Smith', SYSDATE +(-69),SYSDATE +(-65),4000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(52,6,'14','Present First Cut to executives','Walk key stakeholders through the initial reports and obtain their feedback.','Lucille Beatie', SYSDATE +(-64),SYSDATE +(-64),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(53,7,'15','Define the primary IT requirements.','Define the scope and timelines for the development of the IT Management apps.','Bernard Jackman', SYSDATE +(-74),SYSDATE +(-73),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(54,7,'15','Finalize IT Management Apps Data Model','Define the data model for new and existing entities required to support the IT Management apps.','Tyson King', SYSDATE +(-73),SYSDATE +(-70),5000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(55,7,'15','Finalize User Experience for IT Management app','Write developer standards on UX and development standards on how IT will interact with the applications.','Madison Smith', SYSDATE +(-71),SYSDATE +(-70),2500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(56,7,'16','Define Admin Screens for IT Management Apps','Define screens to maintain all of the base tables for the IT Management apps.','Brock Shilling', SYSDATE +(-71),SYSDATE +(-69),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(57,7,'16','Populate Data Structures for IT Management Apps','Upload actual data provided from other IT systems.','Eva Jelinek', SYSDATE +(-70),SYSDATE +(-68),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(58,7,'16','Design production screens for IT Management apps','Implement fully functional and complete screens to cover the major functional areas in Phase 1.','Tyson King', SYSDATE +(-69),SYSDATE +(-64),6000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(59,7,'17','Train IT personnel','Train selected IT staff in how to use the apps.','Tyson King', SYSDATE +(-62),SYSDATE +(-62),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(60,7,'17','Monitor IT Staff','Monitor IT staff selected for the Beta and provide assistance as necessary.','Eva Jelinek', SYSDATE +(-61),SYSDATE +(-59),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(61,7,'17','Review Beta Feedback from IT staff','Analyse feedback from the IT staff who participated in the Beta program.','Bernard Jackman', SYSDATE +(-58),SYSDATE +(-58),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(62,7,'18','Improve existing feature functions','Enhance existing features based on responses from Beta staff.','Brock Shilling', SYSDATE +(-57),SYSDATE +(-53),7000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(63,7,'18','Add required feature functions','Add missing features outlined in responses from Beta staff.','Eva Jelinek', SYSDATE +(-57),SYSDATE +(-53),5500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(64,7,'18','Load full production data','Ensure all data required for production roll out are inserted and maintained.','Harold Youngblood', SYSDATE +(-55),SYSDATE +(-53),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(65,7,'18','Test IT Management Apps','Do full scale testing on the IT Management apps.','Daniel James Lee', SYSDATE +(-52),SYSDATE +(-52),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(66,7,'19','Install IT Management apps onto Production Server','Install the database objects and application(s) into the production environment.','Harold Youngblood', SYSDATE +(-51),SYSDATE +(-51),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(67,7,'19','Configure final data load procedures','Install and test data load procedures from internal and external data sources into production environment.','Harold Youngblood', SYSDATE +(-50),SYSDATE +(-49),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(68,7,'19','Provide user credentials for IT staff','Define user credentials for each IT staff member to allow access to the IT Management apps.','Tyson King', SYSDATE +(-49),SYSDATE +(-49),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(69,7,'19','Announce IT Management apps to all IT staff','Email or call IT staff to inform them of the new application and instructions on how to get started.','Bernard Jackman', SYSDATE +(-48),SYSDATE +(-48),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(70,8,'20','Install Customer Tracker Productivity App','Install the Productivity app and turn on the appropriate options.','Miyazaki Yokohama', SYSDATE +(-47),SYSDATE +(-47),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(71,8,'20','Define external customer data feeds','Specify the data sources for customer data.','Mei Yu', SYSDATE +(-47),SYSDATE +(-46),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(72,8,'20','Design Customer Tracker Look and Feel','Define how data will be displayed on customers.','Madison Smith', SYSDATE +(-46),SYSDATE +(-45),1500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(73,8,'21','Define necessary flex-fields within the Customer Tracker app','Add the additional customer attributes required using the flex fields.','Miyazaki Yokohama', SYSDATE +(-44),SYSDATE +(-44),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(74,8,'21','Populate Data Structures for Customer Tracker','Upload existing customer data from external sources into local tables.','Mei Yu', SYSDATE +(-43),SYSDATE +(-42),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(75,8,'21','Customize the Customer Tracker app','Use built-in functionality and Theme Roller to tweak the application.','Madison Smith', SYSDATE +(-42),SYSDATE +(-42),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(76,8,'21','Present First Cut to executives','Walk key stakeholders through the initial app and obtain their feedback.','Lucille Beatie', SYSDATE +(-40),SYSDATE +(-40),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(77,8,'22','Define additional flex-fields within the Customer Tracker app','Add the extra customer attributes required using the flex fields.','Miyazaki Yokohama', SYSDATE +(-38),SYSDATE +(-38),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(78,8,'22','Final upload of Data Structures for Customer Tracker','Reload customer data from external sources into local tables.','Mei Yu', SYSDATE +(-37),SYSDATE +(-37),1500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(79,8,'22','Customize the Customer Tracker app based on First-Cut feedback','Use built-in functionality and Theme Roller to tweak the application.','Madison Smith', SYSDATE +(-37),SYSDATE +(-37),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(80,8,'22','Train reps on use of Customer Tracker','Walk key users through the application.','Miyazaki Yokohama', SYSDATE +(-36),SYSDATE +(-36),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(81,9,'','Define main requirements for tracking customer satisfaction.','Define the scope and timelines for the development of the tracking app.','Bernard Jackman', SYSDATE +(-46),SYSDATE +(-45),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(82,9,'','Finalize Customer Satisfaction Tracker Data Model','Define the data model for new and existing entities required to support customer satisfaction tracking.','Tyson King', SYSDATE +(-44),SYSDATE +(-42),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(83,9,'','Finalize User Experience for Customer Satisfaction app','Write developer standards on UX and development standards on how the company will acquire and report on customer satisfaction.','Madison Smith', SYSDATE +(-44),SYSDATE +(-43),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(84,9,'','Define Admin Screens for Customer Satisfaction App','Define screens to maintain all of the base tables for the Customer Satisfaction apps.','Brock Shilling', SYSDATE +(-42),SYSDATE +(-41),2750,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(85,9,'','Populate Data Structures for Customer Satisfaction Apps','Upload actual data provided from other IT systems.','Eva Jelinek', SYSDATE +(-41),SYSDATE +(-41),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(86,9,'','Design production screens for the customer to provide feedback','Implement fully functional and complete screens to allow customers to provide feedback.','Tyson King', SYSDATE +(-40),SYSDATE +(-38),3500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(87,9,'','Design internal screens for collecting feedback and analyzing results','Develop data entry and reporting screens to manage Customer Satisfaction.','Eva Jelinek', SYSDATE +(-40),SYSDATE +(-37),5000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(88,9,'','Test Customer Satisfaction internal / external apps','Do full scale testing on both the customer facing and internal-only screens.','Daniel James Lee', SYSDATE +(-36),SYSDATE +(-35),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(89,9,'','Contact initial customers to educate them on providing feedback','Work off a call list to email or call the beta customers and monitor their responses.','Harold Youngblood', SYSDATE +(-36),SYSDATE +(-32),5500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(90,9,'','Announce Customer Satisfaction apps to all customers and staff','Email all current customers and staff to inform them of the new application and instructions on how to get started.','Bernard Jackman', SYSDATE +(-33),SYSDATE +(-33),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(91,10,'23','Define improvements to IT requirements.','Define the scope and timelines for the improvement to the IT Management apps.','Bernard Jackman', SYSDATE +(-32),SYSDATE +(-32),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(92,10,'23','Revise IT Management Apps Data Model','Define the data model for new entities required to support the updated IT Management apps.','Tyson King', SYSDATE +(-31),SYSDATE +(-29),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(93,10,'23','Refine User Experience for IT Management Apps','Update developer standards on UX and development standards on how IT will interact with the applications.','Madison Smith', SYSDATE +(-31),SYSDATE +(-30),2500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(94,10,'24','Populate New Data Structures for IT Management Apps','Upload actual data provided from other IT systems.','Eva Jelinek', SYSDATE +(-29),SYSDATE +(-27),3000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(95,10,'24','Design production screens for revised IT Management apps','Implement fully functional and complete screens to cover the major functional areas.','Tyson King', SYSDATE +(-29),SYSDATE +(-23),6000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(96,10,'25','Train IT personnel in updated app','Train selected IT staff in how to use the apps.','Tyson King', SYSDATE +(-21),SYSDATE +(-51),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(97,10,'25','Monitor IT Staff on IT Management Apps','Monitor IT staff and provide assistance as necessary.','Eva Jelinek', SYSDATE +(-20),SYSDATE +(-17),4000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(98,10,'26','Implement additional feature functions to IT Management Apps','Enhance existing features based on responses from IT staff.','Brock Shilling', SYSDATE +(-16),SYSDATE +(-11),6000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(99,10,'26','Implement outstanding feature functions','Add missing features outlined in responses from IT staff.','Eva Jelinek', SYSDATE +(-16),SYSDATE +(-12),5500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(100,10,'26','Load new production data for final IT Management Apps','Ensure all data required for production roll out are inserted and maintained.','Harold Youngblood', SYSDATE +(-10),SYSDATE +(-10),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(101,10,'26','Test Production-Ready IT Management Apps','Do full scale testing on the IT Management Apps.','Daniel James Lee', SYSDATE +(-9),SYSDATE +(-8),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(102,10,'27','Install revised IT Management apps onto Production Server','Install the revised database objects and application(s) into the production environment.','Harold Youngblood', SYSDATE +(-7),SYSDATE +(-7),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(103,10,'27','Configure production data load procedures','Install and test data load procedures from internal and external data sources into production environment.','Harold Youngblood', SYSDATE +(-6),SYSDATE +(-5),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(104,10,'27','Announce Rollout of revised IT Management apps to all IT staff','Email or call IT staff to inform them of the new application and details on new features.','Bernard Jackman', SYSDATE +(-4),SYSDATE +(-4),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(105,11,'28','Install Bug Tracker Productivity App','Install the Productivity app and turn on the appropriate options.','Miyazaki Yokohama', SYSDATE +(-23),SYSDATE +(-53),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(106,11,'28','Define external bug data feeds','Specify the data sources for bug data.','Mei Yu', SYSDATE +(-22),SYSDATE +(-21),2500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(107,11,'28','Design Bug Tracker Look and Feel','Define how data will be displayed on bugs.','Madison Smith', SYSDATE +(-22),SYSDATE +(-20),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(108,11,'29','Define necessary customizations to the Bug Tracker app','Add the additional attributes required based on the bug information being delivered.','Miyazaki Yokohama', SYSDATE +(-20),SYSDATE +(-19),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(109,11,'29','Populate Data Structures for Bug Tracker','Upload existing bug data from external sources into local tables.','Mei Yu', SYSDATE +(-18),SYSDATE +(-18),1500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(110,11,'29','Customize the Bug Tracker app','Use built-in functionality and Theme Roller to tweak the application.','Madison Smith', SYSDATE +(-18),SYSDATE +(-18),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(111,11,'29','Present First Cut to stakeholders','Walk key stakeholders through the initial app and obtain their feedback.','Lucille Beatie', SYSDATE +(-16),SYSDATE +(-16),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(112,11,'30','Define additional tables / columns within the Bug Tracker app','Add the extra bug attributes required based on feedback.','Miyazaki Yokohama', SYSDATE +(-14),SYSDATE +(-43),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(113,11,'30','Final upload of Data Structures for Bug Tracker','Reload bug data from external sources into local tables.','Mei Yu', SYSDATE +(-12),SYSDATE +(-11),1500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(114,11,'30','Customize the Bug Tracker app based on First-Cut feedback','Use built-in functionality and Theme Roller to tweak the application.','Madison Smith', SYSDATE +(-11),SYSDATE +(-11),500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(115,11,'30','Train staff on use of Bug Tracker','Walk key users through the application.','Miyazaki Yokohama', SYSDATE +(-9),SYSDATE +(-8),2500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(116,12,'','Define main requirements for customer success application.','Define the scope and timelines for the development of the app.','Bernard Jackman', SYSDATE +(-16),SYSDATE +(-15),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(117,12,'','Finalize Customer Success Data Model','Define the data model for new and existing entities required to support customer success input and reporting.','Tyson King', SYSDATE +(-14),SYSDATE +(-12),2500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(118,12,'','Finalize User Experience for Customer Success app','Write developer standards on UX and development standards on how the company will acquire and report on customer success.','Madison Smith', SYSDATE +(-14),SYSDATE +(-13),2500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(119,12,'','Define Admin Screens for Customer Success App','Define screens to maintain all of the base tables for the Customer Success apps.','Brock Shilling', SYSDATE +(-42),SYSDATE +(-11),1500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(120,12,'','Populate Data Structures for Customer Success App','Upload actual data provided from other IT systems.','Eva Jelinek', SYSDATE +(-11),SYSDATE +(-11),1000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(121,12,'','Design production screens for the customer to provide quotes and success stories','Implement fully functional and complete screens to allow customers to provide input.','Tyson King', SYSDATE +(-10),SYSDATE +(-8),2500,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(122,12,'','Design screens for collecting information and analyzing results','Develop data entry and reporting screens to manage Customer Success.','Eva Jelinek', SYSDATE +(-10),SYSDATE +(-7),4000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(123,12,'','Test Customer Success internal / external apps','Do full scale testing on both the customer facing and internal-only screens.','Daniel James Lee', SYSDATE +(-6),SYSDATE +(-5),2000,'Y');
INSERT INTO EBA_PROJECT_TASKS(ID,PROJECT_ID,MILESTONE_ID,NAME,DESCRIPTION,ASSIGNEE,START_DATE,END_DATE,COST,IS_COMPLETE_YN) VALUES(124,12,'','Contact initial customers to educate them on providing quotes and success stories','Work off a call list to email or call the beta customers and monitor their responses.','Harold Youngblood', SYSDATE +(-6),SYSDATE +(-3),4000,'Y');
APEX:Project Data示例项目演示数据(EBA_PROJECTS)
优质生活从拆开始
浙公网安备 33010602011771号