Entity CostProgression

Description of Entity CostProgression

An employee's cost centre progression record determines how his / her cost is being distributed across the cost centres.


List of all Dependencies of the Entity CostProgression

Name

Code

Class Name

Relation_305558

Relation_305558

Reference

Relation_305557

Relation_305557

Reference


List of Attributes of the Entity CostProgression

Name

Code

CostProgSysId

CostProgSysId

EmployeeSysId

EmployeeSysId

Effective Date

CostProgEffectiveDate

Career Code

CostCareerId

Current Cost Centre

CostCentreCurrent

Description

CostCentreProgDesc


Entity Attribute CostProgSysId of the Entity CostProgression

Card of Attribute CostProgSysId of the Entity CostProgression

Name

CostProgSysId

Code

CostProgSysId

Data Type

integer

Mandatory

Yes


Description of Attribute CostProgSysId of the Entity CostProgression

A system generated identity. It is blind to the user. It also acts as a primary key for the CostProgression table.


Entity Attribute EmployeeSysId of the Entity CostProgression

Card of Attribute EmployeeSysId of the Entity CostProgression

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity CostProgression

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.


Entity Attribute Effective Date of the Entity CostProgression

Card of Attribute Effective Date of the Entity CostProgression

Name

Effective Date

Code

CostProgEffectiveDate

Data Type

date

Mandatory

No


Description of Attribute Effective Date of the Entity CostProgression

Shows the effective date of the cost progression.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Career Code of the Entity CostProgression

Card of Attribute Career Code of the Entity CostProgression

Name

Career Code

Code

CostCareerId

Data Type

char(20)

Mandatory

No


Description of Attribute Career Code of the Entity CostProgression

Shows the identity of the career for the employee.
Example: FirstRecord / Transfer / Promotion / SalaryAdjust etc


Entity Attribute Current Cost Centre of the Entity CostProgression

Card of Attribute Current Cost Centre of the Entity CostProgression

Name

Current Cost Centre

Code

CostCentreCurrent

Data Type

smallint

Mandatory

No


Description of Attribute Current Cost Centre of the Entity CostProgression

Shows if it is the current cost centre, in a form of a checkbox.


Entity Attribute Description of the Entity CostProgression

Card of Attribute Description of the Entity CostProgression

Name

Description

Code

CostCentreProgDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity CostProgression

Stores any description about the cost progression.