DataImport (ver7.6.0)
This table contains the details of an import.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DataImportID | 7.6.0 | Number(19,0) | Primary key. Required. |
EndTime | 7.6.0 | Timestamp(6) | Date and time when the import completed. |
FailureRecordCount | 7.6.0 | Number(10,0) | The number of records that failed on import. Defaults to 0. Required. |
FileName | 7.6.0 | Varchar2(256) | Name of the file that was imported. Required. |
ModuleName | 7.6.0 | Varchar2(100) | Name of the target import module. Required. |
ResultData | 7.6.0 | CLOB | Contains XML formatted text detailing the results of the import. |
StartTime | 7.6.0 | Timestamp(6) | Date and time when the import began. |
StatusCode | 7.6.0 | Varchar2(256) | Current status of the import operation. Valid values: In Progress, Complete. |
SuccessRecordCount | 7.6.0 | Number(10,0) | The number of records that successfully imported. Defaults to 0. Required. |
TeachersDCID | 7.6.0 | Number(19,0) | The DCID of the teacher in the associated Users record. Required. |
TotalRecords | 7.6.0 | Number(10,0) | Total number of records in the import file. Required. |
| IsScheduled | 24.6.0.0 | Number(1,0) | Determines if the import operation is scheduled or not. Defaults to 0. |
WhenCreated | 7.6.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 7.6.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 7.6.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 7.6.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |