[Home] [Help] [Dependency Information]
Object Name: | HRI_MB_WRK_ACTIVITY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Base Metric view for Workforce Activity.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_INDICATOR | NUMBER | |||
PRIMARY_ASG_INDICATOR | NUMBER | |||
EVENT_DATE | DATE | |||
EFFECTIVE_START_DATE | DATE | |||
EFFECTIVE_END_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 ROW_INDICATOR
, PRIMARY_ASG_INDICATOR
, EVENT_DATE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_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_MB_WRK_ACTIVITY_V;
|
|
|