SHOWCLAS
Returns quick summary of courses taken for a single individual with the ability to specify courses by date or by course number.
Reporting Area(s)
Names, Registrations
Required Parameters
- Name ID (i.e. nmid, rgid, pyid)
Optional Parameters
- Condition for course dates ("Cobegdate > Date()")
- Condition for course ("codept='Computer'", "coactive=.t.")
- Logical .t. show location, .f. don't show. Must be enclosed in quotations, i.e. ".t."
- Delimiter: character to place between courses ("--", "/", CHR(13) Carriage Return (default) )
- Numeric return value:
0= Course Number, Title, Dates, Location
1= Course Number only
2= Course Title only
3= Course Number & Course Begin Date
4= Course title & course begin date
5= Course Number and Title
6= Course Number, Title, Date, Ceus, Hours
7= Course Number, Title, Date, Ceus
8= Sum of Ceus
9= Sum of Hours
10= Course Number, Title, Date, Ceus, Hours, Grade
- Field to return from Course table (i.e. "codept", "cocoord")
Example(s)
SHOWCLAS(rgid) returns course number, title, dates, and location off all courses individual has taken
SHOWCLAS(rgid,"","",".f."," ",5) returns course number and title of all courses individual has taken separated by 5 spaces
SHOWCLAS(rgid,"cobegdate < date()""codept='accounting'",".f.","--",1) returns course number off all courses individual has taken in the Accounting department prior to current date separated by '--'