tbl_employeedocument

-1 rows


Description

Module: Employee Profile
Purpose: Stores employee document information.
Data: One row is created for each document uploaded or mapped to an employee.
Process Usage:
- Captures employee documents for personal, address, qualification, banking, experience, passport/visa, reference, and training certificate records.
- Tracks document metadata such as upload date, file size, and S3 storage location.
Key Points:
- Documents are linked to employees and mapped to document titles.
- Supports various document types based on predefined categories.
Business Impact: Ensures proper storage, tracking, and retrieval of employee documents for HR and compliance purposes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
edocumentid bigserial 19 √ nextval('tbl_employeedocument_edocumentid_seq'::regclass)
tbl_employeedocumenthistory.edocumentid fk_tbl_employeedocumenthistory R

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

Employee ID
Format: VARCHAR(20)
Meaning: References the employee to whom the document belongs.
Usage: Links document records to the corresponding employee.
edocumentname varchar 100 √ null

Document name
Format: VARCHAR(100)
FK: public.tbl_document_title.title_name
Meaning: Name or title of the document as defined in the document title table.
Usage: Identifies the type of document uploaded.
edcodate timestamp 29,6 √ null

Document upload date
Format: TIMESTAMP
Meaning: Date when the document was uploaded.
Usage: Used for tracking and audit purposes.
edocurl varchar 200 √ null

S3 file URL
Format: VARCHAR(200)
Meaning: Path or name of the document stored in S3.
Usage: Used to retrieve the uploaded document from storage.
edocumentsize varchar 100 √ null

Document size
Format: VARCHAR(100)
Meaning: Size of the uploaded file.
Usage: Useful for storage management and validations.
edocumentvalue varchar 100 √ null

Document value
Format: VARCHAR(100)
Meaning: Value selected based on the document mapping type.
Usage: Represents specific metadata or category associated with the document.
documentfor varchar 2147483647 √ null

Document category
Format: VARCHAR
Possible Values: PERSONAL_DETAIL_AADHAAR, PERSONAL_DETAIL_PAN, PERSONAL_DETAIL_DRIVING_LICENSE, PERSONAL_DETAIL_VOTER_CARD, ADDRESS_DETAIL_CURRENT, ADDRESS_DETAIL_PERMANENT, QUALIFICATION_DETAIL, BANK_DETAIL, CERTIFICATE_TRAINING_DETAIL, EXPERIENCE_DETAIL, PASSPORT_VISA_DETAIL, REFERENCE_DOCUMENT, PERSONAL_DETAIL_UAN
Usage: Identifies the type or category of the employee document.
document_title_id int8 19 √ null

Document title ID
Format: BIGINT
FK: public.tbl_document_title.title_id
Meaning: Maps the document to a predefined title.
Usage: Supports standardized categorization and reporting of employee documents.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeedocument_pk_tbl_employeedocument Primary key Asc edocumentid

Relationships

Close relationships within degrees of separation