DP_DISBVIEWS_VW

(SQL View)
 Index Back

DP_DYNVIEWS_VW

DP_DYNVIEWS_VW

SELECT A.DP_CONFIGVIEW , C.OPRID , A.DP_VIEWTYPE , 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 A.DP_VIEWTYPE = '2' 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_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
10 DP_CONFIGFUTUREPDS Number(3,0) SMALLINT NOT NULL DP_CONFIGFUTUREPDS
11 DP_CONFIGEVALPDS Number(3,0) SMALLINT NOT NULL DP_CONFIGEVALPDS
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
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
26 DP_PRORATIOUPBND Number(13,2) DECIMAL(12,2) NOT NULL DP_PRORATIOUPBND
27 DP_PRORATIOLWRBND Number(13,2) DECIMAL(12,2) NOT NULL DP_PRORATIOLWRBND
28 DP_PRICEPERIODS Number(2,0) SMALLINT NOT NULL DP_PRICEPERIODS
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
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