Table Description
Citizenship: A person's or prospect person's citizenship of a country.

A person may hold many citizenships over their lifetime.

Example

John Smith was born in France and holds French citizenship. John emigrates to Australia and is granted Australian citizenship. John therefore holds two active citizenships.

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::Citizenship::Citizenship
Controlling File: core\model\Packages\Concern\Citizenship_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
reasonCodedetails Code value to indicate the reason for CitizenshipCITIZENSHIP_REASON_CODECitizenshipReasonSVR_STRING<10>
countryCodedetails Code value to indicate the country of citizenshipCOUNTRY_CODECountrySVR_STRING<10>
fromDatedetails Date citizenship is effective from.CURAM_DATE SVR_DATE
toDatedetails Date citizenship is effective to.CURAM_DATE SVR_DATE
statusCodedetails Code value to indicate the status of the Citizenship record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
citizenshipIDkeynoUnique reference number assigned by the systemCITIZENSHIP_ID SVR_INT64
commentsdetails Free text registered by the user.COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
Citizenship.concernRoleIDConcernRole.concernRoleID
Indices (1)
Index NameAttributes
CitizenshipIndexconcernRoleID, countryCode, fromDate, toDate, citizenshipID, statusCode
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByConcernRolensreadmulti Retrieves a list of citizenship details for the specified person. 
searchForOverlapnsmulti Searches for citizenships for the specified concern role that overlap in time with the specified citizenship.SQL
dummy  Non-stereotyped function to force the factory class to extend from the impl class instead of the base class. 
searchByConcernRoleIDAndStatusnsreadmulti Retrieves a list of citizenship details for the specified person with a specific 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_mergeCitizenships)
Client Merge Wizard (Participant_mergeWizard)
Client Merge Wizard (Participant_mergeWizardForViewDuplicate)
Delete Citizenship (Person_cancelCitizenship)
New Citizenship (Person_createCitizenship)
Citizenships (Person_listCitizenship)
Citizenship (Person_listCitizenshipHistory)
Edit Citizenship (Person_modifyCitizenship)
Edit Citizenship (Person_modifyCitizenshipFromList)
Edit Citizenship (Person_modifyCitizenshipFromView)
Register Person (Person_register)
Register Person (Person_registerForPDC)
Delete Citizenship (Prospect_cancelCitizenship)
New Citizenship (Prospect_createCitizenship)
Citizenships (Prospect_listCitizenship)
Edit Citizenship (Prospect_modifyCitizenshipFromList)
Edit Citizenship (Prospect_modifyCitizenshipFromView)
Register Prospect (Prospect_register)
Confirm Registration (Prospect_registerPersonFromProspect)
View Citizenship (Prospect_viewCitizenship)
Delete Citizenship (ProspectPerson_cancelCitizenship)
New Citizenship (ProspectPerson_createCitizenship)
Citizenships (ProspectPerson_listCitizenship)
Edit Citizenship (ProspectPerson_modifyCitizenshipFromList)
Edit Citizenship (ProspectPerson_modifyCitizenshipFromView)
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)