CanonicalFieldList (ver7.0.0)
This table contains the list of custom fields available for transfer through Record and Transcript Exchange.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Country | 7.0.0 | Varchar2(10) | Three-digit country code. |
Description | 7.0.0 | Varchar2(50) | Canonical name displayed on the custom field mapping page. Required. |
IsSROnly | 7.0.0 | Number(3,0) | 1 indicates the canonical field is specific to the state and country identified in those fields. Required |
ID | 7.0.0 | Number(10,0) | Unique sequential number generated by the application. Required. |
Name | 7.0.0 | Varchar2(50) | For non-state specific records this name usually matches the custom field name assigned for an out-of-box PowerSchool instance. Unique for a given TableName. |
State | 7.0.0 | Varchar2(10) | Two-digit state or province code of the state for which the canonical field is used. Only used for fields flagged IsSROnly. |
TableName | 7.0.0 | Varchar2(30) | Name of the table in which the custom field value can be found. Required. |
WhenCreated | 7.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 7.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 7.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 7.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |