JPM_JP_TYP_PIDS

(SQL Table)
Index Back

Profile Identity Options

JPM Profile Identity Option definitions

# 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 Effective Date

Default Value: %date

3 JPM_RLAT_NAME Character(30) VARCHAR2(30) NOT NULL Name of the relationship being established between JPM Data and External Data. Example - JOB CODE might be used to indicate that the relationship is between a JPM Profile of Job and External Data such as the Job Code on the Job Code table.

Prompt Table: JPM_RLAT_ENB_VW

4 JPM_JP_END_PROFILE Character(1) VARCHAR2(1) NOT NULL Job Profile End Profile flag
N=No
Y=Yes
5 JPM_JP_TEMPLATE Character(1) VARCHAR2(1) NOT NULL Job Profile End Profile flag
N=No
Y=Yes
6 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