HR_MASS_TMP_VW (SQL View)	Index Back
View for MU Report The table is used to retrieve data for mass change number 0 by the report HRMASS.sqr.

HR_MASS_TMP_VW

(SQL View)

View for MU Report

The table is used to retrieve data for mass change number 0 by the report HRMASS.sqr.

SELECT MU_ID ,MU_CHG_NUM ,SEQ_NBR ,DESCR100 FROM PS_HR_MASS_TMP WHERE MU_CHG_NUM = 0 AND MU_TRANS_ID = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MU_ID Character(15) VARCHAR2(15) NOT NULL Mass Update ID

2 MU_CHG_NUM Number(3,0) SMALLINT NOT NULL Change Number

3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MU_ID	Character(15)	VARCHAR2(15) NOT NULL	Mass Update ID
2	MU_CHG_NUM	Number(3,0)	SMALLINT NOT NULL	Change Number
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description