[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Table | |
Foreign Table | Foreign Key Column | PER_NUMBER_GENERATION_CONTROLS | HR_ALL_ORGANIZATION_UNITS | PER_NUMBER_GENERATION_CONTROLS BUSINESS_GROUP_ID |
---|
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. |
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;
HR.PER_NUMBER_GENERATION_CONTROLS does not reference any database object
HR.PER_NUMBER_GENERATION_CONTROLS is referenced by following:
|
|
|