Table Description

Self Employment: A participant who is employed by one's own business, trade, or profession, rather than by an employer. Self Employment can only be recorded for a participant who has an employment record.

Example

Linda Smith is currently self employed full time on her own. She has her own business which produces home made food to sell in the local markets. A case worker first creates an Employment record with Linda Smith as the employer, and then creates a Self Employment record associating Linda Smith as a full time employee of her business.

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::Income::SelfEmployment::SelfEmployment
Controlling File: Evidence\model\ServiceLayer\entity\Income\SelfEmployment\SelfEmployment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Self Employment. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Participant who is self employed. The UI field name for this attribute is 'Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
empCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the Self Employment Business. The UI field name for this attribute is 'Employer'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
employmentIDdetailsyes

The system generated unique identifier for the linked employment. There is no UI field for this attribute.

EMPLOYMENT_ID SVR_INT64
selfEmploymentStatusdetails 

The self employment status. Examples include: Full-Time, Part-Time, etc. This is populated from the 'SelfEmploymentStatus' code table. The UI field name for this attribute is 'Self Employment Status'.

EVD_SELF_EMPLOYMENT_STATUSSelfEmploymentStatusSVR_STRING<10>
ownershipTypedetails 

The type of ownership of the Self Employment. Examples include: Individual, Partnership, etc. This is populated from the 'SEOwnershipType' code table. The UI field name for this attribute is 'Ownership Type'.

EVD_SE_OWNERSHIP_TYPESEOwnershipTypeSVR_STRING<10>
incorporatedInddetails 

Indicates if the Self Employment business is incorporated. The UI field name for this attribute is 'Incorporated'.

CURAM_INDICATOR SVR_BOOLEAN
commentsdetails 

Additional details related to the Self Employment. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
Foreign Keys (3)
ChildParent
SelfEmployment.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
SelfEmployment.empCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
SelfEmployment.employmentIDEmployment.employmentID
Indices (3)
Index NameAttributes
IND__2067154099caseParticipantRoleID
IND__206214701empCaseParticipantRoleID
IND__1991286162employmentID
Operations (7)
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 
readSelfEmploymentOwnershipDetailsns Reads ownership details for a Self Employment evidenceSQL
searchSelfEmploymentIDByParticipantRoleIDAndCaseIDnsmulti search by ParticipantRoleIDSQL
transferEvidence    
Related Pages (38)
New Self Employment Evidence (EVD_addToCaseSelfEmploymentEvidence_wzSelAllCreEmpOnly)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCrePAR)
New Transfer To Trust Evidence (EVD_addToCaseTransferToTrustEvidence_wzSelAllCrePRE)
New Anticipated Income Evidence (EVD_createAnticipatedIncomeEvidence_sa)
New Anticipated Income Evidence (EVD_createAnticipatedIncomeEvidence_wzSelAllCre)
New Business Asset Evidence (EVD_createBusinessAssetEvidence_sa)
New Business Asset Evidence (EVD_createBusinessAssetEvidence_wzSelAllCre)
New Gross Receipt Evidence (EVD_createGrossReceiptEvidence_sa)
New Gross Receipt Evidence (EVD_createGrossReceiptEvidence_wzSelAllCre)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
New Ownership Evidence (EVD_createOwnershipEvidence_sa)
New Ownership Evidence (EVD_createOwnershipEvidence_wzSelAllCre)
New Self Employment Evidence (EVD_createSelfEmploymentEvidence_wzSelAllCreEmpOnly)
New Transfer Reversal Evidence (EVD_createTransferReversalEvidence_sa)
New Transfer Reversal Evidence (EVD_createTransferReversalEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCre)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCrePAR)
New Transfer To Trust Evidence (EVD_createTransferToTrustEvidence_wzSelAllCrePRE)
Edit Self Employment Evidence (EVD_incomingModifySelfEmploymentEvidence)
Edit Transfer To Trust Evidence (EVD_incomingModifyTransferToTrustEvidence)
Assign Income from Gross Receipt To Income Trust (EVD_listGrossReceiptEvidenceForAssignedIncomeEvidence)
Edit Anticipated Income Evidence (EVD_modifyAnticipatedIncomeEvidence)
Edit Business Asset Evidence (EVD_modifyBusinessAssetEvidence)
Edit Gross Receipt Evidence (EVD_modifyGrossReceiptEvidence)
Edit Household Member Evidence (EVD_modifyHouseholdMemberEvidence)
Edit Ownership Evidence (EVD_modifyOwnershipEvidence)
Edit Self Employment Evidence (EVD_modifySelfEmploymentEvidence)
Edit Transfer To Trust Evidence (EVD_modifyTransferToTrustEvidence)
Related Persons (Intake_listRelatedPerson)
Person Search Results (Intake_personSearchResult)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Add Household Member (ISAddMemberWizard_summaryDetails)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)