tbl_resignationclearance

-1 rows


Description

Module: Separation - Resignation Clearance
Purpose: Stores individual clearance tasks that must be completed by various departments (e.g., IT, Finance, Library) for a specific employee undergoing the exit/resignation process.
Data: Contains the department assigned, the specific point-of-contact (POC) for the task, the status of the clearance (pending/completed), and general remarks.
Process Usage:
- Links to the overall resignation case header (RCHeaderID).
- Each record represents one mandatory clearance step (e.g., “Clear IT Assets,” “Settle Dues”).
- Used to track the overall progress of the employee’s exit process.
Key Points:
- The central table for managing the workflow and status of departmental sign-offs.
- Status is updated by the assigned department POC.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rclearanceid bigserial 19 √ nextval('tbl_resignationclearance_rclearanceid_seq'::regclass)
tbl_resignationclearanceemployee.rclearanceid fk_tbl_resignationclearanceemployee_rclearanceid R

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific clearance task.
rcheaderid int8 19 √ null
tbl_resignationclearancehead.rcheaderid Implied Constraint R

FK: public.tbl_ResignationClearanceHead.id
Meaning: The ID of the overall resignation case header to which this clearance task belongs.
departmentid int8 19 √ null

FK: public.tbl_DepartmentOfCompany.id
Meaning: The ID of the department (e.g., IT, Accounts) responsible for completing this clearance task.
rcstatus varchar 20 √ '''Pending'''::character varying

The status of this specific departmental clearance task.
Values: PENDING, CLEARED, NOT_CLEARED, REJECTED.
rcdiscriptions varchar 300 √ null

Detailed description or instructions for the required clearance task.
rccreatedate timestamp 29,6 √ null

The date the clearance task was created/assigned.
rcapprowby varchar 50 √ null

Employee ID of the user who performed the action (approval/rejection) on this task.
departmentidnew bool 1 √ false
dptemphead varchar 50 √ null

Employee ID of the designated Department Head/POC initially responsible for this clearance task.
hrstatus varchar 50 √ null

A separate status flag, likely used by the HR/Separation team to track the administrative closure of this task.
attachment varchar 2000 √ null
deptclearancesetupid int8 19 √ null

FK: ID of the master setup for the type of clearance required.
Meaning: Links to the template that defined this clearance task (e.g., “IT Clearance Setup”).
pocname varchar 2147483647 √ null

The name of the specific Point of Contact (POC) or administrator who is currently handling this clearance task.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
deptclearancesetupname varchar 50 √ null

The name of the master clearance setup template used.
approvedby varchar 50 √ null

The final Employee ID of the person who ultimately approved/signed off on this clearance task.
approveddate date 13 √ null

The date the clearance task was formally approved or finalized.

Indexes

Constraint Name Type Sort Column(s)
tbl_resignationclearance_pk_tbl_resignationclearance Primary key Asc rclearanceid

Relationships

Close relationships within degrees of separation