DPA_CONFIGVIEWS

(SQL Table)
 Index Back

DP Archive Record

Online: DP_CONFIGVIEWS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
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_DPUDCODE_VW

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
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_WEIGHTPROFILE Character(20) VARCHAR2(20) NOT NULL DP_WEIGHTPROFILE

Prompt Table: DP_WTPROFILES

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Default Value: 2

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

Default Value: 2

29 DP_PRORATIOLWRBND Number(13,2) DECIMAL(12,2) NOT NULL DP_PRORATIOLWRBND
30 DP_PRICEPERIODS Number(2,0) SMALLINT NOT NULL DP_PRICEPERIODS

Default Value: 3

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

Y/N Table Edit

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

Y/N Table Edit

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

Prompt Table: DP_CALCCODES_VW

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

Prompt Table: DP_CALCCODES_VW

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

Default Value: %DateTime

36 DP_ROUNDDECIMALS Signed Number(3,0) DECIMAL(2) NOT NULL DP_ROUNDDECIMALS
37 DP_FCVIEWLOCK Character(4) VARCHAR2(4) NOT NULL DP_FCVIEWLOCK
0=Not Locked
1=Update Lock
2=View Locked

Default Value: 0

38 DP_FUNCTIONCODE Character(4) VARCHAR2(4) NOT NULL Function Code
39 DP_UDATA01_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA01_CAPTION
40 DP_UDATA01_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA01_INUSE

Y/N Table Edit

Default Value: N

41 DP_UDATA02_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA02_CAPTION
42 DP_UDATA02_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA02_INUSE

Y/N Table Edit

Default Value: N

43 DP_UDATA03_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA03_CAPTION
44 DP_UDATA03_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA03_INUSE

Y/N Table Edit

Default Value: N

45 DP_UDATA04_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA04_CAPTION
46 DP_UDATA04_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA04_INUSE

Y/N Table Edit

Default Value: N

47 DP_UDATA05_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA05_CAPTION
48 DP_UDATA05_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA05_INUSE

Y/N Table Edit

Default Value: N

49 DP_UDATA06_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA06_CAPTION
50 DP_UDATA06_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA06_INUSE

Y/N Table Edit

Default Value: N

51 DP_UDATA07_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA07_CAPTION
52 DP_UDATA07_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA07_INUSE

Y/N Table Edit

Default Value: N

53 DP_UDATA08_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA08_CAPTION
54 DP_UDATA08_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA08_INUSE

Y/N Table Edit

Default Value: N

55 DP_UDATA09_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA09_CAPTION
56 DP_UDATA09_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA09_INUSE

Y/N Table Edit

Default Value: N

57 DP_UDATA10_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_UDATA10_CAPTION
58 DP_UDATA10_INUSE Character(1) VARCHAR2(1) NOT NULL DP_UDATA10_INUSE

Y/N Table Edit

Default Value: N

59 DP_FCAST01_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST01_CAPTION
60 DP_FCAST01_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST01_INUSE

Y/N Table Edit

Default Value: N

61 DP_FCAST02_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST02_CAPTION
62 DP_FCAST02_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST02_INUSE

Y/N Table Edit

Default Value: N

63 DP_FCAST03_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST03_CAPTION
64 DP_FCAST03_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST03_INUSE

Y/N Table Edit

Default Value: N

65 DP_FCAST04_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST04_CAPTION
66 DP_FCAST04_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST04_INUSE

Y/N Table Edit

Default Value: N

67 DP_FCAST05_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST05_CAPTION
68 DP_FCAST05_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST05_INUSE

Y/N Table Edit

Default Value: N

69 DP_FCAST06_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST06_CAPTION
70 DP_FCAST06_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST06_INUSE

Y/N Table Edit

Default Value: N

71 DP_FCAST07_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST07_CAPTION
72 DP_FCAST07_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST07_INUSE

Y/N Table Edit

Default Value: N

73 DP_FCAST08_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST08_CAPTION
74 DP_FCAST08_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST08_INUSE

Y/N Table Edit

Default Value: N

75 DP_FCAST09_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST09_CAPTION
76 DP_FCAST09_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST09_INUSE

Y/N Table Edit

Default Value: N

77 DP_FCAST10_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_FCAST10_CAPTION
78 DP_FCAST10_INUSE Character(1) VARCHAR2(1) NOT NULL DP_FCAST10_INUSE

Y/N Table Edit

Default Value: N

79 DP_MAPEADJUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPEADJUPDREQ

Y/N Table Edit

Default Value: N

80 DP_MAPEEVADJUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPEEVADJUPDREQ

Y/N Table Edit

Default Value: N

81 DP_MAPEEVPROUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPEEVPROUPDREQ

Y/N Table Edit

Default Value: N

82 DP_MAPEEVSTAUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPEEVSTAUPDREQ

Y/N Table Edit

Default Value: N

83 DP_MAPEPROUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPEPROUPDREQ

Y/N Table Edit

Default Value: N

84 DP_MAPESTATUPDREQ Character(1) VARCHAR2(1) NOT NULL DP_MAPESTATUPDREQ

Y/N Table Edit

Default Value: N

85 DP_ADJHIST_SEQ Number(10,0) DECIMAL(10) NOT NULL DP_ADJHIST_SEQ

Default Value: 1

86 DP_FUNCAUDIT_SEQ Number(10,0) DECIMAL(10) NOT NULL DP_FUNCAUDIT_SEQ

Default Value: 1

87 DP_WRKQUE_SEQ Number(10,0) DECIMAL(10) NOT NULL DP_WRKQUE_SEQ

Default Value: 1