| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 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).
|