SM_TYPEA=Applicant
O=Organization
P=Person
SM_PARM_CDROLENAMEPrompt Table: PSROLEDEFN
HCR_SM_PSEC_TBL(SQL Table) |
Index Back |
|---|---|
Search Match Parm SecuritySearch Match Parameter Security Table. This table defines which security roles can use a particular search parameters 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_PARM_CD |
Character(15) | VARCHAR2(15) NOT NULL | Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition. |
| 3 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |