Here is some of the data I'm working with. Since there is only one completion date with seq 20 this person has not completed the program
Progm Org. CD EmplidID Est Comp Date Course Code Compl Date Seq
000005 0599 012345 2003-01-10 003848 2000-05-16 1
000005 0599 012345 2003-01-10...
I have a query setup using PeopleSoft / DB2.
Output would look something like this.
Program 1
Org Name Expected Actual
Completion Completion
Date Date
1234 John 6/10/2002 2/5/2001...
Hello all. I’m trying to create a report that shows employees who have completed training programs. Each prog has several courses. Each course has a seq #. For a program to be completed this criteria must be met:
All courses with a seq of 1 must have a completion date. All courses with a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.