tbl_aboutyourselfhistory

-1 rows


Description

Module: HRMS Employee Information & Self-Service (Audit Log)
Purpose: Stores the historical, immutable audit log of all submissions and status changes made by an employee to their self-reported profile details (e.g., personal bio, skills, certifications).
Data: Contains snapshots of the submitted data (selfdetail), the workflow status, and reasons for rejection.
Process Usage:
- Used for auditing and compliance to see how and when an employee’s personal data changed over time.
- Tracks the complete workflow of a self-service update request (submission, review, rejection).
Key Points:
- Ensures accountability for changes made to employee profiles.
- The selfdetail field likely stores a JSON snapshot of the data submitted by the employee.
Business Impact: Provides a transparent record for all employee-driven master data changes.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single historical submission or event.
companyid int4 10 null
tbl_companymaster.companyid Implied Constraint R

FK: Reference to a company master table
Meaning: The company ID of the employee to whom this history record belongs.
employeeid varchar 500 null
tbl_employee.employeeid fk_tbl_aboutyourselfhistory_employeeid R

FK: public.tbl_employee.employeeid
Meaning: The ID of the employee who submitted the self-details change request.
selfdetail varchar 2000 √ null

Meaning: The complete data payload submitted by the employee for their “About Yourself” section.
Format: JSONB or Text
Usage: Stores the snapshot of the personal details, skills, or bios provided at the time of submission.
status varchar 20 √ null

The current or final status of the self-detail submission (e.g., Pending Review, Approved, Rejected).
Format: Varchar/Text.
rejectreason varchar 200 √ null

The justification or explanation provided by the reviewer if the self-detail submission was rejected.
Format: Text.
createddate timestamp 29,6 √ null

Timestamp of when the self-detail submission record was created (i.e., when the employee submitted the change).
Format: Timestamp with timezone.
createdby varchar 200 √ null

FK: public.tbl_employee.employeeid or public.tbl_userlogin.id
Meaning: The user who created this record (typically the employee or an administrative proxy).
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the submission record (e.g., when the status was changed by a reviewer).
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_employee.employeeid or public.tbl_userlogin.id
Meaning: The user (typically the reviewer or approver) who last modified the status or added a rejection reason.

Indexes

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

Relationships

Close relationships within degrees of separation