tbl_letterhead

-1 rows


Description

Module: HRMS Document Management
Purpose: Stores reusable letterhead templates with headers, footers, watermarks, and layout configurations for official document generation.
Data: Contains complete letterhead designs including HTML headers/footers, positioning measurements, watermarks, and activation status.
Process Usage:
- Serves as template repository for official HR letters, certificates, and organizational documents.
- Provides consistent branding and formatting across all generated documents.
- Enables dynamic selection of letterheads based on document type and organizational requirements.
Key Points:
- Supports precise positioning control for header/footer placement.
- Allows watermark integration for confidential or draft documents.
- Maintains soft delete capability for template management.
Business Impact: Essential for maintaining professional document standards, brand consistency, and efficient document generation workflows.

Columns

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

Primary key
Format: BigSerial (auto-increment)
Used as: Unique identifier for each letterhead template.
letterheadname varchar 100 √ null

Unique name identifier for the letterhead template
Format: String
Examples: “Official_Corporate”, “Confidential_Draft”, “HR_Certificate”
Usage: Used by document generation systems to reference specific letterhead templates.
footerfrombottom varchar 50 √ null

Vertical positioning measurement for footer placement
Format: String (typically CSS units: px, mm, cm, in)
Examples from Data: “0” (default positioning)
Usage: Defines the distance from the bottom of the page where the footer content is positioned.
CSS Implementation: Used in margin-bottom or bottom positioning properties.
headerfromtop varchar 50 √ null

Vertical positioning measurement for header placement
Format: String (typically CSS units: px, mm, cm, in)
Examples from Data: “0” (default positioning)
Usage: Defines the distance from the top of the page where the header content begins.
CSS Implementation: Used in margin-top or top positioning properties.
header varchar 2147483647 √ null

HTML content for the document header section with dynamic data binding
Format: HTML String with embedded images and dynamic variables
Content Examples from Data:
- Company logos with responsive sizing from cloud storage
- Dynamic date and employee information using {{variable}} syntax
- Rich text formatting with CSS styling
- Image embedding: <img src=“https://emgage-demo.s3.amazonaws.com/…”>
Dynamic Variables Used: {{EmployeementDate}}, {{Salutation}}, {{EFirstName}}, {{ELastName}}, {{EAddress}}
Usage: Rendered at the top of every page in generated documents with real-time data substitution.
footer varchar 2147483647 √ null

HTML content for the document footer section with image support
Format: HTML String with embedded images
Content Examples from Data:
- Image-based footers: <img src=“https://emgage-demo.s3.amazonaws.com/…”>
- File references: “footer(1)_1670909796202.jpg”
- Company branding and contact information
Usage: Rendered at the bottom of every page in generated documents.
htmlcontent varchar 5000 √ null
watermark varchar 100 √ null

Watermark image file name or configuration
Format: String (image file name or HTML content)
Examples from Data: Image file names like “footer(1)_1670909796202.jpg”
Usage: Applied as background element to indicate document status or classification.
Storage: Images typically stored in cloud storage (AWS S3) with generated URLs.
status bool 1 √ null

Activation status of the letterhead template
Type: Boolean
TRUE: Template is active and available for document generation
FALSE: Template is inactive and cannot be used
Usage: Controls template availability without permanent deletion.
isdeleted bool 1 √ null

Soft delete flag for template management
Type: Boolean
TRUE: Template is marked as deleted (archived)
FALSE: Template is active in the system
Usage: Supports template retirement while preserving historical document references.
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)
tbl_letterhead_pk__tbl_lett__3214ec07a0bd069e Primary key Asc id

Relationships

Close relationships within degrees of separation