Security for the Payroll/Personnel System (PPS) Data Warehouse is controlled through
views that mimic the PPS access at Office of the President. The views control the access to
specific data fields within the table as well as the population or records. The format of the view-naming
has changed. The old, soon to be discontinued views referred to the screen group with a "SG#" prefix plus the last three
characters of the table name: i.e. departmental access (screen group 4) to the person table EDBPER was "SG4PER" with
the Personnel Office access (screen group 2) with some additional sensitive data fields being "SG2PER".
The old views have been consolidated and replaced with a much simpler naming format:
"TABLENAME_V" so the same person table view is now "EDBPER_V" for departments. Where applicable,
there is a date indication added to the view name "TABLENAME_V_FY_yyyy".
Where a specialized view for
the central administrative offices (i.e. Payroll, Personnel) is needed, the view name is
"TABLENAME_VC" however for tables where the central office view is no different from the departmental view, all
authorized users would have the same view (i.e. appointment data "EDBAPP_V"). Where customized views
were needed unique indicators have been added to the end of the view name (i.e. EDBAPP_V3 - a limited-
access view of job appointments.)
views.
NOTE: PPS Data Warehouse users are encouraged to change their old-style views
to the new view names for 2 reasons: the old views will be deleted at the end of the 2005-2006 fiscal
year and more importantly, some new fields have been included in the new views but have not been
added to the old screen group-style views.
| System | Table Description | Table or View | Examples |
| COA | Chart of Accounts Tables tables | Table | COAACR => COAACR |
| CSE | Committed Salary/Payroll Lien tables | View | CSECSR => CSECSR_V |
| CTL | Control/Code Translation tables | Table | CTLHME => CTLHME |
| DVT | Davis Code Translation tables | Table | DVTSCH => DVTSCH |
| EDB | Employee Data Base tables | View | EDBPER => EDBPER_V (dept), EDBPER_VC (central offices) |
| EDW | Expense Distribution tables | View | EDWEXP => EDWEXP_V_FY_2006 |
| ETH | Expense Transfer Holding tables | View | ETHTOE => ETHTOE_V_FY_2006 (dept), ETHTOE_V_FINAID_FY_2006 (special) |
| PAR | Payroll Audit Record tables | View | PARERN => PARERN_V_FY_2006 |
| STF | Staffing List Report tables | View | STFDBUD => STFDBUD_V |
Access to the data tables that do not contain employee-related information however contain code translations and general account information which does not have to be controlled, do not have view established. When accessing these tables, like the control table which contains the job title code translations (CTLTCI), all data warehouse users will use its original name "CTLTCI".
The web-based documentation about the Data Warehouse such as the Information Model and Data Dictionary will continue to refer to the tables by their table name for ease of use.
Sent Comments to PPS Data Warehouse Support at: paysys-support@ucdavis.edu
Last Updated: June 20, 2006