DP_CFGVWUSER_VW

(SQL View)
 Index Back

DP_CFGVWUSER_VW

DP_CFGVWUSER_VW

SELECT A.DP_CONFIGVIEW , C.OPRID , A.DP_VIEWTYPE , 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_ROUNDDECIMALS FROM PS_DP_CONFIGVIEWS A , PS_DP_USERVIEWS B , PSOPRDEFN C WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND B.DP_USERID = C.OPRID

  • Related Language Record: DP_CFGVWUSR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 DP_VIEWTYPE Character(1) VARCHAR2(1) NOT NULL DP_VIEWTYPE
    0=Working View
    1=Dynamic View
    2=Disbursement View
    4 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    5 DP_DESCRIPTION Character(120) VARCHAR2(120) NOT NULL Description
    6 DP_MAPEPERIODS Number(2,0) SMALLINT NOT NULL DP_MAPEPERIODS

    Default Value: 6

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

    Default Value: 36

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

    Default Value: 24

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

    Default Value: 2

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

    Prompt Table: DP_USERDATACDS

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

    Prompt Table: UNITS_TBL

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

    Default Value: 1

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

    Prompt Table: DP_CAL2_VW

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

    Prompt Table: DP_CALTIME_VW

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

    Default Value: 0

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

    Y/N Table Edit

    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

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

    Y/N Table Edit

    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

    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