CareerTechStudentCredentials (ver19.11.0)
This table contains Student Career Tech Credentials.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| CareerTechProgramCredentialsID | 19.11.0 | Number(10,0) | Foreign key to CareerTechProgramCredentials table. Indexed with StudentDcid. Required. |
| CareerTechSiteID | 19.11.0 | Number(10,0) | Foreign key to CareerTechSite table. Indexed. Required if OtherLocation is not set. |
| CareerTechStudentCredentialsID | 19.11.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
| CredentialDate | 19.11.0 | Timestamp(0) | Date the test was taken. |
| IsActive | 19.11.0 | Number(1,0) | Indicates the student credential association is active or inactive. Valid values 1=active or 0=inactive. Default = 1. |
| IsLocked | 19.11.0 | Number(1,0) | Indicates if the record is editable and deletable. If true, can't do either. Valid values 1=true or 0=false. Default = 0. |
| isPassed | 19.11.0 | Number(1,0) | The column to indicate if the student passed the credential test. Valid values 1=true or 0=false. |
| OtherLocation | 19.11.0 | Varchar2(255) | The column stores where an out of system credential was earned. Required if CareerTechSiteId is not set. |
| StudentDCID | 19.11.0 | Number(10,0) | Foreign key to Students table. Indexed with CareerTechProgramCredentialsId. Required. |
| WhenCreated | 19.11.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 19.11.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 19.11.0 | Varchar2(100) | The name of the person who create the record. Defaults to user. Required. |
| WhoModified | 19.11.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. Required. |