Table Description
OnlineProgramGroupLink: This entity is used to associate a program with a program group, i.e. the program is a member of the program group.
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::OnlineProgramGroupLink::OnlineProgramGroupLink
Controlling File: WorkspaceServices\model\Packages\Entity\OnlineProgramGroupLink\OnlineProgramGroupLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
onlineProgramGroupLinkIDkeynoUnique identifier for this record.ONLINE_PROGRAM_GROUP_ID SVR_INT64
onlineProgramGroupIDdetailsnoReference to the program group.ONLINE_PROGRAM_GROUP_ID SVR_INT64
programTypeIDdetailsnoReference to the program.PROGRAM_TYPE_ID SVR_INT64
recordStatusdetails The status of the record, Active or Cancelled.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (2)
ChildParent
OnlineProgramGroupLink.onlineProgramGroupIDOnlineProgramGroup.onlineProgramGroupID
OnlineProgramGroupLink.programTypeIDProgramType.programTypeID
Indices (2)
Index NameAttributes
IND_748406530programTypeID
IND__1454566336onlineProgramGroupID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: onlineProgramGroupLinkID
AUTO_ID_KEY: INTAKERAKS
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByProgramAndStatusreadmulti Searches for a list of link records by program type and record status. 
searchByProgramGroupAndStatusreadmulti Searches for a list of link records by program group and record status. 
readByProgramGroupAndStatusnsread Read the link by Program Group, Program Type and record status. 
insertOnlineProgramGroupLinknsinsert   
Related Pages (13)