In order for a form to populate with the correct information it will need to first be formatted using a PDF Editing Software (Adobe Acrobat Pro or a similar program). Using the PDF editor you will be able to indicate which sections need to be filled in.
Do this by creating a text field where desired and naming the text field using the correct fillable field code (full list below).
Once a prepared document has been uploaded into your Exempt Edge system, any section that has been coded correctly will automatically populate with the appropriate information when downloaded or printed. Users will still be able to type into fields without a code and also edit any pre-populated details.
This feature works throughout Exempt Edge, for all user types. Pre-filled documents can uploaded to Investor Templates, Approved Required Documents on offerings, Transactions, Investor Profiles, etc.
The following codes are recognizable by our system:
Primary Investor (these fields are used for Individual or Corporate Investors)
Primary Investor Name primary_investor
Primary Investor First Name primary_first_name
Primary Investor Middle Name primary_middle_name
Primary Investor Last Name primary_last_name
Suffix (Mr, Mrs, Ms, Miss) primary_suffix
Marital Status primary_m_status
Citizenship – Canada/USA primary_citizenship
Citizenship if not Canadian or American primary_citizenship_other
Phone Number (XXXXXXXXXX) primary_phone
Phone Number Formatted (XXX)XXX-XXXX primary_phone_formatted
Secondary Phone Number (XXXXXXXXXX) primary_secondary_phone
Secondary Phone Number primary_secondary_phone_formatted
Formatted(XXX)XXX
Primary Email primary_email
Investor External Identifier external_reference_investor
Birthdate
Birthdate (YYYY-MM-DD) primary_birthdate
Birthdate (DD/MM/YYYY) primary_birthday_d/m/Y
Birthdate Day(DD) primary_birthday_day
Birthdate (MM/DD/YYYY) primary_birthday_m/d/Y
Birthdate Month (MM) primary_birthday_month
Birthdate Month Text (MMM) primary_birthday_month_short_text
Birthdate Month (Text) primary_birthday_month_text
Birthdate Year primary_birthday_year
Birthdate (YYYY-MM-DD) primary_birthday_Y-m-d
Address Information
Full Mailing Address primary_full_mail_address
Mailing Street Address primary_mail_address
Mailing Address Suite Number primary_mail_address1
Mailing Address City primary_mail_city
Mailing Address Country primary_mail_country
Mailing Address Postal Code (X1X1X1) primary_mail_postal
Mailing Address Province (AB) primary_mail_province_abb
Mailing Address Province Name primary_mail_province_name
Full Physical Address primary_full_physical_address
Physical Street Address primary_physical_address
Physical Address Suite Number primary_physical_address1
Physical Address City primary_physical_city
Physical Address Country primary_physical_country
Physical Address Postal Code (X1X1X1) primary_physical_postal
Physical Address Province (AB) primary_physical_province_abb
Physical Address Province Name primary_physical_province_name
Identification
Identification Type (Ex. Driver’s License) primary_identification
Identification Expiry (YYYY-MM-DD) primary_identification_expiry
Identification Number primary_identification_number
Identification Place of Issue (City) primary_identification_place_of_issue
Other ID Information primary_identification_other
Other Information
Primary Ages of Dependants primary_ages_of_dependants
Number of Dependants primary_number_of_dependants
Primary Gender primary_gender
Primary Relationship (Spouse) primary_relationship
Primary Tax ID Number (SIN) primary_tax_id
BIN Number (Corporate Investor) primary_cmp_BIN_number
Primary Company Inc Date (Y-m-d) primary_cmp_inc_date_Y-m-d
Primary Company Inc Date (m/d/Y) primary_cmp_inc_date_m/d/Y
Primary Company Inc Date (d/m/Y) primary_cmp_inc_date_d/m/Y
Primary Company Contact primary_cmp_contact
Primary Company Title primary_cmp_title
Joint Investor
Joint Investor Name secondary_investor
Joint Investor First Name secondary_first_name
Joint Investor Middle Name secondary_middle_name
Joint Investor Last Name secondary_last_name
Suffix (Mr, Mrs, Ms, Miss) secondary_suffix
Marital Status secondary_m_status
Primary Citizenship – Canada/USA secondary_citizenship
Contact Information (Joint Investor)
Phone Number (XXXXXXXXXX) secondary_phone
Phone Number Formatted (XXX)XXX-XXXX secondary_phone_formatted
Secondary Phone Number (XXXXXXXXXX) secondary_secondary_phone
Secondary Phone Number Formatted(XXX) secondary_secondary_phone_formatted
Email secondary_email
Birthdate (Joint Investor)
Birthdate (YYYY-MM-DD) secondary_birthday_Y-m-d
Birthdate (DD/MM/YYYY) secondary_birthday_d/m/Y
Birthdate Day(DD) secondary_birthday_day
Birthdate (MM/DD/YYYY) secondary_birthday_m/d/Y
Birthdate Month (MM) secondary_birthday_month
Birthdate Month Text (MMM) secondary_birthday_month_short_text
Birthdate Month (Text) secondary_birthday_month_text
Birthdate Year secondary_birthday_year
Address Information (Joint Investor)
Full Mailing Address secondary_full_mail_address
Mailing Street Address secondary_mail_address
Mailing Address Suite Number secondary_mail_address1
Mailing Address City secondary_mail_city
Mailing Address Country secondary_mail_country
Mailing Address Postal Code (X1X1X1) secondary_mail_postal
Mailing Address Province (AB) secondary_mail_province_abb
Mailing Address Province Name secondary_mail_province_name
Full Physical Address secondary_full_physical_address
Physical Street Address secondary_physical_address
Physical Address Suite Number secondary_physical_address1
Physical Address City secondary_physical_city
Physical Address Country secondary_physical_country
Physical Address Postal Code (X1X1X1) secondary_physical_postal
Physical Address Province (AB) secondary_physical_province_abb
Physical Address Province Name secondary_physical_province_name Identification (Joint Investor)
Identification (Ex. Driver’s License) secondary_identification
Identification Expiry (YYYY-MM-DD) secondary_identification_expiry
Identification Number secondary_identification_number
Identification Place of Issue (City) secondary_identification_place_of_issue
Other Information (Joint Investor)
Relationship (Spouse) secondary_relationship
Tax ID Number secondary_tax_id
Gender secondary_gender
Secondary BIN Number (CorporateInvestor) secondary_cmp_BIN_number
Secondary Company Inc Date (Y-m-d) Secondary_cmp_inc_date_Y-m-d
Secondary Company Inc Date (m/d/Y) Secondary_cmp_inc_date_m/d/Y
Secondary Company Inc Date (d/m/Y) Secondary_cmp_inc_date_d/m/Y
Secondary Company Contact Secondary_cmp_contact
Secondary Company Title Secondary_cmp_title
Issuer or Dealer Details
Your Company Name your_company_name
Your Company Address your_company_address
Your Company Suite Number your_company_address1
Your Company City your_company_city
Your Company Country your_company_country
Your Company Postal Code (X1X1X1) your_company_postal
Your Company Province (AB) your_company_province
Your Company Province Name your_company_province_name
Cheques Payable To Issuer_Cheque_payable
Employment Information - Primary Investor
Occupation primary_occupation
Number of Years Employed primary_years_employed
Employer primary_employer
Employer Address primary_employer_address
Employer Address Suite Number primary_employer_address1
Employer City primary_employer_city
Employer Province primary_employer_province
Employer Postal Code (X1X1X1) primary_employer_postal
Employer Country primary_employer_country
Employment Information - Joint Investor
Occupation secondary_occupation
Number of Years Employed secondary_years_employed
Employer secondary_employer
Employer Address secondary_employer_address
Employer City secondary_employer_city
Employer Province secondary_employer_province
Employer Postal Code (X1X1X1) secondary_employer_postal
Employer Country secondary_employer_country
Account
Account Owners account_owners
(Will list both names if it’s a joint account)
Account Type account_type
Account Number account_number
Account Trust Company account_trust_company
Trust Company Type (Olympia – RRSP) account_trust_company_type
Account Description account_description
Responsible + Description + Account Number = account_trust_info
Account Registration Name account_registration_name
Account Registration Account Reference account_registration
_account_reference
Account Registration Address account_registration_address
Account Registration Phone Number account_registration_phone
Account Delivery Name account_delivery_name
Account Delivery Account Reference account_delivery
_account_reference
Account Delivery Address account_delivery_address
Account Delivery Phone Number account_delivery_phone
Account External Identifier - external_reference_account
(External Application Reference # )
EMD
EMD Name emd_name
EMD Address emd_address
EMD Address 1 emd_address_1
EMD City emd_city
EMD Postal Code emd_postal
EMD Phone Number emd_phone
EMD Province emd_province
EMD Country emd_country
Advisor
Advisor Name advisor_name
Advisor Email advisor_email
Advisor Phone (XXXXXXXXXX) advisor_phone
Issuer Offering details from the Transaction
Issuer Name issue_name
Issuer Contact Name issue_contact_name
Issuer Contact Email issue_contact_email
Issuer Street Address issue_address
Issuer Street Address Suite Number issue_address1
Issuer City issue_city
Issuer Contact Country issue_country
Issuer Postal Code (X1X1X1) issue_postal
Issuer Province issue_province
Offering
Offering Name offering_name
Offering Unit Name offering_unit_name
Offering Security Type offering_security_type
Offering Annual Yield offering_annual_yield
Offering Cost Per Unit offering_cost_per_unit
Transaction
Transaction Total Investment tran_total_investment
Transaction Admin Percentage tran_admin_percent
Transaction Commission Percentage tran_commission_percent Transaction Cost Per Unit tran_cost_per_unit
Transaction Cost Per Unit not Rounded tran_cost_per_unit_no_round
Transaction Currency (CAD/USD) tran_currency
Requested Date tran_date
Requested Date (DD) tran_date_day
Requested Date (MM) tran_date_month
Request Date (YYYY) tran_date_year
Settlement Date trade_date
Settlement Date (DD) trade_date_day
Settlement Date (MM) trade_date_month
Settlement Date (YYYY) trade_date_year
Transaction Dealer Role tran_dealer_role
Transaction Number tran_num
Transaction Total CommissionPercentage tran_total_commission_percent
Transaction Units tran_units
Commission paid to DR tran_dr_commission
Commission % for DR tran_dr_commission_percent
Commission for admin on transaction tran_total_commission_admin Commission for the emd tran_total_commission_emd
Total Commission total_commission
Transaction External Identifier external_reference_transaction
Certificates (Individual and Global)
Certificate Number certificate_number
Full Certificate (including prefix & suffix) certificate_full
Certificate Units certificate_units
Offering/Issuer offering_issuer
Trust Company/Bank trust_company_name
Certificate Active Date certificate_active_date
Certificate Active Date Formatted certificate_active_date_formatted
Certificate Active Date (DD) certificate_active_date_day
Certificate Active Date (MM) certificate_active_date_month
Certificate Active Date (YYYY) certificate_active_date_year
Certificate Historic Date certificate_historic_date
Certificate Historic Date Formatted certificate_historic_date_formatted
Certificate Historic Date (DD) certificate_historic_date_day
Certificate Historic Date (MM) certificate_historic_date_month
Certificate Historic Date (YYYY) certificate_historic_date_year
Certificate Retired Date certificate_retired_date
Certificate Retired Date (DD) certificate_retired_date_day
Certificate Retired Date (MM) certificate_retired_date_month
Certificate Retired Date (YYYY) certificate_retired_date_year
Certificate Owner certificate_owner
Certificate Owner Type certificate_owner_type
Trust Company/Bank + Account Responsible + certificate_responsible
Investor Full Name/Company Name