Table Description
ApplicationTypeProgramLink: Programs may be added to online applications to represent the programs that a citizen can apply for using the online application. This entity records the online application to which a program has been added.
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::ApplicationTypeProgramLink::ApplicationTypeProgramLink
Controlling File: WorkspaceServices\model\Packages\Entity\ApplicationTypeProgramLink\ApplicationTypeProgramLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
applicationTypeProgramLinkIDkeynoUnique identifier for this record.INTERNAL_ID SVR_INT64
intakeApplicationTypeIDdetailsnoReference to the online application.INTERNAL_ID SVR_INT64
programTypeIDdetailsnoReference to the program.INTERNAL_ID SVR_INT64
displayOrderdetails Defines the order in which the programs are displayed for the online application. A value of 1 means the program is displayed first, the program with value 2 is displayed immediately below the first and so forth.DISPLAY_ORDER SVR_INT32
recordStatusdetails The status of the record, Active or Cancelled.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
ApplicationTypeProgramLink.intakeApplicationTypeIDIntakeApplicationType.intakeApplicationTypeID
ApplicationTypeProgramLink.programTypeIDProgramType.programTypeID
AppTypeProgramEvMappingLink.appTypeProgramLinkIDApplicationTypeProgramLink.applicationTypeProgramLinkID
Indices (2)
Index NameAttributes
AppTPLIdx1intakeApplicationTypeID, recordStatus
IND__1752029650programTypeID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: applicationTypeProgramLinkID
AUTO_ID_KEY: INTAKERAKS
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByIntakeTypeAndStatusreadmultiORDER_BY: displayOrder
  
readByIntakeTypeProgramTypeAndStatusnsread   
searchByRecordStatusreadmulti Returns all active ApplicationTypeProgramLink records. 
searchByProgramTypeAndStatusreadmulti Search link records by Program Type and Record Status. 
insertApplicationTypeProgramLinknsinsert   
Related Pages (38)
Application Search (Application_search)
Add Program (CitizenWorkspaceAdmin_addProgramToIntakeApplication)
Configure Online Details (CitizenWorkspaceAdmin_configureOnlineDetails)
CitizenWorkspaceAdmin_intakeApplicationProgramMappingsDropdown
CitizenWorkspaceAdmin_listIntakeApplicationProgramMappings
Intake Application: (CitizenWorkspaceAdmin_listProgramTypesForIntake)
CitizenWorkspaceAdmin_listProgramTypesForInternalIntake
Change Default Local Office (CitizenWorkspaceAdmin_modifyDefaultLocalOfficeForProgram)
Edit Online Application (CitizenWorkspaceAdmin_modifyIntakeApplicationTypeFromList)
Edit Online Application (CitizenWorkspaceAdmin_modifyIntakeApplicationTypeFromView)
Change Order (CitizenWorkspaceAdmin_modifyIntakeLinkDisplayOrder)
Change Order (CitizenWorkspaceAdmin_modifyIntakeProgramDisplayOrder)
Edit Internal Application (CitizenWorkspaceAdmin_modifyInternalIntakeApplicationType)
Edit Program (CitizenWorkspaceAdmin_modifyProgram)
Edit Program (CitizenWorkspaceAdmin_modifyProgramFromList)
Edit Program (CitizenWorkspaceAdmin_modifyProgramFromView)
New Data Mapping (CitizenWorkspaceAdmin_newIntakeApplicationProgramMapping)
New Online Application (CitizenWorkspaceAdmin_newIntakeApplicationType)
New Internal Application (CitizenWorkspaceAdmin_newInternalIntakeApplicationType)
New Program (CitizenWorkspaceAdmin_newProgram)
Remove Online Application (CitizenWorkspaceAdmin_removeIntakeCategoryLink)
Remove Program (CitizenWorkspaceAdmin_removeProgramIntakeApplicationLink)
Add Online Application (CitizenWorkspaceAdmin_selectIntakeApplicationType)
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)
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)