JPM_RLAT_CFG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	JPM_JP_XRLAT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Indicates the type of relationship - profile identity, profile association, search filter, etc - that is represented for JPM Profiles ASSC=Profile Association FLT=Search Filter PIDO=Profile Identity Option Default Value: PIDO
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 0
4	JPM_KEY_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	JPM - Record Name Prompt Table: JPM_RLAT_REC_VW
5	JPM_KEY1_FLD	Character(18)	VARCHAR2(18) NOT NULL	Key 1 Field Name Prompt Table: DERIVED_JPM
6	JPM_KEY2_FLD	Character(18)	VARCHAR2(18) NOT NULL	Key 2 Field Name Prompt Table: DERIVED_JPM
7	JPM_KEY3_FLD	Character(18)	VARCHAR2(18) NOT NULL	Key 3 Field Name Prompt Table: DERIVED_JPM
8	JPM_KEY4_FLD	Character(18)	VARCHAR2(18) NOT NULL	Key 4 Field Name Prompt Table: DERIVED_JPM
9	JPM_SETID_FLG	Character(1)	VARCHAR2(1) NOT NULL	SetID Flag Y/N Table Edit Default Value: N
10	JPM_EFFDT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Effective Dated Y/N Table Edit Default Value: N
11	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 Default Value: J
12	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