OMEC_CHNKSRC_VW (SQL View)	Index Back
Business Unit Chunking Rules View of all the Chunking Rules that use the Enterprise Component supplied Business Unit / Msgnode table Date Initials Issue Description 031801 dms SP2 (DI-EDWONG-14) CRM Integration

OMEC_CHNKSRC_VW

(SQL View)

Business Unit Chunking Rules

View of all the Chunking Rules that use the Enterprise Component supplied Business Unit / Msgnode table Date Initials Issue Description 031801 dms SP2 (DI-EDWONG-14) CRM Integration

SELECT CHUNK_RULE_ID ,DESCR ,RECNAME_CHUNK FROM PS_EO_CHUNKRULE WHERE RECNAME_CHUNK = 'OMEC_SRC_CD_EOC'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CHUNK_RULE_ID Character(30) VARCHAR2(30) NOT NULL Chunking Rule ID

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

3 RECNAME_CHUNK Character(15) VARCHAR2(15) NOT NULL Chunk Table

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CHUNK_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Chunking Rule ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	RECNAME_CHUNK	Character(15)	VARCHAR2(15) NOT NULL	Chunk Table