[Home] [Help] [Dependency Information]
Object Name: | HRFV_PERSON_AGE_ANALYSIS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HRFV_PERSON_AGE_ANALYSIS |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.HRFV_PERSON_AGE_ANALYSIS is not referenced by any database object
|
|
|