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

VIEW: APPS.HRBV_QUALIFICATIONS_V

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

View Type

A Business Intelligence System view


Qualifications (from PER_QUALIFICATIONS/TL table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
TITLE VARCHAR2 (120)
Title.
GRADE_ATTAINED VARCHAR2 (100)
Grade.
STATUS VARCHAR2 (30)
(Lookup code based on lookup type PER_SUBJECT_STATUSES).
STATUS_M VARCHAR2 (4000)
(Lookup meaning based on lookup type PER_SUBJECT_STATUSES).
AWARDED_DATE DATE

Awarded date.
FEE NUMBER (19)
Fee.
FEE_CURRENCY VARCHAR2 (15)
Fee currency.
TRAINING_COMPLETED_AMOUNT NUMBER (15)
Training completed amount.
REIMBURSEMENT_ARRANGEMENTS VARCHAR2 (2000)
Reimbursement arrangements.
TRAINING_COMPLETED_UNITS VARCHAR2 (100)
Training completed units.
TOTAL_TRAINING_AMOUNT NUMBER (15)
Total training amount.
START_DATE DATE

Start date.
END_DATE DATE

End date.
LICENSE_NUMBER VARCHAR2 (60)
License number.
EXPIRY_DATE DATE

License expiry date.
LICENSE_RESTRICTIONS VARCHAR2 (255)
License restrictions.
PROJECTED_COMPLETION_DATE DATE

Projected completion date.
AWARDING_BODY VARCHAR2 (100)
Awarding body.
TUITION_METHOD VARCHAR2 (30)
(Lookup code based on lookup type PER_TUITION_METHODS).
TUITION_METHOD_M VARCHAR2 (4000)
(Lookup meaning based on lookup type PER_TUITION_METHODS).
GROUP_RANKING VARCHAR2 (100)
Group ranking.
COMMENTS VARCHAR2 (2000)
Comments.
QUA_INFORMATION_CATEGORY VARCHAR2 (30)
Qua information category.
QUA_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
QUA_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
PROFESSIONAL_BODY_NAME VARCHAR2 (80)
Professional body name.
MEMBERSHIP_NUMBER VARCHAR2 (80)
Membership number.
MEMBERSHIP_CATEGORY VARCHAR2 (80)
Membership category.
SUBSCRIPTION_PAYMENT_METHOD VARCHAR2 (80)
Subscription payment method.
_DF:QUA CHAR (30)
QUALIFICATION_ID NUMBER (9) Yes Primary key for PER_QUALIFICATIONS.
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
PERSON_ID NUMBER (10)
Foreign key to PER_ALL_PEOPLE_F.
QUALIFICATION_TYPE_ID NUMBER (9) Yes Foreign key to PER_QUALIFICATION_TYPES.
ATTENDANCE_ID NUMBER (9)
Attendence Id.
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 TITLE
,      GRADE_ATTAINED
,      STATUS
,      STATUS_M
,      AWARDED_DATE
,      FEE
,      FEE_CURRENCY
,      TRAINING_COMPLETED_AMOUNT
,      REIMBURSEMENT_ARRANGEMENTS
,      TRAINING_COMPLETED_UNITS
,      TOTAL_TRAINING_AMOUNT
,      START_DATE
,      END_DATE
,      LICENSE_NUMBER
,      EXPIRY_DATE
,      LICENSE_RESTRICTIONS
,      PROJECTED_COMPLETION_DATE
,      AWARDING_BODY
,      TUITION_METHOD
,      TUITION_METHOD_M
,      GROUP_RANKING
,      COMMENTS
,      QUA_INFORMATION_CATEGORY
,      QUA_INFORMATION1
,      QUA_INFORMATION2
,      QUA_INFORMATION3
,      QUA_INFORMATION4
,      QUA_INFORMATION5
,      QUA_INFORMATION6
,      QUA_INFORMATION7
,      QUA_INFORMATION8
,      QUA_INFORMATION9
,      QUA_INFORMATION10
,      QUA_INFORMATION11
,      QUA_INFORMATION12
,      QUA_INFORMATION13
,      QUA_INFORMATION14
,      QUA_INFORMATION15
,      QUA_INFORMATION16
,      QUA_INFORMATION17
,      QUA_INFORMATION18
,      QUA_INFORMATION19
,      QUA_INFORMATION20
,      PROFESSIONAL_BODY_NAME
,      MEMBERSHIP_NUMBER
,      MEMBERSHIP_CATEGORY
,      SUBSCRIPTION_PAYMENT_METHOD
,      _DF:QUA
,      QUALIFICATION_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      QUALIFICATION_TYPE_ID
,      ATTENDANCE_ID
,      PARTY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_QUALIFICATIONS_V;

Dependencies

[top of page]

APPS.HRBV_QUALIFICATIONS_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymPER_QUALIFICATIONS
SynonymPER_QUALIFICATIONS_TL
APPS.HRBV_QUALIFICATIONS_V is referenced by following:

SchemaPUBLIC
SynonymHRBV_QUALIFICATIONS_V