Table Description
IntakeApplicationType: This entity represents an application form used to provide intake information for one or more programs offered by the social agency.
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::WorkspaceServices::Entity::Intake::IntakeApplicationType::IntakeApplicationType
Controlling File: WorkspaceServices\model\Packages\Entity\IntakeApplicationType\IntakeApplicationType_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (18)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
intakeApplicationTypeIDkeynoUnique identifier for this record.INTERNAL_ID SVR_INT64
nameTextIDdetailsnoThe name of the application, e.g. TANF Application Form.LOCALIZABLE_TEXT_ID SVR_INT64
descriptionTextIDdetailsnoA detailed description of the purpose of the application.LOCALIZABLE_TEXT_ID SVR_INT64
intakeScriptIDdetailsyesA reference to the IEG script that is used to capture the data required for the application.IEG_SCRIPT_ID SVR_STRING<100>
summaryTextIDdetails A summary description of the application. This is used to describe the application where it is displayed in lists with other applications in the Citizen Portal.LOCALIZABLE_TEXT_ID SVR_INT64
channeldetails The channel by which the application is available, e.g. Online or Paper.APPLICATION_CHANNELApplicationChannelSVR_STRING<10>
urldetails The address of a web page providing more information on the application.WEBSITE_ADDRESS SVR_STRING<50>
recordStatusdetails The status of the record, Active or Cancelled.RECORD_STATUSRecordStatusSVR_STRING<10>
programSelectionInddetails An application may be for several programs. This indicator is used by the Citizen Portal to determine if the citizen is presented with the option to select programs. If not, by default the citizen applies for all programs associated with the application.CURAM_INDICATOR SVR_BOOLEAN
displayOrderdetailsnoDefines where the application is placed on screen in relation to other applications that have been defined. A value of 1 means the application is displayed first (at the top of the page), the application with value 2 is displayed next and so forth.DISPLAY_ORDER SVR_INT32
submitOnCompletionInddetails This indicator determines whether the citizen can submit the application to the agency from the Citizen Portal before completing the intake script. If it is set to false, the citizen is presented with the option to send the application to the agency at any point from which they exit the intake script. Otherwise, the citizen may only submit the application to the agency on completion of the entire script.CURAM_INDICATOR SVR_BOOLEAN
submissionConfirmPageTitleIDdetailsnoUpon successful submission of an application to the agency from the Citizen Portal, the submission confirmation page is displayed. The text displayed on this page can be configured for each different type of application. This is the text used for the title of the cluster that is used to contain this text, e.g. What you Need to Bring to the Agency.LOCALIZABLE_TEXT_ID SVR_INT64
submissionConfirmPageTextIDdetailsnoUpon successful submission of an application to the agency from the Citizen Portal, the submission confirmation page is displayed. The text displayed on this page can be configured for each different type of application. This attribute refers to the text that is displayed on this page for this type of application, e.g. it may be a description of the legal obligation of the citizen and the agency, or a description of the type of documents that the citizen may be expected to provide to the agency to verify the information that they entered online.LOCALIZABLE_TEXT_ID SVR_INT64
submissionScriptIDdetailsyesEach different type of application may require.IEG_SCRIPT_ID SVR_STRING<100>
intakeSchemaNamedetails The name of the datastore schema used by the intake script to capture data.DATASTORE_SCHEMA_NAME SVR_STRING<40>
pdfFormIDdetailsyesIdentifier of the related PDF Form.INTERNAL_ID SVR_INT64
clientRegistrationdetailsyes INTAKE_CLIENT_REGISTRATION_TYPEClientRegistrationSVR_STRING<10>
icondetails  ATTACHMENT_NAME SVR_STRING<256>
Foreign Keys (9)
ChildParent
IntakeApplicationType.nameTextIDLocalizableText.localizableTextID
IntakeApplicationType.descriptionTextIDLocalizableText.localizableTextID
IntakeApplicationType.submissionConfirmPageTitleIDLocalizableText.localizableTextID
IntakeApplicationType.submissionConfirmPageTextIDLocalizableText.localizableTextID
IntakeApplicationType.pdfFormIDPDFForm.pdfFormID
ApplicationCategoryLink.intakeApplicationTypeIDIntakeApplicationType.intakeApplicationTypeID
ApplicationTypeProgramLink.intakeApplicationTypeIDIntakeApplicationType.intakeApplicationTypeID
IntakeApplication.intakeApplicationTypeIDIntakeApplicationType.intakeApplicationTypeID
WithdrawalRequestReason.intakeApplicationTypeIDIntakeApplicationType.intakeApplicationTypeID
Indices (8)
Index NameAttributes
IntApTyIdx1recordStatus, channel
IntApTyIdx2submissionScriptID, recordStatus
IND_1714039059intakeScriptID
IND__869827280pdfFormID
IND_598538388nameTextID
IND_1106244579descriptionTextID
IND_133384785submissionConfirmPageTitleID
IND__1938928022submissionConfirmPageTextID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: intakeApplicationTypeID
AUTO_ID_KEY: INTAKERAKS
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByRecordStatusreadmultiORDER_BY: displayOrder
Searches for Intake Application Types based on record status. 
searchByChannelAndRecordStatusreadmulti Search by Channel and Record Status. 
searchByIntakeScriptIDAndRecordStatusreadmulti Searches for intake application type records that are related to the Intake IEG Script. 
searchBySubmissionScriptIDAndRecordStatusreadmulti Searches for records that are linked to the submission IEG script. 
insertIntakeApplicationTypensinsert Inserts record to IntakeApplicationType entity. This method expects IntakeApplicationType ID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field IntakeApplicationType ID). It's preferred to call insertIntakeApplicationType only in scenario's where caller wants to set the value of primary key IntakeApplicationType ID) by itself. 
searchByPDFFormIDAndRecordStatusreadmulti Searches for intake application type records that are related to the Intake IEG Script. 
Related Pages (45)
Application Search (Application_search)
Add Program (CitizenWorkspaceAdmin_addProgramToIntakeApplication)
Configure Online Details (CitizenWorkspaceAdmin_configureOnlineDetails)
CitizenWorkspaceAdmin_intakeApplicationProgramMappingsDropdown
CitizenWorkspaceAdmin_listIntakeApplicationProgramMappings
CitizenWorkspaceAdmin_listIntakeApplications
Internal Applications (CitizenWorkspaceAdmin_listInternalIntakeApplications)
Online Applications (CitizenWorkspaceAdmin_listOnlineIntakeApplications)
Set Default Office (CitizenWorkspaceAdmin_modifyDefaultLocalOfficeForPDFForm)
Change Default Local Office (CitizenWorkspaceAdmin_modifyDefaultLocalOfficeForProgram)
Edit Online Application (CitizenWorkspaceAdmin_modifyIntakeApplicationTypeFromList)
Edit Online Application (CitizenWorkspaceAdmin_modifyIntakeApplicationTypeFromView)
Change Order (CitizenWorkspaceAdmin_modifyIntakeLinkDisplayOrder)
Edit Internal Application (CitizenWorkspaceAdmin_modifyInternalIntakeApplicationType)
Edit PDF Form (CitizenWorkspaceAdmin_modifyPDFFormFromList)
Edit PDF Form (CitizenWorkspaceAdmin_modifyPDFFormFromView)
Edit Program (CitizenWorkspaceAdmin_modifyProgram)
Edit Program (CitizenWorkspaceAdmin_modifyProgramFromList)
Edit Program (CitizenWorkspaceAdmin_modifyProgramFromView)
New Online Application (CitizenWorkspaceAdmin_newIntakeApplicationType)
New Internal Application (CitizenWorkspaceAdmin_newInternalIntakeApplicationType)
New PDF Form (CitizenWorkspaceAdmin_newPDFForm)
New Program (CitizenWorkspaceAdmin_newProgram)
Remove Online Application (CitizenWorkspaceAdmin_removeIntakeCategoryLink)
Add Online Application (CitizenWorkspaceAdmin_selectIntakeApplicationType)
Online Category: (CitizenWorkspaceAdmin_viewCategory)
Online Application: (CitizenWorkspaceAdmin_viewIntakeApplicationType)
CitizenWorkspaceAdmin_viewInternalIntakeApplicationType
Applications (CommonIntake_listApplicationCaseByConcernRole)
Applications (CommonIntake_listApplicationFormByConcernRole)
HCR Applications (CommonIntake_listHCRApplicationCaseByConcernRole)
HCR Applications (CommonIntake_listHCRApplicationFormByConcernRole)
New Application Form (CommonIntake_listInternalIntakeApplications)
New Application Form (CommonIntake_listInternalIntakeApplicationsForST)
New Application Form (CommonIntake_listInternalIntakePrograms)
New Application Form (CommonIntake_listInternalIntakeProgramsForST)
Applications (CommonIntake_listReferralCaseByConcernRole)
Submit Application Form (CommonIntake_submitApplicationForm)
Submit Application (HCR_finishInternalIntakeScriptRenewal)
Basic Intake Information (ISPIntakeInformation_create)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Basic Intake Information (ISPIntakeInformation_createWithIntegratedCase)
Edit Basic Intake Information (ISPIntakeInformation_modify)
Edit Basic Intake Information (ISPIntakeInformation_modifyNoCase)
View Basic Intake Information (ISPIntakeInformation_view)