ExtSchemaMigrationIssue (ver7.6.0)
Stores details on issues during custom field migration. If the custom field being migrated is over 4000 characters, a record is created in this table.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
CoreId | 7.6.0 | Number(19,0) | Value for core table unique ID. Column in core table dependent on the table. For legacy tables, this is the DCID. Required. |
CoreTable | 7.6.0 | Varchar2(32) | Name of core table. Required. |
ExtColumn | 7.6.0 | Varchar2(32) | Extended schema column name. Required. |
Extension | 7.6.0 | Varchar2(40) | Name of schema extension incurring the issue. Required. |
FieldSetName | 7.10.0 | Varchar2(100) | Unique name applied to a set of legacy custom fields as a means of grouping the fields when performing a bulk migration. Valid values for PowerSchool core: Core Fields, Core Fields2, User_Created_Custom_Fields. |
ID | 7.6.0 | Number(19,0) | Sequential number generated by the application, uniqueness in the table is guaranteed. Indexed. Required. |
IssueCategory | 7.6.0 | Varchar2(20) | Short description for issue, such as "ExtraData" for data too long. Returned by the Populator implementation. Required. |
IssueState | 7.10.0 | Varchar(30) | The status of the migration record. (Inserted and updated by state reporting). Deleted indicates extension table issue resolved for this record. |
Message | 7.6.0 | CLOB | Full text of the message returned by the Populator. |
SourceData | 7.6.0 | CLOB | Original value from the legacy custom field. |
StatusValue | 7.6.0 | Varchar2(20) | Indicates the status of the issue. Valid value: New. Required. |
WhenCreated | 7.7.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 7.7.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 7.7.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 7.7.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |