Loading Personal and Job Data

Personal and job data that is unrelated to a plan belongs in PeopleSoft Human Resources and the Manage Base Benefits business process records.

Conduct your own analysis to determine the data that your plans require. You might use the following tables:

Table	Notable Fields	Comments
PERSON PERS_DATA_EFFDT NAMES ADDRESSES ADDRESS_TYP_TBL	Employee ID, Name, Birth Date, Sex, Marital Status	Assign an employee ID and provide indicative and biographical data. You load these tables first because all employee IDs are edited using these tables.
JOB PER_ORG_ASGN PER_ORG_INST	Company, Department, Location, Job, Action/Reason, Employee Type, Employee Status, Employee Class, Regular/Temporary, Compensation Rate	Many of these fields are important for plan eligibility. This data is effective-dated. Load historical data for the employee's entire career. The action and reason history is important for calculating service and generating earnings and hours.
DEP_BEN DEP_BEN_NAME DEP_BEN_ADDR DEP_BEN_EFF	Name, Sex, Relationship to Employee, Spouse's Birth Date	Identify employees' dependents and beneficiaries.

Table

Notable Fields

Comments

PERSON

PERS_DATA_EFFDT

NAMES

ADDRESSES

ADDRESS_TYP_TBL

Employee ID, Name, Birth Date, Sex, Marital Status

Assign an employee ID and provide indicative and biographical data.

You load these tables first because all employee IDs are edited using these tables.

JOB

PER_ORG_ASGN

PER_ORG_INST

Company, Department, Location, Job, Action/Reason, Employee Type, Employee Status, Employee Class, Regular/Temporary, Compensation Rate

Many of these fields are important for plan eligibility.

This data is effective-dated.

Load historical data for the employee's entire career.

The action and reason history is important for calculating service and generating earnings and hours.

DEP_BEN

DEP_BEN_NAME

DEP_BEN_ADDR

DEP_BEN_EFF

Name, Sex, Relationship to Employee, Spouse's Birth Date

Identify employees' dependents and beneficiaries.