HR_SRCH_DR_4(SQL Table) |
Index Back |
---|---|
SES:DirectReports AccessType 4Access Type 4 - Reports To This table uses Full Position Management. The relationship between an employee/job and a supervisor is defined by the "Reports To" position on the Job record. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
2 | SUPERVIS_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Supervisor employee record. |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
5 | 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. |
6 | 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 |
7 | JOB_EFFDT | Date(10) | DATE | Job Effective Date |
8 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
9 | POSITION_EFFDT | Date(10) | DATE | Report To Position Effective Date |
10 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |
11 | POSITION_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL | Override Position Data |
12 | SUPERVISOR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Y/N field to determine if a employee is a supervisor on the direct reports tables. |
13 | 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. |
14 | HR_SRCH_CTRL_ID | Number(10,0) | DECIMAL(10) NOT NULL | EIP Control Id |
15 | HR_SRCH_ASSOC_CD | Character(3) | VARCHAR2(3) NOT NULL |
SES: Association Code: Used in Associated facets
DEL=Delegations DIR=Direct Reports EMP=Employee IND=Indirect Reports NON=Not Associated SLF=Self |
16 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |