AddFee2 (SQL Version)

This version only works in the SQL version of ACEweb. If running the ACEweb VFP version, use ADDFEE2 instead. For Student Manager reporting, using this ADDFEE2 version.

Returns the descriptions and/or amounts of Additional/Optional charges for specific registrations.

ACEweb Area(s)

RegStatusFields INI, RosterFields INI, TranscriptFields INI

Required Parameters

1. Name ID (i.e. nmid-used in RosterFields, pcStuID-used in RegStatusFields and TranscriptFields)
2. Course # (i.e. cocrse-used in RegStatusFields and TranscriptFields,pcClassID-used in RosterFields)

Optional Parameters

3. Numeric return value:
   0=fee description only as a character string
   1= description and amount as a string (default)
   2= fee amount as a numeric value with formatting, e.g. 9999.99
   3= unformatted numeric value
4. Condition to return fee (i.e. "rfdesc='book'")
5. Delimiter to place between description and fee amount (i.e. " ", ", ", " - ")
6. Numeric return value: repeat N times the character string in Parameter 5 (to control spacing between Description and Fee Amount)
7. Logical .t. inserts <br> tag at end of line when the string output option is selected. For use when returning multiple fees.

Example(s)

ADDFEE2SQL(pcStuID,cocrse) returns description and dollar amount of optional charges (Banquet Ticket 12.00)

ADDFEE2SQL(pcStuID,cocrse,2,"rfdesc= 'Book'") returns amount of Book fee (12.00)

padr(ADDFEE2SQL(nmid,pcClassID,,,,,.t.),200) returns description & amount of all optional charges, with charges separated by <br> tags. (the pad function is required to show all optional charges)