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

VIEW: APPS.HRBV_PREVIOUS_JOB_USAGES_V

Object Details
Object Name: HRBV_PREVIOUS_JOB_USAGES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Previous job usages (from PER_PREVIOUS_JOB_USAGES table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
START_DATE DATE

Start date.
END_DATE DATE

End date.
PERIOD_YEARS NUMBER (2)
Years.
PERIOD_DAYS NUMBER (3)
Days.
PJU_INFORMATION_CATEGORY VARCHAR2 (30)
Pju information category.
PJU_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
PJU_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
PERIOD_MONTHS NUMBER (2)
Period months.
_DF:PJU CHAR (35)
Descriptive Flexfield Column
PREVIOUS_JOB_USAGE_ID NUMBER (15) Yes Primary key for PER_PREVIOUS_JOB_USAGES.
ASSIGNMENT_ID NUMBER (15) Yes Foreign key to PER_ALL_ASSIGNMENTS_F.
PREVIOUS_JOB_ID NUMBER (15)
Foreign key to PER_PREVIOUS_JOBS.
PREVIOUS_EMPLOYER_ID NUMBER (15)
Foreign key to PER_PREVIOUS_EMPLOYERS.
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
Query Text

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


SELECT START_DATE
,      END_DATE
,      PERIOD_YEARS
,      PERIOD_DAYS
,      PJU_INFORMATION_CATEGORY
,      PJU_INFORMATION1
,      PJU_INFORMATION2
,      PJU_INFORMATION3
,      PJU_INFORMATION4
,      PJU_INFORMATION5
,      PJU_INFORMATION6
,      PJU_INFORMATION7
,      PJU_INFORMATION8
,      PJU_INFORMATION9
,      PJU_INFORMATION10
,      PJU_INFORMATION11
,      PJU_INFORMATION12
,      PJU_INFORMATION13
,      PJU_INFORMATION14
,      PJU_INFORMATION15
,      PJU_INFORMATION16
,      PJU_INFORMATION17
,      PJU_INFORMATION18
,      PJU_INFORMATION19
,      PJU_INFORMATION20
,      PERIOD_MONTHS
,      _DF:PJU
,      PREVIOUS_JOB_USAGE_ID
,      ASSIGNMENT_ID
,      PREVIOUS_JOB_ID
,      PREVIOUS_EMPLOYER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.HRBV_PREVIOUS_JOB_USAGES_V;

Dependencies

[top of page]

APPS.HRBV_PREVIOUS_JOB_USAGES_V references the following:

SchemaAPPS
SynonymPER_PREVIOUS_JOB_USAGES

APPS.HRBV_PREVIOUS_JOB_USAGES_V is not referenced by any database object