HR_DIRRPT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	STARTDATETIME	DateTime(26)	TIMESTAMP	Start Datetime
3	HR_DR_ACCESS_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Direct Reports Table Build. Determines the Access Type Tables to build. 0=All Access Methods 2=2 - Supervisor Id 3=3 - Department Manager ID 4=4 - Reports To Position 5=5 - Position / Supervisor ID 6=6 - Position / Dept Manager Default Value: 0
4	HR_DR_UPDT_MODE	Character(1)	VARCHAR2(1) NOT NULL	Determines whether the process rebuilds the entire direct reports tables or just updates information for those rows that are not current in the direct reports tables. F=Full - Complete Rebuild I=Incremental - Current Date Upd Default Value: F
5	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
6	RECNAME_2	Character(15)	VARCHAR2(15) NOT NULL	Record 2 Name
7	RECNAME_3	Character(15)	VARCHAR2(15) NOT NULL	Record 2 Name
8	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
9	SUPERVIS_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Supervisor employee record.
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
12	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
13	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
14	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
15	DEPT_EFFDT	Date(10)	DATE	Department Table Effective Date
16	JOB_EFFDT	Date(10)	DATE	Job Effective Date
17	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
18	POSITION_EFFDT	Date(10)	DATE	Report To Position Effective Date
19	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
20	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data
21	HR_DR_LEVEL	Number(3,0)	SMALLINT NOT NULL	Number denoting how many levels down the organizational chart the employee is from the supervisor. Direct reports are always level 1.
22	SUPERVISOR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to determine if a employee is a supervisor on the direct reports tables.
23	DRILL_DOWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to determine if the row will appear in the dynamic drill down query. These rows appear in the getsupervisor query.
24	SQLTEXT	Long Character(14000)	CLOB	SQL Statement Text