RA_HEMC_CRIT (SQL Table)	Index Back
Marketing Center Criteria Marketing Center selection criteria rows

RA_HEMC_CRIT

(SQL Table)

Marketing Center Criteria

Marketing Center selection criteria rows

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RA_MKT_CENTER Character(10) VARCHAR2(10) NOT NULL Marketing Center code

2 RA_MC_CRIT_SEQ Number(3,0) SMALLINT NOT NULL Marketing Center criteria sequence number

3 RA_AND_OR_WITH Character(4) VARCHAR2(4) NOT NULL Marketing Center Selection Criteria an/or/with value
AND=And
OR=Or
WITH=With
Default Value: OR
Prompt Table: RA_MCORWITH_VW

4 RA_ATTRIBUTE_ID Number(18,0) DECIMAL(18) NOT NULL Profile / Attribute ID
Prompt Table: RA_ATTRIBUTE

5 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID
Default Value: 1304
Prompt Table: RA_PROFILE

6 RA_PRF_ATTRIB_OPER Character(4) VARCHAR2(4) NOT NULL This field stores the operator for use in audience builder and manage profile changes.

7 RA_VALUE_CHAR254 Character(254) VARCHAR2(254) NOT NULL Holds a string value for audience builder and manage profile updates criteria.
Prompt Table: %EDITTABLE

8 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

9 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

10 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

11 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

12 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

13 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RA_MKT_CENTER	Character(10)	VARCHAR2(10) NOT NULL	Marketing Center code
2	RA_MC_CRIT_SEQ	Number(3,0)	SMALLINT NOT NULL	Marketing Center criteria sequence number
3	RA_AND_OR_WITH	Character(4)	VARCHAR2(4) NOT NULL	Marketing Center Selection Criteria an/or/with value AND=And OR=Or WITH=With Default Value: OR Prompt Table: RA_MCORWITH_VW
4	RA_ATTRIBUTE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Profile / Attribute ID Prompt Table: RA_ATTRIBUTE
5	RA_PROFILE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Profile - profile ID Default Value: 1304 Prompt Table: RA_PROFILE
6	RA_PRF_ATTRIB_OPER	Character(4)	VARCHAR2(4) NOT NULL	This field stores the operator for use in audience builder and manage profile changes.
7	RA_VALUE_CHAR254	Character(254)	VARCHAR2(254) NOT NULL	Holds a string value for audience builder and manage profile updates criteria. Prompt Table: %EDITTABLE
8	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
9	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
10	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
11	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
12	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
13	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time