tbl_resignationclearanceemployee

-1 rows


Description

Module: Separation - Employee Departmental Clearance Tracking
Purpose: Records the status and details of the required clearance process for a specific departing employee with a particular department (e.g., IT, Finance, Admin).
Data: Captures the clearance ID, the department responsible, the status (Cleared/Pending), the department head responsible for sign-off, and any final remarks.
Process Usage:
- Checklist Tracking: Acts as a line item in the overall employee exit clearance process, ensuring all departmental handovers are completed.
- Workflow Control: The Status field is updated by the department head to certify that the employee has completed all obligations (e.g., returned assets, cleared dues) to that department.
Key Points:
- Audit Trail: Provides auditable proof of the employee’s clearance status from each required department.
- Linked to the overall resignation clearance record (RClearanceID).
Business Impact: Critical for risk mitigation during employee separation, ensuring recovery of company assets and closure of departmental responsibilities.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific department clearance task for the employee.
rclearanceid int8 19 null
tbl_resignationclearance.rclearanceid fk_tbl_resignationclearanceemployee_rclearanceid R

FK: public.tbl_ResignationClearance.Id (Implied)
Meaning: The ID of the parent master resignation clearance record for the departing employee.
departmentid int4 10 null
tbl_departmentofcompany.id fk_tbl_resignationclearanceemployee_departmentid R

FK: public.tbl_DepartmentOfCompany.DepartmentID
Meaning: The ID of the department that is required to provide clearance (e.g., Finance, HR, IT).
dptheademployeeid varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the designated Department Head or clearance officer responsible for reviewing and signing off on this clearance.
status varchar 20 √ '''Pending'''::character varying

The current status of the clearance for this department.
Values: PENDING, CLEARED, REJECTED/NOT_CLEARED.
description varchar 1000 √ null

Detailed remarks or reasons provided by the approving department head, especially if the status is REJECTED or if there are notes on assets/dues.
approvedby varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the user who performed the final sign-off (often the same as DptHeadEmployeeId).
active bool 1 √ false

Boolean flag: Indicates if this specific departmental clearance requirement is currently active for the employee’s resignation process.
attachment varchar 2000 √ null

Path or reference to any document or file attached as evidence for the final clearance/sign-off.
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_resignationclearanceemployee_id Primary key Asc id

Relationships

Close relationships within degrees of separation