HRCD_JBTRSR2_VW

(SQL View)
 Index Back

Co Directory-Tree Src View

Company Directory - Tree Source View

SELECT T.TREE_NODE , T.EMPLID , T.EMPL_RCD , %Substring(A.NAME_DISPLAY, 1, 30) FROM PS_HRCD_JOB_TREE T , PS_NAMES A WHERE T.EMPLID = A.EMPLID AND A.NAME_TYPE = 'PRI' AND A.EFFDT IN ( SELECT MAX ( B.EFFDT ) FROM PS_NAMES B WHERE B.EMPLID = A.EMPLID AND B.NAME_TYPE = A.NAME_TYPE AND B.NAME_TYPE = 'PRI' AND B.EFFDT <= %CurrentDateIn ) UNION SELECT T.TREE_NODE , T.EMPLID , T.EMPL_RCD , M.MESSAGE_TEXT %Concat ' ' %Concat %Substring (T.EMPLID, 4, length( T.EMPLID)) FROM PS_HRCD_JOB_TREE T , PSMSGCATDEFN M WHERE MESSAGE_SET_NBR = 1010 AND MESSAGE_NBR = 2192 AND %Substring(T.Emplid,1,3) = 'EP$'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

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

Prompt Table: PER_ORG_ASGN

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description