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_ANALYZED_ALIEN_DETAILS

Object Details

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

The individual income type alien treaty benefits is stored in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQP_ANALYZED_ALIEN_DETAILS_PK

ANALYZED_DATA_DETAILS_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_ANALYZED_ALIEN_DETAILS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ANALYZED_DATA_DETAILS_ID
PQP_ANALYZED_ALIEN_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ANALYZED_DATA_ID INCOME_CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQP_ANALYZED_ALIEN_DETAILS		PQP_ANALYZED_ALIEN_DATA	PQP_ANALYZED_ALIEN_DETAILS ANALYZED_DATA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ANALYZED_DATA_DETAILS_ID	NUMBER	(15)	Yes	System generated primary key
ANALYZED_DATA_ID	NUMBER	(15)	Yes	Foreign key to PQP_ANALYZED_ALIEN_DATA
INCOME_CODE	VARCHAR2	(30)		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.
NRA_EXEMPT_FROM_SS	VARCHAR2	(30)		Y/N value indicating the non resident alien is exempt from SS
NRA_EXEMPT_FROM_MEDICARE	VARCHAR2	(30)		Y/N value indicating the non resident alien is exempt from medicare.
STUDENT_EXEMPT_FROM_SS	VARCHAR2	(30)		Y/N value indicating the alien student is exempt from SS
STUDENT_EXEMPT_FROM_MEDICARE	VARCHAR2	(30)		Y/N value indicating the alien student is exempt from medicare.
ADDL_WITHHOLDING_FLAG	VARCHAR2	(30)		Identifies whether there is any additional withholding.
CONSTANT_ADDL_TAX	NUMBER	(11)		Constant additional tax if any
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.
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
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.
RETRO_LOSS_NOTIFICATION_SENT	VARCHAR2	(30)		Indicates whether a retro loss notification has been sent to the employee
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 ANALYZED_DATA_DETAILS_ID
,      ANALYZED_DATA_ID
,      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
,      NRA_EXEMPT_FROM_SS
,      NRA_EXEMPT_FROM_MEDICARE
,      STUDENT_EXEMPT_FROM_SS
,      STUDENT_EXEMPT_FROM_MEDICARE
,      ADDL_WITHHOLDING_FLAG
,      CONSTANT_ADDL_TAX
,      ADDL_WITHHOLDING_AMT
,      ADDL_WTHLDNG_AMT_PERIOD_TYPE
,      PERSONAL_EXEMPTION
,      ADDL_EXEMPTION_ALLOWED
,      TREATY_BEN_ALLOWED_FLAG
,      TREATY_BENEFITS_START_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      RETRO_LOSS_NOTIFICATION_SENT
,      FORECAST_INCOME_CODE
,      CURRENT_ANALYSIS
FROM HR.PQP_ANALYZED_ALIEN_DETAILS;

Dependencies

[top of page]

HR.PQP_ANALYZED_ALIEN_DETAILS does not reference any database object

HR.PQP_ANALYZED_ALIEN_DETAILS is referenced by following:

APPS: PQP_ANALYZED_ALIEN_DETAILS; PQP_ANALYZED_ALIEN_DETAILS_WHO
PUBLIC: PQP_ANALYZED_ALIEN_DETAILS