*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
*reporting team user accounts: z_slm5, z_jl41, z_lm15, z_np55, z_vp25, z_ama8, z_jmp8
...
| Schema Name | Schema Description | Permissions |
|---|---|---|
| local_automation | This schema is for internal use by the Automation Team. | r/w z_metadbuser_cornell user account |
| local_core | This schema is for internal use by the Reporting Team. | r/w z_metadbuser_cornell user account |
local_derived | This schema is for internal use by the Reporting Team. These tables are created by a script that runs nightly on the Metadb server. The script runs queries in the local_derived directory on cul-folio-analytics. | r/o z_metadbuser_cornell user account r/w reporting team user accounts |
| local_digpres | This schema is used by the HathiTrust team. | r/w z_metadbuser_cornell user account |
| local_eusage | This schema is used for EBSCO consolidation report data. | r/o z_metadbuser_cornell user account r/w z_slm5, z_vp25 |
| local_hathitrust | This schema is used internally by the HathiTrust team. | r/w z_metadbuser_cornell user account |
| local_open | This schema is a sandbox for all users who want to publish a file to a local schema. | r/w z_metadbuser_cornell user account |
| local_protected | This schema is used to store tables with protected data that is used internally by the Reporting Team. | r/o reporting team user accounts r/w z_slm5, z_jl41 |
local_static | This schema is used to store local tables that are in queries used by all reporting users. All users can read the files here, but only reporting team members can post files here. | r/o z_metadbuser_cornell user account r/w reporting team user accounts |
| local_statistics | This schema is for internal use by the Assessment and Planning team. | r/o z_metadbuser_cornell user account r/w z_lm15, z_slm5, z_vp25 |
Reporting Team Members and the Local Static Schema
...