RY_VC_WEB_IMP

(SQL Table)
Index Back

VC Web Impressions Log

Transaction Log for VC Web 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 RY_SR_ACTION_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
6 REPEAT_SEQ_NUMBER Number(18,0) DECIMAL(18) NOT NULL Repeat Number
7 RY_VC_REFER_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
8 RY_PRNT_VC_REF_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
9 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
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