Table Description
OnlineProgramItem: This entity is used to link both program groups and programs to screening types.
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::WorkspaceServices::Entity::Configuration::OnlineProgramItem::OnlineProgramItem
Controlling File: WorkspaceServices\model\Packages\Entity\OnlineProgramItem\OnlineProgramItem_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
onlineProgramItemIDkeynoUnique identifier for this record.ONLINE_PROGRAM_ITEM_ID SVR_INT64
screeningTypeIDdetailsnoA reference to the screening type for which the program group or program is available.INTERNAL_ID SVR_INT64
relatedIDdetailsnoA reference to the program or program group.INTERNAL_ID SVR_INT64
relatedTypedetailsnoThe type of item that is added to the screening, either a program or a program group.ONLINE_PROGRAM_ITEM_TYPEOnlineProgramItemTypeSVR_STRING<10>
displayOrderdetailsnoDefines the order in which the items (programs or program groups) are displayed for the screening. A value of 1 means the program or group is displayed first, the program or group with value 2 is displayed immediately below the first and so forth.DISPLAY_ORDER SVR_INT32
recordStatusdetails The status of the record, Active or Cancelled. RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
OnlineProgramItem.screeningTypeIDScreeningType.screeningTypeID
Indices (2)
Index NameAttributes
OnPrgIttIdx1screeningTypeID, recordStatus
OnPrgIttIdx2screeningTypeID, relatedID, recordStatus
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: onlineProgramItemID
AUTO_ID_KEY: SCRNGTYP
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByScreeningTypeAndStatusreadmultiORDER_BY: displayOrder
Searches for application type items based on screening type. 
readByScreeningTypeAndRelatednsread   
searchByRecordStatusreadmultiORDER_BY: displayOrder
Search the OnlineProgramItem table by the Record Status. 
insertOnlineProgramItemnsinsert Inserts the OnlineProgramItem record.On this method, AUTO ID should not be set. 
Related Pages (20)