MC_DEFN_CRIT (SQL Table)	Index Back
Mass Change Defn Criteria

MC_DEFN_CRIT

(SQL Table)

Mass Change Defn 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 MC_STMNT_SEQ Number(3,0) SMALLINT NOT NULL Mass Change Statement Sequence

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

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

5 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

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

7 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

8 MC_FIELD_LENGTH Number(3,0) SMALLINT NOT NULL Field Length

9 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions

10 FORMAT Number(2,0) SMALLINT NOT NULL Field Format
0=
If Fieldtype=0 (Character) then Upper Case
If Fieldtype=6 (DateTime) then HH:MM
1=Name
2=Phone Number North American (mandatory length 12 characters)
3=Zip/Postal Code North American (mandatory length 10 characters)
4=US Social Security Number (mandatory length 9 characters)
5=
6=Mixed Case
7=Raw/Binary
8=Numbers only
9=SIN (mandatory length 9 characters)
10=International Phone Number
11=Zip/Postal Code International
12=Time HH:MM:SS
13=Time HH:MM:SS.999999
14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MC_DEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Mass Change Definition
2	MC_STMNT_SEQ	Number(3,0)	SMALLINT NOT NULL	Mass Change Statement Sequence
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	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
6	MC_FIELD_LABEL	Character(50)	VARCHAR2(50) NOT NULL	Field Label
7	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
8	MC_FIELD_LENGTH	Number(3,0)	SMALLINT NOT NULL	Field Length
9	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
10	FORMAT	Number(2,0)	SMALLINT NOT NULL	Field Format 0= If Fieldtype=0 (Character) then Upper Case If Fieldtype=6 (DateTime) then HH:MM 1=Name 2=Phone Number North American (mandatory length 12 characters) 3=Zip/Postal Code North American (mandatory length 10 characters) 4=US Social Security Number (mandatory length 9 characters) 5= 6=Mixed Case 7=Raw/Binary 8=Numbers only 9=SIN (mandatory length 9 characters) 10=International Phone Number 11=Zip/Postal Code International 12=Time HH:MM:SS 13=Time HH:MM:SS.999999 14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)