eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: HR.PAY_ZA_TAX_TRACES#

Object Details

Object Name:	PAY_ZA_TAX_TRACES#
Object Type:	VIEW
Owner:	HR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ASG_ACT_ID	NUMBER
ASG_ID	NUMBER
PRL_ACT_ID	NUMBER
PRL_ID	NUMBER
TX_STA	VARCHAR2	(1)
PER_AGE	NUMBER
CALTYP	VARCHAR2	(7)
TX_DIR_VAL	NUMBER
IT3IND	NUMBER
TXPERCVAL	NUMBER
ASG_STRT_DTE	DATE
ZA_ACT_END_DTE	DATE
ZA_CUR_PRD_STRT_DTE	DATE
ZA_CUR_PRD_END_DTE	DATE
ZA_TX_YR_STRT	DATE
ZA_TX_YR_END	DATE
SES_DTE	DATE
PRDFACTOR	NUMBER
POSFACTOR	NUMBER
SITFACTOR	NUMBER
ZA_PAY_PRDS_LFT	NUMBER
ZA_PAY_PRDS_PER_YR	NUMBER
ZA_DYS_IN_YR	NUMBER
SEA_WRK_DYS_WRK	NUMBER
ARR_PF_FRQ	VARCHAR2	(1)
ARR_RA_FRQ	VARCHAR2	(1)
BP_TX_RCV	VARCHAR2	(1)
RA_FRQ	VARCHAR2	(1)
TXBINCPTD	NUMBER
BSEERN	NUMBER
TXBBSEINC	NUMBER
TOTLIBBSE	NUMBER
TXBINCYTD	NUMBER
PERTXBINC	NUMBER
PERPENFND	NUMBER
PERRFICON	NUMBER
PERRFITXB	NUMBER
PERPENFNDMAX	NUMBER
PERPENFNDABM	NUMBER
ANNTXBINC	NUMBER
ANNPENFND	NUMBER
ANNRFICON	NUMBER
ANNRFITXB	NUMBER
ANNPENFNDMAX	NUMBER
ANNPENFNDABM	NUMBER
ARRPENFND	NUMBER
ARRPENFNDABM	NUMBER
RETANU	NUMBER
NRFICON	NUMBER
RETANUMAX	NUMBER
RETANUABM	NUMBER
ARRRETANU	NUMBER
ARRRETANUABM	NUMBER
REBATE	NUMBER
THRESHOLD	NUMBER
MEDAIDABM	NUMBER
PERTOTABM	NUMBER
ANNTOTABM	NUMBER
NORINCYTD	NUMBER
NORINCPTD	NUMBER
NORERN	NUMBER
TXBNORINC	NUMBER
LIBFYNI	NUMBER
TX_ON_NI_YTD	NUMBER
TX_ON_NI_PTD	NUMBER
LIBFPNI	NUMBER
FRNBENYTD	NUMBER
FRNBENPTD	NUMBER
FRNBENERN	NUMBER
TXBFRNINC	NUMBER
LIBFYFB	NUMBER
TX_ON_FB_YTD	NUMBER
TX_ON_FB_PTD	NUMBER
LIBFPFB	NUMBER
TRVALLYTD	NUMBER
TRVALLPTD	NUMBER
TRVALLERN	NUMBER
TXBTRVINC	NUMBER
LIBFYTA	NUMBER
TX_ON_TA_YTD	NUMBER
TX_ON_TA_PTD	NUMBER
LIBFPTA	NUMBER
BONPROYTD	NUMBER
BONPROPTD	NUMBER
BONPROERN	NUMBER
TXBBONPROINC	NUMBER
LIBFYBP	NUMBER
TX_ON_BP_YTD	NUMBER
TX_ON_BP_PTD	NUMBER
LIBFPBP	NUMBER
ANNBONYTD	NUMBER
ANNBONERN	NUMBER
TXBANNBONINC	NUMBER
LIBFYAB	NUMBER
TX_ON_AB_YTD	NUMBER
TX_ON_AB_PTD	NUMBER
LIBFPAB	NUMBER
ANNPYMYTD	NUMBER
ANNPYMPTD	NUMBER
ANNPYMERN	NUMBER
TXBANNPYMINC	NUMBER
LIBFYAP	NUMBER
TX_ON_AP_YTD	NUMBER
TX_ON_AP_PTD	NUMBER
LIBFPAP	NUMBER
PBLOFFYTD	NUMBER
PBLOFFPTD	NUMBER
PBLOFFERN	NUMBER
LIBFYPO	NUMBER
TX_ON_PO_YTD	NUMBER
TX_ON_PO_PTD	NUMBER
LIBFPPO	NUMBER
MSGTXSTATUS	VARCHAR2	(100)
LIBWRN	VARCHAR2	(100)
PAYVALUE	NUMBER
PAYEVAL	NUMBER
SITEVAL	NUMBER
ANNARRPENFND	NUMBER
ANNARRPENFNDABM	NUMBER
ANNRETANU	NUMBER
ANNNRFICON	NUMBER
ANNRETANUMAX	NUMBER
ANNRETANUABM	NUMBER
ANNARRRETANU	NUMBER
ANNARRRETANUABM	NUMBER

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# references the following:

HR: PAY_ZA_TAX_TRACES

HR.PAY_ZA_TAX_TRACES# is referenced by following:

APPS: PAY_ZA_TAX_TRACES