Table Description
Application Form: An application form represents an application for a program made internally by a worker on behalf of a client. When a citizen submits an application, in person, over the phone or using a paper form, the worker may have the option, based on configuration settings, to enter the application on the system using an application form. An application form consists of a set of questions captured in an IEG script. Upon submission of the application form, an application case is created.

Example

James Smith attends his local Social Benefits office in person to see if he is eligible to receive benefits. He meets with a worker, Joan, who advises him that he should apply for Food Allowance and Rent Allowance. Joan creates an application form for James. She completes the application form by filling in the answers James provides to the questions on the script. Before she can submit the form, James needs to leave the office to take an urgent phone call. Joan saves the application form. When James returns, Joan resumes the application form from the point at which it was saved. Once complete, she submits the application form. An application case is created, and all of the information captured in the application form is mapped to the application case as evidence.
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::CommonIntake::CommonIntake::Entity::ApplicationForm::ApplicationForm
Controlling File: CommonIntake\model\Packages\Entity\ApplicationForm.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
applicationFormIDkeynoThe unique identifier of the application form.INTERNAL_ID SVR_INT64
intakeApplicationIDdetailsnoThe unique identifier of the related Intake Application this application form corresponds to.INTERNAL_ID SVR_INT64
statusdetailsnoThe status of the application form. This can be In Progress, Completed, Submitted or Cancelled.APPLICATION_FORM_STATUSApplicationFormStatusSVR_STRING<10>
intakeExecutionIDdetailsnoThe execution ID of the intake script filled out for the application.INTERNAL_ID SVR_INT64
submissionExecutionIDdetailsyesThe execution ID of the submission script for the application, used if the intake script has been completed and a submission script has been configured.INTERNAL_ID SVR_INT64
Foreign Keys (1)
ChildParent
ApplicationForm.intakeApplicationIDIntakeApplication.intakeApplicationID
Indices (1)
Index NameAttributes
ApFormIntakeAppIdxintakeApplicationID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: applicationFormID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByIntakeApplicationreadmulti Returns a list of Application Forms for the given Intake Application. 
Related Pages (5)