JPM_PRF_POS_I (SQL View)	Index Back
Position Profile Interface Vw Returns all active and end non-person profiles having an active POSITION profile identifier.

JPM_PRF_POS_I

(SQL View)

Position Profile Interface Vw

Returns all active and end non-person profiles having an active POSITION profile identifier.

SELECT %Substring(X.JPM_RLAT_KEY1, 1,8) , P.JPM_JP_TYPE , X.JPM_PROFILE_ID FROM PS_JPM_JP_X_RLAT X , PS_JPM_PROFILE P , PS_JPM_JP_TYPES T WHERE X.JPM_RLAT_NAME = 'POSITION' AND %EffdtCheck(JPM_JP_X_RLAT X1, X, %Currentdatein) AND X.EFF_STATUS = 'A' AND P.JPM_PROFILE_ID = X.JPM_PROFILE_ID AND P.JPM_JP_PRFL_STATUS = 'A' AND T.JPM_JP_TYPE = P.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_TYPES T1, T, %Currentdatein) AND T.JPM_JP_END_PROFILE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

2 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
2	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type
3	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.