# profiles

id: 1e6f7573-bb84-4c34-a7dd-3a10ff6e46f0
email: dean@occp.local
email_key: dean@occp.local
full_name: Dr. Amelia Ferrer (Demo Super Admin)
role: SUPER_ADMIN
password_salt: 8069270c7bb48099446ee9cc398db47e
created_at: 2026-08-28T01:35:51.199Z
updated_at: 2026-08-28T01:35:51.199Z
password_hash:
  493b4688f6df6c35f18fcc30fd2a5993fbca88973aac804bbd2a86f58fb3724ad224977c1284a29f05e7b26a262828a803f7e9557c34848b1eee830947ac5d4c


id: b014dd34-134c-447f-923a-2cfbafb710b8
email: admin@occp.local
email_key: admin@occp.local
full_name: Dr. Ramon Cabrera (Demo Dean Admin)
role: DEAN_ADMIN
password_salt: dda609b05d0c76be2bbd133fdd69bcce
created_at: 2026-08-28T01:35:51.235Z
updated_at: 2026-08-28T01:35:51.235Z
password_hash:
  b3adf58db1080382f2505528a4e8c3e0aec0383e461cbc852a00e2431b371bba832a9c5637d8f22ad3e91e0f263952836b4176596d62b74abafaa9bc2290dc42


id: 7f35d715-d080-40ba-88be-6853a0e03f28
email: encoder@occp.local
email_key: encoder@occp.local
full_name: Jesse Aparicio (Demo Encoder)
role: ENCODER
password_salt: 78c2541ddbf2f36f66189cc7b7667077
created_at: 2026-08-28T01:35:51.269Z
updated_at: 2026-08-28T01:35:51.269Z
password_hash:
  cd821d0632b3f2010eae9c0b27ab7bfdd4e5e158a1828d35afa7ff1885da30dd4d9c5bd9dbf637fc35728483e844c754100724fbc1d3979268949bb775d52fb9


id: a3b68721-ba86-4a70-9a23-0f8254304e01
email: viewer@occp.local
email_key: viewer@occp.local
full_name: Robin Salcedo (Demo Viewer)
role: VIEWER
password_salt: 6ae08770acdd455dd4e367d7e1a816db
created_at: 2026-08-28T01:35:51.305Z
updated_at: 2026-08-28T01:35:51.305Z
password_hash:
  88c4d4da86422fc303901e14ceffc47f37ef13eee969b4b26ba1b1511837e40bf1eccc36bcae9d543f3f3c469351a158e737a4d3da9dd366febd9b6fbab13c92


# curricula

id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
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
program_id: aef232ed-7166-462c-a87f-d00f25213536
created_at: 2026-08-28T01:35:51.306Z
updated_at: 2026-08-28T01:35:51.306Z
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: e79302e6-4e6e-477b-ae67-7d799db64552
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-28T01:35:51.311Z
program_id: aef232ed-7166-462c-a87f-d00f25213536
created_at: 2026-08-28T01:35:51.311Z
updated_at: 2026-08-28T01:35:51.311Z
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: 138a369b-705a-4cab-838d-d9b3a4a3bdcf
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
requirement_type: SUMMER_TRAINING
code: CI1
title: Summer Enhancement Program
term: SUMMER
source_sheet: CURRICULUM
created_at: 2026-08-28T01:35:51.309Z
updated_at: 2026-08-28T01:35:51.309Z
notes:
  Training duration: 2 weeks. Primary CURRICULUM sheet value; the BREAKDOWN sheet labels this row "Community Immersion".


id: 3eb903d3-c4dc-423f-b584-90d4420b6e0d
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
requirement_type: SUMMER_TRAINING
code: CI1
title: Community Immersion
term: SUMMER
source_sheet: CURRICULUM
created_at: 2026-08-28T01:35:51.309Z
updated_at: 2026-08-28T01:35:51.309Z
notes:
  Training duration: 2 weeks. Primary CURRICULUM sheet codes this CI1; the BREAKDOWN sheet codes it CI2.


# curriculum_validation_issues

id: 896057a2-f509-4139-85ae-abb7a0278064
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
code: DETAILED_UNIT_SUM
severity: INFO
message: Detailed course-unit sum reproduces 237 units across 57 unit-bearing rows.
created_at: 2026-08-28T01:35:51.310Z
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: 7825c81e-2ff0-41f2-a4cc-17b0cc744b29
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
code: MEDICAL_COURSES_SUMMARY_DISCREPANCY
severity: WARNING
details_json: {"summaryRow":235,"detailedSum":237,"workbookFinalTotal":237}
created_at: 2026-08-28T01:35:51.310Z
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: 434ab134-1f7b-41f4-918a-99aeb53eb8d9
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
code: EFFECTIVE_AY_MISMATCH
severity: WARNING
created_at: 2026-08-28T01:35:51.310Z
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: bc40518f-38e2-44ca-a41a-7498795cb09e
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
code: SUMMER_TITLE_MISMATCH_SECOND_YEAR
severity: WARNING
created_at: 2026-08-28T01:35:51.310Z
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: fe253350-9cfc-4472-b81f-4943e8108498
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
code: SUMMER_CODE_MISMATCH_THIRD_YEAR
severity: WARNING
created_at: 2026-08-28T01:35:51.310Z
message:
  Third Year summer requirement is coded CI1 in CURRICULUM but CI2 in BREAKDOWN LEC AND LAB. The primary sheet value was used.


id: 1e0a37db-9fe5-4fc2-9be8-dd49a0c0ab02
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
code: ORPHAN_PREREQUISITE_REFERENCE
severity: WARNING
details_json: {"course":"Ethics 2-A","missingPrerequisite":"Ethics 1"}
created_at: 2026-08-28T01:35:51.310Z
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: 37c4617a-c276-47dc-bade-616ac3c8cf75
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
code: SECONDARY_SHEET_MISSING_DESCRIPTION
severity: INFO
created_at: 2026-08-28T01:35:51.311Z
message:
  PHYSIO 1-A has a blank subject description in BREAKDOWN LEC AND LAB. The CURRICULUM title "Normal Organ Systems (Function)" was used.


id: 7877d872-3ff0-4bc1-b2ab-87012cf48c41
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
code: CURRICULUM_TYPE_MAPPING_REQUIRED
severity: WARNING
created_at: 2026-08-28T01:35:51.311Z
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: 40f48e07-b48c-4ea7-b065-bf101dc6f248
curriculum_id: 52e9a3f8-d77b-4db6-92d3-36efefb13cfc
code: NON_UNIT_REQUIREMENTS_EXCLUDED
severity: INFO
created_at: 2026-08-28T01:35:51.311Z
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.


