Create a view in the peoplesoft HR database similar to my table structure

I have a table in the access database with the following structure: Name Text Job Title Text Dept Name Text ORG_ID Number MGR_ID Number Email Text Telephone Text I have attached the access database. I would like to get the view (or query) in the peoplesoft HR database to generate (return) the same structure If in the peoplesoft the "Dept Name" or "Job Title" is different it doesn't matter. It doesn't need to have "Email" or "Telephone" fields but it needs to have similar ORG_ID or MGR_ID fields which represent employee id and manager id. Again the basic fields for the view are: (Required) Org_ID employee id (Required)Mgr_Id Manager id (Optional) Name, Title, dept, and some other fields You need to import the required peoplesoft tables tables and the query in MS-Access and send it to me. If you can do this with the latest two version of peoplesoft database that would be a plus. Here is the reason that I need this view: I have application that creates the organizational chart. This application can connect to any database through ADODB and create the orgchart as long as the table and view has two fields. employeeid and supervisorid. I would like to connect this application to the HR peoplesoft database and creates the orgchart using peoplesoft database. If you have experience with peoplesoft marketing for some recommendation that would be a plus. If you are interested I will send you the link to download the evaluation version of the orgchart. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site). ## Platform IIS server, IE browser