tbl_departmentclearancesetup

6 rows


Description

Module: Separation/Off-boarding Management - Department Clearance Master Setup
Purpose: Defines the various clearance activities (e.g., Asset Return, Accounts Closure) required from different departments/functions when an employee leaves the organization.
Data: Captures the name of the clearance area, the department responsible, the specific employee(s) who are the Point of Contact (POC), and a flag indicating if the immediate reporting manager handles the clearance.
Process Usage:
- Off-boarding Workflow: When an employee resigns, this table is used to generate the list of clearance tasks that must be completed by the relevant POCs.
- Task Generation: Links to tbl_DepartmentClearanceTaskSetUp to define the specific sub-tasks required for this clearance area.
Key Points:
- Structured Exit: Ensures a standardized and complete checklist for every employee exit.
- The POC column stores the ID(s) of the employee(s) responsible for signing off on this clearance area.
Business Impact: Minimizes organizational risk by ensuring all company property, access, and accounts are properly recovered and closed during the separation process.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific clearance setup.
name varchar 50 √ null

The name of the clearance area or function (e.g., “IT Clearance,” “Finance Clearance,” “HR Exit Interview”).
poc varchar 2147483647 √ null

A string (often comma-separated Employee IDs) identifying the specific employee(s) who are the Point of Contact (POC) authorized to sign off on this clearance.
department varchar 2147483647 √ null

The name of the department or function that is responsible for completing this clearance.
status varchar 20 √ null

The current status of this clearance setup (e.g., Active, Inactive).
isreportingclearance bool 1 √ null

Boolean flag: If TRUE, the clearance responsibility automatically defaults to the separating employee’s immediate Reporting Person, overriding the defined POC(s).
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)
tbl_departmentclearancesetup_pk__tbl_depa__3214ec07add7c2e6 Primary key Asc id

Relationships

Close relationships within degrees of separation