CPS Database Masters

A database master describes the hierarchical structure of a database and also tells FOCUS how to interpret the data in the file.

The masters listed here are for the mainframe Focus databases.  Use the CPS Data Warehouse Table Descriptions
linked from the Personnel Data Warehouse home page to get information about the data structure of the data warehouse tables. 

• Snapshot Database Master Snapshot Master - extracted from Fiscal Year database each month

• Old Snapshot Database Master - cycles from July 2007 through November 2007

• Old Snapshot Database Master - cycles from July 2006 through June 2007

• Old Snapshot Database Master - cycles from July 2005 through June 2006

• Old Snapshot Database Master - cycles from April 2004 through June 2005

• Old Snapshot Database Master - cycles from July 2002 through April 2004

• Old Snapshot Database Master - cycles from July 2001 through June 2002 

• Old Snapshot Database Master - cycles from July 2000 through June 2001 

• Old Snapshot Database Master - cycles before July 2000 

• Fiscal Year Database Master (Primary CPS database - 12 monthly FY buckets for pay/fte/hours worked)

• Old Fiscal Year Database Master - for July 2007 through November 2007

• Old Fiscal Year Database Master - for fiscal year 2006-07

• Old Fiscal Year Database Master - for fiscal year 2005-06

• Old Fiscal Year Database Master - for fiscal year 2004-05

• Old Fiscal Year Database Master - for fiscal year 2003-04

• Old Fiscal Year Database Master - for fiscal year 2002-03

• Old Fiscal Year Database Master - for fiscal year 2001-02

• Old Fiscal Year Database Master - for fiscal year 2000-01

• Old Fiscal Year Database Master  -for years before 2000-01 

• History Database Master (currently used only for ad hoc requests)

• TCSFCP Database Master (Used for reports combining TCS and CPS data)

• Academic File Master (Used for annual academic reports)

• Fiscal Year Academic Subset Master (Used for annual academic reports)

• Old Fiscal Year Academic Subset Master (Old FY academic master - used before July 2001)

• Address File Master (Used for address file containing employee home/campus addresses)

• Old Address File Master (Old FY address master - used through June 2007)

       Masters for systems no longer in use

• OPP Database Master (Office of the President Personnel System)

• Old OPP Database Master (Old OPP Master - for cycles before July 2000)

• Benefits Counseling System Master (Used for BCS - system no longer in use)