Skip to main content


persistent class %iKnow.Objects.CrcUnique extends %Library.Persistent

SQL Table Name: %iKnow_Objects.CrcUnique

Note: the use of this class is no longer recommended for accessing elements of a specific domain. For those scenarios, %iKnow.Tables.Utils offers a more flexible and customizable way of projecting iKnow domain data to SQL

This is a read-only object representation wrapping the internal iKnow data structures for unique CRCs.

This class can be used from Cache ObjectScript or SQL to access a single or small number of entries, but the storage mappings are not meant to support elaborate or complex queries targeting this SQL table.

Please use the predefined queries in %iKnow.Queries.CrcAPI and other query classes to consult CRC data as the internal global structures are designed to optimize performance for these queries rather than general-purpose access.

NOTE: This object assumes all underlying data structures are present. Use domain-specific copies of these objects for domains where not all indices are built. See also the GenerateAllObjectsForDomain() method in %iKnow.Objects.Utils.

Property Inventory


parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.


property CcUniId as %Integer [ Calculated ];
Property methods: CcUniIdCompute(), CcUniIdDisplayToLogical(), CcUniIdGet(), CcUniIdIsValid(), CcUniIdLogicalToDisplay(), CcUniIdNormalize(), CcUniIdSQLCompute()
property CcUnique as %iKnow.Objects.CcUnique [ Calculated ];
Property methods: CcUniqueCompute(), CcUniqueGet(), CcUniqueGetObject(), CcUniqueGetObjectId(), CcUniqueSQLCompute()
property CorpusDominance as %Numeric [ Calculated ];
Property methods: CorpusDominanceCompute(), CorpusDominanceDisplayToLogical(), CorpusDominanceGet(), CorpusDominanceIsValid(), CorpusDominanceLogicalToDisplay(), CorpusDominanceNormalize(), CorpusDominanceSQLCompute()
property CorpusFrequency as %Integer [ Calculated ];
Property methods: CorpusFrequencyCompute(), CorpusFrequencyDisplayToLogical(), CorpusFrequencyGet(), CorpusFrequencyIsValid(), CorpusFrequencyLogicalToDisplay(), CorpusFrequencyNormalize(), CorpusFrequencySQLCompute()
property CorpusSpread as %Integer [ Calculated ];
Property methods: CorpusSpreadCompute(), CorpusSpreadDisplayToLogical(), CorpusSpreadGet(), CorpusSpreadIsValid(), CorpusSpreadLogicalToDisplay(), CorpusSpreadNormalize(), CorpusSpreadSQLCompute()
property CrcUniId as %Integer [ Required ];
Property methods: CrcUniIdDisplayToLogical(), CrcUniIdGet(), CrcUniIdIsValid(), CrcUniIdLogicalToDisplay(), CrcUniIdNormalize(), CrcUniIdSet()
property DomainId as %Integer [ Required ];
Property methods: DomainIdDisplayToLogical(), DomainIdGet(), DomainIdIsValid(), DomainIdLogicalToDisplay(), DomainIdNormalize(), DomainIdSet()
property Master as %iKnow.Objects.EntityUnique [ Calculated ];
Property methods: MasterCompute(), MasterGet(), MasterGetObject(), MasterGetObjectId(), MasterSQLCompute()
property MasterId as %Integer;
Property methods: MasterIdDisplayToLogical(), MasterIdGet(), MasterIdIsValid(), MasterIdLogicalToDisplay(), MasterIdNormalize(), MasterIdSet()
property Relation as %iKnow.Objects.EntityUnique [ Calculated ];
Property methods: RelationCompute(), RelationGet(), RelationGetObject(), RelationGetObjectId(), RelationSQLCompute()
property RelationId as %Integer;
Property methods: RelationIdDisplayToLogical(), RelationIdGet(), RelationIdIsValid(), RelationIdLogicalToDisplay(), RelationIdNormalize(), RelationIdSet()
property Slave as %iKnow.Objects.EntityUnique [ Calculated ];
Property methods: SlaveCompute(), SlaveGet(), SlaveGetObject(), SlaveGetObjectId(), SlaveSQLCompute()
property SlaveId as %Integer;
Property methods: SlaveIdDisplayToLogical(), SlaveIdGet(), SlaveIdIsValid(), SlaveIdLogicalToDisplay(), SlaveIdNormalize(), SlaveIdSet()


index (CrcUni on DomainId,MasterId,RelationId,SlaveId) [Unique];
Index methods: CrcUniCheck(), CrcUniCheckUnique(), CrcUniDelete(), CrcUniExists(), CrcUniIdDisplayToLogical(), CrcUniIdFreqExists(), CrcUniIdGet(), CrcUniIdIsValid(), CrcUniIdLogicalToDisplay(), CrcUniIdNormalize(), CrcUniIdSet(), CrcUniIdSpreadExists(), CrcUniOpen(), CrcUniSQLCheckUnique(), CrcUniSQLExists(), CrcUniSQLFindPKeyByConstraint(), CrcUniSQLFindRowIDByConstraint()
index (CrcUniIdFreq on DomainId,CorpusFrequency);
Index methods: CrcUniIdFreqExists()
index (CrcUniIdSpread on DomainId,CorpusSpread);
Index methods: CrcUniIdSpreadExists()
index (PKINDEX on DomainId,CrcUniId) [IdKey, PrimaryKey, Type = key, Unique];
Index methods: PKINDEXCheck(), PKINDEXDelete(), PKINDEXExists(), PKINDEXOpen(), PKINDEXSQLCheckUnique(), PKINDEXSQLExists(), PKINDEXSQLFindPKeyByConstraint(), PKINDEXSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods


Storage Model: CacheSQLStorage

Maps: 4

  • Map number 1 is named CrcUni

    thismap.Global: ^ISC.IK.CrcUni

  • Map number 2 is named CrcUniIdFreq

    thismap.Global: ^ISC.IK.CrcUniIdFreq

  • ^ISC.IK.CrcUni({DomainId},{MasterId},{RelationId},{SlaveId})
    Node Delimiter Piece Name
  • Map number 3 is named CrcUniIdSpread

    thismap.Global: ^ISC.IK.CrcUniIdSpread

  • ^ISC.IK.CrcUniIdFreq({DomainId},-{CorpusFrequency},{CrcUniId})
  • Map number 4 is named MainMap

    thismap.Global: ^ISC.IK.CrcUniId

  • ^ISC.IK.CrcUniIdSpread({DomainId},-{CorpusSpread},{CrcUniId})
    Node Delimiter Piece Name
    1 MasterId
    2 RelationId
    3 SlaveId
FeedbackOpens in a new tab