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_SUMMARY	Long Character	CLOB	Summary description of the Profile Type
5	JPM_JP_TYPE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of Job Profile Type A=Active I=Inactive P=Pending Default Value: A
6	JPM_PROFILE_USAGE	Character(1)	VARCHAR2(1) NOT NULL	Value used to specify how the profile is used in business logic. This profile may represent a person profile, a profile in progress and not available for use, a job profile, etc. A=Administrator Only J=End / Final / Job P=Person T=Template
7	JPM_SRCH_CTL	Character(1)	VARCHAR2(1) NOT NULL	JPM Search Control field N=Never P=Specified on Profile Y=Always Default Value: P
8	JPM_SUBSCRIBE_CTL	Character(1)	VARCHAR2(1) NOT NULL	JPM Subscribe Control field N=Never P=Specified on Profile Y=Always Default Value: P
9	END_EFFDT	Date(10)	DATE	End Effdt
10	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name Prompt Table: JPM_EO_TRANS_I
11	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID Prompt Table: EOAW_PRCS
12	JPM_PID_APPRVL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates if Approval is required for updates to Profile Identities for Profiles of this Type. Y/N Table Edit Default Value: N
13	JPM_JP_END_PROFILE	Character(1)	VARCHAR2(1) NOT NULL	Job Profile End Profile flag N=No Y=Yes Default Value: Y
14	JPM_DISP_TAB_ICONS	Character(1)	VARCHAR2(1) NOT NULL	Display Tab Icons Y/N Table Edit Default Value: N
15	ESIGN_ID	Character(5)	VARCHAR2(5) NOT NULL	Acknowledgement ID Prompt Table: ESIGN_HDR
16	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N