ADDCODE

Returns the specified field from the Choices table that holds Code values.

Reporting Area(s)

General

Required Parameters

1. *Code Category (i.e. "subj", "srce", "org", "edlv"). Code category must be lowercase
2. Code Value (i.e. "MARKET", "78F321", "ADMIN"), or field in cursor that contains Code Value (i.e. nmsource)

Optional Parameters

3. 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 (i.e. 02 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

Related Functions

QUIKCODE