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.PER_NUMBER_GENERATION_CONTROLS

Object Details

Object Name:	PER_NUMBER_GENERATION_CONTROLS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_NUMBER_GENERATION_CONTROLS
Subobject Name:
Status:	VALID

PER_NUMBER_GENERATION_CONTROLS stores information about the next value
in a numeric sequence. A row is held for each TYPE within a Business
Group and the NEXT_VALUE item is updated to NEXT_VALUE + 1 each time a
number is used for that TYPE. Sequences are usually used to generate
this type of number, but in this case, if more than one Business Group
existed in the same Oracle HR account, there would be problems with
non contiguous employee/applicant numbers.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_NUMBER_GENERATION_CONT_PK

TYPE
BUSINESS_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_NUMBER_GENERATION_CONT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TYPE BUSINESS_GROUP_ID
PER_NUMBER_GENERATION_CONT_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_NUMBER_GENERATION_CONTROLS		HR_ALL_ORGANIZATION_UNITS	PER_NUMBER_GENERATION_CONTROLS BUSINESS_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TYPE	VARCHAR2	(30)	Yes	Numeric sequence type.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ORGANIZATION_UNITS.
NEXT_VALUE	NUMBER	(30)	Yes	The next value in the sequence.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.

Query Text

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


SELECT TYPE
,      BUSINESS_GROUP_ID
,      NEXT_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_NUMBER_GENERATION_CONTROLS;

Dependencies

[top of page]

HR.PER_NUMBER_GENERATION_CONTROLS does not reference any database object

HR.PER_NUMBER_GENERATION_CONTROLS is referenced by following:

APPS: PER_NUMBER_GENERATION_CONTROLS; PER_NUMBER_GENERATION_CONT_WHO
PUBLIC: PER_NUMBER_GENERATION_CONTROLS