[Home] [Help] [Dependency Information]
Object Name: | PQP_ANALYZED_ALIEN_DATA# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ANALYZED_DATA_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (15) | Yes | |
DATA_SOURCE | VARCHAR2 | (30) | Yes | |
TAX_YEAR | NUMBER | (5) | Yes | |
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 | |||
NUMBER_OF_DAYS_IN_USA | NUMBER | (6) | ||
WITHLDG_ALLOW_ELIGIBLE_FLAG | VARCHAR2 | (30) | ||
RA_EFFECTIVE_DATE | DATE | |||
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) | ||
DATE_8233_SIGNED | DATE | |||
DATE_W4_SIGNED | DATE | |||
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 |
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#;
|
|
|