FOMB_PMAPR_VW

(SQL View)
 Index Back

FOMB Program Activity Map

FOMB Program Activity Map detail

SELECT A.BUSINESS_UNIT , A.FED_PROGRAM , A.EFFDT , A.PRIORITY_ORDER , A.FIELDNAME , A.RANGE_FROM , A.RANGE_TO FROM PS_FOMB_PRGAC_MAPR A , PS_FOMB_PRGAC_MAPL L WHERE A.BUSINESS_UNIT = L.BUSINESS_UNIT AND A.FED_PROGRAM = L.FED_PROGRAM AND A.EFFDT = L.EFFDT AND A.PRIORITY_ORDER =L.PRIORITY_ORDER AND L.EFF_STATUS = 'A'

  • Parent record: FOMB_PRGAC_MAPL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 FED_PROGRAM Character(4) VARCHAR2(4) NOT NULL Fed Program Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 PRIORITY_ORDER Number(5,0) INTEGER NOT NULL Priority Order for Schedules
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: CF_ACTIVE_VW

    6 RANGE_FROM Character(30) VARCHAR2(30) NOT NULL Lower boundary for detail value that contains a range of values
    7 RANGE_TO Character(30) VARCHAR2(30) NOT NULL Upper boundary for detail value that contains a range of values