| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
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.
|
| 2 |
JPM_RLAT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of the relationship being established between JPM Data and External Data. Example - JOB CODE might be used to indicate that the relationship is between a JPM Profile of Job and External Data such as the Job Code on the Job Code table.
|
| 3 |
JPM_CAT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Optional property of an item in Profiles to provide a setid value, often used in conjunction with another property that is setid based.
|
| 4 |
JPM_RLAT_KEY1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data).
|
| 5 |
JPM_RLAT_KEY2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data).
|
| 6 |
JPM_RLAT_KEY3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data).
|
| 7 |
JPM_RLAT_KEY4 |
Character(30) |
VARCHAR2(30) NOT NULL |
Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data).
|
| 8 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|