DataImportTemplateColumn (ver7.6.0)
This table contains information of the map column fields (mapping of the Import file column to PowerSchool field).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DataImportTemplateColumnID | 7.6.0 | Number(19,0) | Unique ID. Required. |
DataImportTemplateID | 7.6.0 | Number(19,0) | Foreign key reference to the DataImportTemplate table. Required. |
MappedTableName | 7.6.0 | Varchar2(150) | Table name, which the mapped column belongs. Required. |
MappedColumnName | 7.6.0 | Varchar2(30) | Name of the column, which the mapped column gets imported into. Required. |
ColumnOrder | 7.6.0 | Number(4) | The column number in the import file that is imported into the DataImportTemplate PowerSchool-defined table name and column name. Required. |
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. |