JPM_PROFILE_USAGEJ=Non-Person
P=Person
JPM_RLAT_NAMELANGUAGE_CDJPM_RLAT_ENB_LN(SQL View) |
Index Back |
|---|---|
JPM_RLAT_ENB_LNJPM_RLAT_ENB_LN is Related Lanaguage view for JPM_RLAT_ENB_VW |
| SELECT C.JPM_PROFILE_USAGE , C.JPM_RLAT_NAME , L.LANGUAGE_CD , L.DESCR FROM PS_JPM_RLAT_SEL_LN L , PS_JPM_RLAT_SEL S , PS_JPM_RLAT_CFG C WHERE S.JPM_JP_RLTN_ENABLD = 'Y' AND C.JPM_JP_XRLAT_TYPE = 'PIDO' AND L.JPM_RLAT_NAME = C.JPM_RLAT_NAME AND S.JPM_RLAT_NAME = C.JPM_RLAT_NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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.
J=Non-Person P=Person |
| 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |