[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PAY_IE_TAX_BODY_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PAY.PAY_IE_TAX_BODY_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
Table to store the details of Tax Credit Information from the Flat file
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PAY_IE_TAX_BODY_INTERFACE_PK | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 PPS_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RECORD_TYPE | VARCHAR2 | (2) | Yes | Record Type Information HC for Header record, PC for body record, TC for trailer record |
| PROCESS_FLAG | VARCHAR2 | (1) | Process Flag, Y indicates the First Phase of validation is sucessful and the records will be used in the second phase validation | |
| PPS_NUMBER | VARCHAR2 | (9) | Yes | PPS Number of the person |
| EMPLOYER_NUMBER | VARCHAR2 | (8) | Employer Paye Reference Number | |
| WK_RATE_CUTOFF | NUMBER | (9) | Weekly Rate Cutoff | |
| WORKS_NUMBER | VARCHAR2 | (12) | Works Number which is equal to Employee Number | |
| MTH_TAX_CREDIT | NUMBER | (10) | Monthly Tax Credit | |
| MTH_RATE_CUTOFF | NUMBER | (10) | Monthly Tax Credit | |
| WK_TAX_CREDIT | NUMBER | (9) | Weekly Tax Credit | |
| CERT_START_DATE | DATE | Yes | Cretificate Start Date | |
| CERT_END_DATE | DATE | Certificate End Date | ||
| WK_MTH_INDICATOR | NUMBER | (1) | Week/Month Indicator | |
| CERT_DATE | DATE | Yes | Certificate Date | |
| LAST_NAME | VARCHAR2 | (20) | Employee Last Name | |
| FIRST_NAME | VARCHAR2 | (20) | Employee First Name | |
| ADDRESS_LINE1 | VARCHAR2 | (30) | Employee Address Line1 | |
| ADDRESS_LINE2 | VARCHAR2 | (30) | Employee Address Line2 | |
| ADDRESS_LINE3 | VARCHAR2 | (30) | Employee Address Line3 | |
| PROCESSED_FLAG | VARCHAR2 | (1) | Processed Flag, Indicating record has been processed | |
| PROCESSED_DATE | DATE | Date when Processed | ||
| TOT_PAY_TO_DATE | NUMBER | (17) | Total Pay to Date | |
| TOT_TAX_TO_DATE | NUMBER | (17) | Total Tax to Date | |
| EXEMPTION_INDICATOR | VARCHAR2 | (1) | Exemption Indicator | |
| STD_RATE_OF_TAX | NUMBER | (2) | Standard Rate of Tax | |
| HIGHER_RATE_OF_TAX | NUMBER | (2) | Higher Rate of Tax | |
| CD_YRLY_TAX_CRED | NUMBER | (9) | Yearly Tax Credit | |
| CD_YRLY_TAX_RATE_1 | NUMBER | (8) | Yearly Tax Rate1 | |
| CD_YRLY_TAX_RATE_2 | NUMBER | (8) | Yearly Tax Rate2 | |
| CD_MTHLY_TAX_RATE_2 | NUMBER | (10) | Monthly Tax Rate2 | |
| CD_WKLY_TAX_RATE_2 | NUMBER | (9) | Weekly Tax Rate2 | |
| CD_TAX_RATE_3 | NUMBER | (2) | Tax Rate3 | |
| CD_YRLY_TAX_RATE_3 | NUMBER | (8) | Yearly Tax Rate3 | |
| CD_MTHLY_TAX_RATE_3 | NUMBER | (10) | Monthly Tax Rate3 | |
| CD_WKLY_TAX_RATE_3 | NUMBER | (9) | Weekly Tax Rate3 | |
| CD_TAX_RATE_4 | NUMBER | (2) | Tax Rate4 | |
| CD_YRLY_TAX_RATE_4 | NUMBER | (8) | Yearly Tax Rate4 | |
| CD_MTHLY_TAX_RATE_4 | NUMBER | (10) | Monthly Tax Rate4 | |
| CD_WKLY_TAX_RATE_4 | NUMBER | (9) | Weekly Tax Rate4 | |
| CD_TAX_RATE_5 | NUMBER | (2) | Tax Rate5 | |
| IN_EXEMPT_USC | VARCHAR2 | (1) | Exempt USC Flag | |
| CD_TOTAL_USC_PAY_TODATE | NUMBER | (17) | Total USCable Pay To Date | |
| CD_TOTAL_USC_TAX_TODATE | NUMBER | (17) | Total USC Deducted To Date | |
| CD_USC_RATE_1 | NUMBER | (2) | USC Rate1 | |
| AM_USC_YRLY_CUTOFF_1 | NUMBER | (17) | Yearly USC Cutoff1 | |
| AM_USC_MTHLY_CUTOFF_1 | NUMBER | (17) | Monthly USC Cutoff1 | |
| AM_USC_WKLY_CUTOFF_1 | NUMBER | (17) | Weekly USC Cutoff1 | |
| CD_USC_RATE_2 | NUMBER | (2) | USC Rate2 | |
| AM_USC_YRLY_CUTOFF_2 | NUMBER | (17) | Yearly USC Cutoff2 | |
| AM_USC_MTHLY_CUTOFF_2 | NUMBER | (17) | Monthly USC Cutoff2 | |
| AM_USC_WKLY_CUTOFF_2 | NUMBER | (17) | Weekly USC Cutoff2 | |
| CD_USC_RATE_3 | NUMBER | (2) | USC Rate3 | |
| AM_USC_YRLY_CUTOFF_3 | NUMBER | (17) | Yearly USC Cutoff3 | |
| AM_USC_MTHLY_CUTOFF_3 | NUMBER | (17) | Monthly USC Cutoff3 | |
| AM_USC_WKLY_CUTOFF_3 | NUMBER | (17) | Weekly USC Cutoff3 | |
| CD_USC_RATE_4 | NUMBER | (2) | USC Rate4 | |
| AM_USC_YRLY_CUTOFF_4 | NUMBER | (17) | Yearly USC Cutoff4 | |
| AM_USC_MTHLY_CUTOFF_4 | NUMBER | (17) | Monthly USC Cutoff4 | |
| AM_USC_WKLY_CUTOFF_4 | NUMBER | (17) | Weekly USC Cutoff4 | |
| CD_USC_RATE_5 | NUMBER | (2) | USC Rate5 |
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 does not reference any database object
HR.PAY_IE_TAX_BODY_INTERFACE is referenced by following:
HR
PAY_IE_TAX_BODY_INTERFACE#
|
|
|
|