tbl_task_hours

-1 rows


Description

Module: Task Management
Purpose: Stores records of the time (in minutes) spent by employees on specific daily tasks.
Data: One row represents the time log of an employee for a given date and task.
Process Usage:
- Captures daily work hours against each task for performance and productivity tracking.
- Used by HR and managers to monitor time allocation and task completion progress.
Key Points:
- Supports attachments and comments for additional context.
- Tracks the life cycle and status of each task entry.
Business Impact: Enables accurate time tracking, productivity analysis, and reporting on employee task engagement.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_task_hours_id_seq'::regclass)
tbl_task.review_id fk_review_id N

Primary key
Format: BIGSERIAL (auto-increment)
Usage: Unique identifier for each time log record.
taskid int8 19 √ null
tbl_schedulemaster.taskid Implied Constraint R

Task Reference
Foreign Key: tbl_task.id
Meaning: Identifies the task for which the employee spent time.
Usage: Links each time entry to its corresponding daily task.
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R

Employee ID
Format: VARCHAR(500)
Meaning: Identifies the employee who logged the task hours.
Usage: Associates the time entry with a specific employee record.
hoursspentdate date 13 √ null

Date of Work
Format: DATE
Meaning: The date on which the employee worked on the task.
Usage: Allows tracking and reporting of hours on a per-day basis.
hours int8 19 √ null

Hours Spent
Format: BIGINT (minutes)
Meaning: Number of minutes the employee spent on the task.
Usage: Used to calculate total time worked and productivity analytics.
comment text 2147483647 √ null

Comment
Format: TEXT
Meaning: Additional remarks or notes provided by the employee for the work session.
Usage: Helps describe work done or provide context for the hours logged.
activity varchar 100 √ null

Activity (Not in use)
Format: VARCHAR(100)
Meaning: Field exists in the schema but not currently used in business logic.
Usage: Reserved for potential future classification of work activity types.
attachmentname varchar 150 √ null

Attachment Name
Format: VARCHAR(150)
Meaning: Original name of the uploaded attachment file related to the work session.
Usage: Provides file identification for review or audit purposes.
systemfilepath text 2147483647 √ null

System File Path (S3 URL)
Format: TEXT
Meaning: The storage path or S3 URL where the attachment is uploaded.
Usage: Used to retrieve or manage the uploaded document.
createddate timestamp 29,6 √ null
createdby varchar 500 null
modifieddate timestamp 29,6 √ null
modifiedby varchar 500 null
rating float8 17,17 √ null

Rating
Format: FLOAT8
Meaning: Performance rating or feedback score given by HR or an administrator.
Usage: Used in performance evaluation or task feedback reports.
is_deleted bool 1 √ false

Soft Delete Flag
Format: BOOLEAN (Default: FALSE)
Meaning: Indicates whether the record is logically deleted.
Usage: When a task entry is edited or overridden, this flag is set to TRUE to retain audit history.
status varchar 50 √ null

Task Status
Format: VARCHAR(50)
Meaning: Represents the current status of the task entry.
Possible Values: CREATED, IN_PROGRESS, ON_HOLD, COMPLETED, CLOSED.
Usage: Used to monitor the progress and workflow state of each task.

Indexes

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

Relationships

Close relationships within degrees of separation