# 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
2837a274-99fe-49c2-ba7c-4bd28da589bb

36 Lecturer Agreement Letter
34012668-54e2-4ca5-ba85-5bc8eb7d0a5a

38 ASE-AI-GS-Agreement-Letter
11efd05d-cbf8-43a6-b1cc-2da96b9e01db

40 ASE-GSI-Dual FLSA-Agreement-Letter
d34c7da1-3aab-4628-9d05-e191a0b91288

41 ASE-Hourly-Agreement-Letter
6f4bc3bd-1edf-4e9a-8e91-9ff76eecf8ef

42 ASE-GSI-Agreement-Letter
144907fc-fa86-4e82-8717-8c1d6a9e22e2


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 ds_templates set template_id = '2837a274-99fe-49c2-ba7c-4bd28da589bb' where id = 34;
#update ds_templates set template_id = '938416ba-b98b-4cbb-8b12-99ec619f85de' where id = 35;
update ds_templates set template_id = '34012668-54e2-4ca5-ba85-5bc8eb7d0a5a' where id = 36;
#update ds_templates set template_id = '56b16e0c-5473-49bb-9fea-67d98d8da80b' where id = 37;
update ds_templates set template_id = '11efd05d-cbf8-43a6-b1cc-2da96b9e01db' where id = 38;
#update ds_templates set template_id = '73202c3a-0157-4e49-819b-89e65e0507f5' where id = 39;
update ds_templates set template_id = 'd34c7da1-3aab-4628-9d05-e191a0b91288' where id = 40;
update ds_templates set template_id = '6f4bc3bd-1edf-4e9a-8e91-9ff76eecf8ef' where id = 41;
update ds_templates set template_id = '144907fc-fa86-4e82-8717-8c1d6a9e22e2' where id = 42;

commit;
