JPM_RLAT_SEL(SQL Table) |
Index Back |
---|---|
Avail Profile Identity Options |
# | 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_RLTN_ENABLD | Character(1) | VARCHAR2(1) NOT NULL |
Relationship Enabled
N=Disabled Y=Enabled Y/N Table Edit Default Value: Y |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | 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 |