HRBP_TM_MEMB_VW

#	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
6	HRMH_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Hierarchy Member Employee Id
7	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
8	HRMH_MEMBER_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Member Role
9	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID Default Value: HRMH_MATRX_DEFN.HRMH_OWNER_EMPLID Prompt Table: HRMH_REPTO_DVW
10	SUPERVIS_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Supervisor employee record.
11	START_DT	Date(10)	DATE	Start Date Default Value: %date
12	END_DT	Date(10)	DATE	end date
13	HRMH_NEW_START_DT	Date(10)	DATE	New Start Date
14	HRMH_NEW_END_DT	Date(10)	DATE	New End Date
15	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
16	HRMH_MEMBER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Matrix Member Status A=Active D=Denied F=Draft I=Inactive P=Pending
17	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