SCCFP_MPDFN_LVW

(SQL View)
 Index Back

FileParser Map Definition View

File Parser Map Definition View

SELECT A.SCCFP_MAP_ID , B.LANGUAGE_CD , B.SCCFP_MAP_NAME FROM PS_SCCFP_MAP_DFN A , PS_SCCFP_MPDFN_LNG B WHERE SCCFP_MAP_STATUS='A' AND A.SCCFP_MAP_ID = B.SCCFP_MAP_ID

  • Related Language Record for SCCFP_MAPDFN_VW SFA_FPMAPDFN_VW SFA_PGMAPDFN_VW SFA_PG_LEU_MPVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 SCCFP_MAP_NAME Character(30) VARCHAR2(30) NOT NULL File Mapping name - the user key to a File Mapping