EOCM_CAT_SRC_VW (SQL View)	Index Back
Data Source Definition This is the definition for storing information about the data sources used by the Trading Partners

EOCM_CAT_SRC_VW

(SQL View)

Data Source Definition

This is the definition for storing information about the data sources used by the Trading Partners

SELECT SETID ,EOCM_ACCESS_ID ,EOCM_DATA_SRC_ID ,EOCM_PSRECORD_NAME ,EOEW_SRCDONAME ,EOCM_DATA_SRC_TYPE ,EOCM_DELIM_TYPE ,FLDDELIMITER ,DESCR ,EOCM_PSERRREC_NAME FROM PS_EOCM_DATA_SRC WHERE EOCM_CREATED_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: EOCM_SETID_VW

2 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID
Prompt Table: %EDITTABLE

3 EOCM_DATA_SRC_ID Character(10) VARCHAR2(10) NOT NULL Catalog Source ID

4 EOCM_PSRECORD_NAME Character(15) VARCHAR2(15) NOT NULL Field used by catalog management to store the actual peoplesoft record name for the data source.

5 EOEW_SRCDONAME Character(30) VARCHAR2(30) NOT NULL Source Data Object

6 EOCM_DATA_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Data Source Type 1 - Flat File 2 - XML 3 - CIF 4 - CUP
1=Flat File
2=xCBL File
3=CIF File
4=CUP File
Default Value: 1

7 EOCM_DELIM_TYPE Character(1) VARCHAR2(1) NOT NULL Delimiter Type 1 = Comma 2 = Semi Colon 3 = Tab 4 = Space 5 = Fixed 6 = Other
1=Comma
2=Semicolon
3=Tab
4=Space
5=Fixed Length
6=Other
Default Value: 1

8 FLDDELIMITER Character(1) VARCHAR2(1) NOT NULL Field Delimiter

9 DESCR Character(30) VARCHAR2(30) NOT NULL Description

10 EOCM_PSERRREC_NAME Character(15) VARCHAR2(15) NOT NULL Field used by Catalog Management to store the actual PeopleSoft error record name for the data source.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: EOCM_SETID_VW
2	EOCM_ACCESS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Field for storing the Partner ID Prompt Table: %EDITTABLE
3	EOCM_DATA_SRC_ID	Character(10)	VARCHAR2(10) NOT NULL	Catalog Source ID
4	EOCM_PSRECORD_NAME	Character(15)	VARCHAR2(15) NOT NULL	Field used by catalog management to store the actual peoplesoft record name for the data source.
5	EOEW_SRCDONAME	Character(30)	VARCHAR2(30) NOT NULL	Source Data Object
6	EOCM_DATA_SRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Data Source Type 1 - Flat File 2 - XML 3 - CIF 4 - CUP 1=Flat File 2=xCBL File 3=CIF File 4=CUP File Default Value: 1
7	EOCM_DELIM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Delimiter Type 1 = Comma 2 = Semi Colon 3 = Tab 4 = Space 5 = Fixed 6 = Other 1=Comma 2=Semicolon 3=Tab 4=Space 5=Fixed Length 6=Other Default Value: 1
8	FLDDELIMITER	Character(1)	VARCHAR2(1) NOT NULL	Field Delimiter
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	EOCM_PSERRREC_NAME	Character(15)	VARCHAR2(15) NOT NULL	Field used by Catalog Management to store the actual PeopleSoft error record name for the data source.