DBA Data[Home] [Help] [Dependency Information]

VIEW: HRI.HRI_MB_ABV#

Object Details
Object Name: HRI_MB_ABV#
Object Type: VIEW
Owner: HRI
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

HRI.HRI_MB_ABV# references the following:

SchemaHRI
TableHRI_MB_ABV
HRI.HRI_MB_ABV# is referenced by following:

SchemaAPPS
SynonymHRI_MB_ABV