GVT_CYBERSEC_CD

(SQL Table)
 Index Back

Cyber Security Speciality

October 2017 Changes: New fields for category/speciality/workrole/long description added.

  • Related Language Record: GVT_CYBER_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_CYBER_SEC_CD Character(3) VARCHAR2(3) NOT NULL Cyber Security Category / Speciality Area
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 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

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

    Prompt Table: GVT_CYBR_SPLTY

    6 GVT_CYBER_WRKROL Character(3) VARCHAR2(3) NOT NULL Cyber Security Work role code

    Prompt Table: GVT_CYBR_WK_ROL

    7 GVT_DESCR40 Character(40) VARCHAR2(40) NOT NULL Description Field
    8 GVT_DESCR70 Character(70) VARCHAR2(70) NOT NULL Description Field
    9 GVT_LONG_DESCR Long Character CLOB Long description fields used in Cyber Securiry setup record