Promotions File
The promotions file should contain all individuals who were promoted during the transaction period. Multiple years of promotions data can be used to develop feeders.
IMPORTANT: If an employee was promoted more than once during the transaction period, they should be included in the promotions file for each promotion they attained. The job information from the most recent promotion should match the information in the employee file (or terminations file if the employee was terminated during the transaction period).
NOTE: The content of fields that appear in the employee, job, and/or transaction files should match in all files. Such fields include, but are not limited to, EEO category, all site fields, job code, and job title.
For example, an individual in the promotions file should have the same current job code, job title, and EEO category in the employees file unless they were terminated during the transaction period (in this case, they would not appear in the employee file at all).
The table below lists possible fields for the promotions file. Field names in bold text are required fields for import. Data in the files can contain letters, numbers, or both unless specifically noted.
TIP: Coding your data in accordance with the acceptable values listed below will make importing your data faster and easier. Values that match the acceptable values will automatically map in the Import Data and Map Data stages.
| Field Name | Max Length | Req'd? | Description |
| Promotion Date | 50 | Y |
The date the employee was promoted for the job listed.
NOTE:
Dates can be formatted in any month/day/year format, but cannot contain the time.
|
| Gender | 50 | Y | Employee’s gender. Acceptable gender information is Male or Female. You may also use codes (i.e., M or F). There should be no employee with ”unknown” gender information. |
| Race | 50 | Y | Employee’s race. Acceptable race information is White, African American, Asian, Hispanic, Native American, Native Hawaiian or Pacific Islander, Two or More. You may also use codes (i.e., W, B, H, I, NHOPI, 2+). There should be no employee with ”unknown” race information. |
| Promotion Type | 64 | Y | A value indicating the type of promotion. Acceptable values are Competitive or Non-Competitive. |
| Previous Job Code | 50 | Y | Job code from which the employee was promoted. Job codes in the promotions file should exist in at least one other import file (employee, job or terminations file). |
| Job Code | 50 | Y | Job code to which the employee was promoted. Job codes in the promotions file should exist in at least one other import file (employee, job or terminations file). |
| Previous Job EEO Category | 128 | Y | The EEO Job Classification for the job from which the employee was promoted. |
| Job EEO Category | 128 | Y | The EEO Job Classification for the job to which the employee was promoted. |
| Previous Selection Site Name | 128 | Y | Name of the site where selection decisions are made for the job from which the employee was promoted. |
| Selection Site Name | 128 | Y | Name of the site where the selection decisions are made for the job to which the employee was promoted. |
| Disability | 50 | N |
Whether or not the employee identifies as an individual with a disability (IWD). Acceptable disability information is Yes, No, Did Not Provide. There should be no employee with ”unknown” disability status.
NOTE: This field is not required for import, but it is required if you wish to create reports required by the OFCCP per Section 503 of the Rehabilitation Act.
|
| Protected Veteran | 50 | N |
Whether or not the employee is a protected veteran. Acceptable information is Yes, No, Did Not Provide. There should be no employee with ”unknown” protected veteran status.
NOTE: This field is not required for import, but it is required if you wish to create reports required by the OFCCP per VEVRAA Regulations.
|
| Promotion Identifier | 64 | N | A unique identifier for each employee (i.e., employee personnel ID number). |
| Previous Job Title | 128 | N | The job title associated with the employee’s previous job code. Job titles in the promotions file must match job titles in all other import files (employee, job or terminations file) for the corresponding job code. |
| Job Title | 128 | N | The job title associated with the employee’s current job code. Job titles in the promotions file must match job titles in all other import files (employee, job or terminations file) for the corresponding job code. |
| Previous Selection Site Address Line 1 | 128 | N |
First address line for the selection site from which the employee was promoted.
|
| Previous Selection Site Address Line 2 | 128 | N | Second address line for the selection site from which the employee was promoted. |
| Previous Selection Site City | 128 | N | City in which the selection site is located from which the employee was promoted. |
| Previous Selection Site State | 64 | N | State in which the selection site is located from which the employee was promoted. |
| Previous Selection Site Zip Code | 50 | N | Zip code in which the selection site is located from which the employee was promoted. |
| Selection Site Address Line 1 | 128 | N |
First address line for the selection site.
|
| Selection Site Address Line 2 | 128 | N | Second address line for the selection site. |
| Selection Site City | 128 | N | City in which the selection site is located. |
| Selection Site State | 64 | N | State in which the selection site is located. |
| Selection Site Zip Code | 50 | N | Zip code in which the selection site is located. |
| Last Name | 64 | N | Employee's last name. |
| First Name | 64 | N | Employee's first name. |
| Previous Organizational Unit 1 | 128 | N | Name of the department of the job from which the employee was promoted. |
| Organizational Unit 1 | 128 | N | Name of the department of the job to which the employee was promoted. |
| Previous Organizational Unit 2 | 128 | N | The second largest organizational unit from which the employee was promoted. |
| Organizational Unit 2 | 128 | N | The second largest organizational unit to which the employee was promoted. |
| Previous Organizational Unit 3 | 128 | N | The third largest organizational unit from which the employee was promoted. |
| Organizational Unit 3 | 128 | N | The third largest organizational unit to which the employee was promoted. |
| Previous Organizational Unit 4 | 128 | N | The fourth largest organizational unit from which the employee was promoted. |
| Organizational Unit 4 | 128 | N | The fourth largest organizational unit to which the employee was promoted. |
| Previous Organizational Unit 5 | 128 | N | The fifth largest organizational unit from which the employee was promoted. |
| Organizational Unit 5 | 128 | N | The fifth largest organizational unit to which the employee was promoted. |