JPM_RLAT_EFDT_I(SQL View) |
Index Back |
|---|---|
Profile Relationships - InterfInterface view for the Profile External Relationships record (JPM_JP_X_RLAT) for the most current Effective Date. This interface also includes the Profile Type field from the JPM_PROFILE record. |
| SELECT B.JPM_PROFILE_ID , B.EFFDT , B.JPM_RLAT_NAME , B.JPM_CAT_SETID , B.JPM_RLAT_KEY1 , B.JPM_RLAT_KEY2 , B.JPM_RLAT_KEY3 , B.JPM_RLAT_KEY4 , B.JPM_JP_XRLAT_TYPE , A.DESCR , A.JPM_JP_TYPE , A.JPM_JP_PRFL_STATUS , A.JPM_PROFILE_USAGE , A.EMPLID , A.JPM_LGCY_PRFL_ID FROM PS_JPM_PROFILE A , PS_JPM_JP_X_RLAT_I B WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND B.EFFDT= ( SELECT MAX(C.EFFDT) FROM PS_JPM_JP_X_RLAT_I C WHERE C.JPM_RLAT_NAME=B.JPM_RLAT_NAME AND C.JPM_JP_TYPE=B.JPM_JP_TYPE AND C.JPM_PROFILE_ID=B.JPM_PROFILE_ID AND C.JPM_CAT_SETID = B.JPM_CAT_SETID AND C.JPM_RLAT_KEY1 = B.JPM_RLAT_KEY1 AND C.EFFDT <=%CurrentDateIn) |
| # | 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.
Prompt Table: JPM_PROFILE |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | 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. |
| 4 | 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. |
| 5 | 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). |
| 6 | 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). |
| 7 | 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). |
| 8 | 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). |
| 9 | JPM_JP_XRLAT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Indicates the type of relationship - profile identity, profile association, search filter, etc - that is represented for JPM Profiles
ASSC=Profile Association FLT=Search Filter PIDO=Profile Identity Option |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | JPM_JP_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type |
| 12 | JPM_JP_PRFL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of JPM Profile
A=Active I=Inactive |
| 13 | JPM_PROFILE_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Value used to specify how the profile is used in business logic. This profile may represent a person profile, a profile in progress and not available for use, a job profile, etc.
A=Administrator Only J=End / Final / Job P=Person T=Template |
| 14 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 15 | JPM_LGCY_PRFL_ID | Character(12) | VARCHAR2(12) NOT NULL | Previous Profile ID that has been carried across during upgrade of Profiles to JPM |