Table Description

Alien: This evidence captures details of an Alien Household Member's Citizenship Details.

An Alien Household Member is an individual who is not a citizen or national of the United States. Alien types include: Refugee, Asylee, Parolee and Amerasian immigrant. The Alien must be determined an eligible Alien to receive assistance from certain programs.

Aliens who are sponsored are granted legal residence in the U.S. and are thus permitted to work. An Alien may have one or more sponsors. Alien Sponsorship evidence records the relationship between the Alien and the Sponsor.

Example

Linda Smith is a refugee from a different country, who resides in the United States. A case worker creates an Alien record for Linda Smith as she has a Citizen Status of type 'Alien'. The Alien type is set to 'Refugee' on the Alien record.
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::Evidence::Service Layer::Entity::Household::Alien::Alien
Controlling File: Evidence\model\ServiceLayer\entity\Household\Alien\Alien_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (16)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Alien.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member who is an Alien. The UI field name of this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
alienTypedetailsyes

The type of Alien the Household Member is categorized under. Examples include: Refugee, etc. This is populated from the 'alienType' code table. The UI field name of this attribute is 'Current Alien Status'.

EVD_ALIEN_TYPEAlienTypeSVR_STRING<10>
dateOfEntrydetailsyes

The date on which the Alien member entered the country. The UI field name of this attribute is 'Date of Entry'.

CURAM_DATE SVR_DATE
countryOfOrigindetailsyes

The country from which the Alien has come. This is populated from the 'CountryCode' code table. The UI field name of this attribute is 'Country/Region of Citizenship'.

COUNTRY_CODECountrySVR_STRING<10>
countryOfCShipdetails 

The country of citizenship of the Alien. This may or may not be different from country of origin. This is populated from the 'CountryCode' code table. For example, the Alien is a person of Indian origin, who is a Turkish citizen. In this case the country/region of citizenship will be recorded as 'Turkey'. The UI field name of this attribute is 'Country/Region of Citizenship'.

COUNTRY_CODECountrySVR_STRING<10>
countryOfBirthdetails 

The Alien's country of birth. This is populated from the 'countryCode' code table. This may or may not be different from the country of origin and/or country of citizenship. The UI field name of this attribute is 'Country/Region of Birth'.

COUNTRY_CODECountrySVR_STRING<10>
alienRegNumberdetails 

The Household Member's Alien registration number. The UI field name of this attribute is 'Registration Number'.

EVD_ALIEN_REGISTRATION_NUMBER SVR_STRING<30>
insSectiondetails 

The INS (Immigration and Naturalization Services) Section of the Household Member. The UI field name of this attribute is 'INS Section'.

EVD_INS_SECTION SVR_STRING<40>
dateLastLeftCountrydetails 

The date on which the Alien Household Member last left the country. The UI field name of this attribute is 'Date Last Left Country'.

CURAM_DATE SVR_DATE
dateStatusGranteddetails 

The date that the Household Member's Alien status was granted. The UI field name of this attribute is 'Date Alien Status Granted'.

CURAM_DATE SVR_DATE
indigentAlienInddetails 

Indicates if the Alien is an Indigent Alien i.e. the State agency has determined they are unable to obtain food and shelter. The UI field name of this attribute is 'Indigent Alien'.

CURAM_INDICATOR SVR_BOOLEAN
commentsdetails 

Additional details relating to the Alien. The UI field name of this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
continuouslyResidingInddetails 

Indicator to show if the Alien has been continuously residing in the country since date of entry. The UI field name of this attribute is 'Continuously Residing in Country since Date of Entry'.

CURAM_INDICATOR SVR_BOOLEAN
alienStatusOnEntrydetails 

The type of Alien the Household Member was categorized under, when he/she first came into the State e.g. Refugee. This is populated from the 'alienType' code table. The UI field name of this attribute is 'Alien Status on Entry'.

EVD_ALIEN_TYPEAlienTypeSVR_STRING<10>
endDatedetails 

The end date of the Alien type. The UI field name of this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
Alien.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND_2136971324caseParticipantRoleID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
Related Pages (14)