Table Description
Taxonomy Term: Taxonomy term is a named concept for classifying service offerings.

A taxonomy term is a named concept that is used to index service offerings and access information in a systematic, unambiguous way. A concept can be broken down to increasingly specific levels.

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::CPM::Service Layer::Taxonomy::Taxonomy Term::Entity::TaxonomyTerm
Controlling File: CPM\model\Packages\Service Layer\Taxonomy\Taxonomy Term\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (15)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
taxonomyTermIDkeynoUnique identifier for the taxonomy term record.TAXONOMY_TERM_ID SVR_INT64
nameTextIDdetailsnoPreferred name for the concept. The Name accurately describes the service each term represents and uses terminology that is accepted in the field.LOCALIZABLE_TEXT_ID SVR_INT64
codedetailsyesIdentification code for a taxonomy term.TAXONOMY_TERM_CODE SVR_STRING<30>
definitionTextIDdetailsnoDescription of the way services are provided. The definition provides a way to make sure that different organizations use the terms in the same way. The definition can be called as a service narrative.LOCALIZABLE_TEXT_ID SVR_INT64
facetCodedetailsyesA descriptor that explains the type or nature of each term. TAXONOMY_TERM_FACET_CODETaxonomyTermFacetSVR_STRING<10>
bibliographicRefTextIDdetailsyesBibliographic reference list source material for Taxonomy definitions and structure.LOCALIZABLE_TEXT_ID SVR_INT64
commentsTextIDdetailsyesProvides information about a term including tips for indexers about how a term should be used or help in distinguishing the term from others that may be similar.LOCALIZABLE_TEXT_ID SVR_INT64
creationDatedetailsnoDate the taxonomy term was first included in the taxonomy.CURAM_DATE SVR_DATE
lastModifiedDatedetailsyesThe date the term was last modified.CURAM_DATE SVR_DATE
statusdetailsnoStatus of the term that determines its usage in the classification system.TAXONOMY_TERM_STATUS_CODETaxonomyTermStatusSVR_STRING<10>
customTermInddetailsyesIndicates whether the term is defined locally by the Agency.CURAM_INDICATOR SVR_BOOLEAN
parentTermIDdetails Unique identifier for the parent term.TAXONOMY_TERM_ID SVR_INT64
codeUpperdetailsyesUpper case representation of the code.TAXONOMY_TERM_CODE SVR_STRING<30>
countryCodedetailsyesCountry code of the taxonomy term.COUNTRY_CODECountrySVR_STRING<10>
recordStatusdetails Status of the service offering.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (11)
ChildParent
TaxonomyTerm.nameTextIDLocalizableText.localizableTextID
TaxonomyTerm.definitionTextIDLocalizableText.localizableTextID
TaxonomyTerm.bibliographicRefTextIDLocalizableText.localizableTextID
TaxonomyTerm.commentsTextIDLocalizableText.localizableTextID
ExtSysClassifnTermLink.taxonomyTermIDTaxonomyTerm.taxonomyTermID
RelatedTermLink.taxonomyTermIDTaxonomyTerm.taxonomyTermID
RelatedTermLink.relatedTermIDTaxonomyTerm.taxonomyTermID
TaxonomyInEditData.taxonomyTermIDTaxonomyTerm.taxonomyTermID
TaxonomyTermOldCode.taxonomyTermIDTaxonomyTerm.taxonomyTermID
TaxonomyTermRelatedConcept.taxonomyTermIDTaxonomyTerm.taxonomyTermID
UseReference.taxonomyTermIDTaxonomyTerm.taxonomyTermID
Indices (7)
Index NameAttributes
TaxonomyTermCodeUpperIdxcodeUpper
TaxonomyTermNameTextIDIdxnameTextID
TaxonomyTermRecordStatusIdxrecordStatus
IND__1285407405parentTermID
IND_289983165definitionTextID
IND_315791404bibliographicRefTextID
IND_341700382commentsTextID
Operations (15)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: taxonomyTermID
Inserts a taxonomy term record. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a taxonomy term record. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
readread Reads a taxonomy term record. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
readByCodensread Retrieves the taxonomy term by code. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
searchByNamensmulti Searches taxonomy terms by name and locale. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced.SQL
searchByParentTermreadmulti Searches the taxonomy term by parent term. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
removeremove Removes a taxonomy term record. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
readByNameTextIDnsread Returns the taxonomy term details based on the localzable text id of the Taxonomy Term. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
createTaxonomyTermsbatchinsert Batch insert operation for inserting the taxonomy term records. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
readAllnkreadmultiORDER_BY: code
READMULTI_LIM: 0
Retrieves all the taxonomy term records. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
searchByStatusreadmulti Searches the taxonomy terms by the term status. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
searchByActiveTermsreadmulti @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
searchActiveTermsByParentTermreadmulti @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
modifyTaxonomyTermsbatchmodify Batch modify operation for modifying the taxonomy term records. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
searchByRootTermnsreadmultiORDER_BY: code
WHERE: TaxonomyTerm.parentTermID IS NULL AND TaxonomyTerm.recordStatus = :recordStatus
Retrieves the root active taxonomy terms. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. 
Related Pages (84)
New Text Translation (ProviderManagement_addLocalizableRelatedConceptTranslation)
New Text Translation (ProviderManagement_addLocalizableTermTranslation)
Related Concepts (ProviderManagement_addRelatedConceptFromInEditTermView)
Related Concepts (ProviderManagement_addRelatedConceptFromPublishedTermView)
Related Concepts (ProviderManagement_addRelatedConceptsToTermFromView)
Related Concepts (ProviderManagement_addRelatedConceptToInEditTerm)
Related Concepts (ProviderManagement_addRelatedConceptToInEditTermFromBrowse)
Related Concepts (ProviderManagement_addRelatedConceptToPublisedInEditTerm)
New See Also Reference (ProviderManagement_addRelatedTermFromInEditTermView)
New See Also Reference (ProviderManagement_addRelatedTermsFromPublishedTermView)
New See Also Reference (ProviderManagement_addRelatedTermsToPublishedInEditTerm)
New See Also Reference (ProviderManagement_addRelatedTermToInEditFromBrowseView)
New See Also Reference (ProviderManagement_addRelatedTermToInEditTerm)
New See Also Reference (ProviderManagement_addSeeAlsoReferenceToPublisedTerm)
New Term (ProviderManagement_addTaxonomyTermsToRelatedConcept)
New Term (ProviderManagement_addTaxonomyTermsToRelatedConceptElement)
New Concept (ProviderManagement_addTaxonomyTermsToRelatedConceptWiz)
New Concept (ProviderManagement_addTermsToRelatedConceptElementWiz)
New Use Reference (ProviderManagement_addUseReferenceToInEditTerm)
New Use Reference (ProviderManagement_addUseReferenceToPublishedTerm)
Confirm Indexing (ProviderManagement_confirmIndexing)
Confirm Indexing (ProviderManagement_confirmIndexingFromAddMore)
Confirm Indexing (ProviderManagement_confirmIndexingFromExisting)
Confirm Indexing (ProviderManagement_confirmIndexingFromExistingMore)
Confirm Indexing (ProviderManagement_confirmIndexingFromMore)
New Term (ProviderManagement_createInEditTaxonomyTerm)
New Concept (ProviderManagement_createRelatedConcept)
New Term (ProviderManagement_createTaxonomyTerm)
Delete All Terms (ProviderManagement_deleteAllInReviewTerms)
Term Position (ProviderManagement_listAssociatedTerms)
Provider Services indexed with (ProviderManagement_listProvidersAndServicesByTaxonomyTerm)
ProviderManagement_listRelatedConceptsForTaxonomyTerm
ProviderManagement_listRelatedConceptsForTaxonomyTermFromBrowse
Related Concepts (ProviderManagement_listRelatedConceptsForTaxonomyTermFromSearch)
ProviderManagement_listSeeAlsoReferencesForInEditTaxonomyTerm
ProviderManagement_listSeeAlsoReferencesForTaxonomyTerm
ProviderManagement_listSeeAlsoReferencesForTaxonomyTermFromBrowse
See Also References (ProviderManagement_listSeeAlsoReferencesForTaxonomyTermFromSearch)
ProviderManagement_listSeeAlsoReferencesForTermInEdit
ProviderManagement_listTaxonomyDeletedItems
ProviderManagement_listTaxonomyModifiedItems
ProviderManagement_listTaxonomyReplacedItems
Taxonomy Terms (ProviderManagement_listTaxonomyTermsForRelatedConcept)
ProviderManagement_listUseReferencesForTaxonomyTerm
ProviderManagement_listUseReferencesForTaxonomyTermFromBrowse
Use References (ProviderManagement_listUseReferencesForTaxonomyTermFromSearch)
Edit Text Translation (ProviderManagement_modifyLocalizableRelatedConceptTranslation)
Edit Text Translation (ProviderManagement_modifyLocalizableTermTranslation)
Edit Related Concept (ProviderManagement_modifyRelatedConcept)
Edit Related Concept (ProviderManagement_modifyRelatedConceptElement)
Term Details (ProviderManagement_previewTaxonomyTerm)
Term Details (ProviderManagement_previewUpdatedTerm)
Publish Taxonomy Terms (ProviderManagement_publishInEditTaxonomyTerms)
Publish Taxonomy Term (ProviderManagement_publishInEditTerm)
Remove Related Concept (ProviderManagement_removeRelatedConceptFromInEditTaxonomyTerm)
Remove Related Concept (ProviderManagement_removeRelatedConceptFromTaxonomyTerm)
Remove See Also Reference (ProviderManagement_removeRelatedTermFromInEditTerm)
Remove See Also Reference (ProviderManagement_removeSeeAlsoReferenceFromPublisedTerm)
Delete Taxonomy Term (ProviderManagement_removeTaxonomyTerm)
Remove Taxonomy Term (ProviderManagement_removeTaxonomyTermFromRelatedConcept)
Delete Taxonomy Term (ProviderManagement_removeTaxonomyTermFromSearch)
Remove Use Reference (ProviderManagement_removeUseReferenceFromInEditTerm)
Remove Use Reference (ProviderManagement_removeUseReferenceFromPublishedTerm)
Republish Taxonomy Version (ProviderManagement_republishTaxonomyVersion)
Delete Terms (ProviderManagement_reviewDeletedTerms)
Review Modified Terms (ProviderManagement_reviewModifiedTerm)
Select Replacement Terms (ProviderManagement_reviewReplacedTerm)
Review Terms (ProviderManagement_reviewVersionTabDetails)
Search By Keyword And Code (ProviderManagement_searchInEditTaxonomyTermsByKeyWordPopup)
ProviderManagement_searchTaxonomyTermsByKeyWord
Search By Keyword And Code (ProviderManagement_searchTaxonomyTermsByKeyWordPopup)
New Term (ProviderManagement_storeInEditTaxonomyTerm)
Add Concept (ProviderManagement_storeRelatedConceptWiz)
New Taxonomy Term (ProviderManagement_storeTaxonomyTerm)
Edit Taxonomy Term (ProviderManagement_updateInEditTaxonomyTerm)
Edit Taxonomy Term (ProviderManagement_updateTaxonomyTerm)
ProviderManagement_viewInEditTaxonomyTermFromBrowse
ProviderManagement_viewPublishedTaxonomyVersion
View Related Concept (ProviderManagement_viewRelatedConcept)
View Related Concept (ProviderManagement_viewRelatedConceptElement)
ProviderManagement_viewTaxonomyTerm
ProviderManagement_viewTaxonomyTermFromBrowse
Taxonomy Term (ProviderManagement_viewTaxonomyTermFromSearch)
ProviderManagement_viewTaxonomyTermTabDetails