Entity AdvanceReport

Description of Entity AdvanceReport

This entity shows the funds of the employees and the employers, current basic rates for the Monthly Variably Component and the National Wages Council.


List of all Dependencies of the Entity AdvanceReport

Name

Code

Class Name

Relation_1275118

Relation_1275118

Reference


List of Attributes of the Entity AdvanceReport

Name

Code

AdvEmployeeSysId

AdvEmployeeSysId

Exchange Rate ID

AdvExRateId

Exchange Rate

AdvExRate

BR Full (F)

AdvBRFullAmtF

MVC Full (F)

AdvMVCFullAmtF

NWC Full (F)

AdvNWCFullAmtF

BR Amt (F)

AdvBRAmtF

MVC Amt (F)

AdvMVCAmtF

NWC Amt (F)

AdvNWCAmtF

BR Amt

AdvBRAmt

MVC Amt

AdvMVCAmt

NWC Amt

AdvNWCAmt

AdvEEFund1

AdvEEFund1

AdvERFund1

AdvERFund1

AdvEEFund2

AdvEEFund2

AdvERFund2

AdvERFund2

AdvEEFund3

AdvEEFund3

AdvERFund3

AdvERFund3

AdvEEFund4

AdvEEFund4

AdvERFund4

AdvERFund4

AdvEEFund5

AdvEEFund5

AdvERFund5

AdvERFund5

AdvEEFund6

AdvEEFund6

AdvERFund6

AdvERFund6

AdvEEFund7

AdvEEFund7

AdvERFund7

AdvERFund7

AdvEEFund8

AdvEEFund8

AdvERFund8

AdvERFund8

AdvEEFund9

AdvEEFund9

AdvERFund9

AdvERFund9

AdvEEFund10

AdvEEFund10

AdvERFund10

AdvERFund10

AdvCurHrDaysBRAmtF

AdvCurHrDaysBRAmtF

AdvCurHrDaysMVCAmtF

AdvCurHrDaysMVCAmtF

AdvCurHrDaysNWCAmtF

AdvCurHrDaysNWCAmtF

AdvCurHrDays

AdvCurHrDays


Entity Attribute AdvEmployeeSysId of the Entity AdvanceReport

Card of Attribute AdvEmployeeSysId of the Entity AdvanceReport

Name

AdvEmployeeSysId

Code

AdvEmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute AdvEmployeeSysId of the Entity AdvanceReport

System generated identifier. It is blind to the user. It also acts as a primary key for the AdvanceReport table.


Entity Attribute Exchange Rate ID of the Entity AdvanceReport

Card of Attribute Exchange Rate ID of the Entity AdvanceReport

Name

Exchange Rate ID

Code

AdvExRateId

Data Type

char(20)

Mandatory

No


Description of Attribute Exchange Rate ID of the Entity AdvanceReport

Shows the identity of the exchange rate.


Entity Attribute Exchange Rate of the Entity AdvanceReport

Card of Attribute Exchange Rate of the Entity AdvanceReport

Name

Exchange Rate

Code

AdvExRate

Data Type

double

Mandatory

No


Description of Attribute Exchange Rate of the Entity AdvanceReport

Shows the exchange rate of the advance pay.


Entity Attribute BR Full (F) of the Entity AdvanceReport

Card of Attribute BR Full (F) of the Entity AdvanceReport

Name

BR Full (F)

Code

AdvBRFullAmtF

Data Type

double

Mandatory

No


Description of Attribute BR Full (F) of the Entity AdvanceReport

Shows the full foreign amount for the basic rate.


Entity Attribute MVC Full (F) of the Entity AdvanceReport

Card of Attribute MVC Full (F) of the Entity AdvanceReport

Name

MVC Full (F)

Code

AdvMVCFullAmtF

Data Type

double

Mandatory

No


Description of Attribute MVC Full (F) of the Entity AdvanceReport

Shows the full foreign amount for the Monthly Variable Component.


Entity Attribute NWC Full (F) of the Entity AdvanceReport

Card of Attribute NWC Full (F) of the Entity AdvanceReport

Name

NWC Full (F)

Code

AdvNWCFullAmtF

Data Type

double

Mandatory

No


Description of Attribute NWC Full (F) of the Entity AdvanceReport

Shows the full foreign amount for the National Wage Council.


Entity Attribute BR Amt (F) of the Entity AdvanceReport

Card of Attribute BR Amt (F) of the Entity AdvanceReport

Name

BR Amt (F)

Code

AdvBRAmtF

Data Type

double

Mandatory

No


Description of Attribute BR Amt (F) of the Entity AdvanceReport

Shows the foreign amount of the basic rate.


Entity Attribute MVC Amt (F) of the Entity AdvanceReport

Card of Attribute MVC Amt (F) of the Entity AdvanceReport

Name

MVC Amt (F)

Code

AdvMVCAmtF

Data Type

double

Mandatory

No


Description of Attribute MVC Amt (F) of the Entity AdvanceReport

Shows the foreign amount of the Monthly Variable Component.


Entity Attribute NWC Amt (F) of the Entity AdvanceReport

Card of Attribute NWC Amt (F) of the Entity AdvanceReport

Name

NWC Amt (F)

Code

AdvNWCAmtF

Data Type

double

Mandatory

No


Description of Attribute NWC Amt (F) of the Entity AdvanceReport

Shows the foreign amount of the National Wage Council.


Entity Attribute BR Amt of the Entity AdvanceReport

Card of Attribute BR Amt of the Entity AdvanceReport

Name

BR Amt

Code

AdvBRAmt

Data Type

double

Mandatory

No


Description of Attribute BR Amt of the Entity AdvanceReport

Shows the basic rate amount.


Entity Attribute MVC Amt of the Entity AdvanceReport

Card of Attribute MVC Amt of the Entity AdvanceReport

Name

MVC Amt

Code

AdvMVCAmt

Data Type

double

Mandatory

No


Description of Attribute MVC Amt of the Entity AdvanceReport

Shows the Monthly Variable Component amount.


Entity Attribute NWC Amt of the Entity AdvanceReport

Card of Attribute NWC Amt of the Entity AdvanceReport

Name

NWC Amt

Code

AdvNWCAmt

Data Type

double

Mandatory

No


Description of Attribute NWC Amt of the Entity AdvanceReport

Shows the National Wage Council amount.


Entity Attribute AdvEEFund1 of the Entity AdvanceReport

Card of Attribute AdvEEFund1 of the Entity AdvanceReport

Name

AdvEEFund1

Code

AdvEEFund1

Data Type

double

Mandatory

No


Description of Attribute AdvEEFund1 of the Entity AdvanceReport

Stores the first fund for the employee.


Entity Attribute AdvERFund1 of the Entity AdvanceReport

Card of Attribute AdvERFund1 of the Entity AdvanceReport

Name

AdvERFund1

Code

AdvERFund1

Data Type

double

Mandatory

No


Description of Attribute AdvERFund1 of the Entity AdvanceReport

Stores the first fund for the employer.


Entity Attribute AdvEEFund2 of the Entity AdvanceReport

Card of Attribute AdvEEFund2 of the Entity AdvanceReport

Name

AdvEEFund2

Code

AdvEEFund2

Data Type

double

Mandatory

No


Description of Attribute AdvEEFund2 of the Entity AdvanceReport

Stores the second fund for the employee.


Entity Attribute AdvERFund2 of the Entity AdvanceReport

Card of Attribute AdvERFund2 of the Entity AdvanceReport

Name

AdvERFund2

Code

AdvERFund2

Data Type

double

Mandatory

No


Description of Attribute AdvERFund2 of the Entity AdvanceReport

Stores the second fund for the employer.


Entity Attribute AdvEEFund3 of the Entity AdvanceReport

Card of Attribute AdvEEFund3 of the Entity AdvanceReport

Name

AdvEEFund3

Code

AdvEEFund3

Data Type

double

Mandatory

No


Description of Attribute AdvEEFund3 of the Entity AdvanceReport

Stores the third fund for the employee.


Entity Attribute AdvERFund3 of the Entity AdvanceReport

Card of Attribute AdvERFund3 of the Entity AdvanceReport

Name

AdvERFund3

Code

AdvERFund3

Data Type

double

Mandatory

No


Description of Attribute AdvERFund3 of the Entity AdvanceReport

Stores the third fund for the employer.


Entity Attribute AdvEEFund4 of the Entity AdvanceReport

Card of Attribute AdvEEFund4 of the Entity AdvanceReport

Name

AdvEEFund4

Code

AdvEEFund4

Data Type

double

Mandatory

No


Description of Attribute AdvEEFund4 of the Entity AdvanceReport

Stores the forth fund for the employee.


Entity Attribute AdvERFund4 of the Entity AdvanceReport

Card of Attribute AdvERFund4 of the Entity AdvanceReport

Name

AdvERFund4

Code

AdvERFund4

Data Type

double

Mandatory

No


Description of Attribute AdvERFund4 of the Entity AdvanceReport

Stores the forth fund for the employer.


Entity Attribute AdvEEFund5 of the Entity AdvanceReport

Card of Attribute AdvEEFund5 of the Entity AdvanceReport

Name

AdvEEFund5

Code

AdvEEFund5

Data Type

double

Mandatory

No


Description of Attribute AdvEEFund5 of the Entity AdvanceReport

Stores the fifth fund for the employee.


Entity Attribute AdvERFund5 of the Entity AdvanceReport

Card of Attribute AdvERFund5 of the Entity AdvanceReport

Name

AdvERFund5

Code

AdvERFund5

Data Type

double

Mandatory

No


Description of Attribute AdvERFund5 of the Entity AdvanceReport

Stores the fifth fund for the employer.


Entity Attribute AdvEEFund6 of the Entity AdvanceReport

Card of Attribute AdvEEFund6 of the Entity AdvanceReport

Name

AdvEEFund6

Code

AdvEEFund6

Data Type

double

Mandatory

No


Description of Attribute AdvEEFund6 of the Entity AdvanceReport

Stores the sixth fund for the employee.


Entity Attribute AdvERFund6 of the Entity AdvanceReport

Card of Attribute AdvERFund6 of the Entity AdvanceReport

Name

AdvERFund6

Code

AdvERFund6

Data Type

double

Mandatory

No


Description of Attribute AdvERFund6 of the Entity AdvanceReport

Stores the sixth fund for the employer.


Entity Attribute AdvEEFund7 of the Entity AdvanceReport

Card of Attribute AdvEEFund7 of the Entity AdvanceReport

Name

AdvEEFund7

Code

AdvEEFund7

Data Type

double

Mandatory

No


Description of Attribute AdvEEFund7 of the Entity AdvanceReport

Stores the seventh fund for the employee.


Entity Attribute AdvERFund7 of the Entity AdvanceReport

Card of Attribute AdvERFund7 of the Entity AdvanceReport

Name

AdvERFund7

Code

AdvERFund7

Data Type

double

Mandatory

No


Description of Attribute AdvERFund7 of the Entity AdvanceReport

Stores the seventh fund for the employer.


Entity Attribute AdvEEFund8 of the Entity AdvanceReport

Card of Attribute AdvEEFund8 of the Entity AdvanceReport

Name

AdvEEFund8

Code

AdvEEFund8

Data Type

double

Mandatory

No


Description of Attribute AdvEEFund8 of the Entity AdvanceReport

Stores the eighth fund for the employee.


Entity Attribute AdvERFund8 of the Entity AdvanceReport

Card of Attribute AdvERFund8 of the Entity AdvanceReport

Name

AdvERFund8

Code

AdvERFund8

Data Type

double

Mandatory

No


Description of Attribute AdvERFund8 of the Entity AdvanceReport

Stores the eighth fund for the employer.


Entity Attribute AdvEEFund9 of the Entity AdvanceReport

Card of Attribute AdvEEFund9 of the Entity AdvanceReport

Name

AdvEEFund9

Code

AdvEEFund9

Data Type

double

Mandatory

No


Description of Attribute AdvEEFund9 of the Entity AdvanceReport

Stores the ninth fund for the employee.


Entity Attribute AdvERFund9 of the Entity AdvanceReport

Card of Attribute AdvERFund9 of the Entity AdvanceReport

Name

AdvERFund9

Code

AdvERFund9

Data Type

double

Mandatory

No


Description of Attribute AdvERFund9 of the Entity AdvanceReport

Stores the ninth fund for the employer.


Entity Attribute AdvEEFund10 of the Entity AdvanceReport

Card of Attribute AdvEEFund10 of the Entity AdvanceReport

Name

AdvEEFund10

Code

AdvEEFund10

Data Type

double

Mandatory

No


Description of Attribute AdvEEFund10 of the Entity AdvanceReport

Stores the tenth fund for the employee.


Entity Attribute AdvERFund10 of the Entity AdvanceReport

Card of Attribute AdvERFund10 of the Entity AdvanceReport

Name

AdvERFund10

Code

AdvERFund10

Data Type

double

Mandatory

No


Description of Attribute AdvERFund10 of the Entity AdvanceReport

Stores the tenth fund for the employer.


Entity Attribute AdvCurHrDaysBRAmtF of the Entity AdvanceReport

Card of Attribute AdvCurHrDaysBRAmtF of the Entity AdvanceReport

Name

AdvCurHrDaysBRAmtF

Code

AdvCurHrDaysBRAmtF

Data Type

double

Mandatory

No


Description of Attribute AdvCurHrDaysBRAmtF of the Entity AdvanceReport

Stores the foreign basic rate amount for the current hire days.


Entity Attribute AdvCurHrDaysMVCAmtF of the Entity AdvanceReport

Card of Attribute AdvCurHrDaysMVCAmtF of the Entity AdvanceReport

Name

AdvCurHrDaysMVCAmtF

Code

AdvCurHrDaysMVCAmtF

Data Type

double

Mandatory

No


Description of Attribute AdvCurHrDaysMVCAmtF of the Entity AdvanceReport

Stores the foreign Monthly Variable Component amount for the current hire days.


Entity Attribute AdvCurHrDaysNWCAmtF of the Entity AdvanceReport

Card of Attribute AdvCurHrDaysNWCAmtF of the Entity AdvanceReport

Name

AdvCurHrDaysNWCAmtF

Code

AdvCurHrDaysNWCAmtF

Data Type

double

Mandatory

No


Description of Attribute AdvCurHrDaysNWCAmtF of the Entity AdvanceReport

Stores the foreign National Wage Council amount for the current hire days.


Entity Attribute AdvCurHrDays of the Entity AdvanceReport

Card of Attribute AdvCurHrDays of the Entity AdvanceReport

Name

AdvCurHrDays

Code

AdvCurHrDays

Data Type

double

Mandatory

No


Description of Attribute AdvCurHrDays of the Entity AdvanceReport

States the number of current hire days.