DP_CFGVWUSR1_VW

(SQL View)
Index Back

DP_CFGVWUSER_VW

DP_CFGVWUSER_VW

SELECT A.DP_CONFIGVIEW , C.OPRID , A.DP_VIEWTYPE , 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

# 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_MAPEPERIODS Number(2,0) SMALLINT NOT NULL DP_MAPEPERIODS

Default Value: 6

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

Default Value: 36

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

Default Value: 24

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

Default Value: 2

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

Prompt Table: DP_USERDATACDS

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

Default Value: 1

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

Prompt Table: DP_CAL2_VW

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

Prompt Table: DP_CALTIME_VW

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

Default Value: 0

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Default Value: 2

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

Default Value: 2

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

Default Value: 3

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

Y/N Table Edit

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

Y/N Table Edit

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

Prompt Table: DP_CALCCODES_VW

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

Prompt Table: DP_CALCCODES_VW

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

Default Value: %DateTime

33 DP_ROUNDDECIMALS Signed Number(3,0) DECIMAL(2) NOT NULL DP_ROUNDDECIMALS