Cleans personnel CSV exports into a standalone SQLite database.
Project description
deped-hr
deped-hr cleans DepEd personnel CSV exports into a standalone SQLite artifact. It depends on a lookup database from deped-dcp-template and an entity artifact from deped-entity.
What This Package Owns
- Personnel row cleaning and normalization
- Entity loading for the personnel domain
- Position title seeding from
lookups.db - A staged, auditable rebuild pipeline over
artifacts/personnel.db - Personnel and ESF7 views for downstream reporting
- Audit metadata, row rejects, and compatibility files
This package is the source of truth for the personnel database contract only.
Main Workflow
just restart
This refreshes artifacts/lookups.db, incrementally rebuilds artifacts/personnel.db through the staged loader with the three ESF7 authority files, and runs hr audit.
Docs
- Build and CLI usage:
docs/operations/build.md - Database contract:
docs/reference/data-contract.md - Normalization and ESF7 matching:
docs/source-contracts/normalization.md - Downstream query patterns:
docs/reference/downstream-queries.md - Source data issues:
docs/analysis/evidence-diagnostics/source-data-issues.md
Notes
- ESF7 is mandatory because it is authoritative for school-level staffing counts; the personnel survey is the email source after audited matching.
hr buildremains compatible, but it requires all three ESF7 files and runs the staged loader with reset semantics.hr rebuildrequires all three ESF7 files while still skipping unchanged upstream stages.TINandphylsys_numfrom ESF7 are never stored in the artifact.
Tests
Run the package tests from this directory:
uv run pytest -q
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file deped_hr-0.3.0.tar.gz.
File metadata
- Download URL: deped_hr-0.3.0.tar.gz
- Upload date:
- Size: 360.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.11.8 {"installer":{"name":"uv","version":"0.11.8","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"macOS","version":null,"id":null,"libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a9e049cb2aa51b0fc3b29a7335af414e45b59cf67925ebce7bae7d65f2ea50fd
|
|
| MD5 |
405f17a04526b871cd10fe12d2285360
|
|
| BLAKE2b-256 |
c5c813b7b01cf9cc05f630d05406f23fa92b0f9372e39f6a5e50d9de321974c8
|
File details
Details for the file deped_hr-0.3.0-py3-none-any.whl.
File metadata
- Download URL: deped_hr-0.3.0-py3-none-any.whl
- Upload date:
- Size: 50.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.11.8 {"installer":{"name":"uv","version":"0.11.8","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"macOS","version":null,"id":null,"libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
2da7f829dcc28554943a130f2d00ca524cfb035b33a3bd9dfce96de8294977b0
|
|
| MD5 |
bd387136ec07cf7fc6a4f85a65a9d01a
|
|
| BLAKE2b-256 |
7cf921eb113e1fa25ccadee0ed9fd2e5d4513f23863f1d3af80bb1c3875760d8
|
