JPMINSTALLATION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_PROFILE_LAST	Number(12,0)	DECIMAL(12) NOT NULL	Stores the Last Job Profile Management Profile ID value that allocated during auto-numbering of the Profile ID
2	JPM_PROFILE_ID_LEN	Number(2,0)	SMALLINT NOT NULL	Stores the allowable Profile ID length for Job Profile Management Profile IDs
3	JPM_DR_NAV_MTHD	Character(1)	VARCHAR2(1) NOT NULL	JPM - Direct Reports Supervisor Unload. Determines the Navigation Method to use when determining reporting relationships. Note: only a subset of the Direct Reports navigation methods are supported for purposes of Unloading to a flat table, as defined by the Translate Values for this field. 2=2 - Supervisor Id 3=3 - Department Manager Id 4=4 - Reports To Position 5=5 - Position / Supervisor Id 6=6 - Position / Dept Manager Default Value: 2
4	JPM_ITEM_KEY_LAST	Number(12,0)	DECIMAL(12) NOT NULL	Last Item Key ID Used Default Value: 1000
5	JPM_JP_TRAN_LAST	Number(12,0)	DECIMAL(12) NOT NULL	Last Approval Transaction Used Default Value: 100
6	JPM_PHOTO_ADM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag on JPM install table that identifies if an employee photo should be displayed on the person profile or not. Y/N Table Edit Default Value: N
7	JPM_PHOTO_SS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag on JPM install table that identifies if an employee photo should be displayed on the person profile or not, for self service pages. Y/N Table Edit Default Value: N
8	JPM_ITM_HIST_PRD	Number(3,0)	SMALLINT NOT NULL	Number of days of history to be displayed in the Profile Items status monitor grid. Default Value: 30