eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PAY_POPULATION_RANGES

Object Details

Object Name:	PAY_POPULATION_RANGES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_POPULATION_RANGES
Subobject Name:
Status:	VALID

PAY_POPULATION_RANGES is used to hold information needed for the
implementation of parallel running of payroll processes. It is not
updateable by users. Each row represents a chunk sized range of
people that can be inserted as assignment actions. Each range also
has an associated chunk number which is used to set the appropriate
value on the assignment action. As each range of people is inserted,
the range row is deleted.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_POPULATION_RANGES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STARTING_PERSON_ID
PAY_POPULATION_RANGES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENDING_PERSON_ID
PAY_POPULATION_RANGES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ACTION_ID CHUNK_NUMBER PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PAYROLL_ACTION_ID	NUMBER	(9)	Yes	Foreign key to PAY_PAYROLL_ACTIONS.
CHUNK_NUMBER	NUMBER	(15)	Yes	Chunk number allocated to the range of people.
STARTING_PERSON_ID	NUMBER	(10)		Foreign key to PER_PEOPLE - start of PERSON_ID range.
ENDING_PERSON_ID	NUMBER	(10)		Foreign key to PER_PEOPLE - end of PERSON_ID range.
RANGE_STATUS	VARCHAR2	(1)	Yes	Status value used for range synchronization.
RAND_CHUNK_NUMBER	NUMBER	(15)		Chunk number allocated for the processing of people
PERSON_ID	NUMBER	(10)		Foreign Key to PER_PEOPLE - PERSON_ID
SOURCE_ID	NUMBER	(10)		Source ID
SOURCE_TYPE	VARCHAR2	(5)		Source Type

Query Text

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


SELECT PAYROLL_ACTION_ID
,      CHUNK_NUMBER
,      STARTING_PERSON_ID
,      ENDING_PERSON_ID
,      RANGE_STATUS
,      RAND_CHUNK_NUMBER
,      PERSON_ID
,      SOURCE_ID
,      SOURCE_TYPE
FROM HR.PAY_POPULATION_RANGES;

Dependencies

[top of page]

HR.PAY_POPULATION_RANGES does not reference any database object

HR.PAY_POPULATION_RANGES is referenced by following:

APPS: PAY_POPULATION_RANGES
PUBLIC: PAY_POPULATION_RANGES