Form Builder (Design-Time)
Define fields, types, conditional visibility, defaults, lookups and validations per context.
Drag fields into the form, reorder, and attach lookups + validations. Column map is versioned per scheme.
Field Library
Reusable fields across contexts.
URN
Text • Unique
⋮⋮Text • Unique
Loan A/c No
Text
⋮⋮Text
Sanction Date
Date
⋮⋮Date
Sanction Amount
Number
⋮⋮Number
Collateral Amount
Number
⋮⋮Number
Borrower Category
Lookup
⋮⋮Lookup
State
Geo Dictionary
⋮⋮Geo Dictionary
Form Canvas
Drop fields here. Configure mandatory, header mapping and validation bins.
Context: New CG (Sanction)
Upload Columns (Ordered)Drag
URN
Required • Unique • 100 Cr cap by URN
⋮⋮Required • Unique • 100 Cr cap by URN
Loan A/c No
Required • Unique with MLI
⋮⋮Required • Unique with MLI
Sanction Date
Required • Window check
⋮⋮Required • Window check
Sanction Amount
Required • Numeric
⋮⋮Required • Numeric
Collateral Amount
≥ 0
⋮⋮≥ 0
ValidationsRules
Interest Range
0–100
⋮⋮0–100
Tenure/Moratorium Slabs
Decision Table
⋮⋮Decision Table
100 Cr Cap by URN
Cross-file + in-DB
⋮⋮Cross-file + in-DB
Runtime behavior: failing rows go to Invalid bin; passing rows to Valid bin (staging tables).
Context: Disbursement
Required ColumnsDrag
CGPAN
Post-CGPAN only
⋮⋮Post-CGPAN only
Loan A/c No
Must exist
⋮⋮Must exist
Disbursement Amount
≤ sanction; multiple tranches
⋮⋮≤ sanction; multiple tranches
Disbursement Date
≥ sanction; ≤ system date; 7-day window
⋮⋮≥ sanction; ≤ system date; 7-day window
Fee LogicCalc
Same FY as sanction
No fee for that tranche
⋮⋮No fee for that tranche
Else daily prorated
Base = (ΣDisb−Collateral)−already charged
⋮⋮Base = (ΣDisb−Collateral)−already charged
Rates
Years 1–3: 1.5%, Year 4+: 1%
⋮⋮Years 1–3: 1.5%, Year 4+: 1%
Context: Continuity (Annual)
Upload by Apr 30 based on Mar-31 O/S. NPA/Close markers affect fee and transitions.
Principal O/S @ Mar-31
Required
⋮⋮Required
Interest O/S @ Mar-31
Required
⋮⋮Required
Mark
Std / NPA / Close
⋮⋮Std / NPA / Close
NPA Date + O/S @ NPA
Conditional: only when Mark=NPA
⋮⋮Conditional: only when Mark=NPA
Context: Update CG (In-Year)
Allowed transitions: Std ↔ NPA ↔ Close (Close locks). Fee implications are evaluated by rule engine.
Current Status
Std/NPA/Close
⋮⋮Std/NPA/Close
New Status
Transition rules enforced
⋮⋮Transition rules enforced
Effective Date
Within FY
⋮⋮Within FY
Context: Claims (Interim/Final)
OTS Yes ⇒ treated as Final. Claim-year cap + carry-forward supported. Maker/Checker edit rights configurable.
Claim Type
Interim / Final
⋮⋮Interim / Final
OTS
Yes/No branching
⋮⋮Yes/No branching
Principal@NPA
Ledger override allowed for NCGTC roles
⋮⋮Ledger override allowed for NCGTC roles
Interest@NPA
Ledger override allowed
⋮⋮Ledger override allowed
Context: Recovery
Appropriation sequence, penalties, reconciliation and cap inputs updated post posting.
Recovery Amount (net legal cost)
Required
⋮⋮Required
Recovery Date
Required
⋮⋮Required
Penalty Code
Scheme-specific
⋮⋮Scheme-specific