[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PER_QUALIFICATIONS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PER.PER_QUALIFICATIONS_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| QUALIFICATION_ID | NUMBER | (9) | Yes | |
| BUSINESS_GROUP_ID | NUMBER | (15) | ||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
| PERSON_ID | NUMBER | |||
| TITLE | VARCHAR2 | (120) | ||
| GRADE_ATTAINED | VARCHAR2 | (100) | ||
| STATUS | VARCHAR2 | (30) | ||
| STATUS_MEANING | VARCHAR2 | (4000) | ||
| AWARDED_DATE | DATE | |||
| FEE | NUMBER | (19) | ||
| FEE_CURRENCY | VARCHAR2 | (15) | ||
| TRAINING_COMPLETED_AMOUNT | NUMBER | (15) | ||
| REIMBURSEMENT_ARRANGEMENTS | VARCHAR2 | (2000) | ||
| TRAINING_COMPLETED_UNITS | VARCHAR2 | (100) | ||
| TOTAL_TRAINING_AMOUNT | NUMBER | (15) | ||
| START_DATE | DATE | |||
| END_DATE | DATE | |||
| LICENSE_NUMBER | VARCHAR2 | (60) | ||
| EXPIRY_DATE | DATE | |||
| LICENSE_RESTRICTIONS | VARCHAR2 | (255) | ||
| PROJECTED_COMPLETION_DATE | DATE | |||
| AWARDING_BODY | VARCHAR2 | (4000) | ||
| TUITION_METHOD | VARCHAR2 | (30) | ||
| TUITION_METHOD_MEANING | VARCHAR2 | (4000) | ||
| GROUP_RANKING | VARCHAR2 | (100) | ||
| COMMENTS | VARCHAR2 | (2000) | ||
| QUALIFICATION_TYPE_ID | NUMBER | (9) | Yes | |
| NAME | VARCHAR2 | (150) | Yes | |
| ATTENDANCE_ID | NUMBER | (9) | ||
| ESTABLISHMENT | VARCHAR2 | (255) | ||
| LOCATION | VARCHAR2 | (240) | ||
| PROFESSIONAL_BODY_NAME | VARCHAR2 | (80) | Name of professional body belonged to. | |
| MEMBERSHIP_NUMBER | VARCHAR2 | (80) | Membership number for professional body belonged to | |
| MEMBERSHIP_CATEGORY | VARCHAR2 | (80) | Membership Category for professional body belonged to | |
| SUBSCRIPTION_PAYMENT_METHOD | VARCHAR2 | (80) | Method of payment of subsciption charges to professional body belonged to | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ATTRIBUTE17 | VARCHAR2 | (150) | ||
| ATTRIBUTE18 | VARCHAR2 | (150) | ||
| ATTRIBUTE19 | VARCHAR2 | (150) | ||
| ATTRIBUTE20 | VARCHAR2 | (150) | ||
| QUA_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
| QUA_INFORMATION1 | VARCHAR2 | (150) | ||
| QUA_INFORMATION2 | VARCHAR2 | (150) | ||
| QUA_INFORMATION3 | VARCHAR2 | (150) | ||
| QUA_INFORMATION4 | VARCHAR2 | (150) | ||
| QUA_INFORMATION5 | VARCHAR2 | (150) | ||
| QUA_INFORMATION6 | VARCHAR2 | (150) | ||
| QUA_INFORMATION7 | VARCHAR2 | (150) | ||
| QUA_INFORMATION8 | VARCHAR2 | (150) | ||
| QUA_INFORMATION9 | VARCHAR2 | (150) | ||
| QUA_INFORMATION10 | VARCHAR2 | (150) | ||
| QUA_INFORMATION11 | VARCHAR2 | (150) | ||
| QUA_INFORMATION12 | VARCHAR2 | (150) | ||
| QUA_INFORMATION13 | VARCHAR2 | (150) | ||
| QUA_INFORMATION14 | VARCHAR2 | (150) | ||
| QUA_INFORMATION15 | VARCHAR2 | (150) | ||
| QUA_INFORMATION16 | VARCHAR2 | (150) | ||
| QUA_INFORMATION17 | VARCHAR2 | (150) | ||
| QUA_INFORMATION18 | VARCHAR2 | (150) | ||
| QUA_INFORMATION19 | VARCHAR2 | (150) | ||
| QUA_INFORMATION20 | VARCHAR2 | (150) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| CREATED_BY | NUMBER | (15) | ||
| CREATION_DATE | DATE | |||
| PARTY_ID | NUMBER | |||
| QUAL_FRAMEWORK_ID | NUMBER | (10) | ||
| QUALIFICATION_TYPE | VARCHAR2 | (100) | ||
| QUALIFICATION_TYPE_MEANING | VARCHAR2 | (4000) | ||
| CREDIT_TYPE | VARCHAR2 | (100) | ||
| CREDIT_TYPE_MEANING | VARCHAR2 | (4000) | ||
| CREDITS | NUMBER | (10) | ||
| LEVEL_TYPE | VARCHAR2 | (40) | ||
| LEVEL_TYPE_MEANING | VARCHAR2 | (4000) | ||
| LEVEL_NUMBER | NUMBER | (10) | ||
| LEVEL_NUMBER_MEANING | VARCHAR2 | (4000) | ||
| FIELD | VARCHAR2 | (100) | ||
| FIELD_MEANING | VARCHAR2 | (4000) | ||
| SUB_FIELD | VARCHAR2 | (100) | ||
| SUB_FIELD_MEANING | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, QUALIFICATION_ID
, BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER
, PERSON_ID
, TITLE
, GRADE_ATTAINED
, STATUS
, STATUS_MEANING
, 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_MEANING
, GROUP_RANKING
, COMMENTS
, QUALIFICATION_TYPE_ID
, NAME
, ATTENDANCE_ID
, ESTABLISHMENT
, LOCATION
, PROFESSIONAL_BODY_NAME
, MEMBERSHIP_NUMBER
, MEMBERSHIP_CATEGORY
, SUBSCRIPTION_PAYMENT_METHOD
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, 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
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, PARTY_ID
, QUAL_FRAMEWORK_ID
, QUALIFICATION_TYPE
, QUALIFICATION_TYPE_MEANING
, CREDIT_TYPE
, CREDIT_TYPE_MEANING
, CREDITS
, LEVEL_TYPE
, LEVEL_TYPE_MEANING
, LEVEL_NUMBER
, LEVEL_NUMBER_MEANING
, FIELD
, FIELD_MEANING
, SUB_FIELD
, SUB_FIELD_MEANING
FROM APPS.PER_QUALIFICATIONS_V;
APPS
HR_GENERAL
- show dependent code
PER_ESTABLISHMENTS
PER_ESTABLISHMENT_ATTENDANCES
PER_QUALIFICATIONS
PER_QUALIFICATIONS_TL
PER_QUALIFICATION_TYPES
PER_QUALIFICATION_TYPES_TL
APPS
PAY_AE_SI_REPORTS
- show dependent code
PQP_GB_TP_PENSION_EXTRACTS
- show dependent code
|
|
|
|