[Home] [Help]
[Dependency Information]
[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:
HRI
HRI_MB_WMV#
|
|
|
|