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 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
2 | JPM_SRCH_SUB_ID | Character(4) | VARCHAR2(4) NOT NULL |
Sub Application Id
SP=Succession Planning |
3 | JPM_SRCH_ID | Character(18) | VARCHAR2(18) NOT NULL | Search Id |
4 | JPM_ROLE | 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 |