[Home] [Help] [Dependency Information]
Object Name: | HRI_MB_ABV# |
---|---|
Object Type: | VIEW |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
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#;
|
|
|