[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
HR.PAY_REPORT_TOTALS does not reference any database object
HR.PAY_REPORT_TOTALS is referenced by following:
|
|
|