# Sets up eHire to use the 2023 Development DocuSign documents 
# (These can get overwritten when the database is copied over from production.)

/*
34 Faculty-Agreement-Letter
4452e23b-13a8-4123-b3f7-f0df639938b9

36 Lecturer Agreement Letter (Instructor)
c36b3312-b3aa-4f9b-88f7-1f535c534f4b

38 ASE-AI-GS-Agreement-Letter (Acting Instructor)
24432875-dc33-47ad-8daf-fb71a0867890

40 ASE-GSI-Dual FLSA-Agreement-Letter (Dual FLSA)
15c98cfe-20e9-4738-b214-8556d34eba16

41 ASE-Hourly-Agreement-Letter (Hourly)
4403cc16-959f-4078-933c-d5b748940969

42 ASE-GSI-Agreement-Letter (GSI)
7cc99b39-292a-45fb-a027-2d5ee94c0ab8


The following documents are listed in the ds_templates table
but are not in Docusign.
############################################################

35 2022-Faculty-Online-Agreement Letter
37 2022-Lecturer-Online-Agreement-Letter
39 2022-ASE-GSI-Online-Agreement-Letter

*/


update ehire.ds_templates set template_id = '4452e23b-13a8-4123-b3f7-f0df639938b9' where id = 34;
update ehire.ds_templates set template_id = 'c36b3312-b3aa-4f9b-88f7-1f535c534f4b' where id = 36;
update ehire.ds_templates set template_id = '24432875-dc33-47ad-8daf-fb71a0867890' where id = 38;
update ehire.ds_templates set template_id = '15c98cfe-20e9-4738-b214-8556d34eba16' where id = 40;
update ehire.ds_templates set template_id = '4403cc16-959f-4078-933c-d5b748940969' where id = 41;
update ehire.ds_templates set template_id = '7cc99b39-292a-45fb-a027-2d5ee94c0ab8' where id = 42;

update ehire.ds_templates set year = '2024' where id = 34;
update ehire.ds_templates set year = '2024' where id = 36;
update ehire.ds_templates set year = '2024' where id = 38;
update ehire.ds_templates set year = '2024' where id = 40;
update ehire.ds_templates set year = '2024' where id = 41;
update ehire.ds_templates set year = '2024' where id = 42;

update ehire.ds_templates set template_name = '2024-Faculty-Agreement-Letter' where id = 34;
update ehire.ds_templates set template_name = '2024-Lecturer-Agreement-Letter' where id = 36;
update ehire.ds_templates set template_name = '2024-ASE-AI-GS-Agreement-Letter' where id = 38;
update ehire.ds_templates set template_name = '2024-ASE-GSI-Dual FLSA-Agreement-Letter' where id = 40;
update ehire.ds_templates set template_name = '2024-ASE-Hourly-Agreement-Letter' where id = 41;
update ehire.ds_templates set template_name = '2024-ASE-GSI-Agreement-Letter' where id = 42;


commit;



