tbl_document_title

34 rows


Description

Module: Employee Profile
Purpose: Categorizes and defines the various document titles used across the Employee Profile module.
Data: Each record represents a specific document title configuration (e.g., Aadhaar Card, PAN Card, Qualification, etc.).
Process Usage:
- Serves as a master table for document categorization across the employee profile.
- Defines whether a document type is mandatory and what type of mapping it belongs to.
- Used by multiple submodules like Qualification, Experience, Address Proof, and Identification documents.
Key Points:
- Helps organize employee documents logically and consistently.
- Maintains attributes such as document requirement, verification need, and upload rules.
Business Impact: Ensures uniform categorization and validation of all employee-related documents across the HRMS system.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Usage: Unique identifier for each document title configuration record.
type_id int8 19 null

Document type reference
Foreign Key: tbl_document_type.id
Meaning: Links the document title to a specific document type category.
Usage: Allows grouping of document titles under broader document type classifications.
title_name varchar 100 null

Title Name
Format: VARCHAR(100)
Meaning: The human-readable name of the document (e.g., Aadhaar Card, PAN Card, Qualification).
Usage: Displayed in the employee profile or upload section.
title_label varchar 100 null

Title Label
Format: VARCHAR(100)
Meaning: Label displayed in the UI for the document title.
Usage: Often used for localized or descriptive labeling of the document title.
title_mapping varchar 100 √ null

Title Mapping Enum
Format: VARCHAR(100)
Meaning: Defines the internal mapping category for the document.
Possible Values: O_FORM, GENERAL, QUALIFICATION, EXPERIENCE, BANK_DETAILS, REFERENCE, CERTIFICATE, TRAINING, STD_10, STD_12, AADHAAR_CARD, PAN_CARD, VOTER_ID, DRIVING_LICENCE, CURRENT_ADDRESS, PERMANENT_ADDRESS, PASSPORT, VISA, UAN, CURRENT_EXPERIENCE.
Usage: Used in backend logic for identifying document type categories across modules.
is_mandatory bool 1 √ null

Is Mandatory
Format: BOOLEAN
Meaning: Indicates whether the document is mandatory to upload.
Usage: Helps enforce compliance for critical document uploads (e.g., Aadhaar, PAN).
verification_required bool 1 √ null

Verification Required
Format: BOOLEAN
Meaning: Indicates whether this document requires verification.
Note: Currently not used in any specific logic but reserved for future validation workflows.
is_multiple_allowed bool 1 √ null

Multiple Uploads Allowed
Format: BOOLEAN
Meaning: Determines whether multiple documents of the same type can be uploaded.
Note: Currently reserved for future use in document handling logic.
is_active bool 1 √ null

Active Flag
Format: BOOLEAN
Meaning: Indicates whether this document title is active and should be available for selection.
Usage: Helps manage deprecated or inactive document titles in the system.
title_index int8 19 √ null

Display Order Index
Format: BIGINT
Meaning: Specifies the order in which titles are displayed in lists or dropdowns.
Note: Used in code for ordering but not critical to business logic.
is_editable int4 10 √ null

Editable Flag
Format: INTEGER
Meaning: Indicates if the document title can be modified.
Note: Not currently used in the application but retained for compatibility or future expansion.
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_document_title Primary key Asc id

Relationships

Close relationships within degrees of separation