PROCESS_INSTANCEUPG_PM_ST1_AET(SQL Table) |
Index Back |
|---|---|
Used in upgrading Legacy dataUpgrade Legacy data into JPM. State 1 is compared to state 2 for id assignments. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COMPETENCY | Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 3 | EP_SUB_ID | Character(12) | VARCHAR2(12) NOT NULL | Sub-Item unique identifier |
| 4 | EP_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Title of an item |
| 5 | EP_SUB_LEVEL | Character(1) | VARCHAR2(1) NOT NULL | Sub-Competency level |
| 6 | EP_DESCR254 | Long Character | CLOB | 1325 character description field used in ePerformance |