SAD_PRS_ETH_SUS (SQL Table)	Index Back
Temp Msg Record Table Message record table to hold the bio-demo and prospect information to be messaged over to CRM when Search/Match/Post batch process is run for Posting to CRM.

SAD_PRS_ETH_SUS

(SQL Table)

Temp Msg Record Table

Message record table to hold the bio-demo and prospect information to be messaged over to CRM when Search/Match/Post batch process is run for Posting to CRM.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

3 TEST_REC_NBR Number(9,0) DECIMAL(9) NOT NULL Test Type Record Nbr

4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

5 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

6 HISP_LATINO Character(1) VARCHAR2(1) NOT NULL Hispanic or Latino
Y/N Table Edit
Default Value: N

7 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator for Multiple

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	TEST_REC_NBR	Number(9,0)	DECIMAL(9) NOT NULL	Test Type Record Nbr
4	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
5	ETHNIC_GRP_CD	Character(8)	VARCHAR2(8) NOT NULL	Ethnic group code
6	HISP_LATINO	Character(1)	VARCHAR2(1) NOT NULL	Hispanic or Latino Y/N Table Edit Default Value: N
7	PRIMARY_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Primary Indicator for Multiple