VIEW: HRI.HRI_MB_ABV#

Source

View Text - Preformatted

select ASSIGNMENT_ID ASSIGNMENT_ID, DATE_FROM DATE_FROM, DATE_TO DATE_TO, FTE_VALUE FTE_VALUE, HEAD_VALUE HEAD_VALUE, HOURS_VALUE HOURS_VALUE, MONEY_VALUE MONEY_VALUE, PFT_VALUE PFT_VALUE, USER1_VALUE USER1_VALUE, USER2_VALUE USER2_VALUE, USER3_VALUE USER3_VALUE, USER4_VALUE USER4_VALUE, USER5_VALUE USER5_VALUE, PERSON_ID PERSON_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, JOB_ID JOB_ID, GRADE_ID GRADE_ID, POSITION_ID POSITION_ID, PAYROLL_ID PAYROLL_ID, PAY_BASIS_ID PAY_BASIS_ID, PEOPLE_GROUP_ID PEOPLE_GROUP_ID, SUPERVISOR_ID SUPERVISOR_ID, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID, RECRUITER_ID RECRUITER_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY, PRIMARY_FLAG PRIMARY_FLAG from "HRI"."HRI_MB_ABV"

View Text - HTML Formatted

SELECT ASSIGNMENT_ID ASSIGNMENT_ID
, DATE_FROM DATE_FROM
, DATE_TO DATE_TO
, FTE_VALUE FTE_VALUE
, HEAD_VALUE HEAD_VALUE
, HOURS_VALUE HOURS_VALUE
, MONEY_VALUE MONEY_VALUE
, PFT_VALUE PFT_VALUE
, USER1_VALUE USER1_VALUE
, USER2_VALUE USER2_VALUE
, USER3_VALUE USER3_VALUE
, USER4_VALUE USER4_VALUE
, USER5_VALUE USER5_VALUE
, PERSON_ID PERSON_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, JOB_ID JOB_ID
, GRADE_ID GRADE_ID
, POSITION_ID POSITION_ID
, PAYROLL_ID PAYROLL_ID
, PAY_BASIS_ID PAY_BASIS_ID
, PEOPLE_GROUP_ID PEOPLE_GROUP_ID
, SUPERVISOR_ID SUPERVISOR_ID
, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, RECRUITER_ID RECRUITER_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY
, PRIMARY_FLAG PRIMARY_FLAG
FROM "HRI"."HRI_MB_ABV"