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]

TABLE: HR.PQP_ALIEN_TRANSACTION_DATA

Object Details

Object Name:	PQP_ALIEN_TRANSACTION_DATA
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQP.PQP_ALIEN_TRANSACTION_DATA
Subobject Name:
Status:	VALID

This table stores the Alien treaty analysis data transactions received from Third party vendors.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQP_ALIEN_TRANSACTION_DATA_PK

ALIEN_TRANSACTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_ALIEN_TRANSACTION_DATA_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ALIEN_TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ALIEN_TRANSACTION_ID	NUMBER	(15)	Yes	System generated primary key column
DATA_SOURCE_TYPE	VARCHAR2	(30)	Yes	Name of the third pary that is giving the analyzed data for Alien employees.
TAX_YEAR	NUMBER	(5)		The tax year for which the data is applicable.
INCOME_CODE	VARCHAR2	(30)	Yes	The income code for which the treaty details belong to.
WITHHOLDING_RATE	NUMBER	(11)		The FIT withholding rate for the Alien earning.
INCOME_CODE_SUB_TYPE	VARCHAR2	(30)		The sub type for the income, if applicable
EXEMPTION_CODE	VARCHAR2	(30)		Excemption code for the alien income.
MAXIMUM_BENEFIT_AMOUNT	NUMBER	(11)		Maximum benefit amount for which the tax is not taken.
RETRO_LOSE_BEN_AMT_FLAG	VARCHAR2	(30)		Identifies whether the employee loses treaty benefits retroactively if they earn more than the maximum benefit amount.
DATE_BENEFIT_ENDS	DATE			The date on which the benefit ends.
RETRO_LOSE_BEN_DATE_FLAG	VARCHAR2	(30)		Identifies whether the employee loses treaty benefits retroactively if they continue to stay beyond the date benefit ends date.
CURRENT_RESIDENCY_STATUS	VARCHAR2	(30)		Identifies the current status as resident or non resident.
NRA_TO_RA_DATE	DATE			The date on which the employee becomes a resident from a non-resident.
TARGET_DEPARTURE_DATE	DATE			The date on which the employee is scheduled to leave the country.
TAX_RESIDENCE_COUNTRY_CODE	VARCHAR2	(30)		The two letter tax residence code.
TREATY_INFO_UPDATE_DATE	DATE			The date on which the Alien treaty was updated.
NRA_EXEMPT_FROM_FICA	VARCHAR2	(30)		Y/N value indicating whether the non resident alien is exempt from FICA
STUDENT_EXEMPT_FROM_FICA	VARCHAR2	(30)		Y/N value indicating whether the alien student is exempt from FICA.
ADDL_WITHHOLDING_FLAG	VARCHAR2	(30)		Identifies whether there is any additional withholding.
ADDL_WITHHOLDING_AMT	NUMBER	(11)		Additional withholding amount, considered only if the additional withholding flag is set to Y.
ADDL_WTHLDNG_AMT_PERIOD_TYPE	VARCHAR2	(30)		The period type for which the additional withholding amount is applicable.
PERSONAL_EXEMPTION	NUMBER	(6)		The number of personal excemptions.
ADDL_EXEMPTION_ALLOWED	NUMBER	(6)		Indicates whether the additional exemptions are allowed.
NUMBER_OF_DAYS_IN_USA	NUMBER	(6)		Number of days the employee is in the US.
WTHLDG_ALLOW_ELIGIBLE_FLAG	VARCHAR2	(30)		Identiies whether the employee is eligible for withholding.
TREATY_BEN_ALLOWED_FLAG	VARCHAR2	(30)		Indicates whether the treaty benefits are allowed for the employee.
TREATY_BENEFITS_START_DATE	DATE			The date from which the treaty benefits begin
RA_EFFECTIVE_DATE	DATE			The date on which the employee has become a resident.
STATE_CODE	VARCHAR2	(30)		The two letter state code for which the state tax is applied.
STATE_HONORS_TREATY_FLAG	VARCHAR2	(30)		Identifies whether the state honors the alien treaty.
YTD_PAYMENTS	NUMBER	(11)		The total YTD payments for this income type.
YTD_W2_PAYMENTS	NUMBER	(11)		The total W2 income for this income type.
YTD_W2_WITHHOLDING	NUMBER	(11)		Total W2 withholdings.
YTD_WITHHOLDING_ALLOWANCE	NUMBER	(11)		YTD withholding allowances.
YTD_TREATY_PAYMENTS	NUMBER	(11)		YTD 1042s payments.
YTD_TREATY_WITHHELD_AMT	NUMBER	(11)		YTD 1042s taxes withheld.
RECORD_SOURCE	VARCHAR2	(30)		Identifier for the third party Alien treaty analysis software.
VISA_TYPE	VARCHAR2	(30)		Type of visa, refers to the lookup type PER_US_VISA_TYPE.
J_SUB_TYPE	VARCHAR2	(30)		Sub type of visa, valid for a visa type of 'J'
PRIMARY_ACTIVITY	VARCHAR2	(30)		Refers to the lookup type PQP_US_PRIMARY_ACTIVITY.
NON_US_COUNTRY_CODE	VARCHAR2	(30)		The non US country code to which the empoyee belongs.
CITIZENSHIP_COUNTRY_CODE	VARCHAR2	(30)		The country in which the employee is a citizen of.
CONSTANT_ADDL_TAX	NUMBER	(11)		Constant additional tax if any
PERSON_ID	NUMBER	(10)		The person id from the PER_ALL_PEOPLE_F table
DATE_8233_SIGNED	DATE			Date on which the form 8233 was signed.
DATE_W4_SIGNED	DATE			Date on which the form W-4 was signed.
ERROR_INDICATOR	VARCHAR2	(30)		Indicates error in the transferred data.
PREV_ER_TREATY_BENEFIT_AMT	NUMBER	(11)		The benefit amount with the previous employer for a given year.
ERROR_TEXT	VARCHAR2	(4000)		The error text.
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	System generated version of row. Increments by one with each update.
FORECAST_INCOME_CODE	VARCHAR2	(30)		The forecast income code is the original income code that was sent for analysis.
CURRENT_ANALYSIS	VARCHAR2	(30)		Flag to indicate whether the income code is valid after analysis.

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 does not reference any database object

HR.PQP_ALIEN_TRANSACTION_DATA is referenced by following:

HR: PQP_ALIEN_TRANSACTION_DATA#