[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQP_ALIEN_TRANSACTION_DATA_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ALIEN_TRANSACTION_ID |
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. |
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;
HR.PQP_ALIEN_TRANSACTION_DATA does not reference any database object
HR.PQP_ALIEN_TRANSACTION_DATA is referenced by following:
|
|
|