SAD_CRM_STG_TXT (SQL Table)	Index Back
CRM Long Text Staging Record This child record of the TS189 Staging tables is used to store the Long Text responses that are transmitted from the CRM system.

SAD_CRM_STG_TXT

(SQL Table)

CRM Long Text Staging Record

This child record of the TS189 Staging tables is used to store the Long Text responses that are transmitted from the CRM system.

Parent record: ADM_T189_CRM_EC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)

2 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.

3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
Default Value: I

4 TRANS_CNTRL_NBR Character(9) VARCHAR2(9) NOT NULL Transaction Set Control Number

5 SAD_CRM_TOPIC_ID Number(18,0) DECIMAL(18) NOT NULL Field used to store the unique identifier of the topic to which the applicant has responded that is being passed from the CRM system.
Prompt Table: SAD_CRM_TPC_TBL

6 SAD_CRM_LONG_TEXT Long Character CLOB SAD_CRM_LONG_TEXT is used to store the Long Text response an applicant may have given in the CRM system

7 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Posting Status

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
2	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
3	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound Default Value: I
4	TRANS_CNTRL_NBR	Character(9)	VARCHAR2(9) NOT NULL	Transaction Set Control Number
5	SAD_CRM_TOPIC_ID	Number(18,0)	DECIMAL(18) NOT NULL	Field used to store the unique identifier of the topic to which the applicant has responded that is being passed from the CRM system. Prompt Table: SAD_CRM_TPC_TBL
6	SAD_CRM_LONG_TEXT	Long Character	CLOB	SAD_CRM_LONG_TEXT is used to store the Long Text response an applicant may have given in the CRM system
7	POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Posting Status