tbl_branchmasterhistory

-1 rows


Description

Module: HRMS Branch Management
Purpose: Provides complete, immutable audit trail for all configuration changes to branch records in the system.
Data: Each row represents a historical event capturing changes to branch configurations, compliance settings, or operational details in JSON format.
Process Usage:
- Automatically populated via system triggers or application logic when branch records are modified.
- Used by administrators and auditors to review branch configuration changes and compliance updates.
- Essential for tracking statutory configuration changes and geographical updates.
Key Points:
- JSON-based change capture provides flexible storage of any branch attribute modifications.
- Complete audit trail for compliance reporting and configuration management.
- Enables reconstruction of branch state at any point in time for dispute resolution.
Business Impact: Critical for regulatory compliance audits, configuration change tracking, and maintaining historical accuracy of branch operations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_branchmasterhistory_id_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for each historical event record.
branchid int8 19 √ null
tbl_branchmaster.branchid Implied Constraint R

FK: public.tbl_BranchMaster.branchId
Purpose: Links this historical record to the specific branch that was modified.
Usage: Enables tracking all historical changes for a particular branch location.
Audit Value: Maintains relationship while preserving change history context.
history varchar 2147483647 √ null

Format: JSON Object
Purpose: Complete snapshot of changes made to the branch record, including before/after states and change metadata.
JSON Structure: Contains change type, timestamp, user information, field-level changes with old and new values, and business impact context.
Audit Value: Provides complete context for change analysis, compliance reporting, and forensic investigation of branch configuration modifications.
createddate timestamp 29,6 √ null
createdby varchar 500 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 500 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_branchmasterhistory_pk__tbl__branchmasterhistory_id Primary key Asc id

Relationships

Close relationships within degrees of separation