HCR_SM_RSEC_TBL(SQL Table) |
Index Back |
---|---|
Search Match Result SecuritySearch Match Result Security Table. This table defines which security roles can use a particular search result value |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Type: This field identifies the domain of core data to be searched.
A=Applicant O=Organization P=Person |
2 | SM_RSLT_CD | Character(15) | VARCHAR2(15) NOT NULL | Search Match Result Code. |
3 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |