DictionaryObject (ver10.1.0)
This table stores any table names documented in the PowerSchool Data Dictionary.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| DictionaryObjectID | 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. |
| ObjectDescription | 10.1.0 | Varchar2(4000) | Describes the purpose of the table. Required. |
| ObjectName | 10.1.0 | Varchar2(30) | Name of the PowerSchool object, currently a table name. Required. Indexed. |
| ObjectNumber | 10.1.0 | Number(6) | Legacy database table number (if applicable). |
| ObjectOrigin | 10.1.0 | Varchar2(30) | Internal development group owning the object. Currently uses the default. Required. Defaults to 'Core'. |
| ObjectSchema | 10.1.0 | Varchar2(30) | Oracle user schema owning the object. Currently uses the default. Required. Defaults to 'PS'. |
| ObjectType | 10.1.0 | Varchar2(30) | Type of database object. Currently uses the default. Required. Defaults to 'Table'. |
| ObjectVersion | 10.1.0 | Varchar2(30) | PowerSchool Application version that introduced the object. |
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. |