Skip to main content
Skip table of contents


This table is a child table of Students and stores Student SHSM Certifications XML segment information.

Column Name


Data Type




Primary key



Primary key that relates the extended table to the [Students] table

Academic_Year char)

The academic year of the submission

Submission_Period_Type23.2.2.0Varchar2(20 char)

Submission period type

Action23.2.2.0Varchar2(6 char)This is the action associated with this submission
Valid values: ADD, NULL (Null is from PAE)
BSID23.2.2.0Number(11)Board School Identification number
SHSM_Program_Type23.2.2.0Varchar2(40 char)Used to uniquely identify the SHSM Program Type
Type23.2.2.0Varchar2(3 char)Used to uniquely identify the SHSM Cert Type
Date_Completed23.2.2.0Varchar2(7 char)Certification Completion Dates (Format: YYYY/MM)
Certification_Hours23.2.2.0Number(25,10)Number of hours related to certification
WhoCreated23.2.2.0Varchar2(100 char)Who created the record
WhenCreated23.2.2.0Timestamp(6)When record was created
WhoModified23.2.2.0Varchar2(100 char)Who modified the record
WhenModified23.2.2.0Timestamp(6)When was the record modified
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.