GVT_CYBR_SPLTY (SQL Table)	Index Back
Specialty Area table Cyber Security Specalty Area table

GVT_CYBR_SPLTY

(SQL Table)

Specialty Area table

Cyber Security Specalty Area table

Related Language Record: GVT_CYBRSPTYLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GVT_CYBER_CATEGORY Character(2) VARCHAR2(2) NOT NULL Cyber Security Category
10=Analyze
20=Investigate
30=Collect and Operate
40=Operate and Maintain
50=Protect and Defend
60=Securely Provision
70=Oversee and Govern
80=Oversee and Govern
90=Oversee and Govern
Prompt Table: GVT_CYBCATGRYVW

2 GVT_CYBER_SPECLTY Character(2) VARCHAR2(2) NOT NULL Specialty Area

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 GVT_CYB_SPLCD3 Character(3) VARCHAR2(3) NOT NULL Cyber Security Work role code

6 GVT_DESCR70 Character(70) VARCHAR2(70) NOT NULL Description Field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GVT_CYBER_CATEGORY	Character(2)	VARCHAR2(2) NOT NULL	Cyber Security Category 10=Analyze 20=Investigate 30=Collect and Operate 40=Operate and Maintain 50=Protect and Defend 60=Securely Provision 70=Oversee and Govern 80=Oversee and Govern 90=Oversee and Govern Prompt Table: GVT_CYBCATGRYVW
2	GVT_CYBER_SPECLTY	Character(2)	VARCHAR2(2) NOT NULL	Specialty Area
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	GVT_CYB_SPLCD3	Character(3)	VARCHAR2(3) NOT NULL	Cyber Security Work role code
6	GVT_DESCR70	Character(70)	VARCHAR2(70) NOT NULL	Description Field