| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 4 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 5 |
CONVENTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Book Depreciation Convention
or Cost Convention
|
| 6 |
CONV_UPGRADE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in Depreciation Convention Upgrade Process. This field is used to indicate whether to upgrade the convention or not.
|
| 7 |
CONV_CALENDAR_ID_3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Used in Depreciation Convention Upgrade Process. This field is used to indicate how to populate the new Calendar ID field in the CONV_TBL. While the regular Calendar ID was defined as Char 2, this field was defined as Char 3 because we could use 'ALL' to denote copy to ALL calendar.
|
| 8 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 9 |
CALENDAR_ID_TO |
Character(2) |
VARCHAR2(2) NOT NULL |
During Copy Depreciation Convention, this field is used to indicate the copy to Calendar ID.
|