S_ON_STU_XML_SHSM_CERT_C (ver. 23.2.2.0)
This table is a child table of Students and stores Student SHSM Certifications XML segment information.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 23.2.2.0 | Number(19) | Primary key |
StudentsDCID | 23.2.2.0 | Number(19) | Primary key that relates the extended table to the [Students] table |
Academic_Year | 23.2.2.0 | Varchar2(9 char) | The academic year of the submission |
Submission_Period_Type | 23.2.2.0 | Varchar2(20 char) | Submission period type |
Action | 23.2.2.0 | Varchar2(6 char) | This is the action associated with this submission Valid values: ADD, NULL (Null is from PAE) |
BSID | 23.2.2.0 | Number(11) | Board School Identification number |
SHSM_Program_Type | 23.2.2.0 | Varchar2(40 char) | Used to uniquely identify the SHSM Program Type |
Type | 23.2.2.0 | Varchar2(3 char) | Used to uniquely identify the SHSM Cert Type |
Date_Completed | 23.2.2.0 | Varchar2(7 char) | Certification Completion Dates (Format: YYYY/MM) |
Certification_Hours | 23.2.2.0 | Number(25,10) | Number of hours related to certification |
WhoCreated | 23.2.2.0 | Varchar2(100 char) | Who created the record |
WhenCreated | 23.2.2.0 | Timestamp(6) | When record was created |
WhoModified | 23.2.2.0 | Varchar2(100 char) | Who modified the record |
WhenModified | 23.2.2.0 | Timestamp(6) | When was the record modified |