[Home] [Help] [Dependency Information]
Object Name: | HRI_TO_WMV_SEP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_INDICATOR | NUMBER | |||
LOSS_SEP_INDICATOR | NUMBER | |||
LOSS_ASG_INDICATOR | NUMBER | |||
LOSS_LTA_INDICATOR | NUMBER | |||
WMT_METRIC | NUMBER | |||
ACTIVE_INDICATOR | NUMBER | |||
LTA_INDICATOR | NUMBER | |||
EMP_INDICATOR | NUMBER | |||
PRIM_ASG_INDICATOR | NUMBER | |||
MEASURE_CALC_DATE | DATE | Yes | ||
EVENT_DATE | DATE | |||
SEPARATION_CATEGORY_CODE | VARCHAR2 | (30) | ||
SEPARATION_REASON_CODE | VARCHAR2 | (30) | ||
CHANGE_REASON_CODE | VARCHAR2 | (30) | ||
PERSON_ID | NUMBER | (10) | Yes | |
ASSIGNMENT_FROM_ID | NUMBER | (10) | Yes | |
BUSINESS_GROUP_FROM_ID | NUMBER | (15) | Yes | |
ORGANIZATION_FROM_ID | NUMBER | (15) | Yes | |
SUPERVISOR_PERSON_FROM_ID | NUMBER | |||
LOCATION_FROM_ID | NUMBER | |||
GEO_AREA_FROM_CODE | VARCHAR2 | (60) | Yes | |
GEO_COUNTRY_FROM_CODE | VARCHAR2 | (100) | Yes | |
GEO_REGION_FROM_CODE | VARCHAR2 | (252) | Yes | |
JOB_FROM_ID | NUMBER | |||
GRADE_FROM_ID | NUMBER | |||
POSITION_FROM_ID | NUMBER | |||
PRIMARY_FROM_FLAG_CODE | VARCHAR2 | (30) | ||
ASSIGNMENT_TYPE_FROM_CODE | VARCHAR2 | (1) | Yes | |
ASSIGNMENT_STATUS_TYPE_FROM_ID | NUMBER | (9) | Yes | |
PER_SYSTEM_STATUS_FROM_CODE | VARCHAR2 | (30) | ||
PAY_SYSTEM_STATUS_FROM_CODE | VARCHAR2 | (1) | ||
WMT_CODE | VARCHAR2 | (30) | Yes | |
LOW_MONTHS_LOSS_SEP | NUMBER | |||
LAST_CHANGE_DATE | DATE | |||
HR_SECURITY_FLAG_CODE | CHAR | (1) | ||
BG_SECURITY_FLAG_CODE | CHAR | (1) | ||
EVENT_FII_TIME_YEAR_ID | NUMBER | |||
EVENT_FII_TIME_SEMIYEAR_ID | VARCHAR2 | (5) | ||
EVENT_FII_TIME_QTR_ID | NUMBER | |||
EVENT_FII_TIME_BIMONTH_ID | VARCHAR2 | (44) | ||
EVENT_FII_TIME_MONTH_ID | NUMBER | |||
EVENT_FII_TIME_DAY_ID | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_INDICATOR
, LOSS_SEP_INDICATOR
, LOSS_ASG_INDICATOR
, LOSS_LTA_INDICATOR
, WMT_METRIC
, ACTIVE_INDICATOR
, LTA_INDICATOR
, EMP_INDICATOR
, PRIM_ASG_INDICATOR
, MEASURE_CALC_DATE
, EVENT_DATE
, SEPARATION_CATEGORY_CODE
, SEPARATION_REASON_CODE
, CHANGE_REASON_CODE
, PERSON_ID
, ASSIGNMENT_FROM_ID
, BUSINESS_GROUP_FROM_ID
, ORGANIZATION_FROM_ID
, SUPERVISOR_PERSON_FROM_ID
, LOCATION_FROM_ID
, GEO_AREA_FROM_CODE
, GEO_COUNTRY_FROM_CODE
, GEO_REGION_FROM_CODE
, JOB_FROM_ID
, GRADE_FROM_ID
, POSITION_FROM_ID
, PRIMARY_FROM_FLAG_CODE
, ASSIGNMENT_TYPE_FROM_CODE
, ASSIGNMENT_STATUS_TYPE_FROM_ID
, PER_SYSTEM_STATUS_FROM_CODE
, PAY_SYSTEM_STATUS_FROM_CODE
, WMT_CODE
, LOW_MONTHS_LOSS_SEP
, LAST_CHANGE_DATE
, HR_SECURITY_FLAG_CODE
, BG_SECURITY_FLAG_CODE
, EVENT_FII_TIME_YEAR_ID
, EVENT_FII_TIME_SEMIYEAR_ID
, EVENT_FII_TIME_QTR_ID
, EVENT_FII_TIME_BIMONTH_ID
, EVENT_FII_TIME_MONTH_ID
, EVENT_FII_TIME_DAY_ID
FROM APPS.HRI_TO_WMV_SEP_V;
|
|
|