[Home] [Help] [Dependency Information]
Object Name: | PAY_ZA_TAX_TRACES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_ZA_TAX_TRACES |
Subobject Name: | |
Status: | VALID |
PAY_ZA_TAX_TRACES holds tax trace data calculated during the payroll run. Only the most recent run's data will be stored.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASG_ACT_ID | NUMBER | Assignment Action ID | ||
ASG_ID | NUMBER | Assignment ID | ||
PRL_ACT_ID | NUMBER | Payroll Action ID | ||
PRL_ID | NUMBER | Payroll ID | ||
TX_STA | VARCHAR2 | (1) | Tax Status for the run | |
PER_AGE | NUMBER | Value of the PER_AGE Database Item | ||
CALTYP | VARCHAR2 | (7) | Indicates the last calculation that was done, eg. NorCalc is the Normal Calculation was performed | |
TX_DIR_VAL | NUMBER | Value of the Input Value: TAX DIRECTIVE VALUE | ||
IT3IND | NUMBER | Indicator used in the IT3A report. Will be 1 if the assignment falls under the Tax threshold figure and 0 (zero) if over the threshold figure. | ||
TXPERCVAL | NUMBER | Set to the Percentage used in the tax calculation for assignments with Tax Status: Directive Percentage, Close Corporation and Temporary Worker / Student. | ||
ASG_STRT_DTE | DATE | Value of the Database Item: ASG_START_DATE | ||
ZA_ACT_END_DTE | DATE | Value of the Database Item: ZA_ACTUAL_END_DATE | ||
ZA_CUR_PRD_STRT_DTE | DATE | Value of the Database Item: ZA_CURRENT_PERIOD_END_DATE | ||
ZA_CUR_PRD_END_DTE | DATE | Value of the Database Item: ZA_CURRENT_PERIOD_START_DATE | ||
ZA_TX_YR_STRT | DATE | Value of the Database Item: ZA_TAX_YEAR_START | ||
ZA_TX_YR_END | DATE | Value of the Database Item: ZA_TAX_YEAR_END | ||
SES_DTE | DATE | Value of the Database Item: SESSION_DATE | ||
PRDFACTOR | NUMBER | Period Factor | ||
POSFACTOR | NUMBER | Possible Period Factor | ||
SITFACTOR | NUMBER | Site Factor. Days in the Year divided by Days Worked. | ||
ZA_PAY_PRDS_LFT | NUMBER | Value of the Database Item: ZA_PAY_PERIODS_LEFT | ||
ZA_PAY_PRDS_PER_YR | NUMBER | Value of the Database Item: ZA_PAY_PERIODS_PER_YEAR | ||
ZA_DYS_IN_YR | NUMBER | Value of the Database Item: ZA_DAYS_IN_YEAR | ||
SEA_WRK_DYS_WRK | NUMBER | ZA_Tax Element Input Value: SEASONAL_WORKERS_DAYS_WORKED | ||
ARR_PF_FRQ | VARCHAR2 | (1) | ZA_Tax Element Input Value: ARREAR_PENSION_FREQUENCY | |
ARR_RA_FRQ | VARCHAR2 | (1) | ZA_Tax Element Input Value: ARREAR_RA_FREQUENCY | |
BP_TX_RCV | VARCHAR2 | (1) | ZA_Tax Element Input Value: BONUS_PROVISION_TAX_RECOVERY | |
RA_FRQ | VARCHAR2 | (1) | ZA_Tax Element Input Value: RETIREMENT_ANNUITY_FREQUENCY | |
TXBINCPTD | NUMBER | Period Type Income PTD Balances that are referenced in the Tax calculation. | ||
BSEERN | NUMBER | Value calculated to be used as a base for tax calculation purposes. | ||
TXBBSEINC | NUMBER | Taxable Base Income | ||
TOTLIBBSE | NUMBER | Tax liability on Taxable Base Income | ||
TXBINCYTD | NUMBER | Period type TAX_ or CAL_YTD income balance values | ||
PERTXBINC | NUMBER | No longer used. | ||
PERPENFND | NUMBER | Annualised Period Pension Fund | ||
PERRFICON | NUMBER | Annualised Total RFIable Income | ||
PERRFITXB | NUMBER | No longer used. | ||
PERPENFNDMAX | NUMBER | Calculated Maximum Pension Fund Abatement for Period Type Income. | ||
PERPENFNDABM | NUMBER | Calculated Pension Fund Abatement value for Period Type Income | ||
ANNTXBINC | NUMBER | No longer used. | ||
ANNPENFND | NUMBER | PerPenFnd plus Annual Pension Fund Contributions. | ||
ANNRFICON | NUMBER | PerRfiCon plus Total Rfiable Annual Income | ||
ANNRFITXB | NUMBER | No longer used. | ||
ANNPENFNDMAX | NUMBER | Calculated Maximum Pension Fund Abatement for Annual Type Income. | ||
ANNPENFNDABM | NUMBER | Calculated Pension Fund Abatement value for Annual Type Income. | ||
ARRPENFND | NUMBER | Annualised contribution value of Arrear Pension plus any excess carried over taking into account the contribution frequency. | ||
ARRPENFNDABM | NUMBER | Calculated Arrear Pension Fund Abatement. | ||
RETANU | NUMBER | Annualised retirement annuity contribution taking into account the contribution frequency. | ||
NRFICON | NUMBER | Annualised NRFI contribution value. If there are no Pension Fund contributions everything is NRFI. | ||
RETANUMAX | NUMBER | Calculated Maximum Retirement Annuity Value. | ||
RETANUABM | NUMBER | Calculated Retirement Annuity Abatement. | ||
ARRRETANU | NUMBER | Annualised contribution value of Arrear Retirement Annuity plus any excess carried over taking into account the contribution frequency. | ||
ARRRETANUABM | NUMBER | Calculated Arrear Retirement Annuity Abatement. | ||
REBATE | NUMBER | Rebate Figure. | ||
THRESHOLD | NUMBER | Tax Threshold Figure. | ||
MEDAIDABM | NUMBER | Calculated Medical Aid Abatement. | ||
PERTOTABM | NUMBER | Total Abatement Figure for Period Type Income. | ||
ANNTOTABM | NUMBER | Total Abatement Figure for Annual Type Income. | ||
NORINCYTD | NUMBER | The sum total of the YTD dimension value of the balances constituting Normal Income. | ||
NORINCPTD | NUMBER | The sum total of the PTD dimension value of the balances constituting Normal Income. | ||
NORERN | NUMBER | The annualised Normal Income value. | ||
TXBNORINC | NUMBER | The taxable value used to calculate the tax liability on Normal Income. | ||
LIBFYNI | NUMBER | Calculated Liability for the tax year for Normal Income. | ||
TX_ON_NI_YTD | NUMBER | Balance Value: Tax on Normal Income YTD | ||
TX_ON_NI_PTD | NUMBER | Balance Value: Tax on Normal Income PTD | ||
LIBFPNI | NUMBER | Calculated Liability that will be deducted in the current payroll run. | ||
FRNBENYTD | NUMBER | The sum total of the YTD dimension value of the balances constituting Fringe Benefits. | ||
FRNBENPTD | NUMBER | The sum total of the PTD dimension value of the balances constituting Fringe Benefits. | ||
FRNBENERN | NUMBER | The annualised Fringe Benefits value plus NorErn. | ||
TXBFRNINC | NUMBER | The taxable value used to calculate the tax liability on FrnBenErn | ||
LIBFYFB | NUMBER | Calculated Liability for the tax year for Fringe Benefits | ||
TX_ON_FB_YTD | NUMBER | Balance Value: Tax on Fringe Benefits YTD | ||
TX_ON_FB_PTD | NUMBER | Balance Value: Tax on Fringe Benefits PTD | ||
LIBFPFB | NUMBER | Calculated Liability that will be deducted in the current payroll run | ||
TRVALLYTD | NUMBER | The sum total of the YTD dimension value of the balances constituting Travel Allowance | ||
TRVALLPTD | NUMBER | The sum total of the PTD dimension value of the balances constituting Travel Allowance | ||
TRVALLERN | NUMBER | The annualised Travel Allowance value plus FrnBenErn | ||
TXBTRVINC | NUMBER | The taxable value used to calculate the tax liability on TrvAllErn | ||
LIBFYTA | NUMBER | Calculated Liability for the tax year for Travel Allowance | ||
TX_ON_TA_YTD | NUMBER | Balance Value: Tax on Car Allowance YTD | ||
TX_ON_TA_PTD | NUMBER | Balance Value: Tax on Car Allowance PTD | ||
LIBFPTA | NUMBER | Calculated Liability that will be deducted in the current payroll run | ||
BONPROYTD | NUMBER | The sum total of the YTD dimension value of the balances constituting Bonus Provision | ||
BONPROPTD | NUMBER | The sum total of the PTD dimension value of the balances constituting Bonus Provision | ||
BONPROERN | NUMBER | The annualised Bonus Provision value plus TrvAllErn | ||
TXBBONPROINC | NUMBER | The taxable value used to calculate the tax liability on BonProErn. | ||
LIBFYBP | NUMBER | Calculated Liability for the tax year for Bonus Provision | ||
TX_ON_BP_YTD | NUMBER | Balance Value: Tax on Bonus Provision YTD | ||
TX_ON_BP_PTD | NUMBER | Balance Balue: Tax on Bonus Provision PTD | ||
LIBFPBP | NUMBER | Calculated Liability that will be deducted in the current payroll run | ||
ANNBONYTD | NUMBER | The sum total of the YTD dimension value of the balances constituting Annual Bonus | ||
ANNBONERN | NUMBER | Annual Bonus YTD plus TrvAllErn | ||
TXBANNBONINC | NUMBER | The taxable value used to calculate the tax liability on AnnBonErn | ||
LIBFYAB | NUMBER | Calculated Liability for the tax year for Annual Bonus | ||
TX_ON_AB_YTD | NUMBER | Balance Value: Tax on Annual Bonus YTD | ||
TX_ON_AB_PTD | NUMBER | Balance Value: Tax on Annual Bonus PTD | ||
LIBFPAB | NUMBER | Calculated Liability that will be deducted in the current payroll run | ||
ANNPYMYTD | NUMBER | The sum total of the YTD dimension value of the balances constituting Annual Payments | ||
ANNPYMPTD | NUMBER | The sum total of the PTD dimension value of the balances constituting Annual Payments | ||
ANNPYMERN | NUMBER | Annual Payments plus AnnBonErn | ||
TXBANNPYMINC | NUMBER | The taxable value used to calculate the tax liability on AnnPymErn | ||
LIBFYAP | NUMBER | Calculated Liability for the tax year for Annual Payments | ||
TX_ON_AP_YTD | NUMBER | Balance Value: Tax on Annual Payments YTD | ||
TX_ON_AP_PTD | NUMBER | Balance Value: Tax on Annual Payments PTD | ||
LIBFPAP | NUMBER | Calculated Liability that will be deducted in the current payroll run. | ||
PBLOFFYTD | NUMBER | The sum total of the YTD dimension value of the balances constituting Public Office Allowance | ||
PBLOFFPTD | NUMBER | The sum total of the PTD dimension value of the balances constituting Public Office Allowance | ||
PBLOFFERN | NUMBER | The annualised Public Office Allowance value | ||
LIBFYPO | NUMBER | Calculated Liability for the tax year for Public Office Allowance | ||
TX_ON_PO_YTD | NUMBER | Balance Value: Tax on Public Office Allow YTD | ||
TX_ON_PO_PTD | NUMBER | Balance Value: Tax on Public Office Allow PTD | ||
LIBFPPO | NUMBER | Calculated Liability that will be deducted in the current payroll run | ||
MSGTXSTATUS | VARCHAR2 | (100) | No longer used | |
LIBWRN | VARCHAR2 | (100) | Warning Message | |
PAYVALUE | NUMBER | Total Liability to be deducted | ||
PAYEVAL | NUMBER | The value to Update the PAYE balance value | ||
SITEVAL | NUMBER | The value to update the SITE balance value | ||
ANNARRPENFND | NUMBER | Annual Arrear Pension Fund | ||
ANNARRPENFNDABM | NUMBER | Annual Arrear Pension Fund Abatement | ||
ANNRETANU | NUMBER | Annual Retirement Annuity | ||
ANNNRFICON | NUMBER | Annual NRFI Income | ||
ANNRETANUMAX | NUMBER | Annual Retirement Annuity Maximum | ||
ANNRETANUABM | NUMBER | Annual Retirement Annuity Abatement | ||
ANNARRRETANU | NUMBER | Annual Arrear Retirement Annuity | ||
ANNARRRETANUABM | NUMBER | Annual Arrear Retirement Annuity Abatement |
Cut, paste (and edit) the following text to query this object:
SELECT ASG_ACT_ID
, ASG_ID
, PRL_ACT_ID
, PRL_ID
, TX_STA
, PER_AGE
, CALTYP
, TX_DIR_VAL
, IT3IND
, TXPERCVAL
, ASG_STRT_DTE
, ZA_ACT_END_DTE
, ZA_CUR_PRD_STRT_DTE
, ZA_CUR_PRD_END_DTE
, ZA_TX_YR_STRT
, ZA_TX_YR_END
, SES_DTE
, PRDFACTOR
, POSFACTOR
, SITFACTOR
, ZA_PAY_PRDS_LFT
, ZA_PAY_PRDS_PER_YR
, ZA_DYS_IN_YR
, SEA_WRK_DYS_WRK
, ARR_PF_FRQ
, ARR_RA_FRQ
, BP_TX_RCV
, RA_FRQ
, TXBINCPTD
, BSEERN
, TXBBSEINC
, TOTLIBBSE
, TXBINCYTD
, PERTXBINC
, PERPENFND
, PERRFICON
, PERRFITXB
, PERPENFNDMAX
, PERPENFNDABM
, ANNTXBINC
, ANNPENFND
, ANNRFICON
, ANNRFITXB
, ANNPENFNDMAX
, ANNPENFNDABM
, ARRPENFND
, ARRPENFNDABM
, RETANU
, NRFICON
, RETANUMAX
, RETANUABM
, ARRRETANU
, ARRRETANUABM
, REBATE
, THRESHOLD
, MEDAIDABM
, PERTOTABM
, ANNTOTABM
, NORINCYTD
, NORINCPTD
, NORERN
, TXBNORINC
, LIBFYNI
, TX_ON_NI_YTD
, TX_ON_NI_PTD
, LIBFPNI
, FRNBENYTD
, FRNBENPTD
, FRNBENERN
, TXBFRNINC
, LIBFYFB
, TX_ON_FB_YTD
, TX_ON_FB_PTD
, LIBFPFB
, TRVALLYTD
, TRVALLPTD
, TRVALLERN
, TXBTRVINC
, LIBFYTA
, TX_ON_TA_YTD
, TX_ON_TA_PTD
, LIBFPTA
, BONPROYTD
, BONPROPTD
, BONPROERN
, TXBBONPROINC
, LIBFYBP
, TX_ON_BP_YTD
, TX_ON_BP_PTD
, LIBFPBP
, ANNBONYTD
, ANNBONERN
, TXBANNBONINC
, LIBFYAB
, TX_ON_AB_YTD
, TX_ON_AB_PTD
, LIBFPAB
, ANNPYMYTD
, ANNPYMPTD
, ANNPYMERN
, TXBANNPYMINC
, LIBFYAP
, TX_ON_AP_YTD
, TX_ON_AP_PTD
, LIBFPAP
, PBLOFFYTD
, PBLOFFPTD
, PBLOFFERN
, LIBFYPO
, TX_ON_PO_YTD
, TX_ON_PO_PTD
, LIBFPPO
, MSGTXSTATUS
, LIBWRN
, PAYVALUE
, PAYEVAL
, SITEVAL
, ANNARRPENFND
, ANNARRPENFNDABM
, ANNRETANU
, ANNNRFICON
, ANNRETANUMAX
, ANNRETANUABM
, ANNARRRETANU
, ANNARRRETANUABM
FROM HR.PAY_ZA_TAX_TRACES;
HR.PAY_ZA_TAX_TRACES does not reference any database object
HR.PAY_ZA_TAX_TRACES is referenced by following:
|
|
|