UPG_PM_OPTIONS(SQL Table) |
Index Back |
|---|---|
JPM Upgrade OptionsStores JPM-specific installation data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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
Default Value: 100000 |
| 2 | JPM_PROFILE_ID_LEN | Number(2,0) | SMALLINT NOT NULL |
Stores the allowable Profile ID length for Job Profile Management Profile IDs
Default Value: 6 |
| 3 | JPM_ITEM_KEY_LAST | Number(12,0) | DECIMAL(12) NOT NULL |
Last Item Key ID Used
Default Value: 0 |
| 4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |