HRMH_ORGACC_VW

(SQL View)
 Index Back

Matrix for Org View Type

This joins matrix to Org View Type for selection of active matrixes for the to show in the current org view type

SELECT A.HRMH_MATRIX_ID , A.EFFDT , A.EFF_STATUS , A.HRMH_OWNER_EMPLID , A.EMPL_RCD , A.HRMH_TITLE , A.DESCR , A.DESCRSHORT , A.HRMH_OWN_ONLY , A.HRMH_SOURCE , A.HRMH_OWN_TOP , A.ACCESS_TYPE , A.HRMH_EMPLID_START , A.HRMH_START_EMPLRCD , A.HRMH_POSN_START , A.GB_GROUP_ID , A.HR_DR_REFRESH_GRP , A.TREE_NAME , A.TREE_NODE_START , B.HRCD_ORGVIEW_TYPE FROM PS_HRMH_MATRX_DEFN A , PS_HRMH_ORG_ACCESS B WHERE A.HRMH_MATRIX_ID = B.HRMH_MATRIX_ID AND A.EFFDT = B.EFFDT AND A.EFF_STATUS = 'A' AND B.HRMH_ORGTYP_ACCESS = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRMH_MATRIX_ID Character(15) VARCHAR2(15) NOT NULL Matrix Identifier
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: I

4 HRMH_OWNER_EMPLID Character(11) VARCHAR2(11) NOT NULL Matrix Owner Employee ID

Prompt Table: HRMH_OWNER_VW

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 HRMH_TITLE Character(30) VARCHAR2(30) NOT NULL Hierarchy Member Employee Id
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
9 HRMH_OWN_ONLY Character(1) VARCHAR2(1) NOT NULL Show in Viewer for Owner Only
N=No
Y=Yes

Default Value: N

10 HRMH_SOURCE Character(1) VARCHAR2(1) NOT NULL Source for building an existing hierarchy.
A=Use Access Type
M=Manual
T=Use Tree

Default Value: M

11 HRMH_OWN_TOP Character(1) VARCHAR2(1) NOT NULL Owner is Top of Hierarchy
N=No
Y=Yes

Default Value: Y

12 ACCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type
1=By Dept Security Tree
2=By Supervisor ID
3=By Department Manager ID
4=By Reports To Position
5=By Part Posn Mgmt Supervisor
6=By Part Posn Mgmt Dept Mgr ID
7=By Group ID
13 HRMH_EMPLID_START Character(11) VARCHAR2(11) NOT NULL The Employee Id at the top of the hierarchy

Prompt Table: HRMH_EMPLID_VW

14 HRMH_START_EMPLRCD Number(3,0) SMALLINT NOT NULL Hierarchy Member Employee Id
15 HRMH_POSN_START Character(8) VARCHAR2(8) NOT NULL The Position Number at the top of the hierarchy

Prompt Table: POSITION_DATA

16 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

Prompt Table: HRMH_GROUP_VW

17 HR_DR_REFRESH_GRP Character(1) VARCHAR2(1) NOT NULL Direct Reports UI: Configuration option to force the refresh of Group Members when the Access Type is "Group".

Default Value: N

18 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: HRMH_TREE_VW

19 TREE_NODE_START Character(20) VARCHAR2(20) NOT NULL Start Tree Node

Prompt Table: %EDITTABLE

20 HRCD_ORGVIEW_TYPE Character(4) VARCHAR2(4) NOT NULL This field stores the Org View Type.
CDFL=Company Directory Fluid
CDOV=Company Directory
MGSS=Direct-Line Reports
MTRX=Matrix Reports