ADDOPT ​
Returns list of Additional/Optional fees for a single registration.
Reporting Area(s) ​
Registrations
Required Parameters ​
- Name ID (i.e. nmid, rgid, pyid)
- Course # (i.e. cocrse, rgcrse, pycrse)
Optional Parameters ​
- Condition to return fees (i.e. "RFDESC = 'Book' " or " RFFEE = 25 "). Default is ALLÂ fees.
- Character return value (i.e. " RFDESC"). Default is Fee Description + $ fee. Enter "RFDESC" to return fee descriptions only. Enter "transform(RFFEE,'$$,$$$.99')" to return fee amounts. Enter "BUCKS" to return total amount of all optional fees.
- Logical .t. only reports the first fee matching the condition specified, .f. returns all fees (default)
- Logical .t. returns fully formatted fees (i.e. Books 3 @ $12 ea = $36).
Example(s) ​
ADDOPT(rgid,rgcrse) returns list of Additional/Optional fee descriptions and amount
ADDOPT(rgid,rgcrse,"RFDESC = 'Book' ") returns Additional/Optional fee description and amount of Book fee
ADDOPT(rgid,rgcrse,"","RFDESC") returns Additional/Optional fee description
ADDOPT(rgid,rgcrse,"","transform(RFFEE,'$$,$$$.99')") returns Additional/Optional fee amount
ADDOPT(rgid,rgcrse,"","BUCKS") returns total amount of all Additional/Optional fees