SEC_CLR_TYP_TBL

(SQL Table)
Index Back

Security Clearance Type Table

The Security Clearance Type record stores all details of security types that can be assigned to Employees, Contingent Workers, and Persons of Interest.

  • Related Language Record: SEC_CLR_TYP_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SEC_CLEARANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Security Clearance Type
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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

    Default Value: A

    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description