SFA_EA_MAP_SRCH (SQL View)	Index Back
EA File Defn Prompt View View of File Parse map definitions that belong to the EA File Parser context.

SFA_EA_MAP_SRCH

(SQL View)

EA File Defn Prompt View

View of File Parse map definitions that belong to the EA File Parser context.

SELECT SCCFP_MAP_ID , SCCFP_MAP_NAME FROM PS_SCCFP_MAP_DFN WHERE SCCFP_CNTXT_ID BETWEEN 100 AND 199

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCCFP_MAP_ID Number(15,0) DECIMAL(15) NOT NULL Mapping ID - the unique key that identifies the file mapping

2 SCCFP_MAP_NAME Character(30) VARCHAR2(30) NOT NULL File Mapping name - the user key to a File Mapping

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCCFP_MAP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Mapping ID - the unique key that identifies the file mapping
2	SCCFP_MAP_NAME	Character(30)	VARCHAR2(30) NOT NULL	File Mapping name - the user key to a File Mapping