Campus Input Specifications

Campuses provide monthly and annual input files for the Corporate Personnel System, including Dependent Data.

       Current Input Files

• CPS Activity File (From PPP710, used primarily for History Database)
• CPS Employee File (From PPP711, provides employee level data for Fiscal Year and Snapshot databases)
• Dependent Data File (From PPP711, provides data on employee dependents for Benefits reports)
• CPS Appointment File (From PPP712, provides appointment level data for Fiscal Year and Snapshot databases)
• CPS Distribution File - (From PPP713, provides distribution level data for Fiscal Year and Snapshot databases)
• BCS Distribution File (From PPP 713, formerly provided distribution level data for the Benefits Counseling system databases - still used for LBNL)
• BCS Control File (Provides payroll control table file data for CPS; mainly used for DOS code data)
• CPS W-2 File (From PPP714, provides year end W-2 data for Fiscal Year and Snapshot databases)
• CPS Mail File (Provides employee campus mail addresses)
• Academic File (Provides annual academic data)
• Annual Academic File - Campus Info (Campus specifications for annual Academic File)
• Campus FTP Guidelines

      Past Input Files and Previous Record Layouts for Current Input Files

• CPS Employee File - Effective January 2007 (From PPP711, provides employee level data for Fiscal Year and Snapshot databases)
• CPS/BCS Employee File - Effective March 2004 (From PPP711, provides employee level data for Fiscal Year and Snapshot databases as well as Benefits Counseling System)
• CPS/BCS Employee File - Effective June 2003 (From PPP711, provides employee level data for Fiscal Year and Snapshot databases as well as Benefits Counseling System)
• CPS/BCS Employee File - Effective July 2001 (From PPP711, provides employee level data for Fiscal Year and Snapshot databases as well as Benefits Counseling System)
• CPS/BCS Employee File - September 2000 and later (From PPP711, provides employee level data for Fiscal Year and Snapshot databases as well as Benefits Counseling System)
• CPS/BCS Employee File - before September 2000 (From PPP711, provides employee level data for Fiscal Year and Snapshot databases as well as Benefits Counseling System)
• CPS/BCS Appointment File - July 2001 and later (From PPP712, provides appointment level data for Fiscal Year and Snapshot databases)
• CPS/BCS Appointment File - before July 1, 2001 (From PPP712, provides appointment level data for Fiscal Year and Snapshot databases)
• CPS Distribution File - Effective May 2004 (From PPP713, provides distribution level data for Fiscal Year and Snapshot databases)
• CPS Distribution File - before May 2004 (From PPP713, provides distribution level data for Fiscal Year and Snapshot databases)
• BCS Distribution File (From PPP 713, formerly provided distribution level data for the Benefits Counseling system databases - still used for LBNL)
• BCS Deduction File (From PPP 713, formerly provided the Benefits Counseling System with PAR deduction records)
• 403B File (From PPP714, provides annual 403B data for Benefits reports)

Last updated  August 19, 2009