[Home] [Help] [Dependency Information]
Object Name: | PAY_IE_TAX_TRAILER_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_TYPE | VARCHAR2 | (2) | Yes | |
RECORD_ID | NUMBER | (8) | ||
EMPLOYER_NUMBER | VARCHAR2 | (8) | Yes | |
RECORD_NO | NUMBER | (10) | ||
TOTAL_MTH_RATE_CUTOFF | NUMBER | (17) | ||
TOTAL_WK_RATE_CUTOFF | NUMBER | (17) | ||
TOTAL_MTH_TAX_CREDIT | NUMBER | (17) | ||
TOTAL_WK_TAX_CREDIT | NUMBER | (17) | ||
FILLER | VARCHAR2 | (160) | ||
TC_TOT_YEARLY_TAX_CRED | NUMBER | (17) | ||
TOT_YEARLY_TAX_RATE_1 | NUMBER | (17) | ||
TOT_YEARLY_TAX_RATE_2 | NUMBER | (17) | ||
TOT_MONTHLY_TAX_RATE_2 | NUMBER | (17) | ||
TOT_WEEKLY_TAX_RATE_2 | NUMBER | (17) | ||
TOT_YEARLY_TAX_RATE_3 | NUMBER | (17) | ||
TOT_MONTHLY_TAX_RATE_3 | NUMBER | (17) | ||
TOT_WEEKLY_TAX_RATE_3 | NUMBER | (17) | ||
TOT_YEARLY_TAX_RATE_4 | NUMBER | (17) | ||
TOT_MONTHLY_TAX_RATE_4 | NUMBER | (17) | ||
TOT_WEEKLY_TAX_RATE_4 | NUMBER | (17) | ||
TOT_YEARLY_USC_RATE_1 | NUMBER | (17) | ||
TOT_YEARLY_USC_RATE_2 | NUMBER | (17) | ||
TOT_YEARLY_USC_RATE_3 | NUMBER | (17) | ||
TOT_YEARLY_USC_RATE_4 | NUMBER | (17) |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_TYPE
, RECORD_ID
, EMPLOYER_NUMBER
, RECORD_NO
, TOTAL_MTH_RATE_CUTOFF
, TOTAL_WK_RATE_CUTOFF
, TOTAL_MTH_TAX_CREDIT
, TOTAL_WK_TAX_CREDIT
, FILLER
, TC_TOT_YEARLY_TAX_CRED
, TOT_YEARLY_TAX_RATE_1
, TOT_YEARLY_TAX_RATE_2
, TOT_MONTHLY_TAX_RATE_2
, TOT_WEEKLY_TAX_RATE_2
, TOT_YEARLY_TAX_RATE_3
, TOT_MONTHLY_TAX_RATE_3
, TOT_WEEKLY_TAX_RATE_3
, TOT_YEARLY_TAX_RATE_4
, TOT_MONTHLY_TAX_RATE_4
, TOT_WEEKLY_TAX_RATE_4
, TOT_YEARLY_USC_RATE_1
, TOT_YEARLY_USC_RATE_2
, TOT_YEARLY_USC_RATE_3
, TOT_YEARLY_USC_RATE_4
FROM HR.PAY_IE_TAX_TRAILER_INTERFACE#;
|
|
|