
SET @token_section_personal_details := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'PersonalDetails');
SET @token_section_contact_details := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'ContactDetails');
SET @token_section_job := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'Job');

INSERT INTO `ohrm_token`(`name`, `display_name`, `class_name`, `entity_name`, `value_getters`, `data_group_id`,
                         `is_date`, `localize`,`token_section_id`)
VALUES ('empFirstName', 'Employee First Name', null, 'Employee', 'getFirstName', 1, 0, 0, @token_section_personal_details),
       ('empLastName', 'Employee Last Name', null, 'Employee', 'getLastName', 1, 0, 0, @token_section_personal_details),
       ('empMiddleName', 'Employee Middle Name', null, 'Employee', 'getMiddleName', 1, 0, 0, @token_section_personal_details),
       ('empFullName', 'Employee Full Name', null, 'Employee', 'getFullNameWithoutTerminationTag', 1, 0, 0, @token_section_personal_details),
       ('empId', 'Employee Id', null, 'Employee', 'getEmployeeId', 1, 0, 0, @token_section_personal_details),
       ('empLicenseNumber', 'Drivers License Number', null, 'Employee', 'getLicenseNo', 1, 0, 0, @token_section_personal_details),
       ('empLicenseExpiryDate', 'License Expiry Date', null, 'Employee', 'getEmpDriLiceExpDate', 1, 1, 0, @token_section_personal_details),
       ('empBirthday', 'Date of Birth', null, 'Employee', 'getEmpBirthday', 1, 1, 0, @token_section_personal_details),
       ('empNationality', 'Nationality', null, 'Employee', 'getNationality,getName', 1, 0, 1, @token_section_personal_details),
       ('empMaritialStatus', 'Marital Status', null, 'Employee', 'getEmpMaritalStatus', 1, 0, 1, @token_section_personal_details),
       ('empGender', 'Gender', null, 'Employee', 'getGenderAsString', 1, 0, 0, @token_section_personal_details),
       ('empAddressStreet1', 'Address Street 1', null, 'Employee', 'getStreet1', 4, 0, 0, @token_section_contact_details),
       ('empAddressStreet2', 'Address Street 2', null, 'Employee', 'getStreet2', 4, 0, 0, @token_section_contact_details),
       ('empCity', 'City', null, 'Employee', 'getCity', 4, 0, 0, @token_section_contact_details),
       ('empState', 'State/Province', null, 'Employee', 'getProvinceNameAsString', 4, 0, 0, @token_section_contact_details),
       ('empZipCode', 'Zip/Postal Code', null, 'Employee', 'getEmpZipcode', 4, 0, 0, @token_section_contact_details),
       ('empCountry', 'Country', null, 'Employee', 'getCountryNameAsString', 4, 0, 1, @token_section_contact_details),
       ('empHomeTelephone', 'Home Telephone', null, 'Employee', 'getEmpHmTelephone', 4, 0, 0, @token_section_contact_details),
       ('empMobile', 'Mobile', null, 'Employee', 'getEmpMobile', 4, 0, 0, @token_section_contact_details),
       ('empWorkTelephone', 'Work Telephone', null, 'Employee', 'getEmpWorkTelephone', 4, 0, 0, @token_section_contact_details),
       ('empWorkEmail', 'Work Email', null, 'Employee', 'getEmpWorkEmail', 4, 0, 0, @token_section_contact_details),
       ('empOtherEmail', 'Other Email', null, 'Employee', 'getEmpOthEmail', 4, 0, 0, @token_section_contact_details),
       ('empJoinedDate', 'Joined Date', null, 'Employee', 'getJobRecord,getJoinedDate', 16, 1, 0, @token_section_job),
       ('empProbationEndDate', 'Probation End Date', null, 'Employee', 'getJobRecord,getProbationEndDate', 16, 1, 0, @token_section_job),
       ('empDateOfPermanency', 'Date of Permanency', null, 'Employee', 'getJobRecord,getDateOfPermanency', 16, 1, 0, @token_section_job),
       ('empJobTitle', 'Job Title', null, 'Employee', 'getJobTitleName', 16, 0, 0, @token_section_job),
       ('empEmploymentStatus', 'Employment Status', null, 'Employee', 'getJobRecord,getEmploymentStatus,getName', 16, 0,
        0, @token_section_job),
       ('empJobCategory', 'Job Category', null, 'Employee', 'getJobCategory,getName', 16, 0, 0, @token_section_job),
       ('empSubUnit', 'Sub Unit', null, 'Employee', 'getSubDivision,getName', 16, 0, 0, @token_section_job),
       ('empLocation', 'Location', null, 'Employee', 'getLocationAsString', 16, 0, 0, @token_section_job),
       ('empEffectiveDate', 'Effective Date', null, 'Employee', 'getJobRecord,getEffectiveDate', 16, 1, 0, @token_section_job),
       ('empContractStartDate', 'Contract Start Date', null, 'Employee', 'getJobRecord,getContractStartDate', 16, 1, 0, @token_section_job),
       ('empContractEndDate', 'Contract End Date', null, 'Employee', 'getJobRecord,getContractEndDate', 16, 1, 0, @token_section_job),
       ('CurrentDate', 'Current Date', 'ClientDateTimeTokenValueGenerator', NULL, NULL, NULL, 0, 0, null),
       ('CurrentDateTime', 'Current Date & Time', 'ClientDateTimeTokenValueGenerator', NULL, NULL, NULL, 0, 0, null),
       ('loggedInUserFirstName', 'Logged-In User - First Name', 'LoggedInUserTokenValueGenerator', NULL, NULL, NULL, 0, 0, null),
       ('loggedInUserMiddleName', 'Logged-In User - Middle Name', 'LoggedInUserTokenValueGenerator', NULL, NULL, NULL, 0, 0, null),
       ('loggedInUserLastName', 'Logged-In User - Last Name', 'LoggedInUserTokenValueGenerator', NULL, NULL, NULL, 0, 0, null),
       ('loggedInUserFullName', 'Logged-In User - Full Name', 'LoggedInUserTokenValueGenerator', NULL, NULL, NULL, 0, 0, null),
       ('loggedInUserJobTitle', 'Logged-In User - Job Title', 'LoggedInUserTokenValueGenerator', NULL, NULL, NULL, 0, 0, null);

INSERT INTO `ohrm_token` (`name`, `display_name`, `class_name`, `entity_name`, `value_getters`, `data_group_id`,
                          `is_date`, `localize`, `parameters`)
VALUES ('organizationName', 'Organization Name', 'OrganizationTokenValueGenerator', NULL, NULL, NULL, 0, 0, null),
       ('organizationAddress', 'Organization Address', 'OrganizationTokenValueGenerator', NULL, NULL, NULL, 0, 0,'avoidDefaultEncode=>true,type=>line_breaks');

SET
@current_date_token_id = (SELECT `id` FROM `ohrm_token` WHERE `name`='CurrentDate');
SET
@current_date_time_token_id = (SELECT `id` FROM `ohrm_token` WHERE `name`='CurrentDateTime');
SET
@organization_name_token_id = (SELECT `id` FROM `ohrm_token` WHERE `name`='organizationName');
SET
@organization_address_token_id = (SELECT `id` FROM `ohrm_token` WHERE `name`='organizationAddress');
SET
@logged_in_user_first_name_token_id = (SELECT `id` FROM `ohrm_token` WHERE `name`='loggedInUserFirstName');
SET
@logged_in_user_middle_name_token_id = (SELECT `id` FROM `ohrm_token` WHERE `name`='loggedInUserMiddleName');
SET
@logged_in_user_last_name_token_id = (SELECT `id` FROM `ohrm_token` WHERE `name`='loggedInUserLastName');
SET
@logged_in_user_full_name_token_id = (SELECT `id` FROM `ohrm_token` WHERE `name`='loggedInUserFullName');
SET
@logged_in_user_job_title_token_id = (SELECT `id` FROM `ohrm_token` WHERE `name`='loggedInUserJobTitle');
SET
@core_module_id = (SELECT `id` FROM `ohrm_module` WHERE `name`='core');
INSERT INTO `ohrm_restricted_module_token` (`token_id`, `restricted_module`) VALUES (@current_date_token_id,@core_module_id),
                                                                                    (@current_date_time_token_id,@core_module_id),
                                                                                    (@organization_name_token_id, @core_module_id),
                                                                                    (@organization_address_token_id, @core_module_id),
                                                                                    (@logged_in_user_first_name_token_id, @core_module_id),
                                                                                    (@logged_in_user_middle_name_token_id, @core_module_id),
                                                                                    (@logged_in_user_last_name_token_id, @core_module_id),
                                                                                    (@logged_in_user_full_name_token_id, @core_module_id),
                                                                                    (@logged_in_user_job_title_token_id, @core_module_id);

SET
@personal_information_datagroup_id = (SELECT `id` FROM `ohrm_data_group` WHERE `name`='personal_information');

INSERT INTO `ohrm_token` (`name`, `display_name`, `class_name`, `entity_name`, `value_getters`, `data_group_id`,
                          `is_date`, `localize`, `token_section_id`)
VALUES ('empOtherId', 'Other Id', null, 'Employee', 'getOtherId', @personal_information_datagroup_id, 0, 0, @token_section_personal_details),
       ('empSSNno', 'SSN Number', null, 'Employee', 'getSsn', @personal_information_datagroup_id, 0, 0, @token_section_personal_details),
       ('empEEORaceAndEthnicity', 'EEO Race and Ethnicity', null, 'Employee', 'getEeoRaceAndEthnicity',
        @personal_information_datagroup_id, 0, 1, @token_section_personal_details),
       ('empNickName', 'Nick Name', null, 'Employee', 'getNicknameValue', @personal_information_datagroup_id, 0, 0, @token_section_personal_details),
       ('empMilitaryService', 'Military Service', null, 'Employee', 'getMilitaryServiceValue',
        @personal_information_datagroup_id, 0, 1, @token_section_personal_details),
       ('empSmoker', 'Smoker', null, 'Employee', 'getSmokerStatusAsString', @personal_information_datagroup_id, 0, 1, @token_section_personal_details);

SET
@job_details_datagroup_id = (SELECT `id` FROM `ohrm_data_group` WHERE `name`='job_history_details');

INSERT INTO `ohrm_token` (`name`, `display_name`, `class_name`, `entity_name`, `value_getters`, `data_group_id`,
                          `is_date`, `localize`, `token_section_id`)
VALUES ('empEEOJobCategory', 'EEO Job Category', null, 'Employee', 'getEeoJobCategoryAsString',
        @job_details_datagroup_id, 0, 1, @token_section_job),
       ('empCostCenter', 'Cost Center', 'JobTokenValueGenerator', null, null, @job_details_datagroup_id, 0, 1, @token_section_job),
       ('empPayPolicy', 'Pay Policy', 'JobTokenValueGenerator', null, null, @job_details_datagroup_id, 0, 1, @token_section_job),
       ('empCurrentService', 'Total Service Period', 'JobTokenValueGenerator', null, null, @job_details_datagroup_id, 0, 0, @token_section_job),
       ('empCreditableService', 'Creditable Service', 'JobTokenValueGenerator', null, null, @job_details_datagroup_id,
        0, 0, @token_section_job),
       ('empInitialJoinedDate', 'Initial Joined Date', 'JobTokenValueGenerator', null, null, @job_details_datagroup_id,
        1,
        1, @token_section_job),
       ('empTerminationDate', 'Termination Date', 'JobTokenValueGenerator', null, null, @job_details_datagroup_id, 1,
        1, @token_section_job),
       ('FLSAExempt', 'FLSA Exempt', 'JobTokenValueGenerator', null, null, @job_details_datagroup_id, 0,
        1, @token_section_job),
       ('jobComment', 'Job Comment', 'JobTokenValueGenerator', null, null, @job_details_datagroup_id, 0,
        1, @token_section_job);

SET
@tax_exemptions_datagroup_id = (SELECT `id` FROM `ohrm_data_group` WHERE `name`='tax_exemptions');
SET @token_section_tax_exemptions := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'TaxExemptions');

INSERT INTO `ohrm_token` (`name`, `display_name`, `class_name`, `entity_name`, `value_getters`, `data_group_id`,
                          `is_date`, `localize`, `token_section_id`)
VALUES ('empFederalIncomeTaxStatus', 'Federal Income Tax Status', null, 'Employee',
        'getEmployeeTaxExemptionsRecord, getFederalStatusAsString', @tax_exemptions_datagroup_id, 0, 1, @token_section_tax_exemptions),
       ('empFederalIncomeTaxExemption', 'Federal Income Tax Exemption', null, 'Employee',
        'getEmployeeTaxExemptionsRecord, getFederalExemptions', @tax_exemptions_datagroup_id, 0, 0, @token_section_tax_exemptions),
       ('empStateIncomeTaxState', 'State Income Tax State', null, 'Employee',
        'getEmployeeTaxExemptionsRecord, getTaxStateAsString', @tax_exemptions_datagroup_id, 0, 0, @token_section_tax_exemptions),
       ('empStateIncomeTaxStatus', 'State Income Tax Status', null, 'Employee',
        'getEmployeeTaxExemptionsRecord, getStateStatusAsString', @tax_exemptions_datagroup_id, 0, 1, @token_section_tax_exemptions),
       ('empStateIncomeExemptions', 'State Income Exemptions', null, 'Employee',
        'getEmployeeTaxExemptionsRecord, getStateExemptions', @tax_exemptions_datagroup_id, 0, 0, @token_section_tax_exemptions),
       ('empStateIncomeUnemploymentState', 'State Income Unemployment State', null, 'Employee',
        'getEmployeeTaxExemptionsRecord, getUnemploymentStateRef, getProvinceName', @tax_exemptions_datagroup_id, 0, 1, @token_section_tax_exemptions),
       ('empStateIncomeWorkState', 'State Income Work State', null, 'Employee',
        'getEmployeeTaxExemptionsRecord, getWorkStateRef, getProvinceName', @tax_exemptions_datagroup_id, 0, 1, @token_section_tax_exemptions);

SET
@salary_history_datagroup_id := (SELECT `id` FROM `ohrm_data_group` WHERE `name`='salary_history_details');
SET @token_section_salary := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'Salary');

INSERT INTO `ohrm_token` (`name`, `display_name`, `class_name`, `entity_name`, `value_getters`, `data_group_id`,
                          `is_date`, `localize`, `token_section_id`)
VALUES ('empPayGrade', 'Pay Grade', 'SalaryTokenValueGenerator', null, null, @salary_history_datagroup_id, 0, 1,@token_section_salary),
       ('empPayGradeCurrency', 'Pay Grade - Currency', 'SalaryTokenValueGenerator', null, null,
        @salary_history_datagroup_id, 0, 1, @token_section_salary),
       ('empPayGradeRange', 'Pay Grade - Range', 'SalaryTokenValueGenerator', null, null, @salary_history_datagroup_id,
        0, 0, @token_section_salary),
       ('empEEOPayBand', 'EEO Pay Band', 'SalaryTokenValueGenerator', null, null, @salary_history_datagroup_id, 0, 0, @token_section_salary),
       ('empAnnualBasicPayment', 'Annual Basic Payment', 'SalaryTokenValueGenerator', null, null, 19, 0, 0, @token_section_salary),
       ('empGrossPay', 'Gross Pay', 'SalaryTokenValueGenerator', null, null, @salary_history_datagroup_id, 0, 0, @token_section_salary),
       ('empTotalDeductions', 'Total Deductions', 'SalaryTokenValueGenerator', null, null, @salary_history_datagroup_id,
        0, 0, @token_section_salary),
       ('empCosttotheCompany', 'Cost to the Company', 'SalaryTokenValueGenerator', null, null,
        @salary_history_datagroup_id, 0, 0, @token_section_salary),
       ('empTotalPayable', 'Total Payable', 'SalaryTokenValueGenerator', null, null, @salary_history_datagroup_id, 0,
        0, @token_section_salary),
       ('salaryComment', 'Salary Comment', 'SalaryTokenValueGenerator', null, null, @salary_history_datagroup_id, 0,
        0, @token_section_salary);

SET @report_to_supervisor_datagroup_id := (SELECT `id` FROM `ohrm_data_group` WHERE `name`='supervisor');
SET @report_to_subordinates_datagroup_id := (SELECT `id` FROM `ohrm_data_group` WHERE `name`='subordinates');
SET @token_section_report_to := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'ReportTo');
SET @qualification_work_experience_datagroup_id := (SELECT `id` FROM `ohrm_data_group` WHERE `name`='qualification_work');
SET @qualification_education_datagroup_id := (SELECT `id` FROM `ohrm_data_group` WHERE `name`='qualification_education');
SET @qualification_skills_datagroup_id := (SELECT `id` FROM `ohrm_data_group` WHERE `name`='qualification_skills');
SET @qualification_languages_datagroup_id := (SELECT `id` FROM `ohrm_data_group` WHERE `name`='qualification_languages');
SET @qualification_license_datagroup_id := (SELECT `id` FROM `ohrm_data_group` WHERE `name`='qualification_license');
SET @qualification_certificates_datagroup_id := (SELECT `id` FROM `ohrm_data_group` WHERE `name`='qualification_certificates');
SET @token_section_qualifications := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'Qualifications');
SET @membership_datagroup_id := (SELECT `id` FROM `ohrm_data_group` WHERE `name`='membership');
SET @token_section_memberships := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'Memberships');
SET @token_section_direct_deposit := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'DirectDeposit');
SET @token_section_immigration := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'Immigration');
SET @immigration_datagroup_id := (SELECT `id` FROM ohrm_data_group WHERE `name` = 'immigration');
SET @token_section_emergency_contacts := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'EmergencyContacts');
SET @emergency_contacts_datagroup_id := (SELECT `id` FROM ohrm_data_group WHERE `name` = 'emergency_contacts');
SET @token_section_dependents := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'Dependents');
SET @dependents_datagroup_id := (SELECT `id` FROM ohrm_data_group WHERE `name` = 'dependents');
SET @social_media_datagroup_id := (SELECT `id` FROM ohrm_data_group WHERE `name` = 'social_media');
SET @token_section_social_media := (SELECT `id` FROM ohrm_token_section WHERE `name` = 'SocialMedia');


INSERT INTO `ohrm_token` (`name`, `display_name`, `class_name`, `entity_name`, `value_getters`, `data_group_id`,
                          `is_date`, `localize`, `parameters`, `token_section_id`, `is_multi_attribute`)
VALUES ('ReportTo.Supervisors', 'Supervisors', 'ReportToTokenValueGenerator', null, '{"Name":{"display_name":"Name","value_getter":"getSupervisor,getFullName"},
        "ReportMethod":{"display_name":"Reporting Method","value_getter":"getReportingMethod,getName"}}', @report_to_supervisor_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_report_to, 1),
       ('ReportTo.Subordinates', 'Subordinates', 'ReportToTokenValueGenerator', null, '{"Name":{"display_name":"Name","value_getter":"getSubordinate,getFullName"},
        "ReportMethod":{"display_name":"Reporting Method","value_getter":"getReportingMethod,getName"}}', @report_to_subordinates_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_report_to, 1),
       ('Qualifications.WorkExperience', 'Work Experience', 'QualificationsTokenValueGenerator', null, '{"Company":{"display_name":"Company","value_getter":"getEmployer", "is_date":false},
        "JobTitle":{"display_name":"Job Title","value_getter":"getJobTitle","is_date":false}, "From":{"display_name":"From","value_getter":"getFromDate","is_date":true},"To":{"display_name":"To","value_getter":"getToDate","is_date":true}, "Creditable":{"display_name":"Creditable","value_getter":"getCreditableAsString","is_date":false}, "Comment":{"display_name":"Comment","value_getter":"getComments","is_date":false}}', @qualification_education_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_qualifications, 1),
       ('Qualifications.Education', 'Education', 'QualificationsTokenValueGenerator', null, '{"Level":{"display_name":"Level","value_getter":"getEducation,getName", "is_date":false},
        "Institute":{"display_name":"Institute","value_getter":"getInstitute","is_date":false},"MajorSpecialization":{"display_name":"Major/Specialization","value_getter":"getMajor","is_date":false}, "Year":{"display_name":"Year","value_getter":"getYear","is_date":false},"GPAScore":{"display_name":"GPA/Score","value_getter":"getScore","is_date":false}, "StartDate":{"display_name":"Start Date","value_getter":"getStartDate","is_date":true }, "EndDate": {"display_name":"End Date","value_getter":"getEndDate","is_date":true}}', @qualification_work_experience_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_qualifications, 1),
       ('Qualifications.Skills', 'Skills', 'QualificationsTokenValueGenerator', null, '{"Skill":{"display_name":"Skill","value_getter":"getSkill,getName", "is_date":false},
        "YearsOfExperience":{"display_name":"Years of Experience","value_getter":"getYearsOfExp","is_date":false}, "Comment":{"display_name":"Comment","value_getter":"getComments","is_date":false}}', @qualification_skills_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_qualifications, 1),
       ('Qualifications.Language', 'Language', 'QualificationsTokenValueGenerator', null, '{"Language":{"display_name":"Language","value_getter":"getLanguage,getName"},
        "Skill":{"display_name":"Skill","value_getter":"getFluencyAsString"}, "FluencyLevel":{"display_name":"Fluency Level","value_getter":"getCompetencyAsString"}, "Comment":{"display_name":"Comment","value_getter":"getComments","is_date":false}}', @qualification_languages_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table',@token_section_qualifications, 1),
       ('Qualifications.License', 'License', 'QualificationsTokenValueGenerator', null, '{"Type":{"display_name":"License Type","value_getter":"getLicense,getName", "is_date":false},
        "Number":{"display_name":"License Number","value_getter":"getLicenseNo","is_date":false}, "IssuedDate":{"display_name":"Issued Date","value_getter":"getLicenseIssuedDate","is_date":true},"ExpiryDate":{"display_name":"Expiry Date","value_getter":"getLicenseExpiryDate","is_date":true}}', @qualification_license_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_qualifications, 1),
       ('Qualifications.Certificates', 'Certificates', 'QualificationsTokenValueGenerator', null, '{"Course":{"display_name":"Course","value_getter":"getOnlineCourse,getFormattedOnlineCourseName", "is_date":false},
        "Status":{"display_name":"Status","value_getter":"getFormattedStatus","is_date":false}, "Mark":{"display_name":"Mark","value_getter":"getFormattedMark","is_date":false},"NoOfAttempts":{"display_name":"No of Attempts","value_getter":"getNoOfAttempts","is_date":false},"IssuedDate":{"display_name":"Issued Date","value_getter":"getAssignedDate","is_date":true},"ExpiryDate":{"display_name":"Expiry Date","value_getter":"getDueDate","is_date":true}}', @qualification_certificates_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_qualifications, 1),
       ('Memberships.AssignedMemberships', 'Memberships', 'MembershipsTokenValueGenerator', null, '{"Membership":{"display_name":"Membership","value_getter":"getMembership,getName", "is_date":false},
        "SubscriptionPaidBy":{"display_name":"Subscription Paid By","value_getter":"getSubscriptionPaidBy","is_date":false}, "SubscriptionAmount":{"display_name":"Subscription Amount","value_getter":"getSubscriptionFee","is_currency":true},"Currency":{"display_name":"Currency","value_getter":"getSubscriptionCurrency","is_date":false}, "SubscriptionCommenceDate":{"display_name":"Subscription Commence Date","value_getter":"getSubscriptionCommenceDate","is_date":true}, "SubscriptionRenewalDate":{"display_name":"Subscription Renewal Date","value_getter":"getSubscriptionRenewalDate","is_date":true}}', @membership_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_memberships, 1),
       ('DirectDeposit.DirectDeposit', 'Direct Deposit', 'DirectDepositTokenValueGenerator', null, '{"Amount":{"display_name":"Amount","value_getter":"getAmount", "is_currency":true},
        "AccountNumber":{"display_name":"Account Number","value_getter":"getAccountNumber","is_date":false}, "FinancialInstitution":{"display_name":"Financial Institution","value_getter":"getInstituteName"},"AccountType":{"display_name":"Account Type","value_getter":"getAccountType"}, "BranchLocation":{"display_name":"Branch Location","value_getter":"getBranchLocation"}, "RoutingNumber":{"display_name":"Routing Number","value_getter":"getRoutingNumber"}}', @salary_history_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true,keyAttribute=>RoutingNumber',@token_section_direct_deposit, 1),
       ('Immigration.AssignedImmigrationRecords', 'Immigration Records', 'ImmigrationTokenValueGenerator', null, '{"Document":{"display_name":"Document","value_getter":"getTypeAsString"},
        "Number":{"display_name":"Number","value_getter":"getNumber"}, "IssuedBy":{"display_name":"Issued By","value_getter":"getCountry,getCouName"},"IssuedDate":{"display_name":"Issued Date","value_getter":"getIssuedDate", "is_date":true}, "ExpiryDate":{"display_name":"Expiry Date","value_getter":"getExpiryDate","is_date":true}, "EligibleReviewDate":{"display_name":"Eligible Review Date","value_getter":"getReviewDate","is_date":true}, "EligibleStatus":{"display_name":"Eligible Status","value_getter":"getStatus","is_date":false}, "Comments":{"display_name":"Comments","value_getter":"getNotes","is_date":false}}', @immigration_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_immigration, 1),
       ('EmergencyContacts.EmergencyContacts', 'Emergency Contacts', 'EmergencyContactsTokenValueGenerator', null, '{"Name":{"display_name":"Name","value_getter":"getName"},
        "Relationship":{"display_name":"Relationship","value_getter":"getRelationship"}, "HomeTelephone":{"display_name":"Home Telephone","value_getter":"getHomePhone"},"Mobile":{"display_name":"Mobile","value_getter":"getMobilePhone"}, "WorkTelephoneExtention":{"display_name":"Work Telephone/Extention","value_getter":"getOfficePhone"}}', @emergency_contacts_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_emergency_contacts, 1),
       ('Dependents.AssignedDependents', 'Dependents', 'DependentsTokenValueGenerator', null, '{"Name":{"display_name":"Name","value_getter":"getName"},
        "Relationship":{"display_name":"Relationship","value_getter":"getRelationshipType"}, "DateofBirth":{"display_name":"Date of Birth","value_getter":"getDateOfBirth", "is_date":true},"Nationality":{"display_name":"Nationality","value_getter":"getNationality,getName"}}', @dependents_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_dependents, 1),
       ('SocialMediaDetails.SocialMedia', 'Social Media', 'SocialMediaTokenValueGenerator', null, '{"Type":{"display_name":"Type","value_getter":"getSocialMediaType,getName"},
        "Handle":{"display_name":"Profile Name","value_getter":"getProfileName"}, "Link":{"display_name":"Profile Link","value_getter":"getProfileLink"},"AllowShareInPublic":{"display_name":"Allow share in public","value_getter":"getAllowShareAsString"}}', @social_media_datagroup_id, 0, 0,'avoidDefaultEncode=>true,type=>table,hasMultiple=>true',@token_section_social_media, 1);
