Singapore Education Account Lifecycle - F01 Batch Workflow

Automatic Account Creation & Business Rules Engine (Sprint 1 MVP)

Singapore Education Account Lifecycle - F01 Batch Workflow Automatic Account Creation & Business Rules Engine (Sprint 1 MVP) 01 / Job Scheduler & Trigger (SGT) 02 / Batch Creation Engine & Decision Gates EX / Exception & Rejection Channels 04 / Core DB & Lifecycle Audit Trail Phase 1: Ingestion & Scan Phase 2: Validation Gates (BR01 - BR03) Phase 3: Provision & Atomic Commit Eligibility & Duplicate Verification Audit Rejection Logging (AF01 - AF03, EF01) Atomic DB Transaction Boundary Daily Cron Trigger · SGT 00:00 Daily Job · Job Scheduler & Trigger (SGT) › Phase 1: Ingestion & Scan · automated Daily Cron Trigger SGT 00:00 Daily Job automated Student Dataset · Person ID, DOB, SC · Batch Creation Engine & Decision Gates › Phase 1: Ingestion & Scan · batch input Student Dataset Person ID, DOB, SC batch input Gate 1: Data Check · NRIC, Name, DOB, SC · Batch Creation Engine & Decision Gates › Eligibility & Duplicate Verification › Phase 2: Validation Gates (BR01 - BR03) · null check Gate 1: Data Check NRIC, Name, DOB, SC null check Gate 2 & 3: SC & Age · SC & 7 <= Age < 16 · Batch Creation Engine & Decision Gates › Eligibility & Duplicate Verification › Phase 2: Validation Gates (BR01 - BR03) · BR01 & BR02 Gate 2 & 3: SC & Age SC & 7 <= Age < 16 BR01 & BR02 Gate 4 & Provision · Check Dup & UUID/Number · Batch Creation Engine & Decision Gates › Eligibility & Duplicate Verification › Phase 3: Provision & Atomic Commit · BR03 - BR05 Gate 4 & Provision Check Dup & UUID/Number BR03 - BR05 EF01 Blocked · Missing / Invalid NRIC · Exception & Rejection Channels › Audit Rejection Logging (AF01 - AF03, EF01) › Phase 2: Validation Gates (BR01 - BR03) · log error EF01 Blocked Missing / Invalid NRIC log error AF01/02 Skipped · Non-SC or Age out of bounds · Exception & Rejection Channels › Audit Rejection Logging (AF01 - AF03, EF01) › Phase 2: Validation Gates (BR01 - BR03) · skip record AF01/02 Skipped Non-SC or Age out of bounds skip record AF03 Duplicate · Already Active/Closed · Exception & Rejection Channels › Audit Rejection Logging (AF01 - AF03, EF01) › Phase 3: Provision & Atomic Commit · preserve acc AF03 Duplicate Already Active/Closed preserve acc Parent Dataset · Guardian mapping (BR10) · Core DB & Lifecycle Audit Trail › Phase 1: Ingestion & Scan · optional Parent Dataset Guardian mapping (BR10) optional Lifecycle Audit Log · Success / Failed log · Core DB & Lifecycle Audit Trail › Atomic DB Transaction Boundary › Phase 3: Provision & Atomic Commit · audit trail Lifecycle Audit Log Success / Failed log audit trail Education Account DB · Active, SGD 0.00, SGT · Core DB & Lifecycle Audit Trail › Atomic DB Transaction Boundary › Phase 3: Provision & Atomic Commit · atomic commit Education Account DB Active, SGD 0.00, SGT atomic commit trigger batch audit log invalid data valid fields eligible SC non-SC / age link guardian commit account exists scan record Legend Agent logic Policy Context / trace