Flexible Employee Data Report Infotype Table
The following table maps each Flexible Employee Data Report field to the infotype:
| Report Field | Infotype Name/Description | Infotype Number |
|---|---|---|
| 2nd Address Line | Addresses | 0006 |
| 2nd Address Line – Type 5 | Addresses | 0006 |
| 2nd Address Line – Type 9 | Addresses | 0006 |
| ACA Status Code | Planned Working Time | 0007 |
| ACA Status Code Text | Planned Working Time | 0007 |
| Action | Actions | 0000 |
| Action Type | Actions | 0000 |
| Agency Hire Date | Date Specifications | 0041 |
| Agency Service Date | Date Specifications | 0041 |
| Anniversary Date | Date Specifications | 0041 |
| Annual Salary | Basic Pay | 0008 |
| Appointment Date | Date Specifications | 0041 |
| Business Area | Organizational Assignment | 0001 |
| Business Area Code | Organizational Assignment | 0001 |
| Cadet Hire Date | Date Specifications | 0041 |
| Capacity Utility Level | Basic Pay | 0008 |
| Certificate | Education | 0022 |
| City | Addresses | 0006 |
| City – Type 5 | Addresses | 0006 |
| City – Type 9 | Addresses | 0006 |
| Commission Date | Date Specifications | 0041 |
| Compressed Workweek (EE) | Telework/Flex Work (Employee) | 9106 |
| Compressed Workweek (EE) Text | Telework/Flex Work (Employee) | 9106 |
| Compressed Workweek (POS) | Telework/Flex Work (POS) | 9901 |
| Compressed Workweek (POS) Text | Telework/Flex Work (POS) | 9901 |
| Contract Type | Contract Elements | 0016 |
| Cost Center | Organizational Assignment | 0001 |
| Country Key | Addresses | 0006 |
| Country Key – Type 5 | Addresses | 0006 |
| Country Key – Type 9 | Addresses | 0006 |
| County | Addresses | 0006 |
| County – Type 5 | Addresses | 0006 |
| County – Type 9 | Addresses | 0006 |
| Daily Work Hours | Planned Working Time | 0007 |
| Education/training Code | Education | 0022 |
| Education/training Text | Education | 0022 |
| Educational Establishment | Education | 0022 |
| Employee E-mail | Communication | 0105 Subtype 10 |
| Employee Group | Organizational Assignment | 0001 |
| Employee Group Code | Organizational Assignment | 0001 |
| Employee Override Group Name | Add. Withh. Info. US | 0234 |
| Employee Override Group Number | Add. Withh. Info. US | 0234 |
| Employee Subgroup | Organizational Assignment | 0001 |
| Employee Subgroup Code | Organizational Assignment | 0001 |
| Employment Percentage | Planned Working Time | 0007 |
| Employment Status | Actions | 0000 |
| Ethnic Origin Code | Additional Personal Data | 0077 |
| Ethnic Origin Text | Additional Personal Data | 0077 |
| Ethnicity Code | Additional Personal Data | 0077 |
| Ethnicity Text | Additional Personal Data | 0077 |
| First Name | Personal Data | 0002 |
| Flextime (EE) | Telework/Flex Work (Employee) | 9106 |
| Flextime (EE) Text | Telework/Flex Work (Employee) | 9106 |
| Flextime (POS) | Telework/Flex Work (POS) | 9901 |
| Flextime (POS) Text | Telework/Flex Work (POS) | 9901 |
| Flextime Hours From | Telework/Flex Work (Employee) | 9106 |
| Flextime Hours To | Telework/Flex Work (Employee) | 9106 |
| Full Name | Organizational Assignment | 0001 |
| Gender Designation for Health Ins. | Personal Data | 0002 |
| Gender Identity | Personal Data | 0002 |
| Indirect Valuation | Basic Pay | 0008 |
| IRS Mandates | Withholding Info W4/W5 US | 0210 |
| JEV Begin Date | Date Specifications | 0041 |
| JEV End Date | Date Specifications | 0041 |
| Job | Organizational Assignment | 0001 |
| Job Code | Organizational Assignment | 0001 |
| Job Key/Class | Organizational Assignment | 0001 |
| Last Name | Personal Data | 0002 |
| Leave/MWE Approver EE# |
Organizational Management relationships will need to be maintained for data to display. If the employee's position has an A002 Reports to position relationship and the position it reports to has a position to org. unit A012 Manages/B012 Is Managed by relationship and/or position to position A002 Reports/B002 is line supervisor of relationships data will display in the report. If the relationships are not maintained the report will display the Leave/MWE Approver EE# field as 00000000. If the employee's position reports to position is vacant, report will go up the org structure hierarchy and report the next position holder's personnel number as the Leave/MWE Approver +D1:D3EE#. |
|
| Leave/MWE Approver Name |
Organizational Management relationships will need to be maintained for data to display. If the employee's position has an A002 Reports to position relationship and the position it reports to has a position to org. unit A012 Manages/B012 Is Managed by relationship and/or position to position A002 Reports/B002 is line supervisor of relationships data will display in the report. If the relationships are not maintained the report will display the Leave/MWE Approver Name field will be blank. If the employee's position reports to position is vacant, the report will go up the org structure hierarchy and report the next position holder's personnel number as the Leave/MWE Approver Name. |
|
| Leave/MWE Approver Position Number |
Organizational Management relationships will need to be maintained for data to display. If the employee's position has an A002 Reports to position relationship and the position it reports to has a position to org. unit A012 Manages/B012 Is Managed by relationship and/or position to position A002 Reports/B002 is line supervisor of relationships data will display in the report. If the relationships are not maintained the report will display the Leave/MWE Approver Position Number field will be blank. If the employee's position reports to position is vacant, the report will go up the org structure hierarchy and report the next position holder's personnel number as the Leave/MWE Approver Position Number. |
|
| LGBTQ+ | Additional Personal Data | 0077 |
| Manager EE# |
Organizational Management relationships will need to be maintained for data to display. If the employee's position has an A002 Reports to position relationship and the position it reports to has a position to org. unit A012 Manages/B012 Is Managed by relationship and/or position to position A002 Reports/B002 is line supervisor of relationships data will display in the report. If the relationships are not maintained the report will display the Manager EE# field as 00000000. If the position the employee reports to is vacant and there is not A012 Manages/B012 Is Managed relationship the report will display the Manager EE# field will display 00000000. If there is a A012 Manages/B012 Is Managed by relationship on the vacant position the report will go up the org structure hierarchy and report the next position holder's personnel number as the Manager EE#. |
|
| Manager Name |
Organizational Management relationships will need to be maintained for data to display. If the employee's position has an A002 Reports to position relationship and the position it reports to has a position to org. unit A012 Manages/B012 Is Managed by relationship and/or position to position A002 Reports/B002 is line supervisor of relationships data will display in the report. If the relationships are not maintained the report will display the Manager Name field will be blank. If the position the employee reports to is vacant and there is not A012 Manages/B012 Is Managed relationship the report will display the Manager Name field will be blank. If there is a A012 Manages/B012 Is Managed by relationship on the vacant position the report will go up the org structure hierarchy and report the next position holder's name as the Manager Name. |
|
| Manager Position Number |
Organizational Management relationships will need to be maintained for data to display. If the employee's position has an A002 Reports to position relationship and the position it reports to has a position to org. unit A012 Manages/B012 Is Managed by relationship and/or position to position A002 Reports/B002 is line supervisor of relationships data will display in the report. If the relationships are not maintained the report will display the Manager Position Number field will be blank. If the position the employee reports to is vacant and there is not A012 Manages/B012 Is Managed relationship the report will display the Manager Position Number field will be blank. If there is a A012 Manages/B012 Is Managed by relationship on the vacant position the report will go up the org structure hierarchy and report the next position holder's position as the Manager Position Number. |
|
| Middle Name | Personal Data | 0002 |
| Military Spouse | Additional Personal Data | 0077 |
| Monthly Hours | Planned Working Time | 0007 |
| Next Increase Date | Basic Pay | 0008 |
| Office/Region | Addresses | 0006 |
| Office/Region – Type 5 | Addresses | 0006 |
| Office/Region – Type 9 | Addresses | 0006 |
| Old JVAC | Note: this is the old JVAC, not the JVAC on Position Relationships | 1002 |
| Organizational Key | Organizational Assignment | 0001 |
| Organizational Unit | Organizational Assignment | 0001 |
| Organizational Unit Abbreviation | Organizational Assignment | 0001 |
| Organizational Unit Code | Organizational Assignment | 0001 |
| Part-Time Indicator | Planned Working Time | 0007 |
| Pay Scale Area | Basic Pay | 0008 |
| Pay Scale Area Code | Basic Pay | 0008 |
| Pay Scale Group | Basic Pay | 0008 |
| Pay Scale Level | Basic Pay | 0008 |
| Pay Scale Reason | Basic Pay | 0008 |
| Pay Scale Reason Code | Basic Pay | 0008 |
| Pay Scale Type | Basic Pay | 0008 |
| Pay Scale Type Code | Basic Pay | 0008 |
| Payroll Area | Organizational Assignment | 0001 |
| Payroll Area Code | Organizational Assignment | 0001 |
| PD Completed | Date Specifications | 0041 |
| PDP Eval Completed Date | Date Specifications | 0041 |
| PDP Expectations Set Date | Date Specifications | 0041 |
| Personal Holiday Eligible | Date Specifications | 0041 |
| Personnel Area | Organizational Assignment | 0001 |
| Personnel Area Code | Organizational Assignment | 0001 |
| Personnel Number | Organizational Assignment | 0001 |
| Personnel Subarea | Organizational Assignment | 0001 |
| Personnel Subarea Code | Organizational Assignment | 0001 |
| Position Number Long Text | Organizational Assignment | 0001 |
| Position Number | Organizational Assignment | 0001 |
| Position Number Short Text | Organizational Assignment | 0001 |
| Position Security Clearance Code | Job Attributes | 1600 |
| Position Security Clearance Text | Job Attributes | 1600 |
| Position Sensitivity Code | Job Attributes | 1600 |
| Position Sensitivity Text | Job Attributes | 1600 |
| Postal Code | Addresses | 0006 |
| Postal Code – Type 5 | Addresses | 0006 |
| Postal Code – Type 9 | Addresses | 0006 |
| Prior Periodic Increment Date | Date Specifications | 0041 |
| Pro Period Number | Contract Elements | 0016 |
| Pro Period Unit | Contract Elements | 0016 |
| PSLF Date Effective | Additional Personal Data | 0077 |
| PSLF Status | Additional Personal Data | 0077 |
| Race Code and Text | Additional Personal Data | 0077 |
| Rate/Salary per Period | Basic Pay | 0008 |
| Reason Action Code | Actions | 0000 |
| Reason for Action | Actions | 0000 |
| Recommission Date | Date Specifications | 0041 |
| Redaction Indicator | Personal Data | 0002 |
| Retirement Eligible Date | Date Specifications | 0041 |
| Seniority Date | Date Specifications | 0041 |
| Separation Effective Date | Date Specifications | 0041 |
| Spouse/DP Surcharge | Benefits Medical Information | 0376 |
| Spouse/DP Surcharge Text | Benefits Medical Information | 0376 |
| Street/House | Addresses | 0006 |
| Street/House – Type 5 | Addresses | 0006 |
| Street/House – Type 9 | Addresses | 0006 |
| Teamster Seniority Date | Date Specifications | 0041 |
| Telework (EE) | Telework/Flex Work (Employee) | 9106 |
| Telework (EE) Text | Telework/Flex Work (Employee) | 9106 |
| Telework (POS) | Telework/Flex Work (POS) | 9901 |
| Telework (POS) Text | Telework/Flex Work (POS) | 9901 |
| Time Administrator | Organizational Assignment | 0001 |
| Time Management Status | Planned Working Time | 0007 |
| Time Type Override | Planned Working Time | 0007 |
| Time Type Override Text | Planned Working Time | 0007 |
| Tobacco Surcharge | Benefits Medical Information | 0376 |
| Tobacco Surcharge Text | Benefits Medical Information | 0376 |
| Total Basic Pay | Calculated: sum of Wage Type amounts listed on Basic Pay (0008) and added into the Annual Salary. | |
| Transit Card Code | Objects On Loan | 0040 |
| Transit Card Loan Object No. | Objects On Loan | 0040 |
| Transit Card Text | Objects On Loan | 0040 |
| Unbroken Service Date | Date Specifications | 0041 |
| Weekly Work Days | Planned Working Time | 0007 |
| Weekly Work Hours | Planned Working Time | 0007 |
| WMS Review Date | Date Specifications | 0041 |
| Work Contract | Organizational Assignment | 0001 |
| Work Schedule Rule | Planned Working Time | 0007 |
| Workforce Indicator | Based on the Job related to the Position on the employee's Organizational Assignment (0001). The Workforce Indicator is assigned on the Job Relationships (1001). | |
| WSP Badge Number Code | Objects On Loan | 0040 |
| WSP Badge Number Loan Object Number | Objects On Loan | 0040 |
| WSP Badge Number Text | Objects On Loan | 0040 |
| Years of Service | Calculated based on the employee's Anniversary Date on Date Specifications (0041). |