JPM_JP_TYPEJPM_RLAT_NAMEJPM_PREFIL_PROFILEJPM_JP_RLAT_VW(SQL View) |
Index Back |
|---|
| SELECT P.JPM_JP_TYPE , R.JPM_RLAT_NAME , P.JPM_PROFILE_ID , P.DESCR FROM PS_JPM_JP_X_RLAT R , PS_JPM_PROFILE P WHERE JPM_JP_XRLAT_TYPE = 'PIDO' AND %EffdtCheck(JPM_JP_X_RLAT R1, R, %Currentdatein) AND R.JPM_PROFILE_ID = P.JPM_PROFILE_ID AND R.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_JP_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type |
| 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_PREFIL_PROFILE |
Character(12) | VARCHAR2(12) NOT NULL | Profile Id |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |