DictionaryColumn (ver10.1.0)
This table contains the columns of the PowerSchool tables and corresponding descriptions.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| DictionaryColumnID | 10.1.0 | Number(10) | Unique sequential number generated internally. Required. Indexed. |
| DisplayName | 10.1.0 | Varchar2(80) | Not currently used. |
IsNolongerUsed | 10.1.0 | Number(1) | 1 indicates the table is no longer used by the application. Required. Defaults to 0. |
| ColumnDescription | 10.1.0 | Varchar2(4000) | Describes the purpose of the column within the PowerSchool application. Required. |
| ColumntName | 10.1.0 | Varchar2(30) | Name of the column as stored in the database table definition. Required. Indexed. |
| TableName | 10.1.0 | Varchar2(30) | ObjectName of the related DictionaryTable record. |
| TableSchema | 10.1.0 | Varchar2(30) | Oracle user schema owning the object. Currently uses the default. Required. Defaults to 'PS'. |
| ColumnDataType | 10.1.0 | Varchar2(30) | Datatype of the column in the database table definition. |
| ColumnVersion | 10.1.0 | Varchar2(30) | PowerSchool Application version that introduced the column. |
WhenCreated | 10.1.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 10.1.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 10.1.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 10.1.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |