JPM_JP_TYPES_LI (SQL View)	Index Back
Profile Types - Interface lang Interface view for the Profile Type record. This interface is used to expose the Profile Type 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).

JPM_JP_TYPES_LI

(SQL View)

Profile Types - Interface lang

Interface view for the Profile Type record. This interface is used to expose the Profile Type 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 JPM_JP_TYPE , EFFDT , LANGUAGE_CD , DESCR FROM PS_JPM_JP_TYPE_LNG

Related Language Record for JPM_JP_TYPES_I

# 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 NOT NULL Effective Date
Default Value: %date

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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 NOT NULL	Effective Date Default Value: %date
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description