Oracle SQL Employee Detail Report -- 2
Budget: $25 – $50 USD
I have an Oracle 12c environment and need a single, well-structured SQL query that returns a detail report on our employee data. The report must list each employee’s job title, department, and key performance metrics in one result set so it can be dropped straight into an existing BI Publisher template.
Scope
• Query must be fully commented, showing table joins, calculated fields for the performance metrics, and any WHERE clauses I can tweak for date ranges or active/inactive status.
• Output columns, in order: Employee_ID, Full_Name, Job_Title, Department_Name, Performance_Score, Metric_Date.
• No summary or aggregation; every employee-metric record should appear on its own row.
• The final script should run cleanly in SQL*Plus and SQL Developer without requiring additional packages.
Acceptance
I’ll consider the job complete once the script returns the correct columns on my dev schema, matches sample data I’ll provide, and execution time stays under two seconds for 50 k rows.
Please let me know if you need schema diagrams or sample tables to get started.
Scope
• Query must be fully commented, showing table joins, calculated fields for the performance metrics, and any WHERE clauses I can tweak for date ranges or active/inactive status.
• Output columns, in order: Employee_ID, Full_Name, Job_Title, Department_Name, Performance_Score, Metric_Date.
• No summary or aggregation; every employee-metric record should appear on its own row.
• The final script should run cleanly in SQL*Plus and SQL Developer without requiring additional packages.
Acceptance
I’ll consider the job complete once the script returns the correct columns on my dev schema, matches sample data I’ll provide, and execution time stays under two seconds for 50 k rows.
Please let me know if you need schema diagrams or sample tables to get started.