Table Description

Student: This evidence captures details about a Household Member's period of education.

A Household Member's enrollment in any type of education. Details recorded include: Grades, The school/college they are attending, whether they are full-time or part-time, period of study and graduation date.

Example

A case worker creates a Student record for Linda Smith as she is currently attending a vocational school full time.
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::Evidence::Service Layer::Entity::Household::Student::Student
Controlling File: Evidence\model\ServiceLayer\entity\Household\Student\Student_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (18)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeyno

System generated unique identifier for the Student. There is no UI field for this attribute.

EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsno

The case participant role ID of the Household Member who is a Student. The UI field name for this attribute is 'Household Member'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
schCaseParticipantRoleIDdetailsyes

The Case Participant Role ID of the school that the student is attending. The UI field name for this attribute is 'School Participant'.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
schoolTypedetails 

The type of school the student is attending. Examples include: Pre-School, Elementary, etc. This is populated from the 'schoolType' code table. The UI field name for this attribute is 'School Type'.

EVD_SCHOOL_TYPESchoolTypeSVR_STRING<10>
studentStatusdetails 

This identifies the student status. Examples include: Full Time, Part Time, Dropped Out, etc. This is populated from the 'StudentStatus' code table. The UI field name for this attribute is 'Student Status'.

EVD_STUDENT_STATUSStudentStatusSVR_STRING<10>
courseNamedetails 

The student's course name. The UI field name for this attribute is 'Course Name'.

EVD_COURSE_NAME SVR_STRING<40>
highGradeCompleteddetails 

The highest grade completed by the Household Member. Examples include: Fifth Grade, College Graduate, etc. This is populated from the 'SchoolGrade' code table. The UI field name for this attribute is 'Highest Grade Completed'.

EVD_SCHOOL_GRADESchoolGradeSVR_STRING<10>
currentGradedetails 

The current grade of the Household Member. Examples include: Fifth Grade, College Graduate, etc. This is populated from the 'SchoolGrade' code table. The UI field name for this attribute is 'Current Grade'.

EVD_SCHOOL_GRADESchoolGradeSVR_STRING<10>
specialProgramdetails 

This describes the special program needs of the person. Examples include: Advanced Placement, Learning Disabilities, etc. This is populated from the 'SpecialProgramType' code table. The UI field name for this attribute is 'Special Program'.

EVD_SPECIAL_PROGRAMSpecialProgramTypeSVR_STRING<10>
studentGradDatedetails 

The date on which the student will graduate. The UI field name for this attribute is 'Graduation Date'.

CURAM_DATE SVR_DATE
studentStartDatedetails 

The date from which the individual became a student. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
studentEndDatedetails 

The date until which the individual is a student. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
studentFinalExamDatedetails 

The date of the student's final exam. The UI field name for this attribute is 'Final Exam Date'.

CURAM_DATE SVR_DATE
workStudyInddetails 

Indicates if the Household Member is participating in work study. The UI field name for this attribute is 'Work Study'.

CURAM_INDICATOR SVR_BOOLEAN
workStudyStartDatedetails 

The start date of the work study. The UI field name for this attribute is 'Start Date'.

CURAM_DATE SVR_DATE
workStudyEndDatedetails 

The end date of work study. The UI field name for this attribute is 'End Date'.

CURAM_DATE SVR_DATE
workStudyReasondetails 

The reason the individual is participating in work study. Examples include: Federally Financed Work Study Program, Federally Financed Work Study Program, etc. This is populated from the 'WorkStudyReason' code table. The UI field name for this attribute is 'Reason'.

EVD_WORK_STUDY_REASONWorkStudyReasonSVR_STRING<10>
commentsdetails 

Additional details related to the student. The UI field name for this attribute is 'Comments'.

COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
Student.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Student.schCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
studentPartIdxcaseParticipantRoleID
IND_1288128576schCaseParticipantRoleID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
readStudentCaseParticipantns Reads a student record and returns the participant name and their caseParticipantRoleID.SQL
readCaseParticipantsByEvidenceIDnsread Returns all related caseParticipantRoleID's for a specified evidence ID of the student evidence. 
readStudentStatusSchoolTypeAndStudentEndDatensread Reads the studentStatus, schoolType and studentEndDate for a student record using the caseParticipantRoleID. 
Related Pages (18)