MC_HIST_CRIT (SQL Table)	Index Back
Mass Change History Criteria

MC_HIST_CRIT

(SQL Table)

Mass Change History Criteria

# 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 ARITH_OPERATION Character(3) VARCHAR2(3) NOT NULL Arithmetic Operation
<=Less Than
<==Less Than or Equal To
<>=Not Equal To
==Equal To
>=Greater Than
>==Greater Than or Equal To
BLK=Is Blank
BTW=Between Value A and Value B
IN=In Subset
LIK=Like
NBL=Is Not Blank
NBT=Not Between
NIN=Not In
NLK=Not Like
NNL=Is Not Null
NUL=Is Null

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

#	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	ARITH_OPERATION	Character(3)	VARCHAR2(3) NOT NULL	Arithmetic Operation <=Less Than <==Less Than or Equal To <>=Not Equal To ==Equal To >=Greater Than >==Greater Than or Equal To BLK=Is Blank BTW=Between Value A and Value B IN=In Subset LIK=Like NBL=Is Not Blank NBT=Not Between NIN=Not In NLK=Not Like NNL=Is Not Null NUL=Is Null
7	MC_FIELD_LABEL	Character(50)	VARCHAR2(50) NOT NULL	Field Label