Table Description

Authorized Representative: This evidence captures details of an individual who acts on behalf of a household.

An adult designated in writing by a household to complete the household's application form correctly and represent the household when applying for the Food Assistance program. The representative is an adult who is sufficiently knowledgeable about the household's circumstances, knows the people in the household and about all the income and expenses of the household. There can only be one Authorized Representative per household.
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::AuthorizedRepresentative::AuthorizedRep
Controlling File: Evidence\model\ServiceLayer\entity\Household\AuthorizedRepresentative\AuthorizedRepresentative_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Authorized Representative. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The name (or rather, the Case Participant Role ID) of the Authorized Representative. The UI field name for this attribute is 'Representative Participants'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
authorRepReasondetails 

The reason the individual is an Authorized Representative i.e. applying for Food Stamps, etc. The UI field name for this attribute is 'Reason for Authorization'.

EVD_AUTHORIZED_REP_REASONAuthorizedRepReasonSVR_STRING<10>
employeeOfDivInddetails 

Indicates if the Authorized Representative is an employee of the agency. The UI field name for this attribute is 'Employee of Division'.

CURAM_INDICATOR SVR_BOOLEAN
mealsProviderForHLessdetails 

Indicates if the Authorized Representative is a meal provider for the homeless. The UI field name for this attribute is 'Meals Provided for Homeless'.

CURAM_INDICATOR SVR_BOOLEAN
authRetailerInddetails 

Indicates if the Authorized Representative is a retailer who is authorized to accept Food Assistance. The UI field name for this attribute is 'Authorized Retailer'.

CURAM_INDICATOR SVR_BOOLEAN
disqIPVInddetails 

Indicates if the Authorized Representative has been disqualified for Intentional Program Violation. There is no UI field for this attribute.

CURAM_INDICATOR SVR_BOOLEAN
commentsdetails 

Details relating to the Authorized Representative. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
authorizedRepStartDatedetails 

The date from which the Authorized Representative was entrusted with the authorization. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
authorizedRepEndDatedetails 

The date until which the Authorized Representative was authorized to act on behalf of the household. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
Foreign Keys (1)
ChildParent
AuthorizedRep.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
IND__1390046153caseParticipantRoleID
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 
readCaseParticipantsByEvidenceIDnsread Returns all related caseParticipantRoleID's for a specified Authorized Representative ID. 
readAuthorizedRepAndParticipantRoleDetailsns Method for reading authorized representative evidence and the participantRoleID of the authorized representative.SQL
transferEvidence    
Related Pages (13)