[Home] [Help] [Dependency Information]
Object Name: | PER_QUALIFICATIONS1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
ALLOWANCE_DATE | DATE | |||
ESTABLISHMENT_TYPE | VARCHAR2 | (150) | ||
COURSE_TYPE | VARCHAR2 | (150) | ||
LICENSE_TYPE | VARCHAR2 | (150) | ||
CERT_PRESENTED | VARCHAR2 | (150) | ||
EDUCATION_CODE | NUMBER | |||
PREFERRED_LEVEL__ | VARCHAR2 | (150) | ||
DECISION_NUMBER | VARCHAR2 | (150) | ||
DATE_OF_DECISION | DATE | |||
TYPE_OF_DECISION | VARCHAR2 | (150) | ||
NAME_OF_FOREIGN_DIPLOMA | VARCHAR2 | (150) | ||
TYPE_OF_RECORD | VARCHAR2 | (150) | ||
QUALIFICATION_CODE | VARCHAR2 | (150) | ||
SUBJECT_CODE_1 | VARCHAR2 | (150) | ||
SUBJECT_CODE_2 | VARCHAR2 | (150) | ||
EDUCATIONAL_LEVEL | VARCHAR2 | (150) | ||
QUALIFICATION_LEVEL | VARCHAR2 | (150) | ||
NUS_2000_CODE | VARCHAR2 | (150) | ||
HIGHEST_LEVEL | VARCHAR2 | (150) | ||
GRADE_POINT_AVERAGE | VARCHAR2 | (150) | ||
NUMBER_OF_CREDITS | NUMBER | |||
COURSE_NAME | VARCHAR2 | (150) | ||
QUALIFICATION_IMPROVEMENT_TYPE | VARCHAR2 | (150) | ||
DOCUMENT_NAME | VARCHAR2 | (150) | ||
DIPLOMA_CERTIFICATE_SERIES | VARCHAR2 | (150) | ||
DIPLOMA_CERTIFICATE_NUMBER | VARCHAR2 | (150) | ||
PROFESSIONAL_QUALIFICATION | VARCHAR2 | (150) | ||
PROFESSION_CODE | VARCHAR2 | (150) | ||
SUN_CODE | VARCHAR2 | (150) | ||
EDUCATION_COURSE | VARCHAR2 | (150) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (1087) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, ALLOWANCE_DATE
, ESTABLISHMENT_TYPE
, COURSE_TYPE
, LICENSE_TYPE
, CERT_PRESENTED
, EDUCATION_CODE
, PREFERRED_LEVEL__
, DECISION_NUMBER
, DATE_OF_DECISION
, TYPE_OF_DECISION
, NAME_OF_FOREIGN_DIPLOMA
, TYPE_OF_RECORD
, QUALIFICATION_CODE
, SUBJECT_CODE_1
, SUBJECT_CODE_2
, EDUCATIONAL_LEVEL
, QUALIFICATION_LEVEL
, NUS_2000_CODE
, HIGHEST_LEVEL
, GRADE_POINT_AVERAGE
, NUMBER_OF_CREDITS
, COURSE_NAME
, QUALIFICATION_IMPROVEMENT_TYPE
, DOCUMENT_NAME
, DIPLOMA_CERTIFICATE_SERIES
, DIPLOMA_CERTIFICATE_NUMBER
, PROFESSIONAL_QUALIFICATION
, PROFESSION_CODE
, SUN_CODE
, EDUCATION_COURSE
, CONCATENATED_SEGMENTS
FROM APPS.PER_QUALIFICATIONS1_DFV;
APPS.PER_QUALIFICATIONS1_DFV is not referenced by any database object
|
|
|