MU_SETUP_TBL (SQL Table)	Index Back
MU Definition Definition of sets of changes on several populations to be processed via Mass Update.

MU_SETUP_TBL

(SQL Table)

MU Definition

Definition of sets of changes on several populations to be processed via Mass Update.

Related Language Record: MU_SETUP_LNG

Parent Record Of MU_SETUP_DTL MU_SETUP_DTLVW1 MU_SETUP_DTLVW2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

4 MU_COPY_FROM Character(15) VARCHAR2(15) NOT NULL Copy From
Prompt Table: MU_SETUP_TBL

5 MU_PRCS_MODE_FLG Character(1) VARCHAR2(1) NOT NULL Mass Update Process updates or adds values according to this flag.
I=Add a New Effective Date
U=Correct Current Information
Default Value: I

6 MU_REFERENCE_DT Date(10) DATE NOT NULL Mass Update process applies changes on effective dated row according to the date given reference date.

7 EFFDT Date(10) DATE Effective Date
Default Value: %date

8 MU_FUTURE_IND Character(1) VARCHAR2(1) NOT NULL Include Eligible Future Rows
Y/N Table Edit
Default Value: N

9 MU_STATUS Character(1) VARCHAR2(1) NOT NULL Mass Update Status
C=Closed
I=Initiated
N=New
P=In Progress
Default Value: N

10 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MU_ID	Character(15)	VARCHAR2(15) NOT NULL	Mass Update ID
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	MU_COPY_FROM	Character(15)	VARCHAR2(15) NOT NULL	Copy From Prompt Table: MU_SETUP_TBL
5	MU_PRCS_MODE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mass Update Process updates or adds values according to this flag. I=Add a New Effective Date U=Correct Current Information Default Value: I
6	MU_REFERENCE_DT	Date(10)	DATE NOT NULL	Mass Update process applies changes on effective dated row according to the date given reference date.
7	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
8	MU_FUTURE_IND	Character(1)	VARCHAR2(1) NOT NULL	Include Eligible Future Rows Y/N Table Edit Default Value: N
9	MU_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Mass Update Status C=Closed I=Initiated N=New P=In Progress Default Value: N
10	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data Default Value: N