Table Description
PDM Notices: This table is used to store a link to the generated notice that was sent to the Citizen during a PDM or Annual Renewal process.
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::HCR::Periodic Data Matching::Entity::PDMNotices
Controlling File: HCR\model\PeriodicDataMatching\Entity\PDMEntity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
pdmNoticeIDkeynoThe primary key.INTERNAL_ID SVR_INT64
noticeTypedetailsnoDifferentiate between notice types. Values are either PDM or Annual Renewal.PDM_NOTICE_TYPEPDMNoticeTypeSVR_STRING<10>
pdmRunCaseControlIDdetailsnoThe foreign key to the case process control table.INTERNAL_ID SVR_INT64
noticeIDdetailsnoThe foreign key to the attachment table where the notice is stored.INTERNAL_ID SVR_INT64
generatedDateTimedetailsnoThe generated date and time of the notice.CURAM_DATETIME SVR_DATETIME
Foreign Keys (2)
ChildParent
PDMNotices.noticeIDConcernRoleCommunication.communicationID
PDMNotices.pdmRunCaseControlIDPDMRunCaseControl.pdmRunCaseControlID
Indices (2)
Index NameAttributes
IND__74071559pdmRunCaseControlID
IND_1958075408noticeID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
readread Standard read method. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard modify method. 
insertinsertAUTO_ID: pdmNoticeID
Standard insert method. 
searchByCaseControlIDreadmulti Return the notice records associated with the specified case control ID. 
Related Pages (0)