Table Description
Applicant: A record of an individual who is making an application for assistance.

An application for assistance may contain one or more applicants. Applications may be submitted to an agency by paper or online. The basic information of each application received by an agency is recorded in the system. The applicants on an application are recorded by the system in the Applicant entity.The system creates an applicant record for each applicant on an application. The applicant record maintains the link between the applicant and the application to which they are associated. It also is used to identify if the applicant is the primary applicant on the application.

Additional data captured on the application is recorded by the system on the Intake Information entity and the Intake Avail Times For Interviewentity.

Example

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::Applicant::Applicant
Controlling File: ISProduct\model\Service Layer\entity\IntakeApplication\Applicant\Applicant_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
applicantIDkeynoSystem generated unique identifier for the applicant.APPLICANT_ID SVR_INT64
concernRoleIDdetailsnoThe concern role ID of the applicant.CONCERN_ROLE_ID SVR_INT64
intakeApplicationIDdetailsnoThe application associated with this applicant.INTAKE_APPLICATION_ID SVR_INT64
primaryApplicantInddetails Indicator to show that the concern is the primary applicant for the application.CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (3)
ChildParent
Applicant.concernRoleIDConcernRole.concernRoleID
Applicant.intakeApplicationIDIntakeApplication.intakeApplicationID
InterviewApplicant.applicantIDApplicant.applicantID
Indices (2)
Index NameAttributes
searchApplicantIndexintakeApplicationID
IND_1697222708concernRoleID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: applicantID
Standard Operation 
readread Standard Operation 
searchApplicantsByApplicationIDreadmulti This method returns a list of applicants based on the application ID 
removeremove Standard Operation 
readByConcernRoleAndIntakeApplicationIDnsread This method reads the applicant table by concern role ID and intake Application ID. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
Related Pages (23)