tbl_reporthistorymaster

-1 rows


Description

Module: HRMS Master Report Module
Purpose: Tracks and audits all report generation and download activities within the HRMS system.
Data: Each row represents a single instance of report generation, including search criteria and user actions for compliance tracking.
Process Usage:
- Automatically logged when users generate, preview, or download reports from any module.
- Used by administrators to monitor report usage patterns and ensure data access compliance.
Key Points:
- Captures complete context of report requests including filters and selection parameters.
- Supports audit requirements for sensitive HR data access and reporting.
Business Impact: Essential for data governance, compliance reporting, and monitoring access to sensitive employee information.

Columns

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

Primary key
Format: Bigint (auto-increment)
Used as: Unique identifier for each report generation event.
employeeid varchar 500 √ null
tbl_employee.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid
Meaning: The employee who initiated the report generation or download.
Dependency: Identifies the user responsible for each report access event.
reportname varchar 500 √ null

Type: Varchar
Meaning: The name or identifier of the report that was generated.
Usage: Specifies which report template was used for the generation event.
searchcriteria varchar 500 √ null

Type: Varchar
Meaning: The search filters and parameters used when generating the report.
Usage: Captures the complete filter context for audit and reproducibility.
selectioncriteria varchar 2147483647 √ null

Type: Varchar
Meaning: The data selection and column choices applied to the report.
Usage: Records specific data fields and scope selected for the report output.
action varchar 500 √ null

Type: Enum (GENERATE, DOWNLOAD, PREVIEW, EXPORT)
Meaning: The specific action performed on the report.
Usage: Differentiates between report preview, download, and other report-related activities.
createdby varchar 50 null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation