[Home] [Help]
View: PQH_CORPS_GRADES_V
View Text
SELECT CEI.CORPS_DEFINITION_ID CORPS_DEFINITION_ID
, CEI.CORPS_EXTRA_INFO_ID CORPS_EXTRA_INFO_ID
, CEI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CEI.INFORMATION_TYPE INFORMATION_TYPE
, CEI.INFORMATION3 GRADE_ID
, GRD.NAME GRADE_NAME
, CEI.INFORMATION4 GRADE_OCCUPANCY_QUOTA
, CEI.INFORMATION5 MIN_PROGRESSION_SPEED
, CEI.INFORMATION6 AVG_PROGRESSION_SPEED
, CEI.INFORMATION7 MAX_PROGRESSION_SPEED
FROM PQH_CORPS_EXTRA_INFO CEI
, PER_GRADES GRD
WHERE CEI.INFORMATION3 = GRD.GRADE_ID
AND CEI.INFORMATION_TYPE ='GRADE'
Columns
Name |
CORPS_DEFINITION_ID |
CORPS_EXTRA_INFO_ID |
OBJECT_VERSION_NUMBER |
INFORMATION_TYPE |
GRADE_ID |
GRADE_NAME |
GRADE_OCCUPANCY_QUOTA |
MIN_PROGRESSION_SPEED |
AVG_PROGRESSION_SPEED |
MAX_PROGRESSION_SPEED |