DP_CONFIGVIEWS

(SQL Table)
 Index Back

Forecast View - parent table

  • Related Language Record: DP_CONFIGVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
    2 DP_VIEWTYPE Character(1) VARCHAR2(1) NOT NULL DP_VIEWTYPE
    0=Working View
    1=Dynamic View
    2=Disbursement View
    3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    4 DP_DESCRIPTION Character(120) VARCHAR2(120) NOT NULL Description
    5 DP_MAPEPERIODS Number(2,0) SMALLINT NOT NULL DP_MAPEPERIODS

    Default Value: 6

    6 DP_LASTCONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_LASTCONFIGLEVEL
    7 DP_FCSTARTYEAR Number(4,0) SMALLINT NOT NULL DP_FCSTARTYEAR
    8 DP_FCSTARTPERIOD Number(3,0) SMALLINT NOT NULL DP_FCSTARTPERIOD
    9 DP_CONFIGHISTPDS Number(3,0) SMALLINT NOT NULL DP_CONFIGHISTPDS

    Default Value: 36

    10 DP_CONFIGFUTUREPDS Number(3,0) SMALLINT NOT NULL DP_CONFIGFUTUREPDS

    Default Value: 24

    11 DP_CONFIGEVALPDS Number(3,0) SMALLINT NOT NULL DP_CONFIGEVALPDS

    Default Value: 2

    12 DP_USERDATACODE Character(20) VARCHAR2(20) NOT NULL DP_USERDATACODE

    Prompt Table: DP_DPUDCODE_VW

    13 DP_PARENTVIEW Character(20) VARCHAR2(20) NOT NULL DP_PARENTVIEW
    14 DP_PARENTLEVEL Number(1,0) SMALLINT NOT NULL DP_PARENTLEVEL
    15 DP_PARENTUOMGROUP Character(10) VARCHAR2(10) NOT NULL DP_PARENTUOMGROUP

    Prompt Table: UNITS_TBL

    16 DP_FISCALBEGINPD Number(3,0) SMALLINT NOT NULL DP_FISCALBEGINPD

    Default Value: 1

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

    Prompt Table: DP_CAL2_VW

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

    Prompt Table: DP_CALTIME_VW

    19 DP_PDSPERYEAR Number(2,0) SMALLINT NOT NULL DP_PDSPERYEAR

    Default Value: 0

    20 DP_WEIGHTPROFILE Character(20) VARCHAR2(20) NOT NULL DP_WEIGHTPROFILE

    Prompt Table: DP_WTPROFILES

    21 DP_SUPPRESSFCCALCS Character(1) VARCHAR2(1) NOT NULL DP_SUPPRESSFCCALCS

    Y/N Table Edit

    Default Value: N

    22 DP_SECURITYACTIVE Character(1) VARCHAR2(1) NOT NULL Security Active

    Y/N Table Edit

    23 DP_DEFAULTSECURITY Character(1) VARCHAR2(1) NOT NULL Default Security

    Y/N Table Edit

    24 DP_ROLLUPADJ Character(1) VARCHAR2(1) NOT NULL DP_ROLLUPADJ

    Y/N Table Edit

    Default Value: N

    25 DP_ROLLUPDMDADJ Character(1) VARCHAR2(1) NOT NULL DP_ROLLUPDMDADJ

    Y/N Table Edit

    Default Value: N

    26 DP_VARIANCELAWPDS Number(3,0) SMALLINT NOT NULL DP_VARIANCELAWPDS

    Default Value: 2

    27 DP_PRORATIOUPBND Number(13,2) DECIMAL(12,2) NOT NULL DP_PRORATIOUPBND

    Default Value: 2

    28 DP_PRORATIOLWRBND Number(13,2) DECIMAL(12,2) NOT NULL DP_PRORATIOLWRBND
    29 DP_PRICEPERIODS Number(2,0) SMALLINT NOT NULL DP_PRICEPERIODS

    Default Value: 3

    30 DP_UPDATEPCSTATIC Character(1) VARCHAR2(1) NOT NULL DP_UPDATEPCSTATIC

    Y/N Table Edit

    Default Value: N

    31 DP_TRANSFERRED Character(1) VARCHAR2(1) NOT NULL DP_TRANSFERRED

    Y/N Table Edit

    32 DP_CALCCODE Character(20) VARCHAR2(20) NOT NULL DP_CALCCODE

    Prompt Table: DP_CALCCODES_VW

    33 DP_PECALCULATIONCD Character(20) VARCHAR2(20) NOT NULL DP_PECALCULATIONCD

    Prompt Table: DP_CALCCODES_VW

    34 DP_MOD_DATE DateTime(26) TIMESTAMP date modified - used to track record changes

    Default Value: %DateTime

    35 DP_ROUNDDECIMALS Signed Number(3,0) DECIMAL(2) NOT NULL DP_ROUNDDECIMALS
    36 DP_FCVIEWLOCK Character(4) VARCHAR2(4) NOT NULL DP_FCVIEWLOCK
    0=Not Locked
    1=Update Lock
    2=View Locked

    Default Value: 0

    37 DP_FUNCTIONCODE Character(4) VARCHAR2(4) NOT NULL Function Code
    38 DP_UDATA01_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA01_CAPTION
    39 DP_UDATA01_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA01_INUSE

    Y/N Table Edit

    Default Value: N

    40 DP_UDATA02_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA02_CAPTION
    41 DP_UDATA02_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA02_INUSE

    Y/N Table Edit

    Default Value: N

    42 DP_UDATA03_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA03_CAPTION
    43 DP_UDATA03_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA03_INUSE

    Y/N Table Edit

    Default Value: N

    44 DP_UDATA04_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA04_CAPTION
    45 DP_UDATA04_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA04_INUSE

    Y/N Table Edit

    Default Value: N

    46 DP_UDATA05_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA05_CAPTION
    47 DP_UDATA05_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA05_INUSE

    Y/N Table Edit

    Default Value: N

    48 DP_UDATA06_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA06_CAPTION
    49 DP_UDATA06_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA06_INUSE

    Y/N Table Edit

    Default Value: N

    50 DP_UDATA07_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA07_CAPTION
    51 DP_UDATA07_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA07_INUSE

    Y/N Table Edit

    Default Value: N

    52 DP_UDATA08_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA08_CAPTION
    53 DP_UDATA08_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA08_INUSE

    Y/N Table Edit

    Default Value: N

    54 DP_UDATA09_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA09_CAPTION
    55 DP_UDATA09_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA09_INUSE

    Y/N Table Edit

    Default Value: N

    56 DP_UDATA10_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA10_CAPTION
    57 DP_UDATA10_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA10_INUSE

    Y/N Table Edit

    Default Value: N

    58 DP_FCAST01_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST01_CAPTION
    59 DP_FCAST01_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST01_INUSE

    Y/N Table Edit

    Default Value: N

    60 DP_FCAST02_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST02_CAPTION
    61 DP_FCAST02_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST02_INUSE

    Y/N Table Edit

    Default Value: N

    62 DP_FCAST03_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST03_CAPTION
    63 DP_FCAST03_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST03_INUSE

    Y/N Table Edit

    Default Value: N

    64 DP_FCAST04_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST04_CAPTION
    65 DP_FCAST04_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST04_INUSE

    Y/N Table Edit

    Default Value: N

    66 DP_FCAST05_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST05_CAPTION
    67 DP_FCAST05_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST05_INUSE

    Y/N Table Edit

    Default Value: N

    68 DP_FCAST06_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST06_CAPTION
    69 DP_FCAST06_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST06_INUSE

    Y/N Table Edit

    Default Value: N

    70 DP_FCAST07_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST07_CAPTION
    71 DP_FCAST07_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST07_INUSE

    Y/N Table Edit

    Default Value: N

    72 DP_FCAST08_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST08_CAPTION
    73 DP_FCAST08_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST08_INUSE

    Y/N Table Edit

    Default Value: N

    74 DP_FCAST09_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST09_CAPTION
    75 DP_FCAST09_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST09_INUSE

    Y/N Table Edit

    Default Value: N

    76 DP_FCAST10_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST10_CAPTION
    77 DP_FCAST10_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST10_INUSE

    Y/N Table Edit

    Default Value: N

    78 DP_MAPEADJUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPEADJUPDREQ

    Y/N Table Edit

    Default Value: N

    79 DP_MAPEEVADJUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPEEVADJUPDREQ

    Y/N Table Edit

    Default Value: N

    80 DP_MAPEEVPROUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPEEVPROUPDREQ

    Y/N Table Edit

    Default Value: N

    81 DP_MAPEEVSTAUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPEEVSTAUPDREQ

    Y/N Table Edit

    Default Value: N

    82 DP_MAPEPROUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPEPROUPDREQ

    Y/N Table Edit

    Default Value: N

    83 DP_MAPESTATUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPESTATUPDREQ

    Y/N Table Edit

    Default Value: N

    84 DP_ADJHIST_SEQ Number(10,0) DECIMAL(10) NOT NULL DP_ADJHIST_SEQ

    Default Value: 1

    85 DP_FUNCAUDIT_SEQ Number(10,0) DECIMAL(10) NOT NULL DP_FUNCAUDIT_SEQ

    Default Value: 1

    86 DP_WRKQUE_SEQ Number(10,0) DECIMAL(10) NOT NULL DP_WRKQUE_SEQ

    Default Value: 1