DP_CFGVWUSR1_VW(SQL View) |
Index Back |
---|---|
DP_CFGVWUSER_VWDP_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 |