hr_documentmaster

-1 rows


Description

Module: HRMS Document Management System
Purpose: Serves as the master repository for all official HR and company documents (e.g., policies, forms, manuals).
Data: Stores metadata, file path, access control, and classification details for each document.
Process Usage:
- Controls which employees can view or download specific documents based on organizational units or roles.
- Used by HR staff to manage the centralized library of official documents.
Key Points:
- Essential for ensuring version control, compliance, and easy employee access to required documents.
- Documents are typically stored on a file server, and this table stores the link and metadata.
Business Impact: Streamlines HR operations and improves employee self-service for information access.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
documentid bigserial 19 √ nextval('hr_documentmaster_documentid_seq'::regclass)
tbl_assigneddocument.documentid Implied Constraint R
tbl_documenthistory.documentid Implied Constraint R
tbl_downloadorviewdocumenthistory.documentid Implied Constraint R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single document record.
documentname varchar 100 √ null

The official name or title of the document (e.g., “Employee Handbook V2.1,” “Sexual Harassment Policy”).
Format: Varchar/Text.
documentdescription varchar 500 √ null

A brief summary or abstract of the document content.
Format: Text.
documentdetail varchar 50 √ null

Detailed textual content of the document, if it is stored directly in the DB; otherwise, used for extended remarks.
Format: Text.
documentsize varchar 50 √ null

The size of the physical file (in bytes, KB, or MB).
Format: Numeric/Integer.
doccategoryid int8 19 √ null
hr_documentcategorymaster.doccategoryid Implied Constraint R

FK: Reference to a document category master table
Meaning: The primary classification category for the document (e.g., “Policy,” “Form,” “Training Manual”).
documentpath varchar 1000 √ null

The full path or URL to the physical document file on the server or cloud storage.
Format: Varchar/Text.
status bool 1 √ null

The current lifecycle status of the document (e.g., Draft, Active, Obsolete, Pending Review).
Format: Varchar/Text.
com1 varchar 2147483647 √ null

Custom field 1 (General Purpose) - Reserved for specific, non-standard business data.
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 varchar 2147483647 √ null

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

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

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

Custom field 9 (General Purpose).
Format: Varchar/Text.
com10 varchar 1500 √ null

Custom field 10 (General Purpose).
Format: Varchar/Text.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The ID of the user who uploaded or created the document record.
createdon timestamp 29,6 √ null

Legacy timestamp of when the document record was initially created.
Format: Timestamp.
modifiedby varchar 50 √ null

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

Legacy timestamp of the last modification to the document record.
Format: Timestamp.
branchid varchar 1500 √ null

FK: Reference to a branch master table
Meaning: Restricts visibility to employees belonging to this branch.
paycadreid varchar 1500 √ null

FK: Reference to a pay cadre master table
Meaning: Restricts visibility to employees belonging to this specific pay cadre.
subcategoryid varchar 1500 √ null

FK: Reference to a document sub-category master table
Meaning: The secondary classification sub-category for the document.
stateid varchar 1500 √ null

FK: Reference to a state master table
Meaning: Restricts visibility to employees located in this geographical state.
designationid varchar 1500 √ null

FK: Reference to a designation master table
Meaning: Restricts visibility to employees holding this designation.
categoryid varchar 1500 √ null

FK: Reference to a category master table
Meaning: A general category ID used for broader filtering (may overlap with doccategoryid).
visibletoall bool 1 √ null

Flag indicating whether this document is accessible to all employees, regardless of other organizational unit restrictions.
Format: Boolean.
isdeleted bool 1 false

Flag indicating if the document record has been logically deleted (soft delete).
Format: Boolean.

Indexes

Constraint Name Type Sort Column(s)
hr_documentmaster_pk_hr_documentmaster Primary key Asc documentid

Relationships

Close relationships within degrees of separation