Sage EasyPay Data Model

Entity Applicant

Description of Entity Applicant

Displays information about the applicant. How the applicant came to know about the job recruitment, his/her expected salary, when they can start working etc.

List of all Dependencies of the Entity Applicant

Reference

Reference

Reference

Reference

Reference

List of Attributes of the Entity Applicant

Available Date (Start Work)

Entity Attribute PersonalSysId of the Entity Applicant

Card of Attribute PersonalSysId of the Entity Applicant

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	No

Description of Attribute PersonalSysId of the Entity Applicant

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 ApplicantSysId of the Entity Applicant

Card of Attribute ApplicantSysId of the Entity Applicant

Name	ApplicantSysId
Code	ApplicantSysId
Data Type	integer
Mandatory	Yes

Description of Attribute ApplicantSysId of the Entity Applicant

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

Entity Attribute Submitted Date of the Entity Applicant

Card of Attribute Submitted Date of the Entity Applicant

Name	Submitted Date
Code	AppDateSubmitted
Data Type	date
Mandatory	No

Description of Attribute Submitted Date of the Entity Applicant

Shows the date of submission of the recruitment for the applicant.
It is in the format: DD-MM-YYYY.

Entity Attribute Expected Salary of the Entity Applicant

Card of Attribute Expected Salary of the Entity Applicant

Name	Expected Salary
Code	AppExpectedSalary
Data Type	double
Mandatory	No

Description of Attribute Expected Salary of the Entity Applicant

Shows the expected salary for the applicant.

Entity Attribute Available Date (Start Work) of the Entity Applicant

Card of Attribute Available Date (Start Work) of the Entity Applicant

Name	Available Date (Start Work)
Code	AppAvailability
Data Type	date
Mandatory	No

Description of Attribute Available Date (Start Work) of the Entity Applicant

Shows when the applicant is available to start working.
It is in the format: DD-MM-YYYY.

Entity Attribute Recommended of the Entity Applicant

Card of Attribute Recommended of the Entity Applicant

Name	Recommended
Code	Recommended
Data Type	smallint
Mandatory	No

Description of Attribute Recommended of the Entity Applicant

Indicates if this applicant was a recommendation, in a form of a checkbox.

Entity Attribute Recommended By of the Entity Applicant

Card of Attribute Recommended By of the Entity Applicant

Name	Recommended By
Code	RecommendedBy
Data Type	char(100)
Mandatory	No

Description of Attribute Recommended By of the Entity Applicant

If the applicant was a recommendation, who was he/she recommended by?

Entity Attribute Remarks of the Entity Applicant

Card of Attribute Remarks of the Entity Applicant

Name	Remarks
Code	Remarks
Data Type	char(100)
Mandatory	No

Description of Attribute Remarks of the Entity Applicant

Store remarks.

Home