DP_WORKVIEWS_VW

(SQL View)
 Index Back

DP_WORKVIEWS_VW

DP_WORKVIEWS_VW

SELECT A.DP_CONFIGVIEW , C.OPRID , A.DP_CAPTION , A.DP_DESCRIPTION , A.DP_MAPEPERIODS , A.DP_LASTCONFIGLEVEL , A.DP_FCSTARTYEAR , A.DP_FCSTARTPERIOD , A.DP_CONFIGHISTPDS , A.DP_CONFIGFUTUREPDS , A.DP_CONFIGEVALPDS , A.DP_USERDATACODE , A.DP_PARENTVIEW , A.DP_PARENTLEVEL , A.DP_PARENTUOMGROUP , A.DP_FISCALBEGINPD , A.DP_CALENDARID , A.DP_TIMEPERIODCODE , A.DP_PDSPERYEAR , A.DP_SUPPRESSFCCALCS , A.DP_SECURITYACTIVE , A.DP_DEFAULTSECURITY , A.DP_ROLLUPADJ , A.DP_ROLLUPDMDADJ , A.DP_VARIANCELAWPDS , A.DP_PRORATIOUPBND , A.DP_PRORATIOLWRBND , A.DP_PRICEPERIODS , A.DP_UPDATEPCSTATIC , A.DP_TRANSFERRED , A.DP_CALCCODE , A.DP_PECALCULATIONCD , A.DP_MOD_DATE , A.DP_UDATA01_CAPTION , A.DP_UDATA01_INUSE , A.DP_UDATA02_CAPTION , A.DP_UDATA02_INUSE , A.DP_UDATA03_CAPTION , A.DP_UDATA03_INUSE , A.DP_UDATA04_CAPTION , A.DP_UDATA04_INUSE , A.DP_UDATA05_CAPTION , A.DP_UDATA05_INUSE , A.DP_UDATA06_CAPTION , A.DP_UDATA06_INUSE , A.DP_UDATA07_CAPTION , A.DP_UDATA07_INUSE , A.DP_UDATA08_CAPTION , A.DP_UDATA08_INUSE , A.DP_UDATA09_CAPTION , A.DP_UDATA09_INUSE , A.DP_UDATA10_CAPTION , A.DP_UDATA10_INUSE , A.DP_FCAST01_CAPTION , A.DP_FCAST01_INUSE , A.DP_FCAST02_CAPTION , A.DP_FCAST02_INUSE , A.DP_FCAST03_CAPTION , A.DP_FCAST03_INUSE , A.DP_FCAST04_CAPTION , A.DP_FCAST04_INUSE , A.DP_FCAST05_CAPTION , A.DP_FCAST05_INUSE , A.DP_FCAST06_CAPTION , A.DP_FCAST06_INUSE , A.DP_FCAST07_CAPTION , A.DP_FCAST07_INUSE , A.DP_FCAST08_CAPTION , A.DP_FCAST08_INUSE , A.DP_FCAST09_CAPTION , A.DP_FCAST09_INUSE , A.DP_FCAST10_CAPTION , A.DP_FCAST10_INUSE FROM PS_DP_CONFIGVIEWS A , PS_DP_USERVIEWS B , PSOPRDEFN C WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND B.DP_USERID = C.OPRID AND A.DP_VIEWTYPE = '0'

  • Related Language Record: DP_WRKVIEWS_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

    Prompt Table: DP_WORKVIEWS_VW

    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    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_USERDATACDS

    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
    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_SUPPRESSFCCALCS Character(1) VARCHAR2(1) NOT NULL DP_SUPPRESSFCCALCS

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Default Value: 2

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

    Default Value: 2

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

    Default Value: 3

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Prompt Table: DP_CALCCODES_VW

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

    Prompt Table: DP_CALCCODES_VW

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

    Default Value: %DateTime

    34 DP_UDATA01_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA01_CAPTION
    35 DP_UDATA01_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA01_INUSE

    Y/N Table Edit

    Default Value: N

    36 DP_UDATA02_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA02_CAPTION
    37 DP_UDATA02_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA02_INUSE

    Y/N Table Edit

    Default Value: N

    38 DP_UDATA03_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA03_CAPTION
    39 DP_UDATA03_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA03_INUSE

    Y/N Table Edit

    Default Value: N

    40 DP_UDATA04_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA04_CAPTION
    41 DP_UDATA04_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA04_INUSE

    Y/N Table Edit

    Default Value: N

    42 DP_UDATA05_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA05_CAPTION
    43 DP_UDATA05_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA05_INUSE

    Y/N Table Edit

    Default Value: N

    44 DP_UDATA06_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA06_CAPTION
    45 DP_UDATA06_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA06_INUSE

    Y/N Table Edit

    Default Value: N

    46 DP_UDATA07_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA07_CAPTION
    47 DP_UDATA07_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA07_INUSE

    Y/N Table Edit

    Default Value: N

    48 DP_UDATA08_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA08_CAPTION
    49 DP_UDATA08_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA08_INUSE

    Y/N Table Edit

    Default Value: N

    50 DP_UDATA09_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA09_CAPTION
    51 DP_UDATA09_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA09_INUSE

    Y/N Table Edit

    Default Value: N

    52 DP_UDATA10_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA10_CAPTION
    53 DP_UDATA10_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA10_INUSE

    Y/N Table Edit

    Default Value: N

    54 DP_FCAST01_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST01_CAPTION
    55 DP_FCAST01_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST01_INUSE

    Y/N Table Edit

    Default Value: N

    56 DP_FCAST02_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST02_CAPTION
    57 DP_FCAST02_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST02_INUSE

    Y/N Table Edit

    Default Value: N

    58 DP_FCAST03_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST03_CAPTION
    59 DP_FCAST03_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST03_INUSE

    Y/N Table Edit

    Default Value: N

    60 DP_FCAST04_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST04_CAPTION
    61 DP_FCAST04_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST04_INUSE

    Y/N Table Edit

    Default Value: N

    62 DP_FCAST05_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST05_CAPTION
    63 DP_FCAST05_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST05_INUSE

    Y/N Table Edit

    Default Value: N

    64 DP_FCAST06_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST06_CAPTION
    65 DP_FCAST06_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST06_INUSE

    Y/N Table Edit

    Default Value: N

    66 DP_FCAST07_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST07_CAPTION
    67 DP_FCAST07_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST07_INUSE

    Y/N Table Edit

    Default Value: N

    68 DP_FCAST08_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST08_CAPTION
    69 DP_FCAST08_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST08_INUSE

    Y/N Table Edit

    Default Value: N

    70 DP_FCAST09_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST09_CAPTION
    71 DP_FCAST09_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST09_INUSE

    Y/N Table Edit

    Default Value: N

    72 DP_FCAST10_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST10_CAPTION
    73 DP_FCAST10_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST10_INUSE

    Y/N Table Edit

    Default Value: N