(USF) Performing Central Personnel Data File Edit Processing

This chapter provides an overview of regulatory requirements for U.S. federal agencies and discusses how to:

Set up control tables for regulatory reports.
Process Central Personnel Data File (CPDF) files.
Submit parent locator information.
Run equal employment opportunity (EEO) reports.
Run veterans (VETS) reports.
Run Monthly Report of Federal Civilian Employment (SF113-A) and Full-time Equivalent/Work-Year Civilian Employment (SF113-G) reports.

Understanding Regulatory Requirements for U.S. Federal Agencies

The PeopleSoft system provides these U.S. federal agency regulatory reports and submissions:

CPDF Error.
CPDF Dynamics Submission.
CPDF Status Submission.
EEO Groups by PATCOB/POI.
EEO Groups by PATCOB/SubAgency.
EEO Groups by Series/POI.
EEO Groups by Series/Sub-Agency.
Monthly Report of Federal Civilian Employment (SF113-A).
Full-time Equivalent/Work-Year Civilian Employment (SF113-G).
VETS - 100 by POI.
VETS - 100 by Sub-Agency.

Setting Up Control Tables for Regulatory Reports

To set up the control tables to meet U.S. federal regulatory requirements, use the CPDF Fields (GVT_CPDF_FIELDS), Prefixes & Fields (GVT_CPDF_PREFIX), Edits (GVT_CPDF_EDIT), and OPM CPDF Maint Details Page (GVT_OPM_EDITUPDT) components.

Set up information in the following tables to meet U.S. federal regulatory requirements.

This section discusses how to:

Add CPDF fields.
Specify CPDF edit prefixes and fields.
Specify edit content.
Enter edit details.

Pages Used to Set Up Control Tables for Regulatory Reports

Page Name	Object Name	Navigation	Usage
CPDF Fields (Central Personnel Data File fields)	GVT_CPDF_FIELDS	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements, CPDF Fields USF	Verify or add CPDF fields. Complete the CPDF Fields page for every data element required in your agency's CPDF submissions.
Prefixes & Fields	GVT_CPDF_PREFIX	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements, CPDF Edits USF, Prefixes & Fields	Specify the CPDF edit number, edit prefix, category and ID, and fields used in the edit. The three-digit edit prefix identifies the data element subject to the edit.
Edits	GVT_CPDF_EDIT	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements, CPDF Edits USF, Edits	Specify the edit content.
OPM CPDF Maint Details Page (Office of Personnel Management CPDF Maintenance Details)	GVT_OPM_EDITUPDT	Set Up HRMS, Product Related, Workforce Monitoring, Regulatory Requirements, CPDF Edits USF, Edits Click the OPM Update Maintenance Details link.	Enter Office of Personnel Management (OPM) edit update maintenance details.

Adding CPDF Fields

Access the CPDF Fields page.

Field Number

Each CPDF field is assigned a field number. The OPM specifies most of the field numbers, however, there are occasions where formatting information is included in the table for fields not specified by the OPM. These special fields are assigned decreasing numbers starting with 999 (i.e., 999, 998, 997, etc.) while the OPM-specified fields are assigned increasing numbers starting with 1.

Field Name

Enter the field name that corresponds to the field number as it is referenced in the CPDF programs.

Field Type

Define the field type. Values are Char (character), Date, and Number. This field is for informational purposes only at this time.

Field Length

Enter the length of the field as it needs to be reported the OPM. The system uses this field to verify the length of the formatted data before writing to the Dynamics and Status working tables.

Status Start Position

This field is reserved for future use.

Dynamic Start Position

This field is reserved for future use.

Default Field Value (File)

Enter the value that you want this field to contain in the case of NULL data during flat file generation.

Default Field Value (Table)

Enter the value that you want this field to contain in the case of NULL data during Dynamics and Status working table creation.

Pad Field

Enter the type of field padding. Options are Left, Right, or No Padding. If you select Left or Right, provide a pad character.

Pad Character

If a field is to be padded, enter the character used for padding. For example, you might use 0 to left pad a numeric field.

Truncate Field?

Specify whether a field should be truncated by selecting Yes or No. Data will be truncated if the content exceeds the field length.

Edit Mask

Provide an edit mask for field formatting the CPDF tables. CPDF programs support all the standard edit masks available in Structured Query Reports.

Specifying CPDF Edit Prefixes and Fields

Access the Prefixes & Fields page.

Edit Category

Enter a two-digit edit category to identify the data element edit. This number corresponds to the OPM designated value.

Edit ID

Select Status, Dynamic, or Status and Dynamic. The edit ID identifies the file to which this edit applies.

Enter additional combinations of edit category and edit ID for this edit prefix by using the arrows in the Edit Information group box to scroll among combinations.

Field Number

Enter the number of fields affected by this edit.

When you move out of the field, the system populates the Field Length field and Default Field Value field with the values that you entered in the CPDF Fields page. Enter additional fields for this edit by using the arrows in the Error Default Overrides group box.

Specifying Edit Content

Access the Edits page.

Note. Not all page elements are visible on this page. See additional elements by scrolling horizontally.

The Edit Prefix, Description, Edit Category, and Edit ID appear by default from the Prefixes & Fields page. Use the arrows in the Edit Information group box to view edits with the same prefix.

Sub-edit Number

Enter a sub-edit number. Most edits have one sub-edit number: 1. For complicated edits with multiple or nested If/Then statements, insert rows with higher sub-edit numbers. Keep the same effective date for multiple sub-edits.

Create an edit by concatenating If and Then statements. Scroll among If and Then statements using the arrows in the Status group box. Compose the body of the If/Then statement in the CPDF Relational Edit grid area.

Status

Add data rows and use the middle scroll arrow, the Effective Date field, and the Status field to maintain edit history data for information that changes over time. For example, to inactivate the edit based on OPM updates, insert an effective-dated row with a status of Inactive.

OPM Update Maintenance Details

Click this link to document when the edit was added or updated by OPM Updates or Changes.

CPDF Relational Edit

If/Then Code and Seq Nbr (sequence number)	Select either If or Then, and assign a sequence number for each separate condition to be edited. The If statements have sequence numbers 1, 2, and 3,; the reciprocal Then statements have sequence numbers 1 and 2. The pieces are connected by or.. For this example, the equation reads "If 1 or 2 or 3, then 1 or 2."
Left Field Number	Select a field number for comparison from the list of valid values. You enter field numbers in the CPDF Fields page.
Comparison Code	Select from the list of translate values: Between, Equal to, Greater Than or Equal To, Greater Than, Less Than or Equal To, Less Than, or Not Equal.
Compared To, Compare Value 1, Compare Value 2, and Right Field Number	Select what the left field number is compared to: Field, Table, or Value. Depending on what you select, the system makes either the Right Field Number or Compare Value 1 and Compare Value 2 fields available for you to enter the appropriate values. Values may be alphanumeric. To indicate an unspecified numeric value, enter #. You only need to enter a value in the Compare Value 2 field if the comparison code is Between. For example, consider CPDF Edit 700.12.3. If pay plan is VN, then step or rate must be between 0 and 28 or asterisks.

This table shows how to set up Edit 560.02.2. If Nature of Action Code is 741, then Prior Pay Rate Determinant must be A, B, E, F, M, U, V, or asterisks.

If/Then Code	Seqnce Nbr	Left Field Number	Comparison Code	Compared to	Compare Value 1	Compare Value 2
If	1	56 Nature of Action Code	Equal to	Value	741	0
Then	1	71 Prior Pay Rate Determinant	Between	Value	A	B
Then	2	71 Prior Pay Rate Determinant	Between	Value	E	F
Then	3	71 Prior Pay Rate Determinant	Equal to	Value	M	0
Then	4	71 Prior Pay Rate Determinant	Between	Value	U	V
Then	5	71 Prior Pay Rate Determinant	Equal to	Value	*	0

Entering Edit Details

Access the OPM CPDF Maint Details page.

Update/Change Number

Indicates the changes received from the CPDF Edit Manual Updates. For example, if you want to change 8 to CPDF Edit Manual Update 13, then enter it as 13.08.

PeopleSoft Edit Location

Specify where this edit is enforced. Options are:

COBOL: the edit is enforced in the COBOL program.

Dynamic: the edit is enforced in the Dynamics SQR.

PeopleCode: the edit is enforced by peoplecode.

Prompt Tbl(Prompt Table): the edit is enforced by a prompt table.

Shared Pgm (Shared Program): the edit is enforced by the FGHR019S.SQR program.

Status: the edit is enforced in the Status SQR.

Table Edit: the edit is enforced on this page.

Processing CPDF Files

This section provides an overview of CPDF reporting requirements and discusses how to:

Define additional CPDF reporting controls
Produce the CPDF files.
Generate the CPDF Edit Errors Report.
Process the Dynamics table.
Process the CPDF Status table.
Generate the Dynamic/Status flat file submissions.
Update CPDF edits.
Process the CPDF Organizational Component Translations file submission.

Understanding CPDF Reporting Requirements

Most agencies in the executive branch of the U.S. federal government—and selected agencies in the legislative branch—participate in the CPDF. CPDF edits provide the OPM with the means to standardize federal government personnel data, monitor quality of data provided by federal government agencies, and produce a series of government-wide reports.

Because you must comply with government requirements when filing CPDF reports, PeopleSoft Enterprise Human Resources Management contains reports with appropriate information in the standard federal reporting format.

The edit submissions are:

CPDF Status submission.

This submission includes a single record for each active employee. It shows the current status of each employee as of the end date of the submission period. The OPM requires a quarterly status file submission in March, June, September, and December.
CPDF Dynamic submission.

This submission consists of all personnel actions processed by the PeopleSoft system during the reporting period. The normal reporting period is the calendar month; however, the period may end as of the last full pay period of the month. Actions that are more than two years past the current effective date or more than six months ahead of the current effective date aren’t reported.
Organizational Component Translations (OCT) submission.

This submission consists of the organizational segments of the agency. The OPM requires that an agency submit this file semi-annually in March and September.

When executing the CPDF error processing, the system uses the CPDF edit processing rules as mandated by the OPM. Then, in the CPDF edit processing, it identifies the fields and records that don’t meet the OPM's quality standards.

Note. For administering CPDF edits, understanding how they apply to your agency, and running the related reports, this discussion assumes that you are familiar with the Federal Workforce Reporting Systems Operating Manual and have a working knowledge of the CPDF edits and processes.

See Also

U.S. Federal Government, Federal Workforce Reporting Systems Operating Manual

Pages Used to Process CPDF Files

Page Name	Object Name	Navigation	Usage
CPDF Edits Processing (Central Personnel Data File edits processing)	RUNCTL_FGCPDF	Workforce Monitoring, Meet Regulatory Rqmts, CPDF Processing USF, Edit Validation, CPDF Edits Processing	Generate a table of the CPDF edit errors found in the CPDF Status and Dynamic tables.
CPDF Dynamic Table (Central Personnel Data File dynamic table)	RUNCTL_FGHR019A	Workforce Monitoring, Meet Regulatory Rqmts, CPDF Processing USF, Dynamic Table, CPDF Dynamic Table	Generate the Dynamics working table containing employee information. This is eventually used to create the Dynamics submission flat file.
CPDF Dynamic/Status File Generation (Central Personnel Data File dynamic/status file generation)	RUNCTL_FGHR019C	Workforce Monitoring, Meet Regulatory Rqmts, CPDF Processing USF, Dynamic/Status File, CPDF Dynamic/Status File Generation	Generate the Dynamic file, Status file, or both, or the Status file for submission to the OPM.
CPDF Org. Comp. File (Central Personnel Data File organizational component file)	RUNCTL_FGHR019D	Workforce Monitoring, Meet Regulatory Rqmts, CPDF Processing USF, Organizational Component File, CPDF Org. Comp. File	Report on codes, titles, and hierarchical relationships for organizations within an agency as of the end of the reporting period.
CPDF Status Table ( Central Personnel Data File status table)	RUNCTL_FGHR019E	Workforce Monitoring, Meet Regulatory Rqmts, CPDF Processing USF, Status Table, CPDF Status Table	Generate the Status working table containing employee information. This is eventually used to create the Status submission flat file.
Run CPDF Error Report (run Central Personnel Data File error report)	RUNCTL_FGHR019B	Workforce Monitoring, Meet Regulatory Rqmts, CPDF Processing USF, Error Report, Run CPDF Error Report	Run the CPDF Error report (FGHR019B). This report lists the CPDF errors identified by the CPDF Validation process.

Defining Additional CPDF Reporting Controls

Before you begin to run the CPDF reporting process, you will need to ensure that certain codes are correctly defined so that they are included with your submissions. This table describes the data and where you enter it in the system.

Data	Page
Indicate if earnings are reported to the CPDF.	Earnings Table 1
Indicate the CPDF earnings type to identify retention allowance, supervisory differential, or staffing differential code types.	Earnings Table 1
Indicate whether the subagency should report its employees to the CPDF.	Sub-Agency Table
Indicate whether or not the personnel action should be reported to the CPDF.	Nature of Action (NOA) Code Table

Producing the CPDF Files

To produce the CPDF files:

Generate the CPDF Dynamic table (monthly) or generate the CPDF Status table (quarterly).
Perform CPDF edit validation processing.
Produce the CPDF Error report.

Review and clean up the data errors identified in the error report. Repeat the processes in steps 1 through 3 until the data satisfactorily meets your organizational reporting standards.
Generate the CPDF Dynamic/Status flat file.
Generate the CPDF Organizational Component Translation submission.

Note. Processing CPDF edits deletes existing data in the CPDF Error table before adding new records. If you need to save existing CPDF Error table data, back up the table before running this process.

Generating the CPDF Edit Errors Report

Access the CPDF Edits Processing page.

Validate CPDF Data

Select Validate CPDF Status Data or Validate CPDF Dynamic Data to create the respective files.

Run

Click this button to process CPDF edits.

Processing the Dynamics Table

Access the CPDF Dynamic Table page.

Generating the CPDF Dynamic table enables you to run the CPDF Edits process against the table and generate the CPDF Dynamic submission. You must generate the CPDF Dynamic table in order to continue processing the CPDF Dynamic edits.

Note. The process deletes any existing data in the CPDF Dynamic table before adding any new records. To save existing CPDF Dynamic table data, you must back up the table before running this process.

As Of Date	Select to define the transactions selected by the CPDF Dynamic Table process. The process selects all transactions with an effective date two years before and six months after the as of date.
Start Date	Enter the starting date when the program should select personnel actions that were last worked on or modified. This field is based on the tracking date from the personnel action.
End Date	Enter the ending date when the program should select personnel actions that were last worked on or modified. This field is based on the tracking date from the personnel action.
Work-in-Progress Status	Select any work-in-progress status for reporting on the CPDF Dynamic table. For a CPDF submission, select PRO (Processed by Human Resources.

Processing the CPDF Status Table

Access the CPDF Status Table page.

You must first generate the CPDF Status table in order to perform the CPDF status edits processing. Generation of the CPDF Status table enables you to run the CPDF edits process against the table and create the CPDF status submission.

Note. This process deletes existing data in the CPDF Status table before adding new records. If the organization needs to retain and save existing CPDF Status table data, you must back up the table before running this process.

As Of Date

Select to restrict your selection to those employees active on that date.

Generating the Dynamic/Status Flat File Submissions

Access the CPDF File Generation page.

The CPDF Dynamic/Status File Generation process builds the CPDF status and dynamic submissions. The process generates these flat files from the CPDF Status table and CPDF Dynamic table, respectively. If the process finds that field defaults are necessary, it uses the CPDF field default table to supply the values.

You must have already entered agency parameters before using this page.

CPDF Dynamic File and CPDF Status File

Select one or both of these fields to generate the correct submission file.

Updating CPDF Edits

When you receive CPDF Edit Manual Updates from the OPM, you must maintain the edits in your system.

Processing the CPDF Organizational Component Translations File Submission

Access the CPDF Org. Comp. File page.

The CPDF OCT consists of codes, titles, and hierarchical relationships for organizations within an agency as of the end of the reporting period. The OCT is reported twice a year, in March and September, and must match the organizational component codes used in the employee records in status submissions for the agency.

You must have already set up agency and language parameters before using this page.

As Of Date

Select so that the file contains organizational components that are effective for a given date.

Submitting Parent Locator Information

Government agencies are required by law to send a biweekly and quarterly file containing data on new hires to the Federal Parent Locator Service, a part of the Social Security Administration. The Federal Parent Locator Service uses the data to track and enforce child support payments.

To submit parent locator information:

Create an interface file using the New Hire Reporting run control page.
Send the file to the Social Security Administration.

You will receive the file back from the Social Security Administration.
Process the file received from the Social Security Administration using the New Hire Error Reporting run control page.

The report created by this process lists errors that were sent previously so that they can be corrected for the next time you send the file.

At any point in the process, you can use the New Hire Reporting Stats page to view statistics about the new hire data exports.

Page Used to View New Hire Data Export Statistics

Page Name	Object Name	Navigation	Usage
New Hire Control	GVT_NH_CONTROL	Workforce Monitoring, Meet Regulatory Rqmts, Review New Hire Stats USF, New Hire Control	Display statistical information about new hire data exports generated by the New Hire Reporting report.

See Also

Meet Regulatory Requirements Reports

Running EEO Reports

This section discusses how to run the EEO reports that are for U.S. federal government users only.

See Also

Setting Up EEO Reporting Requirements

Pages Used to Run EEO Reports

Page Name	Object Name	Navigation	Usage
EEO Groups by PATCOB/POI	RUNCTL_FGHR012	Workforce Monitoring, Meet Regulatory Rqmts, EEO Reports, EEO Groups by PATCOB/POI USF, EEO Groups by PATCOB/POI	Run the EEO Groups by PATCOB/POI report (FGHR012A), which details the distribution of EEO groups and comparison by PATCOB and POI.
EEO Groups by PATCOB/SubAgency	RUNCTL_FGHR012	Workforce Monitoring, Meet Regulatory Rqmts, EEO Reports, EEO Grps by PATCOB/SubAgcy USF, EEO Groups by PATCOB/SubAgency	Run the EEO Groups by PATCOB/SubAgency report (FGHR012B) to see the distribution of EEO groups and comparison by PATCOB and sub-agency.
EEO Groups by Series/POI	RUNCTL_FGHR014	Workforce Monitoring, Meet Regulatory Rqmts, EEO Reports, EEO Groups by Series/POI USF, EEO Groups by Series/POI	Run the EEO Groups by Series/POI report (FGHR014A). This report details the distribution of EEO groups and comparison by occupation and POI.
EEO Groups by Series/SubAgency	RUNCTL_FGHR014	Workforce Monitoring, Meet Regulatory Rqmts, EEO Reports, EEO Grps by Series/SubAgcy USF, EEO Groups by Series/SubAgency	Run the EEO Groups by Series/SubAgency report (FGHR014B), which details the distribution of EEO groups and comparison by series and sub-agency.

Running VETS Reports

This section discusses how to run the VETS reports that are for U.S. federal government users only.

See Also

Meeting VETS-100 Reporting Requirements

Page Used to Run VETS Reports

Page Name	Object Name	Navigation	Usage
VETS-100 by POI	RUNCTL_FGHR013	Workforce Monitoring, Meet Regulatory Rqmts, VETS-100 Reports, VETS-100 by POI USF	Run the VETS-100 by POI report (FGHR013B), which generates a veterans employment report by POI.
VETS-100 by SubAgency	RUNCTL_FGHR013	Workforce Monitoring, Meet Regulatory Rqmts, VETS-100 Reports, VETS-100 by SubAgency	Run the VETS-100 by SubAgency report (FGHR013A), which generates a veterans employment report by sub-agency.

Running the Monthly Report of Federal Civilian Employment (SF113-A) and Full-time Equivalent/Work-Year Civilian Employment (SF113-G) Reports

This section discusses how to run the SF113–G report.

Pages Used to Run SF113-A and SF113-G Reports

Page Name	Object Name	Navigation	Usage
SF113-A Report	RUN_FGSF113A	Workforce Monitoring, Meet Regulatory Rqmts, Regulatory Reports, SF113-A USF, SF113-A Report	Run the SF113-A report (FGSF113A), which generates a monthly report of federal civilian employment.
SF113-G Report	RUN_FGSF113G	Workforce Monitoring, Meet Regulatory Rqmts, Regulatory Reports, SF113-G USF, SF113-G Report	Run the SF113-G report (FGSF113G), which generates a monthly report of full-time equivalent and work-year civilian employment.

Running the SF113-G Report

Access the SF113-G Report page.

SF-113G Authorized Ceiling

If you enter a value here, it is included in the Ceiling column of the report. This field is optional but recommended if you want to report an employee on the SF-113G report.

Field Number	Each CPDF field is assigned a field number. The OPM specifies most of the field numbers, however, there are occasions where formatting information is included in the table for fields not specified by the OPM. These special fields are assigned decreasing numbers starting with 999 (i.e., 999, 998, 997, etc.) while the OPM-specified fields are assigned increasing numbers starting with 1.
Field Name	Enter the field name that corresponds to the field number as it is referenced in the CPDF programs.
Field Type	Define the field type. Values are Char (character), Date, and Number. This field is for informational purposes only at this time.
Field Length	Enter the length of the field as it needs to be reported the OPM. The system uses this field to verify the length of the formatted data before writing to the Dynamics and Status working tables.
Status Start Position	This field is reserved for future use.
Dynamic Start Position	This field is reserved for future use.
Default Field Value (File)	Enter the value that you want this field to contain in the case of NULL data during flat file generation.
Default Field Value (Table)	Enter the value that you want this field to contain in the case of NULL data during Dynamics and Status working table creation.
Pad Field	Enter the type of field padding. Options are Left, Right, or No Padding. If you select Left or Right, provide a pad character.
Pad Character	If a field is to be padded, enter the character used for padding. For example, you might use 0 to left pad a numeric field.
Truncate Field?	Specify whether a field should be truncated by selecting Yes or No. Data will be truncated if the content exceeds the field length.
Edit Mask	Provide an edit mask for field formatting the CPDF tables. CPDF programs support all the standard edit masks available in Structured Query Reports.

Validate CPDF Data	Select Validate CPDF Status Data or Validate CPDF Dynamic Data to create the respective files.
Run	Click this button to process CPDF edits.