tbl_teamtransfermembers

-1 rows


Description

Module: Transfer - Team Transfer Employee Details
Purpose: Stores the individual employee records that are part of a larger, coordinated team transfer/restructuring request (defined in tbl_TeamTransfer).
Data: Captures the employee ID, their current reporting structure, current position, and links them back to the overall transfer request and company.
Process Usage:
- Transfer Execution: Used by the system to identify all employees whose records need to be updated upon approval of the parent TeamTransfer request.
- Pre-transfer Snapshot: Records the employee’s reporting line and position before the transfer takes effect (in the reportingPerson and fromPosition fields).
Key Points:
- Line-item Detail: Acts as a detail table for the header record in tbl_TeamTransfer.
- Crucial for managing the mass movement of employees during organizational changes.
Business Impact: Ensures that all affected employees are tracked and processed correctly during organizational restructuring and reporting line changes.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this employee’s inclusion in the team transfer request.
employeeid varchar 500 null
tbl_employee.employeeid fk_tbl_teamtransfermembers_employeeid R

FK: public.tbl_employee.employeeid
Meaning: The Employee ID who is being transferred as part of this request.
companyid int4 10 null
tbl_companymaster.companyid fk_tbl_teamtransfermembers_companyid R

FK: public.tbl_CompanyDetail.CompID
Meaning: The ID of the company the employee is currently associated with (pre-transfer).
teamtransferid int8 19 null
tbl_teamtransfer.teamtransferid fk_tbl_teamtransfermembers_teamtransferid R

FK: public.tbl_TeamTransfer.Id
Meaning: The ID of the master team transfer request this employee is a part of.
fromposition int8 19 null
tbl_employeestructure.estructureid fk_tbl_teamtransfermembers_fromposition R

FK: public.tbl_EmployeeStructure.id (Implied)
Meaning: The ID of the employee’s current position or job structure before the transfer is executed.
reportingperson1 varchar 500 √ null
tbl_employee.employeeid fk_tbl_teamtransfermembers_reportingperson1 R

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the employee’s primary reporting person before the transfer.
reportingperson2 varchar 500 √ null
tbl_employee.employeeid fk_tbl_teamtransfermembers_reportingperson2 R

FK: public.tbl_employee.employeeid
Meaning: The Employee ID of the employee’s secondary reporting person before the transfer.
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)
pk_tbl_teamtransfermembers_teamtransfermembersid Primary key Asc teamtransfermembersid

Relationships

Close relationships within degrees of separation