tbl_departmentclearancetasksetuphistory

-1 rows


Description

Module: Separation/Off-boarding Management - Department Clearance Task Setup History Log
Purpose: Stores an immutable, historical record of all changes made to the individual sub-tasks that are part of a master Department Clearance Setup (e.g., specific steps required for “IT Clearance”).
Data: Captures a snapshot of the TaskName, links to the original task setup ID, and links to the history record of its parent clearance setup (DepartmentClearanceHistoryId).
Process Usage:
- Auditing: Provides a transparent timeline to track when a specific clearance task (e.g., “Collect Laptop,” “Disable Email Account”) was added, modified, or removed from a clearance checklist.
- Compliance: Used for retrospective checks to ensure that the required clearance tasks were in effect at the time an employee separated.
- Contextual Logging: Links to tbl_DepartmentClearanceSetUpHistory to provide full context of the parent rule set at the time of the change.
Key Points:
- Sub-task Tracking: Tracks the granular steps within the broader clearance process.
- The taskName is the primary piece of data being audited.
Business Impact: Ensures controlled and auditable management of the off-boarding checklist, critical for security and asset recovery.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific historical snapshot of a clearance task.
departmentclearancetasksetupid int8 19 √ null

FK: public.tbl_DepartmentClearanceTaskSetUp.Id (Implied)
Meaning: The ID of the master clearance task setup record that this history entry pertains to.
departmentclearanceid int8 19 √ null

FK: public.tbl_DepartmentClearanceSetUpHistory.Id
Meaning: The ID of the corresponding history record of the parent clearance setup at the time this task history was created.
taskname varchar 2147483647 √ null

The name or description of the specific clearance step/task as it was defined at the time of this history entry (e.g., “Collect all Company ID Cards”).
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_departmentclearancetasksetuphistory_pk__tbl_depa__3214ec071 Primary key Asc id

Relationships

Close relationships within degrees of separation