DBA Data[Home] [Help]

VIEW: HRI.HRI_MB_WMV#

Source

View Text - Preformatted

select PRIMARY_ASG_INDICATOR PRIMARY_ASG_INDICATOR, ASG_INDICATOR ASG_INDICATOR, FTE FTE, HEAD HEAD, HOURS HOURS, MONEY MONEY, PFT PFT, USER1 USER1, USER2 USER2, USER3 USER3, USER4 USER4, USER5 USER5, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ASSIGNMENT_ID ASSIGNMENT_ID, 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, SUPERVISOR_ID SUPERVISOR_ID, PAYROLL_ID PAYROLL_ID, PAY_BASIS_ID PAY_BASIS_ID, PEOPLE_GROUP_ID PEOPLE_GROUP_ID, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID, PER_SYSTEM_STATUS_CODE PER_SYSTEM_STATUS_CODE, PAY_SYSTEM_STATUS_CODE PAY_SYSTEM_STATUS_CODE, RECRUITER_ID RECRUITER_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID, EMPLOYMENT_CATEGORY_CODE EMPLOYMENT_CATEGORY_CODE, PRIMARY_FLAG PRIMARY_FLAG, LAST_CHANGE_DATE LAST_CHANGE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "HRI"."HRI_MB_WMV"
View Text - HTML Formatted

SELECT PRIMARY_ASG_INDICATOR PRIMARY_ASG_INDICATOR
, ASG_INDICATOR ASG_INDICATOR
, FTE FTE
, HEAD HEAD
, HOURS HOURS
, MONEY MONEY
, PFT PFT
, USER1 USER1
, USER2 USER2
, USER3 USER3
, USER4 USER4
, USER5 USER5
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ASSIGNMENT_ID ASSIGNMENT_ID
, 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
, SUPERVISOR_ID SUPERVISOR_ID
, PAYROLL_ID PAYROLL_ID
, PAY_BASIS_ID PAY_BASIS_ID
, PEOPLE_GROUP_ID PEOPLE_GROUP_ID
, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, PER_SYSTEM_STATUS_CODE PER_SYSTEM_STATUS_CODE
, PAY_SYSTEM_STATUS_CODE PAY_SYSTEM_STATUS_CODE
, RECRUITER_ID RECRUITER_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, EMPLOYMENT_CATEGORY_CODE EMPLOYMENT_CATEGORY_CODE
, PRIMARY_FLAG PRIMARY_FLAG
, LAST_CHANGE_DATE LAST_CHANGE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "HRI"."HRI_MB_WMV"