SAD_CRM_STG_FIL (SQL Table)	Index Back
CRM/SA Integ TS189 File Stagin This child record of the TS189 Staging tables is used to store the File Attachment Locator information that is transmitted from the CRM system.

SAD_CRM_STG_FIL

(SQL Table)

CRM/SA Integ TS189 File Stagin

This child record of the TS189 Staging tables is used to store the File Attachment Locator information that is 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 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).
Prompt Table: PSURLDEFN

7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

8 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

9 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Posting Status
Default Value: N

10 ATTACHVIEW Character(1) VARCHAR2(1) NOT NULL View Attachment

#	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	URL_ID	Character(30)	VARCHAR2(30) NOT NULL	URL Identifier (see PSURLDEFN). Prompt Table: PSURLDEFN
7	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
8	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
9	POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Posting Status Default Value: N
10	ATTACHVIEW	Character(1)	VARCHAR2(1) NOT NULL	View Attachment