DB_Object, 169 (ver4.0.0)
This table maintains all of the tables and their columns that exist in the PowerSchool schema that are available for auditing purposes.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Audit_YN | 4.0.0 | Number(10,0) | Indicates whether this object is to be audited. |
Cleanup_Freq | 4.0.0 | Varchar(10) | Frequency or timeframe of when logs relating to this object are to be deleted from the log table. Daily, Weekly, Monthly, Quarterly. |
ID | 4.0.0 | Number(10,0) | A unique sequential number generated by the application. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Name | 4.0.0 | Varchar(40) | Name of the object. |
Object_Internal_Num | 4.0.0 | Number(10,0) | Internal 4D object number. Indexed. |
Object_Type | 4.0.0 | Varchar(10) | Type of the object: Table, Column. |
Parent_DBObjectID | 4.0.0 | Number(10,0) | This is recursive relationship which if present is the ID of the Table which has this column ID. If 0, then it's the table itself. Indexed. |
Unused | 4.0.0 | Number(10,0) | Currently unused field. |
Unused2 | 4.0.0 | Number(10,0) | Currently unused field. |
Unused3 | 4.0.0 | Number(10,0) | Currently unused field. |
Write_To_File_YN | 4.0.0 | Number(10,0) | Indicates whether logs need to be written to a file prior to being deleted (see above). |