Table Description
External Party Office Member: The individuals associated with an external party office who can become external users of the system. External party office members may be already registered with the agency.

Example

The office member entity captures information relating to the office member, for example their profile and the date they were added to the office.

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::Core::Reference Model::Service Layer::ExternalPartyOfficeMember::Entity::ExternalPartyOfficeMember
Controlling File: core\model\Packages\Reference Model\Service Layer\ExternalPartyOfficeMember\Entity\ExternalPartyOfficeMember_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
officeMemberIDkeynoUnique reference number assigned to the external party office member.INTERNAL_ID SVR_INT64
concernRoleIDdetailsnoUnique reference number assigned by the system to a Concern Role record.CONCERN_ROLE_ID SVR_INT64
profiledetailsnoThe profile of the office member relates to the role the individual can play within the external party.EXTERNAL_PARTY_OFFICE_MEMBER_PROFILEOfficeMemberProfileSVR_STRING<10>
externalPartyOfficeIDdetailsnoUnique reference number assigned by the system to an external party office record.INTERNAL_ID SVR_INT64
recordStatusdetailsnoCode table code describing the record status of the external party office member record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails User comments for the external party office member.COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
ExternalPartyOfficeMember.concernRoleIDConcernRole.concernRoleID
ExternalPartyOfficeMember.externalPartyOfficeIDExternalPartyOffice.externalPartyOfficeID
Indices (2)
Index NameAttributes
ExternalPartyOfficeIDIndexexternalPartyOfficeID
EPOMemConRoleIDIdxconcernRoleID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: officeMemberID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
cancelnsmodifyPRE_DATA_ACCESS: yes
This method changes the external party office member status to 'cancelled'. 
searchByExternalPartyOfficeIDreadmulti This method searches for all members who belong to the specified external party office. 
searchForDuplicateOfficeMembernsmulti This method searches for any external party office members who belong to the same external party office, and have the same profile and name.SQL
readByConcernRoleIDnsread This method reads the external party office member details using their concern role ID. 
Related Pages (40)
Confirm Location Hearing (Appeal_confirmExternalLocationHearingIC)
Confirm Location Hearing (Appeal_confirmIssueExternalLocationHearingIC)
Confirm Reschedule External Location Hearing (Appeal_ConfirmReScheduleExternalLocationHearingIC)
Delete External Party Office (ExternalParty_cancelExternalPartyOffice)
Delete Office Member (ExternalParty_cancelOfficeMember)
New Office (ExternalParty_createExternalPartyOffice)
New Office Address (ExternalParty_createOfficeAddress)
New Office Member (ExternalParty_createOfficeMember)
New Office Phone Number (ExternalParty_createOfficePhoneNumber)
Office Members (ExternalParty_listOfficeMember)
Office Member Email Addresses (ExternalParty_listOfficeMemberEmailAddress)
Edit Office Address (ExternalParty_modifyOfficeAddress)
Edit Office Address (ExternalParty_modifyOfficeAddressFromList)
Edit Office Address (ExternalParty_modifyOfficeAddressFromView)
Edit External Party Office (ExternalParty_modifyOfficeFromList)
Edit External Party Office (ExternalParty_modifyOfficeFromView)
Edit Office Member (ExternalParty_modifyOfficeMemberFromList)
Edit Office Member (ExternalParty_modifyOfficeMemberFromView)
Edit Office Phone Number (ExternalParty_modifyOfficePhoneNumberFromList)
Edit Office Phone Number (ExternalParty_modifyOfficePhoneNumberFromView)
View Office Member (ExternalParty_viewOfficeMember)
View Office Member Email Address (ExternalParty_viewOfficeMemberEmailAddress)
Add Legal Action Participants (LegalAction_addParticipant)
Legal Actions (LegalAction_listHearingAssociatedLA)
Legal Actions (LegalAction_listOrderAssociatedLA)
Legal Actions (LegalAction_listPetitionAssociatedLA)
Edit Hearing (LegalAction_modifyHearing)
Edit Legal Order (LegalAction_modifyOrder)
Edit Petition (LegalAction_modifyPetition)
Schedule Hearing (LegalAction_scheduleHearing)
External Party Office Search (LegalAction_searchExternalOfficePopup)
View Hearing (LegalAction_viewHearing)
LegalAction_viewHearingTabDetails
View Legal Action (LegalAction_viewLegalAction)
LegalAction_viewOrder
View Legal Action (LegalAction_viewOrderConditions)
View Requirements and Conditions (LegalAction_viewOrderRequirements)
LegalAction_viewPetition
Edit Representative (Representative_modifyRepresentative)
Edit Representative (Representative_modifyRepresentativeDetails)