Table Description

Alien Sponsor: This evidence captures details of a person or organization who has agreed to provide the financial support necessary to maintain a sponsored alien.

An Alien Sponsor signs an affidavit of support on behalf of an alien as a condition of the alien's entry into the country. An Alien Sponsor may be a Household Member, an individual who is not a Household Member but is a registered person, or an unregistered individual who is recorded on the system as a representative. An Alien Sponsor may also have a participant type of employer, product provider or service supplier.

Example

A case worker creates an Alien Sponsor record for a sponsor who has agreed to provide the financial support to Linda Smith. Linda is a Household Member that has a recorded citizen status of 'Alien'.
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::AlienSponsor::AlienSponsor
Controlling File: Evidence\model\ServiceLayer\entity\Household\AlienSponsor\AlienSponsor_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

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

EVIDENCE_ID SVR_INT64
alienSponsorTypedetailsyes

The type of Alien Sponsor i.e. 'individual' or 'organization'. The UI field name of this attribute is 'Sponsor Type'.

EVD_ALIEN_SPONSOR_TYPEAlienSponsorTypeSVR_STRING<10>
caseParticipantRoleIDdetailsno

The name (or rather, the Case Participant Role ID) of the Alien Sponsor. The UI field name of this attribute is 'Sponsor Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
commentsdetails 

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

COMMENTS SVR_STRING<300>
noOfDependentsdetails 

The number of dependent children the Alien Sponsor has. The UI field name of this attribute is 'Number of Dependents'.

EVD_NUMBER_OF_DEPENDENTS SVR_INT16
residesWithSponsorInddetails 

Indicates if the Alien Sponsor's spouse resides with the sponsor. The UI field name of this attribute is 'Spouse Resides with Sponsor'.

CURAM_INDICATOR SVR_BOOLEAN
spsCaseParticipantRoleIDdetails 

The name (or rather, the Case Participant Role ID) of the Alien Sponsor's spouse. The UI field name of this attribute is 'Spouse Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
startDatedetails 

The date from which the alien was sponsored by the Alien Sponsor. The UI field name of this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
endDatedetails 

The last date until which the alien was sponsored by the sponsor. The UI field name of this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
AlienSponsor.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__1130521848caseParticipantRoleID
Operations (6)
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 
readSponsorTypeByCaseParticipantRolens Reads the Alien Sponsor Type for an Alien Sponsor based on the Alien Sponsor's Case Participant Role ID.SQL
readAlienSponsorCaseParticipantns Reads an alien sponsor record returning the participant name and the caseParticipantRoleID.SQL
Related Pages (4)