GVT_CLS_LVL_TBL (SQL Table)	Index Back
Classification Levels Table GVT: This table is used by the US Federal Government's Job Code Classification process. It identifies the levels that apply to each classification factor and assigns point values. In the Job Code rating and ranking process, the point values for the selected levels within all factors are added together for a Point Total. This point total is then compared to a Grade Conversion Chart for the Standard to ensure the selected Grade is the appropriate grade.

GVT_CLS_LVL_TBL

(SQL Table)

Classification Levels Table

GVT: This table is used by the US Federal Government's Job Code Classification process. It identifies the levels that apply to each classification factor and assigns point values. In the Job Code rating and ranking process, the point values for the selected levels within all factors are added together for a Point Total. This point total is then compared to a Grade Conversion Chart for the Standard to ensure the selected Grade is the appropriate grade.

Parent record: GVT_CLS_FCTR_TB

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GVT_CLS_STANDARD Character(15) VARCHAR2(15) NOT NULL Classification Standard
Prompt Table: GVT_CLS_STD_TBL

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 GVT_CLS_FACTOR Character(2) VARCHAR2(2) NOT NULL Classification Factor
01=Knowledge Required
02=Supervisory Controls
03=Guidelines
04=Complexity
05=Scope and Effect
06=Personal Contacts
07=Purpose of Contacts
08=Physical Demands
09=Work Environment
10=Supervisory Difficulty&Scope
11=Supv Authority&Responsibility
12=Degree Supervision Exercised
13=Program Management

4 GVT_CLS_LEVEL Character(1) VARCHAR2(1) NOT NULL Classification Factor Level

5 GVT_CLS_POINTS Number(4,0) SMALLINT NOT NULL Classification Levels
Default Value: 0000

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GVT_CLS_STANDARD	Character(15)	VARCHAR2(15) NOT NULL	Classification Standard Prompt Table: GVT_CLS_STD_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GVT_CLS_FACTOR	Character(2)	VARCHAR2(2) NOT NULL	Classification Factor 01=Knowledge Required 02=Supervisory Controls 03=Guidelines 04=Complexity 05=Scope and Effect 06=Personal Contacts 07=Purpose of Contacts 08=Physical Demands 09=Work Environment 10=Supervisory Difficulty&Scope 11=Supv Authority&Responsibility 12=Degree Supervision Exercised 13=Program Management
4	GVT_CLS_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Classification Factor Level
5	GVT_CLS_POINTS	Number(4,0)	SMALLINT NOT NULL	Classification Levels Default Value: 0000