# profiles

id: 51e71887-4693-47d7-94aa-f21e93701a59
email: dean@occp.local
email_key: dean@occp.local
full_name: Dr. Amelia Ferrer (Demo Super Admin)
role: SUPER_ADMIN
password_salt: 1e88a7eb48fa380e660bbd555aafb8ff
created_at: 2026-08-24T05:49:57.368Z
updated_at: 2026-08-24T05:49:57.368Z
password_hash:
  6a846885abb1e8b638991f6a4d8277282a3d0991cb1d7775f16abea55e456418633f08dc9d5796d66e46a883bdd5beee066294167709c7dda23a5b76f123c0a1


id: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
email: admin@occp.local
email_key: admin@occp.local
full_name: Dr. Ramon Cabrera (Demo Dean Admin)
role: DEAN_ADMIN
password_salt: c090c6b72eec2aae1b0493f68c431ab9
created_at: 2026-08-24T05:49:57.404Z
updated_at: 2026-08-24T05:49:57.404Z
password_hash:
  9eb27c62107d052d541d67edbcf3750c3214ba9192d34617bf905a1c1396afc736cb09cd81fd608c8790603c18355e16526071b9c89c554ef42d20ad21f40020


id: ca6c9c17-6fd2-4e11-b4a8-e7e2eda91401
email: encoder@occp.local
email_key: encoder@occp.local
full_name: Jesse Aparicio (Demo Encoder)
role: ENCODER
password_salt: 7b11081f2ab899c740ad1d521c7461bf
created_at: 2026-08-24T05:49:57.440Z
updated_at: 2026-08-24T05:49:57.440Z
password_hash:
  6c4a63c6ae936da009dc50e6d0dcfc72b9505a66aac56a028e7c2482aa4822b41dd8bcb36be82844c3e8bd7520dde84c488d95a924ccbbab1c1987379433a27c


id: 63c0d94b-03d5-4869-acb5-70ccc6a7ea7e
email: viewer@occp.local
email_key: viewer@occp.local
full_name: Robin Salcedo (Demo Viewer)
role: VIEWER
password_salt: adf35355cd29f76c99fcac7f697c454d
created_at: 2026-08-24T05:49:57.476Z
updated_at: 2026-08-24T05:49:57.476Z
password_hash:
  faf9e1f69340e42e7a294f28638f338d429c58bebfb726d198e8b05bec38f77999e315d1d11b2a58c7c3bd7eca5a421b2bba1a257608a89ed36ee54246f15d6b


# sessions

id: 21cef53f2b7445db5277a9ffed6a90882da75edc0cd389486bcb8576f3eb4346
user_id: 51e71887-4693-47d7-94aa-f21e93701a59
created_at: 2026-08-24T07:01:40.444Z
expires_at: 2026-08-24T19:01:40.444Z
user_agent:
  Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Claude/1.34493.1 Chrome/148.0.7778.280 Electron/42.9.2 Safari/537.36 MSIX


id: c1181ec6eacc315f43967a2165fb1bf7e08b26faeb24e2d4436a42d451089e57
user_id: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
created_at: 2026-08-24T15:26:23.089Z
expires_at: 2026-08-25T03:26:23.089Z
user_agent:
  Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36


id: 18c364df2aeb18ec03c7487ff9feadda47be0e2b3d35b787360f622abd0b76e5
user_id: 51e71887-4693-47d7-94aa-f21e93701a59
created_at: 2026-08-28T01:31:58.687Z
expires_at: 2026-08-28T13:31:58.687Z
user_agent:
  Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Claude/1.37937.3 Chrome/148.0.7778.280 Safari/537.36 MSIX


# curricula

id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
code: CURR-SRC-2026
name: Approved MMC CAST MD Curriculum (source workbook)
version: 1
status: DRAFT_REVIEW
year_long_credit_policy: ON_FINAL_PASS
source_name: Approved MMC CAST MD Curriculum
source_workbook: Proposed Curriculum AY 2026-2027 and Breakdown of Lec and Lab.xlsx
primary_effective_ay: 2026-2027
secondary_sheet_effective_ay: 2024-2025
mapping_status: REQUIRES_ADMIN_CONFIRMATION
created_at: 2026-08-24T05:49:57.477Z
updated_at: 2026-08-24T05:49:57.477Z
program_id: f1e95f9c-e20d-42df-8380-8ccb33489f0b
notes:
  Imported from the official MMC CAST workbook. Not yet mapped to an institutional curriculum type — the source sheets carry conflicting effective academic years.


id: 266a9c6f-927b-4182-94b8-5ef32223f06d
code: DEMO-A
name: DEMO ONLY — NOT MMC CAST OFFICIAL DATA — Sample Medicine Curriculum A
version: 1
status: PUBLISHED
year_long_credit_policy: ON_FINAL_PASS
published_at: 2026-08-24T05:49:57.483Z
created_at: 2026-08-24T05:49:57.482Z
updated_at: 2026-08-24T05:49:57.483Z
program_id: f1e95f9c-e20d-42df-8380-8ccb33489f0b
notes:
  Fictional demonstration curriculum generated by the seed script. It exists only so the prototype is usable before the official MMC CAST workbooks are imported. Do not use for real assessment.


# non_unit_requirements

id: 761cf3d4-be7d-4e3d-8a4b-46a6cf367447
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
requirement_type: SUMMER_TRAINING
code: CI1
title: Summer Enhancement Program
term: SUMMER
source_sheet: CURRICULUM
created_at: 2026-08-24T05:49:57.481Z
updated_at: 2026-08-24T05:49:57.481Z
notes:
  Training duration: 2 weeks. Primary CURRICULUM sheet value; the BREAKDOWN sheet labels this row "Community Immersion".


id: 233d83c9-b959-488b-a474-a583557d6c06
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
requirement_type: SUMMER_TRAINING
code: CI1
title: Community Immersion
term: SUMMER
source_sheet: CURRICULUM
created_at: 2026-08-24T05:49:57.481Z
updated_at: 2026-08-24T05:49:57.481Z
notes:
  Training duration: 2 weeks. Primary CURRICULUM sheet codes this CI1; the BREAKDOWN sheet codes it CI2.


# audit_logs

id: c3656297-fc1c-4e11-ac76-9d19bfa5c907
actor_user_id: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
actor_email: admin@occp.local
action: CURRICULUM_IMPORTED
entity_type: curriculum
entity_id: 5252967b-9f3b-4bd0-9c7b-4eb1a74279e9
created_at: 2026-08-24T15:51:09.486Z
after_json:
  {"code":"CURR 2025","source_workbook":"OCCP_Curriculum_Import_ 2025.xlsx","worksheet":"Curriculum","courses":72,"total_units":252}


id: bbf3f369-46db-45e0-a1e6-5fb958e6ee4b
actor_user_id: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
actor_email: admin@occp.local
action: CURRICULUM_VALIDATION_ACKNOWLEDGED
entity_type: curriculum
entity_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
reason: Administrator acknowledged this source-file issue. The record is retained, never deleted.
created_at: 2026-08-24T15:52:37.992Z
after_json:
  {"code":"CURRICULUM_TYPE_MAPPING_REQUIRED","message":"This dataset is not yet mapped to Curriculum 2023, 2024 or 2025. An administrator must confirm the mapping before students can be auto-assigned to it. It must not be cloned into all three curriculum types."}


id: 589a695f-a971-4ec5-805c-3fcb2c5e2493
actor_user_id: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
actor_email: admin@occp.local
action: CURRICULUM_VALIDATION_ACKNOWLEDGED
entity_type: curriculum
entity_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
reason: Administrator acknowledged this source-file issue. The record is retained, never deleted.
created_at: 2026-08-24T15:52:38.682Z
after_json:
  {"code":"ORPHAN_PREREQUISITE_REFERENCE","message":"Ethics 2-A lists prerequisite \"Ethics 1\", but no Ethics 1 course exists in the unit-bearing course list. No course was invented to resolve this reference."}


id: 6d32e4bc-5ed4-47d5-9777-c74ad4624715
actor_user_id: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
actor_email: admin@occp.local
action: CURRICULUM_VALIDATION_ACKNOWLEDGED
entity_type: curriculum
entity_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
reason: Administrator acknowledged this source-file issue. The record is retained, never deleted.
created_at: 2026-08-24T15:52:39.325Z
after_json:
  {"code":"SUMMER_CODE_MISMATCH_THIRD_YEAR","message":"Third Year summer requirement is coded CI1 in CURRICULUM but CI2 in BREAKDOWN LEC AND LAB. The primary sheet value was used."}


id: 9b5e26a3-3014-4512-aca7-65eeca7a1eca
actor_user_id: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
actor_email: admin@occp.local
action: CURRICULUM_VALIDATION_ACKNOWLEDGED
entity_type: curriculum
entity_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
reason: Administrator acknowledged this source-file issue. The record is retained, never deleted.
created_at: 2026-08-24T15:52:40.442Z
after_json:
  {"code":"SUMMER_TITLE_MISMATCH_SECOND_YEAR","message":"Second Year summer requirement CI1 is titled \"Summer Enhancement Program\" in CURRICULUM but \"Community Immersion\" in BREAKDOWN LEC AND LAB. The primary sheet value was used."}


id: 115e3036-1590-48ce-ac09-6282112be904
actor_user_id: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
actor_email: admin@occp.local
action: CURRICULUM_VALIDATION_ACKNOWLEDGED
entity_type: curriculum
entity_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
reason: Administrator acknowledged this source-file issue. The record is retained, never deleted.
created_at: 2026-08-24T15:52:40.950Z
after_json:
  {"code":"EFFECTIVE_AY_MISMATCH","message":"The CURRICULUM sheet states Effective Academic Year 2026-2027, while the BREAKDOWN LEC AND LAB sheet states 2024-2025. The institutional curriculum type was not inferred from these labels."}


id: 608b914f-d827-4e35-9a84-b6765f6fec66
actor_user_id: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
actor_email: admin@occp.local
action: CURRICULUM_VALIDATION_ACKNOWLEDGED
entity_type: curriculum
entity_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
reason: Administrator acknowledged this source-file issue. The record is retained, never deleted.
created_at: 2026-08-24T15:52:41.484Z
after_json:
  {"code":"MEDICAL_COURSES_SUMMARY_DISCREPANCY","message":"The workbook's summary row states \"Medical Courses — 235 Units\", but the six unit-bearing semester totals sum to 237 units and the workbook's own final total also states 237 units. Detailed course units were NOT altered to force a 235-unit sum. Production default: 237 units."}


# curriculum_validation_issues

id: 92d43c5e-4350-4375-8c4c-66a11462e5c5
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
code: DETAILED_UNIT_SUM
severity: INFO
message: Detailed course-unit sum reproduces 237 units across 57 unit-bearing rows.
created_at: 2026-08-24T05:49:57.482Z
details_json:
  {"semesterTotals":[{"year":1,"term":"1ST SEMESTER","units":37},{"year":1,"term":"2ND SEMESTER","units":35},{"year":2,"term":"1ST SEMESTER","units":41},{"year":2,"term":"2ND SEMESTER","units":41},{"year":3,"term":"1ST SEMESTER","units":40},{"year":3,"term":"2ND SEMESTER","units":43}],"expectedRows":57,"expectedTotal":237}


id: 790a8747-1409-40a2-ab7f-62cbf0a0ab26
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
code: MEDICAL_COURSES_SUMMARY_DISCREPANCY
severity: WARNING
details_json: {"summaryRow":235,"detailedSum":237,"workbookFinalTotal":237}
acknowledged_by: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
acknowledged_at: 2026-08-24T15:52:41.484Z
created_at: 2026-08-24T05:49:57.482Z
message:
  The workbook's summary row states "Medical Courses — 235 Units", but the six unit-bearing semester totals sum to 237 units and the workbook's own final total also states 237 units. Detailed course units were NOT altered to force a 235-unit sum. Production default: 237 units.


id: b363055d-bb27-400e-8502-1e77245c3bc2
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
code: EFFECTIVE_AY_MISMATCH
severity: WARNING
acknowledged_by: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
acknowledged_at: 2026-08-24T15:52:40.950Z
created_at: 2026-08-24T05:49:57.482Z
message:
  The CURRICULUM sheet states Effective Academic Year 2026-2027, while the BREAKDOWN LEC AND LAB sheet states 2024-2025. The institutional curriculum type was not inferred from these labels.


id: 3de4f81b-5935-4bf8-b752-53266f42377e
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
code: SUMMER_TITLE_MISMATCH_SECOND_YEAR
severity: WARNING
acknowledged_by: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
acknowledged_at: 2026-08-24T15:52:40.442Z
created_at: 2026-08-24T05:49:57.482Z
message:
  Second Year summer requirement CI1 is titled "Summer Enhancement Program" in CURRICULUM but "Community Immersion" in BREAKDOWN LEC AND LAB. The primary sheet value was used.


id: a74c80ea-d119-4c9f-8141-3f6f55d5bec3
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
code: SUMMER_CODE_MISMATCH_THIRD_YEAR
severity: WARNING
acknowledged_by: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
acknowledged_at: 2026-08-24T15:52:39.325Z
created_at: 2026-08-24T05:49:57.482Z
message:
  Third Year summer requirement is coded CI1 in CURRICULUM but CI2 in BREAKDOWN LEC AND LAB. The primary sheet value was used.


id: 4f2589ce-4aef-4d73-a917-d0bae1e54799
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
code: ORPHAN_PREREQUISITE_REFERENCE
severity: WARNING
details_json: {"course":"Ethics 2-A","missingPrerequisite":"Ethics 1"}
acknowledged_by: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
acknowledged_at: 2026-08-24T15:52:38.682Z
created_at: 2026-08-24T05:49:57.482Z
message:
  Ethics 2-A lists prerequisite "Ethics 1", but no Ethics 1 course exists in the unit-bearing course list. No course was invented to resolve this reference.


id: 37ed9ce3-5171-4f42-869b-ec63b17a2a47
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
code: SECONDARY_SHEET_MISSING_DESCRIPTION
severity: INFO
created_at: 2026-08-24T05:49:57.482Z
message:
  PHYSIO 1-A has a blank subject description in BREAKDOWN LEC AND LAB. The CURRICULUM title "Normal Organ Systems (Function)" was used.


id: 08036c44-b79f-49e9-9be8-7ea7341fd27a
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
code: CURRICULUM_TYPE_MAPPING_REQUIRED
severity: WARNING
acknowledged_by: 19b8cc62-d2fe-4c44-bfc8-398a47742ece
acknowledged_at: 2026-08-24T15:52:37.992Z
created_at: 2026-08-24T05:49:57.482Z
message:
  This dataset is not yet mapped to Curriculum 2023, 2024 or 2025. An administrator must confirm the mapping before students can be auto-assigned to it. It must not be cloned into all three curriculum types.


id: 8598ec56-cac9-4765-8ec8-23991f8351ee
curriculum_id: 6ca13e91-a1d9-4cd3-9059-cedec6130691
code: NON_UNIT_REQUIREMENTS_EXCLUDED
severity: INFO
created_at: 2026-08-24T05:49:57.482Z
message:
  15 non-unit requirements (2 summer training requirements and the 12-month clinical clerkship, reference 365 days) are tracked separately and are excluded from the 237-unit denominator.


id: 4d444c96-ecf8-4ad7-9017-f2e32d537a14
curriculum_id: 5252967b-9f3b-4bd0-9c7b-4eb1a74279e9
code: IMPORTED_FROM_WORKBOOK
severity: INFO
created_at: 2026-08-24T15:51:09.486Z
message:
  Imported 72 course rows totalling 252 program units from "OCCP_Curriculum_Import_ 2025.xlsx" / "Curriculum".


id: 6eda6f32-f266-47c9-b7ba-b50f0661be42
curriculum_id: 5252967b-9f3b-4bd0-9c7b-4eb1a74279e9
code: CURRICULUM_TYPE_MAPPING_REQUIRED
severity: WARNING
created_at: 2026-08-24T15:51:09.486Z
message:
  This imported curriculum is not yet mapped to an institutional curriculum type (2023 / 2024 / 2025). An administrator must confirm the mapping.


