Skip to content

ADDOPT ​

Returns list of Additional/Optional fees for a single registration.

Reporting Area(s) ​

Registrations

Required Parameters ​

  1. Name ID (i.e. nmid, rgid, pyid)
  2. Course # (i.e. cocrse, rgcrse, pycrse)

Optional Parameters ​

  1. Condition to return fees (i.e. "RFDESC = 'Book' " or " RFFEE = 25 "). Default is ALL fees.
  2. 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.
  3. Logical .t. only reports the first fee matching the condition specified, .f. returns all fees (default)
  4. 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

ADDFEE2