Workforce App

Purpose

The workforce app will enable senior leadership to asses the strengths and weaknesses of the CoP workforce across districts and divisions. Rather than utilizing various data calls with spreadsheets, this will provide a single source for supervisors and senior leadership to assess workforce capabilities/strengths.

---

Scope Objectives

• Handle district supervisor, division supervisor and CoP lead roles.
• Allow supervisor to load all direct employees (bulk load screen?)
• Reports will include:
  • Demographics (years of service, age)
  • Employee Strengths
  • Credentials/Degrees
  • Grade Level
  • etc

--

Random Notes

• No employee names will be stored. Avoid PII
• Position is a driving entity. Position view showing employee changes
• Position could be added/eliminated, eliminated would retain history?
• Discourage deletions
• Allow employee/occupant to be moved between positions (temp assignments)
• Track/Report on Vacant positions?

---

Application Implementation

Environment Variables

Environment variables are defined in the Docker Compose file for local development. Not all variables defined will transpose to the implementation. The following are variables designed to be used in the Infrastructure as Code, AWS Secrets, or where appropriate.

Environment Variable Name	Local Development	AWS Defined	API Config Required	API Config Default	AWS Value
AWS_ACCESS_KEY_ID	X
AWS_SECRET_ACCESS_KEY	X
AWS_DEFAULT_REGION	X	X
AWS_DISABLE_SSL	X
AWS_S3_FORCE_PATH_STYLE	X
AUTH_ENVIRONMENT	X	X			determined by ENVIRONMENT
AUTH_PUBLIC_KEY	X	X			determined by ENVIRONMENT
MINIO_ENDPOINT_URL	X
PGUSER	X	X	X		workforce_user
PGPASSWORD	X	X	X
PGDATABASE	X	X	X
PGHOST	X	X	X
PGSSLMODE	X		X	require
PGX_POOL_MAXCONNS	X			10
PGX_POOL_MINCONNS	X			5
PGX_POOL_MAXCONN_IDLETIME	X			30m
S3_BUCKET	X	X	X		hhc-shared-ENVIRONMENT
S3_DEFAULT_INDEX	X			index.html
S3_PREFIX_STATIC	X	X		/	/workforce/ui
RESOURCE_ACCESS_ROLES	X	X		public
API_PORT	X			8080
API_LOG	X			false