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

VIEW: APPS.HRFV_PERSON_AGE_ANALYSIS

Object Details
Object Name: HRFV_PERSON_AGE_ANALYSIS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HRFV_PERSON_AGE_ANALYSIS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view shows age band information. Use this in combination with other views
(for example, JOB APPLICATIONS) to perform age analysis. The ages are
calculated as of today's date.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
AGE_LESS_THAN_20 NUMBER


AGE_20_25 NUMBER


AGE_26_30 NUMBER


AGE_31_35 NUMBER


AGE_36_40 NUMBER


AGE_41_45 NUMBER


AGE_46_50 NUMBER


AGE_51_55 NUMBER


AGE_56_60 NUMBER


AGE_61_65 NUMBER


AGE_66_70 NUMBER


AGE_MORE_THAN_70 NUMBER


AGE_UNKNOWN NUMBER

AGE_IN_YEARS NUMBER

BUSINESS_GROUP_ID NUMBER (15) Yes
PERSON_ID NUMBER (10) Yes
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      AGE_LESS_THAN_20
,      AGE_20_25
,      AGE_26_30
,      AGE_31_35
,      AGE_36_40
,      AGE_41_45
,      AGE_46_50
,      AGE_51_55
,      AGE_56_60
,      AGE_61_65
,      AGE_66_70
,      AGE_MORE_THAN_70
,      AGE_UNKNOWN
,      AGE_IN_YEARS
,      BUSINESS_GROUP_ID
,      PERSON_ID
FROM APPS.HRFV_PERSON_AGE_ANALYSIS;

Dependencies

[top of page]

APPS.HRFV_PERSON_AGE_ANALYSIS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_X
SchemaPUBLIC
SynonymDUAL
APPS.HRFV_PERSON_AGE_ANALYSIS is referenced by following:

SchemaPUBLIC
SynonymHRFV_PERSON_AGE_ANALYSIS