Sage EasyPay Data Model

Entity AppraisalPoint

Description of Entity AppraisalPoint

This entity is to setup questions and statements for the appraisers to respond to.

List of all Dependencies of the Entity AppraisalPoint

Relation_300051

Relation_300051

Reference

List of Attributes of the Entity AppraisalPoint

Entity Attribute ApprPointSysId of the Entity AppraisalPoint

Card of Attribute ApprPointSysId of the Entity AppraisalPoint

Name	ApprPointSysId
Code	ApprPointSysId
Data Type	integer
Mandatory	Yes

Description of Attribute ApprPointSysId of the Entity AppraisalPoint

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

Entity Attribute FreeBlob1 of the Entity AppraisalPoint

Card of Attribute FreeBlob1 of the Entity AppraisalPoint

Name	FreeBlob1
Code	FreeBlob1
Data Type	long binary
Mandatory	No

Description of Attribute FreeBlob1 of the Entity AppraisalPoint

A blob stands for a Binary Large Object. It is a collection of binary data stored as a single entity in a database management system. Blobs are usually images, audio or other multimedia objects.
This attribute allows the user to create a free blob.

Entity Attribute FreeBlob2 of the Entity AppraisalPoint

Card of Attribute FreeBlob2 of the Entity AppraisalPoint

Name	FreeBlob2
Code	FreeBlob2
Data Type	long binary
Mandatory	No

Description of Attribute FreeBlob2 of the Entity AppraisalPoint

A blob stands for a Binary Large Object. It is a collection of binary data stored as a single entity in a database management system. Blobs are usually images, audio or other multimedia objects.
This attribute allows the user to create a free blob.

Entity Attribute FreeNumeric1 of the Entity AppraisalPoint

Card of Attribute FreeNumeric1 of the Entity AppraisalPoint

Name	FreeNumeric1
Code	FreeNumeric1
Data Type	double
Mandatory	No

Description of Attribute FreeNumeric1 of the Entity AppraisalPoint

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Entity Attribute FreeNumeric2 of the Entity AppraisalPoint

Card of Attribute FreeNumeric2 of the Entity AppraisalPoint

Name	FreeNumeric2
Code	FreeNumeric2
Data Type	double
Mandatory	No

Description of Attribute FreeNumeric2 of the Entity AppraisalPoint

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Entity Attribute FreeNumeric3 of the Entity AppraisalPoint

Card of Attribute FreeNumeric3 of the Entity AppraisalPoint

Name	FreeNumeric3
Code	FreeNumeric3
Data Type	double
Mandatory	No

Description of Attribute FreeNumeric3 of the Entity AppraisalPoint

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Entity Attribute FreeNumeric4 of the Entity AppraisalPoint

Card of Attribute FreeNumeric4 of the Entity AppraisalPoint

Name	FreeNumeric4
Code	FreeNumeric4
Data Type	double
Mandatory	No

Description of Attribute FreeNumeric4 of the Entity AppraisalPoint

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Entity Attribute FreeNumeric5 of the Entity AppraisalPoint

Card of Attribute FreeNumeric5 of the Entity AppraisalPoint

Name	FreeNumeric5
Code	FreeNumeric5
Data Type	double
Mandatory	No

Description of Attribute FreeNumeric5 of the Entity AppraisalPoint

Enables the customer to customize the section. Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87

Entity Attribute FreeWt1 of the Entity AppraisalPoint

Card of Attribute FreeWt1 of the Entity AppraisalPoint

Name	FreeWt1
Code	FreeWt1
Data Type	double
Mandatory	No

Description of Attribute FreeWt1 of the Entity AppraisalPoint

Shows the free weight of the appraisal.

Entity Attribute FreeWt2 of the Entity AppraisalPoint

Card of Attribute FreeWt2 of the Entity AppraisalPoint

Name	FreeWt2
Code	FreeWt2
Data Type	double
Mandatory	No

Description of Attribute FreeWt2 of the Entity AppraisalPoint

Shows the free weight of the appraisal.

Entity Attribute FreeWt3 of the Entity AppraisalPoint

Card of Attribute FreeWt3 of the Entity AppraisalPoint

Name	FreeWt3
Code	FreeWt3
Data Type	double
Mandatory	No

Description of Attribute FreeWt3 of the Entity AppraisalPoint

Shows the free weight of the appraisal.

Entity Attribute FreeWt4 of the Entity AppraisalPoint

Card of Attribute FreeWt4 of the Entity AppraisalPoint

Name	FreeWt4
Code	FreeWt4
Data Type	double
Mandatory	No

Description of Attribute FreeWt4 of the Entity AppraisalPoint

Shows the free weight of the appraisal.

Entity Attribute FreeWt5 of the Entity AppraisalPoint

Card of Attribute FreeWt5 of the Entity AppraisalPoint

Name	FreeWt5
Code	FreeWt5
Data Type	double
Mandatory	No

Description of Attribute FreeWt5 of the Entity AppraisalPoint

Shows the free weight of the appraisal.

Entity Attribute FreeString1 of the Entity AppraisalPoint

Card of Attribute FreeString1 of the Entity AppraisalPoint

Name	FreeString1
Code	FreeString1
Data Type	char(200)
Mandatory	No

Description of Attribute FreeString1 of the Entity AppraisalPoint

Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer.
Example: Sage Software Asia Pte. Ltd.

Entity Attribute FreeString2 of the Entity AppraisalPoint

Card of Attribute FreeString2 of the Entity AppraisalPoint

Name	FreeString2
Code	FreeString2
Data Type	char(200)
Mandatory	No

Description of Attribute FreeString2 of the Entity AppraisalPoint

Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer.
Example: Sage Software Asia Pte. Ltd.

Entity Attribute FreeString3 of the Entity AppraisalPoint

Card of Attribute FreeString3 of the Entity AppraisalPoint

Name	FreeString3
Code	FreeString3
Data Type	char(200)
Mandatory	No

Description of Attribute FreeString3 of the Entity AppraisalPoint

Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer.
Example: Sage Software Asia Pte. Ltd.

Entity Attribute FreeString4 of the Entity AppraisalPoint

Card of Attribute FreeString4 of the Entity AppraisalPoint

Name	FreeString4
Code	FreeString4
Data Type	char(200)
Mandatory	No

Description of Attribute FreeString4 of the Entity AppraisalPoint

Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer.
Example: Sage Software Asia Pte. Ltd.

Entity Attribute FreeString5 of the Entity AppraisalPoint

Card of Attribute FreeString5 of the Entity AppraisalPoint

Name	FreeString5
Code	FreeString5
Data Type	char(200)
Mandatory	No

Description of Attribute FreeString5 of the Entity AppraisalPoint

Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer.
Example: Sage Software Asia Pte. Ltd.

Entity Attribute FreeDate1 of the Entity AppraisalPoint

Card of Attribute FreeDate1 of the Entity AppraisalPoint

Name	FreeDate1
Code	FreeDate1
Data Type	date
Mandatory	No

Description of Attribute FreeDate1 of the Entity AppraisalPoint

Enables the customer to customize the section. The customer can ask for the date-of-birth or hire date of the user and this function will show a calendar for an easier selection.
It is in the format: DD-MM-YYYY.

Entity Attribute FreeDate2 of the Entity AppraisalPoint

Card of Attribute FreeDate2 of the Entity AppraisalPoint

Name	FreeDate2
Code	FreeDate2
Data Type	date
Mandatory	No

Description of Attribute FreeDate2 of the Entity AppraisalPoint

Enables the customer to customize the section. The customer can ask for the date-of-birth or hire date of the user and this function will show a calendar for an easier selection.
It is in the format: DD-MM-YYYY.

Entity Attribute FreeDate3 of the Entity AppraisalPoint

Card of Attribute FreeDate3 of the Entity AppraisalPoint

Name	FreeDate3
Code	FreeDate3
Data Type	date
Mandatory	No

Description of Attribute FreeDate3 of the Entity AppraisalPoint

Enables the customer to customize the section. The customer can ask for the date-of-birth or hire date of the user and this function will show a calendar for an easier selection.
It is in the format: DD-MM-YYYY.

Entity Attribute FreeDate4 of the Entity AppraisalPoint

Card of Attribute FreeDate4 of the Entity AppraisalPoint

Name	FreeDate4
Code	FreeDate4
Data Type	date
Mandatory	No

Description of Attribute FreeDate4 of the Entity AppraisalPoint

Enables the customer to customize the section. The customer can ask for the date-of-birth or hire date of the user and this function will show a calendar for an easier selection.
It is in the format: DD-MM-YYYY.

Entity Attribute FreeDate5 of the Entity AppraisalPoint

Card of Attribute FreeDate5 of the Entity AppraisalPoint

Name	FreeDate5
Code	FreeDate5
Data Type	date
Mandatory	No

Description of Attribute FreeDate5 of the Entity AppraisalPoint

Enables the customer to customize the section. The customer can ask for the date-of-birth or hire date of the user and this function will show a calendar for an easier selection.
It is in the format: DD-MM-YYYY.

Entity Attribute FreeInteger1 of the Entity AppraisalPoint

Card of Attribute FreeInteger1 of the Entity AppraisalPoint

Name	FreeInteger1
Code	FreeInteger1
Data Type	integer
Mandatory	No

Description of Attribute FreeInteger1 of the Entity AppraisalPoint

Enables the customer to customize the section. It only allows whole numbers to be inserted.

Entity Attribute FreeInteger2 of the Entity AppraisalPoint

Card of Attribute FreeInteger2 of the Entity AppraisalPoint

Name	FreeInteger2
Code	FreeInteger2
Data Type	integer
Mandatory	No

Description of Attribute FreeInteger2 of the Entity AppraisalPoint

Enables the customer to customize the section. It only allows whole numbers to be inserted.

Entity Attribute FreeInteger3 of the Entity AppraisalPoint

Card of Attribute FreeInteger3 of the Entity AppraisalPoint

Name	FreeInteger3
Code	FreeInteger3
Data Type	integer
Mandatory	No

Description of Attribute FreeInteger3 of the Entity AppraisalPoint

Enables the customer to customize the section. It only allows whole numbers to be inserted.

Entity Attribute FreeInteger4 of the Entity AppraisalPoint

Card of Attribute FreeInteger4 of the Entity AppraisalPoint

Name	FreeInteger4
Code	FreeInteger4
Data Type	integer
Mandatory	No

Description of Attribute FreeInteger4 of the Entity AppraisalPoint

Enables the customer to customize the section. It only allows whole numbers to be inserted.

Entity Attribute FreeInteger5 of the Entity AppraisalPoint

Card of Attribute FreeInteger5 of the Entity AppraisalPoint

Name	FreeInteger5
Code	FreeInteger5
Data Type	integer
Mandatory	No

Description of Attribute FreeInteger5 of the Entity AppraisalPoint

Enables the customer to customize the section. It only allows whole numbers to be inserted.

Entity Attribute SubTotal of the Entity AppraisalPoint

Card of Attribute SubTotal of the Entity AppraisalPoint

Name	SubTotal
Code	SubTotal
Data Type	double
Mandatory	No

Description of Attribute SubTotal of the Entity AppraisalPoint

Shows the sub total for the appraisal.