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

VIEW: APPS.HRI_MD_REC_TIME_EFFICIENCY_V

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

View Type

A Business Intelligence System view


Derived Metric for Recruitment Efficiency.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DAYS_TO_APPLICATION NUMBER

DAYS_TO_ACCEPT NUMBER

DAYS_ACCEPT_TO_HIRE NUMBER

DAYS_TO_HIRE NUMBER

HIRE_DATE DATE

BUSINESS_GROUP_ID NUMBER (15) Yes
GRADE_ID NUMBER

JOB_ID NUMBER

LOCATION_ID NUMBER

MANAGER_ID NUMBER

FK_MANAGER_ID NUMBER (15)
ORGANIZATION_ID NUMBER

FK_ORGANIZATION_ID NUMBER (15)
PEOPLE_GROUP_ID NUMBER

PERSON_ID NUMBER (10) Yes
POSITION_ID NUMBER

RECRUITER_ID NUMBER

REQUISITION_ID NUMBER (15) Yes
VACANCY_ID NUMBER (15) Yes
VACANCY_STATUS_CODE VARCHAR2 (30)
BUDGET_MEASUREMENT_TYPE_CODE VARCHAR2 (30)
VACANCY_CATEGORY_CODE VARCHAR2 (80)
REC_SOURCE_TYPE_CODE VARCHAR2 (30)
Query Text

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


SELECT DAYS_TO_APPLICATION
,      DAYS_TO_ACCEPT
,      DAYS_ACCEPT_TO_HIRE
,      DAYS_TO_HIRE
,      HIRE_DATE
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      JOB_ID
,      LOCATION_ID
,      MANAGER_ID
,      FK_MANAGER_ID
,      ORGANIZATION_ID
,      FK_ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      PERSON_ID
,      POSITION_ID
,      RECRUITER_ID
,      REQUISITION_ID
,      VACANCY_ID
,      VACANCY_STATUS_CODE
,      BUDGET_MEASUREMENT_TYPE_CODE
,      VACANCY_CATEGORY_CODE
,      REC_SOURCE_TYPE_CODE
FROM APPS.HRI_MD_REC_TIME_EFFICIENCY_V;

Dependencies

[top of page]

APPS.HRI_MD_REC_TIME_EFFICIENCY_V references the following:

SchemaAPPS
PL/SQL PackageHRI_BPL_PERSON_TYPE - show dependent code
ViewHRI_MB_APL_ACTIVITY_V
ViewHRI_MB_VACANCY_V
PL/SQL PackageHRI_OPL_RECRUITMENT - show dependent code
SynonymPER_RECRUITMENT_ACTIVITIES
APPS.HRI_MD_REC_TIME_EFFICIENCY_V is referenced by following:

SchemaPUBLIC
SynonymHRI_MD_REC_TIME_EFFICIENCY_V