---------------------------------------------------------------------------------------------------------------------
--Ishit Tankaria(6th july 2021)
INSERT INTO `j1_statuses` (`id`, `status_key`, `status_name`, `category`) VALUES ('1012', 'skills-added', 'Skills Added', '1');
UPDATE `as_steps` SET `j1_status_id` = '1012' WHERE `as_steps`.`id` = 8;
-----------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani (7th july 2021)
UPDATE `as_steps` SET `j1_status_id` = '2005' WHERE `as_steps`.`as_order_key` = '3_contract_sponsor';
UPDATE `as_steps` SET `as_order_key` = '2_english_level_interview' WHERE `as_steps`.`as_order_key` = '3_english_level_interview';
UPDATE `as_steps` SET `j1_status_id` = '1012' WHERE `as_steps`.`as_order_key` = '3_english_level_interview';
UPDATE `as_steps` SET `j1_status_id` = '3017' WHERE `as_steps`.`as_order_key` = '2_contract_placement';
-----------------------------------------------------------------------------------------------------------------------
--Manisha Odedara (7th july 2021)
INSERT INTO `document_requirements` (`id`, `agency_id`, `document_type`, `document_desc`, `document_template`, `requirement_type`, `document_section`, `visibility`) VALUES
(NULL, 4, 55, 'requierment', '', 1, 1, 3);

DELETE FROM as_steps_by_dos WHERE step_id IN(34,35);
----------------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani (8th july 2021)
UPDATE `as_steps` SET `j1_status_id` = '1012' WHERE `as_steps`.`as_order_key` = '2_contract_placement';
UPDATE `as_steps` SET `j1_status_id` = '2001' WHERE `as_steps`.`as_order_key` = '2_english_level_interview';
UPDATE `as_steps` SET `j1_status_id` = '3017' WHERE `as_steps`.`as_order_key` = '2_supporting_documents';
----------------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani (09th july 2021)
DELETE FROM `as_steps_by_dos` WHERE `as_steps_by_dos`.`step_id` = 36;
DELETE FROM `as_steps_by_dos` WHERE `dos_program_category_id` = 3 AND `stage_id` = 2;
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES 
(NULL, 3, 8, 2, 1),
(NULL, 3, 9, 2, 3),
(NULL, 3, 10, 2, 4),
(NULL, 3, 11, 2, 5),
(NULL, 3, 12, 2, 6),
(NULL, 3, 36, 2, 2);
----------------------------------------------------------------------------------------------------------------------------
--Ishit Tankaria(12th july 2021)
ALTER TABLE `user_payment_ipn`  ADD `fee_type` INT(1) NULL DEFAULT NULL COMMENT '1=Registration)'  AFTER `transaction_id`;
----------------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani (14th july 2021)
INSERT INTO `notification_messages` (`id`, `notification_type_id`, `notification_type_key`, `notification_type_data`, `notification_text`, `notification_message`, `status`, `created_at`, `updated_at`) VALUES (NULL, '4', '2_english_level_interview_msg_1', '2_english_level_interview', 'Application Status: English Interview', 'Your English interview has been completed successfully', '1', '2019-07-22 13:00:00', '2020-09-09 07:26:00');
INSERT INTO `notification_messages` (`id`, `notification_type_id`, `notification_type_key`, `notification_type_data`, `notification_text`, `notification_message`, `status`, `created_at`, `updated_at`) VALUES (NULL, '4', '2_english_level_interview_msg_2', '2_english_level_interview', 'Application Status: English Interview', 'You are not eligible for the IMIX program', '1', '2019-07-22 13:00:00', '2020-09-09 07:25:52');
UPDATE `j1_statuses` SET `status_name` = 'English Level Interview Schedule' WHERE `j1_statuses`.`id` = 3017;
INSERT INTO `j1_statuses` (`id`, `status_key`, `status_name`, `category`) VALUES ('3018', 'english-interview-finished', 'English Interview Finished', '1');
UPDATE `as_steps` SET `j1_status_id` = '2001,3017' WHERE `as_steps`.`as_order_key` = '2_english_level_interview';
UPDATE `as_steps` SET `j1_status_id` = '3018,2001' WHERE `as_steps`.`as_order_key` = '2_supporting_documents';

ALTER TABLE `j1_interview` ADD `interview_confirmed_admin` INT(1) NOT NULL DEFAULT '0' COMMENT '1 = Yes, 2 = No' AFTER `interview_confirmed_hc`;
ALTER TABLE `j1_interview` ADD `admin_reject_reason` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `hc_reject_reason`;
ALTER TABLE `j1_interview` ADD `admin_alternate_datetime` DATETIME NULL DEFAULT NULL COMMENT ' Alternative date-time on schedule rejected by Admin' AFTER `hc_alternate_datetime`;
----------------------------------------------------------------------------------------------------------------------------
--Manisha Odedara (15th July 2021) 
ALTER TABLE `oauth_clients` ADD `provider` VARCHAR(244) NULL DEFAULT NULL AFTER `revoked`;
-----------------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani (21 july 2021)

UPDATE `email_notification` SET `text` = '<p>Dear Bridge USA program participant</p>\r\n\r\n<p>The Odyssey International Group has partnered with&nbsp;{{company}}&nbsp;Online to provide you Live update about your J-1 cultural exchange program</p>\r\n\r\n<p>Please click on the button below to accept the invitation from ODC International Group and the International Trainee Network.</p>\r\n\r\n<p>{{url}}</p>\r\n\r\n<p>Please don&rsquo;t hesitate to contact us at if you have any questions about the program,</p>' WHERE `email_notification`.`en_key` = 'send_invitation_to_user';
-----------------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani (26 july 2021)
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, 3, 33, 4, 6);
-----------------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani (26 july 2021)
UPDATE `email_notification` SET `text` = '<p>Dear {{ev_name}}</p>\r\n\r\n<p>Thank you for your interest in our J-1 Bridge USA exchange program: <strong>{{category_name}}</strong></p>\r\n\r\n<p>Please click the link below to create your personal applicant profile. You will use this profile throughout your journey to manage your program.</p>\r\n\r\n<p>{{url}}</p>\r\n\r\n<p>Thank you and we look forward to helping you on your upcoming journey to the United States!</p>' WHERE `email_notification`.`en_key` = 'send_invitation_to_user';
UPDATE `dos_program_category` SET program_category_name='Camp Counselor' WHERE `id` = 3;
-----------------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani (29 july 2021)
ALTER TABLE `user_details` ADD `current_university` INT(1) NOT NULL DEFAULT '0' COMMENT 'For DOC Program Category = 3' AFTER `field_studied`;
ALTER TABLE `user_details` CHANGE `current_university` `current_university` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '1 = Yes, 2 = No';

ALTER TABLE `j1_interview` ADD `no_of_camp_program` INT NULL DEFAULT '0' COMMENT 'For DOS Prog Cat = 3' AFTER `previous_us_visas`;
-----------------------------------------------------------------------------------------------------------------------------
--Manisha Odedara (2 September 2021)
INSERT INTO `system_settings` (`id`, `name`, `field`, `value`, `description`) VALUES
(NULL, 'CAMP Agreement Content', 'camp_itn_agreement_content', '<p><strong>Research Service Agreement &ndash; Camp Counselor </strong></p>\r\n\r\n<div>\r\n<p><strong>THIS AGREEMENT </strong>is made the {DAY}&nbsp;of {MONTH} {YEAR} by and between {EV_NAME}, hereinafter called the &lsquo;Candidate&rsquo;, and International Trainee Network, hereinafter called the &lsquo;Service Provider&rsquo;.</p>\r\n</div>\r\n\r\n<p>The Candidate understands that the Service Provider is primarily a research company specialized in helping international students and young professionals&nbsp; consolidate their careers by finding them a Host Company under&nbsp; the Visitor Exchange Program. The program provides on-the-job exposure to American techniques, methodologies and expertise and enhances the Candidate&rsquo;s knowledge of American society and culture. Moreover, Service&nbsp; Provider is engaged in researching and providing opportunities for post-secondary students, youth workers and teachers in the Visitor Exchange Camp Counselor Program, so they can share their culture and ideas with&nbsp; the&nbsp; people of the United States in camp settings throughout the country.</p>\r\n\r\n<p>WITNESSETH, that the Candidate and the Service Provider for the considerations named agree as follows:</p>\r\n\r\n<h4><strong>ARTICLE 1.&nbsp;&nbsp;&nbsp; THE CAMP COUNSELOR PROGRAM</strong></h4>\r\n\r\n<p>The Camp Counselor Program enables post-secondary students, youth workers, and teachers&nbsp; to&nbsp; share&nbsp; their&nbsp; culture and ideas with the people of the United States in camp settings throughout the country. The participants&nbsp; are placed in camp counselor positions to essentially supervise&nbsp; camp&nbsp; activities and develop recreational plans.&nbsp; They generally work with children in residential summer camps or day camps. Their job duties include guiding teenagers and children in camping, swimming, hiking and other outdoor pursuits. Counselors may&nbsp; organize&nbsp; camping trips, plan and schedule group activities, provide emotional support, greet new campers,&nbsp; and explain all the rules of the camp.</p>\r\n\r\n<p>Other job responsibilities of camp counselors include the health and safety of their charges,&nbsp; and&nbsp; they&nbsp; lead&nbsp; campers in fire drills and emergency procedures. Camp counselors should also be prepared to work night and weekend hours, because supervision of the campers is also needed during these times.</p>\r\n\r\n<h4><strong>ARTICLE 2.&nbsp;&nbsp;&nbsp; SCOPE OF THE SERVICES</strong></h4>\r\n\r\n<ol>\r\n	<li><u>Provider&rsquo;s Services</u>. The Service Provider will:\r\n\r\n	<ol>\r\n		<li>Evaluate and determine the Candidate&rsquo;s eligibility for the Camp Counselor Program .</li>\r\n		<li>Evaluate the Candidate&rsquo;s English level.</li>\r\n		<li>Send the application package to be fully completed by the Candidate.</li>\r\n		<li>Reformat the Candidate&rsquo;s resume to the American standard.</li>\r\n		<li>Arrange interviews with potential host companies, as required.</li>\r\n		<li>Prepare the Candidate for the interviews with potential host companies.</li>\r\n		<li>Negotiate the conditions for the duration of the program: pay and benefits, means of transportation and housing, if provided by the Host Company.</li>\r\n		<li>Prepare the Job Offer according to the Host Company&rsquo;s specifications.</li>\r\n		<li>Assist the Candidate upon arrival by providing the &ldquo;Candidate Arrival Guidebook&rdquo; with information</li>\r\n		<li>Monitor Candidate throughout their stay and provide assistance as needed.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<div>\r\n	<p>&nbsp;<u>Research of Host Company</u>. The Service Provider will use its best effort to find&nbsp; host&nbsp; company&nbsp; placement for the Candidate within twelve (12) weeks of receipt of the required documents and the non-refundable registration fee as described in Article 5 of this agreement.&nbsp;</p>\r\n\r\n	<p>&nbsp;</p>\r\n\r\n	<ol>\r\n		<li><u>Processing Time</u>. The Service Provider will issue a Job Offer after the Candidate has:\r\n\r\n		<ol>\r\n			<li>been accepted by the Host Company;</li>\r\n			<li>provided all necessary documents requested by the Service Provider; and</li>\r\n			<li>paid in full the Program fees as described in Article 5 below.</li>\r\n		</ol>\r\n		</li>\r\n	</ol>\r\n\r\n	<h4><strong>ARTICLE 3. CANDIDATE&rsquo;S OBLIGATIONS AND RESPONSIBILITIES</strong></h4>\r\n	</div>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li><u>Candidate&rsquo;s Obligations</u>. The Candidate agrees:\r\n		<ol>\r\n			<li>To comply with all academic and/or work experience requirements and submit to the Service Provider the corresponding supporting documents.</li>\r\n			<li>To attend all interviews, including telephonic or Skype interviews, at the pre-arranged time organized by&nbsp; the Service Provider.</li>\r\n			<li>To not decline more than two (2) interviews with potential Host Companies.</li>\r\n			<li>The Candidate understands that he/she&nbsp; needs to do research about the Host&nbsp; Company&nbsp; before accepting an interview. Once the Candidate has accepted to interview with a Host Company, he/she has to accept&nbsp;&nbsp; the position if the interview is successful. Declining of the offer and the position after a&nbsp; successful&nbsp; interview will be subject to an administrative fee as described in Article 6 of this agreement.</li>\r\n			<li>To provide all necessary/requested authentic/truthful documentation in a timely manner.</li>\r\n			<li>To submit payment of the program fees in a timely manner (The due date will be&nbsp; indicated&nbsp; on&nbsp; the payment invoice).</li>\r\n			<li>To secure his/her housing before arrival in the United States unless provided by the Host Company for the duration of the stay in the USA.</li>\r\n			<li>To observe and respect the American culture and comply with all laws and regulations of&nbsp; the&nbsp; USA&nbsp; (included but not limited to all laws in relation to the Exchange Visitor Program) as well as the Host Company&rsquo;s internal regulations.</li>\r\n			<li>To perform his/her duties during the program, as described in Article 1 of this agreement, at a&nbsp; high standard and with all due skills, care and attention consistent with the level of the knowledge, experience&nbsp; or education which the Candidate has represented to the Service Provider and the Host Company</li>\r\n		</ol>\r\n		</li>\r\n	</ol>\r\n	</li>\r\n</ol>\r\n\r\n<ol>\r\n	<li>\r\n	<ol>\r\n		<li><u>Candidate&rsquo;s Responsibilities</u>. The Candidate is responsible and liable for:\r\n\r\n		<ol>\r\n			<li>All transportation costs to, from and within the USA.</li>\r\n			<li>All of his/her living expenses such as food, transportation and housing unless provided by the Host&nbsp; Company for the duration of the stay in the USA.</li>\r\n			<li>All medical expenses and bills that are outside the coverage of the medical insurance.</li>\r\n			<li>Reading all emails, documents, agreements, informational handouts and guidebooks provided to the Candidate by the Service Provider</li>\r\n		</ol>\r\n		</li>\r\n	</ol>\r\n	</li>\r\n</ol>\r\n\r\n<h4><strong>ARTICLE 4.&nbsp;&nbsp;&nbsp; TERMS OF THE AGREEMENT</strong></h4>\r\n\r\n<p>4.1 <u>Commencement of the Agreement</u>. This Agreement will commence when the Service Provider receives from&nbsp;the Candidate a complete application package and full payment of the registration fees as described in Article 4 below.</p>\r\n\r\n<p>4.2. <u>Termination of the Agreement</u>. This Agreement will end on the program termination date or as otherwise terminated in accordance with the p ovisions of this Agreement.</p>\r\n\r\n<h4><strong>ARTICLE 5.&nbsp;&nbsp;&nbsp; FEES</strong></h4>\r\n\r\n<p>5.1. <u>Fee Structure</u>. The fee structure is as follows:</p>\r\n\r\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"width:500px\">\r\n	<tbody>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td><strong>Description</strong></td>\r\n			<td><strong>Amount</strong></td>\r\n		</tr>\r\n		<tr>\r\n			<td><strong>Registration Fee</strong></td>\r\n			<td>\r\n			<p>Non-refundable and non-applicable to the Program Fee. Due after program eligibility is confirmed and before interviews will be arranged with camps. Covers the Service Provider&rsquo;s administrative costs to start</p>\r\n			the research for a Host Company on behalf of the Candidate.</td>\r\n			<td>\r\n			<p>{REG_FEE} {CURRENCY}</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td><strong>Program Fee</strong></td>\r\n			<td>\r\n			<p>The Program Fee covers all services outlined in section 2.1 of this</p>\r\n			agreement.</td>\r\n			<td>{PROG_FEE} {CURRENCY}</td>\r\n		</tr>\r\n		<tr>\r\n			<td><strong>SEVIS Fee</strong></td>\r\n			<td>\r\n			<p>Mandatory fee to create and maintain a unique exchange visitor profile&nbsp;&nbsp; in the SEVIS database. SEVIS fees are collected by Odyssey and are paid</p>\r\n			to the US government.</td>\r\n			<td>\r\n			<p>{SEVIS_FEE}{CURRENCY}</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ol>\r\n	<li>\r\n	<ol>\r\n		<li><u>Additional Costs.</u> Applicants will be responsible for the following:\r\n\r\n		<ol>\r\n			<li>Embassy Fees: {CURRENCY_SYMBOL}160.00 &ndash; Mandatory fees to reserve a visa appointment at the U.S. Embassy. Fees paid directly to U.S. government at time of visa interview reservation.</li>\r\n			<li>Transportation costs, including all flights and airport transfers.</li>\r\n			<li>Costs associated with participating in the program not included in section 2.1 of this agreement.</li>\r\n		</ol>\r\n		</li>\r\n	</ol>\r\n	</li>\r\n</ol>\r\n\r\n<p><strong>&nbsp;ARTICLE 6.&nbsp;&nbsp;&nbsp; REFUND POLICY</strong></p>\r\n\r\n<div>\r\n<ol>\r\n	<li>\r\n	<ol>\r\n		<li><u>Registration Fee.</u> Applicants enrolling in Odyssey&rsquo;s All-Inclusive program are required to pay a {CURRENCY_SYMBOL}{REG_FEE}&nbsp;registration fee before Odyssey begins the process of matching them to a prospective host. Registration fees are non-refundable.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li><u>Withdrawal After Placement is Confirmed.</u> If the Candidate cancels the placement or withdraws from the program due to any reason after a successful interview with the Host Company and receipt of the notification that confirms his/her Placement, the Candidate will be entitled to a&nbsp; refund of the&nbsp; program&nbsp; fee minus&nbsp; {PROG_FEE_TEXT} {CURRENCY_SYMBOL_NAME} &nbsp; ( {PROG_FEE} {CURRENCY}) which will be withheld and account for the administrative fees of ITN. If&nbsp; the Candidate fails to satisfy the Pre-arrival Liabilities and/or if the Candidate is unable&nbsp; to continue the program&nbsp; due to any academic reason, such as course failure, attributable to the Candidate, it shall be deemed as a withdrawal by&nbsp; the Candidate and the administrative fees will&nbsp; be billed. The refund will&nbsp; be processed within 30&nbsp; days after receipt of the refund request.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li><u>Withdrawal After Placement is Confirmed due to COVID-19.</u> If the Candidate cancels the placement or withdraws from the program due to COVID-19 after a successful interview with the Host Company and receipt of&nbsp; the notification that confirms his/her Placement, the Candidate will not be entitled to any refund. The Candidate&nbsp; will be re-placed at a new Host Company based on his/her preferences and eligibility requirements.</li>\r\n	</ol>\r\n	</li>\r\n</ol>\r\n</div>\r\n\r\n<div>\r\n<ol>\r\n	<li>\r\n	<ol>\r\n		<li><u>Withdrawal After Issuance of SEVIS number.</u> If the Candidate cancels the placement or withdraws from the program due to any reason after the issuance of the SEVIS number, the Candidate will not be&nbsp; entitled to any&nbsp; refund. If the Candidate fails to satisfy the Pre-arrival Liabilities and/or if the Candidate is unable to continue the program due to any academic reasons, such as course failure, attributable to the Candidate, it shall be deemed as&nbsp;&nbsp;&nbsp; a withdrawal by the Candidate.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li><u>Withdrawal After Issuance of SEVIS number due to COVID-19.</u> If the Candidate cancels the placement or withdraws from the program due to COVID-19 after the issuance of the SEVIS number, the Candidate will not be entitled to any refund. The Candidate will be re-placed at a new Host Company based on his/her preferences and eligibility requirements.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li><u>Embassy/Consulate Denial.</u> In case of a visa denial at the US Embassy, the Candidate must inform ITN within 3</li>\r\n	</ol>\r\n	</li>\r\n</ol>\r\n\r\n<p>business days of denial and return the original Form DS-2019 and proof of denial fr m the Embassy or Consulate</p>\r\n\r\n<p>within 10 Business Days from the date of denial in order to be eligible for refunds. The Candidate will be entitled&nbsp;&nbsp;&nbsp;&nbsp; to a refund of the program fee minus Two Hundred and Twenty Five {CURRENCY_SYMBOL_NAME} ({PROG_FEE} {CURRENCY}) which will&nbsp; be withheld; and account for the administrative fees. The refund will be processed within 30 days after receipt of the refund request. No refund will be issued if the documents are returned after the 10 Business Days deadline or if&nbsp;&nbsp;&nbsp; the documents are not returned to OIC.</p>\r\n\r\n<ol>\r\n	<li>\r\n	<ol>\r\n		<li><u>Cancellation by the Host Company.</u> If the Host Company cancels the placement or withdraws&nbsp; from&nbsp; the&nbsp; program prior to the start date of the Candidate&rsquo;s program stated on the Job Offer, ITN will, to its best efforts, try&nbsp;&nbsp; to relocate the Candidate with another Host Company. If the Candidate declines another interview with potential Host Companies for a re-placement or withdraws from the program after accepted for a&nbsp; re-placement&nbsp; with&nbsp; another Host Company, the Candidate will be entitled to a refund of the program fee minus Two Hundred and Twenty Five {CURRENCY_SYMBOL_NAME} ({PROG_FEE} {CURRENCY}) which will be withheld and account for the administrative costs of OIC. The refund will be processed within 30 days after receipt of the refund request.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li><u>Cancellation by the Host Company due to COVID-19.</u> If the Host Company cancels the placement or withdraws from the program prior to the program start date for any reasons related to COVID-19, no refunds will be issued. Candidate may retain their fees as a credit towards another&nbsp; program. ITN will attempt to re-place the Candidate&nbsp;&nbsp;&nbsp; at a new Host Company based on his/her preferences and eligibility requirements.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li><u>Cancellation After Arrival in the United States.</u> If the Candidate withdraws from the program or is unable to continue the program due to any reason after arrival in the US or if the Candidate is laid off or fired by the Host Company, the Candidate will not be entitled to any refund.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li><u>Refusal of Interviews.</u> If the Candidate refuses to interview with 2 or more potential Host Companies within&nbsp; the field of his preferences, the Candidate will be terminated from the program.</li>\r\n	</ol>\r\n	</li>\r\n</ol>\r\n\r\n<h4><strong>ARTICLE 7.&nbsp;&nbsp;&nbsp; OTHER TERMS</strong></h4>\r\n\r\n<ol>\r\n	<li>\r\n	<ol>\r\n		<li>The Candidate understands that the Service Provider may cancel his/her application if the Service Provider determines that the Candidate fails to pass the eligibility requirements based on the rules and regulations by the Service Provider and/or the Program Sponsor.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li>The length of the program agreed upon by the Host Company and the Candidate shall be contingent on the Candidate&rsquo;s performance as reviewed by the Host Company, and does not bind the Host Company to the full</li>\r\n	</ol>\r\n	</li>\r\n</ol>\r\n</div>\r\n\r\n<p>duration if the Candidate does not meet the Host Company professional requirements&nbsp; or&nbsp; standards.&nbsp; The&nbsp; Candidate understands that if the Host Company determines that the Candidate does not perform his/her duties properly and/or the Candidate does not comply strictly with the regulations, the Host Company has the right to terminate or fire the Candidate. In which case, the Candidate will not be entitled to receive any refund.</p>\r\n\r\n<ol>\r\n	<li>\r\n	<ol>\r\n		<li>If the Host Company goes out of business, files for bankruptcy, shuts down for any reason,&nbsp; or terminates or&nbsp; lays off the Candidate for lack of commercial activity, the&nbsp; Service Provider will&nbsp; assist&nbsp; the candidate in&nbsp; finding&nbsp; a new Host Company; however, the Service Provider cannot guarantee that a suitable new Host Company will be found within a reasonable time with due consideration of the full program duration and/or validity of the J1 Visa.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li>Candidate agrees&nbsp; to indemnify and hold harmless ITN, its&nbsp; officers and directors, employees and its affiliates&nbsp; and their respective successors and assigns and each other person, if any, who controls any thereof, against any&nbsp; loss, liability, claim, damage and expense whatsoever (including, but not limited to, any and all&nbsp; expenses whatsoever reasonably incurred in investigating, preparing, or defending against any litigation commenced or threatened or any claim whatsoever) arising out of or resulting from, or in connection with the services contemplated by this agreement.</li>\r\n	</ol>\r\n	</li>\r\n	<li>\r\n	<ol>\r\n		<li>The Candidate confirms that he/she is fit to participate in the Camp Counselor Program both physically and mentally, and understands that the experience can be stressful and may requi e participants to&nbsp; engage&nbsp; in&nbsp; physically strenuous activities. All pre-existing medical conditions must be made known to the Service Provider in writing at the time of application. Accommodations will be made whenever possible to allow applications from Candidates with non-serious medical conditions.</li>\r\n	</ol>\r\n	</li>\r\n</ol>\r\n\r\n<p>The Candidate understands the medical insurance provider does not cover pre-existing medical conditions and if&nbsp; the Candidate requires medical treatment for pre-existing conditions after arrival in the Unites States, the&nbsp; Candidate will be responsible for all charges and fees related to treatment.</p>\r\n\r\n<p>If the Candidate has any physical or mental condition which could affect your ability to participate in the program, please disclose it here:</p>', 'CAMP Agreement Content');

INSERT INTO `menu_items` (`id`, `permission_group_id`, `permission_id`, `parent_id`, `title`, `route_name`, `menu_item_order`, `created_at`, `updated_at`) VALUES
(NULL, 2, 218, 0, 'Manage Agreement', 'agreement', 1, '2021-07-29 05:00:21', '2021-07-29 05:00:21');
INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES
(217, NULL, 2, 'agreement.edit', 'Manage agreement', 'Manage Agreement access permission', 'agreement.edit', 0),
(218, NULL, 2, 'agreement', 'Agreement', 'Manage Agreement access permission', 'agreement', 1);
-------------------------------------------------------------------------------------------------------------------------------------
--Manisha Odedara (7 September 2021)
UPDATE system_settings 
SET value = '<h3 style="text-align:center;"><span style="background-color:hsl(0,0%,100%);"><strong>Research Service Agreement – Camp Counselor</strong></span></h3><p style="text-align:center;"> </p><p><strong>THIS AGREEMENT </strong>is made the {DAY}&nbsp;of {MONTH} {YEAR} by and between {EV_NAME}, hereinafter called the ‘Candidate’, and International Trainee Network hereinafter called the ‘Service Provider’.</p><p>The Candidate understands that the Service Provider is primarily a research company specialized in helping international students and young professionals consolidate their careers by finding them a Host Company under the Visitor Exchange Program. The program provides on-the-job exposure to American techniques, methodologies, and expertise and enhances the Candidate’s knowledge of American society and culture. Moreover, Service&nbsp;Provider is engaged in researching and providing opportunities for post-secondary students, youth workers, and teachers in the Visitor Exchange Camp Counselor Program, so they can share their culture and ideas with the&nbsp;people of the United States in camp settings throughout the country.</p><p>WITNESSETH, that the Candidate and the Service Provider for the considerations named agree as follows:</p><p> </p><p> </p><h4 style="text-align:center;"><strong>ARTICLE 1.&nbsp;&nbsp;&nbsp; THE CAMP COUNSELOR PROGRAM</strong></h4><p>The Camp Counselor Program enables post-secondary students, youth workers, and teachers to&nbsp;share&nbsp;their&nbsp;culture and ideas with the people of the United States in camp settings throughout the country. The participants&nbsp;are placed in camp counselor positions to essentially supervise&nbsp;camp&nbsp;activities and develop recreational plans.&nbsp;They generally work with children in residential summer camps or day camps. Their job duties include guiding teenagers and children in camping, swimming, hiking, and other outdoor pursuits. Counselors may&nbsp;organize camping trips, plan and schedule group activities, provide emotional support, greet new campers,&nbsp;and explain all the rules of the camp.</p><p>Other job responsibilities of camp counselors include the health and safety of their charges, and they&nbsp;lead&nbsp;campers in fire drills and emergency procedures. Camp counselors should also be prepared to work night and weekend hours because supervision of the campers is also needed during these times.</p><p> </p><h4 style="text-align:center;"><strong>ARTICLE 2.&nbsp;&nbsp;&nbsp; SCOPE OF THE SERVICES</strong></h4><ol style="list-style-type:decimal;"><li><strong><u>Provider’s Services</u>. </strong>The Service Provider&nbsp;will:<ol style="list-style-type:lower-alpha;"><li>Evaluate and determine the Candidate’s eligibility for the Camp Counselor Program.</li><li>Evaluate the Candidate’s English&nbsp;level.</li><li>Send the application package to be fully completed by the&nbsp;Candidate.</li><li>Reformat the Candidate’s resume to the American&nbsp;standard.</li><li>Arrange interviews with potential host companies, as&nbsp;required.</li><li>Prepare the Candidate for the interviews with potential host&nbsp;companies.</li><li>Negotiate the conditions for the duration of the program: pay and benefits, means of transportation, and housing, if provided by the Host&nbsp;Company.</li><li>Prepare the Job Offer according to the Host Company’s&nbsp;specifications.</li><li>Assist&nbsp;the&nbsp;Candidate&nbsp;upon arrival by providing the "Candidate Arrival Guidebook" with information regarding housing, Social Security, bank account, etc.</li><li>Provide Candidates, prior to departure for the United States, with information on their duties&nbsp;and responsibilities as a camp counselor, contractual obligations relative to accepting a camp&nbsp;counselor position.</li><li>To provide medical insurance for the duration of the&nbsp;program.</li><li>Monitor Candidate throughout their stay and provide assistance as&nbsp;needed</li></ol></li><li style="text-align:justify;"><strong><u>Research of Host Company</u>.</strong> The Service Provider will use its best effort to find host&nbsp;company&nbsp;placement for the Candidate within twelve (12) weeks of receipt of the required documents and the non-refundable registration fee as described in Article 5 of this&nbsp;agreement.</li><li><strong><u>Processing Time</u>. </strong>The Service Provider will issue a Job Offer after the Candidate&nbsp;has:<ol style="list-style-type:lower-alpha;"><li>been accepted by&nbsp;the Host&nbsp;Company;</li><li>provided all necessary documents requested by the Service Provider;&nbsp;and</li><li>paid in full the Program fees as described in Article 5&nbsp;below.</li></ol></li></ol><p> </p><p> </p><h4 style="text-align:center;"><strong>ARTICLE 3. CANDIDATE’S OBLIGATIONS AND RESPONSIBILITIES</strong></h4><ol><li><strong><u>Candidate’s Obligations</u>.</strong> The Candidate agrees:<ol style="list-style-type:lower-latin;"><li>To comply with all academic and/or work experience requirements and submit to the Service Provider the corresponding supporting documents.</li><li>To attend all interviews, including telephonic or Skype interviews, at the pre-arranged time organized by the Service Provider.</li><li>To not decline more than two (2) interviews with potential Host Companies.</li><li>The Candidate understands that he/she needs to do research about the Host&nbsp;Company before accepting an interview. Once the Candidate has accepted to interview with a Host Company, he/she has to accept the position if the interview is successful. Declining of the offer and the position after a successful interview will be subject to an administrative fee as described in Article 6 of this agreement.</li><li>To provide all necessary/requested authentic/truthful documentation in a timely manner.</li><li>To submit payment of the program fees in a timely manner (The due date will be indicated&nbsp;on&nbsp;the payment invoice).</li><li>To secure his/her housing before arrival in the United States unless provided by the Host Company for the duration of the stay in the USA.</li><li>To observe and respect the American culture and comply with all laws and regulations of the&nbsp;USA&nbsp;(included but not limited to all laws in relation to the Exchange Visitor Program) as well as the Host Company’s internal regulations.</li><li>To perform his/her duties during the program, as described in Article 1 of this agreement, at a&nbsp;high standard and with all due skills, care, and attention consistent with the level of the knowledge, experience, or education which the Candidate has represented to the Service Provider and the Host Company</li></ol></li><li><strong><u>Candidate’s Responsibilities</u>. </strong>The Candidate is responsible and liable for:<ol style="list-style-type:lower-latin;"><li>All transportation costs too, from and within the USA.</li><li>All of his/her living expenses such as food, transportation, and housing unless provided by the Host Company for the duration of the stay in the USA.</li><li>All medical expenses and bills that are outside the coverage of the medical insurance.</li><li>Reading all emails, documents, agreements, informational handouts, and guidebooks provided to the Candidate by the Service Provider</li></ol></li></ol><p> </p><p> </p><h4 style="text-align:center;"><strong>ARTICLE 4.&nbsp;&nbsp;&nbsp; TERMS OF THE AGREEMENT</strong></h4><ol style="list-style-type:decimal;"><li><strong><u>Commencement of the Agreement</u>.</strong> This Agreement will commence when the Service Provider receives from&nbsp;the Candidate a complete application package and full payment of the registration fees as described in Article 5 below.</li><li><strong><u>Termination of the Agreement</u>. </strong><span style="color:black;">This Agreement will end on the program termination date or as otherwise terminated in accordance with the provisions of this Agreement.</span></li></ol><p> </p><p> </p><h4 style="text-align:center;"><strong>ARTICLE 5.&nbsp;&nbsp;&nbsp; FEES</strong></h4><ol style="list-style-type:decimal;"><li><strong><u>Fee Structure</u>. </strong>The fee structure is as follows:</li></ol><figure class="table"><table><tbody><tr><td><br> </td><td><strong>Description</strong></td><td><strong>Amount</strong></td></tr><tr><td><strong>Registration Fee</strong></td><td><p>Non-refundable and non-applicable to the Program Fee. Due after program eligibility is confirmed and before interviews will be arranged with camps. Covers the Service Provider’s administrative costs to start</p><p>the research for a Host Company on behalf of the Candidate.</p></td><td>{REG_FEE} {CURRENCY}</td></tr><tr><td><strong>Program Fee</strong></td><td><p>The Program Fee covers all services outlined in section 2.1 of this</p><p>agreement.</p></td><td>{PROG_FEE} {CURRENCY}</td></tr><tr><td><strong>SEVIS Fee</strong></td><td><p>The mandatory fee to create and maintain a unique exchange visitor profile in the SEVIS database. SEVIS fees are collected by Odyssey and are paid</p><p>to the US government.</p></td><td>{SEVIS_FEE}{CURRENCY}</td></tr></tbody></table></figure><p> </p><p>2. <strong><u>Additional Costs.</u></strong> Applicants will be responsible for the following:</p><ol style="list-style-type:lower-latin;"><li>Embassy Fees: {CURRENCY_SYMBOL}160.00 – Mandatory fees to reserve a visa appointment at the U.S. Embassy. Fees paid directly to the U.S. government at the time of visa interview reservation.</li><li>Transportation costs, including all flights and airport transfers.</li><li>Costs associated with participating in the program are not included in section 2.1 of this agreement.</li></ol><p> </p><p> </p><h4 style="text-align:center;"><strong>ARTICLE 6.&nbsp;&nbsp;&nbsp; REFUND POLICY</strong></h4><ol style="list-style-type:decimal;"><li><strong><u>Registration Fee</u></strong><u>.</u> Applicants enrolling in Odyssey’s All-Inclusive program are required to pay a {CURRENCY_SYMBOL}{REG_FEE}&nbsp;registration fee before Odyssey begins the process of matching them to a prospective host. Registration fees are non-refundable.</li><li><strong><u>Withdrawal After Placement is Confirmed.</u> </strong>If the Candidate cancels the placement or withdraws from the program due to any reason after a successful interview with the Host Company and receipt of the notification that confirms his/her Placement, the Candidate will be entitled to a refund of the&nbsp;program&nbsp;fee minus&nbsp;<span style="color:black;">Two Hundred and Twenty Five </span>{CURRENCY_SYMBOL_NAME} ( <span style="color:black;">225.00 </span>{CURRENCY}) which will be withheld and account for the administrative fees of ITN. If&nbsp;the candidate fails to satisfy the Pre-arrival Liabilities and/or if the Candidate is unable to continue the program due to any academic reason, such as course failure, attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate and the administrative fees will&nbsp;be billed. The refund will be processed within 30 days after receipt of the refund request.</li><li><strong><u>Withdrawal After Placement is Confirmed due to COVID-19.</u> </strong>If the Candidate cancels the placement or withdraws from the program due to COVID-19 after a successful interview with the Host Company and receipt of&nbsp;the notification that confirms his/her Placement, the Candidate will not be entitled to any refund. The Candidate&nbsp;will be replaced at a new Host Company based on his/her preferences and eligibility requirements.</li><li><strong><u>Withdrawal After Issuance of SEVIS number.</u></strong> If the Candidate cancels the placement or withdraws from the program due to any reason after the issuance of the SEVIS number, the Candidate will not be&nbsp;entitled to any refund. If the candidate fails to satisfy the Pre-arrival Liabilities and/or if the Candidate is unable to continue the program due to any academic reasons, such as course failure, attributable to the Candidate, it shall be deemed as&nbsp;a withdrawal by the Candidate.</li><li><strong><u>Withdrawal After Issuance of SEVIS number due to COVID-19</u></strong><u>.</u> If the Candidate cancels the placement or withdraws from the program due to COVID-19 after the issuance of the SEVIS number, the Candidate will not be entitled to any refund. The Candidate will be replaced at a new Host Company based on his/her preferences and eligibility requirements.</li><li><strong><u>Embassy/Consulate Denial</u></strong><u>.</u> In case of a visa denial at the US Embassy, the Candidate must inform ITN within 3 business days of denial and return the original Form DS-2019 and proof of denial from the Embassy or Consulate within 10 Business Days from the date of denial in order to be eligible for refunds. The Candidate will be entitled&nbsp;to a refund of the program fee minus Two Hundred and Twenty Five {CURRENCY_SYMBOL_NAME} ( <span style="color:black;">225.00&nbsp;</span>{CURRENCY}) which will be withheld, and account for the administrative fees. The refund will be processed within 30 days after receipt of the refund request. No refund will be issued if the documents are returned after the 10 Business Days deadline or if the documents are not returned to OIC.</li><li><strong><u>Cancellation by the Host Company.</u> </strong>If the Host Company cancels the placement or withdraws from&nbsp;the&nbsp;program prior to the start date of the Candidate’s program stated on the Job Offer, ITN will, to its best efforts, try&nbsp;to relocate the Candidate to another Host Company. If the Candidate declines another interview with potential Host Companies for a re-placement or withdraws from the program after being accepted for a&nbsp;replacement&nbsp;with another Host Company, the Candidate will be entitled to a refund of the program fee minus Two Hundred and Twenty Five {CURRENCY_SYMBOL_NAME} (<span style="color:black;">225.00</span> {CURRENCY}) which will be withheld and account for the administrative costs of OIC. The refund will be processed within 30 days after receipt of the refund request.</li><li><strong><u>Cancellation by the Host Company due to COVID-19.</u></strong> If the Host Company cancels the placement or withdraws from the program prior to the program start date for any reasons related to COVID-19, no refunds will be issued. Candidate may retain their fees as a credit towards another&nbsp;program. ITN will attempt to re-place the Candidate&nbsp;at a new Host Company based on his/her preferences and eligibility requirements.</li><li><strong><u>Cancellation After Arrival in the United States.</u></strong> If the candidate withdraws from the program or is unable to continue the program due to any reason after arrival in the US or if the Candidate is laid off or fired by the Host Company, the Candidate will not be entitled to any refund.</li><li><strong><u>Refusal of Interviews.</u></strong> If the Candidate refuses to interview with 2 or more potential Host Companies within the field of his preferences, the Candidate will be terminated from the program.</li></ol><p> </p><h4 style="text-align:center;"><strong>ARTICLE 7.&nbsp;&nbsp;&nbsp; OTHER TERMS</strong></h4><ol style="list-style-type:decimal;"><li>The Candidate understands that the Service Provider may cancel his/her application if the Service Provider determines that the candidate fails to pass the eligibility requirements based on the rules and regulations by the Service Provider and/or the Program Sponsor.</li><li>The length of the program agreed upon by the Host Company and the Candidate shall be contingent on the Candidate’s performance as reviewed by the Host Company and does not bind the Host Company to the full duration if the Candidate does not meet the Host Company professional requirements&nbsp;or&nbsp;standards.&nbsp;The Candidate understands that if the Host Company determines that the Candidate does not perform his/her duties properly and/or the Candidate does not comply strictly with the regulations, the Host Company has the right to terminate or fire the Candidate. In which case, the Candidate will not be entitled to receive any refund.</li><li>If the Host Company goes out of business, files for bankruptcy, shuts down for any reason,&nbsp;or terminates or&nbsp;lays off the Candidate for lack of commercial activity, the&nbsp;Service Provider will&nbsp;assist&nbsp;the candidate in finding&nbsp;a new Host Company; however, the Service Provider cannot guarantee that a suitable new Host Company will be found within a reasonable time with due consideration of the full program duration and/or validity of the J1 Visa.</li><li>Candidate agrees to indemnify and hold harmless ITN, its&nbsp;officers and directors, employees and its affiliates&nbsp;and their respective successors and assigns and each other person, if any, who controls any thereof, against any loss, liability, claim damage, and expense whatsoever (including, but not limited to, any and all expenses whatsoever reasonably incurred in investigating, preparing, or defending against any litigation commenced or threatened or any claim whatsoever) arising out of or resulting from, or in connection with the services contemplated by this agreement.</li><li>The Candidate confirms that he/she is fit to participate in the Camp Counselor Program both physically and mentally, and understands that the experience can be stressful and may require participants to&nbsp;engage in&nbsp;physically strenuous activities. All pre-existing medical conditions must be made known to the Service Provider in writing at the time of application. Accommodations will be made whenever possible to allow applications from Candidates with non-serious medical conditions.</li></ol><p> </p><p> </p><p>The Candidate understands the medical insurance provider does not cover pre-existing medical conditions and if&nbsp;the Candidate requires medical treatment for pre-existing conditions after arrival in the UnitedUnited States, the&nbsp;Candidate will be responsible for all charges and fees related to treatment.</p><p><strong>If the Candidate has any physical or mental condition which could affect your ability to participate in the program, please disclose it here:</strong></p><p>{ANS}</p>' WHERE field = 'camp_itn_agreement_content';
-------------------------------------------------------------------------------------------------------------------------------------------
--Chandresh Kukadiya(09 September 2021)
INSERT INTO `j1_statuses` (`id`, `status_key`, `status_name`, `category`) VALUES ('1013', 'short-introduction-added', 'Short Introduction Added', '1');
INSERT INTO `as_steps` (`id`, `as_order_key`, `as_title`, `as_icon`, `as_desc_before`, `as_desc_current`, `as_desc_after`, `j1_status_id`) VALUES (NULL, '1_short_introduction', 'Short Video Introduction', 'fa-youtube-play', 'Add the YouTube URL link of the short video about yourself.', 'Add the YouTube URL link of the short video about yourself.', 'Add the YouTube URL link of the short video about yourself.', '1012');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, '3', '39', '1', '10');
ALTER TABLE `user_details` ADD `short_introduction` VARCHAR(255) NULL AFTER `additional_photo`;
ALTER TABLE `user_details` ADD `short_introduction_status` enum('0','1','2') NOT NULL DEFAULT '0' COMMENT '0 =  pending , 1 => approved, 2=> rejected' AFTER `short_introduction`;
ALTER TABLE `user_details` ADD `short_introduction_reject_reason` text NULL AFTER `short_introduction_status`;
INSERT INTO `notification_messages` (`id`, `notification_type_id`, `notification_type_key`, `notification_type_data`, `notification_text`, `notification_message`, `status`, `created_at`, `updated_at`) VALUES (NULL, '4', '1_short_introduction_1', '1_short_introduction', 'Application Status: Short Video Introduction', 'Your YouTube video link has been approved.', '1', current_timestamp(), NULL);
INSERT INTO `notification_messages` (`id`, `notification_type_id`, `notification_type_key`, `notification_type_data`, `notification_text`, `notification_message`, `status`, `created_at`, `updated_at`) VALUES (NULL, '4', '1_short_introduction_2', '1_short_introduction', 'Application Status: Short Video Introduction', 'Your YouTube video link has been rejected.', '1', current_timestamp(), NULL);
-----------------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani(17 September 2021)
ALTER TABLE `portfolio` ADD `itn_reg_admin_type` INT(11) NOT NULL DEFAULT '0' AFTER `dos_program_category_id`;
ALTER TABLE `portfolio` ADD `itn_reg_admin_category` INT(11) NOT NULL DEFAULT '0' COMMENT 'Ref key of ITNDB admin_category table >> admin_cat_id column' AFTER `itn_reg_admin_type`;
ALTER TABLE `portfolio` CHANGE `itn_reg_admin_type` `itn_reg_admin_type` INT(11) NOT NULL DEFAULT '0' COMMENT 'Ref key of ITNDB admin_types table >> admin_type_id column';
-----------------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani(21 September 2021)
UPDATE `email_notification` SET `subject` = 'Create Your Online Profile' WHERE `email_notification`.`en_key` = 'send_invitation_to_user';
-----------------------------------------------------------------------------------------------------------------------------
--Nidhi lakhani(04 October 2021)
INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES
(NULL, NULL, 11, 'sync.user.detail', 'Sync User Detail', 'Sync User Detail', 'sync.user.detail', 0),
(NULL, NULL, 11, 'login.from.admin', 'Secure Login', 'Secure Login', 'login.from.admin', 0);
-----------------------------------------------------------------------------------------------------------------------------

--Ishit Tankaria (6th October 2021)

CREATE TABLE IF NOT EXISTS `temp_country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table `temp_country`
--

INSERT INTO `temp_country` (`id`, `iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`) VALUES
(1, 'AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4, 93),
(2, 'AL', 'ALBANIA', 'Albania', 'ALB', 8, 355),
(3, 'DZ', 'ALGERIA', 'Algeria', 'DZA', 12, 213),
(4, 'AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16, 1684),
(5, 'AD', 'ANDORRA', 'Andorra', 'AND', 20, 376),
(6, 'AO', 'ANGOLA', 'Angola', 'AGO', 24, 244),
(7, 'AI', 'ANGUILLA', 'Anguilla', 'AIA', 660, 1264),
(8, 'AQ', 'ANTARCTICA', 'Antarctica', NULL, NULL, 0),
(9, 'AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28, 1268),
(10, 'AR', 'ARGENTINA', 'Argentina', 'ARG', 32, 54),
(11, 'AM', 'ARMENIA', 'Armenia', 'ARM', 51, 374),
(12, 'AW', 'ARUBA', 'Aruba', 'ABW', 533, 297),
(13, 'AU', 'AUSTRALIA', 'Australia', 'AUS', 36, 61),
(14, 'AT', 'AUSTRIA', 'Austria', 'AUT', 40, 43),
(15, 'AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31, 994),
(16, 'BS', 'BAHAMAS', 'Bahamas', 'BHS', 44, 1242),
(17, 'BH', 'BAHRAIN', 'Bahrain', 'BHR', 48, 973),
(18, 'BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50, 880),
(19, 'BB', 'BARBADOS', 'Barbados', 'BRB', 52, 1246),
(20, 'BY', 'BELARUS', 'Belarus', 'BLR', 112, 375),
(21, 'BE', 'BELGIUM', 'Belgium', 'BEL', 56, 32),
(22, 'BZ', 'BELIZE', 'Belize', 'BLZ', 84, 501),
(23, 'BJ', 'BENIN', 'Benin', 'BEN', 204, 229),
(24, 'BM', 'BERMUDA', 'Bermuda', 'BMU', 60, 1441),
(25, 'BT', 'BHUTAN', 'Bhutan', 'BTN', 64, 975),
(26, 'BO', 'BOLIVIA', 'Bolivia', 'BOL', 68, 591),
(27, 'BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70, 387),
(28, 'BW', 'BOTSWANA', 'Botswana', 'BWA', 72, 267),
(29, 'BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL, 0),
(30, 'BR', 'BRAZIL', 'Brazil', 'BRA', 76, 55),
(31, 'IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', NULL, NULL, 246),
(32, 'BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96, 673),
(33, 'BG', 'BULGARIA', 'Bulgaria', 'BGR', 100, 359),
(34, 'BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854, 226),
(35, 'BI', 'BURUNDI', 'Burundi', 'BDI', 108, 257),
(36, 'KH', 'CAMBODIA', 'Cambodia', 'KHM', 116, 855),
(37, 'CM', 'CAMEROON', 'Cameroon', 'CMR', 120, 237),
(38, 'CA', 'CANADA', 'Canada', 'CAN', 124, 1),
(39, 'CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132, 238),
(40, 'KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136, 1345),
(41, 'CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140, 236),
(42, 'TD', 'CHAD', 'Chad', 'TCD', 148, 235),
(43, 'CL', 'CHILE', 'Chile', 'CHL', 152, 56),
(44, 'CN', 'CHINA', 'China', 'CHN', 156, 86),
(45, 'CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL, 61),
(46, 'CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL, 672),
(47, 'CO', 'COLOMBIA', 'Colombia', 'COL', 170, 57),
(48, 'KM', 'COMOROS', 'Comoros', 'COM', 174, 269),
(49, 'CG', 'CONGO', 'Congo', 'COG', 178, 242),
(50, 'CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', 180, 242),
(51, 'CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184, 682),
(52, 'CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188, 506),
(53, 'CI', 'COTE D''IVOIRE', 'Cote D''Ivoire', 'CIV', 384, 225),
(54, 'HR', 'CROATIA', 'Croatia', 'HRV', 191, 385),
(55, 'CU', 'CUBA', 'Cuba', 'CUB', 192, 53),
(56, 'CY', 'CYPRUS', 'Cyprus', 'CYP', 196, 357),
(57, 'CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203, 420),
(58, 'DK', 'DENMARK', 'Denmark', 'DNK', 208, 45),
(59, 'DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262, 253),
(60, 'DM', 'DOMINICA', 'Dominica', 'DMA', 212, 1767),
(61, 'DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214, 1809),
(62, 'EC', 'ECUADOR', 'Ecuador', 'ECU', 218, 593),
(63, 'EG', 'EGYPT', 'Egypt', 'EGY', 818, 20),
(64, 'SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222, 503),
(65, 'GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226, 240),
(66, 'ER', 'ERITREA', 'Eritrea', 'ERI', 232, 291),
(67, 'EE', 'ESTONIA', 'Estonia', 'EST', 233, 372),
(68, 'ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231, 251),
(69, 'FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238, 500),
(70, 'FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234, 298),
(71, 'FJ', 'FIJI', 'Fiji', 'FJI', 242, 679),
(72, 'FI', 'FINLAND', 'Finland', 'FIN', 246, 358),
(73, 'FR', 'FRANCE', 'France', 'FRA', 250, 33),
(74, 'GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254, 594),
(75, 'PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258, 689),
(76, 'TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL, 0),
(77, 'GA', 'GABON', 'Gabon', 'GAB', 266, 241),
(78, 'GM', 'GAMBIA', 'Gambia', 'GMB', 270, 220),
(79, 'GE', 'GEORGIA', 'Georgia', 'GEO', 268, 995),
(80, 'DE', 'GERMANY', 'Germany', 'DEU', 276, 49),
(81, 'GH', 'GHANA', 'Ghana', 'GHA', 288, 233),
(82, 'GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292, 350),
(83, 'GR', 'GREECE', 'Greece', 'GRC', 300, 30),
(84, 'GL', 'GREENLAND', 'Greenland', 'GRL', 304, 299),
(85, 'GD', 'GRENADA', 'Grenada', 'GRD', 308, 1473),
(86, 'GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312, 590),
(87, 'GU', 'GUAM', 'Guam', 'GUM', 316, 1671),
(88, 'GT', 'GUATEMALA', 'Guatemala', 'GTM', 320, 502),
(89, 'GN', 'GUINEA', 'Guinea', 'GIN', 324, 224),
(90, 'GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624, 245),
(91, 'GY', 'GUYANA', 'Guyana', 'GUY', 328, 592),
(92, 'HT', 'HAITI', 'Haiti', 'HTI', 332, 509),
(93, 'HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', NULL, NULL, 0),
(94, 'VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336, 39),
(95, 'HN', 'HONDURAS', 'Honduras', 'HND', 340, 504),
(96, 'HK', 'HONG KONG', 'Hong Kong', 'HKG', 344, 852),
(97, 'HU', 'HUNGARY', 'Hungary', 'HUN', 348, 36),
(98, 'IS', 'ICELAND', 'Iceland', 'ISL', 352, 354),
(99, 'IN', 'INDIA', 'India', 'IND', 356, 91),
(100, 'ID', 'INDONESIA', 'Indonesia', 'IDN', 360, 62),
(101, 'IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364, 98),
(102, 'IQ', 'IRAQ', 'Iraq', 'IRQ', 368, 964),
(103, 'IE', 'IRELAND', 'Ireland', 'IRL', 372, 353),
(104, 'IL', 'ISRAEL', 'Israel', 'ISR', 376, 972),
(105, 'IT', 'ITALY', 'Italy', 'ITA', 380, 39),
(106, 'JM', 'JAMAICA', 'Jamaica', 'JAM', 388, 1876),
(107, 'JP', 'JAPAN', 'Japan', 'JPN', 392, 81),
(108, 'JO', 'JORDAN', 'Jordan', 'JOR', 400, 962),
(109, 'KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398, 7),
(110, 'KE', 'KENYA', 'Kenya', 'KEN', 404, 254),
(111, 'KI', 'KIRIBATI', 'Kiribati', 'KIR', 296, 686),
(112, 'KP', 'KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF', 'Korea, Democratic People''s Republic of', 'PRK', 408, 850),
(113, 'KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', 410, 82),
(114, 'KW', 'KUWAIT', 'Kuwait', 'KWT', 414, 965),
(115, 'KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417, 996),
(116, 'LA', 'LAO PEOPLE''S DEMOCRATIC REPUBLIC', 'Lao People''s Democratic Republic', 'LAO', 418, 856),
(117, 'LV', 'LATVIA', 'Latvia', 'LVA', 428, 371),
(118, 'LB', 'LEBANON', 'Lebanon', 'LBN', 422, 961),
(119, 'LS', 'LESOTHO', 'Lesotho', 'LSO', 426, 266),
(120, 'LR', 'LIBERIA', 'Liberia', 'LBR', 430, 231),
(121, 'LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434, 218),
(122, 'LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438, 423),
(123, 'LT', 'LITHUANIA', 'Lithuania', 'LTU', 440, 370),
(124, 'LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442, 352),
(125, 'MO', 'MACAO', 'Macao', 'MAC', 446, 853),
(126, 'MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807, 389),
(127, 'MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450, 261),
(128, 'MW', 'MALAWI', 'Malawi', 'MWI', 454, 265),
(129, 'MY', 'MALAYSIA', 'Malaysia', 'MYS', 458, 60),
(130, 'MV', 'MALDIVES', 'Maldives', 'MDV', 462, 960),
(131, 'ML', 'MALI', 'Mali', 'MLI', 466, 223),
(132, 'MT', 'MALTA', 'Malta', 'MLT', 470, 356),
(133, 'MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584, 692),
(134, 'MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474, 596),
(135, 'MR', 'MAURITANIA', 'Mauritania', 'MRT', 478, 222),
(136, 'MU', 'MAURITIUS', 'Mauritius', 'MUS', 480, 230),
(137, 'YT', 'MAYOTTE', 'Mayotte', NULL, NULL, 269),
(138, 'MX', 'MEXICO', 'Mexico', 'MEX', 484, 52),
(139, 'FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', 583, 691),
(140, 'MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498, 373),
(141, 'MC', 'MONACO', 'Monaco', 'MCO', 492, 377),
(142, 'MN', 'MONGOLIA', 'Mongolia', 'MNG', 496, 976),
(143, 'MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500, 1664),
(144, 'MA', 'MOROCCO', 'Morocco', 'MAR', 504, 212),
(145, 'MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508, 258),
(146, 'MM', 'MYANMAR', 'Myanmar', 'MMR', 104, 95),
(147, 'NA', 'NAMIBIA', 'Namibia', 'NAM', 516, 264),
(148, 'NR', 'NAURU', 'Nauru', 'NRU', 520, 674),
(149, 'NP', 'NEPAL', 'Nepal', 'NPL', 524, 977),
(150, 'NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528, 31),
(151, 'AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530, 599),
(152, 'NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540, 687),
(153, 'NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554, 64),
(154, 'NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558, 505),
(155, 'NE', 'NIGER', 'Niger', 'NER', 562, 227),
(156, 'NG', 'NIGERIA', 'Nigeria', 'NGA', 566, 234),
(157, 'NU', 'NIUE', 'Niue', 'NIU', 570, 683),
(158, 'NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574, 672),
(159, 'MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580, 1670),
(160, 'NO', 'NORWAY', 'Norway', 'NOR', 578, 47),
(161, 'OM', 'OMAN', 'Oman', 'OMN', 512, 968),
(162, 'PK', 'PAKISTAN', 'Pakistan', 'PAK', 586, 92),
(163, 'PW', 'PALAU', 'Palau', 'PLW', 585, 680),
(164, 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL, 970),
(165, 'PA', 'PANAMA', 'Panama', 'PAN', 591, 507),
(166, 'PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598, 675),
(167, 'PY', 'PARAGUAY', 'Paraguay', 'PRY', 600, 595),
(168, 'PE', 'PERU', 'Peru', 'PER', 604, 51),
(169, 'PH', 'PHILIPPINES', 'Philippines', 'PHL', 608, 63),
(170, 'PN', 'PITCAIRN', 'Pitcairn', 'PCN', 612, 0),
(171, 'PL', 'POLAND', 'Poland', 'POL', 616, 48),
(172, 'PT', 'PORTUGAL', 'Portugal', 'PRT', 620, 351),
(173, 'PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630, 1787),
(174, 'QA', 'QATAR', 'Qatar', 'QAT', 634, 974),
(175, 'RE', 'REUNION', 'Reunion', 'REU', 638, 262),
(176, 'RO', 'ROMANIA', 'Romania', 'ROM', 642, 40),
(177, 'RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643, 70),
(178, 'RW', 'RWANDA', 'Rwanda', 'RWA', 646, 250),
(179, 'SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654, 290),
(180, 'KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659, 1869),
(181, 'LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662, 1758),
(182, 'PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', 666, 508),
(183, 'VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670, 1784),
(184, 'WS', 'SAMOA', 'Samoa', 'WSM', 882, 684),
(185, 'SM', 'SAN MARINO', 'San Marino', 'SMR', 674, 378),
(186, 'ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678, 239),
(187, 'SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682, 966),
(188, 'SN', 'SENEGAL', 'Senegal', 'SEN', 686, 221),
(189, 'CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', NULL, NULL, 381),
(190, 'SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690, 248),
(191, 'SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694, 232),
(192, 'SG', 'SINGAPORE', 'Singapore', 'SGP', 702, 65),
(193, 'SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703, 421),
(194, 'SI', 'SLOVENIA', 'Slovenia', 'SVN', 705, 386),
(195, 'SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90, 677),
(196, 'SO', 'SOMALIA', 'Somalia', 'SOM', 706, 252),
(197, 'ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710, 27),
(198, 'GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', NULL, NULL, 0),
(199, 'ES', 'SPAIN', 'Spain', 'ESP', 724, 34),
(200, 'LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144, 94),
(201, 'SD', 'SUDAN', 'Sudan', 'SDN', 736, 249),
(202, 'SR', 'SURINAME', 'Suriname', 'SUR', 740, 597),
(203, 'SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', 744, 47),
(204, 'SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748, 268),
(205, 'SE', 'SWEDEN', 'Sweden', 'SWE', 752, 46),
(206, 'CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756, 41),
(207, 'SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760, 963),
(208, 'TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158, 886),
(209, 'TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762, 992),
(210, 'TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834, 255),
(211, 'TH', 'THAILAND', 'Thailand', 'THA', 764, 66),
(212, 'TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL, 670),
(213, 'TG', 'TOGO', 'Togo', 'TGO', 768, 228),
(214, 'TK', 'TOKELAU', 'Tokelau', 'TKL', 772, 690),
(215, 'TO', 'TONGA', 'Tonga', 'TON', 776, 676),
(216, 'TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780, 1868),
(217, 'TN', 'TUNISIA', 'Tunisia', 'TUN', 788, 216),
(218, 'TR', 'TURKEY', 'Turkey', 'TUR', 792, 90),
(219, 'TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795, 7370),
(220, 'TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', 796, 1649),
(221, 'TV', 'TUVALU', 'Tuvalu', 'TUV', 798, 688),
(222, 'UG', 'UGANDA', 'Uganda', 'UGA', 800, 256),
(223, 'UA', 'UKRAINE', 'Ukraine', 'UKR', 804, 380),
(224, 'AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784, 971),
(225, 'GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826, 44),
(226, 'US', 'UNITED STATES', 'United States', 'USA', 840, 1),
(227, 'UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL, 1),
(228, 'UY', 'URUGUAY', 'Uruguay', 'URY', 858, 598),
(229, 'UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860, 998),
(230, 'VU', 'VANUATU', 'Vanuatu', 'VUT', 548, 678),
(231, 'VE', 'VENEZUELA', 'Venezuela', 'VEN', 862, 58),
(232, 'VN', 'VIET NAM', 'Viet Nam', 'VNM', 704, 84),
(233, 'VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', 92, 1284),
(234, 'VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', 850, 1340),
(235, 'WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', 876, 681),
(236, 'EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732, 212),
(237, 'YE', 'YEMEN', 'Yemen', 'YEM', 887, 967),
(238, 'ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894, 260),
(239, 'ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716, 263);

ALTER TABLE `geo_country`  ADD `country_phone_code` VARCHAR(50) NULL DEFAULT NULL  AFTER `country_status`;

UPDATE geo_country as c1
LEFT JOIN temp_country as c2
    ON c1.country_code = c2.iso OR c1.country_name = c2.nicename
SET c1.country_phone_code = c2.phonecode;

DROP TABLE `temp_country`;

ALTER TABLE `user_details`  ADD `country_phone_code` VARCHAR(50) NULL DEFAULT NULL  AFTER `phone_number`;
ALTER TABLE `user_details`  ADD `country_phone_code_two` VARCHAR(50) NULL DEFAULT NULL  AFTER `phone_number_two`;
ALTER TABLE `user_details`  ADD `employer_country_phone_code` VARCHAR(50) NULL DEFAULT NULL  AFTER `employer_phone`;
ALTER TABLE `user_details`  ADD `contact_country_phone_code` VARCHAR(50) NULL DEFAULT NULL  AFTER `contact_phone`;
ALTER TABLE `user_details`  ADD `contact_alternative_country_phone_code` VARCHAR(50) NULL DEFAULT NULL  AFTER `contact_phone_alternative`;
ALTER TABLE `resume`  ADD `primary_phone_country_code` VARCHAR(50) NULL DEFAULT NULL  AFTER `primary_phone`;
ALTER TABLE `resume`  ADD `secondary_phone_country_code` VARCHAR(50) NULL DEFAULT NULL  AFTER `secondary_phone`;

UPDATE `as_steps` SET `as_title` = 'Interview Schedule with Host Company' WHERE `as_steps`.`as_order_key` = '2_booked'; UPDATE `as_steps` SET `as_title` = 'Placement Confirmed' WHERE `as_steps`.`as_order_key` = '2_placed'; UPDATE `as_steps` SET `as_title` = 'Searching US Host Company' WHERE `as_steps`.`as_order_key` = '2_searching_position';
-------------------------------------------------------------------------------------------------------------------------------------------
--Manisha Odedara (7 October 2021)
INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES
(NULL, NULL, 11, 'sync.user.detail.email', 'Sync User Detail using email', 'Sync User Detail using email', 'sync.user.detail.email', 0);
-----------------------------------------------------------------------------------------------------------------------------------------------------
--Ishit Tankaria (18th October 2021)
ALTER TABLE `user_details`  ADD `short_introduction_added_at` DATETIME NULL DEFAULT NULL  AFTER `short_introduction_reject_reason`;
-----------------------------------------------------------------------------------------------------------------------------------------------------
--Ishit Tankaria (20th October 2021)
INSERT INTO `j1_statuses` (`id`, `status_key`, `status_name`, `category`) VALUES ('1014', 'short-video-introduction-skipped', 'Short Video Introduction Skipped', '1');
UPDATE j1_statuses SET status_name='Short Video Introduction Added' WHERE status_key = 'short-introduction-added';
UPDATE as_steps SET as_desc_before = "USD/EUR non-refundable registration fee. This is a one time, non-refundable fee for the processing of your application.",  as_desc_current = "USD/EUR non-refundable registration fee. This is a one time, non-refundable fee for the processing of your application.",  as_desc_after= "USD/EUR non-refundable registration fee. This is a one time, non-refundable fee for the processing of your application." WHERE as_order_key = "1_registration_fee"
-----------------------------------------------------------------------------------------------------------------------------------------------------   
--Ishit Tankaria (19th October 2021)
UPDATE `j1_statuses` SET status_name="Registration Fee Paid" WHERE status_key="registration-fee-completed";
INSERT INTO `j1_statuses` (`id`, `status_key`, `status_name`, `category`) VALUES ('1015', 'registration-fee-charged', 'Registration Fee Charged', '1'), ('1016', 'registration-fee-postponed', 'Registration Fee Postponed', '1');
UPDATE `as_steps` SET j1_status_id = '1009,1015' WHERE as_order_key = '1_registration_fee';
UPDATE `as_steps` SET j1_status_id = '3018,2001,1014' WHERE as_order_key = '2_supporting_documents';
UPDATE `as_steps` SET j1_status_id = '1010,1016' WHERE as_order_key = '1_additional_info';

-----------------------------------------------------------------------------------------------------------------------------------------------------
--Chandresh Kukadiya(26th October 2021)

CREATE TABLE `ticket_details` (
  `id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL DEFAULT 0,
  `portfolio_id` int(11) NOT NULL DEFAULT 0,
  `admin_id` int(11) NOT NULL DEFAULT 0,
  `ticket_content` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


ALTER TABLE `ticket_details`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `ticket_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES (NULL, NULL, '11', 'user.ticket.search', 'Search Tickets', 'search tickets', 'user.ticket.search', '0');

INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES (NULL, NULL, '11', 'load.ticket.data', 'Load Ticket Data', 'load ticket data', 'load.ticket.data', '0');

INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES (NULL, NULL, '11', 'user.ticket.submit', 'Submit Ticket', 'submit ticket', 'user.ticket.submit', '0');

INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES (NULL, NULL, '11', 'mark.ticket.completed', 'Mark Ticket Completed', 'mark ticket completed manually', 'mark.ticket.completed', '0');

INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES (NULL, NULL, '11', 'admin.ticket.details', 'Ticket Conversation', 'Ticket conversation details', 'admin.ticket.details', '0');

INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES (NULL, NULL, '11', 'admin.ticket.send_message', 'Reply Message To Ticket', 'Reply message to ticket', 'admin.ticket.send_message', '0');

INSERT INTO `email_notification` (`id`, `en_key`, `subject`, `text`, `send_to`, `send_cc`, `status`) VALUES (NULL, 'send_ticket_notification_to_admins', 'Ticket generated by user', '<p>Hello there,</p>\r\n\r\n<p>New ticket generated by user, please find bellow details.</p>\r\n\r\n<p>Subject : {{subject}}</p>\r\n<p>Question : {{question}}</p>\r\n\r\n\r\nThanks', '1', 'test_cc_qa@yopmail.com', '1');

----------------------------------------------------------------------------------------------------------------------------------------------------
--Manisha Odedara (26 October 2021)
INSERT INTO `email_notification` (`id`, `en_key`, `subject`, `text`, `send_to`, `send_cc`, `status`)VALUES (NULL, 'ev_failed_to_update_email', 'EV failed to update email address','<div><p>Dear {{admin_name}},</p><p>Below EV cannot update email address because there is another account with the same email address.</p><p><strong>EV name:</strong> {{ev_name}}</br><strong>EV Email Address:</strong> {{ev_email}}</br><strong>EV Portfolio Number:</strong> {{portfolio_number}} </p><p>Thank you,</p></div>', '2', '', '1');
-----------------------------------------------------------------------------------------------------------------------------
--Manisha Odedara (27 October 2021)
UPDATE `email_notification` SET `text` = '<div><p>Dear {{admin_name}}, </p><p>Below EV cannot update email address because there is another account with the same email address.</p><p><strong>EV name:</strong> {{ev_name}}</br><strong>Old EV Email Address:</strong> {{ev_email}}</br><strong>New Duplicate EV Email Address:</strong> {{new_email}}</p><p>Thank you, </p></div>' WHERE `email_notification`.`en_key` = 'ev_failed_to_update_email';
UPDATE `email_notification` SET `text` = '<p>Dear {{first_name}} {{last_name}},<br/><br/>You have changed your email address. Please click on the link below to verify your new email address.<br/><a href="{{url}}">Click Here</a><br/><br/>Once you verify your email address, your further process will be held with your new email address. FYI, your password will remain unchanged.</p>' WHERE `email_notification`.`en_key` = 'activate_user_account_with_new_email';
-----------------------------------------------------------------------------------------------------------------------------
--Chandresh Kukadiya(27th October 2021)

ALTER TABLE `tickets` DROP `admin_id`, DROP `question`, DROP `answer`;

------------- THIS QUERY IS ONLY FOR LIVE DATABASE START ------------------------------------------

INSERT INTO `tickets` (`id`, `portfolio_id`, `subject`, `status`, `active_step_key`, `created_at`, `updated_at`) VALUES
(1, 24, 'Registration Fee Support', 'pending', '1_registration_fee', '2021-09-23 22:10:14', '2021-09-23 22:10:14'),
(2, 31, 'Interview Support', 'pending', '1_j1_interview', '2021-09-29 10:34:31', '2021-10-26 03:47:49'),
(3, 32, 'Contract With Placement Agency Support', 'pending', '2_contract_placement', '2021-10-04 10:35:30', '2021-10-26 03:49:08'),
(4, 39, 'Provide Supporting Documents Support', 'pending', '2_supporting_documents', '2021-10-11 10:19:57', '2021-10-26 03:49:12'),
(5, 11, 'Contact Support', 'completed', 'contact-support', '2021-10-13 13:52:35', '2021-10-26 04:04:44'),
(6, 20, 'Contact Support', 'pending', 'contact-support', '2021-10-19 03:01:40', '2021-10-26 04:04:48'),
(7, 24, 'Provide Supporting Documents Support', 'pending', '2_supporting_documents', '2021-10-19 12:26:12', '2021-10-26 03:49:18'),
(8, 44, 'Provide Supporting Documents Support', 'pending', '2_supporting_documents', '2021-10-21 20:24:01', '2021-10-26 03:49:21');

INSERT INTO `ticket_details` (`id`, `ticket_id`, `portfolio_id`, `admin_id`, `ticket_content`, `created_at`, `updated_at`) VALUES
(1, 1, 24, 0, 'Hello, i created a paypal account to be able to send the 20 dolars, but when i want to finish the transaction the page lowds and doesn\'t send. I phone Visa, because i thought my Credit card wasn\'t available to send money to the USA. But Visa said my card was ok, just that it might be a problem of paypal. Could you help me pleace to sort out this problem.\r\nThanks, i wait for your answer.', '2021-09-24 09:10:14', '2021-09-24 14:31:38'),
(2, 1, 24, 0, 'Sorry to write again, just that i also remembered that if it\'s not paypal it could be, that you need to let me send you money from Argentina.', '2021-09-24 09:10:14', '2021-09-24 09:10:14'),
(3, 7, 24, 0, 'Why is takeing so long to me approved my passpport ??', '2021-10-26 14:32:33', '2021-10-26 14:32:33'),
(4, 2, 31, 0, 'Good day. May I know when will be the schedule of the interview? Thank you very much', '2021-09-29 14:35:20', '2021-09-29 14:35:20'),
(5, 3, 32, 0, 'Hi, I\'ve been waiting for the agreement form to pop out but I didn\'t receive any for the past 4 days, I Think. Can you help me with this?  because I\'m really interested in this camp. Looking forward to your response. Thank you so much.', '2021-10-04 14:39:03', '2021-10-04 14:39:03'),
(6, 4, 39, 0, 'Hi! Sorry, but where could I get the ITN Agreement file again? Thanks!', '2021-10-11 14:41:22', '2021-10-11 14:41:22'),
(7, 4, 39, 0, 'Hi! Sorry, I uploaded the wrong file for the ITN Agreement. Is there a way I could upload the right one?', '2021-10-19 14:41:51', '2021-10-19 14:41:51'),
(8, 5, 11, 0, 'Test question', '2021-10-14 14:42:24', '2021-10-14 14:42:24'),
(9, 5, 0, 4, 'Check in LIVE', '2021-10-14 10:21:43', '2021-10-14 10:21:43'),
(10, 6, 20, 0, 'Hello! I have already submitted my resume, ITN agreement and passport and  all were already approved last October 19. I was hoping to know for the next step as I could not proceed and click on to the next button. Thank you and have a great day!', '2021-10-19 14:43:51', '2021-10-19 14:43:51'),
(11, 8, 44, 0, 'Where do I get the ITN agreement?', '2021-10-22 14:44:21', '2021-10-22 14:44:21');

------------- THIS QUERY IS ONLY FOR LIVE DATABASE END ------------------------------------------

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--Manisha Odedara (28 October 2021)
CREATE TABLE `stripe_transaction` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `portfolio_id` int(11) DEFAULT NULL,
  `fee_type` int(1) DEFAULT NULL COMMENT '1=Registration',
  `invoice_id` int(11) DEFAULT NULL,
  `invoice_number` varchar(255) DEFAULT NULL,
  `is_installment` int(11) DEFAULT NULL COMMENT '1 = Yes, 2 = No',
  `subscrption_id` varchar(255) DEFAULT NULL,
  `instalment_number` int(11) DEFAULT NULL,
  `instalment_start_date` date DEFAULT NULL,
  `instalment_end_date` date DEFAULT NULL,
  `amount_due` decimal(10,0) DEFAULT NULL,
  `amount_due_date` date DEFAULT NULL,
  `amount_paid` decimal(10,0) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `paymnt_receipt_url` varchar(255) DEFAULT NULL,
  `payment_status` int(11) DEFAULT NULL COMMENT 'Pending = 1, Paid = 2, Fail = 3',
  `payment_status_id` varchar(255) DEFAULT NULL,
  `payment_response` longtext DEFAULT NULL,
  `payment_type` int(11) DEFAULT NULL COMMENT '1 = Full, 2 = Initial, 3 = Instalments',
  `stripe_email` varchar(255) DEFAULT NULL,
  `stripe_phone` varchar(255) DEFAULT NULL,
  `transaction_type` int(11) DEFAULT NULL COMMENT '1 = CIDC(W&T), 2 = Odyssey Camp, 3 = ACEO Camp, 4= W&T , 5=Registration Fee',
  `transaction_date` date DEFAULT NULL,
  `created_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `stripe_transaction` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`),ADD KEY `invoice_id` (`invoice_id`);
ALTER TABLE `stripe_transaction` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--------------------------------------------------------------------------------------------------------------------------------------------------
--Ishit Tankaria (2nd November 2021)
UPDATE j1_statuses SET status_name='Eligible for HC Interview - Missing Doc' WHERE status_key='supporting-document-collected';
UPDATE j1_statuses SET status_name='Eligible for HC Interview' WHERE status_key='searching-position';
--------------------------------------------------------------------------------------------------------------------------------------------------
--Chandresh Kukadiya(2nd November 2021)
INSERT INTO `notification_types` (`id`, `notification_key`, `notification_name`, `status`, `visible_to_user`, `notification_mode`) VALUES (NULL, 'ticket_conversation', 'Ticket Conversation', '1', '1', '1');

INSERT INTO `notification_messages` (`id`, `notification_type_id`, `notification_type_key`, `notification_type_data`, `notification_text`, `notification_message`, `status`, `created_at`, `updated_at`) VALUES (NULL, '10', 'ticket_conversation', 'ticket_conversation', 'Ticket Reply', 'New ticket message from admin', '1', current_timestamp(), NULL);
--------------------------------------------------------------------------------------------------------------------------------------------------
--Nidhi Lakhani(11th November 2021)
ALTER TABLE `agency_contract` ADD `is_accepted_by_ev` TINYINT NOT NULL DEFAULT '0' COMMENT '1 = requested, 2 = accepted' AFTER `request_status`;
UPDATE `agency_contract` SET `is_accepted_by_ev` = '2' WHERE `agency_contract`.`request_status` = 2;
UPDATE `agency_contract` SET `is_accepted_by_ev` = '1' WHERE `agency_contract`.`request_status` = 1;
--------------------------------------------------------------------------------------------------------------------------------------------------
--Chandresh Kukadiya(12th November 2021)
Hits the Command : composer update
--------------------------------------------------------------------------------------------------------------------------------------------------
--Ishit Tankaria (12th November 2021)
UPDATE `j1_statuses` SET status_name = 'Registration Fee Invoiced' WHERE status_key = 'registration-fee-charged';
--------------------------------------------------------------------------------------------------------------------------------------------------
--Manisha Odedara (24 November 2021)
UPDATE email_notification SET
    text = '<div>
                <p>Dear {{ev_name}}, </p>
                <p>Your payment of the Registration Fee has been accepted.</p>
                <p>We have attached your invoice.</p>
                <p>{{stripe_receipt_link}}</p>
                <p>Thank you for your payment,</p>
            </div>'
    WHERE `email_notification`.`en_key` = 'registration_fee_payment_success';
--------------------------------------------------------------------------------------------------------------
--Manisha Odedara (25 November 2021)
UPDATE `j1_statuses` SET `status_name` = 'Predeparture Orientation Quiz Completed' WHERE `j1_statuses`.`status_key` = 'predeparture-orientation';
----------------------------------------------------------------------------------------------------------------------
--Chandresh Kukadiya(11th Jan 2022)
ALTER TABLE `user_details` ADD `is_skipped_additional_info` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'when EV skip additional info step then flag set as 1' AFTER `short_introduction_added_at`;

INSERT INTO `document_requirements` (`agency_id`, `document_type`, `document_desc`, `requirement_type`, `document_section`, `visibility`) VALUES ('4', '56', 'requirement', '1', '2', '3');

INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES (NULL, NULL, '2', 'sponsor.agreement', 'Sponsor Agreement', 'sponsor agreement', 'sponsor.agreement', '1');
INSERT INTO `permissions` (`id`, `parent_permission_id`, `permission_group_id`, `permission_name`, `display_name`, `description`, `route_name`, `is_menu_item`) VALUES (NULL, NULL, '2', 'sponsor.agreement.edit', 'Sponsor Agreement Edit', 'sponsor agreement edit', 'sponsor.agreement.edit', '0');

INSERT INTO `system_settings` (`id`, `name`, `field`, `value`, `description`) VALUES (NULL, 'Sponsor ODC Agreement Content', 'sponsor_odc_agreement_content', 'contents', 'Sponsor ODC Agreement Content');

INSERT INTO `system_settings` (`id`, `name`, `field`, `value`, `description`) VALUES (NULL, 'Sponsor ODC CAMP Agreement Content', 'sponsor_odc_camp_agreement_content', 'contents', 'Sponsor ODC CAMP Agreement Content');

INSERT INTO `system_settings` (`name`, `field`, `value`, `description`) VALUES
('Intern Agreement Content', 'intern_itn_agreement_content', "<h3 style=\"text-align:center;\"><span style=\"background-color:hsl(0,0%,100%);\"><strong>2020 AHA All-Inclusive Research Service Agreement - 8.1 to 12 months</strong></span><br> </h3><p><strong>THIS AGREEMENT</strong> is made the<strong>{DAY}</strong> of <strong>{MONTH} {YEAR}</strong> by and between <strong>{EV_NAME}</strong>, hereinafter called the \'Candidate\' and International Trainee Network, hereinafter called the \'Service Provider\'.</p><p> </p><p>The Candidate understands that the J1 Visa Program offered, applied and controlled by the Service Provider and its affiliated US Department of State designated Visa Sponsor Organization is not a work or employment program but a structured and guided work-based career training program that provides on-the-job exposure to American techniques, methodologies and expertise and enhances the Intern\'s/Trainee\'s knowledge of American society and culture.</p><p>Furthermore, the Candidate understands that the Service Provider is a research company specialized in helping international students and young professionals either jump-start or consolidate their careers by finding them a Host Company in the U.S. where they can carry about a practical training within their field of expertise.</p><p>WITNESSETH, that the Candidate and the Service Provider for the considerations named agree as follows:</p><p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 1 . SCOPE OF THE SERVICES</strong></span></p><p><br><u>1.1. Provider\'s Services.</u> The Service Provider will:</p><ol><li>Evaluate and determine the Candidate\'s eligibility for the J-1 Program according to the U.S. Department of<br>State\'s current regulations.</li><li>Evaluate the Candidate\'s English level.</li><li>Send the application package to be fully completed by the Candidate.</li><li>Reformat the Candidate\'s resume to the American standard.</li><li>Arrange interviews with potential Host Companies.</li><li>Prepare the Candidate for the interviews with potential Host Companies.</li><li>Negotiate the conditions of the training/internship: stipend, means of transportation and housing, if<br>provided by the Host Company.</li><li>Prepare Form DS-7002, \"Training/Internship Placement Plan\", according to the Host Company\'s specifications.</li><li>Complete and secure requisite signatures on Form DS-7002.</li><li>Prepare the Candidate\'s file to obtain the Form DS-2019, \"Certificate of Eligibility for Exchange Visitor Status\", which is a prerequisite for obtaining the J1 Visa.</li><li>Prepare the Candidate with regard to their interview at the U.S. Embassy / U.S. Consulate.</li><li>Send the Candidate his/her medical insurance card valid for the duration of the DS-2019.</li><li>Assist the Candidate upon arrival by providing the \"Candidate Arrival Package\" with information regarding housing, Social Security, bank account, etc</li></ol><p><u>1.2. Research of Host Company.</u> The Service Provider will use its best effort to find an internship/training for the Candidate within twelve (12) weeks of receipt of the non-refundable registration fee as described in Article 4 below and all required documents.</p><p><br><u>1.3. Negotiation of Stipend. </u>The Service Provider guarantees to negotiate with the Host Company a paid internship/traineeship,<br><u>1.4. Processing of DS Form.</u> The Service Provider will process and issue Form DS-7002, \"Training/Internship Placement Plan\" after the Candidate has:</p><ol style=\"list-style-type:lower-latin;\"><li>Been accepted by the Host Company; and</li><li>Provided all necessary documents requested by the Service Provider; and</li><li>Satisfied the fees as described in Article 4.</li></ol><p style=\"text-align:center;\"><br><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 2. CANDIDATE\'S OBLIGATIONS AND RESPONSIBILITIES</strong></span></p><p><br><u>2.1. Candidate\'s Obligations. </u>The Candidate agrees:</p><ol style=\"list-style-type:lower-latin;\"><li>To have passed all academic requirement and/or to have required work experiences and to be able to<br>provide the Service Provider with all supportive documents for education and work experience stated on<br>his/her resume.</li><li>To attend all interviews, including telephonic or Skype interviews, at the pre-arranged time that have<br>been organized by the Service Provider.</li><li>To not decline more than two (2) interviews with potential Host Companies.</li><li>To accept the position that was offered to him/her by a Host Company after a successful interview. The<br>Candidate understands that he/she needs to do research about the Host Company before accepting an interview, once the Candidate has accepted to interview with a Host Company, he/she has to accept the position if the interview is successful. Declining of the offer and the position after a successful interview<br>will be subject to an administrative fee as described in Article 5.1.</li><li>To provide all necessary/requested documentation in a timely manner.</li><li>To submit payment of the program fees in a timely manner (The due date will be indicated on an invoice)</li><li>To secure his/her housing before arrival in the United States unless provided by the Host Company for the<br>duration of the intern/trainee\'s stay in the USA.</li><li>To study the medial insurance brochures provided by the Service Provider and examine medical insurance<br>coverage before arrival. Pre-existing conditions that might affect his/her internship/traineeship must be<br>disclosed in below Article 6.6.</li><li>To observe and respect the American culture and comply with all laws and regulations of the USA<br>(included but not limited to all laws in relation to the Exchange Visitor Program) as well as the Host<br>Company\'s internal regulations.</li><li>To perform his/her duties during his/her training period at a high standard and with all due skills, care and<br>attention with regard to the level of the knowledge, experience or education the Candidate has represented to the Service Provider he or she possesses.</li></ol><p><u>2.2. Candidate\'s Responsibilities.</u> The Candidate is responsible and liable for:</p><ol style=\"list-style-type:lower-latin;\"><li>All transportation costs to, from and within the USA.</li><li>All of his/her living expenses such as food, transportation and housing unless provided by the Host<br>Company for the duration of the intern/trainee\'s stay in the USA.</li><li>All medical expenses and bills except the medical insurance provided by the Sponsor Organization.</li><li>Reading all emails, documents, agreements, informational handouts and guidebooks provided to the Candidate by the Service Provider and/or its affiliated Sponsor Organization.<br> </li></ol><p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 3. TERMS OF THE AGREEMENT</strong></span></p><p><br><u>3.1 Commencement of the Agreement.</u> This Agreement will commence when the Service Provider receives from the Candidate a full payment of the registration fees as described in Article 4 below.</p><p><br><u>3.2. Termination of the Agreement.</u> This Agreement will end on the Internship/Training Program termination date or as otherwise terminated in accordance with the provisions of this Agreement.</p><p> </p><p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 4. FEES</strong></span></p><p><u>4.1. Fee Structure. </u>The fee structure is as follows:</p><figure class=\"table\"><table><tbody><tr><td> </td><td colspan=\"2\"><p style=\"text-align:center;\"><strong>Description</strong></p></td><td><strong>Amount</strong></td></tr><tr><td><p style=\"text-align:center;\"><strong>Registration</strong><br><strong>Fee</strong></p></td><td colspan=\"2\">It is non-refundable and non-applicable to the Program Fee. It covers the Service Provider\'s administrative costs to start the research for a Host Company on behalf of the Candidate.</td><td>75 USD</td></tr><tr><td rowspan=\"3\"><p style=\"text-align:center;\"><strong>Program</strong><br><strong>Fee</strong></p></td><td><p style=\"text-align:center;\"><strong>Full Payment Option</strong></p></td><td>It covers the services described in Article 1.1 and the medical insurance and DS Forms for the duration of the program.</td><td>3,755 USD</td></tr><tr><td rowspan=\"2\"><p style=\"text-align:center;\"><strong>Installment Payment Option</strong></p></td><td>The Candidate will pay the initial deposit for the program before arrival It covers the services described in Article 1.1</td><td rowspan=\"2\">$100 every two weeks</td></tr><tr><td><p>The Candidate will remit payment every two weeks upon arrival for the duration of the program stated on his/her DS 2019. The Candidate will have to set up an automated payment through his/her American debit/credit card upon arrival in the United States.</p><p>The Candidate must understand and agree that if he/she stops payment, he/she will be terminated from the J1 Program and will have to return to his/her home country immediately. You will need to clear off your reaming balance in any occasion including withdrawing from the internship program or leaving early. The Candidate must understand and agree that if he/she stops payment, he/she will be terminated from the J1 Program and will have to return to his/her home country immediately. You will need to clear off your reaming balance in any occasion including withdrawing from the internship program or leaving early.</p></td></tr></tbody></table></figure><p><br><u>4.2 Excluded Fees. </u>The Embassy fee and the SEVIS fee required to train in the United States are not included in the above indicated fee. The Embassy fee will be paid by the Candidate directly to the Embassy. The SEVIS fee will be collected by the Service Provider with the above program fee. The SEVIS fee will be submitted to U.S. Immigration and Customs Enforcement to create the Candidate\'s profile on the SEVIS system upon the process of the Form DS 7002 and no refund will be issued once the SEVIS fee is submitted to U.S. Immigration and Customs Enforcement.</p><p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 5. REFUND POLICY</strong></span></p><p><br><u>5.1 Withdrawal After Placement is confirmed.</u> If the Candidate cancels the placement or withdraws from the program due to any reason after a successful interview with the Host Company and receipt of the notification the Candidate will be entitled to a refund of the program fee minus Five<br>Hundred and Ninety-Five US Dollars (595.00 USD) which will be withheld and account for the administrative fees of the Service Provider and the Sponsor Organization. If the Candidate fails to satisfy the pre-arrival liabilities described in Article 2 and/or if the Candidate is unable to continue the program due to any academic reasons attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate and the administrative fees will be billed. The refund will be processed within 30 days after receipt of the refund request.</p><p><br><u>5.2 Withdrawal After Issuance of Form DS-7002.</u> If the Candidate cancels the placement or withdraws from the program due to any reason after the issuance of Form DS-7002 with the SEVIS number, the Candidate will not be entitled to any refund. If the Candidate fails to satisfy the pre-arrival liabilities described in Article 2 and/or if the Candidate is unable to continue the program due to any academic reasons attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate.<br> </p><p><u>5.3 Embassy/Consulate Denial. </u>In case of a visa denial at the US Embassy, the Candidate must inform the Service Provider within 3 business days of denial and return the original Form DS-2019 and proof of denial from the Embassy or Consulate within 10 business days from the date of denial in order to be eligible to refunds. The Candidate will be entitled to a refund of the program fee minus Five Hundred and Ninety-Five US Dollars (595.00 USD) which will be withheld and account for the administrative fees of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request. No refund will be issued if the documents are returned after the stipulated deadline or if the documents are not returned to the Service Provider.<br> </p><p><u>5.4. Embassy/Consulate Delays. </u>ITN cannot not be held financially responsible for any delays at the US Embassy/Consulate level that are beyond ITN\'s control. These delays include but are not limited to: visa denial, lack of availability for an appointment at local US Embassy/Consulate and cancellation of schedule by the Embassy/Consulate that may sometimes result in shorter programs. In such a case, ITN will not refund any amount for any loss of program time.<br> </p><p><u>5.5 Cancellation by the Host Company.</u> If the Host Company cancels the placement or withdraws from the program prior to the start date of the Candidate\'s program stated on Form DS 7002/2019, the Service Provider will, to its best efforts, try to relocate the Candidate with another Host Company. If the Candidate declines another interview with potential Host Companies for a re-placement or withdraws from the program after accepted for a re-placement with another Host Company, the Candidate will be entitled to a refund of the program fee minus Five Hundred and Ninety-Five US Dollars (595.00 USD) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request.<br> </p><p><u>5.6 Cancellation due to Ineligibility.</u> If the Candidate is found to be ineligible after placement due to incorrect information on his/her resume the Candidate will be entitled to a refund of the program fee minus Five Hundred and Ninety-Five US Dollars (595.00 USD) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request.<br><br><u>5.7 Cancellation by the Sponsor Organization. </u>If the Sponsor Organization cancels the program before the start date of the Candidate\'s program which is stated on Form DS 7002/2019, the Service Provider will, to its best efforts, try to relocate the Candidate with another Host Company. If the Candidate declines another interview with potential Host Companies for a re-placement or withdraws from the program after accepted for a replacement with another Host Company, the Candidate will be entitled to a refund of the program fee minus Five Hundred and Ninety-Five US Dollars (595.00 USD) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request. If the Sponsor Organization determines the Candidate does not comply with the Rules and Regulations for the Exchange Visitor Program or standards by the Host Company and cancels the program after arrival the Candidate will not be entitled to any refund.<br> </p><p><u>5.8 Cancellation After Arrival in the United States.</u> If the Candidate withdraws from the program or is unable to continue the program due to any reason after arrival in the US or if the Candidate is laid off or fired by the Host Company, the Candidate will not be entitled to any refund.<br> </p><p><u>5.9 Overstay.</u> Upon application, Candidate must disclose illegal status of an immediate relative presently in the United States, if any. Should Candidate be denied a visa for failure to disclose to ITN that his/her immediate family members have overstayed a US visa, Candidate will not be entitled to any refund.<br> </p><p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 6. OTHER TERMS</strong></span></p><p><br>6.1 The Candidate understands that the Service Provider can cancel his/her application if the Service Provider determines that the Candidate fails to pass the requirements and eligibility based on the rules and regulations by the Service Provider, the Sponsor Organization, or US Department of State.</p><p><br>6.2 If the Candidate changes the program or the program length after placement is confirmed, the fee for a late program change in the amount of two hundred fifty US Dollar (250 USD) will be charged.</p><p><br>6.3 Candidate understands that he/she is entitled to a minimum of 32 hours of training per week, however this number may increase based on the Host Company\'s discretion.</p><p><br>6.4 The length of the Internship/Trainee program agreed upon by the Host Company and the Candidate is based solely on the Candidate\'s performance reviewed by the Host Company and does not bind the Host Company to the full term as stipulated in the Training Plan if the Candidate does not meet the Host Company professional requirements or standards. The Candidate understands if the Host Company determines that the Candidates does not perform his/her duties properly and/or the Candidate does not comply strictly with the regulations, the Host Company has the right to terminate or fire the Candidate anytime during the Internship/Trainee program. In this case the Candidate will not be entitled to receive any refund.</p><p><br>6.5 If there was a need to make changes in the program dates or for any reason the Candidate needs a re-print of Form DS 7002 and/or Form DS 2019 once it has already been generated, administrative fees for a DS reprint and the cost of shipping and handling will apply. The Service Provider will process re-issuance upon receipt of the indicated fees.<br><br>6.6 If the Host Company goes out of business, files for bankruptcy, shuts down for any reason, or terminates or lays off the Candidate for lack of commercial activity, the Service Provider will assist the Candidate in finding a new Host Company; however, it is up to the Sponsor Organization to accept or deny the change of Host Company. The Service Provider cannot guarantee that a suitable new Host Company will be found within the grace period of thirty (30) days in observance of the Sponsor Organization\'s Rules and Regulations.</p><p><br>6.7 If the Candidate would like to extend his/her training period beyond the length of the original program, the Candidate is required to notify the Service Provider about the extension at least thirty (30) days before the end of the original Internship/Trainee program\'s period.</p><p><br>6.8 Candidate agrees to indemnify and hold harmless ITN, its officers and directors, employees and its affiliates and their respective successors and assigns and each other person, if any, who controls any thereof, against any loss, liability, claim, damage and expense whatsoever (including, but not limited to, any and all expenses whatsoever reasonably incurred in investigating, preparing, or defending against any litigation commenced or threatened or any claim whatsoever) arising out of or resulting from or in connection with the services contemplated by this agreement.</p><p><br>6.9 The Candidate confirms that he/she is fit to participate in a J1 program both physically and mentally and understands that an international training experience can be stressful and require participants to stand for up to 8 hours a day as well as lift objects up to 50 pounds (depending on the position). All pre-existing medical conditions must be made known to the Service Provider in writing at the time of application. Accommodations will be made whenever possible to allow the Candidate with non-serious medical conditions to apply. The Candidate understands the medical insurance provider does not cover pre-existing medical conditions and if the Candidate requires medical treatment for pre-existing conditions after arrival during the internship/trainee program, the Candidate will be responsible for all charges and fees related to treatment.</p><p><br>If the Candidate has any physical or mental condition which could affect your ability to participate in the program, please disclose it here:</p>", 'Intern Agreement Content'),
('Trainee Agreement Content', 'trainee_itn_agreement_content', "<h3 style=\"text-align:center;\"><span style=\"background-color:hsl(0,0%,100%);\"><strong>2021 All-Inclusive Research Service Agreement</strong></span></h3><p><br><strong>THIS AGREEMENT</strong> is made the {DAY} of&nbsp;{MONTH} {YEAR} by and between {EV_NAME}, hereinafter called the \'Candidate\', and International Trainee Network, hereinafter called the \'Service Provider\'.</p><p><br>The Candidate understands that the ]1 Visa Program offered, applied and controlled by the Service Provider and its affiliated US Department of State designated Visa Sponsor Organization is not a work or employment program but a structured and guided work-based career training program that provides on-the-job exposure to American techniques, methodologies and expertise and enhances the Intern\'s/Trainee\'s knowledge of American society and culture.</p><p><br>Furthermore, the Candidate understands that the Service Provider is a research company specialized in helping international students and young professionals either jump-start or consolidate their careers by finding them a Host Company in the U.S. where they can carry about a practical training within their field of expertise.<br>WITNESSETH, that the Candidate and the Service Provider for the considerations named agree as follows:</p><p style=\"text-align:center;\"><br><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 1.&nbsp;&nbsp;SCOPE OF THE SERVICES</strong></span></p><p><br><u>1.1. Provider\'s Services.</u> The Service Provider will:</p><ol><li>Evaluate and determine the Candidate\'s eligibility for the J-1 Program according to the U.S. Department of<br>State\'s current regulations.</li><li>Evaluate the Candidate\'s English level.</li><li>Send the application package to be fully completed by the Candidate.</li><li>Reformat the Candidate\'s resume to the American standard.</li><li>Arrange interviews with potential Host Companies.</li><li>Prepare the Candidate for the interviews with potential Host Companies.</li><li>Negotiate the conditions of the training/internship: stipend, means of transportation and housing, if provided by the Host Company.</li><li>Prepare Form DS-7002, \"Training/Internship Placement Plan\", according to the Host Company\'s<br>specifications.</li><li>Complete and secure requisite signatures on Form DS-7002.</li><li>Prepare the Candidate\'s file to obtain the Form DS-2019, \"Certificate of Eligibility for Exchange Visitor<br>Status\", which is a prerequisite for obtaining the 31 Visa.</li><li>Prepare the Candidate with regard to their interview at the U.S. Embassy / U.S. Consulate.</li><li>Send the Candidate his/her medical insurance card valid for the duration of the DS-2019.</li><li>Assist the Candidate upon arrival by providing the \"Candidate Arrival Package\" with information regarding<br>housing, Social Security, bank account, etc.</li></ol><p><br><u>1.2. Research of Host Company. </u>The Service Provider will use its best effort to find an internship/training for the Candidate within twelve (12) weeks of receipt of the non-refundable registration fee as described in Article 4 below and all required documents.</p><p><u>1.3. Negotiation of Stipend.</u> The Service Provider guarantees to negotiate with the Host Company a paid internship/traineeship.</p><p><br><u>1.4. Processing of DS Form.</u> The Service Provider will process and issue Form DS-7002, \"Training/Internship Placement Plan\" after the Candidate has:</p><p style=\"margin-left:40px;\">a) Been accepted by the Host Company; and</p><p style=\"margin-left:40px;\">b) Provided all necessary documents requested by the Service Provider; and</p><p style=\"margin-left:40px;\">c) Satisfied the fees as described in Article 4.</p><p style=\"text-align:center;\"><br><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 2. CANDIDATE\'S OBLIGATIONS AND RESPONSIBILITIES</strong></span></p><p><br><u>2.1. Candidate\'s Obligations.</u> The Candidate agrees:</p><p style=\"margin-left:40px;\">a) To have passed all academic requirement and/or to have required work experiences and to be able to<br>provide the Service Provider with all supportive documents for education and work experience stated on<br>his/her resume.</p><p style=\"margin-left:40px;\">b) To attend all interviews, including telephonic or Skype interviews, at the pre-arranged time that have been<br>organized by the Service Provider.</p><p style=\"margin-left:40px;\">c) To not decline more than two (2) interviews with potential Host Companies.</p><p style=\"margin-left:40px;\">d) To accept the position that was offered to him/her by a Host Company after a successful interview. The<br>Candidate understands that he/she needs to do research about the Host Company before accepting an interview, once the Candidate has accepted to interview with a Host Company, he/she has to accept the position if the interview is successful. Declining of the offer and the position after a successful interview will<br>be subject to an administrative fee as described in Article 5.1.</p><p style=\"margin-left:40px;\">e) To provide all necessary/requested documentation in a timely manner.</p><p style=\"margin-left:40px;\">f) To submit payment of the program fees in a timely manner (The due date will be indicated on an invoice)</p><p style=\"margin-left:40px;\">g) To secure his/her housing before arrival in the United States unless provided by the Host Company for the<br>duration of the intern/trainee\'s stay in the USA.</p><p style=\"margin-left:40px;\">h) To study the medial insurance brochures provided by the Service Provider and examine medical insurance<br>coverage before arrival. Pre-existing conditions that might affect his/her internship/traineeship must be<br>disclosed in below Article 6.6.</p><p style=\"margin-left:40px;\">i) To observe and respect the American culture and comply with all laws and regulations of the USA (included<br>but not limited to all laws in relation to the Exchange Visitor Program) as well as the Host Company\'s internal<br>regulations.</p><p style=\"margin-left:40px;\">j) To perform his/her duties during his/her training period at a high standard and with all due skills, care and<br>attention with regard to the level of the knowledge, experience or education the Candidate has represented to the Service Provider he or she possesses.</p><p><br><u>2.2. Candidate\'s Responsibilities. </u>The Candidate is responsible and liable for:</p><p style=\"margin-left:40px;\">a) All transportation costs to, from and within the USA.</p><p style=\"margin-left:40px;\">b) All of his/her living expenses such as food, transportation and housing unless provided by the Host Company for the duration of the intern/trainee\'s stay in the USA.</p><p style=\"margin-left:40px;\">c) All medical expenses and bills except the medical insurance provided by the Sponsor Organization. d) Reading all emails, documents, agreements, informational handouts and guidebooks provided to the Candidate by the Service&nbsp;Provider and/or its affiliated Sponsor Organization.</p><p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 3. TERMS OF THE AGREEMENT</strong></span></p><p><br><u>3.1 Commencement of the Agreement. </u>This Agreement will commence when the Service Provider receives from the Candidate a full payment of the registration fees as described in Article 4 below.<br> </p><p><u>3.2. Termination of the Agreement. </u>This Agreement will end on the Internship/Training Program termination date or as otherwise terminated in accordance with the provisions of this Agreement.</p><p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 4. FEES</strong></span></p><p><u>4.1. Fee Structure</u>. The fee structure is as follows. Candidate must check the box next to the program type he/she is selecting. If Candidate is open to multiple program types Candidate must check ALL program types that apply.</p><p> </p><figure class=\"table\"><table><tbody><tr><td> </td><td colspan=\"2\"><p style=\"text-align:center;\"><strong>Description</strong></p></td><td><p style=\"text-align:center;\">Amount</p></td><td><p style=\"text-align:center;\">Select Program</p></td></tr><tr><td><p style=\"text-align:center;\"><strong>Registration Fee</strong></p></td><td colspan=\"2\">It is non-refundable and non-applicable to the Program Fee. It covers the Service Provider\'s<br>administrative costs to start the research for a Host Company on behalf of the Candidate.</td><td><p style=\"text-align:center;\">75 USD</p></td><td> </td></tr><tr><td><p style=\"text-align:center;\"><strong>5.1 - 8 months Program Fee</strong></p></td><td><p style=\"text-align:center;\"><strong>Full Payment Option</strong></p></td><td>It covers the services described in Article 1.1 and the medical insurance and DS Forms for the duration of the program.</td><td><p style=\"text-align:center;\">3,595 USD</p></td><td> </td></tr><tr><td><p style=\"text-align:center;\"><strong>8.1 - 12 months Program Fee</strong></p></td><td><p style=\"text-align:center;\"><strong>Full Payment Option</strong></p></td><td>It covers the services described in Article 1.1 and the medical insurance and DS Forms for the duration of the program.</td><td><p style=\"text-align:center;\">3,995 USD</p></td><td> </td></tr><tr><td rowspan=\"3\"><strong>6+6 Program Fee</strong></td><td><p style=\"text-align:center;\"><strong>Full Payment Option</strong></p></td><td>It covers the services described in Article 1.1 and the medical insurance and DS Forms for the duration of the program.</td><td><p style=\"text-align:center;\">4,295 USD</p></td><td> </td></tr><tr><td rowspan=\"2\"><p style=\"text-align:center;\"><strong>Installment Payment Option</strong></p></td><td>The Candidate will pay the first installment for the program before arrival It covers the services described in Article 1.1</td><td><p style=\"text-align:center;\">2,925 USD</p></td><td> </td></tr><tr><td><p>The Second Installment of the Program Fee secures placement and covers the continuance of Form DS 2019 and medical insurance.</p><p><u>A payment plan will not be offered to the second installment payment.</u></p><p> </p><p>The Candidate must understand and agree that if he/she does not remit payment, he/she may be terminated from the J-1 Program and</p><p>will have to return to his/her home country immediately. You will need to clear off your balance in any occasion including early leaving due</p><p>to withdrawing from the internship program or a termination from a Host Company</p><p> </p><p> </p></td><td><p style=\"text-align:center;\">1,370 USD</p><p style=\"text-align:center;\">Due on three months</p><p style=\"text-align:center;\">after arrival to the US</p></td><td> </td></tr></tbody></table></figure><p><u>4.2 Excluded Fees.</u> The Embassy fee and the SEVIS fee required to train in the United States are not included in the above indicated fee. The Embassy fee will be paid by the Candidate directly to the Embassy. The SEVIS fee will be collected by the Service Provider with the above program fee. The SEVIS fee will be submitted to U.S. Immigration and Customs Enforcement to create the Candidate\'s profile on the SEVIS system upon the process of the Form DS 7002 and no refund will be issued once the SEVIS fee is submitted to U.S. Immigration and Customs Enforcement.</p><p style=\"text-align:center;\"><br><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 5. REFUND POLICY</strong></span></p><p><u>5.1 Withdrawal After Placement is Confirmed.</u> If the Candidate cancels the placement or withdraws from the program due to any reason after a successful interview with the Host Company and receipt of the notification the Candidate will be entitled to a refund of the program fee minus One Thousand US Dollars (1,000.00 USD) which will be withheld and account for the administrative fees of the Service Provider and the Sponsor Organization. If the Candidate fails to satisfy the pre-arrival liabilities described in Article 2 and/or if the Candidate is unable to continue the program due to any academic reasons attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate and the administrative fees will be billed. The refund will be processed within 30 days after receipt of the refund request.</p><p><br><u>5.2 Withdrawal After Placement is Confirmed due to COVID-19.</u> If the Candidate cancels the placement or withdraws from the program due to COVID-19 after a successful interview with the Host Company and<br>receipt of the notification that confirms his/her Placement, the Candidate will not be entitled to any refund. The Candidate will be re-placed at a new Host Company by ITN based on his/her preferences and eligibility requirements.<br> </p><p><u>5.3 Withdrawal After Issuance of Form DS-7002. </u>If the Candidate cancels the placement or withdraws from the program due to any reason after the issuance of Form DS-7002 with the SEVIS number, the Candidate will not be entitled to any refund. If the Candidate fails to satisfy the pre-arrival liabilities described in Article 2 and/or if the Candidate is unable to continue the program due to any academic reasons attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate.<br> </p><p><u>5.4 Withdrawal After Issuance of Form DS-7002 due to COVID-19.</u> If the Candidate cancels the placement or withdraws from the program due to COVID-19 after the issuance of Form DS-7002 with the SEVIS number, the Candidate will not be entitled to any refund. The Candidate will be re-placed at a new Host Company by ITN based on his/her preferences and eligibility requirements.<br> </p><p><u>5.5 Embassy/Consulate Denial.</u> In case of a visa denial at the US Embassy, the Candidate must inform the Service Provider within 3 business days of denial and return the original Form DS-2019 and proof of denial from the Embassy or Consulate within 10 business days from the date of denial in order to be eligible to refunds. The Candidate will be entitled to a refund of the program fee minus One Thousand US Dollars (1,000.00 USD) which will be withheld and account for the administrative fees of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request. No refund will be issued if the documents are returned after the stipulated deadline or if the documents are not returned to the Service Provider.<br> </p><p><u>5.6 Embassy/Consulate Delays.</u> ITN cannot not be held financially responsible for any delays at the US Embassy/Consulate level that are beyond ITN\'s control. These delays include but are not limited to: visa denial, lack of availability for an appointment at local US Embassy/Consulate and cancellation of schedule by the Embassy/Consulate that may sometimes result in shorter programs. In such a case, ITN will not refund any amount for any loss of program time.<br> </p><p><u>5.7 Cancellation by the Host Company. </u>If the Host Company cancels the placement or withdraws from the program prior to the start date of the Candidate\'s program stated on Form DS 7002/2019, the Service Provider will, to its best efforts, try to relocate the Candidate with another Host Company. If the Candidate declines another interview with potential Host Companies for a re-placement or withdraws from the program after accepted for a replacement with another Host Company, the Candidate will be entitled to a refund of the program fee minus One Thousand US Dollars (1,000.00 USD) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request.<br> </p><p><u>5.8 Cancellation by the Host Company due to COVID-19.</u> If the Host Company cancels the placement or withdraws from the program prior to the start date of the Candidate\'s program stated on Form DS 7002/2019, ITN will re-place the Candidate at a new Host Company based on his/her preferences and eligibility requirements.<br> </p><p><u>5.9 Cancellation due to Ineligibility.</u> If the Candidate is found to be ineligible after placement due to incorrect information on his/her resume the Candidate will be entitled to a refund of the program fee minus One Thousand US Dollars (1,000.00 USD) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request.<br> </p><p><u>5.10 Cancellation by the Sponsor Organization. </u>If the Sponsor Organization cancels the program before the start date of the Candidate\'s program which is stated on Form DS 7002/2019, the Service Provider will, to its best efforts, try to relocate the Candidate with another Host Company. If the Candidate declines another interview with potential Host Companies for a re-placement or withdraws from the program after accepted for a re-placement with another Host Company, the Candidate will be entitled to a refund of the program fee minus One Thousand US Dollars (1,000.00 USD) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request. If the Sponsor Organization determines the Candidate does not comply with the Rules and Regulations for the Exchange Visitor Program or standards by the Host Company and cancels the program after arrival the Candidate will not be entitled to any refund.<br> </p><p><u>5.11 Cancellation After Arrival in the United States. </u>If the Candidate withdraws from the program or is unable to continue the program due to any reason after arrival in the US or if the Candidate is laid off or fired by the Host Company, the Candidate will not be entitled to any refund.<br> </p><p><u>5.12 Overstay. </u>Upon application, Candidate must disclose illegal status of an immediate relative presently in the United States, if any. Should Candidate be denied a visa for failure to disclose to ITN that his/her immediate family members have overstayed a US visa, Candidate will not be entitled to any refund.</p><p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 6. OTHER TERMS</strong></span></p><p><br>6.1 The Candidate understands that the Service Provider can cancel his/her application if the Service Provider determines that the Candidate fails to pass the requirements and eligibility based on the rules and regulations by the Service Provider, the Sponsor Organization, or US Department of State.</p><p><br>6.2 If the Candidate changes the program or the program length after placement is confirmed, the fee for a late program change in the amount of two hundred fifty US Dollar (250 USD) will be charged.<br> </p><p>6.3 Candidate understands that he/she is entitled to a minimum of 32 hours of training per week, however this number may increase based on the Host Company\'s discretion.<br> </p><p>6.4 The length of the Internship/Trainee program agreed upon by the Host Company and the Candidate is based solely on the Candidate\'s performance reviewed by the Host Company and does not bind the Host Company to the full term as stipulated in the Training Plan if the Candidate does not meet the Host Company professional requirements or standards. The Candidate understands if the Host Company determines that the Candidates does not perform his/her duties properly and/or the Candidate does not comply strictly with the regulations, the Host Company has the right to terminate or fire the Candidate anytime during the Internship/Trainee program. In this case the Candidate will not be entitled to receive any refund.<br> </p><p>6.5 If there was a need to make changes in the program dates or for any reason the Candidate needs a re-print of Form DS 7002 and/or Form DS 2019 once it has already been generated, administrative fees for a DS reprint and the cost of shipping and handling will apply. The Service Provider will process re-issuance upon receipt of the indicated fees.<br> </p><p>6.6 If the Host Company goes out of business, files for bankruptcy, shuts down for any reason, or terminates or lays off the Candidate for lack of commercial activity, the Service Provider will assist the Candidate in finding a new Host Company; however, it is up to the Sponsor Organization to accept or deny the change of Host Company. The Service Provider cannot guarantee that a suitable new Host Company will be found within the grace period of thirty (30) days in observance of the Sponsor Organization\'s Rules and Regulations.<br> </p><p>6.7 If the Candidate would like to extend his/her training period beyond the length of the original program, the Candidate is required to notify the Service Provider about the extension at least thirty (30) days before the end of the original internship/Trainee program\'s period.<br> </p><p>6.8 Candidate agrees to indemnify and hold harmless ITN, its officers and directors, employees and its affiliates and their respective successors and assigns and each other person, if any, who controls any thereof, against any loss, liability, claim, damage and expense whatsoever (including, but not limited to, any and all expenses whatsoever reasonably incurred in investigating, preparing, or defending against any litigation commenced or threatened or any claim whatsoever) arising out of or resulting from, or in connection with the services contemplated by this agreement.<br> </p><p>6.9 The Candidate confirms that he/she is fit to participate in a J1 program both physically and mentally and understands that an international training experience can be stressful and require participants to stand for up to 8 hours a day as well as lift objects up to 50 pounds (depending on the position). All pre-existing medical conditions must be made known to the Service Provider in writing at the time of application. Accommodations will be made whenever possible to allow the Candidate with non-serious medical conditions to apply. The Candidate understands the medical insurance provider does not cover pre-existing medical conditions and if the Candidate requires medical treatment for pre-existing conditions after arrival during the internship/trainee program, the Candidate will be responsible for all charges and fees related to treatment.<br><br>If the Candidate has any physical or mental condition which could affect your ability to participate in the program, please disclose it here:</p>", 'Trainee Agreement Content');

--------------------------------------------------------------------------------------------------------------
--Hetal Visaveliya (11th Jan 2022)
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, '1', '33', '4', '8');
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, '2', '33', '4', '8');
----------------------------------------------------------------------------------------------------------------------
--Ishit Tankaria (17th Jan 2022)
UPDATE `system_settings` 
SET `value` = "<h3 style=\"text-align:center;\"><span style=\"background-color:hsl(0,0%,100%);\"><strong>2020 AHA All-Inclusive Research Service Agreement - 8.1 to 12 months</strong></span><br> </h3><p><strong>THIS AGREEMENT</strong> is made the<strong>{DAY}</strong> of <strong>{MONTH} {YEAR}</strong> by and between <strong>{EV_NAME}</strong>, hereinafter called the \'Candidate\' and International Trainee Network, hereinafter called the \'Service Provider\'.</p><p> </p><p>The Candidate understands that the J1 Visa Program offered, applied and controlled by the Service Provider and its affiliated US Department of State designated Visa Sponsor Organization is not a work or employment program but a structured and guided work-based career training program that provides on-the-job exposure to American techniques, methodologies and expertise and enhances the Intern\'s/Trainee\'s knowledge of American society and culture.</p><p>Furthermore, the Candidate understands that the Service Provider is a research company specialized in helping international students and young professionals either jump-start or consolidate their careers by finding them a Host Company in the U.S. where they can carry about a practical training within their field of expertise.</p>
<p>WITNESSETH, that the Candidate and the Service Provider for the considerations named agree as follows:</p><p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 1 . SCOPE OF THE SERVICES</strong></span></p><p><br><u>1.1. Provider\'s Services.</u> The Service Provider will:</p><ol><li>Evaluate and determine the Candidate\'s eligibility for the J-1 Program according to the U.S. Department of<br>State\'s current regulations.</li><li>Evaluate the Candidate\'s English level.</li><li>Send the application package to be fully completed by the Candidate.</li><li>Reformat the Candidate\'s resume to the American standard.</li><li>Arrange interviews with potential Host Companies.</li><li>Prepare the Candidate for the interviews with potential Host Companies.</li><li>Negotiate the conditions of the training/internship: stipend, means of transportation and housing, if<br>provided by the Host Company.</li><li>Prepare Form DS-7002, \"Training/Internship Placement Plan\", according to the Host Company\'s specifications.</li><li>Complete and secure requisite signatures on Form DS-7002.</li><li>Prepare the Candidate\'s file to obtain the Form DS-2019, \"Certificate of Eligibility for Exchange Visitor Status\", which is a prerequisite for obtaining the J1 Visa.</li><li>Prepare the Candidate with regard to their interview at the U.S. Embassy / U.S. Consulate.</li><li>Send the Candidate his/her medical insurance card valid for the duration of the DS-2019.</li><li>Assist the Candidate upon arrival by providing the \"Candidate Arrival Package\" with information regarding housing, Social Security, bank account, etc</li></ol><p><u>1.2. Research of Host Company.</u> The Service Provider will use its best effort to find an internship/training for the Candidate within twelve (12) weeks of receipt of the non-refundable registration fee as described in Article 4 below and all required documents.</p><p><br>
<u>1.3. Negotiation of Stipend. </u>The Service Provider guarantees to negotiate with the Host Company a paid internship/traineeship,<br><u>1.4. Processing of DS Form.</u> The Service Provider will process and issue Form DS-7002, \"Training/Internship Placement Plan\" after the Candidate has:</p><ol style=\"list-style-type:lower-latin;\"><li>Been accepted by the Host Company; and</li><li>Provided all necessary documents requested by the Service Provider; and</li><li>Satisfied the fees as described in Article 4.</li></ol>
<p style=\"text-align:center;\"><br><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 2. CANDIDATE\'S OBLIGATIONS AND RESPONSIBILITIES</strong></span></p><p><br><u>2.1. Candidate\'s Obligations. </u>The Candidate agrees:</p><ol style=\"list-style-type:lower-latin;\"><li>To have passed all academic requirement and/or to have required work experiences and to be able to<br>provide the Service Provider with all supportive documents for education and work experience stated on<br>his/her resume.</li><li>To attend all interviews, including telephonic or Skype interviews, at the pre-arranged time that have<br>been organized by the Service Provider.</li><li>To not decline more than two (2) interviews with potential Host Companies.</li><li>To accept the position that was offered to him/her by a Host Company after a successful interview. The<br>Candidate understands that he/she needs to do research about the Host Company before accepting an interview, once the Candidate has accepted to interview with a Host Company, he/she has to accept the position if the interview is successful. Declining of the offer and the position after a successful interview<br>will be subject to an administrative fee as described in Article 5.1.</li><li>To provide all necessary/requested documentation in a timely manner.</li><li>To submit payment of the program fees in a timely manner (The due date will be indicated on an invoice)</li><li>To secure his/her housing before arrival in the United States unless provided by the Host Company for the<br>duration of the intern/trainee\'s stay in the USA.</li><li>To study the medial insurance brochures provided by the Service Provider and examine medical insurance<br>coverage before arrival. Pre-existing conditions that might affect his/her internship/traineeship must be<br>disclosed in below Article 6.6.</li><li>To observe and respect the American culture and comply with all laws and regulations of the USA<br>(included but not limited to all laws in relation to the Exchange Visitor Program) as well as the Host<br>Company\'s internal regulations.</li><li>To perform his/her duties during his/her training period at a high standard and with all due skills, care and<br>attention with regard to the level of the knowledge, experience or education the Candidate has represented to the Service Provider he or she possesses.</li></ol><p><u>2.2. Candidate\'s Responsibilities.</u> The Candidate is responsible and liable for:</p><ol style=\"list-style-type:lower-latin;\"><li>All transportation costs to, from and within the USA.</li><li>All of his/her living expenses such as food, transportation and housing unless provided by the Host<br>Company for the duration of the intern/trainee\'s stay in the USA.</li><li>All medical expenses and bills except the medical insurance provided by the Sponsor Organization.</li><li>Reading all emails, documents, agreements, informational handouts and guidebooks provided to the Candidate by the Service Provider and/or its affiliated Sponsor Organization.<br> </li></ol>
<p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 3. TERMS OF THE AGREEMENT</strong></span></p><p><br><u>3.1 Commencement of the Agreement.</u> This Agreement will commence when the Service Provider receives from the Candidate a full payment of the registration fees as described in Article 4 below.</p><p><br><u>3.2. Termination of the Agreement.</u> This Agreement will end on the Internship/Training Program termination date or as otherwise terminated in accordance with the provisions of this Agreement.</p><p> </p>
<p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 4. FEES</strong></span></p><p><u>4.1. Fee Structure. </u>The fee structure is as follows:</p><figure class=\"table\"><table><tbody><tr><td> </td><td colspan=\"2\"><p style=\"text-align:center;\"><strong>Description</strong></p></td><td><strong>Amount</strong></td></tr><tr><td><p style=\"text-align:center;\"><strong>Registration</strong><br><strong>Fee</strong></p></td><td colspan=\"2\">It is non-refundable and non-applicable to the Program Fee. It covers the Service Provider\'s administrative costs to start the research for a Host Company on behalf of the Candidate.</td><td>{REG_FEE} {CURRENCY}</td></tr><tr><td rowspan=\"3\"><p style=\"text-align:center;\"><strong>Program</strong><br><strong>Fee</strong></p></td><td><p style=\"text-align:center;\"><strong>Full Payment Option</strong></p></td><td>It covers the services described in Article 1.1 and the medical insurance and DS Forms for the duration of the program.</td><td>{PROG_FEE} {CURRENCY}</td></tr><tr><td rowspan=\"2\"><p style=\"text-align:center;\"><strong>Installment Payment Option</strong></p></td><td>The Candidate will pay the initial deposit for the program before arrival It covers the services described in Article 1.1</td><td rowspan=\"2\">{CURRENCY_SYMBOL}100 every two weeks</td></tr><tr><td><p>The Candidate will remit payment every two weeks upon arrival for the duration of the program stated on his/her DS 2019. The Candidate will have to set up an automated payment through his/her American debit/credit card upon arrival in the United States.</p><p>The Candidate must understand and agree that if he/she stops payment, he/she will be terminated from the J1 Program and will have to return to his/her home country immediately. You will need to clear off your reaming balance in any occasion including withdrawing from the internship program or leaving early. The Candidate must understand and agree that if he/she stops payment, he/she will be terminated from the J1 Program and will have to return to his/her home country immediately. You will need to clear off your reaming balance in any occasion including withdrawing from the internship program or leaving early.</p></td></tr></tbody></table></figure><p><br><u>4.2 Excluded Fees. </u>The Embassy fee and the SEVIS fee required to train in the United States are not included in the above indicated fee. The Embassy fee will be paid by the Candidate directly to the Embassy. The SEVIS fee will be collected by the Service Provider with the above program fee. The SEVIS fee will be submitted to U.S. Immigration and Customs Enforcement to create the Candidate\'s profile on the SEVIS system upon the process of the Form DS 7002 and no refund will be issued once the SEVIS fee is submitted to U.S. Immigration and Customs Enforcement.</p>
<p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 5. REFUND POLICY</strong></span></p><p><br><u>5.1 Withdrawal After Placement is confirmed.</u> If the Candidate cancels the placement or withdraws from the program due to any reason after a successful interview with the Host Company and receipt of the notification the Candidate will be entitled to a refund of the program fee minus Five<br>Hundred and Ninety-Five US Dollars (595.00 {CURRENCY}) which will be withheld and account for the administrative fees of the Service Provider and the Sponsor Organization. If the Candidate fails to satisfy the pre-arrival liabilities described in Article 2 and/or if the Candidate is unable to continue the program due to any academic reasons attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate and the administrative fees will be billed. The refund will be processed within 30 days after receipt of the refund request.</p><p><br>
<u>5.2 Withdrawal After Issuance of Form DS-7002.</u> If the Candidate cancels the placement or withdraws from the program due to any reason after the issuance of Form DS-7002 with the SEVIS number, the Candidate will not be entitled to any refund. If the Candidate fails to satisfy the pre-arrival liabilities described in Article 2 and/or if the Candidate is unable to continue the program due to any academic reasons attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate.<br> </p><p><u>5.3 Embassy/Consulate Denial. </u>In case of a visa denial at the US Embassy, the Candidate must inform the Service Provider within 3 business days of denial and return the original Form DS-2019 and proof of denial from the Embassy or Consulate within 10 business days from the date of denial in order to be eligible to refunds. The Candidate will be entitled to a refund of the program fee minus Five Hundred and Ninety-Five US Dollars (595.00 {CURRENCY}) which will be withheld and account for the administrative fees of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request. No refund will be issued if the documents are returned after the stipulated deadline or if the documents are not returned to the Service Provider.<br> </p><p><u>5.4. Embassy/Consulate Delays. </u>ITN cannot not be held financially responsible for any delays at the US Embassy/Consulate level that are beyond ITN\'s control. These delays include but are not limited to: visa denial, lack of availability for an appointment at local US Embassy/Consulate and cancellation of schedule by the Embassy/Consulate that may sometimes result in shorter programs. In such a case, ITN will not refund any amount for any loss of program time.<br> </p><p><u>5.5 Cancellation by the Host Company.</u> If the Host Company cancels the placement or withdraws from the program prior to the start date of the Candidate\'s program stated on Form DS 7002/2019, the Service Provider will, to its best efforts, try to relocate the Candidate with another Host Company. If the Candidate declines another interview with potential Host Companies for a re-placement or withdraws from the program after accepted for a re-placement with another Host Company, the Candidate will be entitled to a refund of the program fee minus Five Hundred and Ninety-Five US Dollars (595.00 {CURRENCY}) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request.<br> </p><p><u>5.6 Cancellation due to Ineligibility.</u> If the Candidate is found to be ineligible after placement due to incorrect information on his/her resume the Candidate will be entitled to a refund of the program fee minus Five Hundred and Ninety-Five US Dollars (595.00 {CURRENCY}) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request.<br><br><u>5.7 Cancellation by the Sponsor Organization. </u>If the Sponsor Organization cancels the program before the start date of the Candidate\'s program which is stated on Form DS 7002/2019, the Service Provider will, to its best efforts, try to relocate the Candidate with another Host Company. If the Candidate declines another interview with potential Host Companies for a re-placement or withdraws from the program after accepted for a replacement with another Host Company, the Candidate will be entitled to a refund of the program fee minus Five Hundred and Ninety-Five US Dollars (595.00 {CURRENCY}) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request. If the Sponsor Organization determines the Candidate does not comply with the Rules and Regulations for the Exchange Visitor Program or standards by the Host Company and cancels the program after arrival the Candidate will not be entitled to any refund.<br> </p><p><u>5.8 Cancellation After Arrival in the United States.</u> If the Candidate withdraws from the program or is unable to continue the program due to any reason after arrival in the US or if the Candidate is laid off or fired by the Host Company, the Candidate will not be entitled to any refund.<br> </p><p>
<u>5.9 Overstay.</u> Upon application, Candidate must disclose illegal status of an immediate relative presently in the United States, if any. Should Candidate be denied a visa for failure to disclose to ITN that his/her immediate family members have overstayed a US visa, Candidate will not be entitled to any refund.<br> </p>
<p style=\"text-align:center;\"><span style=\"color:hsl(210,75%,60%);\"><strong>ARTICLE 6. OTHER TERMS</strong></span></p><p><br>6.1 The Candidate understands that the Service Provider can cancel his/her application if the Service Provider determines that the Candidate fails to pass the requirements and eligibility based on the rules and regulations by the Service Provider, the Sponsor Organization, or US Department of State.</p><p><br>6.2 If the Candidate changes the program or the program length after placement is confirmed, the fee for a late program change in the amount of two hundred fifty US Dollar (250 {CURRENCY}) will be charged.</p><p><br>6.3 Candidate understands that he/she is entitled to a minimum of 32 hours of training per week, however this number may increase based on the Host Company\'s discretion.</p><p><br>6.4 The length of the Internship/Trainee program agreed upon by the Host Company and the Candidate is based solely on the Candidate\'s performance reviewed by the Host Company and does not bind the Host Company to the full term as stipulated in the Training Plan if the Candidate does not meet the Host Company professional requirements or standards. The Candidate understands if the Host Company determines that the Candidates does not perform his/her duties properly and/or the Candidate does not comply strictly with the regulations, the Host Company has the right to terminate or fire the Candidate anytime during the Internship/Trainee program. In this case the Candidate will not be entitled to receive any refund.</p><p><br>6.5 If there was a need to make changes in the program dates or for any reason the Candidate needs a re-print of Form DS 7002 and/or Form DS 2019 once it has already been generated, administrative fees for a DS reprint and the cost of shipping and handling will apply. The Service Provider will process re-issuance upon receipt of the indicated fees.<br><br>6.6 If the Host Company goes out of business, files for bankruptcy, shuts down for any reason, or terminates or lays off the Candidate for lack of commercial activity, the Service Provider will assist the Candidate in finding a new Host Company; however, it is up to the Sponsor Organization to accept or deny the change of Host Company. The Service Provider cannot guarantee that a suitable new Host Company will be found within the grace period of thirty (30) days in observance of the Sponsor Organization\'s Rules and Regulations.</p><p><br>6.7 If the Candidate would like to extend his/her training period beyond the length of the original program, the Candidate is required to notify the Service Provider about the extension at least thirty (30) days before the end of the original Internship/Trainee program\'s period.</p><p><br>6.8 Candidate agrees to indemnify and hold harmless ITN, its officers and directors, employees and its affiliates and their respective successors and assigns and each other person, if any, who controls any thereof, against any loss, liability, claim, damage and expense whatsoever (including, but not limited to, any and all expenses whatsoever reasonably incurred in investigating, preparing, or defending against any litigation commenced or threatened or any claim whatsoever) arising out of or resulting from or in connection with the services contemplated by this agreement.</p><p><br>6.9 The Candidate confirms that he/she is fit to participate in a J1 program both physically and mentally and understands that an international training experience can be stressful and require participants to stand for up to 8 hours a day as well as lift objects up to 50 pounds (depending on the position). All pre-existing medical conditions must be made known to the Service Provider in writing at the time of application. Accommodations will be made whenever possible to allow the Candidate with non-serious medical conditions to apply. The Candidate understands the medical insurance provider does not cover pre-existing medical conditions and if the Candidate requires medical treatment for pre-existing conditions after arrival during the internship/trainee program, the Candidate will be responsible for all charges and fees related to treatment.</p><p><br>If the Candidate has any physical or mental condition which could affect your ability to participate in the program, please disclose it here:</p>" 
WHERE `system_settings`.`field` = 'intern_itn_agreement_content';

UPDATE `system_settings` 
SET `value` = "<h3 style="text-align:center;"><span style="background-color:hsl(0,0%,100%);"><strong>2021 All-Inclusive Research Service Agreement</strong></span></h3><p><br><strong>THIS AGREEMENT</strong> is made the {DAY} of&nbsp;{MONTH} {YEAR} by and between {EV_NAME}, hereinafter called the 'Candidate', and International Trainee Network, hereinafter called the 'Service Provider'.</p><p><br>The Candidate understands that the ]1 Visa Program offered, applied and controlled by the Service Provider and its affiliated US Department of State designated Visa Sponsor Organization is not a work or employment program but a structured and guided work-based career training program that provides on-the-job exposure to American techniques, methodologies and expertise and enhances the Intern's/Trainee's knowledge of American society and culture.</p><p><br>Furthermore, the Candidate understands that the Service Provider is a research company specialized in helping international students and young professionals either jump-start or consolidate their careers by finding them a Host Company in the U.S. where they can carry about a practical training within their field of expertise.<br>WITNESSETH, that the Candidate and the Service Provider for the considerations named agree as follows:</p>
<p style="text-align:center;"><br><span style="color:hsl(210,75%,60%);"><strong>ARTICLE 1.&nbsp;&nbsp;SCOPE OF THE SERVICES</strong></span></p><p><br><u>1.1. Provider's Services.</u> The Service Provider will:</p><ol><li>Evaluate and determine the Candidate's eligibility for the J-1 Program according to the U.S. Department of<br>State's current regulations.</li><li>Evaluate the Candidate's English level.</li><li>Send the application package to be fully completed by the Candidate.</li><li>Reformat the Candidate's resume to the American standard.</li><li>Arrange interviews with potential Host Companies.</li><li>Prepare the Candidate for the interviews with potential Host Companies.</li><li>Negotiate the conditions of the training/internship: stipend, means of transportation and housing, if provided by the Host Company.</li><li>Prepare Form DS-7002, "Training/Internship Placement Plan", according to the Host Company's<br>specifications.</li><li>Complete and secure requisite signatures on Form DS-7002.</li><li>Prepare the Candidate's file to obtain the Form DS-2019, "Certificate of Eligibility for Exchange Visitor<br>Status", which is a prerequisite for obtaining the 31 Visa.</li><li>Prepare the Candidate with regard to their interview at the U.S. Embassy / U.S. Consulate.</li><li>Send the Candidate his/her medical insurance card valid for the duration of the DS-2019.</li><li>Assist the Candidate upon arrival by providing the "Candidate Arrival Package" with information regarding<br>housing, Social Security, bank account, etc.</li></ol><p><br><u>1.2. Research of Host Company. </u>The Service Provider will use its best effort to find an internship/training for the Candidate within twelve (12) weeks of receipt of the non-refundable registration fee as described in Article 4 below and all required documents.</p><p><u>1.3. Negotiation of Stipend.</u> The Service Provider guarantees to negotiate with the Host Company a paid internship/traineeship.</p><p><br><u>1.4. Processing of DS Form.</u> The Service Provider will process and issue Form DS-7002, "Training/Internship Placement Plan" after the Candidate has:</p><p style="margin-left:40px;">a) Been accepted by the Host Company; and</p><p style="margin-left:40px;">b) Provided all necessary documents requested by the Service Provider; and</p><p style="margin-left:40px;">c) Satisfied the fees as described in Article 4.</p>
<p style="text-align:center;"><br><span style="color:hsl(210,75%,60%);"><strong>ARTICLE 2. CANDIDATE'S OBLIGATIONS AND RESPONSIBILITIES</strong></span></p><p><br><u>2.1. Candidate's Obligations.</u> The Candidate agrees:</p><p style="margin-left:40px;">a) To have passed all academic requirement and/or to have required work experiences and to be able to<br>provide the Service Provider with all supportive documents for education and work experience stated on<br>his/her resume.</p><p style="margin-left:40px;">b) To attend all interviews, including telephonic or Skype interviews, at the pre-arranged time that have been<br>organized by the Service Provider.</p><p style="margin-left:40px;">c) To not decline more than two (2) interviews with potential Host Companies.</p><p style="margin-left:40px;">d) To accept the position that was offered to him/her by a Host Company after a successful interview. The<br>Candidate understands that he/she needs to do research about the Host Company before accepting an interview, once the Candidate has accepted to interview with a Host Company, he/she has to accept the position if the interview is successful. Declining of the offer and the position after a successful interview will<br>be subject to an administrative fee as described in Article 5.1.</p><p style="margin-left:40px;">e) To provide all necessary/requested documentation in a timely manner.</p><p style="margin-left:40px;">f) To submit payment of the program fees in a timely manner (The due date will be indicated on an invoice)</p><p style="margin-left:40px;">g) To secure his/her housing before arrival in the United States unless provided by the Host Company for the<br>duration of the intern/trainee's stay in the USA.</p><p style="margin-left:40px;">h) To study the medial insurance brochures provided by the Service Provider and examine medical insurance<br>coverage before arrival. Pre-existing conditions that might affect his/her internship/traineeship must be<br>disclosed in below Article 6.6.</p><p style="margin-left:40px;">i) To observe and respect the American culture and comply with all laws and regulations of the USA (included<br>but not limited to all laws in relation to the Exchange Visitor Program) as well as the Host Company's internal<br>regulations.</p><p style="margin-left:40px;">j) To perform his/her duties during his/her training period at a high standard and with all due skills, care and<br>attention with regard to the level of the knowledge, experience or education the Candidate has represented to the Service Provider he or she possesses.</p><p><br><u>2.2. Candidate's Responsibilities. </u>The Candidate is responsible and liable for:</p><p style="margin-left:40px;">a) All transportation costs to, from and within the USA.</p><p style="margin-left:40px;">b) All of his/her living expenses such as food, transportation and housing unless provided by the Host Company for the duration of the intern/trainee's stay in the USA.</p><p style="margin-left:40px;">c) All medical expenses and bills except the medical insurance provided by the Sponsor Organization. d) Reading all emails, documents, agreements, informational handouts and guidebooks provided to the Candidate by the Service&nbsp;Provider and/or its affiliated Sponsor Organization.</p>
<p style="text-align:center;"><span style="color:hsl(210,75%,60%);"><strong>ARTICLE 3. TERMS OF THE AGREEMENT</strong></span></p><p><br><u>3.1 Commencement of the Agreement. </u>This Agreement will commence when the Service Provider receives from the Candidate a full payment of the registration fees as described in Article 4 below.<br> </p><p><u>3.2. Termination of the Agreement. </u>This Agreement will end on the Internship/Training Program termination date or as otherwise terminated in accordance with the provisions of this Agreement.</p>
<p style="text-align:center;"><span style="color:hsl(210,75%,60%);"><strong>ARTICLE 4. FEES</strong></span></p><p><u>4.1. Fee Structure</u>. The fee structure is as follows. Candidate must check the box next to the program type he/she is selecting. If Candidate is open to multiple program types Candidate must check ALL program types that apply.</p><p> </p><figure class="table"><table><tbody><tr><td> </td><td colspan="2"><p style="text-align:center;"><strong>Description</strong></p></td><td><p style="text-align:center;">Amount</p></td><td><p style="text-align:center;">Select Program</p></td></tr><tr><td><p style="text-align:center;"><strong>Registration Fee</strong></p></td><td colspan="2">It is non-refundable and non-applicable to the Program Fee. It covers the Service Provider's<br>administrative costs to start the research for a Host Company on behalf of the Candidate.</td><td><p style="text-align:center;">{REG_FEE} {CURRENCY}</p></td><td> </td></tr><tr><td><p style="text-align:center;"><strong>5.1 - 8 months Program Fee</strong></p></td><td><p style="text-align:center;"><strong>Full Payment Option</strong></p></td><td>It covers the services described in Article 1.1 and the medical insurance and DS Forms for the duration of the program.</td><td><p style="text-align:center;">3,595 {CURRENCY}</p></td><td> </td></tr><tr><td><p style="text-align:center;"><strong>8.1 - 12 months Program Fee</strong></p></td><td><p style="text-align:center;"><strong>Full Payment Option</strong></p></td><td>It covers the services described in Article 1.1 and the medical insurance and DS Forms for the duration of the program.</td><td><p style="text-align:center;">3,995 {CURRENCY}</p></td><td> </td></tr><tr><td rowspan="3"><strong>6+6 Program Fee</strong></td><td><p style="text-align:center;"><strong>Full Payment Option</strong></p></td><td>It covers the services described in Article 1.1 and the medical insurance and DS Forms for the duration of the program.</td><td><p style="text-align:center;">4,295 {CURRENCY}</p></td><td> </td></tr><tr><td rowspan="2"><p style="text-align:center;"><strong>Installment Payment Option</strong></p></td><td>The Candidate will pay the first installment for the program before arrival It covers the services described in Article 1.1</td><td><p style="text-align:center;">2,925 {CURRENCY}</p></td><td> </td></tr><tr><td><p>The Second Installment of the Program Fee secures placement and covers the continuance of Form DS 2019 and medical insurance.</p><p><u>A payment plan will not be offered to the second installment payment.</u></p><p> </p><p>The Candidate must understand and agree that if he/she does not remit payment, he/she may be terminated from the J-1 Program and</p><p>will have to return to his/her home country immediately. You will need to clear off your balance in any occasion including early leaving due</p><p>to withdrawing from the internship program or a termination from a Host Company</p><p> </p><p> </p></td><td><p style="text-align:center;">1,370 {CURRENCY}</p><p style="text-align:center;">Due on three months</p><p style="text-align:center;">after arrival to the US</p></td><td> </td></tr></tbody></table></figure><p><u>4.2 Excluded Fees.</u> The Embassy fee and the SEVIS fee required to train in the United States are not included in the above indicated fee. The Embassy fee will be paid by the Candidate directly to the Embassy. The SEVIS fee will be collected by the Service Provider with the above program fee. The SEVIS fee will be submitted to U.S. Immigration and Customs Enforcement to create the Candidate's profile on the SEVIS system upon the process of the Form DS 7002 and no refund will be issued once the SEVIS fee is submitted to U.S. Immigration and Customs Enforcement.</p>
<p style="text-align:center;"><br><span style="color:hsl(210,75%,60%);"><strong>ARTICLE 5. REFUND POLICY</strong></span></p><p><u>5.1 Withdrawal After Placement is Confirmed.</u> If the Candidate cancels the placement or withdraws from the program due to any reason after a successful interview with the Host Company and receipt of the notification the Candidate will be entitled to a refund of the program fee minus One Thousand US Dollars (1,000.00 {CURRENCY}) which will be withheld and account for the administrative fees of the Service Provider and the Sponsor Organization. If the Candidate fails to satisfy the pre-arrival liabilities described in Article 2 and/or if the Candidate is unable to continue the program due to any academic reasons attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate and the administrative fees will be billed. The refund will be processed within 30 days after receipt of the refund request.</p><p><br><u>5.2 Withdrawal After Placement is Confirmed due to COVID-19.</u> If the Candidate cancels the placement or withdraws from the program due to COVID-19 after a successful interview with the Host Company and<br>receipt of the notification that confirms his/her Placement, the Candidate will not be entitled to any refund. The Candidate will be re-placed at a new Host Company by ITN based on his/her preferences and eligibility requirements.<br> </p><p><u>5.3 Withdrawal After Issuance of Form DS-7002. </u>If the Candidate cancels the placement or withdraws from the program due to any reason after the issuance of Form DS-7002 with the SEVIS number, the Candidate will not be entitled to any refund. If the Candidate fails to satisfy the pre-arrival liabilities described in Article 2 and/or if the Candidate is unable to continue the program due to any academic reasons attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate.<br> </p><p><u>5.4 Withdrawal After Issuance of Form DS-7002 due to COVID-19.</u> If the Candidate cancels the placement or withdraws from the program due to COVID-19 after the issuance of Form DS-7002 with the SEVIS number, the Candidate will not be entitled to any refund. The Candidate will be re-placed at a new Host Company by ITN based on his/her preferences and eligibility requirements.<br> </p><p><u>5.5 Embassy/Consulate Denial.</u> In case of a visa denial at the US Embassy, the Candidate must inform the Service Provider within 3 business days of denial and return the original Form DS-2019 and proof of denial from the Embassy or Consulate within 10 business days from the date of denial in order to be eligible to refunds. The Candidate will be entitled to a refund of the program fee minus One Thousand US Dollars (1,000.00 {CURRENCY}) which will be withheld and account for the administrative fees of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request. No refund will be issued if the documents are returned after the stipulated deadline or if the documents are not returned to the Service Provider.<br> </p><p><u>5.6 Embassy/Consulate Delays.</u> ITN cannot not be held financially responsible for any delays at the US Embassy/Consulate level that are beyond ITN's control. These delays include but are not limited to: visa denial, lack of availability for an appointment at local US Embassy/Consulate and cancellation of schedule by the Embassy/Consulate that may sometimes result in shorter programs. In such a case, ITN will not refund any amount for any loss of program time.<br> </p><p><u>5.7 Cancellation by the Host Company. </u>If the Host Company cancels the placement or withdraws from the program prior to the start date of the Candidate's program stated on Form DS 7002/2019, the Service Provider will, to its best efforts, try to relocate the Candidate with another Host Company. If the Candidate declines another interview with potential Host Companies for a re-placement or withdraws from the program after accepted for a replacement with another Host Company, the Candidate will be entitled to a refund of the program fee minus One Thousand US Dollars (1,000.00 {CURRENCY}) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request.<br> </p><p><u>5.8 Cancellation by the Host Company due to COVID-19.</u> If the Host Company cancels the placement or withdraws from the program prior to the start date of the Candidate's program stated on Form DS 7002/2019, ITN will re-place the Candidate at a new Host Company based on his/her preferences and eligibility requirements.<br> </p><p><u>5.9 Cancellation due to Ineligibility.</u> If the Candidate is found to be ineligible after placement due to incorrect information on his/her resume the Candidate will be entitled to a refund of the program fee minus One Thousand US Dollars (1,000.00 {CURRENCY}) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request.<br> </p><p><u>5.10 Cancellation by the Sponsor Organization. </u>If the Sponsor Organization cancels the program before the start date of the Candidate's program which is stated on Form DS 7002/2019, the Service Provider will, to its best efforts, try to relocate the Candidate with another Host Company. If the Candidate declines another interview with potential Host Companies for a re-placement or withdraws from the program after accepted for a re-placement with another Host Company, the Candidate will be entitled to a refund of the program fee minus One Thousand US Dollars (1,000.00 {CURRENCY}) which will be withheld and account for the administrative costs of the Service Provider and the Sponsor Organization. The refund will be processed within 30 days after receipt of the refund request. If the Sponsor Organization determines the Candidate does not comply with the Rules and Regulations for the Exchange Visitor Program or standards by the Host Company and cancels the program after arrival the Candidate will not be entitled to any refund.<br> </p><p><u>5.11 Cancellation After Arrival in the United States. </u>If the Candidate withdraws from the program or is unable to continue the program due to any reason after arrival in the US or if the Candidate is laid off or fired by the Host Company, the Candidate will not be entitled to any refund.<br> </p><p><u>5.12 Overstay. </u>Upon application, Candidate must disclose illegal status of an immediate relative presently in the United States, if any. Should Candidate be denied a visa for failure to disclose to ITN that his/her immediate family members have overstayed a US visa, Candidate will not be entitled to any refund.</p>
<p style="text-align:center;"><span style="color:hsl(210,75%,60%);"><strong>ARTICLE 6. OTHER TERMS</strong></span></p><p><br>6.1 The Candidate understands that the Service Provider can cancel his/her application if the Service Provider determines that the Candidate fails to pass the requirements and eligibility based on the rules and regulations by the Service Provider, the Sponsor Organization, or US Department of State.</p><p><br>6.2 If the Candidate changes the program or the program length after placement is confirmed, the fee for a late program change in the amount of two hundred fifty US Dollar (250 {CURRENCY}) will be charged.<br> </p><p>6.3 Candidate understands that he/she is entitled to a minimum of 32 hours of training per week, however this number may increase based on the Host Company's discretion.<br> </p><p>6.4 The length of the Internship/Trainee program agreed upon by the Host Company and the Candidate is based solely on the Candidate's performance reviewed by the Host Company and does not bind the Host Company to the full term as stipulated in the Training Plan if the Candidate does not meet the Host Company professional requirements or standards. The Candidate understands if the Host Company determines that the Candidates does not perform his/her duties properly and/or the Candidate does not comply strictly with the regulations, the Host Company has the right to terminate or fire the Candidate anytime during the Internship/Trainee program. In this case the Candidate will not be entitled to receive any refund.<br> </p><p>6.5 If there was a need to make changes in the program dates or for any reason the Candidate needs a re-print of Form DS 7002 and/or Form DS 2019 once it has already been generated, administrative fees for a DS reprint and the cost of shipping and handling will apply. The Service Provider will process re-issuance upon receipt of the indicated fees.<br> </p><p>6.6 If the Host Company goes out of business, files for bankruptcy, shuts down for any reason, or terminates or lays off the Candidate for lack of commercial activity, the Service Provider will assist the Candidate in finding a new Host Company; however, it is up to the Sponsor Organization to accept or deny the change of Host Company. The Service Provider cannot guarantee that a suitable new Host Company will be found within the grace period of thirty (30) days in observance of the Sponsor Organization's Rules and Regulations.<br> </p><p>6.7 If the Candidate would like to extend his/her training period beyond the length of the original program, the Candidate is required to notify the Service Provider about the extension at least thirty (30) days before the end of the original internship/Trainee program's period.<br> </p><p>6.8 Candidate agrees to indemnify and hold harmless ITN, its officers and directors, employees and its affiliates and their respective successors and assigns and each other person, if any, who controls any thereof, against any loss, liability, claim, damage and expense whatsoever (including, but not limited to, any and all expenses whatsoever reasonably incurred in investigating, preparing, or defending against any litigation commenced or threatened or any claim whatsoever) arising out of or resulting from, or in connection with the services contemplated by this agreement.<br> </p><p>6.9 The Candidate confirms that he/she is fit to participate in a J1 program both physically and mentally and understands that an international training experience can be stressful and require participants to stand for up to 8 hours a day as well as lift objects up to 50 pounds (depending on the position). All pre-existing medical conditions must be made known to the Service Provider in writing at the time of application. Accommodations will be made whenever possible to allow the Candidate with non-serious medical conditions to apply. The Candidate understands the medical insurance provider does not cover pre-existing medical conditions and if the Candidate requires medical treatment for pre-existing conditions after arrival during the internship/trainee program, the Candidate will be responsible for all charges and fees related to treatment.<br><br>If the Candidate has any physical or mental condition which could affect your ability to participate in the program, please disclose it here:</p>" 
WHERE `system_settings`.`field` = 'trainee_itn_agreement_content';

-----------------------------------------------------------------------------------------------------------------------------------------------------
--Hetal Visaveliya (26th January 2022) 
INSERT INTO `position_types` (`id`, `position_type_name`, `position_type_order`, `status`) VALUES (150, 'Sports camps', '', '1'), (151, 'Skills based camps', '', '1'), (152, 'Religious camps', '', '1'), (153, 'Inner city camps', '', '1'), (154, 'Traditional outdoor/overnight camps', '', '1'), (155, 'N/A - ODC Partners Filing Only', '', '1');

----------------------------------------------------------------------------------------------------------------------
--Chandresh Kukadiya(26th January 2022)
INSERT INTO `system_settings` (`id`, `name`, `field`, `value`, `description`) VALUES (NULL, 'Sponsor ASSE Agreement Content', 'sponsor_asse_agreement_content', 'content', 'Sponsors ASSE Agreement Content');

INSERT INTO `system_settings` (`id`, `name`, `field`, `value`, `description`) VALUES (NULL, 'Sponsor CENET Agreement Content', 'sponsor_cenet_agreement_content', 'content', 'Sponsors CENET Agreement Content');

INSERT INTO `system_settings` (`id`, `name`, `field`, `value`, `description`) VALUES (NULL, 'Sponsor INTRAX Agreement Content', 'sponsor_intrax_agreement_content', 'content', 'Sponsors INTRAX Agreement Content');

INSERT INTO `system_settings` (`id`, `name`, `field`, `value`, `description`) VALUES (NULL, 'Sponsor INTRAX Co-branded Agreement Content', 'sponsor_intrax_co_branded_agreement_content', 'content', 'Sponsors INTRAX Co-branded Agreement Content');

INSERT INTO `system_settings` (`id`, `name`, `field`, `value`, `description`) VALUES (NULL, 'Sponsor AAG Agreement Content', 'sponsor_aag_agreement_content', 'content', 'Sponsors AAG Agreement Content');
--------------------------------------------------------------------------------------------------------------------------------------------------
--Manisha Odedara (28 Jan 2022)
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, '3', '35', '3', '3');
-----------------------------------------------------------------------------------------------------------------------
--Chandresh Kukadiya(3rd February 2022)
UPDATE `email_notification` SET `text` = '<p>Hello there,</p>\r\n\r\n<p>New ticket generated by user, please find bellow details.</p>\r\n\r\n<p>EV Name : {{first_name}} {{last_name}} [{{email}}]</p>\r\n<p>Subject : {{subject}}</p>\r\n<p>Question : {{question}}</p>\r\n\r\nThanks' WHERE `email_notification`.`en_key` = 'send_ticket_notification_to_admins';
-----------------------------------------------------------------------------------------------------------------------
--Hetal Visaveliya (17th February 2022)
CREATE TABLE `application_activity_status` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `portfolio_id` int(11) NOT NULL,
  `as_order_key` varchar(255) NOT NULL COMMENT 'application_status_steps -> as_order_key',
  `status` tinyint(1) NOT NULL COMMENT 'Is activity step key set or not',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `application_activity_status`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `application_activity_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-----------------------------------------------------------------------------------------------------------------------
--Hetal Visaveliya (23rd February 2022)
INSERT INTO `j1_statuses` (`id`, `status_key`, `status_name`, `category`) VALUES ('3019', 'embassy-interview-rescheduled', 'US Embassy Interview Rescheduled', '3');
----------------------------------------------------------------------------------------------------------------------- 
--Chandresh Kukadiya(7th March 2022)

ALTER TABLE `ticket_details` ADD `is_send` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0 - Not send , 1 - Send in email ' AFTER `ticket_content`;
INSERT INTO `email_notification` (`id`, `en_key`, `subject`, `text`, `send_to`, `send_cc`, `status`) VALUES (NULL, 'send_ticket_reminder_to_admins', 'Pending Ticket Reply', '<p>Hello,</p>\r\n\r\n<p>{{link}}</p>\r\n\r\nThanks', '1', 'test_cc_qa@yopmail.com', '1');

----------------------------------------------------------------------------------------------------------------------- 
--Chandresh Kukadiya(16th March 2022)

UPDATE `notification_messages` SET `notification_message` = 'Ticket Response from Imix' WHERE `notification_messages`.`notification_type_key` = 'ticket_conversation';

----------------------------------------------------------------------------------------------------------------------- 
--Chandresh Kukadiya(23rd March 2022)

INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, '1', '36', '2', '2');

UPDATE `as_steps_by_dos` SET `step_order` = '3' WHERE `as_steps_by_dos`.`dos_program_category_id` = 1 AND `as_steps_by_dos`.`step_id` = 9 AND `as_steps_by_dos`.`stage_id` = 2;

UPDATE `as_steps_by_dos` SET `step_order` = '4' WHERE `as_steps_by_dos`.`dos_program_category_id` = 1 AND `as_steps_by_dos`.`step_id` = 10 AND `as_steps_by_dos`.`stage_id` = 2;

UPDATE `as_steps_by_dos` SET `step_order` = '5' WHERE `as_steps_by_dos`.`dos_program_category_id` = 1 AND `as_steps_by_dos`.`step_id` = 11 AND `as_steps_by_dos`.`stage_id` = 2;

UPDATE `as_steps_by_dos` SET `step_order` = '6' WHERE `as_steps_by_dos`.`dos_program_category_id` = 1 AND `as_steps_by_dos`.`step_id` = 12 AND `as_steps_by_dos`.`stage_id` = 2;

----------------------------------------------------------------------------------------------------------------------- 
--Hetal Visaveliya(24th March 2022

UPDATE `programs` SET `program_name` = 'ODC Self Placed - TRN Young Pro' WHERE `programs`.`id` = 26;
UPDATE `programs` SET `program_name` = 'ODC Self Placed - TRN Rec Grad' WHERE `programs`.`id` = 27;

UPDATE `dev_team_email` SET `dev_name` = 'hetal', `dev_email` = 'hetal@odcitservices.com' WHERE `dev_team_email`.`dev_email` = 'chaitasi@odcitservices.com';
UPDATE `dev_team_email` SET `dev_name` = 'vandana', `dev_email` = 'vandana@odcitservices.com' WHERE `dev_team_email`.`dev_email` = 'cmakwana@odcitservices.com';
----------------------------------------------------------------------------------------------------------------------- 
--Chandresh Kukadiya(31st March 2022)
INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, '2', '36', '2', '2');
----------------------------------------------------------------------------------------------------------------------- 

--Chandresh Kukadiya(4th April 2022)
UPDATE `programs` SET `program_name` = 'ODC Self Placed - INT Rec Grad' WHERE `programs`.`id` = 24;
UPDATE `programs` SET `program_name` = 'ODC Self Placed - INT Current Stud' WHERE `programs`.`id` = 25;
-----------------------------------------------------------------------------------------------------------------------  
--Hetal Visaveliya(7th April 2022)
INSERT INTO `as_steps_by_dos` (`dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, '7', '2', '1'), ('1', '7', '2', '1'), ('2', '7', '2', '1'), ( '3', '7', '2', '1');
 
UPDATE `as_steps_by_dos` SET `step_order` = '3' WHERE `as_steps_by_dos`.`dos_program_category_id` = 2 AND `as_steps_by_dos`.`step_id` = 9 AND `as_steps_by_dos`.`stage_id` = 2;

UPDATE `as_steps_by_dos` SET `step_order` = '4' WHERE `as_steps_by_dos`.`dos_program_category_id` = 2 AND `as_steps_by_dos`.`step_id` = 10 AND `as_steps_by_dos`.`stage_id` = 2;

UPDATE `as_steps_by_dos` SET `step_order` = '5' WHERE `as_steps_by_dos`.`dos_program_category_id` = 2 AND `as_steps_by_dos`.`step_id` = 11 AND `as_steps_by_dos`.`stage_id` = 2;

UPDATE `as_steps_by_dos` SET `step_order` = '6' WHERE `as_steps_by_dos`.`dos_program_category_id` = 2 AND `as_steps_by_dos`.`step_id` = 12 AND `as_steps_by_dos`.`stage_id` = 2;
-----------------------------------------------------------------------------------------------------------------------  
--Hetal Visaveliya(20th April 2022)
INSERT INTO `dos_program_category` (`id`, `program_category_name`, `program_number`, `PositionCode`, `CategoryCode`) VALUES ('100', 'Other', '', NULL, NULL);
 
UPDATE `programs` SET `category` = '6' WHERE `programs`.`id` = 8;
UPDATE `programs` SET `dos_program_category_id` = '100' WHERE `programs`.`id` = 8;

INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, '100', '1', '1', '1'), (NULL, '100', '7', '1', '8'), (NULL, '100', '30', '1', '7'), (NULL, '100', '6', '1', '6'), (NULL, '100', '5', '1', '5'), (NULL, '100', '4', '1', '4'), (NULL, '100', '3', '1', '3'), (NULL, '100', '2', '1', '2');

INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, '100', '36', '2', '2'), (NULL, '100', '7', '2', '1'), (NULL, '100', '12', '2', '6'), (NULL, '100', '11', '2', '5'), (NULL, '100', '10', '2', '4'), (NULL, '100', '8', '2', '1'), (NULL, '100', '9', '2', '3');

INSERT INTO `as_steps_by_dos` (`id`, `dos_program_category_id`, `step_id`, `stage_id`, `step_order`) VALUES (NULL, '100', '22', '3', '11'), (NULL, '100', '21', '3', '10'), (NULL, '100', '20', '3', '9'), (NULL, '100', '19', '3', '8'), (NULL, '100', '32', '3', '7'), (NULL, '100', '18', '3', '6');
----------------------------------------------------------------------------------------------------------------------- 
-- Nidhi Lakhani (22 April 2022)
ALTER TABLE `user_details` ADD `camp_driver_license` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '1=Yes , 2=NO' AFTER `is_skipped_additional_info`;
----------------------------------------------------------------------------------------------------------------------- 
-- Hetal Visaveliya (29 April 2022)
INSERT INTO `system_settings` (`name`, `field`, `value`, `description`) VALUES
('Other Category Agreement Content', 'other_category_agreement_content', 'content', 'Other Category Agreement Content');

INSERT INTO `notification_messages` (`notification_type_id`, `notification_type_key`, `notification_type_data`, `notification_text`, `notification_message`, `status`, `created_at`, `updated_at`) VALUES ('4', '2_english_level_interview_msg_3', '2_english_level_interview', 'Application Status: English Interview', 'Your English interview has been scheduled', '1', '2019-07-23 01:30:00', '2020-09-09 19:55:52');
----------------------------------------------------------------------------------------------------------------------------------------------------------
--Nidhi Lakhani(19 May 2022)
ALTER TABLE `accounting_transactions` CHANGE `void` `void` INT(1) NULL DEFAULT '0';
UPDATE `accounting_transactions` SET `void` = '0';
----------------------------------------------------------------------------------------------------------------------- 
--Chandresh Kukadiya(4th April 2022)
ALTER TABLE `email_notification` ADD `send_to_admin` TEXT NULL AFTER `send_cc`;
ALTER TABLE `email_notification` CHANGE `send_cc` `send_cc` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
-----------------------------------------------------------------------------------------------------------------------  
--Chandresh Kukadiya(11th July 2022)
UPDATE `email_notification` SET `send_to` = '2' WHERE `email_notification`.`id` = 19;
----------------------------------------------------------------------------------------------------------------------- 
-- Hetal Visaveliya (07 October 2022) 
INSERT INTO `j1_statuses` (`id`, `status_key`, `status_name`, `category`) VALUES ('6009', 'program-completed', 'Program Completed', '5');
----------------------------------------------------------------------------------------------------------------------- 
-- Hetal Visaveliya (11 November 2022)
ALTER TABLE `j1_interview` ADD `latest_availability_date` DATE NULL AFTER `availability_type`;
----------------------------------------------------------------------------------------------------------------------- 
-- Hetal Visaveliya (9 December 2022)
CREATE TABLE `bank_wire_details` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `portfolio_id` int(11) DEFAULT NULL,
  `fee_type` int(1) DEFAULT NULL COMMENT '1=Registration',
  `amount` int(11) NOT NULL,
  `date` date NOT NULL,
  `bank_receipt` text NOT NULL,
  `invoice_ids` text NOT NULL,
  `is_verified_accounting` enum('y','n') NOT NULL DEFAULT 'n' COMMENT 'y = Yes, n = No',
  `is_verified_by` int(11) NOT NULL DEFAULT '0' COMMENT 'verified admin ID',
  `added_by` enum('e','p','h','s') NOT NULL DEFAULT 'p' COMMENT 'p = Partner, e = EV, h=Host Company, s=Sending Company',
  `added_by_id` int(11) NOT NULL DEFAULT '0' COMMENT 'added_by \r\ne=user_id, p=parnter_id, h=emp_id, s=sc_id',
  `created_date` datetime NOT NULL,
  `updated_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `bank_wire_details`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `bank_wire_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
----------------------------------------------------------------------------------------------------------------------- 
--Chandresh Kukadiya(18th Jan 2023)
ALTER TABLE `j1_interview` CHANGE `reg_fee_status` `reg_fee_status` TINYINT(1) NULL DEFAULT NULL COMMENT '1 = Charge,2 = Postpone,4 = Partner invoice charge';

----------------------------------------------------------------------------------------------------------------------- 
--Chandresh Kukadiya(19th Jan 2023)

CREATE TABLE `cron_azure_upload_document` (
  `id` int(11) NOT NULL,
  `doc_id` int(11) NOT NULL COMMENT 'documents->document_id',
  `doc_name` varchar(255) DEFAULT NULL,
  `doc_type` enum('1','2','3','4','5') NOT NULL DEFAULT '1' COMMENT 'table\r\n1:documents, \r\n2:users,\r\n3:admins,\r\n4:testimonials,\r\n5:required_document\r\n',
  `fileshare_storage_type` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1: Hot Storage [current returnee as document],\r\n2: Cold Storage [old document]',
  `is_doc_exist` enum('1','2') NOT NULL DEFAULT '1' COMMENT '1: File exist and uploaded to azure,\r\n2: File not exist at  server',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


ALTER TABLE `cron_azure_upload_document`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `cron_azure_upload_document`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
----------------------------------------------------------------------------------------------------------------------- 
--Chandresh Kukadiya(02 Feb 2023)

ALTER TABLE `cron_azure_upload_document` CHANGE `doc_type` `doc_type` ENUM('1','2','3','4','5','6') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT 'table\r\n1:documents, \r\n2:users,\r\n3:admins,\r\n4:testimonials,\r\n5:required_document,\r\n6:portfolio';
-----------------------------------------------------------------------------------------------------------------------
--Nidhi Lakhani(22 May 2023)
CREATE TABLE `document_status` (
  `id` int(11) NOT NULL,
  `document_status_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `document_status_desc` varchar(255) DEFAULT NULL,
  `document_status_type` int(11) NOT NULL DEFAULT 0 COMMENT '0 - Pending, 1 - Approve, 2 - Reject',
  `document_status_order` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '0 = Inactive and 1 = Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `document_status`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `document_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
INSERT INTO `document_status` (`id`, `document_status_name`, `document_status_desc`, `document_status_type`, `document_status_order`, `status`) VALUES
(1, 'Pending to Review', 'Pending (Waiting for approve or reject)', 0, 1, 1),
(2, 'Pre-approved by ITN', 'Pre-approved by ITN (Pending approval by ODYSSEY)', 1, 2, 1),
(3, 'Rejected by ITN', 'Rejected by ITN', 2, 3, 1),
(4, 'Validate by ODYSSEY', 'Validate by ODYSSEY (Approved by ODYSSEY)', 1, 4, 1),
(5, 'Rejected by ODYSSEY', 'Rejected by ODYSSEY', 2, 5, 1),
(6, 'Action Require', 'Action Require', 0, 6, 1);
-----------------------------------------------------------------------------------------------------------------------
--Nidhi Lakhani(30 May 2023)
UPDATE  documents SET document_status=5 WHERE document_status = 2 ORDER BY document_id DESC;
UPDATE  documents SET document_status=4 WHERE document_status = 1 ORDER BY document_id DESC;
UPDATE  documents SET document_status=1 WHERE document_status = 0 ORDER BY document_id DESC;
-----------------------------------------------------------------------------------------------------------------------
--Nidhi Lakhani(21 June 2023)
UPDATE `document_types` SET `name` = 'Signed Employment Contract' WHERE `document_types`.`doc_key` = 'job_offer';
-----------------------------------------------------------------------------------------------------------------------
--Chandresh Kukadiya(22 June 2023)
ALTER TABLE `email_log` ADD `sg_message_id` TEXT NULL COMMENT '1) Sendgrid: success->unique message id, fail-> blank 2) php mailer: success->php_mailer, fali->php_mailer_fail' AFTER `is_reminder`;
CREATE TABLE `email_event` ( `id` INT NOT NULL AUTO_INCREMENT , `odc_email_log_id` INT NOT NULL DEFAULT '0' , `sg_message_id` VARCHAR(255) NOT NULL , `event` VARCHAR(255) NOT NULL , `ip` VARCHAR(255) NOT NULL , `sg_event_id` VARCHAR(255) NOT NULL , `useragent` VARCHAR(255) NOT NULL , `timestamp` INT NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
-----------------------------------------------------------------------------------------------------------------------
--Vandana Pipaliya (27 Sep 2023)
INSERT INTO `system_settings` (`id`, `name`, `field`, `value`, `description`) VALUES (NULL, 'Shut Access Mode', 'ribbon_message', '{"shut_access_flag":"off","ribbon_msg_txt":""}', 'Shut Access Mode Setting'); 
-----------------------------------------------------------------------------------------------------------------------
--Nidhi Lakhani(03 Nov 2023)
ALTER TABLE `bank_wire_details` ADD `payor_info` VARCHAR(255) NULL DEFAULT NULL COMMENT 'name of the bank account holder of the payor or money transfer institution used by the payor. Example: Western union, Wise' AFTER `added_by_id`;
-----------------------------------------------------------------------------------------------------------------------
--Hetal Visaveliya(22 Nov 2023)

UPDATE `system_settings` SET `value` = '<p style=\"text-align:center;\"><strong>ODYSSEY INTERNATIONAL CAMP</strong><br>TERMS AND CONDITIONS</p><p>Please read every section of this terms and conditions document and initial and sign where requested. If you have any questions regarding the contents, please contact Odyssey for clarification before signing.</p><p><u>SECTION 1: PURPOSE OF THE PROGRAM</u></p><p>I understand that the purpose of the exchange visitor program being offered by Odyssey International Camp is to:</p><ol><li>Promote international understanding by improving American knowledge of foreign cultures while enabling foreign participants to increase their knowledge of American culture. This is achieved by serving as a camp counselor, that is, having direct responsibility for supervision of groups of American youth and of activities at a summer camp.</li><li>To foster the exchange of culture ideas and information, allowing participants to return to their home country and share their experiences with their fellow citizens.</li></ol><p><u>SECTION 2: ROLE OF ODYSSEY AND PROGRAM SPONSORSHIP</u></p><ol><li style=\"text-align:justify;\">I understand that Odyssey International Camp is a designated J-1 Camp Counselor program sponsor authorized to administer J-1 camp counselor programs. I acknowledge that Odyssey is primarily a cultural exchange organization and not an employment agency. Odyssey is responsible for my safety and well being and to ensure the rules and regulations of the program are followed. Odyssey ultimately has the authority to determine program violations and repercussions.</li></ol><p><u>SECTION 3: SERVICES PROVIDED BY ODYSSEY</u></p><ol><li>Confirm participant’s eligibility to participate in the requested J-1 Exchange Visitor Program according to the most updated program regulations.</li><li>Ensure the participant receives a job offer from their host camp which, at a minimum, discloses:<ol style=\"list-style-type:lower-alpha;\"><li>Duties and responsibilities relating to their service as a camp counselor;</li><li>Contractual obligations relating to their acceptance of a camp counselor position; and</li><li>Financial compensation for their service as a camp counselor.</li></ol></li><li>Ensure participants receive the same pay and benefits as their American counterparts.</li><li>Provide J-1 participants with insurance that meets or exceeds the requirements outlined in 22 CFR 62 – Exchange Visitor Program, for the duration of their program.</li><li>Provide and applicant with a DS-2019 document, which they will need to apply for their J-1 Visa in their home country.</li><li>Pay the SEVIS Fee I-901 and send the participant a SEVIS receipt.</li><li>Provide candidates with J-1 sponsorship for the approved category in which they have applied, along with all mandatory roles and services of a designated sponsor as outlined in 22 CFR 62 – Exchange Visitor Program, for the duration of their program.</li><li>Create an exchange visitor profile in SEVIS on behalf of the participant.</li><li>Provide the participant with a detailed pre-departure orientation as well as orientation materials, including a Participant Handbook with useful information on assimilating into American society.</li><li>Provide 24 hour support through an Odyssey emergency hotline.</li><li>Constant communication and monitoring for the duration of the program.</li></ol><p><u>SECTION 4: CANDIDATE’S OBLIGATIONS</u></p><p>The Candidate agrees:</p><ol><li>To comply with all academic and/or work experience requirements and submit to the Service Provider the corresponding supporting documents.</li><li>To attend all interviews, including telephonic or Skype interviews, at the pre-arranged time organized by the Service Provider.</li><li>To not decline more than two (2) interviews with potential Host Camps.</li><li>The Candidate understands that he/she needs to do research about the Host Camp before accepting an interview. Once the Candidate has accepted an interview with a Host Camp, he/she has to accept the position if the interview is successful. Declining of the offer and the position after a successful interview will be subject to an administrative fee as described in this agreement.</li><li>To provide all necessary/requested authentic/truthful documentation in a timely manner.</li><li>To submit payment of the program fees in a timely manner (The due date will be indicated on the payment invoice).</li><li>To secure his/her housing before arrival in the United States unless provided by the Host Company for the duration of the stay in the USA.</li><li>To observe and respect the American culture and comply with all laws and regulations of the USA (included but not limited to all laws in relation to the Exchange Visitor Program) as well as the Host Company’s internal regulations.</li><li>To perform his/her duties during the program, as described in Article 1 of this agreement, at a high standard and with all due skills, care and attention consistent with the level of the knowledge, experience or education which the Candidate has represented to the Service Provider and the Host Company.</li></ol><p><u>CANDIDATE’S RESPONSIBILITIES</u>.</p><p>The Candidate is responsible and liable for:</p><ol><li>All transportation costs to, from and within the USA.</li><li>All of his/her living expenses such as food, transportation and housing unless provided by the Host Camp for the duration of the stay in the USA.</li><li>All medical expenses and bills that are outside the coverage of the medical insurance.</li><li>Reading all emails, documents, agreements, informational handouts and guidebooks provided to the Candidate by the Service Provider</li></ol><p><u>SECTION 5: ELIGIBILITY</u></p><p>I verify that I meet the following requirements for the program I am applying for:</p><ol><li>I am at least 18 years old.</li><li>I am a bona fide youth worker, student, teacher, or have specialized skills as determined by Odyssey.</li><li>I speak and understand English at an intermediate or advanced level. I understand that my English level will be assessed during a spoken interview with an ODYSSEY associate and through a written evaluation.</li><li>I will submit all required registration documents as outlined by Odyssey.</li><li>I will participate in cultural activities while living in the U.S. and will provide documentation of my participation to my sponsor.</li><li>I understand that Odyssey has final determination of my eligibility and may decline my application for any reason before the issuance of my DS-2019 document.</li></ol><p><u>SECTION 6: GENERAL TERMS AND CONDITIONS</u></p><ol><li>I agree not to start my Camp Counselor Program prior to the start date on my DS-2019 form or work beyond the end date on my DS-2019 form. I understand that I must return home within 30 days after the end date on my DS-2019 form, and I may not work or earn money during that period.</li><li>I understand that I must check-in with Odyssey within 72 hours after arriving in the United States to activate my SEVIS account. Failure to do this within 10 days will automatically cancel my program.</li><li>I understand that if I do not comply with the rules, regulations and requirements set by Odyssey that Odyssey has the authority to terminate my program early and require me to return home immediately without a refund.</li><li>I will check my emails at least once every other day and respond to all messages from Odyssey.</li><li>I understand that I must complete a monthly check-in with Odyssey where I will update my status and send evidence of participation in cultural activities.</li><li>I agree to indemnify and hold harmless Odyssey, its officers and directors, employees and its affiliates and their respective successors and assigns and each other person, if any, who controls any thereof, against any loss, liability, claim, damage and expense whatsoever (including, but not limited to, any and all expenses whatsoever reasonably incurred in investigating, preparing, or defending against any litigation commenced or threatened or any claim whatsoever) arising out of or resulting from, or in connection with the services contemplated by this agreement.</li><li>I will declare any known ailments, allergies or known medical history which could affect my ability to participate in the program or the position I was selected for.</li><li>I understand that I am not allowed to engage in any other activity for money for the duration of my J-1 program besides the duties and responsibilities outlined by my host camp. This includes second jobs for other companies. If I am caught working a second job, my program will be immediately terminated and I will be required to depart the country without a refund.</li><li>I agree that any photos, testimonials of videos I sent to Odyssey may be used in promotional and educational materials.</li><li>I will not attempt to change my visa status while in the United States. I understand that any future visa applications must be initiated from my home country and that Odyssey does not support change of visa status.</li><li>I understand that it is recognized that some non-counseling chores are an essential part of camp life for all counselors. This may include duties such as cleaning cabins or bathrooms, setting up events, helping with maintaining equipment, cleaning up after activities or events. However, this program is not intended to assist American camps in bringing in foreign nationals to serve as administrative personnel, cooks, or menial laborers, such as dishwashers or janitors. If I feel this requirement is not being followed, I will inform Odyssey.</li><li>I will participate in cultural activities while living in the U.S. and will provide documentation of my participation to my sponsor.</li><li>I understand that by signing a job offer, I am making a commitment to a U.S. summer camp. Failure to abide by the terms of the contract could result in early termination of my program. If I am terminated by my host, I may be required to return to my home country.</li></ol><p style=\"text-align:justify;\"><u>SECTION 7: J-1 VISA APPLICATION</u></p><ol><li>I understand that the J-1 Visa is a non-immigrant visa and that this program is not a way to obtain a permanent job in the U.S. or a way to immigrate. Further, I understand that I am expected to return to my home country at the conclusion of my program.</li><li>I have a valid passport that will not expire for at least six months after my program ends. I understand my DS-2019 Form is NOT a visa, but is required for my ability to participate in the program in the USA. I understand that I must take the DS-2019 Form and other required documents to the U.S. Embassy or Consulate to apply for a J-1 visa in my home country.</li><li>I understand that I cannot change my program dates once my DS-2019 has been issued unless authorized by ODYSSEY and a new DS-2019 is issued.</li><li>I understand that if I need to leave the United States during my program I must have prior authorization from ODYSSEY at least two weeks before my departure. Failure to do this will result in my inability to re-enter the country.</li><li>ODYSSEY is not responsible, nor does ODYSSEY have any influence as to whether the J-1 visa is approved at the US Embassy. Proof of eligibility to qualify for a J-1 visa lies solely with the applicant.</li><li>I understand that I may be subject to the Immigration and Nationality Act, Section 212(e), also referred to as the two-year home-country physical presence requirement. This may prevent me from applying for H, L or K visas for up to 2 years after the completion of my program, unless a waiver is granted.</li></ol><p style=\"text-align:justify;\"><u>SECTION 8: INSURANCE</u></p><ol><li>I understand that my insurance coverage begins on my program start date. The insurance coverage ends on the Program End Date as listed on my DS-2019.</li><li>I understand that I must have medical insurance for the duration of my program and I agree to accept the insurance policy provided to me by Odyssey.</li><li>I understand that I should always call the insurance provider before seeking medical attention to be pre-approved for procedures whenever possible. I understand that failure to be pre-approved could result in liability for unwanted medical expenses.</li><li>I understand that I am responsible for all medical bills incurred during my program. Furthermore, I understand that Odyssey is not responsible for any bills I may incur.</li><li>I understand that the coverage provided to me by Odyssey is intended for emergency and urgent medical situations only. It is not intended for routine maintenance or check-ups.</li><li>I understand that my insurance does not cover any bills associated with pre-existing conditions. I agree to declare all pre-existing conditions to Odyssey before departing.</li><li>I understand that if I intend to stay in the United States past the end date of my program (to use the 30-day grace period), then it is my responsibility to arrange additional insurance coverage for this time.</li></ol><p><u>SECTION 9: EXPENSES</u></p><ol><li>I understand that there is a fee required to participate in a J-1 program. The fees are required to provide the placement, DS-2019, medical insurance, orientation materials, 24/7 support and monitoring throughout my program.</li><li>I understand that I am responsible for additional expenses for services not included in the Odyssey Terms and Conditions. These include may housing, transportation, food and entertainment.</li><li>I understand that I must have access to at least $700 upon entering the United States to cover living expenses before I receive my first stipend check which may take several weeks after arrival.</li><li>I understand that the purpose of my stipend from my host company is to assist in covering living expenses and not to make or save money. I also acknowledge that the stipend is not guaranteed to cover all living expenses.</li><li>I understand that the purpose of the Exchange Visitor program for which I am applying is not to work or earn money, but rather to experience American culture and work experience..</li><li>I understand that I may not engage in any other forms of paid work during my J-1 program besides that with the host camp listed on my DS-2019.</li><li>Program Costs Disclosure:</li></ol><figure class=\"table\"><table><tbody><tr><td colspan=\"3\"><p style=\"margin-left:10.7pt;text-align:center;\"><i>The purpose of this table is to declare the varying costs of services provided to J-1 exchange visitors of Odyssey International Exchange and to ensure the programs remain transparent and accessible. It is not intended to be a commitment to pay for services.</i></p><p style=\"margin-left:10.6pt;text-align:center;\"><i>*If applicable</i></p></td></tr><tr><td><p style=\"margin-left:10.9pt;text-align:center;\"><strong>Service</strong></p></td><td><p style=\"margin-left:9.45pt;text-align:center;\"><strong>Total Cost (USD)</strong></p></td><td><p style=\"margin-left:94.0pt;text-align:center;\"><strong>Description of Service</strong></p></td></tr><tr><td><p style=\"margin-left:0cm;\"> </p><p style=\"margin-left:10.9pt;text-align:center;\">Agent Fee*</p></td><td><p style=\"margin-left:0cm;\"> </p><p style=\"margin-left:9.45pt;text-align:center;\">Varies</p></td><td>Recruitment, screening, document translation, interview organization, placement, document collection, English evaluation, orientation, interview assistance, administrative costs.</td></tr><tr><td><p style=\"margin-left:26.15pt;\">Odyssey Camp</p><p style=\"margin-left:24.15pt;\">Registration Fee</p></td><td><p style=\"margin-left:9.45pt;text-align:center;\">$40</p></td><td>One time, nonrefundable fee for camp program registration.</td></tr><tr><td><p style=\"margin-left:10.9pt;text-align:center;\">Sponsor Fee</p><p style=\"margin-left:10.9pt;text-align:center;\"><i>Up to 4 Month Program</i></p></td><td><p style=\"margin-left:0cm;\"> </p><p style=\"margin-left:9.45pt;text-align:center;\">$295.00</p></td><td>Application review and screening, pre-departure orientation materials, program vetting and approval, DS-2019 form &amp; supporting documents, on-going monitoring of program experience, 24-hour support while in the U.S.</td></tr><tr><td><p style=\"margin-left:0cm;\"> </p><p style=\"margin-left:10.9pt;text-align:center;\">Insurance</p></td><td><p style=\"margin-left:0cm;\"> </p><p style=\"margin-left:9.45pt;text-align:center;\">$50.00/month</p></td><td>All J-1 participants are required to have insurance for the duration of their programs. The insurance provided by Odyssey exceeds minimum program requirements.</td></tr><tr><td><p style=\"margin-left:0cm;\"> </p><p style=\"margin-left:10.9pt;text-align:center;\">SEVIS Fee</p></td><td><p style=\"margin-left:0cm;\"> </p><p style=\"margin-left:9.45pt;text-align:center;\">$35.00</p></td><td>Mandatory U.S. Government fee required to create and maintain an exchange visitor profile in the SEVIS system. This price includes a $20.00 service fee to create the SEVIS profile on behalf of the exchange visitor.</td></tr><tr><td><p style=\"margin-left:10.9pt;text-align:center;\">Visa Application Fee</p></td><td><p style=\"margin-left:9.45pt;text-align:center;\">$160.00</p></td><td>Mandatory fee to make a J-1 Visa appointment. Paid directly to the U.S. Government online.</td></tr><tr><td><p style=\"margin-left:10.9pt;text-align:center;\">Site Visit*</p></td><td><p style=\"margin-left:9.45pt;text-align:center;\">$295.00</p></td><td>Only required if host company does not meet minimum staffing or revenue requirements.</td></tr><tr><td><p style=\"margin-left:10.9pt;text-align:center;\">Roundtrip Airfare</p></td><td><p style=\"margin-left:9.45pt;text-align:center;\">$1,200.00</p></td><td>Estimated cost of airfare to and from the U.S.</td></tr><tr><td><p style=\"margin-left:10.9pt;text-align:center;\">Arrival Funds</p></td><td><p style=\"margin-left:9.45pt;text-align:center;\">$700.00</p></td><td>Minimum required personal funds all exchange visitors must have available upon arriving in the U.S.</td></tr></tbody></table></figure><p><u>SECTION 10: ARRIVAL AND ORIENTATION</u></p><ol><li>I agree to review all orientation materials provided by Odyssey, specifically the ODYSSEY Pre-Departure Orientation and the Odyssey Participant Handbook.</li><li>Odyssey recommends that I do not arrive more than a week prior to the start date on my DS-2019 form and that I cannot begin my program until the start date on the form.</li><li>I understand that ODYSSEY does not recommend purchasing any non-refundable items or tickets before my visa is approved.</li><li>I agree to communicate my arrival information as soon as possible to Odyssey by following the instruction of the Arrival Check in email sent by Odyssey.</li><li>I understand that I MUST check-in with Odyssey within 72 hours after arriving. Failure to do so within 10 days after arriving will automatically terminate my program.</li></ol><p><u>SECTION 11: HOST CAMP</u></p><ol><li>I understand that I can be terminated from my host camp for failing to comply with company policy. If I am terminated, I may be required to return home immediately without a refund. Odyssey will determine if a transfer to another host camp is appropriate.</li><li>I understand that some companies require drug tests. If I fail a drug test, I understand that I will be terminated and will need to leave the country according to Odyssey’s instructions.</li><li>I understand that Odyssey does not encourage changing host camps and will only do so as a last resort. I will not leave my camp without first consulting Odyssey or my program will be cancelled. Odyssey has the sole discretion whether or not to approve a change of host company.</li><li>I understand that Odyssey is only available to enforce the rules and regulations of the J-1 program. Odyssey cannot interfere with personal issues or matters of hearsay.</li><li>Odyssey is not responsible for loss of stipend, location transfer costs or any other transportation or accommodation expenses incurred due to termination, placement cancellation or change of location.</li><li>I understand that no position can be guaranteed for the duration of a program as businesses sometimes go out of business or experience financial hardships which could result in layoffs. In this case, Odyssey will assist the participant to the best of its abilities to secure a new position. I understand that alternate positions may not be comparable to my original position in position, stipend or location.</li></ol><p><u>SECTION 12: REFUNDS</u></p><ol><li><u>Registration Fee.</u> Applicants enrolling in Odyssey’s All-Inclusive program are required to pay a $40.00 registration fee before Odyssey begins the process of matching them to a prospective host. Registration fees are non-refundable.</li><li><u>Withdrawal After Placement is Confirmed</u>. If the Candidate cancels the placement or withdraws from the program due to any reason after a successful interview with the Host Company and receipt of the notification that confirms his/her Placement, the Candidate will be entitled to a refund of the program fee minus One Hundred and Ninety Five US Dollars (195.00 USD) which will be withheld and account for the administrative fees of OIC. If the Candidate fails to satisfy the Pre-arrival Liabilities and/or if the Candidate is unable to continue the program due to any academic reason, such as course failure, attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate and the administrative fees will be billed. The refund will be processed within 30 days after receipt of the refund request.</li><li><u>Withdrawal After Placement is Confirmed due to COVID-19</u>. If the Candidate cancels the placement or withdraws from the program due to COVID-19 after a successful interview with the Host Company and receipt of the notification that confirms his/her Placement, the Candidate will not be entitled to any refund. The Candidate will be re-placed at a new Host Company by OIC based on his/her preferences and eligibility requirements.</li><li><u>Withdrawal After Issuance of SEVIS number</u>. If the Candidate cancels the placement or withdraws from the program due to any reason after the issuance of the SEVIS number, the Candidate will not be entitled to any refund. If the Candidate fails to satisfy the Pre-arrival Liabilities and/or if the Candidate is unable to continue the program due to any academic reasons, such as course failure, attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate.</li><li><u>Withdrawal After Issuance of SEVIS number due to COVID-19.</u> If the Candidate cancels the placement or withdraws from the program due to COVID-19 after the issuance of the SEVIS number, the Candidate will not be entitled to any refund. The Candidate will be re-placed at a new Host Company by OIC based on his/her preferences and eligibility requirements.</li><li><u>Embassy/Consulate Denial</u>. In case of a visa denial at the US Embassy, the Candidate must inform OIC within 3 business days of denial and return the original Form DS-2019 and proof of denial from the Embassy or Consulate within 10 Business Days from the date of denial in order to be eligible for refunds. The Candidate will be entitled to a refund of the program fee minus One Hundred and Ninety Five US Dollars (195.00 USD) which will be withheld; and account for the administrative fees of OIC. The refund will be processed within 30 days after receipt of the refund request. No refund will be issued if the documents are returned after the 10 Business Days deadline or if the documents are not returned to OIC.</li><li><u>Cancellation by the Host Company Prior to DS-2019 Issuance.</u> If the Host Company cancels the placement or withdraws from the program prior to the issuance of the DS-2019 document, The Candidate will be entitled to a refund of the program fee minus One Hundred and Ninety Five US Dollars (195.00 USD) which will be withheld; and account for the administrative fees of OIC. The refund will be processed within 30 days after receipt of the refund request. No refund will be issued if the documents are returned after the 10 Business Days deadline or if the documents are not returned to OIC.</li><li><u>Cancellation by the Host Company due to COVID-19.</u> If the Host Company cancels the placement or withdraws from the program prior to the program start date for any reasons related to COVID-19, no refunds will be issued. Candidate may retain their fees as a credit towards another program. OIC will attempt to re-place the Candidate at a new Host Company based on his/her preferences and eligibility requirements.</li><li><u>Cancellation After Arrival in the United States</u>. If the Candidate withdraws from the program or is unable to continue the program due to any reason after arrival in the US or if the Candidate is laid off or fired by the Host Company, the Candidate will not be entitled to any refund.</li><li><u>Refusal of Interviews</u>. If the Candidate refuses to interview with 2 or more potential Host Companies within the field of his preferences, the Candidate will be terminated from the program.</li></ol><p style=\"text-align:justify;\"><u>SECTION 13: OTHER TERMS</u></p><ol><li>The Candidate understands that the Service Provider may cancel his/her application if the Service Provider determines that the Candidate fails to pass the eligibility requirements based on the rules and regulations by the Service Provider and/or the Program Sponsor.</li><li>The length of the program agreed upon by the Host Company and the Candidate shall be contingent on the Candidate’s performance as reviewed by the Host Company and does not bind the Host Company to the full duration if the Candidate does not meet the Host Company professional requirements or standards. The Candidate understands that if the Host Company determines that the Candidate does not perform his/her duties properly and/or the Candidate does not comply strictly with the regulations, the Host Company has the right to terminate or fire the Candidate. In which case, the Candidate will not be entitled to receive any refund.</li><li>If the Host Company goes out of business, files for bankruptcy, shuts down for any reason, or terminates or lays off the Candidate for lack of commercial activity, the Service Provider will assist the candidate in finding a new Host Company; however, the Service Provider cannot guarantee that a suitable new Host Company will be found within a reasonable time with due consideration of the full program duration and/or validity of the J1 Visa.</li><li>Candidate agrees to indemnify and hold harmless Odyssey, its officers and directors, employees and its affiliates and their respective successors and assigns and each other person, if any, who controls any thereof, against any loss, liability, claim, damage and expense whatsoever (including, but not limited to, any and all expenses whatsoever reasonably incurred in investigating, preparing, or defending against any litigation commenced or threatened or any claim whatsoever) arising out of or resulting from, or in connection with the services contemplated by this agreement.</li><li>The Candidate confirms that he/she is fit to participate in the Camp Counselor Program both physically and mentally, and understands that the experience can be stressful and may require participants to engage in physically strenuous activities. All pre-existing medical conditions must be made known to the Service Provider in writing at the time of application. Accommodations will be made whenever possible to allow applications from Candidates with non-serious medical conditions.</li></ol><p style=\"text-align:justify;\">By signing below, I acknowledge that I have read and understood all sections of this terms and conditions document and agree to abide by its contents and instructions. (Please sign and date on the next page.)</p><p style=\"text-align:justify;\"> </p><p><span style=\"background-color:yellow;\">Full Name (Printed):</span><u>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</u></p><p style=\"margin-left:0cm;\"> </p><p><span style=\"background-color:yellow;\">Signature:</span> <u> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</u></p><p style=\"margin-left:0cm;\"> </p><p><span style=\"background-color:yellow;\">Date:</span> <u> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </u></p>' WHERE `system_settings`.`field` = 'camp_itn_agreement_content';
-----------------------------------------------------------------------------------------------------------------------
--Hetal Visaveliya(24 Nov 2023)

UPDATE `system_settings` SET `value` = '<p style="text-align:center;"><strong>ODYSSEY INTERNATIONAL CAMP</strong><br>TERMS AND CONDITIONS</p><p>Please read every section of this terms and conditions document and initial and sign where requested. If you have any questions regarding the contents, please contact Odyssey for clarification before signing.</p><p><u>SECTION 1: PURPOSE OF THE PROGRAM</u></p><p>I understand that the purpose of the exchange visitor program being offered by Odyssey International Camp is to:</p><ol><li>Promote international understanding by improving American knowledge of foreign cultures while enabling foreign participants to increase their knowledge of American culture. This is achieved by serving as a camp counselor, that is, having direct responsibility for supervision of groups of American youth and of activities at a summer camp.</li><li>To foster the exchange of culture ideas and information, allowing participants to return to their home country and share their experiences with their fellow citizens.</li></ol><p><u>SECTION 2: ROLE OF ODYSSEY AND PROGRAM SPONSORSHIP</u></p><ol><li style="text-align:justify;">I understand that Odyssey International Camp is a designated J-1 Camp Counselor program sponsor authorized to administer J-1 camp counselor programs. I acknowledge that Odyssey is primarily a cultural exchange organization and not an employment agency. Odyssey is responsible for my safety and well being and to ensure the rules and regulations of the program are followed. Odyssey ultimately has the authority to determine program violations and repercussions.</li></ol><p><u>SECTION 3: SERVICES PROVIDED BY ODYSSEY</u></p><ol><li>Confirm participant’s eligibility to participate in the requested J-1 Exchange Visitor Program according to the most updated program regulations.</li><li>Ensure the participant receives a job offer from their host camp which, at a minimum, discloses:<ol style="list-style-type:lower-alpha;"><li>Duties and responsibilities relating to their service as a camp counselor;</li><li>Contractual obligations relating to their acceptance of a camp counselor position; and</li><li>Financial compensation for their service as a camp counselor.</li></ol></li><li>Ensure participants receive the same pay and benefits as their American counterparts.</li><li>Provide J-1 participants with insurance that meets or exceeds the requirements outlined in 22 CFR 62 – Exchange Visitor Program, for the duration of their program.</li><li>Provide and applicant with a DS-2019 document, which they will need to apply for their J-1 Visa in their home country.</li><li>Pay the SEVIS Fee I-901 and send the participant a SEVIS receipt.</li><li>Provide candidates with J-1 sponsorship for the approved category in which they have applied, along with all mandatory roles and services of a designated sponsor as outlined in 22 CFR 62 – Exchange Visitor Program, for the duration of their program.</li><li>Create an exchange visitor profile in SEVIS on behalf of the participant.</li><li>Provide the participant with a detailed pre-departure orientation as well as orientation materials, including a Participant Handbook with useful information on assimilating into American society.</li><li>Provide 24 hour support through an Odyssey emergency hotline.</li><li>Constant communication and monitoring for the duration of the program.</li></ol><p><u>SECTION 4: CANDIDATE’S OBLIGATIONS</u></p><p>The Candidate agrees:</p><ol><li>To comply with all academic and/or work experience requirements and submit to the Service Provider the corresponding supporting documents.</li><li>To attend all interviews, including telephonic or Skype interviews, at the pre-arranged time organized by the Service Provider.</li><li>To not decline more than two (2) interviews with potential Host Camps.</li><li>The Candidate understands that he/she needs to do research about the Host Camp before accepting an interview. Once the Candidate has accepted an interview with a Host Camp, he/she has to accept the position if the interview is successful. Declining of the offer and the position after a successful interview will be subject to an administrative fee as described in this agreement.</li><li>To provide all necessary/requested authentic/truthful documentation in a timely manner.</li><li>To submit payment of the program fees in a timely manner (The due date will be indicated on the payment invoice).</li><li>To secure his/her housing before arrival in the United States unless provided by the Host Company for the duration of the stay in the USA.</li><li>To observe and respect the American culture and comply with all laws and regulations of the USA (included but not limited to all laws in relation to the Exchange Visitor Program) as well as the Host Company’s internal regulations.</li><li>To perform his/her duties during the program, as described in Article 1 of this agreement, at a high standard and with all due skills, care and attention consistent with the level of the knowledge, experience or education which the Candidate has represented to the Service Provider and the Host Company.</li></ol><p><u>CANDIDATE’S RESPONSIBILITIES</u>.</p><p>The Candidate is responsible and liable for:</p><ol><li>All transportation costs to, from and within the USA.</li><li>All of his/her living expenses such as food, transportation and housing unless provided by the Host Camp for the duration of the stay in the USA.</li><li>All medical expenses and bills that are outside the coverage of the medical insurance.</li><li>Reading all emails, documents, agreements, informational handouts and guidebooks provided to the Candidate by the Service Provider</li></ol><p><u>SECTION 5: ELIGIBILITY</u></p><p>I verify that I meet the following requirements for the program I am applying for:</p><ol><li>I am at least 18 years old.</li><li>I am a bona fide youth worker, student, teacher, or have specialized skills as determined by Odyssey.</li><li>I speak and understand English at an intermediate or advanced level. I understand that my English level will be assessed during a spoken interview with an ODYSSEY associate and through a written evaluation.</li><li>I will submit all required registration documents as outlined by Odyssey.</li><li>I will participate in cultural activities while living in the U.S. and will provide documentation of my participation to my sponsor.</li><li>I understand that Odyssey has final determination of my eligibility and may decline my application for any reason before the issuance of my DS-2019 document.</li></ol><p><u>SECTION 6: GENERAL TERMS AND CONDITIONS</u></p><ol><li>I agree not to start my Camp Counselor Program prior to the start date on my DS-2019 form or work beyond the end date on my DS-2019 form. I understand that I must return home within 30 days after the end date on my DS-2019 form, and I may not work or earn money during that period.</li><li>I understand that I must check-in with Odyssey within 72 hours after arriving in the United States to activate my SEVIS account. Failure to do this within 10 days will automatically cancel my program.</li><li>I understand that if I do not comply with the rules, regulations and requirements set by Odyssey that Odyssey has the authority to terminate my program early and require me to return home immediately without a refund.</li><li>I will check my emails at least once every other day and respond to all messages from Odyssey.</li><li>I understand that I must complete a monthly check-in with Odyssey where I will update my status and send evidence of participation in cultural activities.</li><li>I agree to indemnify and hold harmless Odyssey, its officers and directors, employees and its affiliates and their respective successors and assigns and each other person, if any, who controls any thereof, against any loss, liability, claim, damage and expense whatsoever (including, but not limited to, any and all expenses whatsoever reasonably incurred in investigating, preparing, or defending against any litigation commenced or threatened or any claim whatsoever) arising out of or resulting from, or in connection with the services contemplated by this agreement.</li><li>I will declare any known ailments, allergies or known medical history which could affect my ability to participate in the program or the position I was selected for.</li><li>I understand that I am not allowed to engage in any other activity for money for the duration of my J-1 program besides the duties and responsibilities outlined by my host camp. This includes second jobs for other companies. If I am caught working a second job, my program will be immediately terminated and I will be required to depart the country without a refund.</li><li>I agree that any photos, testimonials of videos I sent to Odyssey may be used in promotional and educational materials.</li><li>I will not attempt to change my visa status while in the United States. I understand that any future visa applications must be initiated from my home country and that Odyssey does not support change of visa status.</li><li>I understand that it is recognized that some non-counseling chores are an essential part of camp life for all counselors. This may include duties such as cleaning cabins or bathrooms, setting up events, helping with maintaining equipment, cleaning up after activities or events. However, this program is not intended to assist American camps in bringing in foreign nationals to serve as administrative personnel, cooks, or menial laborers, such as dishwashers or janitors. If I feel this requirement is not being followed, I will inform Odyssey.</li><li>I will participate in cultural activities while living in the U.S. and will provide documentation of my participation to my sponsor.</li><li>I understand that by signing a job offer, I am making a commitment to a U.S. summer camp. Failure to abide by the terms of the contract could result in early termination of my program. If I am terminated by my host, I may be required to return to my home country.</li></ol><p style="text-align:justify;"><u>SECTION 7: J-1 VISA APPLICATION</u></p><ol><li>I understand that the J-1 Visa is a non-immigrant visa and that this program is not a way to obtain a permanent job in the U.S. or a way to immigrate. Further, I understand that I am expected to return to my home country at the conclusion of my program.</li><li>I have a valid passport that will not expire for at least six months after my program ends. I understand my DS-2019 Form is NOT a visa, but is required for my ability to participate in the program in the USA. I understand that I must take the DS-2019 Form and other required documents to the U.S. Embassy or Consulate to apply for a J-1 visa in my home country.</li><li>I understand that I cannot change my program dates once my DS-2019 has been issued unless authorized by ODYSSEY and a new DS-2019 is issued.</li><li>I understand that if I need to leave the United States during my program I must have prior authorization from ODYSSEY at least two weeks before my departure. Failure to do this will result in my inability to re-enter the country.</li><li>ODYSSEY is not responsible, nor does ODYSSEY have any influence as to whether the J-1 visa is approved at the US Embassy. Proof of eligibility to qualify for a J-1 visa lies solely with the applicant.</li><li>I understand that I may be subject to the Immigration and Nationality Act, Section 212(e), also referred to as the two-year home-country physical presence requirement. This may prevent me from applying for H, L or K visas for up to 2 years after the completion of my program, unless a waiver is granted.</li></ol><p style="text-align:justify;"><u>SECTION 8: INSURANCE</u></p><ol><li>I understand that my insurance coverage begins on my program start date. The insurance coverage ends on the Program End Date as listed on my DS-2019.</li><li>I understand that I must have medical insurance for the duration of my program and I agree to accept the insurance policy provided to me by Odyssey.</li><li>I understand that I should always call the insurance provider before seeking medical attention to be pre-approved for procedures whenever possible. I understand that failure to be pre-approved could result in liability for unwanted medical expenses.</li><li>I understand that I am responsible for all medical bills incurred during my program. Furthermore, I understand that Odyssey is not responsible for any bills I may incur.</li><li>I understand that the coverage provided to me by Odyssey is intended for emergency and urgent medical situations only. It is not intended for routine maintenance or check-ups.</li><li>I understand that my insurance does not cover any bills associated with pre-existing conditions. I agree to declare all pre-existing conditions to Odyssey before departing.</li><li>I understand that if I intend to stay in the United States past the end date of my program (to use the 30-day grace period), then it is my responsibility to arrange additional insurance coverage for this time.</li></ol><p><u>SECTION 9: EXPENSES</u></p><ol><li>I understand that there is a fee required to participate in a J-1 program. The fees are required to provide the placement, DS-2019, medical insurance, orientation materials, 24/7 support and monitoring throughout my program.</li><li>I understand that I am responsible for additional expenses for services not included in the Odyssey Terms and Conditions. These include may housing, transportation, food and entertainment.</li><li>I understand that I must have access to at least $700 upon entering the United States to cover living expenses before I receive my first stipend check which may take several weeks after arrival.</li><li>I understand that the purpose of my stipend from my host company is to assist in covering living expenses and not to make or save money. I also acknowledge that the stipend is not guaranteed to cover all living expenses.</li><li>I understand that the purpose of the Exchange Visitor program for which I am applying is not to work or earn money, but rather to experience American culture and work experience..</li><li>I understand that I may not engage in any other forms of paid work during my J-1 program besides that with the host camp listed on my DS-2019.</li><li>Program Costs Disclosure:</li></ol><figure class="table"><table><tbody><tr><td colspan="3"><p style="margin-left:10.7pt;text-align:center;"><i>The purpose of this table is to declare the varying costs of services provided to J-1 exchange visitors of Odyssey International Exchange and to ensure the programs remain transparent and accessible. It is not intended to be a commitment to pay for services.</i></p><p style="margin-left:10.6pt;text-align:center;"><i>*If applicable</i></p></td></tr><tr><td><p style="margin-left:10.9pt;text-align:center;"><strong>Service</strong></p></td><td><p style="margin-left:9.45pt;text-align:center;"><strong>Total Cost (USD)</strong></p></td><td><p style="margin-left:94.0pt;text-align:center;"><strong>Description of Service</strong></p></td></tr><tr><td><p style="margin-left:0cm;"> </p><p style="margin-left:10.9pt;text-align:center;">Agent Fee*</p></td><td><p style="margin-left:0cm;"> </p><p style="margin-left:9.45pt;text-align:center;">Varies</p></td><td>Recruitment, screening, document translation, interview organization, placement, document collection, English evaluation, orientation, interview assistance, administrative costs.</td></tr><tr><td><p style="margin-left:26.15pt;">Odyssey Camp</p><p style="margin-left:24.15pt;">Registration Fee</p></td><td><p style="margin-left:9.45pt;text-align:center;">$40</p></td><td>One time, nonrefundable fee for camp program registration.</td></tr><tr><td><p style="margin-left:10.9pt;text-align:center;">Sponsor Fee</p><p style="margin-left:10.9pt;text-align:center;"><i>Up to 4 Month Program</i></p></td><td><p style="margin-left:0cm;"> </p><p style="margin-left:9.45pt;text-align:center;">$295.00</p></td><td>Application review and screening, pre-departure orientation materials, program vetting and approval, DS-2019 form &amp; supporting documents, on-going monitoring of program experience, 24-hour support while in the U.S.</td></tr><tr><td><p style="margin-left:0cm;"> </p><p style="margin-left:10.9pt;text-align:center;">Insurance</p></td><td><p style="margin-left:0cm;"> </p><p style="margin-left:9.45pt;text-align:center;">$50.00/month</p></td><td>All J-1 participants are required to have insurance for the duration of their programs. The insurance provided by Odyssey exceeds minimum program requirements.</td></tr><tr><td><p style="margin-left:0cm;"> </p><p style="margin-left:10.9pt;text-align:center;">SEVIS Fee</p></td><td><p style="margin-left:0cm;"> </p><p style="margin-left:9.45pt;text-align:center;">$35.00</p></td><td>Mandatory U.S. Government fee required to create and maintain an exchange visitor profile in the SEVIS system. This price includes a $20.00 service fee to create the SEVIS profile on behalf of the exchange visitor.</td></tr><tr><td><p style="margin-left:10.9pt;text-align:center;">Visa Application Fee</p></td><td><p style="margin-left:9.45pt;text-align:center;">$160.00</p></td><td>Mandatory fee to make a J-1 Visa appointment. Paid directly to the U.S. Government online.</td></tr><tr><td><p style="margin-left:10.9pt;text-align:center;">Site Visit*</p></td><td><p style="margin-left:9.45pt;text-align:center;">$295.00</p></td><td>Only required if host company does not meet minimum staffing or revenue requirements.</td></tr><tr><td><p style="margin-left:10.9pt;text-align:center;">Roundtrip Airfare</p></td><td><p style="margin-left:9.45pt;text-align:center;">$1,200.00</p></td><td>Estimated cost of airfare to and from the U.S.</td></tr><tr><td><p style="margin-left:10.9pt;text-align:center;">Arrival Funds</p></td><td><p style="margin-left:9.45pt;text-align:center;">$700.00</p></td><td>Minimum required personal funds all exchange visitors must have available upon arriving in the U.S.</td></tr></tbody></table></figure><p><u>SECTION 10: ARRIVAL AND ORIENTATION</u></p><ol><li>I agree to review all orientation materials provided by Odyssey, specifically the ODYSSEY Pre-Departure Orientation and the Odyssey Participant Handbook.</li><li>Odyssey recommends that I do not arrive more than a week prior to the start date on my DS-2019 form and that I cannot begin my program until the start date on the form.</li><li>I understand that ODYSSEY does not recommend purchasing any non-refundable items or tickets before my visa is approved.</li><li>I agree to communicate my arrival information as soon as possible to Odyssey by following the instruction of the Arrival Check in email sent by Odyssey.</li><li>I understand that I MUST check-in with Odyssey within 72 hours after arriving. Failure to do so within 10 days after arriving will automatically terminate my program.</li></ol><p><u>SECTION 11: HOST CAMP</u></p><ol><li>I understand that I can be terminated from my host camp for failing to comply with company policy. If I am terminated, I may be required to return home immediately without a refund. Odyssey will determine if a transfer to another host camp is appropriate.</li><li>I understand that some companies require drug tests. If I fail a drug test, I understand that I will be terminated and will need to leave the country according to Odyssey’s instructions.</li><li>I understand that Odyssey does not encourage changing host camps and will only do so as a last resort. I will not leave my camp without first consulting Odyssey or my program will be cancelled. Odyssey has the sole discretion whether or not to approve a change of host company.</li><li>I understand that Odyssey is only available to enforce the rules and regulations of the J-1 program. Odyssey cannot interfere with personal issues or matters of hearsay.</li><li>Odyssey is not responsible for loss of stipend, location transfer costs or any other transportation or accommodation expenses incurred due to termination, placement cancellation or change of location.</li><li>I understand that no position can be guaranteed for the duration of a program as businesses sometimes go out of business or experience financial hardships which could result in layoffs. In this case, Odyssey will assist the participant to the best of its abilities to secure a new position. I understand that alternate positions may not be comparable to my original position in position, stipend or location.</li></ol><p><u>SECTION 12: REFUNDS</u></p><ol><li><u>Registration Fee.</u> Applicants enrolling in Odyssey’s All-Inclusive program are required to pay a $40.00 registration fee before Odyssey begins the process of matching them to a prospective host. Registration fees are non-refundable.</li><li><u>Withdrawal After Placement is Confirmed</u>. If the Candidate cancels the placement or withdraws from the program due to any reason after a successful interview with the Host Company and receipt of the notification that confirms his/her Placement, the Candidate will be entitled to a refund of the program fee minus One Hundred and Ninety Five US Dollars (195.00 USD) which will be withheld and account for the administrative fees of OIC. If the Candidate fails to satisfy the Pre-arrival Liabilities and/or if the Candidate is unable to continue the program due to any academic reason, such as course failure, attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate and the administrative fees will be billed. The refund will be processed within 30 days after receipt of the refund request.</li><li><u>Withdrawal After Placement is Confirmed due to COVID-19</u>. If the Candidate cancels the placement or withdraws from the program due to COVID-19 after a successful interview with the Host Company and receipt of the notification that confirms his/her Placement, the Candidate will not be entitled to any refund. The Candidate will be re-placed at a new Host Company by OIC based on his/her preferences and eligibility requirements.</li><li><u>Withdrawal After Issuance of SEVIS number</u>. If the Candidate cancels the placement or withdraws from the program due to any reason after the issuance of the SEVIS number, the Candidate will not be entitled to any refund. If the Candidate fails to satisfy the Pre-arrival Liabilities and/or if the Candidate is unable to continue the program due to any academic reasons, such as course failure, attributable to the Candidate, it shall be deemed as a withdrawal by the Candidate.</li><li><u>Withdrawal After Issuance of SEVIS number due to COVID-19.</u> If the Candidate cancels the placement or withdraws from the program due to COVID-19 after the issuance of the SEVIS number, the Candidate will not be entitled to any refund. The Candidate will be re-placed at a new Host Company by OIC based on his/her preferences and eligibility requirements.</li><li><u>Embassy/Consulate Denial</u>. In case of a visa denial at the US Embassy, the Candidate must inform OIC within 3 business days of denial and return the original Form DS-2019 and proof of denial from the Embassy or Consulate within 10 Business Days from the date of denial in order to be eligible for refunds. The Candidate will be entitled to a refund of the program fee minus One Hundred and Ninety Five US Dollars (195.00 USD) which will be withheld; and account for the administrative fees of OIC. The refund will be processed within 30 days after receipt of the refund request. No refund will be issued if the documents are returned after the 10 Business Days deadline or if the documents are not returned to OIC.</li><li><u>Cancellation by the Host Company Prior to DS-2019 Issuance.</u> If the Host Company cancels the placement or withdraws from the program prior to the issuance of the DS-2019 document, The Candidate will be entitled to a refund of the program fee minus One Hundred and Ninety Five US Dollars (195.00 USD) which will be withheld; and account for the administrative fees of OIC. The refund will be processed within 30 days after receipt of the refund request. No refund will be issued if the documents are returned after the 10 Business Days deadline or if the documents are not returned to OIC.</li><li><u>Cancellation by the Host Company due to COVID-19.</u> If the Host Company cancels the placement or withdraws from the program prior to the program start date for any reasons related to COVID-19, no refunds will be issued. Candidate may retain their fees as a credit towards another program. OIC will attempt to re-place the Candidate at a new Host Company based on his/her preferences and eligibility requirements.</li><li><u>Cancellation After Arrival in the United States</u>. If the Candidate withdraws from the program or is unable to continue the program due to any reason after arrival in the US or if the Candidate is laid off or fired by the Host Company, the Candidate will not be entitled to any refund.</li><li><u>Refusal of Interviews</u>. If the Candidate refuses to interview with 2 or more potential Host Companies within the field of his preferences, the Candidate will be terminated from the program.</li></ol><p style="text-align:justify;"><u>SECTION 13: OTHER TERMS</u></p><ol><li>The Candidate understands that the Service Provider may cancel his/her application if the Service Provider determines that the Candidate fails to pass the eligibility requirements based on the rules and regulations by the Service Provider and/or the Program Sponsor.</li><li>The length of the program agreed upon by the Host Company and the Candidate shall be contingent on the Candidate’s performance as reviewed by the Host Company and does not bind the Host Company to the full duration if the Candidate does not meet the Host Company professional requirements or standards. The Candidate understands that if the Host Company determines that the Candidate does not perform his/her duties properly and/or the Candidate does not comply strictly with the regulations, the Host Company has the right to terminate or fire the Candidate. In which case, the Candidate will not be entitled to receive any refund.</li><li>If the Host Company goes out of business, files for bankruptcy, shuts down for any reason, or terminates or lays off the Candidate for lack of commercial activity, the Service Provider will assist the candidate in finding a new Host Company; however, the Service Provider cannot guarantee that a suitable new Host Company will be found within a reasonable time with due consideration of the full program duration and/or validity of the J1 Visa.</li><li>Candidate agrees to indemnify and hold harmless Odyssey, its officers and directors, employees and its affiliates and their respective successors and assigns and each other person, if any, who controls any thereof, against any loss, liability, claim, damage and expense whatsoever (including, but not limited to, any and all expenses whatsoever reasonably incurred in investigating, preparing, or defending against any litigation commenced or threatened or any claim whatsoever) arising out of or resulting from, or in connection with the services contemplated by this agreement.</li><li>The Candidate confirms that he/she is fit to participate in the Camp Counselor Program both physically and mentally, and understands that the experience can be stressful and may require participants to engage in physically strenuous activities. All pre-existing medical conditions must be made known to the Service Provider in writing at the time of application. Accommodations will be made whenever possible to allow applications from Candidates with non-serious medical conditions.</li></ol><p style="text-align:justify;">By signing below, I acknowledge that I have read and understood all sections of this terms and conditions document and agree to abide by its contents and instructions. (Please sign and date on the next page.)</p>' WHERE `system_settings`.`field` = 'camp_itn_agreement_content';
-----------------------------------------------------------------------------------------------------------------------
