# 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
f07e0b83-12a4-4e5d-8550-2e1ae98ee549

36 Lecturer Agreement Letter (Instructor)
ad8e4750-8844-41d9-b9df-3c449e1e932c

38 ASE-AI-GS-Agreement-Letter (Acting Instructor)
3cfb69d4-f3f5-4335-9bfc-420b65dab76f

40 ASE-GSI-Dual FLSA-Agreement-Letter (Dual FLSA)
e60ddcd5-5d3c-4563-af5c-1aa36dafba3b

41 ASE-Hourly-Agreement-Letter (Hourly)
03e77a07-6b7a-4820-9892-3ac0442975ea

42 ASE-GSI-Agreement-Letter (GSI)
847b606f-c857-437a-a533-e787948ac69e


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 = 'f07e0b83-12a4-4e5d-8550-2e1ae98ee549' where id = 34;
update ehire.ds_templates set template_id = 'ad8e4750-8844-41d9-b9df-3c449e1e932c' where id = 36;
update ehire.ds_templates set template_id = '3cfb69d4-f3f5-4335-9bfc-420b65dab76f' where id = 38;
update ehire.ds_templates set template_id = 'e60ddcd5-5d3c-4563-af5c-1aa36dafba3b' where id = 40;
update ehire.ds_templates set template_id = '03e77a07-6b7a-4820-9892-3ac0442975ea' where id = 41;
update ehire.ds_templates set template_id = '847b606f-c857-437a-a533-e787948ac69e' where id = 42;

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

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

commit;



