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_JOB_GROUPS

Object Details

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

PER_JOB_GROUPS is used to group records contained in PER_JOBS. Each Job Group has to be within a business group unless the profile option HR: Cross Business Group Profile is set to 'N' in which case a Job Group can have a NULL Business Group (considered to be a Global Job Group). Jobs in Global Job Groups can be viewed across the system. All HR jobs, i.e., those jobs used within the HRMS system, must be defined within a 'Default HR Job Group'. The default HR Job Group is created at the same time a Business Group is created.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_JOB_GROUPS_PK

JOB_GROUP_ID

Unique Key: PER_JOB_GROUPS_UK1

INTERNAL_NAME
BUSINESS_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_JOB_GROUPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	JOB_GROUP_ID
PER_JOB_GROUPS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INTERNAL_NAME BUSINESS_GROUP_ID
PER_JOB_GROUPS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PER_JOB_GROUPS	HR_ALL_ORGANIZATION_UNITS	PER_JOB_GROUPS BUSINESS_GROUP_ID
PER_JOBS	PER_JOB_GROUPS	PER_JOBS JOB_GROUP_ID
PER_ROLES	PER_JOB_GROUPS	PER_ROLES JOB_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
JOB_GROUP_ID	NUMBER	(15)	Yes	System generated primary key
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to PER_JOB_DEFINITIONS
LEGISLATION_CODE	VARCHAR2	(30)		The legislation to which the Job Group applies.
INTERNAL_NAME	VARCHAR2	(30)	Yes	The name of the Job Group held internally on the system. This name cannot be updated once the job group has been created.
DISPLAYED_NAME	VARCHAR2	(30)	Yes	The name displayed on any form or report. The user can update this name after the Job Group has been created.
ID_FLEX_NUM	NUMBER	(15)	Yes	The key flex field that all jobs created within this job group should use
MASTER_FLAG	VARCHAR2	(1)		Certain jobs can be defined as 'Master Jobs' which some organizations use as a 'template' for other jobs of the same level or grade.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System generated version of row. Increments by one for each update
CREATION_DATE	DATE			Standard WHO column
CREATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column

Query Text

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


SELECT JOB_GROUP_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      INTERNAL_NAME
,      DISPLAYED_NAME
,      ID_FLEX_NUM
,      MASTER_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM HR.PER_JOB_GROUPS;

Dependencies

[top of page]

HR.PER_JOB_GROUPS does not reference any database object

HR.PER_JOB_GROUPS is referenced by following:

APPS: PER_JOB_GROUPS; PER_JOB_GROUPS_WHO
PUBLIC: PER_JOB_GROUPS