Table Description
Foreign Residency: A period of time when a person or prospect person resided in a country other than where the organization is located.

The availability of data on foreign residency could be of particular interest where reciprocal arrangements exist between two national organizations.

Example

John Smith had always resided in England. From 1/1/2001 to 1/1/2002, he resided in France on a secondment for his job.

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::Core::Reference Model::Concern::Entity Objects::ForeignResidency::ForeignResidency
Controlling File: core\model\Packages\Concern\ForeignResidency_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernRoleIDdetailsnoUnique reference number assigned by the system to a Concern Role record.CONCERN_ROLE_ID SVR_INT64
startDatedetails Date Foreign Residency is effective from.CURAM_DATE SVR_DATE
endDatedetails Date Foreign Residency is effective to.CURAM_DATE SVR_DATE
reasonCodedetails Code to denote the reason for the Concern's period of Foreign Residency.FOREIGN_RESIDENCY_REASON_CODEForeignResidencyReasonSVR_STRING<10>
countryCodedetails Code to denote in which country the Concern spent the period of Foreign Residency.COUNTRY_CODECountrySVR_STRING<10>
statusCodedetails Code table code describing the record status of the foreign residency record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
foreignResidencyIDkeynoUnique reference number assigned by the systemFOREIGN_RESIDENCY_ID SVR_INT64
commentsdetails Free text registered by the user.COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
ForeignResidency.concernRoleIDConcernRole.concernRoleID
Indices (1)
Index NameAttributes
ForeignResidencyInconcernRoleID, countryCode, startDate, endDate, foreignResidencyID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByConcernRolensreadmulti Retrieves a list of foreign residency details for the specified person. 
searchForOverlapnsmulti Search for foreign residencies for the specified person which overlap in time with the specified foreign residency.SQL
searchResidenceByDatensmulti Search foreign residence by dateSQL
dummy  Non-stereotyped function to force the factory class to extend from the impl class instead of the base class. 
searchByConcernRoleIDAndStatusnsreadmulti Search all foreign residency records using the concern role id and status 
Related Pages (83)
Register Prospect (AddProspectPerson_registerForPDCWizard)
Register Prospect (AddProspectPerson_registerWizard)
Add Client (Application_registerPersonAndAddAsClient)
Register Person (Application_registerProspectPersonAsPerson)
Register Person (BenefitSample_registerPerson)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCase)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCasePDC)
Register Prospect Person and Create a Case (Case_registerProspectPersonAndCreateIntegratedCase)
Register Prospect Person and Create an Integrated Case (Case_registerProspectPersonAndCreateIntegratedCasePDC)
Reception Contact (ClientContactWizard_issueDetails)
Add Client (CommonIntake_addClient)
Register Client (CommonIntake_registerClient)
Create Client Contact (Contact_register)
Create Client Contact (Contact_registerFromPersonSearch)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
Add Member (HCRAddMemberWizard_summary)
Register Person (ICSample_registerPerson)
Register Person (IncomeScreening_registerHouseholdMember)
Register Prospect Person (IncomeScreening_registerHouseholdProspect)
Register Person (IncomeScreening_registerPerson)
Register Prospect Person (IncomeScreening_registerProspect)
Register Person (IncomeSupportScreening_registerPerson)
Register Person (IncomeSupportScreening_registerPersonForHouseholdEvidence)
Register Prospect (IncomeSupportScreening_registerProspect)
Register Prospect (IncomeSupportScreening_registerProspectForHouseholdEvidence)
Register Prospect Person as Person (Individual_registerProspectAsPerson)
Related Persons (Intake_listRelatedPerson)
Client Merge Wizard (Intake_MergeProspecrToPersonWizard)
Register Person (Intake_personFullRegistration)
Person Search Results (Intake_personSearchResult)
Register Prospect Person as Person (Intake_registerProspectAsPerson)
Register Client for Intake (Intake_registerProspectPerson)
Register Prospect Person as Person (Intake_registerProspectPersonAsPerson)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Register Person (IntakeShortCuts_registerPerson)
Add Prospect Person (IntakeShortCuts_registerProspectPerson)
Register Person (InvestigationSample_registerPerson)
Register Person (InvestigationSample_registerPersonForPDC)
Add Household Member (ISAddMemberWizard_summaryDetails)
Register Person (ISP_registerPerson)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)
Register Person (LiabilitySample_registerPerson)
Merge Duplicate (Participant_mergeForeignResidencies)
Client Merge Wizard (Participant_mergeWizard)
Client Merge Wizard (Participant_mergeWizardForViewDuplicate)
Delete Foreign Residency (Person_cancelForeignResidency)
New Foreign Residency (Person_createForeignResidency)
Foreign Residencies (Person_listForeignResidency)
Foreign Residency (Person_listForeignResidencyHistory)
Edit Foreign Residency (Person_modifyForeignResidency)
Edit Foreign Residency (Person_modifyForeignResidencyFromList)
Edit Foreign Residency (Person_modifyForeignResidencyFromView)
Register Person (Person_register)
Register Person (Person_registerForPDC)
Delete Foreign Residency (Prospect_cancelForeignResidency)
New Foreign Residency (Prospect_createForeignResidency)
Foreign Residencies (Prospect_listForeignResidency)
Edit Foreign Residency (Prospect_modifyForeignResidencyFromList)
Edit Foreign Residency (Prospect_modifyForeignResidencyFromView)
Register Prospect (Prospect_register)
Confirm Registration (Prospect_registerPersonFromProspect)
View Foreign Residency (Prospect_viewForeignResidency)
Delete Foreign Residency (ProspectPerson_cancelForeignResidency)
New Foreign Residency (ProspectPerson_createForeignResidency)
Foreign Residencies (ProspectPerson_listForeignResidency)
Edit Foreign Residency (ProspectPerson_modifyForeignResidencyFromList)
Edit Foreign Residency (ProspectPerson_modifyForeignResidencyFromView)
Register Prospect Person (ProspectPerson_register)
Register Prospect Person as Person (ProspectPerson_registerAsPerson)
Register Prospect Person as Person (ProspectPerson_registerAsPersonForPDCWizard)
Register Prospect Person as Person (ProspectPerson_registerAsPersonWizard)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
Step 5: Register Person (ProviderManagement_registerPersonAsProvider)
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
Quick Registration (Quick_register)
Register Person (RegisterPerson_registerForPDCWizard)
Register Person (RegisterPerson_registerWizard)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)