tbl_resignationclearancetaskinfo

-1 rows


Description

Module: Separation/Resignation Clearance Task/Checklist
Purpose: Stores the individual, low-level tasks (or checklist items) required to complete a specific departmental clearance during the employee resignation process.
Data: Captures the task name, associated assets, the status of the task completion, remarks, and the final sign-off details.
Process Usage:
- Links to a parent departmental clearance record (RClearanceId, likely pointing to tbl_ResignationClearance).
- Used to track the detailed handovers, such as returning specific assets (e.g., Laptop, ID Card) or clearing specific responsibilities.
- The status of these tasks contributes to the final status of the parent departmental clearance.
Key Points:
- Granular Control: Provides a detailed, auditable checklist for the exit process.
- Asset Handover: Directly links clearance tasks to specific company assets via asset_id.
Business Impact: Ensures all company property is recovered and all departmental responsibilities are handed over properly upon employee separation.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this individual clearance checklist item.
rclearanceid varchar 10 √ null

FK: public.tbl_ResignationClearance.RClearanceID (Stored as String in this table)
Meaning: The ID of the parent departmental clearance record (e.g., the IT clearance record) this task belongs to.
clearancename varchar 50 √ null

The name of the overall departmental clearance this task belongs to (e.g., “Finance Clearance”).
taskname varchar 2147483647 √ null

The specific, detailed name of the clearance task (e.g., “Return Company Laptop,” “Clear Library Dues”).
remarks varchar 500 √ null

Any comments, explanations, or notes recorded by the employee or the clearance officer regarding the task.
status varchar 10 √ null

The current status of this individual task.
Values: PENDING, CLEARED, NOT_APPLICABLE, NOT_CLEARED.
attachment varchar 100 √ null

Path or reference to any document or file attached as proof of task completion/clearance.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
approvedby varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the person who formally signed off and approved the completion of this task.
approveddate date 13 √ null

The date when this individual task was formally approved and completed.
clearanceid numeric 0 √ null

FK: ID of the master setup for the type of clearance required.
Meaning: Links to the template that defined the parent clearance task.
asset_id int8 19 √ null

FK: public.tbl_assets.id
Meaning: The ID of the specific company asset (e.g., laptop, access card) associated with this handover task (if applicable).

Indexes

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

Relationships

Close relationships within degrees of separation