Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PAY_ZA_TAX_TRACES

Object Details
Object Name: PAY_ZA_TAX_TRACES
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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. deprecated
PERPENFND NUMBER

Annualised Period Pension Fund
PERRFICON NUMBER

Annualised Total RFIable Income
PERRFITXB NUMBER

No longer used. deprecated
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. deprecated
ANNPENFND NUMBER

PerPenFnd plus Annual Pension Fund Contributions.
ANNRFICON NUMBER

PerRfiCon plus Total Rfiable Annual Income
ANNRFITXB NUMBER

No longer used. deprecated
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 deprecated
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
Query Text

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;

Dependencies

[top of page]

HR.PAY_ZA_TAX_TRACES does not reference any database object

HR.PAY_ZA_TAX_TRACES is referenced by following:

SchemaHR
ViewPAY_ZA_TAX_TRACES#