DP_CFGVIEW_AET(SQL Table) |
Index Back |
|---|---|
External Import View State recExternal Import View State rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 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 |
| 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 |
| 11 | DP_CONFIGFUTUREPDS | Number(3,0) | SMALLINT NOT NULL | DP_CONFIGFUTUREPDS |
| 12 | DP_CONFIGEVALPDS | Number(3,0) | SMALLINT NOT NULL | DP_CONFIGEVALPDS |
| 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 |
| 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 |
| 21 | DP_WEIGHTPROFILE | Character(20) | VARCHAR2(20) NOT NULL | DP_WEIGHTPROFILE |
| 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 |
| 28 | DP_PRORATIOUPBND | Number(13,2) | DECIMAL(12,2) NOT NULL | DP_PRORATIOUPBND |
| 29 | DP_PRORATIOLWRBND | Number(13,2) | DECIMAL(12,2) NOT NULL | DP_PRORATIOLWRBND |
| 30 | DP_PRICEPERIODS | Number(2,0) | SMALLINT NOT NULL | DP_PRICEPERIODS |
| 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 |
| 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 |
| 38 | DP_FUNCTIONCODE | Character(4) | VARCHAR2(4) NOT NULL | Function Code |
| 39 | DP_ADJUSTMENTBASIS | Character(1) | VARCHAR2(1) NOT NULL |
DP_ADJUSTMENTBASIS
0=Statistical 1=Prorated 2=Adjusted |
| 40 | DP_COMMENTHANDLING | Character(2) | VARCHAR2(2) NOT NULL |
DP_COMMENTHANDLING
0=Replace 1=Concatenate Left 2=Concatenate Right |
| 41 | DP_HORIZON_BEGIN | Number(10,5) | DECIMAL(9,5) NOT NULL | DP_HORIZON_BEGIN |
| 42 | DP_HORIZON_END | Number(10,5) | DECIMAL(9,5) NOT NULL | DP_HORIZON_END |
| 43 | DP_DEFAULTFCITEM | Character(120) | VARCHAR2(120) NOT NULL | DP_DEFAULTFCITEM |
| 44 | DP_AUDITINUSE | Character(1) | VARCHAR2(1) NOT NULL | DP_AUDITINUSE |
| 45 | DP_KEYFLDNAMES | Character(254) | VARCHAR2(254) NOT NULL | DP_KEYFLDNAMES |
| 46 | DP_UDFLDNAMES | Character(254) | VARCHAR2(254) NOT NULL | DP_UDFLDNAMES |
| 47 | DP_CONCATFCITEM | Character(254) | VARCHAR2(254) NOT NULL | DP_CONCATFCITEM |
| 48 | DP_WHERENOBLANK | Character(254) | VARCHAR2(254) NOT NULL | DP_WHERENOBLANK |
| 49 | DP_LENGTHCHECK | Character(254) | VARCHAR2(254) NOT NULL | DP_LENGTHCHECK |