Table Description

Alien Sponsorship: This evidence stores a link between an Alien Household Member and their Sponsor.

This link provides the mechanism to associate Aliens with their Sponsors.

An Alien can have multiple Sponsors and a Sponsor can support multiple Aliens in the household. An Alien Sponsorship record is created for each relationship.
Model Details
Location in Model: Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Household::AlienSponsorship::AlienSponsorship
Controlling File: Evidence\model\ServiceLayer\entity\Household\AlienSponsorship\AlienSponsorship_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Alien Sponsorship. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
sponsorStartDatedetailsyes

The date on which the Alien Sponsor began sponsoring the Alien. The UI field name of this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
sponsorEndDatedetails 

The date on which the Alien Sponsor ceased sponsoring the Alien. The UI field name of this attribute is 'End Date'.

CURAM_DATE SVR_DATE
affidavitOfSupportInddetails 

Indicates if the Alien Sponsor has signed an affidavit of support. The UI field name of this attribute is 'Affidavit of Support'.

CURAM_INDICATOR SVR_BOOLEAN
sponsorEndReasondetails 

Reason the sponsorship has come to an end. The UI field name of this attribute is 'End Reason'.

EVD_SPONSORSHIP_END_REASONSponsorshipEndReasonSVR_STRING<10>
commentsdetails 

Details relating to the Alien Sponsorship. The UI field name of this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
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 (1)