Table Description
Education: A program of instruction or a qualification received from a learning institution.

Example

John Smith attended the University of London from January 1992 to July 1996. He attained a degree in engineering.
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::Concern::Entity Objects::Education::Education
Controlling File: core\model\Packages\Concern\Education_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
VALIDATION_EXIT_POINTyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
educationIDkeynoThe unique education idEDUCATION_ID SVR_INT64
fromDatedetails The date the education record beganCURAM_DATE SVR_DATE
toDatedetails The date the education record ceasedCURAM_DATE SVR_DATE
courseTypedetails The type of course, either Full-Time or Part-TimeCOURSE_TYPE_CODECourseTypeSVR_STRING<10>
qualificationdetails The qualification obtained, degree, diploma, certificate, masters, doctorateQUALIFICATION_CODEQualificationSVR_STRING<10>
institutiondetails The institution, (college), where the education took placeNAME SVR_STRING<131>
addressIDdetailsnoThe unique address idADDRESS_ID SVR_INT64
concernRoleIDdetailsnoThe concern role idCONCERN_ROLE_ID SVR_INT64
statusCodedetails The status of the record, either active or canceledRECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Any free text can be entered hereCOMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
Education.concernRoleIDConcernRole.concernRoleID
Indices (1)
Index NameAttributes
concernRoleIDIdxconcernRoleID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchEducationByConcernnsreadmulti Method to return a list of all Education Records for a Concern Role. 
searchForDuplicatensmulti Method to check for overlapping records.SQL
searchByConcernRoleIDAndStatusnsreadmulti Search all education records using the concern role id and status 
Related Pages (17)