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: APPS.PAY_US_DEDUCTIONS_REPORT_RBR_V

Object Details

Object Name:	PAY_US_DEDUCTIONS_REPORT_RBR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_US_DEDUCTIONS_REPORT_RBR_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view returns all the deductions for an employee

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONSOLIDATION_SET_ID	NUMBER	(9)		Consolidation Set ID
CONSOLIDATION_SET_NAME	VARCHAR2	(60)	Yes	Consolidation Set Name
PAYROLL_ID	NUMBER	(9)		Payroll ID
PAYROLL_NAME	VARCHAR2	(80)	Yes	Payroll Name
PAYROLL_EFFECTIVE_START_DATE	DATE		Yes	Payroll Effective Start Date
PAYROLL_EFFECTIVE_END_DATE	DATE		Yes	Payroll Effective End Date
PAYROLL_ACTION_ID	NUMBER	(9)	Yes	Payroll Action ID for Action Type of R, Q, B, V, I
PAYROLL_ACTION_EFFECTIVE_DATE	DATE		Yes	Payroll Action Effective Date for Action Type of R, Q, B, V, I
PAYROLL_ACTION_DATE_EARNED	DATE			Payroll Action Date Earned for Action Type of R, Q, B, V, I
TIME_PERIOD_ID	NUMBER	(15)	Yes	Time Period ID
PERIOD_NAME	VARCHAR2	(70)	Yes	Period Name
PERIOD_NUM	NUMBER	(15)	Yes	Period Num
PERIOD_TYPE	VARCHAR2	(30)	Yes	Perdion Type
PERIOD_START_DATE	DATE		Yes	Period Start Date
PERIOD_END_DATE	DATE		Yes	Period End Date
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Yes	Assignment Action ID
ASSIGNMENT_ID	NUMBER	(10)		Assignment ID
TAX_UNIT_ID	NUMBER	(15)		Tax Unit ID/GRE ID
GRE	VARCHAR2	(240)	Yes	Tax Unit/GRE Name
PERSON_ID	NUMBER	(10)	Yes	Person ID
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee Number
FULL_NAME	VARCHAR2	(240)		Employee Full Name
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization ID
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization Name
LOCATION_ID	NUMBER	(15)		Location ID
LOCATION_CODE	VARCHAR2	(60)		Location Code
LOCATION_DESCRIPTION	VARCHAR2	(240)		Location Description
ASSIGNMENT_SEQUENCE	NUMBER	(15)	Yes	Assignment Sequence
ASSIGNMENT_NUMBER	VARCHAR2	(30)		Assignment Number
ELEMENT_TYPE_ID	NUMBER	(9)	Yes	Element Type ID
ELEMENT_NAME	VARCHAR2	(80)	Yes	Element Name
ELEMENT_DESCRIPTION	VARCHAR2	(240)		Element Description
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group ID
PRIMARY_BALANCE_ID	VARCHAR2	(150)		Primay Balance ID
HOURS_BALANCE_ID	VARCHAR2	(150)		Hours Balance ID
CLASSIFICATION_ID	NUMBER	(9)	Yes	Element Classification ID
CLASSIFICATION_NAME	VARCHAR2	(80)	Yes	Element Classification Name
PRIMARY_BALANCE	NUMBER			Primary Balance Value
NOT_TAKEN_BALANCE	NUMBER			Not Taken Balance Value
ARREARS_BALANCE	NUMBER			Arrears Balance Value
ACCRUED_BALANCE	VARCHAR2	(40)		Accrued Balance Value
TOTAL_OWED	NUMBER			Total Owed Balance Value

Query Text

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


SELECT CONSOLIDATION_SET_ID
,      CONSOLIDATION_SET_NAME
,      PAYROLL_ID
,      PAYROLL_NAME
,      PAYROLL_EFFECTIVE_START_DATE
,      PAYROLL_EFFECTIVE_END_DATE
,      PAYROLL_ACTION_ID
,      PAYROLL_ACTION_EFFECTIVE_DATE
,      PAYROLL_ACTION_DATE_EARNED
,      TIME_PERIOD_ID
,      PERIOD_NAME
,      PERIOD_NUM
,      PERIOD_TYPE
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      ASSIGNMENT_ACTION_ID
,      ASSIGNMENT_ID
,      TAX_UNIT_ID
,      GRE
,      PERSON_ID
,      EMPLOYEE_NUMBER
,      FULL_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      LOCATION_ID
,      LOCATION_CODE
,      LOCATION_DESCRIPTION
,      ASSIGNMENT_SEQUENCE
,      ASSIGNMENT_NUMBER
,      ELEMENT_TYPE_ID
,      ELEMENT_NAME
,      ELEMENT_DESCRIPTION
,      BUSINESS_GROUP_ID
,      PRIMARY_BALANCE_ID
,      HOURS_BALANCE_ID
,      CLASSIFICATION_ID
,      CLASSIFICATION_NAME
,      PRIMARY_BALANCE
,      NOT_TAKEN_BALANCE
,      ARREARS_BALANCE
,      ACCRUED_BALANCE
,      TOTAL_OWED
FROM APPS.PAY_US_DEDUCTIONS_REPORT_RBR_V;

Dependencies

[top of page]

APPS.PAY_US_DEDUCTIONS_REPORT_RBR_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; PAY_ALL_PAYROLLS_F; PAY_ASSIGNMENT_ACTIONS; PAY_BALANCE_ATTRIBUTES; PAY_BAL_ATTRIBUTE_DEFINITIONS; PAY_CONSOLIDATION_SETS; PAY_DEFINED_BALANCES; PAY_ELEMENT_CLASSIFICATIONS; PAY_ELEMENT_TYPES_F; PAY_PAYROLL_ACTIONS; PAY_RUN_BALANCES; PAY_US_DEDN_PKG - show dependent code; PAY_US_TAXBAL_VIEW_PKG - show dependent code; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_TIME_PERIODS

APPS.PAY_US_DEDUCTIONS_REPORT_RBR_V is not referenced by any database object