RY_VC_EM_IMPR

(SQL Table)
Index Back

VC Email Impressions Log

Transaction Log for VC EMail Impressions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RY_RECORD_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
2 RY_IND_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
3 RY_ACTION_ID Number(18,0) DECIMAL(18) NOT NULL Id for a dialog element for the dialog designer.
4 RY_LIST_ID Number(18,0) DECIMAL(18) NOT NULL Audience ID for Dialogs, used in the dialog designer.
5 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
6 RY_VC_REFER_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
7 RY_PRNT_VC_REF_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
8 RY_SR_ACTION_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
9 REPEAT_SEQ_NUMBER Number(18,0) DECIMAL(18) NOT NULL Repeat Number
10 DEFLT_IMPRESS_CODE Character(100) VARCHAR2(100) NOT NULL Default Impression Code
11 RY_MERGE_FLD_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
12 EXTERN_CONT_ID Character(100) VARCHAR2(100) NOT NULL External Content ID
13 OPTIONAL_ID_1 Character(100) VARCHAR2(100) NOT NULL OPTIONAL_ID_1
14 OPTIONAL_ID_2 Character(100) VARCHAR2(100) NOT NULL OPTIONAL_ID_2
15 OPTIONAL_ID_3 Character(100) VARCHAR2(100) NOT NULL OPTIONAL_ID_3