VIEW: MTH.MTH_PERSONNEL_STG#

Source

View Text - Preformatted

select PERSONNEL_PK PERSONNEL_PK, EBS_PERSONNEL_ID EBS_PERSONNEL_ID, EBS_ORGANIZATION_ID EBS_ORGANIZATION_ID, FIRST_NAME FIRST_NAME, LAST_NAME LAST_NAME, SYSTEM_FK SYSTEM_FK, RESOURCE_FK RESOURCE_FK, PERSONNEL_DESCRIPTION PERSONNEL_DESCRIPTION, USER_ATTR1 USER_ATTR1, USER_ATTR2 USER_ATTR2, USER_ATTR3 USER_ATTR3, USER_ATTR4 USER_ATTR4, USER_ATTR5 USER_ATTR5, USER_MEASURE1 USER_MEASURE1, USER_MEASURE2 USER_MEASURE2, USER_MEASURE3 USER_MEASURE3, USER_MEASURE4 USER_MEASURE4, USER_MEASURE5 USER_MEASURE5, SOURCE_ORG_CODE SOURCE_ORG_CODE, PROCESSING_FLAG PROCESSING_FLAG, MIDDLE_NAME MIDDLE_NAME, KNOWN_AS KNOWN_AS, FULL_NAME FULL_NAME, TITLE TITLE, SEX SEX, EMAIL_ADDRESS EMAIL_ADDRESS, WORK_TELEPHONE WORK_TELEPHONE, MOBILE_PHONE_NUMBER MOBILE_PHONE_NUMBER, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE from "MTH"."MTH_PERSONNEL_STG"

View Text - HTML Formatted

SELECT PERSONNEL_PK PERSONNEL_PK
, EBS_PERSONNEL_ID EBS_PERSONNEL_ID
, EBS_ORGANIZATION_ID EBS_ORGANIZATION_ID
, FIRST_NAME FIRST_NAME
, LAST_NAME LAST_NAME
, SYSTEM_FK SYSTEM_FK
, RESOURCE_FK RESOURCE_FK
, PERSONNEL_DESCRIPTION PERSONNEL_DESCRIPTION
, USER_ATTR1 USER_ATTR1
, USER_ATTR2 USER_ATTR2
, USER_ATTR3 USER_ATTR3
, USER_ATTR4 USER_ATTR4
, USER_ATTR5 USER_ATTR5
, USER_MEASURE1 USER_MEASURE1
, USER_MEASURE2 USER_MEASURE2
, USER_MEASURE3 USER_MEASURE3
, USER_MEASURE4 USER_MEASURE4
, USER_MEASURE5 USER_MEASURE5
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, PROCESSING_FLAG PROCESSING_FLAG
, MIDDLE_NAME MIDDLE_NAME
, KNOWN_AS KNOWN_AS
, FULL_NAME FULL_NAME
, TITLE TITLE
, SEX SEX
, EMAIL_ADDRESS EMAIL_ADDRESS
, WORK_TELEPHONE WORK_TELEPHONE
, MOBILE_PHONE_NUMBER MOBILE_PHONE_NUMBER
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
FROM "MTH"."MTH_PERSONNEL_STG"