[Home] [Help] [Dependency Information]
Object Name: | HRI_MB_ABV |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_MB_ABV_PK | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
ASSIGNMENT_ID
DATE_FROM DATE_TO |
HRI_MB_ABV_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | GRADE_ID |
HRI_MB_ABV_N10 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | POSITION_ID |
HRI_MB_ABV_N11 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | RECRUITER_ID |
HRI_MB_ABV_N12 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SET_OF_BOOKS_ID |
HRI_MB_ABV_N13 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SUPERVISOR_ID |
HRI_MB_ABV_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | JOB_ID |
HRI_MB_ABV_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | LOCATION_ID |
HRI_MB_ABV_N4 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | ORGANIZATION_ID |
HRI_MB_ABV_N5 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | PAYROLL_ID |
HRI_MB_ABV_N6 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | PAY_BASIS_ID |
HRI_MB_ABV_N7 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | PEOPLE_GROUP_ID |
HRI_MB_ABV_N8 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | PERIOD_OF_SERVICE_ID |
HRI_MB_ABV_N9 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | PERSON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | (15) | ||
DATE_FROM | DATE | |||
DATE_TO | DATE | |||
FTE_VALUE | NUMBER | |||
HEAD_VALUE | NUMBER | |||
HOURS_VALUE | NUMBER | |||
MONEY_VALUE | NUMBER | |||
PFT_VALUE | NUMBER | |||
USER1_VALUE | NUMBER | |||
USER2_VALUE | NUMBER | |||
USER3_VALUE | NUMBER | |||
USER4_VALUE | NUMBER | |||
USER5_VALUE | NUMBER | |||
PERSON_ID | NUMBER | (10) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
GRADE_ID | NUMBER | (15) | ||
POSITION_ID | NUMBER | (15) | ||
PAYROLL_ID | NUMBER | (9) | ||
PAY_BASIS_ID | NUMBER | (9) | ||
PEOPLE_GROUP_ID | NUMBER | (15) | ||
SUPERVISOR_ID | NUMBER | (10) | ||
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | (9) | ||
RECRUITER_ID | NUMBER | (10) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
PERIOD_OF_SERVICE_ID | NUMBER | (10) | ||
EMPLOYMENT_CATEGORY | VARCHAR2 | (30) | ||
PRIMARY_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, DATE_FROM
, DATE_TO
, FTE_VALUE
, HEAD_VALUE
, HOURS_VALUE
, MONEY_VALUE
, PFT_VALUE
, USER1_VALUE
, USER2_VALUE
, USER3_VALUE
, USER4_VALUE
, USER5_VALUE
, PERSON_ID
, BUSINESS_GROUP_ID
, ORGANIZATION_ID
, LOCATION_ID
, JOB_ID
, GRADE_ID
, POSITION_ID
, PAYROLL_ID
, PAY_BASIS_ID
, PEOPLE_GROUP_ID
, SUPERVISOR_ID
, ASSIGNMENT_STATUS_TYPE_ID
, RECRUITER_ID
, SET_OF_BOOKS_ID
, PERIOD_OF_SERVICE_ID
, EMPLOYMENT_CATEGORY
, PRIMARY_FLAG
FROM HRI.HRI_MB_ABV;
HRI.HRI_MB_ABV does not reference any database object
HRI.HRI_MB_ABV is referenced by following:
|
|
|