Table Description
Organization Unit Resource: A resource used by an organization unit to perform work.
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::OrganisationUnitResource::Entity::OrganisationUnitResource::OrganisationUnitResource
Controlling File: core\model\Packages\Reference Model\Service Layer\OrganisationUnitResource\Entity\OrganisationUnitResource\OrganisationUnitResource_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
VALIDATION_EXIT_POINTno
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
organisationUnitResourceIDkeynoUnique reference number assigned by the system.ORGANISATION_UNIT_RESOURCE_ID SVR_INT64
organisationUnitIDdetailsnoUnique reference number assigned by the system to an Organization Unit record.ORGANISATION_UNIT_ID SVR_INT64
resourceIDdetailsnoUnique reference number assigned by the system to a Organization Unit Resource Record.RESOURCE_ID SVR_INT64
recordStatusdetailsnoAttribute indicating status of record.ORGANISATION_UNIT_RESOURCE_RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
OrganisationUnitResource.organisationUnitIDOrganisationUnit.organisationUnitID
OrganisationUnitResource.resourceIDResources.resourceID
Indices (2)
Index NameAttributes
OrgUnitIdxorganisationUnitID
OrgUnitResStatusIdxresourceID, recordStatus
Operations (15)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: organisationUnitResourceID
AUTO_ID_KEY: ORGNSTREBO
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
countByOrganisationUnitAndResourcens Counts organization unit resource records by organization unit and resource id and resource status..SQL
searchByOrganisationUnitnsmulti Method to return all organization unit resources for specified organization unit.SQL
searchByOrganisationUnitAndResourceTypensmulti Method to return all organization unit resources for specified organization unit and resource type code.SQL
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Method to cancel organization unit resource. 
validateInsert  Method to validate organization unit resource details before creating new organization unit resource. 
validateCancel  Method to validate organization unit resource details before canceling organization unit resource record. 
validate  Method to validate general organization unit resource details. 
countByResourceIDns Returns any active OrganisationUnitResources for a Resource.SQL
searchByOrganisationUnitAndResourceIDns Returns organizationUnitResourceID by organization unit and resource id and resource statusSQL
searchByresourceIDAndStatusnsreadmulti Returns organization unit resource records by resource id and OrganisationUnitResource status.. 
searchByOrganisationUnitKeyreadmulti Reads all the record for an organisation unit id. 
insertOrganisationUnitResourceinsertPRE_DATA_ACCESS: no
Inserts record to organisation unit resource entity. This method expects organisation unit resource ID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field (organisation unit resource ID). It's preferred to call insertOrganisationUnitResource only in scenarios where caller wants to set the value of primary key (organisation unit resource ID) by itself. 
modifymodify Modifies a organisation unit resource record. 
Related Pages (10)