tbl_employeeimmigration

-1 rows


Description

Module: Employee Profile
Purpose: Stores passport and visa details for employees.
Data: One row is created for each passport or visa record associated with an employee.
Process Usage:
- Maintains information about employee immigration documents.
- Tracks issue and expiry dates for compliance and HR management.
Key Points:
- Supports tracking of both passports and visas.
- Provides additional comments for internal reference.
Business Impact: Ensures HR compliance, visa/passport tracking, and accurate employee documentation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
eimmigrationid bigserial 19 √ nextval('tbl_employeeimmigration_eimmigrationid_seq'::regclass)
tbl_employeeimmigrationhistory.eimmigrationid fk__tbl_emplo__eimmi__3002bfd0 R

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each immigration record.
employeeid varchar 20 null
tbl_employee_previous_pf.employeeid Implied Constraint R

Employee ID
Format: VARCHAR(20)
Meaning: References the employee to whom this passport or visa belongs.
Usage: Links the immigration record to a specific employee.
eitype varchar 40 √ null

Document type
Format: VARCHAR(40)
Meaning: Type of immigration document
Possible Values: Passport, Visa.
Usage: Identifies the kind of document being stored.
einumber varchar 20 √ null

Document number
Format: VARCHAR(20)
Meaning: Passport or visa number.
Usage: Used as the key reference for the document in HR records.
eicitizenship varchar 60 √ null

Citizenship
Format: VARCHAR(60)
Meaning: Country of citizenship of the employee.
eiissuedate timestamp 29,6 √ null

Issue date of the document
Format: TIMESTAMP
Meaning: Date when the passport or visa was issued.
eiexpirydate timestamp 29,6 √ null

Expiry date of the document
Format: TIMESTAMP
Meaning: Date when the passport or visa will expire.
eicomments varchar 200 √ null

Additional comments
Format: VARCHAR(200)
Meaning: Optional notes regarding the passport or visa.
Usage: Can include internal remarks or special conditions for the document.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeeimmigration_pk_tbl_employeeimmigration Primary key Asc eimmigrationid

Relationships

Close relationships within degrees of separation