Table Description

Criminal History: This evidence captures details of a Household Member's charges, convictions and parole details.

A Household Member with a criminal history may be subject to sanctions which can result in the loss of certain benefits from certain programs. Conviction types include: Intentional Program Violation, Drug Felony, Sale of Controlled Substance.

Example

A case worker records a Criminal History record for Linda Smith. Linda Smith was convicted of shoplifting and is now on parole.
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::CriminalHistory::CriminalHistory
Controlling File: Evidence\model\ServiceLayer\entity\Household\CriminalHistory\CriminalHistory_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Criminal History evidence.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The Case Participant Role ID of the Household Member for whom the Criminal History record is being recorded. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
convictionDatedetails 

The start date of the Household Member's conviction. The UI field name for this attribute is 'Conviction Date'.

CURAM_DATE SVR_DATE
convictionTypedetails 

The conviction type for the Household Member. Examples would be: Hit & Run, Drug Possession, etc. This is populated from the 'convictionType' code table. The UI field name for this attribute is 'Conviction Type'.

EVD_CONVICTION_TYPEConvictionTypeSVR_STRING<10>
plcdOnProbParolInddetails 

Indicates if the Household Member has been placed on either probation or parole. The UI field name for this attribute is 'Placement on Probation Parole'.

CURAM_INDICATOR SVR_BOOLEAN
paroleStartDatedetails 

The date from which the probation/parole started. The UI field name for this attribute is 'Parole Start Date'.

CURAM_DATE SVR_DATE
paroleEndDatedetails 

The date on which the probation/parole ended. The UI field name for this attribute is 'Parole End Date'.

CURAM_DATE SVR_DATE
paroleViolatorInddetails 

Indicates if the Household Member has violated the conditions of their parole. The UI field name for this attribute is 'Parole Violation'.

CURAM_INDICATOR SVR_BOOLEAN
fleeingFelonInddetails 

Indicates if the Household Member is a felon who is fleeing from Law Enforcement. The UI field name for this attribute is 'Fleeing Felon'.

CURAM_INDICATOR SVR_BOOLEAN
commentsdetails 

Additional details relating to the Criminal History of the Household Member. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
CriminalHistory.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__1353721690caseParticipantRoleID
Operations (5)
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 
transferEvidence    
Related Pages (13)