Employee Tuition Waiver LEAP Integration

Owned by David Chudnow (Deactivated)
Last updated: Jul 13, 2021

Overview

Employs the same LEAP/RESTful architecture as the  Dependent Tuition Waiver application and is secured using a different username/password pair.  The code base resides in the DTW application space (dtwwebapi.jar) with a unique package structure, which reduces the need for additional build/deploy resources.


Configuration:

Scripts

start-dtwWebapi.sh executes dtwWebapi.sh in the background to start the dtwwebapi RESTful application

stop-dtwWebApi.sh o stop the dtwwebapi RESTful application

 Directory structure

/srv/uconn_configs/webapi/dtwwebapi

/srv/uconn_configs/webapi/dtwwebapi/config

/srv/uconn_configs/webapi/dtwwebapi/logs

/srv/uconn_configs/webapi/dtwwebapi/config/empltwwebapi.properties
etw.user=empltwuser
etw.user.password=[password]
etw.user.bcrypt.hash=[bcrypt hash]
campus.mappings=STORR=Storrs,UCHC=Health Center,HRTFD=Hartford,AVYPT=Avery Point,STMFD=Stamford,WTBY=Waterbury,LAW=Law
etw.exportdate.id=61d2b7b7-b3ca-4a26-8f23-caa453ec3e00
etw.department.type.code=8
etw.uchc.eligible.subject=PUBH
etw.mngr.union.code=02
hr.mail.fromAddress=noreply.hr@uconn.edu
etw.action.by.day=7
#
#LEAP Integration
#
leap.user=feb_ent_financials
leap.password=3nt$in@nc1@ls
##dev
etw.leap.base.url=https://hclleap-prod1.its.uconn.edu:9443

## prod
##etw.base.url=https://hclleap-prod2.its.uconn.edu

etw.leap.data.path=/apps-basic/secure/org/data/
etw.leap.form.path=/apps/secure/org/app/

## exports (phase 2)
## dev
etw.export.file.path=/srv/uconn_configs/webapi/dtwwebapi/etw/
## prod
##etw.export.file.path=/home/etw
etw.export.file.name=etw.prn
#
# leap form fields
#
etw.leap.form.id=F_Waiver
etw.leap.appl.id=5af486f2-d9a1-44b3-8b5c-2330e636b049
etw.leap.launch.form=/launch/index.html?form=
etw.spvr.first.name=F_SupFirstName
etw.spvr.last.name=F_SupLastName
etw.spvr.email=F_SupEmail
etw.waiver.status=F_WaiverStatus
etw.empl.first.name=F_FirstName
etw.empl.last.name=F_LastName
etw.empl.email=F_EmailAddress
etw.request.date=F_RequestDate
#
etw.form.exported=F_Exported
etw.leap.id=F_RecUid
etw.form.percent=F_PercentEligible
etw.form.pplsoftid=F_PsNumber
etw.form.employee.nbr=F_EmplNumber
etw.form.spouse.pplsoftid=F_SpousePsId
etw.form.export.pplsoftid=F_ExportPsId
etw.form.empl.first.name=F_FirstName
etw.form.empl.last.name=F_LastName
etw.form.empl.union=F_EmplAffiliation
etw.form.spouse.name=F_SpouseName
etw.form.spouse.waiver=F_SpousalWaiver
etw.form.rqst.date=F_RequestDate
etw.form.uchc=F_fromUch
etw.form.current.term=F_CurTermDisplay
etw.form.hr.review.date=F_HrReviewDate
##
etw.form.academic.status=F_AcademicStatus
etw.form.degree.qry=F_JdPhdAprn
etw.form.job.related=F_JobRelated
etw.form.subject=F_Subject
etw.form.job.descr=F_jobDescription
etw.form.spouse.elig=F_SpsEligible
etw.form.grad.lvl.selction=F_GradLevelSelection
etw.formacademic.career=F_SrchCareer
## final status
etw.uconn.final=ST_UcFinal
etw.uchc.final=ST_UchFinal

The application also uses the database connection information locatedf in /srv/uconn_configs/webapi/config/security.properties.

RESTful web services

Url base

Production: https://api.dtw.uconn.edu/emplTuitionWaiver

Development: https://dev.api.dtw.uconn.edu/emplTuitionWaiver

Resources

/employeeInfo

/employeeEligiblity

/spouseEligibility

/degreeProgram

/coursesBySubject

/courseListCurrentTerm

/eligibleUnions

/academicCareers

/academicSubjects

/currentTerm

/campusList

/academicTerms

/sendEtwSpvrReminders