Entity EmployeeRpt

Description of Entity EmployeeRpt

Employee reports displays one employee record per row and the report items are laid in columns. The layout is similar to the financial listing reports.


List of all Dependencies of the Entity EmployeeRpt

Name

Code

Class Name

Relation_1893

Relation_1893

Reference

Relation_1892

Relation_1892

Reference

Relation_958

Relation_958

Reference


List of Attributes of the Entity EmployeeRpt

Name

Code

Employee Report ID

EmpInfoRptId

Description

EmpInfoRptDesc

Report Based On

EmpInfoRptType

Has Report Condition

EmployeeRptHasFilter

EmployeeRptFilterCond

EmployeeRptFilterCond

Has Employee Count

EmployeeRptHasEmpCt

To report base on Employed Staff

EmployeeRptHasEmpOnly


Entity Attribute Employee Report ID of the Entity EmployeeRpt

Card of Attribute Employee Report ID of the Entity EmployeeRpt

Name

Employee Report ID

Code

EmpInfoRptId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Employee Report ID of the Entity EmployeeRpt

Shows the identity of the employee information report. This is also the primary key for the EmployeeRpt table.


Entity Attribute Description of the Entity EmployeeRpt

Card of Attribute Description of the Entity EmployeeRpt

Name

Description

Code

EmpInfoRptDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity EmployeeRpt

Stores a description about the employee information report.


Entity Attribute Report Based On of the Entity EmployeeRpt

Card of Attribute Report Based On of the Entity EmployeeRpt

Name

Report Based On

Code

EmpInfoRptType

Data Type

char(20)

Mandatory

No


Description of Attribute Report Based On of the Entity EmployeeRpt

Shows the type of the employee information report.


Entity Attribute Has Report Condition of the Entity EmployeeRpt

Card of Attribute Has Report Condition of the Entity EmployeeRpt

Name

Has Report Condition

Code

EmployeeRptHasFilter

Data Type

smallint

Mandatory

No


Description of Attribute Has Report Condition of the Entity EmployeeRpt

Indicates if the employee report has a filter, i.e. users can choose what to include in the report.


Entity Attribute EmployeeRptFilterCond of the Entity EmployeeRpt

Card of Attribute EmployeeRptFilterCond of the Entity EmployeeRpt

Name

EmployeeRptFilterCond

Code

EmployeeRptFilterCond

Data Type

char(255)

Mandatory

No


Description of Attribute EmployeeRptFilterCond of the Entity EmployeeRpt

A condition for the employee report filter.


Entity Attribute Has Employee Count of the Entity EmployeeRpt

Card of Attribute Has Employee Count of the Entity EmployeeRpt

Name

Has Employee Count

Code

EmployeeRptHasEmpCt

Data Type

smallint

Mandatory

No


Description of Attribute Has Employee Count of the Entity EmployeeRpt

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


Entity Attribute To report base on Employed Staff of the Entity EmployeeRpt

Card of Attribute To report base on Employed Staff of the Entity EmployeeRpt

Name

To report base on Employed Staff

Code

EmployeeRptHasEmpOnly

Data Type

smallint

Mandatory

No


Description of Attribute To report base on Employed Staff of the Entity EmployeeRpt

Indicates if the employee report has employees only, in a form of a checkbox.