Table Description
Screening Assessment Configuration: Identifies that an AssessmentConfiguration is available for the specified dates on a ScreeningConfiguration.
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::Screening Admin::Entity::ScreeningAssessmentConfig::ScreeningAssessmentConfig
Controlling File: core\model\Packages\Reference Model\Service Layer\Screening\ScreeningAdmin_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
scrAssConfigIDkeynoThe unique Id.SCREENING_ASSESSMENT_CONFIG_ID SVR_INT64
screeningConfigIDdetailsnoThe ID of the screening configuration.SCREENING_CONFIGURATION_ID_POPUP SVR_INT64
assessmentConfigurationIDdetailsnoThe ID of the Assessment Configuration.ASSESSMENT_CONFIGURATION_ID SVR_INT64
startDatedetails The date that the assessment configuration is available on the screening configuration.CURAM_DATE SVR_DATE
endDatedetails The date after which the assessment configuration is no longer available on the screening configuration.CURAM_DATE SVR_DATE
recordStatusdetails The record status to support logical deletes.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
ScreeningAssessmentConfig.assessmentConfigurationIDAssessmentConfiguration.assessmentConfigurationID
ScreeningAssessmentConfig.screeningConfigIDScreeningConfiguration.screeningConfigID
Indices (3)
Index NameAttributes
AssStatusIndexassessmentConfigurationID, recordStatus
ScrAssOverlapIdxscreeningConfigID, assessmentConfigurationID, recordStatus, scrAssConfigID, startDate, endDate
ScrStatusIndexrecordStatus, screeningConfigID
Operations (22)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: scrAssConfigID
AUTO_ID_KEY: SCRENINGBO
PRE_DATA_ACCESS: yes
Standard Operation 
searchByScreeningConfignsmulti Retrieves a list of assessment configuration that are on this screening configuration, independent of status or dates.SQL
readScreeningAssessmentConfigns Retrieves details for the specified Screening Assessment relationship.SQL
modifyDatesnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modifies the start and end dates on the link. 
validateInsert  Validates that this insert will maintain date integrity. 
validateBasics  Validates mandatory fields. 
validateOverlap  Validates if there would be an overlap inserting or modifying the specified details. 
validateModifyDates  Validates that this modify will maintain date integrity. 
validateAgainstAssessmentStatusAndDates  Checks that the specified dates will not conflict with the ACTIVE AssessmentConfiguration. 
validateAgainstScreeningStatusAndDates  Checks that the specified dates will not conflict with the ACTIVE ScreeningConfiguration. 
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
  
readStatusnsread   
countOverlapsnsPRE_DATA_ACCESS: yes
 
Counts the overlaps that the specified data would cause.SQL
readread Standard Operation 
validateCancel  Checks that cancel will maintain integrity. 
countByScreeningConfigStatusns Counts how many Active Assessment configuration links exist on the Screening Configuration.SQL
countByScreeningConfigOutsidens Counts how many Active Screening configuration links exist outside the specified dates for a Screening Configuration.SQL
countByAssessmentConfigStatusns Counts how many Active Screening configuration links exist on the AssessmentConfiguration.SQL
countByAssessmentConfigOutsidens Counts how many Active Assessment configuration links exist outside the specified dates for an Assessment Configuration.SQL
insertScreeningAssessmentConfiginsert Inserts&nbsp;screening&nbsp;assessment&nbsp;configuration&nbsp;record. This method expects the scrAssConfigID to be set. It is preferred to call insertScreeningAssessmentConfiguration method only in scenarios where calling method&nbsp;wants to set the value of primary key by itself. 
searchByScreeningConfig1nsmulti Retrieves a list of assessment configuration that are on this screening configuration, independent of status or dates.SQL
modifyScreeningAssessmentConfigmodifyOPTIMISTIC_LOCKING: yes
This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. 
Related Pages (17)