DP_FILEDEFNF_VW (SQL View)	Index Back
File Layout Import FCItems File Layout Import FCItems

DP_FILEDEFNF_VW

(SQL View)

File Layout Import FCItems

SELECT FLDDEFNNAME , DESCR FROM PSFLDDEFN WHERE FLDDEFNNAME LIKE 'DP_IMP_FCI%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DP_FILELAYOUT_NM Character(30) VARCHAR2(30) NOT NULL DP_FILELAYOUT_NM

2 DP_DESCR Character(30) VARCHAR2(30) NOT NULL DP_DESCR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DP_FILELAYOUT_NM	Character(30)	VARCHAR2(30) NOT NULL	DP_FILELAYOUT_NM
2	DP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	DP_DESCR