AssignmentScoreImportLine (ver11.0.0)
This table temporarily houses import data during import validation.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AssignmentSectionID | 11.0.0 | Number(16) | Foreign key to the AssignmentSection table. Required. Indexed. |
AssignmentScoreID | 11.0.0 | Number(10) | Foreign key to the AssignmentScore table. Indexed. |
AssignmentScoreImportLineID | 11.0.0 | Number(16) | Primary key. Required. Indexed. |
GradeScaleID | 11.0.0 | Number(10) | Foreign key to the GradeScaleItem table. |
LineNo | 11.0.0 | Number(10) | Line number in the import file. Required. |
Reason | 11.0.0 | Varchar2(128) | If failed to import, a string with more detail on the cause of the failure. |
Status | 11.0.0 | Varchar2(20) | String representing the status of the imported record. Valid values include: Header, Skipped, Added, Updated, Failed. |
StudentsDCID | 11.0.0 | Number(10) | Foreign key to the Students table. Indexed. |
UsersDCID | 11.0.0 | Number(16) | Foreign key to the Users table. Required. Indexed. |
WhoCreated | 11.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
WhoModified | 11.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |
WhenCreated | 11.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 11.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |