GVT_CLS_FCTR_TB (SQL Table)	Index Back
Classification Factors Table GVT: This table is used in the US Federal Governement's Job Code Classification process. It identifies the pertinent factors by classification standard used to classify, rate, and rank Job Codes.

GVT_CLS_FCTR_TB

(SQL Table)

Classification Factors Table

GVT: This table is used in the US Federal Governement's Job Code Classification process. It identifies the pertinent factors by classification standard used to classify, rate, and rank Job Codes.

Parent record: GVT_CLS_STD_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GVT_CLS_STANDARD Character(15) VARCHAR2(15) NOT NULL Classification Standard

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 COMMENTS Long Character CLOB NOT NULL Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GVT_CLS_STANDARD	Character(15)	VARCHAR2(15) NOT NULL	Classification Standard
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	COMMENTS	Long Character	CLOB NOT NULL	Comment