HR_SRCH_CHG_3 (SQL Table)	Index Back
SES:Direct Reports Type 3 Temp Temporary table for incremental build of Direct Reports for Access Type 3 by manager id This table contains those employees who need updates during an incremtal run of the driect reports table build for this access type

HR_SRCH_CHG_3

(SQL Table)

SES:Direct Reports Type 3 Temp

Temporary table for incremental build of Direct Reports for Access Type 3 by manager id This table contains those employees who need updates during an incremtal run of the driect reports table build for this access type

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

4 OLD_SUPER_ID Character(11) VARCHAR2(11) NOT NULL Old Supervisor

5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

6 DEPTID_PRIOR Character(10) VARCHAR2(10) NOT NULL Prior Deptid Value

7 CHANGED Character(1) VARCHAR2(1) NOT NULL Field introduced with Rules to differentiate pure template-based rules from those subsequently customized.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
4	OLD_SUPER_ID	Character(11)	VARCHAR2(11) NOT NULL	Old Supervisor
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
6	DEPTID_PRIOR	Character(10)	VARCHAR2(10) NOT NULL	Prior Deptid Value
7	CHANGED	Character(1)	VARCHAR2(1) NOT NULL	Field introduced with Rules to differentiate pure template-based rules from those subsequently customized.