ADDFIRM2
Returns specified field from the Firm table based on the Firm ID.
Reporting Area(s)
Course, Instructor, Names
Required Parameters
- Firm ID (i.e.nmfmid, infmid, cofmid)
- Field from Firm Table to return (i.e. "fmcity", "fmextra", "fmcontact")
Optional Parameters
None
Example(s)
ADDFIRM2(infmid,"fmcity") returns city of the instructor's firm
Notes
Firm ID (nmfmid, infmid, cofmid) must be present in the cursor.
This function will converts all returned values to character format.