tbl_report_footer_reference_v1

-1 rows


Description

Module: HRMS System Administration & Reporting
Purpose: Stores the names, designations, and digital/scanned signature paths for key organizational stakeholders required to sign or authorize official company reports and documents (e.g., HR letters, final settlement).
Data: Configuration data detailing the signatory authority for various departments (HR, Admin, Director, IT, TDS/Finance).
Process Usage:
- Referenced by the reporting engine to dynamically populate the footer of generated PDF documents.
- Ensures consistency and accuracy of official report signatories across the system.
Key Points:
- Version 1 of the report footer reference, implying potential future versions.
- Directly ties signature blocks to Strategic Business Units (SBUs) for proper organizational context.
Business Impact: Ensures legal and organizational authenticity of system-generated official documents.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for this footer configuration record.
sbu_id int8 19 null

FK: Reference to SBU master table
Meaning: The Strategic Business Unit (SBU) to which this specific footer configuration applies.
Usage: Allows different SBUs to have different authorized signatories.
hr_name varchar 200 √ null

The name of the authorized HR signatory.
Format: Varchar/Text.
hr_designation_id int8 19 √ null

FK: Reference to designation master table
Meaning: The designation ID of the authorized HR signatory.
hr_signature text 2147483647 √ null

The file path or binary data for the HR signatory’s digital/scanned signature.
Format: Varchar/Text (Path/URL) or BYTEA.
admin_name varchar 200 √ null

The name of the authorized Administration signatory.
Format: Varchar/Text.
admin_designation_id int8 19 √ null

FK: Reference to designation master table
Meaning: The designation ID of the authorized Administration signatory.
admin_signature text 2147483647 √ null

The file path or binary data for the Administration signatory’s digital/scanned signature.
Format: Varchar/Text (Path/URL) or BYTEA.
director_name varchar 200 √ null

The name of the authorized Director/Executive signatory.
Format: Varchar/Text.
director_designation_id int8 19 √ null

FK: Reference to designation master table
Meaning: The designation ID of the authorized Director signatory.
director_signature text 2147483647 √ null

The file path or binary data for the Director signatory’s digital/scanned signature.
Format: Varchar/Text (Path/URL) or BYTEA.
it_name varchar 200 √ null

The name of the authorized IT/Technical signatory (often used for technical compliance reports).
Format: Varchar/Text.
it_designation_id int8 19 √ null

FK: Reference to designation master table
Meaning: The designation ID of the authorized IT signatory.
it_signature text 2147483647 √ null

The file path or binary data for the IT signatory’s digital/scanned signature.
Format: Varchar/Text (Path/URL) or BYTEA.
tds_name varchar 200 √ null

The name of the authorized TDS (Tax Deducted at Source) or Finance signatory.
Format: Varchar/Text.
tds_designation_id int8 19 √ null

FK: Reference to designation master table
Meaning: The designation ID of the authorized TDS/Finance signatory.
tds_signature text 2147483647 √ null

The file path or binary data for the TDS/Finance signatory’s digital/scanned signature.
Format: Varchar/Text (Path/URL) or BYTEA.
tds_description varchar 500 √ null

Additional description or notes specific to the TDS/Finance signatory (e.g., certification number).
Format: Text.
createdby varchar 500 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user who created this configuration record.
createddate timestamp 29,6 √ null

Timestamp of when the configuration record was created.
Format: Timestamp with timezone.
modifiedby varchar 500 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The last user who modified this configuration record.
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the configuration record.
Format: Timestamp with timezone.

Indexes

Constraint Name Type Sort Column(s)
tbl_report_footer_reference_v1_pk__tbl__report__footer__referen Primary key Asc id

Relationships

Close relationships within degrees of separation