EOCM_CAT_MST_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_MST_VW

(SQL View)

Data Source Definition

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

SELECT DISTINCT A.SETID ,B.EOCM_ACCESS_ID ,D.DESCR ,A.EOCM_DATA_SRC_ID ,C.SEQNUM ,A.EOCM_PSRECORD_NAME ,A.EOEW_SRCDONAME ,A.EOCM_DATA_SRC_TYPE ,A.EOCM_DELIM_TYPE ,A.FLDDELIMITER ,A. ATTACHSYSFILENAME ,A.ATTACHUSERFILE ,A.EOCM_FIRST_LINE ,A.EOCM_OTHER_LINE , C.EOCM_FIELD_NAME , C.FLDLENGTH , C.DECIMALPOS , C.EOCM_FIELD_TYPE , C.EOCM_PS_FLD_NAME , C.EOCM_DATA_QLFR , C.EOCM_DATA_STRIP ,A.EOCM_CREATED_FLAG ,A.CREATED_DTTM ,A.CREATEOPRID ,A.LASTUPDDTTM ,A.LASTUPDOPRID ,A.EOCM_SRC_OPTION ,A.EOCM_PSERRREC_NAME FROM PS_EOCM_DATA_MST A , PS_EOCM_DSMST_PART B , PS_EOCM_DSMST_FLDS C , PS_EOCM_TRDPARTNER D WHERE A.SETID = B.SETID AND A.EOCM_DATA_SRC_ID = B.EOCM_DATA_SRC_ID AND A.SETID = C.SETID AND A.EOCM_DATA_SRC_ID = C.EOCM_DATA_SRC_ID AND B.SETID = D.SETID AND B.EOCM_ACCESS_ID = D.EOCM_ACCESS_ID AND A.EOCM_CREATED_FLAG = 'Y' UNION SELECT A.SETID ,B.EOCM_ACCESS_ID ,E.DESCR ,D.EOCM_DATA_SRC_ID ,F.SEQNUM ,D.EOCM_PSRECORD_NAME ,D.EOEW_SRCDONAME ,D.EOCM_DATA_SRC_TYPE ,D.EOCM_DELIM_TYPE ,D.FLDDELIMITER ,D. ATTACHSYSFILENAME ,D.ATTACHUSERFILE ,D.EOCM_FIRST_LINE ,D.EOCM_OTHER_LINE , F.EOCM_FIELD_NAME , F.FLDLENGTH , F.DECIMALPOS , F.EOCM_FIELD_TYPE , F.EOCM_PS_FLD_NAME , F.EOCM_DATA_QLFR , F.EOCM_DATA_STRIP ,D.EOCM_CREATED_FLAG ,D.CREATED_DTTM ,D.CREATEOPRID ,D.LASTUPDDTTM ,D.LASTUPDOPRID ,D.EOCM_SRC_OPTION ,D.EOCM_PSERRREC_NAME FROM PS_EOCM_CATALOG A , PS_EOCM_CATALOG_TP B , PS_EOEW_MAP_DFN C , PS_EOCM_DATA_PSMST D , PS_EOCM_DSPSMT_FLD F , PS_EOCM_TRDPARTNER E WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND A.EOCM_MAP_OBJ = 'CMSTDMSTMAP' AND C.EOEW_MAP_OBJ = 'CCM_STD999999' AND C.EOEW_SRC_OBJ = D.EOCM_DATA_SRC_ID AND D.EOCM_DATA_SRC_ID = F.EOCM_DATA_SRC_ID AND B.EOCM_ACCESS_ID = E.EOCM_ACCESS_ID

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

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

6 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.

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

8 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

9 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

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

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

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

13 EOCM_FIRST_LINE Character(1) VARCHAR2(1) NOT NULL First Line Contents 1 = Data 2 = Column Headings
1=Column Headings
2=Data
Default Value: 1

14 EOCM_OTHER_LINE Character(1) VARCHAR2(1) NOT NULL Subsequent Line Contents 1 = Data 2 = None
1=Data
2=None
Default Value: 1

15 EOCM_FIELD_NAME Character(32) VARCHAR2(32) NOT NULL store the last field for new prods

16 FLDLENGTH Number(5,0) INTEGER NOT NULL Field Length

17 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions

18 EOCM_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Field Type 0 = Character 2 = Number 3 = Signed Number 4 = Date 5 = Time 6 = DateTime
0=Character
2=Number
3=Signed Number
4=Date
5=Time
6=DateTime

19 EOCM_PS_FLD_NAME Character(18) VARCHAR2(18) NOT NULL Corresponding Peoplesoft Field Name

20 EOCM_DATA_QLFR Character(1) VARCHAR2(1) NOT NULL field to specify qualifiers

21 EOCM_DATA_STRIP Character(20) VARCHAR2(20) NOT NULL Field for stripping characters from the incoming data

22 EOCM_CREATED_FLAG Character(1) VARCHAR2(1) NOT NULL Record Created Flag
Y/N Table Edit
Default Value: Y

23 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time

24 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

25 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

26 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

27 EOCM_SRC_OPTION Character(1) VARCHAR2(1) NOT NULL Indicator on a data source object to determine if it is a Master object or a Partner object.
M=Master Source
P=Partner Source
Default Value: M

28 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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	EOCM_DATA_SRC_ID	Character(10)	VARCHAR2(10) NOT NULL	Catalog Source ID
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	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.
7	EOEW_SRCDONAME	Character(30)	VARCHAR2(30) NOT NULL	Source Data Object
8	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
9	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
10	FLDDELIMITER	Character(1)	VARCHAR2(1) NOT NULL	Field Delimiter
11	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
12	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
13	EOCM_FIRST_LINE	Character(1)	VARCHAR2(1) NOT NULL	First Line Contents 1 = Data 2 = Column Headings 1=Column Headings 2=Data Default Value: 1
14	EOCM_OTHER_LINE	Character(1)	VARCHAR2(1) NOT NULL	Subsequent Line Contents 1 = Data 2 = None 1=Data 2=None Default Value: 1
15	EOCM_FIELD_NAME	Character(32)	VARCHAR2(32) NOT NULL	store the last field for new prods
16	FLDLENGTH	Number(5,0)	INTEGER NOT NULL	Field Length
17	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
18	EOCM_FIELD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Field Type 0 = Character 2 = Number 3 = Signed Number 4 = Date 5 = Time 6 = DateTime 0=Character 2=Number 3=Signed Number 4=Date 5=Time 6=DateTime
19	EOCM_PS_FLD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Corresponding Peoplesoft Field Name
20	EOCM_DATA_QLFR	Character(1)	VARCHAR2(1) NOT NULL	field to specify qualifiers
21	EOCM_DATA_STRIP	Character(20)	VARCHAR2(20) NOT NULL	Field for stripping characters from the incoming data
22	EOCM_CREATED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Record Created Flag Y/N Table Edit Default Value: Y
23	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Date and time
24	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
25	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
26	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
27	EOCM_SRC_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Indicator on a data source object to determine if it is a Master object or a Partner object. M=Master Source P=Partner Source Default Value: M
28	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.