Table Description
Interview: An interview of a citizen(s) by an agency worker in respect of their application to the agency for assistance.

Applicants are required to attend an interview as part of the application process. The interview is where the agency worker obtains all the data required for a complete application from the applicant. The interview is used to capture the details as outlined below. The system creates this record when the agency records the interview information in the system.

Interviews are generally conducted face to face with the applicant and in special circumstances (under waiver) are sometimes conducted over the phone. Interviews may be rescheduled for a number of reasons, but must be conducted within a specified time period of the receipt of the application.

Applicants present at the interview are recorded via the Interview Applicantentity.

Additional evidence details are captured via the evidence entities.

Example

An application for assistance is received by an agency. The application is recorded in the system. An agency worker arranges an interview with the applicant(s). The applicant(s) present themselves to the agency on the scheduled date for the interview. The agency worker selects the application and starts the interview, by selecting the start interview link on the application home page within CGISS, where the user then records the basic details of the interview.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Income Support Product::Service Layer::entity::IntakeApplication::Interview::Interview
Controlling File: ISProduct\model\Service Layer\entity\IntakeApplication\Interview\Interview_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (11)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
interviewIDkeynoUnique ID for an interview.INTERVIEW_ID SVR_INT64
intakeApplicationIDdetailsnoUnique ID of the intake application record that this interview relates to.INTAKE_APPLICATION_ID SVR_INT64
startDateTimedetails The date and time (12 hour clock) on which the interview begins.CURAM_DATETIME SVR_DATETIME
endDateTimedetails The date and time (12 hour clock) on which the interview ends.CURAM_DATETIME SVR_DATETIME
interviewMethodCodedetails Code value to denote the method by which the interview by conducted. The possible values are - Phone, In Person. INTERVIEW_METHOD_CODEInterviewMethodCodeSVR_STRING<10>
interviewWaivedInddetails Indicates if the interview was waived or not.CURAM_INDICATOR SVR_BOOLEAN
interviewWaiverReasonCodedetails Code value to denote the reason that the interview was waived.INTERVIEW_WAIVER_REASON_CODEInterviewWaiverReasonCodeSVR_STRING<10>
statusCodedetails Code value to denote the status of the Interview record.INTERVIEW_STATUS_CODEInterviewStatusCodeSVR_STRING<10>
nonAttendanceReasonCodedetails Code value to denote the reason that the claimant did not attend the interview.NONATTENDANCE_REASON_CODENonAttendanceReasonCodeSVR_STRING<10>
interviewPerformedBydetailsnoThe userID of the caseworker who performed the interview.USER_NAME SVR_STRING<64>
commentsdetails Comments relating to the interview.COMMENTS SVR_STRING<300>
Foreign Keys (3)
ChildParent
Interview.intakeApplicationIDIntakeApplication.intakeApplicationID
Interview.interviewPerformedByUsers.userName
InterviewApplicant.interviewIDInterview.interviewID
Indices (2)
Index NameAttributes
InterviewAppIDIndexintakeApplicationID
IND__978729964interviewPerformedBy
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: interviewID
Standard Operation 
readread Standard Operation 
searchInterviewByIntakeAppIDreadmulti   
modifymodify Method used to update the details of an Interview. 
searchByAppIDAndStatusInProgressnsread   
Related Pages (6)