SCCFP_STG_VW

(SQL View)
 Index Back

File Parser Stage Table View

File Parser Staging Table view - used for prompting

SELECT DISTINCT A.SCCFP_MAP_ID , A.RECNAME , B.RECDESCR FROM PS_SCCFP_MAP_REC A , PSRECDEFN B WHERE A.RECNAME=B.RECNAME

  • Related Language Record: SCCFP_STG_LVW

    • # 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 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    3 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description