[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PAY_IE_TAX_BODY_INTERFACE# |
|---|---|
| Object Type: | VIEW |
| Owner: | HR |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RECORD_TYPE | VARCHAR2 | (2) | Yes | |
| PROCESS_FLAG | VARCHAR2 | (1) | ||
| PPS_NUMBER | VARCHAR2 | (9) | Yes | |
| EMPLOYER_NUMBER | VARCHAR2 | (8) | ||
| WK_RATE_CUTOFF | NUMBER | (9) | ||
| WORKS_NUMBER | VARCHAR2 | (12) | ||
| MTH_TAX_CREDIT | NUMBER | (10) | ||
| MTH_RATE_CUTOFF | NUMBER | (10) | ||
| WK_TAX_CREDIT | NUMBER | (9) | ||
| CERT_START_DATE | DATE | Yes | ||
| CERT_END_DATE | DATE | |||
| WK_MTH_INDICATOR | NUMBER | (1) | ||
| CERT_DATE | DATE | Yes | ||
| LAST_NAME | VARCHAR2 | (20) | ||
| FIRST_NAME | VARCHAR2 | (20) | ||
| ADDRESS_LINE1 | VARCHAR2 | (30) | ||
| ADDRESS_LINE2 | VARCHAR2 | (30) | ||
| ADDRESS_LINE3 | VARCHAR2 | (30) | ||
| PROCESSED_FLAG | VARCHAR2 | (1) | ||
| PROCESSED_DATE | DATE | |||
| TOT_PAY_TO_DATE | NUMBER | (17) | ||
| TOT_TAX_TO_DATE | NUMBER | (17) | ||
| EXEMPTION_INDICATOR | VARCHAR2 | (1) | ||
| STD_RATE_OF_TAX | NUMBER | (2) | ||
| HIGHER_RATE_OF_TAX | NUMBER | (2) | ||
| CD_YRLY_TAX_CRED | NUMBER | (9) | ||
| CD_YRLY_TAX_RATE_1 | NUMBER | (8) | ||
| CD_YRLY_TAX_RATE_2 | NUMBER | (8) | ||
| CD_MTHLY_TAX_RATE_2 | NUMBER | (10) | ||
| CD_WKLY_TAX_RATE_2 | NUMBER | (9) | ||
| CD_TAX_RATE_3 | NUMBER | (2) | ||
| CD_YRLY_TAX_RATE_3 | NUMBER | (8) | ||
| CD_MTHLY_TAX_RATE_3 | NUMBER | (10) | ||
| CD_WKLY_TAX_RATE_3 | NUMBER | (9) | ||
| CD_TAX_RATE_4 | NUMBER | (2) | ||
| CD_YRLY_TAX_RATE_4 | NUMBER | (8) | ||
| CD_MTHLY_TAX_RATE_4 | NUMBER | (10) | ||
| CD_WKLY_TAX_RATE_4 | NUMBER | (9) | ||
| CD_TAX_RATE_5 | NUMBER | (2) | ||
| IN_EXEMPT_USC | VARCHAR2 | (1) | ||
| CD_TOTAL_USC_PAY_TODATE | NUMBER | (17) | ||
| CD_TOTAL_USC_TAX_TODATE | NUMBER | (17) | ||
| CD_USC_RATE_1 | NUMBER | (2) | ||
| AM_USC_YRLY_CUTOFF_1 | NUMBER | (17) | ||
| AM_USC_MTHLY_CUTOFF_1 | NUMBER | (17) | ||
| AM_USC_WKLY_CUTOFF_1 | NUMBER | (17) | ||
| CD_USC_RATE_2 | NUMBER | (2) | ||
| AM_USC_YRLY_CUTOFF_2 | NUMBER | (17) | ||
| AM_USC_MTHLY_CUTOFF_2 | NUMBER | (17) | ||
| AM_USC_WKLY_CUTOFF_2 | NUMBER | (17) | ||
| CD_USC_RATE_3 | NUMBER | (2) | ||
| AM_USC_YRLY_CUTOFF_3 | NUMBER | (17) | ||
| AM_USC_MTHLY_CUTOFF_3 | NUMBER | (17) | ||
| AM_USC_WKLY_CUTOFF_3 | NUMBER | (17) | ||
| CD_USC_RATE_4 | NUMBER | (2) | ||
| AM_USC_YRLY_CUTOFF_4 | NUMBER | (17) | ||
| AM_USC_MTHLY_CUTOFF_4 | NUMBER | (17) | ||
| AM_USC_WKLY_CUTOFF_4 | NUMBER | (17) | ||
| CD_USC_RATE_5 | NUMBER | (2) |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_TYPE
, PROCESS_FLAG
, PPS_NUMBER
, EMPLOYER_NUMBER
, WK_RATE_CUTOFF
, WORKS_NUMBER
, MTH_TAX_CREDIT
, MTH_RATE_CUTOFF
, WK_TAX_CREDIT
, CERT_START_DATE
, CERT_END_DATE
, WK_MTH_INDICATOR
, CERT_DATE
, LAST_NAME
, FIRST_NAME
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, PROCESSED_FLAG
, PROCESSED_DATE
, TOT_PAY_TO_DATE
, TOT_TAX_TO_DATE
, EXEMPTION_INDICATOR
, STD_RATE_OF_TAX
, HIGHER_RATE_OF_TAX
, CD_YRLY_TAX_CRED
, CD_YRLY_TAX_RATE_1
, CD_YRLY_TAX_RATE_2
, CD_MTHLY_TAX_RATE_2
, CD_WKLY_TAX_RATE_2
, CD_TAX_RATE_3
, CD_YRLY_TAX_RATE_3
, CD_MTHLY_TAX_RATE_3
, CD_WKLY_TAX_RATE_3
, CD_TAX_RATE_4
, CD_YRLY_TAX_RATE_4
, CD_MTHLY_TAX_RATE_4
, CD_WKLY_TAX_RATE_4
, CD_TAX_RATE_5
, IN_EXEMPT_USC
, CD_TOTAL_USC_PAY_TODATE
, CD_TOTAL_USC_TAX_TODATE
, CD_USC_RATE_1
, AM_USC_YRLY_CUTOFF_1
, AM_USC_MTHLY_CUTOFF_1
, AM_USC_WKLY_CUTOFF_1
, CD_USC_RATE_2
, AM_USC_YRLY_CUTOFF_2
, AM_USC_MTHLY_CUTOFF_2
, AM_USC_WKLY_CUTOFF_2
, CD_USC_RATE_3
, AM_USC_YRLY_CUTOFF_3
, AM_USC_MTHLY_CUTOFF_3
, AM_USC_WKLY_CUTOFF_3
, CD_USC_RATE_4
, AM_USC_YRLY_CUTOFF_4
, AM_USC_MTHLY_CUTOFF_4
, AM_USC_WKLY_CUTOFF_4
, CD_USC_RATE_5
FROM HR.PAY_IE_TAX_BODY_INTERFACE#;
HR
PAY_IE_TAX_BODY_INTERFACE
APPS
PAY_IE_TAX_BODY_INTERFACE
|
|
|
|