POSITION_NBRJOB_FAMILYSETIDJOBCODEJOB_TASKEFFDTDefault Value: %date
UPG_ROLE(SQL Table) |
Index Back |
|---|---|
Upgrade Only - Legacy BackupUpgrade Only - Legacy Backup This table holds a backup of Legacy Data created during the upgrade to Profile Management 9.0. When the customer is satisfied with the upgrade or no longer needs a copy of the prior data, this table should be dropped from the Database. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 2 | JOB_FAMILY |
Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 5 | JOB_TASK |
Character(6) | VARCHAR2(6) NOT NULL | Job Task |
| 6 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | EVAL_METHOD | Character(1) | VARCHAR2(1) NOT NULL | Method of Evaluation |
| 8 | 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. |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |