DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HRBV_EVENTS_V

Object Details
Object Name: HRBV_EVENTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Events (from PER_EVENTS table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
DATE_START DATE
Yes Date start.
TYPE VARCHAR2 (30) Yes (Lookup code based on lookup type TYPE).
TYPE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type TYPE).
COMMENTS CLOB (4000)
Comments.
CONTACT_TELEPHONE_NUMBER VARCHAR2 (60)
Contact telephone number.
DATE_END DATE

Date end.
EMP_OR_APL VARCHAR2 (1)
(Lookup code based on lookup type EMP_APL).
EMP_OR_APL_M VARCHAR2 (4000)
(Lookup meaning based on lookup type EMP_APL).
EVENT_OR_INTERVIEW VARCHAR2 (30)
(Lookup code based on lookup type EVENT_INTERVIEW).
EVENT_OR_INTERVIEW_M VARCHAR2 (4000)
(Lookup meaning based on lookup type EVENT_INTERVIEW).
EXTERNAL_CONTACT VARCHAR2 (80)
External contact.
TIME_END VARCHAR2 (5)
Time end.
TIME_START VARCHAR2 (5)
Time start.
_DF:EVT CHAR (22)
Descriptive Flexfield Column
EVENT_ID NUMBER (15) Yes Primary key for PER_EVENTS.
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
LOCATION_ID NUMBER (15)
Foreign key to HR_LOCATIONS_ALL.
INTERNAL_CONTACT_PERSON_ID NUMBER (10)
Foreign key to PER_ALL_PEOPLE_F.
ORGANIZATION_RUN_BY_ID NUMBER (15)
Foreign key to HR_ALL_ORGANZATION_UNITS.
ASSIGNMENT_ID NUMBER (10)
Foreign key to PER_ALL_ASSIGNMENTS_F.
PARTY_ID NUMBER (15)
Foreign key to HZ_PARTIES.
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
BG_SECURITY_FLAG_CODE CHAR (1)
Business group security flag code.
Query Text

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


SELECT DATE_START
,      TYPE
,      TYPE_M
,      COMMENTS
,      CONTACT_TELEPHONE_NUMBER
,      DATE_END
,      EMP_OR_APL
,      EMP_OR_APL_M
,      EVENT_OR_INTERVIEW
,      EVENT_OR_INTERVIEW_M
,      EXTERNAL_CONTACT
,      TIME_END
,      TIME_START
,      _DF:EVT
,      EVENT_ID
,      BUSINESS_GROUP_ID
,      LOCATION_ID
,      INTERNAL_CONTACT_PERSON_ID
,      ORGANIZATION_RUN_BY_ID
,      ASSIGNMENT_ID
,      PARTY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_EVENTS_V;

Dependencies

[top of page]

APPS.HRBV_EVENTS_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymPER_EVENTS

APPS.HRBV_EVENTS_V is not referenced by any database object