ADDCODE ​
Returns the specified field from the Choices table that holds Code values.
Reporting Area(s) ​
General
Required Parameters ​
- Code Category (i.e. "subj", "srce", "org", "edlv"). Code category must be lowercase
- Code Value (i.e. "MARKET", "78F321", "ADMIN"), or field in cursor that contains Code Value (i.e. nmsource)
Optional Parameters ​
- Field from Choices table to return (i.e. "NO_BROC", "COST") Description is the default
Example(s) ​
ADDCODE("srce",nmsource) returns description of the Source Code (e.g. Newspaper Ad)
ADDCODE("srce","01news","cost") returns $500.00 (tracking code amount)
Code Categories ​
Code Categories and the associated code list.
- adjf - FEES: Registration (OTF) Adjustment Fees
- atnd - ATTEND: Attendance Codes
- atmo - ATTEND: Module Codes
- ccat - COURSE: Course Categories
- coor - COURSE: Course Coordinators
- dept - COURSE: Department Codes
- disa - NAMES: Disability Codes
- edlv - NAMES: Education Level Codes
- empv - FIRM: Employee Codes
- ethn - NAMES: Ethnic Origin Codes
- fees - FEES: Course Main Fee Descriptions
- finaid - FINANCIAL AID: Types
- fmc1 - FIRM: Character 1
- fmc2 - FIRM: Character 2
- fopt - FEES: Course Additional/Optional Fee Descriptions
- ftyp - NAMES: Family Type
- grou - COURSE: Grouping Codes
- hmow - NAMES: Dwelling Type
- inudfc1 - Instructor Screen > Additional Info (UDFs) tab > +Pay Type
- inv - FEES: Inventory Items
- lang - NAMES: Language Codes
- leac - COURSE: Account Numbers
- lect - LEDGER: Major Expense Categories
- ledg - LEDGER: Expense Classification Codes
- loci - LOCATION: City
- loco - LOCATION: County
- mart - NAMES: Marital Status
- memshp - COURSE: Membership Codes
- merc - COURSE: Merchant Numbers
- misc - REGISTER: Miscellaneous Codes
- ninc - NAMES: Household Income
- nmsc - NAMES: Miscellaneous Codes
- occ - NAMES: Occupation Codes
- org - NAMES: Organization Codes
- pmoc - NAMES: Prefer M of C Codes
- pypc - PAY: Payment Identifiers
- refw - PAY: Refund Wizard Pay Adjustments
- rgcd - REGISTER: Reg Code
- salv - NAMES: Salutations
- scope - NAMES: Interest Code Scoping
- sex - NAMES: Sex (Gender) Codes
- sizv - FIRM: Sales Codes
- srce - NAMES: Source/Tracking Codes or REGISTER: Tracking Codes
- stat - REGISTER: Registration Status
- subj - COURSE: Subject Codes or NAMES: Interest Codes
- tetyp - NAMES: Testing & Certification Types