eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: EDWBV_HR_GRD_GRADES_LCV

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ GRA.GRADE_ID || '-' || INST.INSTANCE_CODE GRADE_PK
, INST.INSTANCE_CODE INSTANCE
, GRA.NAME || '(' || INST.INSTANCE_CODE || ')' NAME
, GRA.NAME || '(' || INST.INSTANCE_CODE || ')' GRADE_DP
, 'ALL' ALL_FK
, GRA.DATE_FROM GRADE_DATE_FROM
, GRA.DATE_TO GRADE_DATE_TO
, GRA.SEQUENCE GRADE_SEQUENCE
, BGR.NAME BUSINESS_GROUP_NAME
, GRA.GRADE_ID GRADE_ID
, BGR.ORGANIZATION_ID BUSINESS_GROUP_ID
, GRD.GRADE_DEFINITION_ID GRADE_DEFINITION_ID
, '_DF:PER:PER_GRADES:GRA'
, '_KF:PER:GRD:GRD'
, GREATEST( NVL(GRA.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(BGR.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(GRD.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))) LAST_UPDATE_DATE
, GRA.CREATION_DATE CREATION_DATE
FROM PER_GRADES GRA
, HR_ALL_ORGANIZATION_UNITS BGR
, PER_GRADE_DEFINITIONS GRD
, EDW_LOCAL_INSTANCE INST
WHERE GRA.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND GRA.GRADE_DEFINITION_ID = GRD.GRADE_DEFINITION_ID

Columns

Name
GRADE_PK
INSTANCE
NAME
GRADE_DP
ALL_FK
GRADE_DATE_FROM
GRADE_DATE_TO
GRADE_SEQUENCE
BUSINESS_GROUP
GRADE_ID
BUSINESS_GROUP_ID
GRADE_DEFINITION_ID
"_DF:GRADE_DETAILS:_EDW"
"_KF:GRADE_NAME:_EDW"
LAST_UPDATE_DATE
CREATION_DATE