[Home] [Help] [Dependency Information]
Object Name: | HRI_MB_WMV |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
This table holds precollected Assignment Budget Values for a given history of your employee assignments. The table is populated by the concurrent request, HRI Load Assignment Budget Value Hsitory.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_MB_WMV_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
ASSIGNMENT_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
HRI_MB_WMV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERSON_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
HRI_MB_WMV_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRIMARY_ASG_INDICATOR | NUMBER | Primary Assignment Indicator | ||
ASG_INDICATOR | NUMBER | Assignment Indicator | ||
FTE | NUMBER | FTE Value | ||
HEAD | NUMBER | Head Count Value | ||
HOURS | NUMBER | Column reserved for future use | ||
MONEY | NUMBER | Column reserved for future use | ||
PFT | NUMBER | Column reserved for future use | ||
USER1 | NUMBER | Column reserved for future use | ||
USER2 | NUMBER | Column reserved for future use | ||
USER3 | NUMBER | Column reserved for future use | ||
USER4 | NUMBER | Column reserved for future use | ||
USER5 | NUMBER | Column reserved for future use | ||
EFFECTIVE_START_DATE | DATE | Effective Start Date | ||
EFFECTIVE_END_DATE | DATE | Effective End Date | ||
ASSIGNMENT_ID | NUMBER | (15) | Assignment Id | |
PERSON_ID | NUMBER | (10) | Person Id | |
BUSINESS_GROUP_ID | NUMBER | (15) | Business Group Id | |
ORGANIZATION_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
GRADE_ID | NUMBER | (15) | ||
POSITION_ID | NUMBER | (15) | ||
SUPERVISOR_ID | NUMBER | (10) | ||
PAYROLL_ID | NUMBER | (9) | ||
PAY_BASIS_ID | NUMBER | (9) | ||
PEOPLE_GROUP_ID | NUMBER | (15) | ||
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | (9) | Assignment Status Type Id | |
PER_SYSTEM_STATUS_CODE | VARCHAR2 | (30) | Per System Status Code | |
PAY_SYSTEM_STATUS_CODE | VARCHAR2 | (30) | Pay System Status Code | |
RECRUITER_ID | NUMBER | (10) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
PERIOD_OF_SERVICE_ID | NUMBER | (10) | Period Of Service Id | |
EMPLOYMENT_CATEGORY_CODE | VARCHAR2 | (30) | ||
PRIMARY_FLAG | VARCHAR2 | (1) | Primary Flag | |
LAST_CHANGE_DATE | DATE | Standard WHO Column | ||
LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
LAST_UPDATED_BY | NUMBER | Standard WHO Column | ||
CREATED_BY | NUMBER | Standard WHO Column | ||
CREATION_DATE | DATE | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT PRIMARY_ASG_INDICATOR
, ASG_INDICATOR
, FTE
, HEAD
, HOURS
, MONEY
, PFT
, USER1
, USER2
, USER3
, USER4
, USER5
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ASSIGNMENT_ID
, PERSON_ID
, BUSINESS_GROUP_ID
, ORGANIZATION_ID
, LOCATION_ID
, JOB_ID
, GRADE_ID
, POSITION_ID
, SUPERVISOR_ID
, PAYROLL_ID
, PAY_BASIS_ID
, PEOPLE_GROUP_ID
, ASSIGNMENT_STATUS_TYPE_ID
, PER_SYSTEM_STATUS_CODE
, PAY_SYSTEM_STATUS_CODE
, RECRUITER_ID
, SET_OF_BOOKS_ID
, PERIOD_OF_SERVICE_ID
, EMPLOYMENT_CATEGORY_CODE
, PRIMARY_FLAG
, LAST_CHANGE_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM HRI.HRI_MB_WMV;
HRI.HRI_MB_WMV does not reference any database object
HRI.HRI_MB_WMV is referenced by following:
|
|
|