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]

TABLE: HR.PAY_REPORT_TOTALS

Object Details

Object Name:	PAY_REPORT_TOTALS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_REPORT_TOTALS
Subobject Name:
Status:	VALID

This table is used for Canadian Year End Register Reports.
The T4/T4A/RL1 Register Report uses this table to calculate
the summary data. The data hets deleted once the summary
report has completed successfully.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PAYROLL_ACTION_ID	NUMBER		Yes	Foreign key to PAY_PAYROLL_ACTIONS
BUSINESS_GROUP_ID	NUMBER		Yes	Business Group the totals relate to
ASSIGNMENT_ACTION_ID	NUMBER			Foreign key to PAY_ASSIGNMENT_ACTIONS
INFORMATION_TYPE1	VARCHAR2	(80)	Yes	Report total attribute
INFORMATION_TYPE2	VARCHAR2	(80)		Report total attribute
INFORMATION_TYPE3	VARCHAR2	(80)		Report total attribute
INFORMATION_TYPE4	VARCHAR2	(80)		Report total attribute
INFORMATION_TYPE5	VARCHAR2	(80)		Report total attribute
INFORMATION_VALUE1	VARCHAR2	(80)	Yes	Report total value
INFORMATION_VALUE2	VARCHAR2	(80)		Report total value
INFORMATION_VALUE3	VARCHAR2	(80)		Report total value
INFORMATION_VALUE4	VARCHAR2	(80)		Report total value
INFORMATION_VALUE5	VARCHAR2	(80)		Report total value
ATTRIBUTE_TYPE	VARCHAR2	(80)		Report total identifier
ATTRIBUTE_VALUE	NUMBER			Report total identifier value

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PAYROLL_ACTION_ID
,      BUSINESS_GROUP_ID
,      ASSIGNMENT_ACTION_ID
,      INFORMATION_TYPE1
,      INFORMATION_TYPE2
,      INFORMATION_TYPE3
,      INFORMATION_TYPE4
,      INFORMATION_TYPE5
,      INFORMATION_VALUE1
,      INFORMATION_VALUE2
,      INFORMATION_VALUE3
,      INFORMATION_VALUE4
,      INFORMATION_VALUE5
,      ATTRIBUTE_TYPE
,      ATTRIBUTE_VALUE
FROM HR.PAY_REPORT_TOTALS;

Dependencies

[top of page]

HR.PAY_REPORT_TOTALS does not reference any database object

HR.PAY_REPORT_TOTALS is referenced by following:

HR: PAY_REPORT_TOTALS#