MC_HIST_DEFAULT (SQL Table)	Index Back
Mass Change History Defaults

MC_HIST_DEFAULT

(SQL Table)

Mass Change History Defaults

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition

2 DTTM_STAMP 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.

3 MC_STMNT_SEQ Number(3,0) SMALLINT NOT NULL Mass Change Statement Sequence

4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

6 MC_FIELD_LABEL Character(50) VARCHAR2(50) NOT NULL Field Label

7 MC_FIELD_VALUE Character(250) VARCHAR2(250) NOT NULL Mass Change Field Value
Prompt Table: %EDITTABLE2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MC_DEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Mass Change Definition
2	DTTM_STAMP	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.
3	MC_STMNT_SEQ	Number(3,0)	SMALLINT NOT NULL	Mass Change Statement Sequence
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	MC_FIELD_LABEL	Character(50)	VARCHAR2(50) NOT NULL	Field Label
7	MC_FIELD_VALUE	Character(250)	VARCHAR2(250) NOT NULL	Mass Change Field Value Prompt Table: %EDITTABLE2