HR_MTRX_DEFN_VW

(SQL View)
 Index Back

Main definition of the matrix

Defines a Matrix Hierarchy

SELECT A.HRMH_MATRIX_ID , A.EFFDT , A.HRMH_MATRIX_TYPE , 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 , A.HR_DR_EX_CWR , A.COMMENTS , A.START_DT , A.END_DT , A.HRMH_OWNER_EMPLID2 FROM PS_HRMH_MATRX_DEFN A WHERE %EffdtCheck(HRMH_MATRX_DEFN B,A,%CurrentDatein)

  • Related Language Record: HRMH_MTRX_DEF_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRMH_MATRIX_ID Character(15) VARCHAR2(15) NOT NULL Matrix Identifier

    Default Value: NEW

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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

    Default Value: I

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

    Prompt Table: HRMH_OWNER_VW

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

    Default Value: N

    11 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

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

    Default Value: Y

    13 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
    14 HRMH_EMPLID_START Character(11) VARCHAR2(11) NOT NULL The Employee Id at the top of the hierarchy

    Prompt Table: HRMH_EMPLID_VW

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

    Prompt Table: POSITION_DATA

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

    Prompt Table: HRMH_GROUP_VW

    18 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

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

    Prompt Table: HRMH_TREE_VW

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

    Prompt Table: %EDITTABLE

    21 HR_DR_EX_CWR Character(1) VARCHAR2(1) NOT NULL Person Search - Simple: Switch to indicate whether Contingent Workers should be included in results.

    Y/N Table Edit

    Default Value: N

    22 COMMENTS Long Character CLOB Comment
    23 START_DT Date(10) DATE NOT NULL Start Date

    Default Value: %date

    24 END_DT Date(10) DATE end date
    25 HRMH_OWNER_EMPLID2 Character(11) VARCHAR2(11) NOT NULL Matrix Prior Owner Employee ID