tbl_transferrequisitionmaster

-1 rows


Description

Module: HRMS Transfers & Requisitions
Purpose: Stores the master record for every internal employee transfer or relocation request raised within the organization.
Data: Contains details about the requested move, including the originating and destination organizational units, financial implications, and approval status.
Process Usage:
- Used to track the lifecycle of a transfer request from initiation through final approval/rejection.
- Serves as the primary data source for transfer audit trails and reporting.
Key Points:
- Essential for documenting staffing movements and organizational changes.
- Contains multiple custom fields (com1 through com10) for flexible data capture.
Business Impact: Facilitates controlled and auditable employee mobility across departments, branches, or companies.

Columns

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

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

Meaning: The requested effective start date of the transfer.
Format: Date.
description varchar 500 √ null

Detailed justification or explanation for the transfer request.
Format: Text.
totalno int4 10 √ null

Meaning: The total number of positions or employees involved in this specific requisition.
Format: Integer.
state int8 19 √ null
tbl_statemaster.stateid fk_tbl_transferrequisitionmaster_state R

The current geographical state or region associated with the transfer (often the source state).
Format: Varchar/Text.
branch int8 19 √ null
tbl_branchmaster.branchid fk_tbl_transferrequisitionmaster_branch R

The originating branch/location from which the employee is being transferred.
FK: Reference to a branch/location master table.
category int8 19 √ null
tbl_categorymaster.categoryid fk_tbl_transferrequisitionmaster_category R

The job category of the position being transferred.
Format: Varchar/Text.
subcategory int8 19 √ null
tbl_subcategorymaster.subcategoryid fk_tbl_transferrequisitionmaster_subcategory R

The detailed sub-category of the job.
Format: Varchar/Text.
department int4 10 √ null
tbl_departmentofcompany.id fk_tbl_transferrequisitionmaster_department R

The originating department of the employee/position.
FK: Reference to a department master table.
subdepartment int4 10 √ null
tbl_departmentofcompany.id fk_tbl_transferrequisitionmaster_subdepartment R

The originating sub-department.
FK: Reference to a sub-department master table.
stage varchar 50 √ null

The current step in the workflow process Approved or Pending (e.g., HR Review, Final Approval, Completed).
Format: Varchar/Text.
com1 varchar 2147483647 √ null

Custom field 1 (General Purpose) - Reserved for specific, non-standard business data. Any com value is not specified
Format: Varchar/Text.
com2 varchar 2147483647 √ null

Custom field 2 (General Purpose).
Format: Varchar/Text.
com3 varchar 2147483647 √ null

Custom field 3 (General Purpose).
Format: Varchar/Text.
com4 varchar 2147483647 √ null

Custom field 4 (General Purpose).
Format: Varchar/Text.
com5 varchar 2147483647 √ null

Custom field 5 (General Purpose).
Format: Varchar/Text.
com6 numeric 0 √ null

Custom field 6 (General Purpose).
Format: Varchar/Text.
com7 numeric 0 √ null

Custom field 7 (General Purpose).
Format: Varchar/Text.
com8 bool 1 √ null

Custom field 8 (General Purpose).
Format: Varchar/Text.
com9 bool 1 √ null

Custom field 9 (General Purpose).
Format: Varchar/Text.
com10 timestamp 29,6 √ null

Custom field 10 (General Purpose).
Format: Varchar/Text.
createdon timestamp 29,6 √ null

Legacy timestamp of when the transfer request was initially created (may be redundant with createddate).
Format: Timestamp.
createdby varchar 500 √ null

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

Legacy timestamp of the last modification to the transfer request (may be redundant with modifieddate).
Format: Timestamp.
modifiedby varchar 500 √ null

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

Meaning: The exact timestamp of when the record was created.
Stored as: UTC
Format: Timestamp with timezone.
modifieddate timestamp 29,6 √ null

Meaning: The exact timestamp of the last modification to the record.
Stored as: UTC
Format: Timestamp with timezone.
employeeid varchar 500 √ null
tbl_employee.employeeid fk_tbl_transferrequisitionmaster_employeeid R

FK: public.tbl_employee.employeeid
Meaning: The ID of the employee targeted by this transfer requisition.
Format: Integer/Varchar.
relocationamount int8 19 √ null

Meaning: The approved or estimated financial amount associated with the relocation/transfer (e.g., travel expenses, moving costs).
Format: Numeric/Money.
reportingperson1 varchar 500 √ null
tbl_employee.employeeid fk_tbl_transferrequisitionmaster_reportingperson1 R

FK: public.tbl_employee.employeeid
Meaning: The ID of the primary reporting manager for the new position/location.
reportingperson2 varchar 500 √ null
tbl_employee.employeeid fk_tbl_transferrequisitionmaster_reportingperson2 R

FK: public.tbl_employee.employeeid
Meaning: The ID of the secondary reporting manager (dotted-line report) for the new position/location.
companyid int4 10 √ null
tbl_companymaster.companyid fk_tbl_transferrequisitionmaster_companyid R

FK: Reference to a company master table
Meaning: The company ID where the employee is currently placed (source company).
Format: Integer/Varchar.
sbuid int4 10 √ null
tbl_companymaster.companyid fk_tbl_transferrequisitionmaster_sbuid R
fromposition int8 19 √ null
tbl_employeestructure.estructureid fk_tbl_transferrequisitionmaster_fromposition R

FK: Reference to a position master table
Meaning: The original position/designation from which the employee is transferring.
Format: Integer/Varchar.
statusdate timestamp 29,6 √ null

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

FK: public.tbl_employee.employeeid or public.tbl_userlogin.id
Meaning: The ID of the user who set the current status.(approved or reject )
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 approval chains/processes were impacted by this transfer request.(changes are impacted or not )
Format: Varchar/Boolean.
source varchar 100 null

The system or method through which the request was initiated (e.g.,Import transfer or Manaul request ).
Format: Varchar/Text.
subdepartmentid1 int8 19 √ null

FK: Reference to a sub-department master table
Meaning: The target sub-department ID after the transfer (Destination Sub-Department).
subdepartmentid2 int8 19 √ null

Used for capturing a secondary target sub-department or a custom organizational unit.
Format: Integer/Varchar.
subdepartmentid3 int8 19 √ null

Used for capturing a tertiary target sub-department or a custom organizational unit.
Format: Integer/Varchar.
subdepartmentid4 int8 19 √ null

Used for capturing a quaternary target sub-department or a custom organizational unit.
Format: Integer/Varchar.
compliance_branch int8 19 √ null

FK: Reference to a branch/location master table
Meaning: The branch/location relevant for compliance and regulatory purposes after the transfer.
past_structure_ids text 2147483647 √ null

A JSON array or Text list of old organizational unit IDs (e.g., department, branch) the employee was historically associated with before this transfer.
Format: JSONB/Text.

Indexes

Constraint Name Type Sort Column(s)
tbl_transferrequisitionmaster_pk_tbl_transferrequisitionmaster Primary key Asc transferrequisitionid

Relationships

Close relationships within degrees of separation