Entity FinancialRpt

Description of Entity FinancialRpt

Financial reports can be categorized into two types (each with two variants):
- Listing Reports: Display each employee record in a row, and select the column items, like basic wages, overtime hours etc.
- Statistics Reports: Select the column and row items and the report will collate the employee records into these terms

Each spreadsheet can contain one or more of each type or variant, and these are combined reports. Later when you are familiar with setting up reports, you can use colors to differentiate between the different sections, columns, and rows.


List of all Dependencies of the Entity FinancialRpt

Name

Code

Class Name

Relation_1449

Relation_1449

Reference

Relation_1448

Relation_1448

Reference

Relation_1447

Relation_1447

Reference

Relation_1446

Relation_1446

Reference

Relation_950

Relation_950

Reference


List of Attributes of the Entity FinancialRpt

Name

Code

Financial Report ID

FinancialRptId

Description

FinancialRptDesc

Financial Project ID

FinancialAnalysProjId

Has Report Grand Total

FinancialHasGrandTot

Has Total Employee Count

FinancialHasTotEmpCt


Entity Attribute Financial Report ID of the Entity FinancialRpt

Card of Attribute Financial Report ID of the Entity FinancialRpt

Name

Financial Report ID

Code

FinancialRptId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Financial Report ID of the Entity FinancialRpt

Shows the identity of the financial report. This is also the primary key for the FinancialRpt table.
Example:
Emp Statistics Rpt
Coy LveAsOfDate Rpt
Dept PayRecon Rpt
etc


Entity Attribute Description of the Entity FinancialRpt

Card of Attribute Description of the Entity FinancialRpt

Name

Description

Code

FinancialRptDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity FinancialRpt

Stores a description about the financial report.
Example:
Employee Statistics Report
Company Leave As Of Date Listing Report
Department Pay Reconciliation Report
etc


Entity Attribute Financial Project ID of the Entity FinancialRpt

Card of Attribute Financial Project ID of the Entity FinancialRpt

Name

Financial Project ID

Code

FinancialAnalysProjId

Data Type

char(30)

Mandatory

No


Description of Attribute Financial Project ID of the Entity FinancialRpt

Shows the identity of the financial analysis project.
Example:
ExcelEmpStat
ExcelCoLveAsOfDate
ExcelDeptPayRecon
etc


Entity Attribute Has Report Grand Total of the Entity FinancialRpt

Card of Attribute Has Report Grand Total of the Entity FinancialRpt

Name

Has Report Grand Total

Code

FinancialHasGrandTot

Data Type

smallint

Mandatory

No


Description of Attribute Has Report Grand Total of the Entity FinancialRpt

Indicates if the report has a grand total, in a form of a checkbox.


Entity Attribute Has Total Employee Count of the Entity FinancialRpt

Card of Attribute Has Total Employee Count of the Entity FinancialRpt

Name

Has Total Employee Count

Code

FinancialHasTotEmpCt

Data Type

smallint

Mandatory

No


Description of Attribute Has Total Employee Count of the Entity FinancialRpt

Indicates if the report has a total employee count, in a form of a checkbox.