Skip to main content
Skip table of contents

CareerTechStudentCredentials (ver19.11.0)

This table contains Student Career Tech Credentials.

Column Name

Initial Version

Data TypeDescription
CareerTechProgramCredentialsID19.11.0Number(10,0)Foreign key to CareerTechProgramCredentials table. Indexed with StudentDcid. Required.
CareerTechSiteID19.11.0Number(10,0)Foreign key to CareerTechSite table. Indexed. Required if OtherLocation is not set.
CareerTechStudentCredentialsID19.11.0Number(10,0)Unique identifier for this table. Indexed. Required.
CredentialDate19.11.0Timestamp(0)Date the test was taken.
IsActive19.11.0Number(1,0)Indicates the student credential association is active or inactive. Valid values 1=active or 0=inactive. Default = 1.
IsLocked19.11.0Number(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.
isPassed19.11.0Number(1,0)The column to indicate if the student passed the credential test. Valid values 1=true or 0=false.

The column stores where an out of system credential was earned.

Required if CareerTechSiteId is not set.

StudentDCID19.11.0Number(10,0)Foreign key to Students table. Indexed with CareerTechProgramCredentialsId. Required.

The date and time the record was created. Defaults to system date. Required.

WhenModified19.11.0Timestamp(6)The date and time the record was modified. Defaults to system date. Required.
WhoCreated19.11.0Varchar2(100)The name of the person who create the record. Defaults to user. Required.
WhoModified19.11.0Varchar2(100)The name of person who modified the record. Defaults to user. Required.
JavaScript errors detected

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

If this problem persists, please contact our support.