# 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
33052729-4866-4d2b-ac01-6ead948dc60c

36 Lecturer Agreement Letter
ddc3e229-23c4-4418-addd-5f30a5cccfd5

38 ASE-AI-GS-Agreement-Letter
586c4d3f-e759-46a7-a7a2-da3114925351

40 ASE-GSI-Dual FLSA-Agreement-Letter
3752fff7-c1b1-4faa-8f7e-e2eddc8063c4

41 ASE-Hourly-Agreement-Letter
c7be801a-0cfa-456b-80cd-75442eedcbd5

42 ASE-GSI-Agreement-Letter
f48a527c-d2d1-471a-a666-27d12b2511cf


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 = '33052729-4866-4d2b-ac01-6ead948dc60c' where id = 34;
update ehire.ds_templates set template_id = 'ddc3e229-23c4-4418-addd-5f30a5cccfd5' where id = 36;
update ehire.ds_templates set template_id = '586c4d3f-e759-46a7-a7a2-da3114925351' where id = 38;
update ehire.ds_templates set template_id = '3752fff7-c1b1-4faa-8f7e-e2eddc8063c4' where id = 40;
update ehire.ds_templates set template_id = 'c7be801a-0cfa-456b-80cd-75442eedcbd5' where id = 41;
update ehire.ds_templates set template_id = 'f48a527c-d2d1-471a-a666-27d12b2511cf' 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;



