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.PER_HU_ABSENCE_REPORT_V

Object Details

Object Name:	PER_HU_ABSENCE_REPORT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_HU_ABSENCE_REPORT_V
Subobject Name:
Status:	VALID

View Type

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

Hungary Absence Report View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PAYROLL_ACTION_ID	NUMBER	(9)	Yes	Payroll Action ID
GENERATOR_REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Yes	Assignment Action ID
COMPANY_NAME	VARCHAR2	(240)		Company Name
FULL_NAME	VARCHAR2	(240)		Full Name
ORGANIZATION	VARCHAR2	(240)		Organization
LOCATION	VARCHAR2	(240)		Location
EMPLOYEE_NUMBER	VARCHAR2	(240)		Employee Number
BIRTH_DATE	VARCHAR2	(240)		Birth Date
JOB	VARCHAR2	(240)		Job
HIRE_DATE	VARCHAR2	(240)		Hire Date
SUSPENDED_END_DATE	VARCHAR2	(240)		Suspended End Date
REPORTING_YEAR	VARCHAR2	(240)		Reporting Year
BASE_HOLIDAY	VARCHAR2	(240)		Base Holiday
ADDITIONAL_HOLIDAY_CHILD_CARE	VARCHAR2	(240)		Additional Holiday Child Care
OTHER_ADDITIONAL_HOLIDAY	VARCHAR2	(240)		Other Additional Holiday
PAID_HOLIDAY_CARRY_OVER	VARCHAR2	(240)		Paid Holiday Carry Over
SICKNESS_HOLIDAY	VARCHAR2	(240)		Paid Holiday Carry Over
TOTAL_NORMAL_PAID_HOLIDAY	VARCHAR2	(240)		Total Normal Paid Holiday
ISSUE_DATE	VARCHAR2	(240)		Issue Date
PEOPLE_GROUP	VARCHAR2	(240)		People Group

Query Text

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


SELECT PAYROLL_ACTION_ID
,      GENERATOR_REQUEST_ID
,      ASSIGNMENT_ACTION_ID
,      COMPANY_NAME
,      FULL_NAME
,      ORGANIZATION
,      LOCATION
,      EMPLOYEE_NUMBER
,      BIRTH_DATE
,      JOB
,      HIRE_DATE
,      SUSPENDED_END_DATE
,      REPORTING_YEAR
,      BASE_HOLIDAY
,      ADDITIONAL_HOLIDAY_CHILD_CARE
,      OTHER_ADDITIONAL_HOLIDAY
,      PAID_HOLIDAY_CARRY_OVER
,      SICKNESS_HOLIDAY
,      TOTAL_NORMAL_PAID_HOLIDAY
,      ISSUE_DATE
,      PEOPLE_GROUP
FROM APPS.PER_HU_ABSENCE_REPORT_V;

Dependencies

[top of page]

APPS.PER_HU_ABSENCE_REPORT_V references the following:

APPS: PAY_ACTION_INFORMATION; PAY_ASSIGNMENT_ACTIONS; PAY_PAYROLL_ACTIONS

APPS.PER_HU_ABSENCE_REPORT_V is not referenced by any database object