Entity Appraisal

Description of Entity Appraisal

An appraisal is a generic term for forms that users can fill in. They can be in the form of performance review, user survey forms etc. Common to all appraisals is that questions are assigned points that can be tallied up.


List of all Dependencies of the Entity Appraisal

Name

Code

Class Name

Relation_303319

Relation_303319

Reference

Relation_287041

Relation_287041

Reference

Relation_274844

Relation_274844

Reference

Relation_216807

Relation_216807

Reference

Relation_358892

Relation_358892

Reference

Relation_227693

Relation_227693

Reference

Relation_227691

Relation_227691

Reference

Relation_274419

Relation_274419

Reference

Relation_274441

Relation_274441

Reference

Relation_284244

Relation_284244

Reference


List of Attributes of the Entity Appraisal

Name

Code

PersonalSysId

PersonalSysId

AppraisalSysId

AppraisalSysId

Appraisal Date

AppraisalDate

Service From

AppraisalSvcFrom

Service To

AppraisalSvcTo

Next Appraisal Date

AppraisalNext

Remarks

AppraisalRemarks

Total Performance

AppraisalPerformance

Status

AppraisalStatus

For Bonus Processing

ApprBonusProcess

Appraisal Bonus Factor

ApprBonusFactor

Objective Achieved %

ApprObjectivePercent

Career Movement

ApprCareerMovement

Career Effect Date

ApprCareerEffectDate

Pay Adjustment

ApprPayAdjust

Basic Rate Progression Date

ApprBRProgDate

Adjustment By

ApprAdjustType

Basic Rate

ApprBRAdjust

MVC

ApprMVCAdjust

NWC

ApprNWCAdjust


Entity Attribute PersonalSysId of the Entity Appraisal

Card of Attribute PersonalSysId of the Entity Appraisal

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

No


Description of Attribute PersonalSysId of the Entity Appraisal

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.


Entity Attribute AppraisalSysId of the Entity Appraisal

Card of Attribute AppraisalSysId of the Entity Appraisal

Name

AppraisalSysId

Code

AppraisalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute AppraisalSysId of the Entity Appraisal

A system generated identity. It is blind to the user. This also holds the primary key for the Appraisal table.


Entity Attribute Appraisal Date of the Entity Appraisal

Card of Attribute Appraisal Date of the Entity Appraisal

Name

Appraisal Date

Code

AppraisalDate

Data Type

date

Mandatory

No


Description of Attribute Appraisal Date of the Entity Appraisal

Shows the date of the appraisal.
It is in the format: DD-MM-YYYY.


Entity Attribute Service From of the Entity Appraisal

Card of Attribute Service From of the Entity Appraisal

Name

Service From

Code

AppraisalSvcFrom

Data Type

date

Mandatory

No


Description of Attribute Service From of the Entity Appraisal

Shows the start date of the appraisal.
It is in the format: DD-MM-YYYY.


Entity Attribute Service To of the Entity Appraisal

Card of Attribute Service To of the Entity Appraisal

Name

Service To

Code

AppraisalSvcTo

Data Type

date

Mandatory

No


Description of Attribute Service To of the Entity Appraisal

Shows the end date of the appraisal.
It is in the format: DD-MM-YYYY.


Entity Attribute Next Appraisal Date of the Entity Appraisal

Card of Attribute Next Appraisal Date of the Entity Appraisal

Name

Next Appraisal Date

Code

AppraisalNext

Data Type

date

Mandatory

No


Description of Attribute Next Appraisal Date of the Entity Appraisal

Shows the date of the next appraisal.
It is in the format: DD-MM-YYYY.


Entity Attribute Remarks of the Entity Appraisal

Card of Attribute Remarks of the Entity Appraisal

Name

Remarks

Code

AppraisalRemarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity Appraisal

Stores any remarks about the appraisal.


Entity Attribute Total Performance of the Entity Appraisal

Card of Attribute Total Performance of the Entity Appraisal

Name

Total Performance

Code

AppraisalPerformance

Data Type

double

Mandatory

No


Description of Attribute Total Performance of the Entity Appraisal

Shows the total performance for the appraisal.


Entity Attribute Status of the Entity Appraisal

Card of Attribute Status of the Entity Appraisal

Name

Status

Code

AppraisalStatus

Data Type

char(20)

Mandatory

No


Description of Attribute Status of the Entity Appraisal

Shows the status of the appraisal.


Entity Attribute For Bonus Processing of the Entity Appraisal

Card of Attribute For Bonus Processing of the Entity Appraisal

Name

For Bonus Processing

Code

ApprBonusProcess

Data Type

smallint

Mandatory

No


Description of Attribute For Bonus Processing of the Entity Appraisal

Indicates if the appraisal performance is for bonus processing, in a form of a checkbox.


Entity Attribute Appraisal Bonus Factor of the Entity Appraisal

Card of Attribute Appraisal Bonus Factor of the Entity Appraisal

Name

Appraisal Bonus Factor

Code

ApprBonusFactor

Data Type

double

Mandatory

No


Description of Attribute Appraisal Bonus Factor of the Entity Appraisal

Shows the bonus factor for the appraisal.


Entity Attribute Objective Achieved % of the Entity Appraisal

Card of Attribute Objective Achieved % of the Entity Appraisal

Name

Objective Achieved %

Code

ApprObjectivePercent

Data Type

double

Mandatory

No


Description of Attribute Objective Achieved % of the Entity Appraisal

Shows the objective percentage achieved for the appraisal.


Entity Attribute Career Movement of the Entity Appraisal

Card of Attribute Career Movement of the Entity Appraisal

Name

Career Movement

Code

ApprCareerMovement

Data Type

smallint

Mandatory

No


Description of Attribute Career Movement of the Entity Appraisal

Indicates the career movement, in a form of radio buttons.
Example: No Change / Promotion / Demotion / Transfer


Entity Attribute Career Effect Date of the Entity Appraisal

Card of Attribute Career Effect Date of the Entity Appraisal

Name

Career Effect Date

Code

ApprCareerEffectDate

Data Type

date

Mandatory

No


Description of Attribute Career Effect Date of the Entity Appraisal

Shows the effective date of the career.
It is in the format: DD-MM-YYYY.


Entity Attribute Pay Adjustment of the Entity Appraisal

Card of Attribute Pay Adjustment of the Entity Appraisal

Name

Pay Adjustment

Code

ApprPayAdjust

Data Type

smallint

Mandatory

No


Description of Attribute Pay Adjustment of the Entity Appraisal

Indicates the pay adjustment for the appraisal, in a form of radio buttons.
Example: No Change / Increment / Decrement


Entity Attribute Basic Rate Progression Date of the Entity Appraisal

Card of Attribute Basic Rate Progression Date of the Entity Appraisal

Name

Basic Rate Progression Date

Code

ApprBRProgDate

Data Type

date

Mandatory

No


Description of Attribute Basic Rate Progression Date of the Entity Appraisal

Shows the date for the basic rate progression.
It is in the format: DD-MM-YYYY.


Entity Attribute Adjustment By of the Entity Appraisal

Card of Attribute Adjustment By of the Entity Appraisal

Name

Adjustment By

Code

ApprAdjustType

Data Type

smallint

Mandatory

No


Description of Attribute Adjustment By of the Entity Appraisal

Indicates the adjustment type for the appraisal, in a form of radio buttons.
Example: Percentage / Fixed Amount


Entity Attribute Basic Rate of the Entity Appraisal

Card of Attribute Basic Rate of the Entity Appraisal

Name

Basic Rate

Code

ApprBRAdjust

Data Type

double

Mandatory

No


Description of Attribute Basic Rate of the Entity Appraisal

Shows the basic rate adjustment for the appraisal.


Entity Attribute MVC of the Entity Appraisal

Card of Attribute MVC of the Entity Appraisal

Name

MVC

Code

ApprMVCAdjust

Data Type

double

Mandatory

No


Description of Attribute MVC of the Entity Appraisal

Shows the adjustment of the Monthly Variable Component for the appraisal.


Entity Attribute NWC of the Entity Appraisal

Card of Attribute NWC of the Entity Appraisal

Name

NWC

Code

ApprNWCAdjust

Data Type

double

Mandatory

No


Description of Attribute NWC of the Entity Appraisal

Shows the adjustment of the National Wages Council for the appraisal.