Table Description

nbsp;Advisement

: nbsp; Outcomes worker can advise Eligibility worker for some tasks. >
Model Details
Location in Model: Logical View::MetaModel::Curam::AssessmentTracking::Service Layer::Advisement::Entity::Advisement
Controlling File: AssessmentTracking\model\Packages\Service Layer\Advisement\Entity\ModelFragment_1.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
advisementIdkeyno ADVISEMENT_ID SVR_INT64
advisementSubjectdetails  ADVISE SVR_STRING<1000>
advisementDatedetails  CURAM_DATE SVR_DATE
descriptiondetails  OUTCOME_PLAN_RICH_TEXT_SMALL SVR_STRING<2000>
statusdetails  ADVISEMENT_STATUSAdvisementStatusSVR_STRING<10>
advisementTypedetails  ADVISEMENT_TYPEAdvisementTypeSVR_STRING<10>
caseParticipantRoleIddetails  CASE_PARTICIPANT_ROLE_ID SVR_INT64
createdBydetails  USER_NAME SVR_STRING<64>
outcomePlanIDdetails  CASE_ID SVR_INT64
actionTakenBydetails  USER_NAME SVR_STRING<64>
rejectionReasondetails  REJECTION_REASONRejectingAdvisementSVR_STRING<10>
actionDatedetails  CURAM_DATETIME SVR_DATETIME
actionCommentsdetails  COMMENTS SVR_STRING<300>
Indices (1)
Index NameAttributes
IND_564658141outcomePlanID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: advisementId
Standard Operation 
readAllByOutcomePlanIdreadmultiORDER_BY: advisementDate
  
readread Standard Operation 
modifyAdvisementStatusnsmodifyOPTIMISTIC_LOCKING: yes
  
Related Pages (7)