Table Description
Sequential Continuous Reference Number: Generates a sequential continuous reference numbers for a given code name. This generates continuous sequential reference numbers.

Generates a sequential continuous reference numbers for a given code name. It returns the reference number for a given code name and increments the reference number by one.

Example

When a Provider Foster care is enrolled in Social Enterprise Management agency, provider gets the reference number 100. Next Provider that will be registered will get 101 as the reference number.
Model Details
Location in Model: Logical View::MetaModel::Curam::CPM::Service Layer::SequentialContinuousRefNumber::Entity::SequentialContinuousRefNumber
Controlling File: CPM\model\Packages\Service Layer\SequentialContinuousRefNumber\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
sequentialContinuousRefNoIDkeynoThe unique system generated identifier for the Sequential Continuous Reference Number record.INTERNAL_ID SVR_INT64
referenceNumberCodeNamedetails Reference Number Code Name against which next reference numbers to be assigned are stored.KEYSET_NAME SVR_STRING<10>
nextReferenceNumberdetails Next reference number for the given Reference Number Code Name.INTERNAL_ID SVR_INT64
Indices (1)
Index NameAttributes
SeqContiRefNbrRefNbrCodeNmIdxreferenceNumberCodeName
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: sequentialContinuousRefNoID
Creates a new row on Sequential Continuous Reference Number table. 
readread Reads a row of data from Sequential Continuous Reference Number table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on Sequential Continuous Reference Number table. 
readByReferenceNumberCodeNamensread Reads Sequential Continuous Reference Number by Reference Number Code Name. 
Related Pages (6)