DP_PUB_FCAST

(SQL Table)
 Index Back

Published Forecast Header

Published Forecast Header

  • Parent Record Of DP_PUBFCBTCIVW DP_PUBFCBUBIVW DP_PUBFCBUINVW DP_PUBFCBUOMVW DP_PUBFCC6VW DP_PUBFCC8VW DP_PUBFCCATIDVW DP_PUBFCCC10AVW DP_PUBFCCC10BVW DP_PUBFCCC10CVW DP_PUBFCCC10DVW DP_PUBFCCC1AVW DP_PUBFCCC1BVW DP_PUBFCCC1CVW DP_PUBFCCC1DVW DP_PUBFCCC2VW DP_PUBFCCC30AVW DP_PUBFCCC30BVW DP_PUBFCCC30CVW DP_PUBFCCC30DVW DP_PUBFCCC4VW DP_PUBFCCCHANVW DP_PUBFCCCIDVW DP_PUBFCCGRPVW DP_PUBFCCLASSVW DP_PUBFCCURCDVW DP_PUBFCFCANAVW DP_PUBFCIC10AVW DP_PUBFCIC10BVW DP_PUBFCIC10CVW DP_PUBFCIC10DVW DP_PUBFCIC1AVW DP_PUBFCIC1BVW DP_PUBFCIC1CVW DP_PUBFCIC1DVW DP_PUBFCIC2VW DP_PUBFCIC30AVW DP_PUBFCIC30BVW DP_PUBFCIC30CVW DP_PUBFCIC30DVW DP_PUBFCIC4VW DP_PUBFCIC6VW DP_PUBFCIC8VW DP_PUBFCIICOVW DP_PUBFCIIGRVW DP_PUBFCIIIDVW DP_PUBFCIITYVW DP_PUBFCINVVW DP_PUBFCIPFCVW DP_PUBFCMDESCVW DP_PUBFCPBRNDVW DP_PUBFCPC10AVW DP_PUBFCPC10BVW DP_PUBFCPC10CVW DP_PUBFCPC10DVW DP_PUBFCPC1AVW DP_PUBFCPC1BVW DP_PUBFCPC1CVW DP_PUBFCPC1DVW DP_PUBFCPC2VW DP_PUBFCPC30AVW DP_PUBFCPC30BVW DP_PUBFCPC30CVW DP_PUBFCPC30DVW DP_PUBFCPC4VW DP_PUBFCPC6VW DP_PUBFCPC8VW DP_PUBFCPCATVW DP_PUBFCPMDIVVW DP_PUBFCPMREGVW DP_PUBFCPMTERVW DP_PUBFCPPROGVW DP_PUBFCPRDDVW DP_PUBFCPRIDVW DP_PUBFCREGCDVW DP_PUBFCSHTCIVW DP_PUBFCSOTCIVW DP_PUBFCSQUA1VW DP_PUBFCSQUA2VW DP_PUBFCSRCCDVW DP_PUBFCUD01VW DP_PUBFCUD02VW DP_PUBFCUD03VW DP_PUBFCUD04VW DP_PUBFCUD05VW DP_PUBFCUD06VW DP_PUBFCUD07VW DP_PUBFCUD08VW DP_PUBFCUD09VW DP_PUBFCUD10VW DP_PUBFCUD11VW DP_PUBFCUD12VW DP_PUBFCUD13VW DP_PUBFCUD14VW DP_PUBFCUD15VW DP_PUBFCUD16VW DP_PUBFCUD17VW DP_PUBFCUD18VW DP_PUBFCUD19VW DP_PUBFCUD20VW DP_PUBFCUD21VW DP_PUBFCUD22VW DP_PUBFCUD23VW DP_PUBFCUD24VW DP_PUBFCUD25VW DP_PUBFCUD26VW DP_PUBFCUD27VW DP_PUBFCUD28VW DP_PUBFCUD29VW DP_PUBFCUD30VW DP_PUBFCUD31VW DP_PUBFCUD32VW DP_PUBFCUD33VW DP_PUBFCUD34VW DP_PUBFCUD35VW DP_PUBFCUD36VW DP_PUBFCUD37VW DP_PUBFCUD38VW DP_PUBFCUD39VW DP_PUBFCUD40VW DP_PUBFCUD41VW DP_PUBFCUD42VW DP_PUBFCUD43VW DP_PUBFCUD44VW DP_PUBFCUD45VW DP_PUBFCUD46VW DP_PUBFCUD47VW DP_PUBFCUD48VW DP_PUBFCUD49VW DP_PUBFCUD50VW DP_PUBRLFCITMVW DP_PUBRLFCITVW2 DP_PUBRLFCITVW3 DP_PUB_FCASTKEY DP_PUB_FCITEMS DP_PUB_FCITEMS2 DP_PUB_FCITS_VW DP_PUB_FCIT_EXT DP_PUB_FCIT_WGT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name
    2 DP_PUBLISH_DATE Date(10) DATE NOT NULL DP_PUBLISH_DATE
    3 DP_DESCRIPTION Character(120) VARCHAR2(120) NOT NULL Description
    4 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
    5 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL
    6 DP_STATISTICALATTR Character(1) VARCHAR2(1) NOT NULL DP_STATISTICALATTR

    Y/N Table Edit

    7 DP_DAILYWEIGHTS Character(1) VARCHAR2(1) NOT NULL DP_DAILYWEIGHTS

    Y/N Table Edit

    8 DP_DAILYFORECAST Character(1) VARCHAR2(1) NOT NULL DP_DAILYFORECAST

    Y/N Table Edit

    9 DP_USERFIELD Character(1) VARCHAR2(1) NOT NULL DP_USERFIELD

    Y/N Table Edit

    10 DP_CALENDARID Character(20) VARCHAR2(20) NOT NULL DP_CALENDARID

    Prompt Table: DP_CAL2_VW

    11 DP_TIMEPERIODCODE Character(10) VARCHAR2(10) NOT NULL DP_TIMEPERIODCODE

    Prompt Table: DP_CALTIME_VW

    12 DP_PUBTIMEPERIODCD Character(10) VARCHAR2(10) NOT NULL DP_PUBTIMEPERIODCD

    Prompt Table: DP_CALTIME5_VW

    13 DP_CONVUNITDESC Character(30) VARCHAR2(30) NOT NULL Conversion Unit Description
    14 DP_CONVTOINVUOM Character(1) VARCHAR2(1) NOT NULL DP_CONVTOINVUOM

    Y/N Table Edit

    15 DP_LASTUPDATED Date(10) DATE DP_LASTUPDATED
    16 DP_FCPERIODS Number(4,0) SMALLINT NOT NULL DP_FCPERIODS
    17 MAPID Character(3) VARCHAR2(3) NOT NULL Map ID