CA_FS_MAPHDR_VW

(SQL View)
 Index Back

Map Header CA view

This is a new view created ONLY for listing Mapping IDs with Owner ID = FCA

SELECT FS_MAP_ID ,DESCR ,VERSION FROM %Table(FS_MAP_HDR_TBL) WHERE FS_MAP_ACT_FLG = 'Y' AND FS_MAP_STATUS = 'R' AND OBJECTOWNERID='FCA'

  • Related Language Record: CA_FS_MAPHD_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FS_MAP_ID Character(30) VARCHAR2(30) NOT NULL Map ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference