HR_EE_SC_INV_ST (SQL Table)	Index Back
EE Sec. Clr. Investigation Sts The Employee Security Clearance - Investigation Status record stores details regarding the current status of all investigation actions concerning the employee's security clearance type.

HR_EE_SC_INV_ST

(SQL Table)

EE Sec. Clr. Investigation Sts

The Employee Security Clearance - Investigation Status record stores details regarding the current status of all investigation actions concerning the employee's security clearance type.

Parent record: HR_EE_SEC_CLR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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 SEC_CLR_INVSTG_STS Character(1) VARCHAR2(1) NOT NULL Security Clearance Investigation Status
A=Approved
D=Denied
I=Initiated
P=In Progress

5 STATUS_DT Date(10) DATE Status Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
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	SEC_CLR_INVSTG_STS	Character(1)	VARCHAR2(1) NOT NULL	Security Clearance Investigation Status A=Approved D=Denied I=Initiated P=In Progress
5	STATUS_DT	Date(10)	DATE	Status Date