[Home] [Help] [Dependency Information]
Object Name: | PQP_ALIEN_TRANSACTION_DATA# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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#;
|
|
|