Entity ExportSetting

Description of Entity ExportSetting

The different settings to export a pay detail. You have to select the period, sub period and year, also choose what type of pay you want to include in the report you are exporting, Bonus / Normal / Advance etc Pay.


List of all Dependencies of the Entity ExportSetting

Name

Code

Class Name

Relation_153758

Relation_153758

Reference


List of Attributes of the Entity ExportSetting

Name

Code

Export Report ID

ExReportID

Year

ExPayRecYear

Period

ExPayRecPeriod

Sub Period

ExPayRecSubPeriod

Export Sort By

ExSortBy

Export Normal Pay

ExNormalPay

Export Bonus Pay

ExBonusPay

Export Other Pay

ExOtherPay

ExAdvancePay

ExAdvancePay

ExReportIdDesc

ExReportIdDesc

ExLinePerPage

ExLinePerPage

ExLine1

ExLine1

ExLine2

ExLine2

ExLine3

ExLine3

ExLine4

ExLine4

ExLine5

ExLine5

ExLine6

ExLine6

ExLine7

ExLine7

ExLine8

ExLine8

ExLine9

ExLine9

ExLine10

ExLine10


Entity Attribute Export Report ID of the Entity ExportSetting

Card of Attribute Export Report ID of the Entity ExportSetting

Name

Export Report ID

Code

ExReportID

Data Type

char(30)

Mandatory

Yes


Description of Attribute Export Report ID of the Entity ExportSetting

Shows the identity of the export report. This also acts as a primary key for the ExportSetting table.


Entity Attribute Year of the Entity ExportSetting

Card of Attribute Year of the Entity ExportSetting

Name

Year

Code

ExPayRecYear

Data Type

integer

Mandatory

Yes


Description of Attribute Year of the Entity ExportSetting

Shows the year for the export setting.
Example: 2012


Entity Attribute Period of the Entity ExportSetting

Card of Attribute Period of the Entity ExportSetting

Name

Period

Code

ExPayRecPeriod

Data Type

integer

Mandatory

Yes


Description of Attribute Period of the Entity ExportSetting

Shows the period for the export setting.
Example: January = "1", February = "2", March = "3" etc.


Entity Attribute Sub Period of the Entity ExportSetting

Card of Attribute Sub Period of the Entity ExportSetting

Name

Sub Period

Code

ExPayRecSubPeriod

Data Type

integer

Mandatory

Yes


Description of Attribute Sub Period of the Entity ExportSetting

Holds the sub period for the export setting.

Example:
Sub period 1 = 1 Payment Group (Hourly, Daily & Monthly rated)
Sub period 2 = 2 Payment Group (Hourly, Daily & Monthly rated)
Sub period 3 = 3 Payment Group (Hourly & Daily rated), divided by 3 and the balance is placed in the last sub-period
Sub Period 4 = 4 Payment Group (Hourly & Daily rated)


Entity Attribute Export Sort By of the Entity ExportSetting

Card of Attribute Export Sort By of the Entity ExportSetting

Name

Export Sort By

Code

ExSortBy

Data Type

char(20)

Mandatory

Yes


Description of Attribute Export Sort By of the Entity ExportSetting

Shows how the export setting is sorted.


Entity Attribute Export Normal Pay of the Entity ExportSetting

Card of Attribute Export Normal Pay of the Entity ExportSetting

Name

Export Normal Pay

Code

ExNormalPay

Data Type

integer

Mandatory

Yes


Description of Attribute Export Normal Pay of the Entity ExportSetting

Shows the normal pay that will be exported.


Entity Attribute Export Bonus Pay of the Entity ExportSetting

Card of Attribute Export Bonus Pay of the Entity ExportSetting

Name

Export Bonus Pay

Code

ExBonusPay

Data Type

integer

Mandatory

Yes


Description of Attribute Export Bonus Pay of the Entity ExportSetting

Shows the bonus pay that will be exported.


Entity Attribute Export Other Pay of the Entity ExportSetting

Card of Attribute Export Other Pay of the Entity ExportSetting

Name

Export Other Pay

Code

ExOtherPay

Data Type

integer

Mandatory

Yes


Description of Attribute Export Other Pay of the Entity ExportSetting

Shows other pays that can be exported.


Entity Attribute ExAdvancePay of the Entity ExportSetting

Card of Attribute ExAdvancePay of the Entity ExportSetting

Name

ExAdvancePay

Code

ExAdvancePay

Data Type

integer

Mandatory

No


Description of Attribute ExAdvancePay of the Entity ExportSetting

Shows the advance pay that can be exported.


Entity Attribute ExReportIdDesc of the Entity ExportSetting

Card of Attribute ExReportIdDesc of the Entity ExportSetting

Name

ExReportIdDesc

Code

ExReportIdDesc

Data Type

char(100)

Mandatory

No


Description of Attribute ExReportIdDesc of the Entity ExportSetting

Shows the report identity description that will be exported.


Entity Attribute ExLinePerPage of the Entity ExportSetting

Card of Attribute ExLinePerPage of the Entity ExportSetting

Name

ExLinePerPage

Code

ExLinePerPage

Data Type

integer

Mandatory

No


Description of Attribute ExLinePerPage of the Entity ExportSetting

Shows the number of lines per page that are available when exported.


Entity Attribute ExLine1 of the Entity ExportSetting

Card of Attribute ExLine1 of the Entity ExportSetting

Name

ExLine1

Code

ExLine1

Data Type

char(100)

Mandatory

No


Description of Attribute ExLine1 of the Entity ExportSetting

Shows the first line of the export line.


Entity Attribute ExLine2 of the Entity ExportSetting

Card of Attribute ExLine2 of the Entity ExportSetting

Name

ExLine2

Code

ExLine2

Data Type

char(100)

Mandatory

No


Description of Attribute ExLine2 of the Entity ExportSetting

Shows the second line of the export line.


Entity Attribute ExLine3 of the Entity ExportSetting

Card of Attribute ExLine3 of the Entity ExportSetting

Name

ExLine3

Code

ExLine3

Data Type

char(100)

Mandatory

No


Description of Attribute ExLine3 of the Entity ExportSetting

Shows the third line of the export line.


Entity Attribute ExLine4 of the Entity ExportSetting

Card of Attribute ExLine4 of the Entity ExportSetting

Name

ExLine4

Code

ExLine4

Data Type

char(100)

Mandatory

No


Description of Attribute ExLine4 of the Entity ExportSetting

Shows the forth line of the export line.


Entity Attribute ExLine5 of the Entity ExportSetting

Card of Attribute ExLine5 of the Entity ExportSetting

Name

ExLine5

Code

ExLine5

Data Type

char(100)

Mandatory

No


Description of Attribute ExLine5 of the Entity ExportSetting

Shows the fifth line of the export line.


Entity Attribute ExLine6 of the Entity ExportSetting

Card of Attribute ExLine6 of the Entity ExportSetting

Name

ExLine6

Code

ExLine6

Data Type

char(100)

Mandatory

No


Description of Attribute ExLine6 of the Entity ExportSetting

Shows the sixth line of the export line.


Entity Attribute ExLine7 of the Entity ExportSetting

Card of Attribute ExLine7 of the Entity ExportSetting

Name

ExLine7

Code

ExLine7

Data Type

char(100)

Mandatory

No


Description of Attribute ExLine7 of the Entity ExportSetting

Shows the seventh line of the export line.


Entity Attribute ExLine8 of the Entity ExportSetting

Card of Attribute ExLine8 of the Entity ExportSetting

Name

ExLine8

Code

ExLine8

Data Type

char(100)

Mandatory

No


Description of Attribute ExLine8 of the Entity ExportSetting

Shows the eighth line of the export line.


Entity Attribute ExLine9 of the Entity ExportSetting

Card of Attribute ExLine9 of the Entity ExportSetting

Name

ExLine9

Code

ExLine9

Data Type

char(100)

Mandatory

No


Description of Attribute ExLine9 of the Entity ExportSetting

Shows the ninth line of the export line.


Entity Attribute ExLine10 of the Entity ExportSetting

Card of Attribute ExLine10 of the Entity ExportSetting

Name

ExLine10

Code

ExLine10

Data Type

char(100)

Mandatory

No


Description of Attribute ExLine10 of the Entity ExportSetting

Shows the tenth line of the export line.