DP_VWRECON_SPEC(SQL Table) |
Index Back |
|---|---|
View Reconciliation SpecView Reconciliation Specification |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DP_RECONSPEC |
Character(20) | VARCHAR2(20) NOT NULL | View Reconciliation Specification |
| 2 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_CFGVWUSER_VW |
| 3 | DP_CONFIGLEVEL | Number(2,0) | SMALLINT NOT NULL |
DP_CONFIGLEVEL
Default Value: 1 Prompt Table: DP_CONFIGLEVELS |
| 4 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 5 | DP_RECONFORMATCODE | Character(10) | VARCHAR2(10) NOT NULL |
Collabaration Display Template
Prompt Table: DP_COLADJFRM_VW |
| 6 | DP_RECADJACTION | Character(4) | VARCHAR2(4) NOT NULL |
Reconciliation Adjustment Action
0=Replace 1=Add |
| 7 | 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 |
| 8 | DP_FC_COMMENT | Character(50) | VARCHAR2(50) NOT NULL | DP_FC_COMMENT |
| 9 | DP_ADJ_REASON | Character(8) | VARCHAR2(8) NOT NULL |
DP_ADJ_REASON
Prompt Table: DP_ADJ_REASN_VW |
| 10 | DP_ADJ_COMMENT | Character(50) | VARCHAR2(50) NOT NULL | DP_ADJ_COMMENT |
| 11 | DP_PERIOD | Number(3,0) | SMALLINT NOT NULL | DP_PERIOD |
| 12 | DP_YEAR | Number(4,0) | SMALLINT NOT NULL | DP_YEAR |
| 13 | DP_NUMPERIODS | Number(3,0) | SMALLINT NOT NULL | DP_NUMPERIODS |
| 14 | DP_THRESHOLDPCT | Number(3,0) | SMALLINT NOT NULL | DP_THRESHOLDPCT |
| 15 | DP_EXCLUDEPCT | Number(3,0) | SMALLINT NOT NULL | Exclude when Adjustment in Period changes by more than this Percentage |
| 16 | DP_REPWQ_PCT | Number(3,0) | SMALLINT NOT NULL | Report Work Queue Alert when Adjustment in Period changes by more than this Percentage |
| 17 | DP_EX_UPDATE | Character(1) | VARCHAR2(1) NOT NULL |
Load Imported External Data
Y/N Table Edit Default Value: N |