JPM_SRCH_ROLE(SQL Table) |
Index Back |
|---|---|
JPM Search ConfigurationDefines the roles that apply to a search configuration instance. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier | |
| 2 | Character(4) | VARCHAR2(4) NOT NULL |
Sub Application Id
SP=Succession Planning |
|
| 3 | Character(18) | VARCHAR2(18) NOT NULL | Search Id | |
| 4 | Character(3) | VARCHAR2(3) NOT NULL |
Role
ADM=Administrator EMP=Employee MGR=Manager |
|
| 5 | 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.
Default Value: N |