HR_DRPT_4I_VW(SQL View) |
Index Back |
---|---|
Direct Reports by "Reports To"Used internally by the HR Direct Reports class, this view returns a list of employee/jobs that report to a set of positions, when one or more "supervisor's" positions is "joined" to this view. This is used to determine the number of Indirect Reports for one or more employees, and can only be used to successfully return all employees when Full Position Management has been implemented. |
SELECT JOB.REPORTS_TO , JOB.POSITION_NBR , JOB.EMPLID , JOB.EMPL_RCD , JOB.EFFDT , JOB.EFFSEQ , JOB.EMPL_STATUS , JOB.HR_STATUS FROM PS_JOB JOB WHERE (JOB.POSITION_NBR > ' ' OR REPORTS_TO > ' ') AND JOB.EFFSEQ=( SELECT MAX(JOB3.EFFSEQ) FROM PS_JOB JOB3 WHERE JOB.EMPLID=JOB3.EMPLID AND JOB.EMPL_RCD=JOB3.EMPL_RCD AND JOB.EFFDT=JOB3.EFFDT) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |
2 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
6 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
7 | 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 |
8 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
HR Status
A=Active I=Inactive |