ColumnReMap (ver12.0.0)
This table contains the mapping needed to migrate contact-related data into the new contacts schema. This table does not represent a functional area within Powerschool, nor is it application specific.
Migration Notes: For internal use only. The current schema is not normalized. The existing methodology requires a new column to be added when a new contact is created. The revised methodology eliminates need for new columns by adding rows into this normalized data structure. This table could be used for future remapping of other columns.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| CoreTable | 12.0.0 | Varchar2 (32) | The source table for the mapping. Indexed along with the SourceField column. Required |
| DestinationField | 12.0.0 | Varchar2 (100) | Indicates the new location of the original column(s). In most cases they represent the destination field. However, in some cases where the original column needs to be split into multiple columns, an asterisk is used as a prefix. For example, Students.Geocode is saved to the new Address table as latitude and longitude and the destination field is represented as *geocode. Required. |
| MappingMeans | 12.0.0 | Varchar2 (100) | Identifies how the SourceField column is mapped to the DestinationField column. For example, there are different kinds of addresses, such as Home or Mailing. MappingMeans is the Address and the MappingMeansType identifies if the address is Home or Mailing. Defaults to *contact. Required. |
MappingMeansType | 12.0.0 | Varchar2 (100) | Indicates the sub-category of the MappingMeans column. For example, if Phone is the MappingMeans, then Home or Work could be the MappingMeansType. Used in combination with the MappingMeans column to determine the DestinationField column. Optional. |
| OriginalType | 12.0.0 | Varchar2 (100) | The original contact type, such as Mother, Father, Emerg1, Emerg2, Emerg3, Guardian, etc. Defaults to *self. |
| SourceField | 12.0.0 | Varchar2 (100) | The source column in the source table. Indexed along with the CoreTable column. Required. |
| WhenCreated | 12.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 12.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 12.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. Required. |
WhoModified | 12.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. Required. |