JPM_JP_TYP_PI_I

(SQL View)
 Index Back

Profile Type Ident - Interface

Interface view for the Profile Type Identity Options record. This interface is used to expose the Profile Type Identity Options information to other applications outside of JPM. Applications inside the HRMS db can access this view directly, while applications that reside outside the HRMS db must use an EIP built upon this view (or rather a derived record that is basically this view).

SELECT A.JPM_JP_TYPE , A.EFFDT , A.JPM_RLAT_NAME , B.JPM_JP_END_PROFILE FROM PS_JPM_JP_TYP_PIDS A , PS_JPM_JP_TYPES B WHERE A.JPM_JP_TYPE = B.JPM_JP_TYPE AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JPM_JP_TYP_PIDS A1 WHERE A.JPM_JP_TYPE= A1.JPM_JP_TYPE AND A1.EFFDT <= B.EFFDT)

# 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 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.

Prompt Table: JPM_RLAT_ENB_VW

4 JPM_JP_END_PROFILE Character(1) VARCHAR2(1) NOT NULL Job Profile End Profile flag
N=No
Y=Yes