Table Description
External Party Office: An office(s) or location where the external party carries out its services.

Example

The Sisters of Charity is a community based organization (CBO). They have two locations where they carry out their services, one is a shelter they provide to the homeless and another is a center for the elderly.

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::ExternalPartyOffice::Entity::ExternalPartyOffice
Controlling File: core\model\Packages\Reference Model\Service Layer\ExternalPartyOffice\Entity\ExternalPartyOffice_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
externalPartyOfficeIDkeynoUnique reference number assigned by the system.INTERNAL_ID SVR_INT64
concernRoleIDdetailsnoUnique reference number assigned by the system to a Concern Role record.CONCERN_ROLE_ID SVR_INT64
namedetailsnoThe name of the external party office or location.EXTERNAL_PARTY_OFFICE_NAME SVR_STRING<131>
typedetailsyesThe type of external party office, for example, Shelter or Benefits Counselor.EXTERNAL_PARTY_OFFICE_TYPEOfficeTypeSVR_STRING<10>
startDatedetailsnoThe date from which the office is established as a location at which the external party provides services.CURAM_DATE SVR_DATE
endDatedetails The last date on which the office is a location for the external party.CURAM_DATE SVR_DATE
serviceOffereddetailsyesThe type of service offered by the external party office.EXTERNAL_PARTY_OFFICE_SERVICEOfficeServiceSVR_STRING<10>
primaryAddressIDdetails The address ID for the primary address of the external party office.ADDRESS_ID SVR_INT64
primaryPhoneNumberIDdetails The phone number ID for the primary phone number of the external party office.PHONE_NUMBER_ID SVR_INT64
recordStatusdetailsnoCode table code describing the record status of the external party office record.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (4)
ChildParent
ExternalPartyOffice.concernRoleIDExternalParty.concernRoleID
ExternalPartyOfficeAddress.externalPartyOfficeIDExternalPartyOffice.externalPartyOfficeID
ExternalPartyOfficeMember.externalPartyOfficeIDExternalPartyOffice.externalPartyOfficeID
ExternalPartyOfficePhoneNumber.externalPartyOfficeIDExternalPartyOffice.externalPartyOfficeID
Indices (1)
Index NameAttributes
IND_92827881concernRoleID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: externalPartyOfficeID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
searchByExternalPartyreadmultiORDER_BY: name
This method returns a list of external party office details associated with the given external party. 
searchByOfficeNameAddressRefNumberTypesnsmulti Search for external party records based on given criteria.SQL
cancelnsmodifyPRE_DATA_ACCESS: yes
This method changes the external party office status to 'cancelled' 
Related Pages (77)
Add Resolution to Appealed Items (Appeal_addResolutionToAppealedItems)
Confirm Location Hearing (Appeal_confirmExternalLocationHearingIC)
Confirm Location Hearing (Appeal_confirmIssueExternalLocationHearingIC)
Confirm Reschedule External Location Hearing (Appeal_ConfirmReScheduleExternalLocationHearingIC)
Home (Appeal_hearingCaseHearingHome)
Hearing Home (Appeal_hearingCaseHearingHomeDetails)
Home (Appeal_hearingCaseHearingHomeForIC)
Home (Appeal_hearingCaseHearingHomeViewOnly)
Items Under Appeal (Appeal_listItemsUnderAppeal)
Appeal Objects (Appeal_listObjectsByAppeal)
Manage Decision (Appeal_manageHearingCaseDecisionForIC)
Decisions (Appeal_manageHearingReviewDecisionForIC)
Manage Decision (Appeal_manageJudicialReviewDecisionForIC)
Appeals (Application_listAppeals)
Items Under Appeal (Application_listItemsUnderAppeal)
ApplicationContextPanel
CAProductHomeDetails
CGISSApplicationContextPanel
CGISSApplicationContextPanel1
CHIPProductHomeDetails
CREOLECAProductHomeDetails
CREOLECHIPProductHomeDetails
CREOLEFAProductHomeDetails
CREOLEMAProductHomeDetails
Delete External Party Office (ExternalParty_cancelExternalPartyOffice)
Delete Office Address (ExternalParty_cancelOfficeAddress)
Delete Office Phone Number (ExternalParty_cancelOfficePhoneNumber)
New Office (ExternalParty_createExternalPartyOffice)
New Office Address (ExternalParty_createOfficeAddress)
New Office Member (ExternalParty_createOfficeMember)
New Office Phone Number (ExternalParty_createOfficePhoneNumber)
Offices (ExternalParty_listExternalPartyOffice)
Office Addresses (ExternalParty_listOfficeAddress)
Office Members (ExternalParty_listOfficeMember)
Office Member Email Addresses (ExternalParty_listOfficeMemberEmailAddress)
Office Phone Numbers (ExternalParty_listOfficePhoneNumber)
Edit External Party (ExternalParty_modifyExternalParty)
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 External Party Office (ExternalParty_viewExternalPartyOffice)
View Office Address (ExternalParty_viewOfficeAddress)
View Office Member (ExternalParty_viewOfficeMember)
View Office Member Email Address (ExternalParty_viewOfficeMemberEmailAddress)
View Office Phone Number (ExternalParty_viewOfficePhoneNumber)
ExternalPartyOffice_search
FAProductHomeDetails
Appeals (ISP_listAppeals)
ISPCaseHomeDetails
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
LIFCProductHomeDetails
LTCProductHomeDetails
ProductHomeDetails
RefugeeProductHomeDetails
SpendDownProductHomeDetails
TBBCCProductHomeDetails