Person
Model – Core Entities
Personal data has been normalized (split) into multiple tables with the
primary table being PERSON
Person Model with Extensions
•
Basic
core portion of the Person Model consists of fields and tables that contain
information about a person, regardless of the person’s role in the organization
•
When
bio/demographic data is updated, all pages and components are updated to the
core Person Model tables
Many of the
v8.0 records still exist with PERSON as the parent
NOTE: Some fields from v8.0 Personal Data have been
moved to effective dated tables from v8.9
Personal
Information
Personal
Data Snapshot Table
•
With
8.9, the PERSONAL_DATA table is no longer used by PeopleSoft
•
PERSONAL_DATA
table remains as a snapshot table for reporting
•
The
PERSONAL_DATA snapshot table is updated in two ways:
•
Automatically
updated via Services Oriented Architecture (SOA)
•
Refresh
Personal Data processes
Core
Person Data Model
PERSON
•
This
is the parent record to over 500 records
•
There
is one record for each Person
•
Fields
that have been moved from Personal Data to PERSON:
•
BIRTHDATE
•
BIRTHPLACE
•
BIRTHCOUNTRY
•
BIRTHSTATE
•
DT_OF_DEATH
New Records
or Fields
PERS_DATA_EFFDT
(effective dated)
•
ALTER_EMPLID
•
FT_STUDENT
•
HIGHEST_EDUC_LVL
•
LANG_CD
•
LASTUPDDTTM
•
LASTUPDOPRID
•
MARITAL_STATUS
•
MAR_STATUS_DT
(new)
•
SEX
PERS_DATA_USA
(effective dated)
•
CITIZEN_PROOF1
•
CITIZEN_PROOF2
•
MEDICARE_ENTLD_DT
•
MILITARY_STATUS
•
US_WORK_ELIGIBILTY
ADDRESS_TYP_TBL
(Formerly a translate value, now a setup table)
(Formerly a translate value, now a setup table)
§ ADDRESS_TYPE
§ ORDER_BY_SEQ
§ ADDR_TYPE_DESCR
§ ADDR_TYPE_SHORT
§ DATA_TYPE_CD
ETHNIC_GRP_TBL
(effective dated)
•
SETID
•
ETHNIC_GRP_CD
•
ETHNIC_CATEGORY
(not used)
•
ETHNIC_GROUP
DIVERS_ETHNIC
•
ETHNIC_GRP_CD
•
PRIMARY_INDICATOR
•
REG_REGION
•
SETID
ETHNICITY_DTL
•
ETHNIC_GRP_CD
•
ETHNIC_PCT_DENMRTR
•
ETHNIC_PCT_NUMRATR
•
REG_REGION
Other
Core Table Changes
Employment
– Now a View
•
PER_ORG_ASGN
•
PER_ORG_INST
•
JOB
JOB –
New Fields
•
HIRE_DT
•
TERMINATION_DT
•
HR_STATUS
XLATTABLE
•
Renamed
to PSXLATDEFN, PSXLATITEM
Read More about Person Model
