| # |
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 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
JPM_PROFILE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
|
| 5 |
JPM_PROFILE_LAST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores the Last Job Profile Management Profile ID value that allocated during auto-numbering of the Profile ID
|
| 6 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 7 |
JPM_ITEM_KEY_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.
|
| 8 |
JPM_PROP_CLAUSE |
Character(12) |
VARCHAR2(12) NOT NULL |
JPM upgrade field
|
| 9 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 10 |
SQL_ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.
|
| 11 |
CHECK_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Check first byte &&return type
|
| 12 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 13 |
JPM_CAT_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
|
| 14 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 15 |
AE_TEST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Flag
|