PROCESS_INSTANCEA=Advanced
B=Basic
I=Intermediate
UPG_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
A=Advanced B=Basic I=Intermediate |
| 6 | EP_DESCR254 | Long Character(1325) | VARCHAR2(1325) | 1325 character description field used in ePerformance |