HR_EE_SEC_CLR (SQL Table)	Index Back
EE Security Clearance Types The Employee Security Clearance Type record stores details of all security clearance types associated with an employee, contingent worker, or person of interest.

HR_EE_SEC_CLR

(SQL Table)

EE Security Clearance Types

The Employee Security Clearance Type record stores details of all security clearance types associated with an employee, contingent worker, or person of interest.

Parent Record Of HR_EE_SC_INV_ST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 SEC_CLEARANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Security Clearance Type
Prompt Table: SEC_CLR_TYP_TBL

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

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

5 SEC_CLEARANCE_NUM Character(20) VARCHAR2(20) NOT NULL Security Clearance Number

6 EXPIRATION_DATE Date(10) DATE Expiration Date

7 SPONSOR Character(50) VARCHAR2(50) NOT NULL Sponsor

8 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator for Multiple
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	SEC_CLEARANCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Security Clearance Type Prompt Table: SEC_CLR_TYP_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	SEC_CLEARANCE_NUM	Character(20)	VARCHAR2(20) NOT NULL	Security Clearance Number
6	EXPIRATION_DATE	Date(10)	DATE	Expiration Date
7	SPONSOR	Character(50)	VARCHAR2(50) NOT NULL	Sponsor
8	PRIMARY_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Primary Indicator for Multiple Y/N Table Edit Default Value: N