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

Skills: ASP, Database Administration, Engineering, Microsoft Access, MySQL, Oracle, PHP, Software Architecture, Software Testing, SQL, Visual Basic

See more: view job, peoplesoft job, need a hr manager, marketing job title, job hr manager, i need a manager's job, i need a job in marketing, hr manager job, hr manager database, create a table chart, create a chart, a job in, job recommendation, program manager download, i need a employee, get download manager, view source, the view, send me the link!, organizational chart, HR, create similar access, create form & connect, database employee, import access database php

About the Employer:
( 151 reviews ) Vienna, United States

Project ID: #2983639

Awarded to:


See private message.

$29.75 USD in 15 days
(3 Reviews)

5 freelancers are bidding on average $58 for this job


See private message.

$59.5 USD in 15 days
(27 Reviews)

See private message.

$29.75 USD in 15 days
(1 Review)

See private message.

$85 USD in 15 days
(1 Review)

See private message.

$85 USD in 15 days
(0 Reviews)