Wednesday, June 25, 2014

Oracle HRMS Competence Tables


PER_RATING_SCALES
RATING_SCALE_ID       
NAME                  
TYPE                  
DESCRIPTION           

PER_RATING_LEVELS
RATING_LEVEL_ID       
STEP_VALUE            
NAME                  
RATING_SCALE_ID       
BEHAVIOURAL_INDICATOR

PER_COMPETENCES
COMPETENCE_ID
NAME
DATE_FROM
BEHAVIOURAL_INDICATOR
RATING_SCALE_ID

PER_ASSESSMENT_TYPES
ASSESSMENT_TYPE_ID
BUSINESS_GROUP_ID     
NAME
ASSESSMENT_CLASSIFICATION
RATING_SCALE_ID

PER_COMPETENCE_ELEMENTS
COMPETENCE_ELEMENT_ID
TYPE
COMPETENCE_ID
ASSESSMENT_ID
ASSESSMENT_TYPE_ID
COMPETENCE_TYPE

PER_APPRAISAL_TEMPLATES
APPRAISAL_TEMPLATE_ID
BUSINESS_GROUP_ID     
NAME
ASSESSMENT_TYPE_ID
RATING_SCALE_ID
QUESTIONNAIRE_TEMPLATE_ID

PER_APPRAISALS
APPRAISAL_ID                  
BUSINESS_GROUP_ID     
APPRAISAL_TEMPLATE_ID         
APPRAISEE_PERSON_ID           
APPRAISER_PERSON_ID           
APPRAISAL_DATE                
APPRAISAL_PERIOD_END_DATE     
APPRAISAL_PERIOD_START_DATE
TYPE                          
NEXT_APPRAISAL_DATE           
STATUS                        
OPEN

PER_ASSESSMENTS
ASSESSMENT_ID
BUSINESS_GROUP_ID     
ASSESSMENT_TYPE_ID
ASSESSMENT_DATE
STATUS
TOTAL_SCORE
APPRAISAL_ID

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect