HRMH_MATRX_MEMB (SQL Table)	Index Back
Manually Maintained Matrix If the matrix is manually built the members and hierarchy are stored here

HRMH_MATRX_MEMB

(SQL Table)

Manually Maintained Matrix

If the matrix is manually built the members and hierarchy are stored here

Related Language Record: HRMH_MTRX_MEM_L

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: HRMH_EMPLID_VW

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

5 HRMH_MATRIX_TYPE Character(3) VARCHAR2(3) NOT NULL Matrix Type
Default Value: CFR
Prompt Table: HRMH_MTRX_TYPE

6 HRMH_TITLE Character(30) VARCHAR2(30) NOT NULL Hierarchy Member Employee Id

7 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
Default Value: HRMH_MATRX_DEFN.HRMH_OWNER_EMPLID
Prompt Table: HRMH_REPTO_DVW

8 SUPERVIS_EMPL_RCD Number(3,0) SMALLINT NOT NULL Supervisor employee record.

9 HRMH_MEMBER_ROLE Character(30) VARCHAR2(30) NOT NULL Member Role

10 START_DT Date(10) DATE Start Date
Default Value: %date

11 END_DT Date(10) DATE end date

12 HRMH_NEW_START_DT Date(10) DATE New Start Date

13 HRMH_NEW_END_DT Date(10) DATE New End Date

14 HRMH_MEMBER_ACTION Character(3) VARCHAR2(3) NOT NULL To capture Member Action like Add Member/Change Duration/Inactivate Member
A=Add Member
AM=Add Member
C=Change Duration
CD=Change Duration
I=Inactive Member
IM=Inactive Member

15 HRMH_MEMBER_STATUS Character(1) VARCHAR2(1) NOT NULL Matrix Member Status
A=Active
D=Denied
F=Draft
I=Inactive
P=Pending
Default Value: A

16 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
Default Value: S

17 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: HRMH_EMPLID_VW
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	HRMH_MATRIX_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Matrix Type Default Value: CFR Prompt Table: HRMH_MTRX_TYPE
6	HRMH_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Hierarchy Member Employee Id
7	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID Default Value: HRMH_MATRX_DEFN.HRMH_OWNER_EMPLID Prompt Table: HRMH_REPTO_DVW
8	SUPERVIS_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Supervisor employee record.
9	HRMH_MEMBER_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Member Role
10	START_DT	Date(10)	DATE	Start Date Default Value: %date
11	END_DT	Date(10)	DATE	end date
12	HRMH_NEW_START_DT	Date(10)	DATE	New Start Date
13	HRMH_NEW_END_DT	Date(10)	DATE	New End Date
14	HRMH_MEMBER_ACTION	Character(3)	VARCHAR2(3) NOT NULL	To capture Member Action like Add Member/Change Duration/Inactivate Member A=Add Member AM=Add Member C=Change Duration CD=Change Duration I=Inactive Member IM=Inactive Member
15	HRMH_MEMBER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Matrix Member Status A=Active D=Denied F=Draft I=Inactive P=Pending Default Value: A
16	WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Workflow Status A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved Default Value: S
17	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
18	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.