VIEW: HR.PQP_ALIEN_TRANSACTION_DATA#

Source

View Text - Preformatted

select ALIEN_TRANSACTION_ID ALIEN_TRANSACTION_ID, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, TAX_YEAR TAX_YEAR, INCOME_CODE INCOME_CODE, WITHHOLDING_RATE WITHHOLDING_RATE, INCOME_CODE_SUB_TYPE INCOME_CODE_SUB_TYPE, EXEMPTION_CODE EXEMPTION_CODE, MAXIMUM_BENEFIT_AMOUNT MAXIMUM_BENEFIT_AMOUNT, RETRO_LOSE_BEN_AMT_FLAG RETRO_LOSE_BEN_AMT_FLAG, DATE_BENEFIT_ENDS DATE_BENEFIT_ENDS, RETRO_LOSE_BEN_DATE_FLAG RETRO_LOSE_BEN_DATE_FLAG, 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, NRA_EXEMPT_FROM_FICA NRA_EXEMPT_FROM_FICA, STUDENT_EXEMPT_FROM_FICA STUDENT_EXEMPT_FROM_FICA, ADDL_WITHHOLDING_FLAG ADDL_WITHHOLDING_FLAG, ADDL_WITHHOLDING_AMT ADDL_WITHHOLDING_AMT, ADDL_WTHLDNG_AMT_PERIOD_TYPE ADDL_WTHLDNG_AMT_PERIOD_TYPE, PERSONAL_EXEMPTION PERSONAL_EXEMPTION, ADDL_EXEMPTION_ALLOWED ADDL_EXEMPTION_ALLOWED, NUMBER_OF_DAYS_IN_USA NUMBER_OF_DAYS_IN_USA, WTHLDG_ALLOW_ELIGIBLE_FLAG WTHLDG_ALLOW_ELIGIBLE_FLAG, TREATY_BEN_ALLOWED_FLAG TREATY_BEN_ALLOWED_FLAG, TREATY_BENEFITS_START_DATE TREATY_BENEFITS_START_DATE, RA_EFFECTIVE_DATE RA_EFFECTIVE_DATE, STATE_CODE STATE_CODE, STATE_HONORS_TREATY_FLAG STATE_HONORS_TREATY_FLAG, YTD_PAYMENTS YTD_PAYMENTS, YTD_W2_PAYMENTS YTD_W2_PAYMENTS, YTD_W2_WITHHOLDING YTD_W2_WITHHOLDING, YTD_WITHHOLDING_ALLOWANCE YTD_WITHHOLDING_ALLOWANCE, YTD_TREATY_PAYMENTS YTD_TREATY_PAYMENTS, YTD_TREATY_WITHHELD_AMT YTD_TREATY_WITHHELD_AMT, 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, CONSTANT_ADDL_TAX CONSTANT_ADDL_TAX, PERSON_ID PERSON_ID, DATE_8233_SIGNED DATE_8233_SIGNED, DATE_W4_SIGNED DATE_W4_SIGNED, ERROR_INDICATOR ERROR_INDICATOR, PREV_ER_TREATY_BENEFIT_AMT PREV_ER_TREATY_BENEFIT_AMT, ERROR_TEXT ERROR_TEXT, 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, FORECAST_INCOME_CODE FORECAST_INCOME_CODE, CURRENT_ANALYSIS CURRENT_ANALYSIS from "HR"."PQP_ALIEN_TRANSACTION_DATA"

View Text - HTML Formatted

SELECT ALIEN_TRANSACTION_ID ALIEN_TRANSACTION_ID
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, TAX_YEAR TAX_YEAR
, INCOME_CODE INCOME_CODE
, WITHHOLDING_RATE WITHHOLDING_RATE
, INCOME_CODE_SUB_TYPE INCOME_CODE_SUB_TYPE
, EXEMPTION_CODE EXEMPTION_CODE
, MAXIMUM_BENEFIT_AMOUNT MAXIMUM_BENEFIT_AMOUNT
, RETRO_LOSE_BEN_AMT_FLAG RETRO_LOSE_BEN_AMT_FLAG
, DATE_BENEFIT_ENDS DATE_BENEFIT_ENDS
, RETRO_LOSE_BEN_DATE_FLAG RETRO_LOSE_BEN_DATE_FLAG
, 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
, NRA_EXEMPT_FROM_FICA NRA_EXEMPT_FROM_FICA
, STUDENT_EXEMPT_FROM_FICA STUDENT_EXEMPT_FROM_FICA
, ADDL_WITHHOLDING_FLAG ADDL_WITHHOLDING_FLAG
, ADDL_WITHHOLDING_AMT ADDL_WITHHOLDING_AMT
, ADDL_WTHLDNG_AMT_PERIOD_TYPE ADDL_WTHLDNG_AMT_PERIOD_TYPE
, PERSONAL_EXEMPTION PERSONAL_EXEMPTION
, ADDL_EXEMPTION_ALLOWED ADDL_EXEMPTION_ALLOWED
, NUMBER_OF_DAYS_IN_USA NUMBER_OF_DAYS_IN_USA
, WTHLDG_ALLOW_ELIGIBLE_FLAG WTHLDG_ALLOW_ELIGIBLE_FLAG
, TREATY_BEN_ALLOWED_FLAG TREATY_BEN_ALLOWED_FLAG
, TREATY_BENEFITS_START_DATE TREATY_BENEFITS_START_DATE
, RA_EFFECTIVE_DATE RA_EFFECTIVE_DATE
, STATE_CODE STATE_CODE
, STATE_HONORS_TREATY_FLAG STATE_HONORS_TREATY_FLAG
, YTD_PAYMENTS YTD_PAYMENTS
, YTD_W2_PAYMENTS YTD_W2_PAYMENTS
, YTD_W2_WITHHOLDING YTD_W2_WITHHOLDING
, YTD_WITHHOLDING_ALLOWANCE YTD_WITHHOLDING_ALLOWANCE
, YTD_TREATY_PAYMENTS YTD_TREATY_PAYMENTS
, YTD_TREATY_WITHHELD_AMT YTD_TREATY_WITHHELD_AMT
, 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
, CONSTANT_ADDL_TAX CONSTANT_ADDL_TAX
, PERSON_ID PERSON_ID
, DATE_8233_SIGNED DATE_8233_SIGNED
, DATE_W4_SIGNED DATE_W4_SIGNED
, ERROR_INDICATOR ERROR_INDICATOR
, PREV_ER_TREATY_BENEFIT_AMT PREV_ER_TREATY_BENEFIT_AMT
, ERROR_TEXT ERROR_TEXT
, 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
, FORECAST_INCOME_CODE FORECAST_INCOME_CODE
, CURRENT_ANALYSIS CURRENT_ANALYSIS
FROM "HR"."PQP_ALIEN_TRANSACTION_DATA"