tbl_teamtransfer

-1 rows


Description

Module: HRMS Organizational Management
Purpose: Records the details of every transfer request concerning an employee moving from one team or project to another within the same organization, often without a change in department or location.
Data: Stores the effective date, approval status, and rationale for the team change.
Process Usage:
- Used to update the employee’s current team assignment in the core employee profile.
- Provides an audit trail for all internal team movements.
Key Points:
- Essential for accurate project staffing, cost center allocation, and internal reporting on team distribution.
- Tracks the complete workflow lifecycle of the team transfer request.
Business Impact: Facilitates controlled and documented internal resource mobility.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
teamtransferid bigserial 19 √ nextval('tbl_teamtransfer_teamtransferid_seq'::regclass)
tbl_teamtransfermembers.teamtransferid fk_tbl_teamtransfermembers_teamtransferid R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single team transfer request record.
effectivedate date 13 null

Meaning: The date on which the team transfer is officially scheduled to take effect.
Format: Date.
transfernotes varchar 500 √ null

Detailed justification or remarks explaining the reason for the team transfer (e.g., project reassignment, capacity balancing).
Format: Text.
companyid int4 10 null
tbl_companymaster.companyid fk_tbl_teamtransfer_companyid R

FK: Reference to a company master table
Meaning: The company ID where the employee is currently placed (source company).
Format: Integer/Varchar.
employeeid varchar 500 null
tbl_employee.employeeid fk_tbl_teamtransfer_employeeid R

FK: public.tbl_employee.employeeid
Meaning: The ID of the employee whose team is being changed.
Format: Integer/Varchar.
stage varchar 100 null

The current step in the workflow process (e.g., Team Manager Review, HR Review, Completed).
Format: Varchar/Text.
statusdate timestamp 29,6 √ null

The timestamp when the current status was last set (e.g., Approved, Rejected, Pending).
Format: Timestamp with timezone.
statusby varchar 500 √ null
tbl_employee.employeeid fk_tbl_teamtransfer_statusby R

FK: public.tbl_employee.employeeid or public.tbl_userlogin.id
Meaning: The ID of the user who set the current status.
statusremark varchar 500 √ null

Comments or detailed justification provided by the user who set the current status.
Format: Text.
approvalimpacted bool 1 √ null

Flag or code indicating which internal approval chains or downstream systems (e.g., project management) were impacted by this transfer request.
Format: Varchar/Boolean.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The ID of the user who initiated the transfer request.
createddate timestamp 29,6 √ null

Timestamp of when the transfer request record was created.
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The ID of the last user who modified the transfer request.
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the transfer request record.
Format: Timestamp with timezone.

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_teamtransfer_teamtransferid Primary key Asc teamtransferid

Relationships

Close relationships within degrees of separation