Tables for lead opportunity reservations
Mirrors LeadOpportunityReservation, LeadOpportunityCommissionSplit and **************** in kamo-shared-library. ddl-auto:update would create them from the entit...
Repair the quote-option FK defaults ddl-auto cannot reach
The existing dynamic sweep only covers nullable FK columns that already carry a FOREIGN KEY constraint. commerce_quote_options.quote_id is NOT NULL, so it is ex...
Create phi_access_log — the durable §164.312(b) audit trail
Until now PHI access was recorded only to a log stream with 14-day retention against a six-year obligation, and with no query surface. An accounting of disclosu...
Create the second-factor tables
Backs UserMfaEnrollment and MfaRecoveryCode in kamo-shared-library — §164.312(d) Person or Entity Authentication, the gap the compliance assessment called disqu...
Kujenga HANDLES PHI na PHI EFFECTIVE DATE kwenye orgs
Mirrors the two new Organization fields, following the OrgBrandingFieldsMigration convention, so the columns are reproducible on any environment rather than onl...
Revert "feat(phi): create HANDLES_PHI and PHI_EFFECTIVE_DATE on orgs"
This reverts commit ****************
Create HANDLES_PHI and PHI_EFFECTIVE_DATE on orgs
Mirrors the two new fields on the Organization entity in kamo-shared-library, following the OrgBrandingFieldsMigration convention. HANDLES_PHI is NOT NULL DEFAU...
Mwanzo MaxSeats 5, Biashara MaxSeats 25
Inaweka mbegu ya bei ya KamoCRM katika hatua na orodha ya kuishi baada ya Kuweka upya nafasi zilizotangazwa.
Register **************** repositories
LeadService now eagerly wires MarketLosConnectionResolver, which requires the integrations.los repositories **************** KI's explicit @EnableJpaRepositorie...
Originator/transaction-first columns (@Order 90)
Additive nullable columns + org-unique transaction-number index for the MLOS originator/transaction refactor: mlos_loan_transaction (transaction_number + assign...
Add INVESTOR_PRICE column to rate_locks + loan_pricing_snapshots
@Order(80) idempotent ADD COLUMN IF NOT EXISTS (DECIMAL(9,4), matching the price-to-100 grids) so the MLOS RCE can record the true non-par investor execution pr...
Partial-unique index enforcing one active closing package per loan (eClose double-close backstop)
CREQUE INDEX uk mlos closing pkg active loan Kuhusu mlos closing package (loan file uid) ambapo hali <> 'inawezekana'. Nyuma ya nyuma Ulinzi wa idempotency ya n...
Create mlos_doc_req_borrower_idx for the vault cross-loan reuse query
Mlos requirement single-live index keyed per-human (borrower_uid)
Drop the party-only **************** (it would reject a legitimate 2nd co-borrower requirement); create **************** on **************** Already applied to ...
Seed the 17 real program rulesets (doc03 §9 Phase 1)
Migrates the authoritative ProgramRuleset data from the KamoMLOS client ruleset files into **************** (17 codes, extracted faithfully) and replaces Progra...
Platform-singleton partial-unique index for mlos_governor_config (D4)
mlos_governor_config auto-creates via ddl-auto; add the partial expression unique index confining the platform-default (organization_id IS NULL) to a single row...
Scan mlos.intake repos (§5.A) + tone la yatima mlos aus connection config (D40)
Ongeza com.kamo.z.shared.mlos.intake kwa @EnableJpaRepositories - §5.A [TD="width: 456"] [FONT=&](2)[/FONT][FONT=&]Bila kuathiri masharti ya kifungu kidogo (1) ...
Drop **************** column (D39)
The coarse boolean is replaced by the per-program mlos_investor_delegation child; drop the removed NOT-NULL column so Hibernate INSERTs are not rejected.
Codify §4.2 requirement-writer single-live partial-unique backstop
Kwa mahitaji zaidi ya moja ya kuishi kwa kila (loan file uid, img doc type id, chama) Wajibu wa seli. [TD="width: 456"] [FONT=&](2)[/FONT][FONT=&]Bila kuathiri ...
Scope mock lead vendors to a market; drop removed createMarket arg
NULLs-safe unique index for ClosingWorkflowTemplate versions (doc 05 §6.3)
One version per (organization_id, scope_level, scope_ref_id) grain. CRDB is NULLs-distinct, so split for the nullable scope_ref_id (mirrors mlos_aiptp_*): mlos_...
Null-safe split of the AiPullThroughPolicy single-active index (doc 09 §8)
CRDB is NULLs-distinct, so the single (lender_profile_id, market_id) WHERE status='ACTIVE' index did NOT backstop the org-wide (market_id IS NULL) grain — two c...
(loan_file_uid,type) native single-active partial-unique index (doc 11 §5.3/§6.2)
Closes a pre-existing double-active hole in the MLOS loan-identifier registry: index (a) **************** only constrains (org, type, VALUE) for the 10 REGISTRY...
Anti-double-lock partial-unique index for RCE lock records (doc 08 §7.3)
SchemaCleanupRunner adds **************** — a partial UNIQUE index on mlos_lock_record (organization_id, loan_scenario_id) WHERE status IN **************** At m...
§ 2.4 Ripoti ya Umoja wa Mataifa kuhusu mlos aus run
One ACTIVE (non-superseded, non-frozen) AusRun per (loan_file_uid, source_label) — "duplicates look like AUS-shopping" (doc 10 §2.4/§2.5). Safe to land now that...
Register pkg + RCE/pull-through DDL (docs 08/09)
@EnableJpaRepositories += Kwa mfano, *** SchemaCleanupRunner: Kwa mfano, *** (sehemu ya umoja) + rce commit ai decision fk rce commit lock record fk + rce commi...
Jisajili com.kamo.z.shared.mlos.e close in @EnableJpaRepositories (doc 05)
Jisajili com.kamo.z.shared.mlos.aus katika @EnableJpaRepositories (doc 10)
New aus_* repo package (AusRun + children). mlos_aus_run created + verified.
EventProjectionPolicy platform-default partial unique index (doc 07 §6.7)
**************** **************** WHERE organization_id IS NULL — pins the platform-default singleton (CRDB NULLs-distinct leaves null-org rows unconstrained ot...
RuleVersionPin entry->pin hard FK (doc 06 §4.6)
mlo rvpe pin idx + mlos rvpe pin fk Kwa mfano, *** -> mlos rule version pin.uid), kuangalia satisfier-> mahitaji ya FK. Bonyeza + imethibitishwa.
Rule-layer DB CHECKs (doc 06 §4.2/§9.2)
3 jukwaa inayomilikiwa biconditional CHECKs (mlos requirement rule / rule set mlos freshness policy: jukwaa owned = (organization id IS NULL) backstop ck requi...
Schema for the 1-obligation/N-satisfier condition model (doc 06)
Jisajili com.kamo.z.shared.mlos.docs katika @EnableJpaRepositories (new repo pkg) + SchemaCleanupRunner backstop kwa mlos requirement satisfier (mwisho wa pekee...
Notification party+consent ledger schema (doc 07 §6)
- KamoInitializerApp: @EnableJpaRepositories += **************** (new repo pkg for **************** - SchemaCleanupRunner: mlos_consent_one_identity_chk = num...
DecisionInput provenance-integrity DDL (decision-spine 2c)
decision_input auto-creates via ddl-auto; SchemaCleanupRunner adds the invariants Hibernate can't emit: - decision_input_one_source_chk: num_nonnulls(11 FK cols...
Check in pending WIP (no CI/CD on this repo)
- DataLoader: platform baseline security model + KamoCRM market-backfill wiring - add KamoCRMMarketBackfillLoader; remove superseded BillingGroupBackfillLoader ...
Regenerate maven wrapper (drop mvnw.real shim, vendor wrapper jar)
Stop per-boot customer_id FK tug-of-war in SchemaCleanupRunner
Remove the stale RetailCustomer->Account cleanup drops of commerce_carts.customer_id, **************** and **************** Those columns are now live, Hibernat...
Guideline-version no-overlap partial-unique index (Phase-2 Slice 7)
SchemaCleanupRunner: ux_guideline_version_active partial-unique ON mlos_guideline_version (organization_id, product_id) WHERE status='ACTIVE' AND effective_unti...
Value-set platform-owned ownership CHECK (Phase-2 Slice 4)
SchemaCleanupRunner: ADD CONSTRAINT mlos_value_set_ownership_chk CHECK (platform_owned = (organization_id IS NULL)) — doc 02 §6.2: a platform taxonomy is platfo...
Mlos_product ARM-consistency CHECK (Phase-2 Slice 2)
SchemaCleanupRunner: ADD CONSTRAINT **************** CHECK ((amortization_type = 'ARM') = (arm_fixed_period_months IS NOT NULL)) — a fixed period is declared IF...
Orodha ya repos + kiwango chasheet-version hakuna-overlap index (Phase-2 Slice 1)
@EnableJpaRepositories + = com.kamo.z.shared.mlos.catalog (Mkurugenzi mpya wa MlosInvestor / [TD="width: 456"] [FONT=&](2)[/FONT][FONT=&]Bila kuathiri masharti ...
Sehemu ya kipekee indexes + invariants huduma (Phase-1 config kukamilika)
SchemaCleanupRunner DDL for the new mlos.config domains (mlos.config already in @EnableJpaRepositories; Hibernate ddl-auto:update creates the tables): - one-act...
Register mlos.config repo pkg (Phase-1 Slice 1)
Ongeza com.kamo.z.shared.mlos.config to @EnableJpaRepositories so KamoInitializer Inajenga mlos lender profile + mlos licensing entry. Index ya incl. Umoja wa S...
Kujiandikisha mlos.compliance repo pkg (Slice 2c-i)
Ongeza kwenye @EnableJpaRepositories hivyo KamoInitializer Inaunda mlos adverse action timer + mlos regx timer. Orodha ya taasisi zilizotangazwa kupitia @Table ...
Kujiandikisha mlos.legal repo pkg (Slice 2b)
Ongeza com.kamo.z.shared.mlos.legal kwa @EnableJpaRepositories hivyo KamoInitializer Kujenga mlos licensed act registry / mlos ron eligibility / mlos steward li...
Kujiandikisha mlo.steward + mlos.orchestration repos; Slice-2a schema
- KamoInitializerApp @EnableJpaRepositories: add the accumulated MLOS repo packages **************** plus esign/personal_loans so KamoInitializer owns their...
Je, unaona nini kuhusu usafiri?
Kila moja ya hizi updates ardhi katika nafasi yako ya kazi moja kwa moja. Kuanza bure na kuangalia kukua wiki baada ya wiki.