tbl_inactiveemployee

-1 rows


Description

Module: Employee Lifecycle/Separation Management - Inactive Employee Request
Purpose: Stores the details of a request to change an employee’s status to inactive (e.g., resignation, termination, long-term leave) and tracks the multi-stage approval workflow for the request.
Data: Captures the employee ID, the reason for inactivation, the requested date of change, and the status and details of up to two reporting manager approvals.
Process Usage:
- Initiated when an event triggers an employee’s separation or long-term status change.
- Tracks the sequential sign-off from managers (Rep1, Rep2) before the final status is recorded in the main employee master.
Key Points:
- Workflow Control: Manages the formal approval process for employee exit/status change.
- The FinalStatus dictates the official status change.
Business Impact: Provides a structured, audited process for managing employee separation and official employment status changes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
inactiveid serial 10 √ nextval('tbl_inactiveemployee_inactiveid_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific inactivation request.
employeeid varchar 500 null
tbl_employee.employeeid fk__tbl_inact__emplo__338937f1 R

FK: public.tbl_employee.employeeid
Meaning: The Employee ID whose status is being changed.
inactivefor varchar 500 √ null

The reason or category for the inactivation (e.g., RESIGNATION, TERMINATION, RETIREMENT).
employeestatus varchar 50 √ null

The official employment status to be set after approval (e.g., INACTIVE, ACTIVE).
requestrelievingdate timestamp 29,6 √ null

The requested or proposed date on which the employee’s status should become inactive.
reperson1status varchar 50 √ null

The status of the request after review by the first approving manager.
Values: PENDING, APPROVED, REJECTED.
reperson2status varchar 50 √ null

The status of the request after review by the second approving manager.
Values: PENDING, APPROVED, REJECTED.
reperson1name varchar 50 √ null

FK: public.tbl_employee.employeeid (via name/ID lookup)
Meaning: The name/ID of the first approving manager/reporter.
reperson2name varchar 50 √ null

FK: public.tbl_employee.employeeid (via name/ID lookup)
Meaning: The name/ID of the second approving manager/reporter (if required).
finalstatus varchar 50 √ null

The conclusive status of the entire inactivation request workflow.
Values: PENDING, APPROVED, REJECTED, PROCESSED.
createddate timestamp 29,6 √ null
createdby varchar 30 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 30 √ null
rejectreason varchar 500 √ null

The reason provided if the inactivation request was formally rejected by any approver.

Indexes

Constraint Name Type Sort Column(s)
tbl_inactiveemployee_pk__tbl_inac__e8155ba0fba8c261 Primary key Asc inactiveid

Relationships

Close relationships within degrees of separation