DP_USERVIEWS

(SQL Table)
 Index Back

User's Views

User's Views

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

Prompt Table: DP_CONFIGVIEWS

2 DP_USERID Character(30) VARCHAR2(30) NOT NULL DP_USERID

Prompt Table: PSOPRDEFN_SRCH

3 DP_USERNAME Character(30) VARCHAR2(30) NOT NULL DP_USERNAME
4 DP_CURRENTFCITEM Character(120) VARCHAR2(120) NOT NULL DP_CURRENTFCITEM

Prompt Table: DP_FCITEMS2_VW

5 DP_CURRENTCTLGROUP Character(20) VARCHAR2(20) NOT NULL DP_CURRENTCTLGROUP

Prompt Table: DP_CTRLGRPS1_VW

6 DP_CURRENTSEASPROF Character(20) VARCHAR2(20) NOT NULL DP_CURRENTSEASPROF

Prompt Table: DP_SEASPROF2_VW

7 DP_ADJUSTMENTBASIS Character(1) VARCHAR2(1) NOT NULL DP_ADJUSTMENTBASIS
0=Statistical
1=Prorated
2=Adjusted

Default Value: 1

8 DP_FC_PROC_ACT_SEL Character(1) VARCHAR2(1) NOT NULL DP_FC_PROC_ACT_SEL
0=Not Adjusted/Prorated
1=Not Adjusted/Not Prorated
2=Direct/Prorated
3=Direct/Not Prorated
4=Promoted/Prorated
5=Promoted/Not Prorated

Default Value: 0

9 DP_COMMENTHANDLING Character(2) VARCHAR2(2) NOT NULL DP_COMMENTHANDLING
0=Replace
1=Concatenate Left
2=Concatenate Right

Default Value: 2

10 DP_DMD_PROCESS_ACT Character(1) VARCHAR2(1) NOT NULL DP_DMD_PROCESS_ACT
0=Not Adjusted
1=Direct

Default Value: 0

11 DP_FORMATCODE Character(10) VARCHAR2(10) NOT NULL DP_FORMATCODE

Prompt Table: DP_INQFORMATS

12 DP_GRIDFORMAT Character(1) VARCHAR2(1) NOT NULL DP_GRIDFORMAT
R=Record
S=Spreadsheet

Default Value: R

13 DP_ADJFORMATCODE Character(10) VARCHAR2(10) NOT NULL DP_ADJFORMATCODE

Prompt Table: DP_ADJFORMUS_VW

14 DP_INQFIELDID1 Character(24) VARCHAR2(24) NOT NULL DP_INQFIELDID1

Prompt Table: DP_VWFLDSEL9_VW

15 DP_INQFIELDID2 Character(24) VARCHAR2(24) NOT NULL DP_INQFIELDID2

Prompt Table: DP_VWFLDSEL9_VW

16 DP_INQFIELDID3 Character(24) VARCHAR2(24) NOT NULL DP_INQFIELDID3

Prompt Table: DP_VWFLDSEL9_VW

17 DP_ADJFIELDID1 Character(24) VARCHAR2(24) NOT NULL DP_ADJFIELDID1

Prompt Table: DP_VWFLDSE16_VW

18 DP_ADJFIELDID2 Character(24) VARCHAR2(24) NOT NULL DP_ADJFIELDID2

Prompt Table: DP_VWFLDSE16_VW

19 DP_ADJFIELDID3 Character(24) VARCHAR2(24) NOT NULL DP_ADJFIELDID3

Prompt Table: DP_VWFLDSE16_VW

20 DP_ADJFIELDID4 Character(24) VARCHAR2(24) NOT NULL DP_ADJFIELDID4

Prompt Table: DP_VWFLDSE16_VW

21 DP_CONFIGFUTUREPDS Number(3,0) SMALLINT NOT NULL DP_CONFIGFUTUREPDS
22 DP_CONFIGHISTPDS Number(3,0) SMALLINT NOT NULL DP_CONFIGHISTPDS
23 DP_EFFDEMANDPDS Number(3,0) SMALLINT NOT NULL DP_EFFDEMANDPDS
24 DP_HISTDEMANDPDS Number(3,0) SMALLINT NOT NULL DP_HISTDEMANDPDS
25 DP_NUMPERIODS Number(3,0) SMALLINT NOT NULL DP_NUMPERIODS
26 DP_ALIGNPERIODS Character(1) VARCHAR2(1) NOT NULL Align Periods

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

29 DP_ROLLUPUSERFORE Character(1) VARCHAR2(1) NOT NULL DP_ROLLUPADJ

Y/N Table Edit

Default Value: N

30 DP_MODELCHGFREQ Number(2,0) SMALLINT NOT NULL DP_MODELCHGFREQ
31 DP_RECONFORMATCODE Character(10) VARCHAR2(10) NOT NULL Collabaration Display Template

Prompt Table: DP_COLADJFRM_VW

32 DP_COLHISTPERIODS Number(3,0) SMALLINT NOT NULL Collabaration Historical Periods
33 DP_COLFUTPERIODS Number(3,0) SMALLINT NOT NULL Collabaration Future Periods