RSP_ACCTM_MERGE (SQL Table)	Index Back
Account Team Merge Options Merge options for Sales Account Teams when integrating with Customer Data Hub.

RSP_ACCTM_MERGE

(SQL Table)

Account Team Merge Options

Merge options for Sales Account Teams when integrating with Customer Data Hub.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACCOUNT_TEAM_MERGE Character(1) VARCHAR2(1) NOT NULL Option used when integrating to CDH and a company is to be merged in CDM.
C=Combine Account Teams
D=Remove Account Teams
R=Retain Survivor Account Team
Default Value: C

2 RSP_ACCT_TEAM_ALL Character(1) VARCHAR2(1) NOT NULL Used by Strategic Account planning CDH merge options. Indicates whether or not email should be sent to all account team members after two companies have been merged.
Y/N Table Edit
Default Value: N

3 RSP_ACCT_TEAM_PRI Character(1) VARCHAR2(1) NOT NULL Used by Strategic Account planning CDH merge options. Indicates whether or not email should be sent to primary team members after two companies have been merged.
Y/N Table Edit
Default Value: Y

4 RSP_ACCT_TEAM_TASK Character(1) VARCHAR2(1) NOT NULL Used by Strategic Account planning CDH merge options. Indicates whether or not task should be created for the Sales Admin role after two companies have been merged.
Y/N Table Edit
Default Value: N

5 RSP_ACCT_TEAM_MAIL Character(1) VARCHAR2(1) NOT NULL Used by Strategic Account planning CDH merge options. Indicates whether or not email should be sent to Sales Admin after two companies have been merged.
Y/N Table Edit
Default Value: N

6 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: RB_TD_ROLE_VW

7 YES_NO Character(1) VARCHAR2(1) NOT NULL Indicator flag -- Yes (Y) or No (N)
N=No
Y=Yes
Y/N Table Edit
Default Value: Y

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	ACCOUNT_TEAM_MERGE	Character(1)	VARCHAR2(1) NOT NULL	Option used when integrating to CDH and a company is to be merged in CDM. C=Combine Account Teams D=Remove Account Teams R=Retain Survivor Account Team Default Value: C
2	RSP_ACCT_TEAM_ALL	Character(1)	VARCHAR2(1) NOT NULL	Used by Strategic Account planning CDH merge options. Indicates whether or not email should be sent to all account team members after two companies have been merged. Y/N Table Edit Default Value: N
3	RSP_ACCT_TEAM_PRI	Character(1)	VARCHAR2(1) NOT NULL	Used by Strategic Account planning CDH merge options. Indicates whether or not email should be sent to primary team members after two companies have been merged. Y/N Table Edit Default Value: Y
4	RSP_ACCT_TEAM_TASK	Character(1)	VARCHAR2(1) NOT NULL	Used by Strategic Account planning CDH merge options. Indicates whether or not task should be created for the Sales Admin role after two companies have been merged. Y/N Table Edit Default Value: N
5	RSP_ACCT_TEAM_MAIL	Character(1)	VARCHAR2(1) NOT NULL	Used by Strategic Account planning CDH merge options. Indicates whether or not email should be sent to Sales Admin after two companies have been merged. Y/N Table Edit Default Value: N
6	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: RB_TD_ROLE_VW
7	YES_NO	Character(1)	VARCHAR2(1) NOT NULL	Indicator flag -- Yes (Y) or No (N) N=No Y=Yes Y/N Table Edit Default Value: Y
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