JPM_JP_TYPES_I (SQL View)	Index Back
Profile Types - Interface View 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_I

(SQL View)

Profile Types - Interface View

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 , DESCR , JPM_JP_TYPE_STATUS FROM PS_JPM_JP_TYPES

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 JPM_JP_TYPE_STATUS Character(1) VARCHAR2(1) NOT NULL Status of Job Profile Type
A=Active
I=Inactive
P=Pending
Default Value: 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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	JPM_JP_TYPE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of Job Profile Type A=Active I=Inactive P=Pending Default Value: A