[Home] [Help] [Dependency Information]
Object Name: | PAY_REPORT_TOTALS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYROLL_ACTION_ID | NUMBER | Yes | ||
BUSINESS_GROUP_ID | NUMBER | Yes | ||
ASSIGNMENT_ACTION_ID | NUMBER | |||
INFORMATION_TYPE1 | VARCHAR2 | (80) | Yes | |
INFORMATION_TYPE2 | VARCHAR2 | (80) | ||
INFORMATION_TYPE3 | VARCHAR2 | (80) | ||
INFORMATION_TYPE4 | VARCHAR2 | (80) | ||
INFORMATION_TYPE5 | VARCHAR2 | (80) | ||
INFORMATION_VALUE1 | VARCHAR2 | (80) | Yes | |
INFORMATION_VALUE2 | VARCHAR2 | (80) | ||
INFORMATION_VALUE3 | VARCHAR2 | (80) | ||
INFORMATION_VALUE4 | VARCHAR2 | (80) | ||
INFORMATION_VALUE5 | VARCHAR2 | (80) | ||
ATTRIBUTE_TYPE | VARCHAR2 | (80) | ||
ATTRIBUTE_VALUE | NUMBER |
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#;
|
|
|