DP_AUTO_NUMBERPSARCH_IDDP_CONFIGVIEWDPA_ADJ_HISTORY(SQL Table) |
Index Back |
|---|---|
Adjustment HistoryAdjustment History |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_AUTO_NUMBER |
Number(10,0) | DECIMAL(10) NOT NULL | DP_AUTO_NUMBER |
| 2 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 3 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL | DP_CONFIGVIEW |
| 4 | DP_CONFIGLEVEL | Number(2,0) | SMALLINT NOT NULL | DP_CONFIGLEVEL |
| 5 | DP_FORECASTITEM | Character(120) | VARCHAR2(120) NOT NULL | DP_FORECASTITEM |
| 6 | DP_FCST_PERIOD | Number(3,0) | SMALLINT NOT NULL | DP_FCST_PERIOD |
| 7 | DP_FCST_YEAR | Number(4,0) | SMALLINT NOT NULL | Forecast Year |
| 8 | DP_FIELDID | Character(24) | VARCHAR2(24) NOT NULL | DP_FIELDID |
| 9 | DP_ADJ_REASON | Character(8) | VARCHAR2(8) NOT NULL | DP_ADJ_REASON |
| 10 | DP_PROCESS_ACT | Character(1) | VARCHAR2(1) NOT NULL | DP_PROCESS_ACT |
| 11 | DP_ADJ_VALUE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | DP_ADJ_VALUE |
| 12 | DP_ADJ_COMMENT | Character(50) | VARCHAR2(50) NOT NULL | DP_ADJ_COMMENT |
| 13 | DP_FUNCTIONCODE | Character(4) | VARCHAR2(4) NOT NULL | Function Code |
| 14 | DP_DATESTAMP | DateTime(26) | TIMESTAMP | DP_DATESTAMP |
| 15 | DP_USERID | Character(30) | VARCHAR2(30) NOT NULL | DP_USERID |