Suppose a simple query involving professor, asst professor and to find if both can be available before and at a mentioned date?
- 1 Answers
- 804 Views
- I also Faced
- E-Mail Answers
Answer / Moh Sharif Khan
To check the availability of both Professor and Asst. Professor before and at a certain date, you would need to query their schedules. Here is a simplified example in PeopleSoft SQL (PSQL):nn```sqlnSELECT p.employee_id AS professor_id,n ap.employee_id AS asst_professor_id,n p.effective_start_date,n p.effective_end_date,n ap.effective_start_date,n ap.effective_end_date,n (p.effective_end_date - p.effective_start_date) AS professor_duration,n (ap.effective_end_date - ap.effective_start_date) AS asst_professor_duration,n p.effect_type,n ap.effect_typenFROM ps_persons pnJOIN ps_persons ap ON p.employee_id = 'PROF' AND ap.employee_id = 'AP' -- replace with actual professor and asst professor employee IDsnWHERE (p.effective_end_date > date 'your_date') AND (ap.effective_end_date > date 'your_date');```
| Is This Answer Correct ? | 0 Yes | 0 No |
You are a PeopleSoft Partner and wish to get information on database performance benchmark ( or something like this)Where would you look for the info ?
What are the differences between state and temp records?
How to test an application engine program in 8.8?
Explain differences between state and temp records?
What are the different ways of setting up an hrms system to make it position driven and where is this setup done?
Which command shuts down an application server domain using a “forced” shutdown method?
Explain about hrms foundation tables sequencing?
My Asst. Manager approves some document; She uses some screens which presents her with all the data. What she do to minimize the data?
Define standalone rowset?
What are all stored in System Catalog?
Which three peoplesoft tables the db user mentioned in connect id should have permission?
Please differentiate between translate, processing, control and transaction tables?
PeopleSoft HRMS 
