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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: HR.PQP_ALIEN_TRANSACTION_DATA#

Object Details

Object Name:	PQP_ALIEN_TRANSACTION_DATA#
Object Type:	VIEW
Owner:	HR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ALIEN_TRANSACTION_ID	NUMBER	(15)	Yes
DATA_SOURCE_TYPE	VARCHAR2	(30)	Yes
TAX_YEAR	NUMBER	(5)
INCOME_CODE	VARCHAR2	(30)	Yes
WITHHOLDING_RATE	NUMBER	(11)
INCOME_CODE_SUB_TYPE	VARCHAR2	(30)
EXEMPTION_CODE	VARCHAR2	(30)
MAXIMUM_BENEFIT_AMOUNT	NUMBER	(11)
RETRO_LOSE_BEN_AMT_FLAG	VARCHAR2	(30)
DATE_BENEFIT_ENDS	DATE
RETRO_LOSE_BEN_DATE_FLAG	VARCHAR2	(30)
CURRENT_RESIDENCY_STATUS	VARCHAR2	(30)
NRA_TO_RA_DATE	DATE
TARGET_DEPARTURE_DATE	DATE
TAX_RESIDENCE_COUNTRY_CODE	VARCHAR2	(30)
TREATY_INFO_UPDATE_DATE	DATE
NRA_EXEMPT_FROM_FICA	VARCHAR2	(30)
STUDENT_EXEMPT_FROM_FICA	VARCHAR2	(30)
ADDL_WITHHOLDING_FLAG	VARCHAR2	(30)
ADDL_WITHHOLDING_AMT	NUMBER	(11)
ADDL_WTHLDNG_AMT_PERIOD_TYPE	VARCHAR2	(30)
PERSONAL_EXEMPTION	NUMBER	(6)
ADDL_EXEMPTION_ALLOWED	NUMBER	(6)
NUMBER_OF_DAYS_IN_USA	NUMBER	(6)
WTHLDG_ALLOW_ELIGIBLE_FLAG	VARCHAR2	(30)
TREATY_BEN_ALLOWED_FLAG	VARCHAR2	(30)
TREATY_BENEFITS_START_DATE	DATE
RA_EFFECTIVE_DATE	DATE
STATE_CODE	VARCHAR2	(30)
STATE_HONORS_TREATY_FLAG	VARCHAR2	(30)
YTD_PAYMENTS	NUMBER	(11)
YTD_W2_PAYMENTS	NUMBER	(11)
YTD_W2_WITHHOLDING	NUMBER	(11)
YTD_WITHHOLDING_ALLOWANCE	NUMBER	(11)
YTD_TREATY_PAYMENTS	NUMBER	(11)
YTD_TREATY_WITHHELD_AMT	NUMBER	(11)
RECORD_SOURCE	VARCHAR2	(30)
VISA_TYPE	VARCHAR2	(30)
J_SUB_TYPE	VARCHAR2	(30)
PRIMARY_ACTIVITY	VARCHAR2	(30)
NON_US_COUNTRY_CODE	VARCHAR2	(30)
CITIZENSHIP_COUNTRY_CODE	VARCHAR2	(30)
CONSTANT_ADDL_TAX	NUMBER	(11)
PERSON_ID	NUMBER	(10)
DATE_8233_SIGNED	DATE
DATE_W4_SIGNED	DATE
ERROR_INDICATOR	VARCHAR2	(30)
PREV_ER_TREATY_BENEFIT_AMT	NUMBER	(11)
ERROR_TEXT	VARCHAR2	(4000)
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes
FORECAST_INCOME_CODE	VARCHAR2	(30)
CURRENT_ANALYSIS	VARCHAR2	(30)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ALIEN_TRANSACTION_ID
,      DATA_SOURCE_TYPE
,      TAX_YEAR
,      INCOME_CODE
,      WITHHOLDING_RATE
,      INCOME_CODE_SUB_TYPE
,      EXEMPTION_CODE
,      MAXIMUM_BENEFIT_AMOUNT
,      RETRO_LOSE_BEN_AMT_FLAG
,      DATE_BENEFIT_ENDS
,      RETRO_LOSE_BEN_DATE_FLAG
,      CURRENT_RESIDENCY_STATUS
,      NRA_TO_RA_DATE
,      TARGET_DEPARTURE_DATE
,      TAX_RESIDENCE_COUNTRY_CODE
,      TREATY_INFO_UPDATE_DATE
,      NRA_EXEMPT_FROM_FICA
,      STUDENT_EXEMPT_FROM_FICA
,      ADDL_WITHHOLDING_FLAG
,      ADDL_WITHHOLDING_AMT
,      ADDL_WTHLDNG_AMT_PERIOD_TYPE
,      PERSONAL_EXEMPTION
,      ADDL_EXEMPTION_ALLOWED
,      NUMBER_OF_DAYS_IN_USA
,      WTHLDG_ALLOW_ELIGIBLE_FLAG
,      TREATY_BEN_ALLOWED_FLAG
,      TREATY_BENEFITS_START_DATE
,      RA_EFFECTIVE_DATE
,      STATE_CODE
,      STATE_HONORS_TREATY_FLAG
,      YTD_PAYMENTS
,      YTD_W2_PAYMENTS
,      YTD_W2_WITHHOLDING
,      YTD_WITHHOLDING_ALLOWANCE
,      YTD_TREATY_PAYMENTS
,      YTD_TREATY_WITHHELD_AMT
,      RECORD_SOURCE
,      VISA_TYPE
,      J_SUB_TYPE
,      PRIMARY_ACTIVITY
,      NON_US_COUNTRY_CODE
,      CITIZENSHIP_COUNTRY_CODE
,      CONSTANT_ADDL_TAX
,      PERSON_ID
,      DATE_8233_SIGNED
,      DATE_W4_SIGNED
,      ERROR_INDICATOR
,      PREV_ER_TREATY_BENEFIT_AMT
,      ERROR_TEXT
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      FORECAST_INCOME_CODE
,      CURRENT_ANALYSIS
FROM HR.PQP_ALIEN_TRANSACTION_DATA#;

Dependencies

[top of page]

HR.PQP_ALIEN_TRANSACTION_DATA# references the following:

HR: PQP_ALIEN_TRANSACTION_DATA

HR.PQP_ALIEN_TRANSACTION_DATA# is referenced by following:

APPS: PQP_ALIEN_TRANSACTION_DATA; PQP_ALIEN_TRANSACTION_DATA_WHO