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

VIEW: APPS.PER_ZA_FORMAL_QUALIFICATIONS_V

Object Details
Object Name: PER_ZA_FORMAL_QUALIFICATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_ZA_FORMAL_QUALIFICATIONS_V
Subobject Name:
Status: VALID

View Type

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


PER_ZA_FORMAL_QUALIFICATIONS_V is used to maintain table PER_ZA_FORMAL_QUALIFICATIONS via NQF forms.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
QUALIFICATION_ID NUMBER (9) Yes Unique Qualification Identifier
BUSINESS_GROUP_ID NUMBER (15)
Business Group ID
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number
PERSON_ID NUMBER

Person ID
TITLE VARCHAR2 (120)
Title
GRADE_ATTAINED VARCHAR2 (100)
Grade attained
STATUS VARCHAR2 (30)
Status
STATUS_MEANING VARCHAR2 (4000)
Status Meaning
AWARDED_DATE DATE

Date awarded
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

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)
Tuition Method
TUITION_METHOD_MEANING VARCHAR2 (4000)
Tuition Method Meaning
GROUP_RANKING VARCHAR2 (100)
Group Ranking
COMMENTS VARCHAR2 (2000)
Comments
QUALIFICATION_TYPE_ID NUMBER (9) Yes Qualification Type ID
NAME VARCHAR2 (150) Yes Name
ATTENDANCE_ID NUMBER (9)
Attendance ID
ESTABLISHMENT VARCHAR2 (255)
Establishment
LOCATION VARCHAR2 (240)
Location
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Refer base table
ATTRIBUTE2 VARCHAR2 (150)
Refer base table
ATTRIBUTE3 VARCHAR2 (150)
Refer base table
ATTRIBUTE4 VARCHAR2 (150)
Refer base table
ATTRIBUTE5 VARCHAR2 (150)
Refer base table
ATTRIBUTE6 VARCHAR2 (150)
Refer base table
ATTRIBUTE7 VARCHAR2 (150)
Refer base table
ATTRIBUTE8 VARCHAR2 (150)
Refer base table
ATTRIBUTE9 VARCHAR2 (150)
Refer base table
ATTRIBUTE10 VARCHAR2 (150)
Refer base table
ATTRIBUTE11 VARCHAR2 (150)
Refer base table
ATTRIBUTE12 VARCHAR2 (150)
Refer base table
ATTRIBUTE13 VARCHAR2 (150)
Refer base table
ATTRIBUTE14 VARCHAR2 (150)
Refer base table
ATTRIBUTE15 VARCHAR2 (150)
Refer base table
ATTRIBUTE16 VARCHAR2 (150)
Refer base table
ATTRIBUTE17 VARCHAR2 (150)
Refer base table
ATTRIBUTE18 VARCHAR2 (150)
Refer base table
ATTRIBUTE19 VARCHAR2 (150)
Refer base table
ATTRIBUTE20 VARCHAR2 (150)
Refer base table
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LEVEL_ID NUMBER (9)
Level Identifier
FIELD_OF_LEARNING VARCHAR2 (30)
Field of Learning - free text
FIELD_OF_LEARNING_MEANING VARCHAR2 (4000)
Field of Learning meaning
SUB_FIELD VARCHAR2 (120)
Sub field of learning - free text
REGISTRATION_DATE DATE

Registration date
REGISTRATION_NUMBER VARCHAR2 (10)
Registration number
Query Text

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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LEVEL_ID
,      FIELD_OF_LEARNING
,      FIELD_OF_LEARNING_MEANING
,      SUB_FIELD
,      REGISTRATION_DATE
,      REGISTRATION_NUMBER
FROM APPS.PER_ZA_FORMAL_QUALIFICATIONS_V;

Dependencies

[top of page]

APPS.PER_ZA_FORMAL_QUALIFICATIONS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPER_ESTABLISHMENTS
SynonymPER_ESTABLISHMENT_ATTENDANCES
SynonymPER_QUALIFICATIONS
SynonymPER_QUALIFICATION_TYPES
SynonymPER_ZA_FORMAL_QUALIFICATIONS
APPS.PER_ZA_FORMAL_QUALIFICATIONS_V is referenced by following:

SchemaPUBLIC
SynonymPER_ZA_FORMAL_QUALIFICATIONS_V