CareerTechAuditHistory (ver19.11.0)
This table contains Career Tech Change History information. When a Program Credential association is deleted, the corresponding cluster name, program name, and credential name are stored here for display in the Career Tech Change History transactions related to the lifetime of the deleted Program Credential.
Note: The Change history feature has been enhanced to handle maintaining information from fields that are deleted from the database such as Program Credentials. No further tables of this nature are expected in the future.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CareerTechAuditHistoryID | 19.11.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ClusterName | 19.11.0 | VarChar2(100) | Name of the Cluster. Required. |
CredentialName | 19.11.0 | Varchar2(100) | Name of the Credential. Required. |
ProgramCredentialsID | 19.11.0 | Number(10,0) | Historical Foreign key to ProgramCredentials. When a record exists in this table, the corresponding ProgramCredential will have been deleted. Career Tech Change History will query based on this ID in order to get display values. Indexed. Required. |
ProgramName | 19.11.0 | VarChar2(100) | Name of the Program. Required. |
| WhoCreated | 19.11.0 | Varchar2(100) | The name of the person who create the record. Defaults to user. Required. |
| WhenCreated | 19.11.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
| WhoModified | 19.11.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. Required. |
| WhenModified | 19.11.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. Required. |