[Home] [Help] [Dependency Information]
Object Name: | PER_GEN_HIERARCHY_NODES1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
TO_STEP_ID | VARCHAR2 | (150) | ||
FROM_CORPS_ID | VARCHAR2 | (150) | ||
FROM_SENIORITY | VARCHAR2 | (150) | ||
FROM_SENIORITY_UOM | VARCHAR2 | (150) | ||
TO_SENIORITY | VARCHAR2 | (150) | ||
TO_SENIORITY_UOM | VARCHAR2 | (150) | ||
TO_CORPS_ID | VARCHAR2 | (150) | ||
SENIORITY_TYPE | VARCHAR2 | (150) | ||
LOS_YEARS | NUMBER | |||
LOS_MONTHS | NUMBER | |||
LOS_DAYS | NUMBER | |||
REM_CORPS_LOS_YEARS | NUMBER | |||
REM_CORPS_LOS_MONTHS | NUMBER | |||
REM_CORPS_LOS_DAYS | NUMBER | |||
REM_GRADE_LOS_YEARS | NUMBER | |||
REM_GRADE_LOS_MONTHS | NUMBER | |||
REM_GRADE_LOS_DAYS | NUMBER | |||
REM_STEP_LOS_YEARS | NUMBER | |||
REM_STEP_LOS_MONTHS | NUMBER | |||
REM_STEP_LOS_DAYS | NUMBER | |||
GRADE_LADDER_ID | VARCHAR2 | (150) | ||
TO_GRADE_ID | NUMBER | |||
COMMENTS | VARCHAR2 | (150) | ||
UNIT_PERCENTAGE | NUMBER | |||
STATISTICAL_INDICATOR | VARCHAR2 | (150) | ||
ADDITIONAL_AMOUNT_FIRST_CHILD | NUMBER | |||
ADDITIONAL_AMOUNT_FURTH_CHILD | NUMBER | |||
AMOUNT_IF_SINGLE | NUMBER | |||
AMOUNT_IF_MARRIED | NUMBER | |||
AMOUNT_IF_MARRIED_AND_A_CHILD | NUMBER | |||
ADDITIONAL_AMOUNT__THIRD_FURTH | NUMBER | |||
CONCATENATED_SEGMENTS | VARCHAR2 | (3352) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, TO_STEP_ID
, FROM_CORPS_ID
, FROM_SENIORITY
, FROM_SENIORITY_UOM
, TO_SENIORITY
, TO_SENIORITY_UOM
, TO_CORPS_ID
, SENIORITY_TYPE
, LOS_YEARS
, LOS_MONTHS
, LOS_DAYS
, REM_CORPS_LOS_YEARS
, REM_CORPS_LOS_MONTHS
, REM_CORPS_LOS_DAYS
, REM_GRADE_LOS_YEARS
, REM_GRADE_LOS_MONTHS
, REM_GRADE_LOS_DAYS
, REM_STEP_LOS_YEARS
, REM_STEP_LOS_MONTHS
, REM_STEP_LOS_DAYS
, GRADE_LADDER_ID
, TO_GRADE_ID
, COMMENTS
, UNIT_PERCENTAGE
, STATISTICAL_INDICATOR
, ADDITIONAL_AMOUNT_FIRST_CHILD
, ADDITIONAL_AMOUNT_FURTH_CHILD
, AMOUNT_IF_SINGLE
, AMOUNT_IF_MARRIED
, AMOUNT_IF_MARRIED_AND_A_CHILD
, ADDITIONAL_AMOUNT__THIRD_FURTH
, CONCATENATED_SEGMENTS
FROM APPS.PER_GEN_HIERARCHY_NODES1_DFV;
|
|
|