IND_MKT_DATA_VW

(SQL View)
 Index Back

Marketing Specific BO Data

This is a Marketing Specific BO Data view of Individuals.

SELECT A.BO_ID , A.EXTERNAL_LIST_ID , A.SOURCE_SYSID , A.DATASET_SYSID , A.DEPARTMENT , A.NCOA_LAST_OVERLAY , A.ORIGIN , A.DO_NOT_EMAIL , A.DUNS_NUMBER , A.FUNCTIONAL_TITLE , %subrec(RB_AUDIT_SBR,A) FROM PS_BO_MKT_DATA A , PS_BO B WHERE A.BO_ID = B.BO_ID AND B.BO_TYPE_ID = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 EXTERNAL_LIST_ID Character(20) VARCHAR2(20) NOT NULL External List Id
3 SOURCE_SYSID Number(18,0) DECIMAL(18) NOT NULL Source System ID
4 DATASET_SYSID Number(18,0) DECIMAL(18) NOT NULL Data Set ID

Default Value: 1

5 DEPARTMENT Character(40) VARCHAR2(40) NOT NULL Department
6 NCOA_LAST_OVERLAY Date(10) DATE NCOA Last Overlay Date
7 ORIGIN Character(40) VARCHAR2(40) NOT NULL Origin
8 DO_NOT_EMAIL Character(1) VARCHAR2(1) NOT NULL Do Not Email
N=No
Y=Yes
9 DUNS_NUMBER Character(20) VARCHAR2(20) NOT NULL DUNS Number
10 FUNCTIONAL_TITLE Character(40) VARCHAR2(40) NOT NULL Functional Title
11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
15 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.
16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time