[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PAY_IE_TAX_TRAILER_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PAY.PAY_IE_TAX_TRAILER_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
Trailer Table to store Tax Credit upload Information
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RECORD_TYPE | VARCHAR2 | (2) | Yes | Record Type Indicator, TC for Trailer Record |
| RECORD_ID | NUMBER | (8) | Record Id | |
| EMPLOYER_NUMBER | VARCHAR2 | (8) | Yes | Employer Paye Reference Number |
| RECORD_NO | NUMBER | (10) | Record Number | |
| TOTAL_MTH_RATE_CUTOFF | NUMBER | (17) | Total Monthly Rate Cutoff | |
| TOTAL_WK_RATE_CUTOFF | NUMBER | (17) | Total Weekly Rate Cutoff | |
| TOTAL_MTH_TAX_CREDIT | NUMBER | (17) | Total Monthly tax Credit | |
| TOTAL_WK_TAX_CREDIT | NUMBER | (17) | Total Weekly Tax Credit | |
| FILLER | VARCHAR2 | (160) | Filler for Further use | |
| TC_TOT_YEARLY_TAX_CRED | NUMBER | (17) | Total Yearly Tax Credit | |
| TOT_YEARLY_TAX_RATE_1 | NUMBER | (17) | Total Yearly Tax Rate1 | |
| TOT_YEARLY_TAX_RATE_2 | NUMBER | (17) | Total Yearly Tax Rate2 | |
| TOT_MONTHLY_TAX_RATE_2 | NUMBER | (17) | Total Monthly Tax Rate2 | |
| TOT_WEEKLY_TAX_RATE_2 | NUMBER | (17) | Total Weekly Tax Rate2 | |
| TOT_YEARLY_TAX_RATE_3 | NUMBER | (17) | Total Yearly Tax Rate3 | |
| TOT_MONTHLY_TAX_RATE_3 | NUMBER | (17) | Total Monthly Tax Rate3 | |
| TOT_WEEKLY_TAX_RATE_3 | NUMBER | (17) | Total Weekly Tax Rate3 | |
| TOT_YEARLY_TAX_RATE_4 | NUMBER | (17) | Total Yearly Tax Rate4 | |
| TOT_MONTHLY_TAX_RATE_4 | NUMBER | (17) | Total Monthly Tax Rate4 | |
| TOT_WEEKLY_TAX_RATE_4 | NUMBER | (17) | Total Weekly Tax Rate4 | |
| TOT_YEARLY_USC_RATE_1 | NUMBER | (17) | Total Yearly USC Rate1 | |
| TOT_YEARLY_USC_RATE_2 | NUMBER | (17) | Total Yearly USC Rate2 | |
| TOT_YEARLY_USC_RATE_3 | NUMBER | (17) | Total Yearly USC Rate3 | |
| TOT_YEARLY_USC_RATE_4 | NUMBER | (17) | Total Yearly USC Rate4 |
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;
HR.PAY_IE_TAX_TRAILER_INTERFACE does not reference any database object
HR.PAY_IE_TAX_TRAILER_INTERFACE is referenced by following:
HR
PAY_IE_TAX_TRAILER_INTERFACE#
|
|
|
|