HR_JTREE_VW(SQL View) |
Index Back |
|---|---|
Temp Table Job Tree BuilderNon-primary supervisors |
| SELECT FILL.PROCESS_INSTANCE , FILL.SUPERVISOR_ID , FILL.SUPERVISOR_ERN , FILL.EMPLID , FILL.EMPL_RCD , FILL.TREE_NODE , FILL.PARENT_NODE_NAME , FILL.TREE_LEVEL_NUM , FILL.EMPL_STATUS , FILL.JOB_INDICATOR , FILL.DRILL_DOWN_FLAG , FILL.INDR_COUNT , SUPER.INDR_COUNT FROM PS_HR_JTREE_TAO FILL , PS_HR_JTREE_TAO super WHERE super.tree_node = fill.parent_node_name UNION SELECT PROCESS_INSTANCE , SUPERVISOR_ID , SUPERVISOR_ERN , EMPLID , EMPL_RCD , TREE_NODE , PARENT_NODE_NAME , TREE_LEVEL_NUM , EMPL_STATUS , JOB_INDICATOR , DRILL_DOWN_FLAG , INDR_COUNT , INDR_COUNT FROM PS_HR_JTREE_TAO A WHERE TREE_LEVEL_NUM = ( SELECT MIN(TREE_LEVEL_NUM) FROM PS_HR_JTREE_TAO B WHERE a.supervisor_id = b.supervisor_id AND A.supervisor_ern = b.supervisor_ern AND a.emplid = b.emplid AND A.empl_rcd = b.empl_rcd) AND NOT EXISTS ( SELECT 'x' FROM PS_HR_JTREE_TAO super WHERE super.tree_node = a.parent_node_name) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 |  SUPERVISOR_ID |
Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 3 | SUPERVISOR_ERN |
Number(3,0) | SMALLINT NOT NULL | This is used to hold the Employment Record Number of a supervisor. |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 7 | PARENT_NODE_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Name of parent node |
| 8 | TREE_LEVEL_NUM |
Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 9 | 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 |
| 10 | JOB_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable P=Primary Job S=Secondary Job |
| 11 | 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. |
| 12 | INDR_COUNT | Number(7,0) | INTEGER NOT NULL | Indirect Reports Count |
| 13 | PARENT_DR_COUNT | Number(7,0) | INTEGER NOT NULL | Direct Reports Count of supervisor |