Proposed Universal Substitution System

Caption text

Header text	Header text	Header text
Example	Example	Example
Example	Example	Example
Example	Example	Example

Registrant

Substitution	Description	Source	Tag Replacement	badgecode
uid	outputs the registrant uid.	Tag Replacements	reg_uid	$uid
legal_first	outputs registrant first name.	Tag Replacements	reg_rl_first	$registrant_rl_first
legal_last	outputs registrant last name.	Tag Replacements	reg_rl_last	$registrant_rl_last
legal_name	outputs registrant "first" + "last" name.	Tag Replacements	reg_full_name
common_name	outputs registrant badge name if not empty - otherwise thier "first" + "last" name.	Tag Replacements	reg_badge_name	$registrant_fan_name
badge_name	outputs registrant badge name.	Tag Replacements	reg_birthday	$registrant_birthday
birthday	outputs registrant birthdate.	Tag Replacements	reg_first_created
first_created	outputs registrant account creation date from database.	Tag Replacements	reg_common_name	$registrant_common_name
address_ship_to_name	outputs registrant ship to name.	Tag Replacements	reg_address_ship_to_name
address_line_1	outputs registrant address line 1.	Tag Replacements	reg_address_line_1
address_line_2	outputs registrant address line 2.	Tag Replacements	reg_address_line_2
address_city	outputs registrant address city.	Tag Replacements	reg_address_city
address_state	outputs registrant address state.	Tag Replacements	reg_address_state
address_country	outputs registrant address country.	Tag Replacements	reg_address_country
address_zip	outputs registrant address zip.	Tag Replacements	reg_address_zip
address_full	outputs registrant address with all fields combined.	Tag Replacements	reg_address_full
phone_type	outputs registrant phone type.	Tag Replacements	reg_phone_type
phone_number	outputs registrant phone number.	Tag Replacements	reg_phone_number
email	outputs registrant email.	Tag Replacements	reg_email
payment_hold_created	outputs date payment hold was created for current registrant and event.	Tag Replacements	reg_payment_hold_created
payment_hold_expiry	outputs date payment hold will expire for current registrant and event. ex: 2020-01-22 18:30:15	Tag Replacements	reg_payment_hold_expiry
payment_hold_extendable_to	outputs latest date payment hold can be extended up to for current registrant and event.	Tag Replacements	reg_payment_hold_extendable_to
payment_hold_payment_type	outputs most recent payment type selected for current registrant and event	Tag Replacements	reg_payment_hold_payment_type
payment_hold_expiry_long	outputs long date payment hold will expire for current registrant and event. ex: Wednesday, January 22, 2020, @ 6:30 PM	Tag Replacements	reg_payment_hold_expiry_long
bool_marked_deceased	Returns True if the user is marked deceased	new
bool_ConsoleUser	Returns True if the user has an active console login	new
consoleUserExpiryDate	Displays expiration date for console login	new
CompMoneyRemaining	Displays the remaining comp money	new