Tables Used by Human Capital Management Fundamentals

This list includes the primary tables in the JD Edwards EnterpriseOne Human Capital Management Fundamentals system:

Table

Description

Address Book Master (F0101)

Contains name and address information for all employees. This information has a search type of E (Employee).

Employee Master Information (F060116)

Contains detailed information about employees, such as salary, pay grade, birth date, and job type.

Employee Master Additional Information File (F060120)

Contains additional information about each employee.

Employee Master - International Data (F060117)

Contains country-specific information about each employee. The F060117A tag file contains the longer alien registration number field

Future Data EE Master Revisions (F06042)

Contains future changes to employee master records.

Job Information (F08001)

Contains information for job ID and for the job evaluation. The job ID is the combination of the job type and job step.

HR History (F08042)

Contains employee history records for each employee master (F060116) field.

Supplemental Database Setup (F00090)

Contains data types and their respective column headings. Use these data types to specify the types of supplemental information that you want to track for jobs, employees, applicants, and requisitions.

Supplemental Data (F00092)

Contains multiple values with a specific type of data for individual applicants, employees, jobs, and requisitions.

Payroll General Constants (F069096)

Contains default information that applies to all Human Capital Management payroll records in the system. This table also contains default information that applies to specific modules.

HR History Constants (F08040)

Contains default information that applies to all Human Capital Management records in the system. This table also contains default information that applies to specific modules.