Em Andamento

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

Habilidades: ASP, Administração de Bancos de Dados, Engenharia, Microsoft Access, MySQL, Oracle, PHP, Arquitetura de software, Teste de Software, SQL, Visual Basic

Ver mais: view job, peoplesoft job, need job marketing, manager job, manager database, create table chart, job recommendation, program manager download, get download manager, view source, the view, organizational chart, hr, create similar access, database employee, import access database php, create email platform, access query table, access create form, connect database php form, access database text, create table using, access table query, telephone database software, orgchart

Acerca do Empregador:
( 150 comentários ) Vienna, United States

ID do Projeto: #2983639

Premiar a:

unitechsolu

See private message.

$29.75 USD em 15 dias
(3 Avaliações)
2.9

5 freelancers estão ofertando em média $58 para este trabalho

hmichopoulos

See private message.

$59.5 USD in 15 dias
(27 Comentários)
3.7
taj1572

See private message.

$29.75 USD in 15 dias
(1 Comentário)
0.9
linkcalifornia

See private message.

$85 USD in 15 dias
(1 Comentário)
0.0
tshaffer

See private message.

$85 USD in 15 dias
(0 Comentários)
0.0