Sage EasyPay Data Model

Entity InterviewSchedule

Description of Entity InterviewSchedule

This entity shows the schedule of the interview. What time and which day is it, where it will be held are one of the more mandatory fields for an interview schedule.

List of all Dependencies of the Entity InterviewSchedule

Relation_376270

Reference

Relation_410858

Reference

List of Attributes of the Entity InterviewSchedule

Entity Attribute InterviewSchSysId of the Entity InterviewSchedule

Card of Attribute InterviewSchSysId of the Entity InterviewSchedule

Name	InterviewSchSysId
Code	InterviewSchSysId
Data Type	integer
Mandatory	Yes

Description of Attribute InterviewSchSysId of the Entity InterviewSchedule

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

Entity Attribute Interview Date of the Entity InterviewSchedule

Card of Attribute Interview Date of the Entity InterviewSchedule

Name	Interview Date
Code	InterviewDate
Data Type	date
Mandatory	No

Description of Attribute Interview Date of the Entity InterviewSchedule

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

Entity Attribute Interview Time of the Entity InterviewSchedule

Card of Attribute Interview Time of the Entity InterviewSchedule

Name	Interview Time
Code	InterviewTime
Data Type	time
Mandatory	No

Description of Attribute Interview Time of the Entity InterviewSchedule

Shows the time of the interview.

Entity Attribute Remarks of the Entity InterviewSchedule

Card of Attribute Remarks of the Entity InterviewSchedule

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

Description of Attribute Remarks of the Entity InterviewSchedule

Store remarks about the interview.

Entity Attribute Location of the Entity InterviewSchedule

Card of Attribute Location of the Entity InterviewSchedule

Name	Location
Code	InterviewLoc
Data Type	char(20)
Mandatory	No

Description of Attribute Location of the Entity InterviewSchedule

Shows the location of the interview.

Entity Attribute Recruit Action of the Entity InterviewSchedule

Card of Attribute Recruit Action of the Entity InterviewSchedule

Name	Recruit Action
Code	RecruitAction
Data Type	char(20)
Mandatory	No

Description of Attribute Recruit Action of the Entity InterviewSchedule

Shows the recruit action of the interview.

Entity Attribute Applicant Response of the Entity InterviewSchedule

Card of Attribute Applicant Response of the Entity InterviewSchedule

Name	Applicant Response
Code	ApplicantResponse
Data Type	char(20)
Mandatory	No

Description of Attribute Applicant Response of the Entity InterviewSchedule

Shows the response of the applicant.

Entity Attribute Created Date Time of the Entity InterviewSchedule

Card of Attribute Created Date Time of the Entity InterviewSchedule

Name	Created Date Time
Code	CreatedDateTime
Data Type	timestamp
Mandatory	No

Description of Attribute Created Date Time of the Entity InterviewSchedule

Shows the date and time of when the task/reminder was created.

Entity Attribute InterviewOrder of the Entity InterviewSchedule

Card of Attribute InterviewOrder of the Entity InterviewSchedule

Name	InterviewOrder
Code	InterviewOrder
Data Type	integer
Mandatory	No

Description of Attribute InterviewOrder of the Entity InterviewSchedule

Shows the order of the interview.

Entity Attribute Applicant Last Response Date of the Entity InterviewSchedule

Card of Attribute Applicant Last Response Date of the Entity InterviewSchedule

Name	Applicant Last Response Date
Code	ApplicantRespDate
Data Type	date
Mandatory	No

Description of Attribute Applicant Last Response Date of the Entity InterviewSchedule

Shows the date where the applicant responds.
It is in the format: DD-MM-YYYY.

Home