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_DATA

Object Details

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

Table stores the alien employees analyzed data that is returned from a third pary.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQP_ANALYZED_ALIEN_DATA_PK

ANALYZED_DATA_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_ANALYZED_ALIEN_DATA_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ANALYZED_DATA_ID
PQP_ANALYZED_ALIEN_DATA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID TAX_YEAR

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_ID	NUMBER	(15)	Yes	System generated primary key.
ASSIGNMENT_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_ASSIGNMENTS_F
DATA_SOURCE	VARCHAR2	(30)	Yes	Name of the third pary that is giving the analyzed data for Alien employees.
TAX_YEAR	NUMBER	(5)	Yes	The tax year for which the data is applicable.
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.
NUMBER_OF_DAYS_IN_USA	NUMBER	(6)		Number of days the employee is in the US.
WITHLDG_ALLOW_ELIGIBLE_FLAG	VARCHAR2	(30)		Identiies whether the employee is eligible for withholding.
RA_EFFECTIVE_DATE	DATE			The date on which the employee has become a resident.
RECORD_SOURCE	VARCHAR2	(30)		Identifier for the third party Alien treaty analysis software.
VISA_TYPE	VARCHAR2	(30)		Identifies the type of visa
J_SUB_TYPE	VARCHAR2	(30)		Sub type of visa, valid for a visa type of 'J'
PRIMARY_ACTIVITY	VARCHAR2	(30)		Thr primary activity in the US.
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.
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.
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.

Query Text

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


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

Dependencies

[top of page]

HR.PQP_ANALYZED_ALIEN_DATA does not reference any database object

HR.PQP_ANALYZED_ALIEN_DATA is referenced by following:

APPS: PQP_ANALYZED_ALIEN_DATA; PQP_ANALYZED_ALIEN_DATA_WHO
PUBLIC: PQP_ANALYZED_ALIEN_DATA