[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#;
|
|
|