[Home] [Help] [Dependency Information]
Object Name: | HRI_MD_WMV_LOSS_ORG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Derived Mertic, Workforce Measurement Values for lossess from the perspective of an Organization.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOSS_SEP_INDICATOR | NUMBER | |||
LOSS_ASG_INDICATOR | NUMBER | |||
LOSS_LTA_INDICATOR | NUMBER | |||
LOSS_ORG_INDICATOR | NUMBER | |||
PRIMARY_ASG_INDICATOR | NUMBER | |||
ASG_INDICATOR | NUMBER | |||
FTE | NUMBER | |||
FTE_SEPARATIONS | NUMBER | |||
HEAD | NUMBER | |||
HEAD_SEPARATIONS | NUMBER | |||
HOURS | NUMBER | |||
MONEY | NUMBER | |||
PFT | NUMBER | |||
USER1 | NUMBER | |||
USER2 | NUMBER | |||
USER3 | NUMBER | |||
USER4 | NUMBER | |||
USER5 | NUMBER | |||
EVENT_DATE | DATE | |||
MOVE_EVENT_TYPE_CODE | VARCHAR2 | (13) | ||
GAIN_EVENT_TYPE_CODE | VARCHAR2 | (10) | ||
LOSS_EVENT_TYPE_CODE | VARCHAR2 | (8) | ||
ASSIGNMENT_START_CODE | VARCHAR2 | (6) | ||
ASSIGNMENT_END_CODE | VARCHAR2 | (6) | ||
ORG_CHANGE_TYPE_CODE | VARCHAR2 | (10) | ||
SUP_CHANGE_TYPE_CODE | VARCHAR2 | (10) | ||
LOC_CHANGE_TYPE_CODE | VARCHAR2 | (10) | ||
JOB_CHANGE_TYPE_CODE | VARCHAR2 | (10) | ||
GRADE_CHANGE_TYPE_CODE | VARCHAR2 | (10) | ||
POS_CHANGE_TYPE_CODE | VARCHAR2 | (10) | ||
PRIMARY_FLAG_CHANGE_CODE | VARCHAR2 | (6) | ||
REASON_CODE | VARCHAR2 | (30) | ||
SEPARATION_CATEGORY_CODE | VARCHAR2 | (30) | ||
PERSON_ID | NUMBER | (10) | ||
ASSIGNMENT_FROM_ID | NUMBER | |||
BUSINESS_GROUP_FROM_ID | NUMBER | |||
ORGANIZATION_FROM_ID | NUMBER | |||
SUPERVISOR_PERSON_FROM_ID | NUMBER | |||
LOCATION_FROM_ID | NUMBER | |||
JOB_FROM_ID | NUMBER | |||
GRADE_FROM_ID | NUMBER | |||
POSITION_FROM_ID | NUMBER | |||
PRIMARY_FROM_FLAG_CODE | VARCHAR2 | (30) | ||
ASSIGNMENT_STATUS_TYPE_FROM_ID | NUMBER | |||
PER_SYSTEM_STATUS_FROM_CODE | VARCHAR2 | (30) | ||
PAY_SYSTEM_STATUS_FROM_CODE | VARCHAR2 | (6) | ||
ASSIGNMENT_TO_ID | NUMBER | |||
BUSINESS_GROUP_TO_ID | NUMBER | |||
ORGANIZATION_TO_ID | NUMBER | |||
SUPERVISOR_PERSON_TO_ID | NUMBER | |||
LOCATION_TO_ID | NUMBER | |||
JOB_TO_ID | NUMBER | |||
GRADE_TO_ID | NUMBER | |||
POSITION_TO_ID | NUMBER | |||
PRIMARY_TO_FLAG_CODE | VARCHAR2 | (30) | ||
ASSIGNMENT_STATUS_TYPE_TO_ID | NUMBER | |||
PER_SYSTEM_STATUS_TO_CODE | VARCHAR2 | (30) | ||
PAY_SYSTEM_STATUS_TO_CODE | VARCHAR2 | (6) | ||
LAST_CHANGE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT LOSS_SEP_INDICATOR
, LOSS_ASG_INDICATOR
, LOSS_LTA_INDICATOR
, LOSS_ORG_INDICATOR
, PRIMARY_ASG_INDICATOR
, ASG_INDICATOR
, FTE
, FTE_SEPARATIONS
, HEAD
, HEAD_SEPARATIONS
, HOURS
, MONEY
, PFT
, USER1
, USER2
, USER3
, USER4
, USER5
, EVENT_DATE
, MOVE_EVENT_TYPE_CODE
, GAIN_EVENT_TYPE_CODE
, LOSS_EVENT_TYPE_CODE
, ASSIGNMENT_START_CODE
, ASSIGNMENT_END_CODE
, ORG_CHANGE_TYPE_CODE
, SUP_CHANGE_TYPE_CODE
, LOC_CHANGE_TYPE_CODE
, JOB_CHANGE_TYPE_CODE
, GRADE_CHANGE_TYPE_CODE
, POS_CHANGE_TYPE_CODE
, PRIMARY_FLAG_CHANGE_CODE
, REASON_CODE
, SEPARATION_CATEGORY_CODE
, PERSON_ID
, ASSIGNMENT_FROM_ID
, BUSINESS_GROUP_FROM_ID
, ORGANIZATION_FROM_ID
, SUPERVISOR_PERSON_FROM_ID
, LOCATION_FROM_ID
, JOB_FROM_ID
, GRADE_FROM_ID
, POSITION_FROM_ID
, PRIMARY_FROM_FLAG_CODE
, ASSIGNMENT_STATUS_TYPE_FROM_ID
, PER_SYSTEM_STATUS_FROM_CODE
, PAY_SYSTEM_STATUS_FROM_CODE
, ASSIGNMENT_TO_ID
, BUSINESS_GROUP_TO_ID
, ORGANIZATION_TO_ID
, SUPERVISOR_PERSON_TO_ID
, LOCATION_TO_ID
, JOB_TO_ID
, GRADE_TO_ID
, POSITION_TO_ID
, PRIMARY_TO_FLAG_CODE
, ASSIGNMENT_STATUS_TYPE_TO_ID
, PER_SYSTEM_STATUS_TO_CODE
, PAY_SYSTEM_STATUS_TO_CODE
, LAST_CHANGE_DATE
FROM APPS.HRI_MD_WMV_LOSS_ORG_V;
|
|
|