DP_FILEDEFN2_VW

(SQL View)
 Index Back

View of the PSFLDDEFN

SELECT FLDDEFNNAME , DESCR FROM PSFLDDEFN WHERE FLDDEFNNAME LIKE 'DP_IMP_IPMST%' This view only include the File Layout for IP Import

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

# 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