Table Description
Education Snapshot: Maintains a history of changes to the education data for a participant.

Example

If a user modifies, for example, the qualification details of the education, a snapshot of the education data prior to making this modification is written to the education snapshot table. Likewise when any of the education details are modified a snapshot of the previous version of the record is created.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Concern::Entity Objects::Education::EducationSnapshot
Controlling File: core\model\Packages\Concern\Education_cat.efx
Attributes (12)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
educationSnapshotIDkeynoUnique identifier of the education snapshot record.EDUCATION_SNAPSHOT_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>
addressIDdetails Identifier for the address of the institution at which the education takes place.ADDRESS_ID SVR_INT64
concernRoleIDdetails Identifier of the participant for whom the education data is being maintained.CONCERN_ROLE_ID SVR_INT64
statusCodedetails The status of the record, either active or canceledRECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Free text as entered by the user.COMMENTS SVR_STRING<300>
creationDateTimedetails The date and time the education snapshot was created.CURAM_DATETIME SVR_DATETIME
educationIDdetails Identifier of the education record for which the snapshot was created.EDUCATION_ID SVR_INT64
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: educationSnapshotID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
removeremove Standard Operation 
searchByEducationIDnsmulti Method to return a list of all Education Snapshot Records for an Education ID.SQL
Related Pages (2)