[Home] [Help] [Dependency Information]
Object Name: | PQP_ANALYZED_ALIEN_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ANALYZED_DATA_DETAILS_ID | NUMBER | (15) | Yes | |
ANALYZED_DATA_ID | NUMBER | (15) | Yes | |
INCOME_CODE | VARCHAR2 | (30) | ||
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) | ||
NRA_EXEMPT_FROM_SS | VARCHAR2 | (30) | ||
NRA_EXEMPT_FROM_MEDICARE | VARCHAR2 | (30) | ||
STUDENT_EXEMPT_FROM_SS | VARCHAR2 | (30) | ||
STUDENT_EXEMPT_FROM_MEDICARE | VARCHAR2 | (30) | ||
ADDL_WITHHOLDING_FLAG | VARCHAR2 | (30) | ||
CONSTANT_ADDL_TAX | NUMBER | (11) | ||
ADDL_WITHHOLDING_AMT | NUMBER | (11) | ||
ADDL_WTHLDNG_AMT_PERIOD_TYPE | VARCHAR2 | (30) | ||
PERSONAL_EXEMPTION | NUMBER | (6) | ||
ADDL_EXEMPTION_ALLOWED | NUMBER | (6) | ||
TREATY_BEN_ALLOWED_FLAG | VARCHAR2 | (30) | ||
TREATY_BENEFITS_START_DATE | 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 | |
RETRO_LOSS_NOTIFICATION_SENT | VARCHAR2 | (30) | ||
FORECAST_INCOME_CODE | VARCHAR2 | (30) | ||
CURRENT_ANALYSIS | VARCHAR2 | (30) |
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#;
|
|
|