[Home] [Help] [Dependency Information]

TABLE: AR.HZ_PER_PROFILES_EXT_SG

Object Details

Object Name:	HZ_PER_PROFILES_EXT_SG
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_PER_PROFILES_EXT_SG
Subobject Name:
Status:	VALID

The HZ_PER_PROFILES_EXT_SG staging table stores person profile tracking data
to use for copying extensions data.

Depending on the HZ: Profile Version Method for Updates profile option
setting, when person profiles are updated, the existing profile record can be
set with an end date, and a new profile record created with the newly entered
information.

Extensions are custom attributes that extend the data model and store
additional information, in this case, for person profile. The Copy Person
Extensions Data for Profile Versioning program uses this staging table to
copy extensions data associated with the old profile identifier and create
new rows associated with the new profile record, in the extensions tables.
This staging table stores identifiers of all old and new profile versions
that need this processing.

For example, the old profile identifier is 123, and there are five rows in
the HZ_PER_PROFILES_EXT tables with extended attribute values for that
profile (the PERSON_PROFILE_ID column is 123). The user updates the profile
information and creates a new version with identifier 456. The extensions
data is still linked to record 123. This staging table would store 123 as the
old identifier and 456 as the new identifier. When the Copy Person Extensions
Data for Profile Versioning program runs, it copies the extensions data for
123 and creates new extensions records with PERSON_PROFILE_ID column as 456.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT OLD_PROFILE_ID
,      NEW_PROFILE_ID
,      WORK_UNIT_NUMBER
,      STATUS
FROM AR.HZ_PER_PROFILES_EXT_SG;

Dependencies

[top of page]

AR.HZ_PER_PROFILES_EXT_SG does not reference any database object

AR.HZ_PER_PROFILES_EXT_SG is referenced by following:

AR

HZ_PER_PROFILES_EXT_SG#