tbl_dailyreport

-1 rows


Description

Module: Timesheet
Purpose: Stores daily timesheet entries submitted by employees.
Data: Each record represents one task entry for a given date and time range.
Process Usage:
- Captures details about tasks performed by employees, including start and end time, duration, and remarks.
- Used in the timesheet approval workflow by reporting managers and HR.
- Tracks both manual UI entries and imported timesheet records.
Key Points:
- Supports multi-level approval workflow (Rep1, Rep2, HR).
- Provides JSON-based tracking for reopen and review history.
- Can be used for payroll, productivity, and project tracking.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dailyreportid bigserial 19 √ nextval('tbl_dailyreport_dailyreportid_seq'::regclass)
tbl_timesheet_person_company_detail.daily_report_id fk__tbl_times__daily__01f1dc5d R

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

Meaning: Project/Task reference ID.
Usage: Identifies which project the task belongs to.
Reference: Connected to tbl_schedulemaster.
Note: Helps in project-wise timesheet reporting.
reportingdate timestamp 29,6 √ null

Meaning: Task start timestamp.
Format: yyyy-MM-dd HH:mm:ss.SSS (e.g., 2024-02-23 14:36:06.604).
Usage: Used to record when the task started; only time is displayed in the UI.
description varchar 800 √ null

Meaning: Task description or additional notes.
Usage: Stores extra information related to the work performed.
hours numeric 0 √ null

Meaning: Duration of work in minutes.
Usage: Represents how much time (in minutes) the employee spent on the task.
employeeid varchar 30 √ null

Status: Currently unused in code.
Note: Legacy field retained for backward compatibility.
targetedenddate timestamp 29,6 √ null

Meaning: Task end timestamp.
Format: yyyy-MM-dd HH:mm:ss.SSS (e.g., 2024-02-23 16:36:06.604).
Usage: Indicates when the task was completed; only time is displayed in the UI.
status varchar 50 √ null

Status: Currently unused in code.
Note: May have been used in early versions of timesheet tracking.
remarks varchar 50 √ null

Status: Currently unused in code.
Note: Placeholder for additional comments in older workflows.
taskname varchar 300 √ null

Meaning: Task name or label selected by the user.
Usage: Displays which task was worked on during this timesheet entry.
companyid int8 19 √ null

Meaning: Company identifier.
Status: In code but not actively used.
Note: Useful in multi-tenant or multi-company environments.
estimatedhours numeric 0 √ null

Status: Currently unused in code.
Note: Could be used for planned vs. actual effort comparison.
taskpriority varchar 30 √ null

Meaning: Task priority level.
Status: In code but not actively used.
Possible Values: High, Medium, Low (not enforced).
managerremark varchar 500 √ null

Meaning: Manager’s remark or feedback.
Status: In code but not actively used.
Usage: Could hold first-level manager comments.
projectclientname varchar 100 √ null

Status: Currently unused in code.
Note: Possibly used for client-based timesheet tracking in earlier versions.
createddate timestamp 29,6 √ null

Meaning: Record creation timestamp.
Usage: Indicates when the timesheet entry was initially submitted.
modifiedby varchar 50 √ null

Meaning: Employee ID of the last user who modified the record.
Usage: Tracks audit information for updates.
modifieddate timestamp 29,6 √ null

Meaning: Timestamp of the last modification.
Usage: Used for auditing and version tracking of timesheet entries.
stage varchar 100 √ null

Meaning: Timesheet approval stage/status.
Possible Values: Deleted, Draft, Rejected2, Approved2, Created, Approved1, Rejected1, Approved, Rejected.
Usage: Indicates the current approval stage of the timesheet (Old Workflow).
taskdate date 13 √ null

Meaning: Date for which the timesheet was filled.
Usage: Helps in daily report aggregation and payroll processing.
attachment varchar 50 √ null

Meaning: Attachment file name (if uploaded).
Usage: Stores the uploaded document name (e.g., screenshot, report).
createdby varchar 50 '''Admin'''::character varying

Meaning: Employee ID of the submitter.
Usage: Identifies who submitted the timesheet.
Default: ‘Admin’.
rep1status varchar 50 √ null

Meaning: Reporting Manager 1 status.
Workflow: New Workflow.
Usage: Tracks first-level approval (e.g., Pending, Approved, Rejected).
rep2status varchar 50 √ null

Meaning: Reporting Manager 2 status.
Workflow: New Workflow.
Usage: Tracks second-level approval stage.
finalstatus varchar 50 √ null

Meaning: HR or final approval status.
Workflow: New Workflow.
Usage: Captures the HR decision in the new approval process.
rep1reason varchar 200 √ null

Meaning: Reporting Manager 1 remarks.
Usage: Contains feedback or reason for approval/rejection from Manager 1.
rep2reason varchar 200 √ null

Meaning: Reporting Manager 2 remarks.
Usage: Contains feedback or reason for approval/rejection from Manager 2.
adminreason varchar 200 √ null

Meaning: HR remarks.
Usage: Captures HR comments related to approval/rejection.
reopen_history text 2147483647 √ null

Meaning: JSON string tracking timesheet reopen history.
Example: [{"reason":"Reopen","reopenBy":"accumax","reopenDate":"9::May::2025 15::16::00"}]
Usage: Records who reopened the timesheet, when, and why.
is_billable bool 1 √ true

Meaning: Billable flag.
Usage: Indicates whether the recorded time is chargeable to the client/project.
reviews text 2147483647 √ null

Meaning: JSON string storing timesheet review details.
Example: [{"createdTime":"2025-05-14T18:14:20.32548098","createdBy":"FC439","comment":"QA","rating":8}]
Usage: Captures comments and ratings provided on the timesheet entry.
is_imported bool 1 √ null

Meaning: Import flag.
Usage: TRUE if the record was created via Excel import, FALSE if entered through UI.
Purpose: Distinguishes between system-generated and user-submitted entries.

Indexes

Constraint Name Type Sort Column(s)
tbl_dailyreport_pk_tbl_dailyreport Primary key Asc dailyreportid

Relationships

Close relationships within degrees of separation