eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.PQP_ANALYZED_ALIEN_DATA#

Source

View Text - Preformatted


select ANALYZED_DATA_ID ANALYZED_DATA_ID, ASSIGNMENT_ID ASSIGNMENT_ID, DATA_SOURCE DATA_SOURCE, TAX_YEAR TAX_YEAR, CURRENT_RESIDENCY_STATUS CURRENT_RESIDENCY_STATUS, NRA_TO_RA_DATE NRA_TO_RA_DATE, TARGET_DEPARTURE_DATE TARGET_DEPARTURE_DATE, TAX_RESIDENCE_COUNTRY_CODE TAX_RESIDENCE_COUNTRY_CODE, TREATY_INFO_UPDATE_DATE TREATY_INFO_UPDATE_DATE, NUMBER_OF_DAYS_IN_USA NUMBER_OF_DAYS_IN_USA, WITHLDG_ALLOW_ELIGIBLE_FLAG WITHLDG_ALLOW_ELIGIBLE_FLAG, RA_EFFECTIVE_DATE RA_EFFECTIVE_DATE, RECORD_SOURCE RECORD_SOURCE, VISA_TYPE VISA_TYPE, J_SUB_TYPE J_SUB_TYPE, PRIMARY_ACTIVITY PRIMARY_ACTIVITY, NON_US_COUNTRY_CODE NON_US_COUNTRY_CODE, CITIZENSHIP_COUNTRY_CODE CITIZENSHIP_COUNTRY_CODE, DATE_8233_SIGNED DATE_8233_SIGNED, DATE_W4_SIGNED DATE_W4_SIGNED, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."PQP_ANALYZED_ALIEN_DATA"

View Text - HTML Formatted

SELECT ANALYZED_DATA_ID ANALYZED_DATA_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, DATA_SOURCE DATA_SOURCE
, TAX_YEAR TAX_YEAR
, CURRENT_RESIDENCY_STATUS CURRENT_RESIDENCY_STATUS
, NRA_TO_RA_DATE NRA_TO_RA_DATE
, TARGET_DEPARTURE_DATE TARGET_DEPARTURE_DATE
, TAX_RESIDENCE_COUNTRY_CODE TAX_RESIDENCE_COUNTRY_CODE
, TREATY_INFO_UPDATE_DATE TREATY_INFO_UPDATE_DATE
, NUMBER_OF_DAYS_IN_USA NUMBER_OF_DAYS_IN_USA
, WITHLDG_ALLOW_ELIGIBLE_FLAG WITHLDG_ALLOW_ELIGIBLE_FLAG
, RA_EFFECTIVE_DATE RA_EFFECTIVE_DATE
, RECORD_SOURCE RECORD_SOURCE
, VISA_TYPE VISA_TYPE
, J_SUB_TYPE J_SUB_TYPE
, PRIMARY_ACTIVITY PRIMARY_ACTIVITY
, NON_US_COUNTRY_CODE NON_US_COUNTRY_CODE
, CITIZENSHIP_COUNTRY_CODE CITIZENSHIP_COUNTRY_CODE
, DATE_8233_SIGNED DATE_8233_SIGNED
, DATE_W4_SIGNED DATE_W4_SIGNED
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."PQP_ANALYZED_ALIEN_DATA"