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


TABLE: HR.PER_JOBS

Object Details
Object Name: PER_JOBS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_JOBS
Subobject Name:
Status: VALID


PER_JOBS holds jobs that have been defined for a Business Group. The
NAME is a concatenation of key flexfield segments, held in
PER_JOB_DEFINITIONS. Jobs define the role that an employee can
perform in the business group, and they are independent of specific
organizations. Each Job is contained within a Job Group.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_JOBS_PK
  1. ColumnJOB_ID
Unique Key: PER_JOBS_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_JOBS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_ID
PER_JOBS_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnBUSINESS_GROUP_ID
SYS_IL0000043538C00064$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
PER_JOBS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_JOBS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_DEFINITION_ID
PER_JOBS_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_GROUP_ID
PER_JOBS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_INFORMATION4
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_JOBS PER_JOBS_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_JOBS BUSINESS_GROUP_ID
PER_JOBS PER_JOBS_FK2 TablePER_JOB_DEFINITIONS PER_JOBS JOB_DEFINITION_ID
PER_JOBS PER_JOBS_FK3 TablePER_JOB_GROUPS PER_JOBS JOB_GROUP_ID
TableGHR_PA_REQUESTS GHR_PA_REQUESTS_FK6 PER_JOBS GHR_PA_REQUESTS TO_JOB_ID
TableHR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK5 PER_JOBS HR_ALL_POSITIONS_F JOB_ID
TablePAY_ELEMENT_LINKS_F PAY_ELEMENT_LINKS_F_FK2 PER_JOBS PAY_ELEMENT_LINKS_F JOB_ID
TablePAY_JOB_WC_CODE_USAGES PAY_JOB_WC_CODE_USAGES_FK2 PER_JOBS PAY_JOB_WC_CODE_USAGES JOB_ID
TablePAY_WCI_OCCUPATIONS PAY_WCI_OCCUPATIONS_FK2 PER_JOBS PAY_WCI_OCCUPATIONS JOB_ID
TablePER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK5 PER_JOBS PER_ALL_ASSIGNMENTS_F JOB_ID
TablePER_ALL_POSITIONS PER_POSITIONS_FK2 PER_JOBS PER_ALL_POSITIONS JOB_ID
TablePER_ALL_VACANCIES PER_VACANCIES_FK3 PER_JOBS PER_ALL_VACANCIES JOB_ID
TablePER_BUDGET_ELEMENTS PER_BUDGET_ELEMENTS_FK3 PER_JOBS PER_BUDGET_ELEMENTS JOB_ID
TablePER_CAREER_PATH_ELEMENTS PER_CAREER_PATH_ELEMENTS_FK2 PER_JOBS PER_CAREER_PATH_ELEMENTS SUBORDINATE_JOB_ID
TablePER_CAREER_PATH_ELEMENTS PER_CAREER_PATH_ELEMENTS_FK3 PER_JOBS PER_CAREER_PATH_ELEMENTS PARENT_JOB_ID
TablePER_COMPETENCE_ELEMENTS PER_COMPETENCE_ELEMENTS_FK8 PER_JOBS PER_COMPETENCE_ELEMENTS JOB_ID
TablePER_DEPLOYMENT_FACTORS PER_DEPLOYMENT_FACTORS_FK2 PER_JOBS PER_DEPLOYMENT_FACTORS JOB_ID
TablePER_JOB_EVALUATIONS PER_JOB_EVALUATIONS_FK50 PER_JOBS PER_JOB_EVALUATIONS JOB_ID
TablePER_JOB_EXTRA_INFO PER_JOB_EXTRA_INFO_FK2 PER_JOBS PER_JOB_EXTRA_INFO JOB_ID
TablePER_JOB_REQUIREMENTS PER_JOB_REQUIREMENTS_FK50 PER_JOBS PER_JOB_REQUIREMENTS JOB_ID
TablePER_MM_POSITIONS PER_MM_POSITIONS_FK5 PER_JOBS PER_MM_POSITIONS TARGET_JOB_ID
TablePER_ROLES PER_ROLES_FK4 PER_JOBS PER_ROLES JOB_ID
TablePER_VALID_GRADES PER_VALID_GRADES_FK50 PER_JOBS PER_VALID_GRADES JOB_ID
TablePQH_BUDGET_DETAILS PQH_BUDGET_DETAILS_FK4 PER_JOBS PQH_BUDGET_DETAILS JOB_ID
TablePQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK5 PER_JOBS PQH_POSITION_TRANSACTIONS JOB_ID
TablePQH_TXN_JOB_REQUIREMENTS PQH_TXN_JOB_REQUIREMENTS_FK5 PER_JOBS PQH_TXN_JOB_REQUIREMENTS JOB_ID
TablePQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK5 PER_JOBS PQH_WORKSHEET_DETAILS JOB_ID
Columns
Name Datatype Length Mandatory Comments
JOB_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
JOB_DEFINITION_ID NUMBER (15) Yes Foreign key to PER_JOB_DEFINITIONS.
DATE_FROM DATE
Yes Date from which an employee or applicant may be assigned to this job.
DATE_TO DATE

Date after which employees and applicants may no longer be assigned to this job.
NAME VARCHAR2 (700)
Job name, concatenated from the keyflex structure.
REQUEST_ID NUMBER (15)
Standard Who column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
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.
JOB_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column.
JOB_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
JOB_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
JOB_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
BENCHMARK_JOB_FLAG VARCHAR2 (30)
Benchmark Job Flag
BENCHMARK_JOB_ID NUMBER (15)
Benchmark Job Id.
EMP_RIGHTS_FLAG VARCHAR2 (30)
Additional employee rights.
JOB_GROUP_ID NUMBER (15) Yes Foreign key to per_job_groups.
APPROVAL_AUTHORITY NUMBER (38)
Approval Authority used by OAM
COMMENTS CLOB (4000)
General remark.
Query Text

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


SELECT JOB_ID
,      BUSINESS_GROUP_ID
,      JOB_DEFINITION_ID
,      DATE_FROM
,      DATE_TO
,      NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      JOB_INFORMATION_CATEGORY
,      JOB_INFORMATION1
,      JOB_INFORMATION2
,      JOB_INFORMATION3
,      JOB_INFORMATION4
,      JOB_INFORMATION5
,      JOB_INFORMATION6
,      JOB_INFORMATION7
,      JOB_INFORMATION8
,      JOB_INFORMATION9
,      JOB_INFORMATION10
,      JOB_INFORMATION11
,      JOB_INFORMATION12
,      JOB_INFORMATION13
,      JOB_INFORMATION14
,      JOB_INFORMATION15
,      OBJECT_VERSION_NUMBER
,      JOB_INFORMATION16
,      JOB_INFORMATION17
,      JOB_INFORMATION18
,      JOB_INFORMATION19
,      JOB_INFORMATION20
,      BENCHMARK_JOB_FLAG
,      BENCHMARK_JOB_ID
,      EMP_RIGHTS_FLAG
,      JOB_GROUP_ID
,      APPROVAL_AUTHORITY
,      COMMENTS
FROM HR.PER_JOBS;

Dependencies

[top of page]

HR.PER_JOBS does not reference any database object

HR.PER_JOBS is referenced by following:

SchemaHR
ViewPER_JOBS#