HR_PSS_CONFIG(SQL Table) |
Index Back |
|---|---|
Person Search Simple ConfigPerson Search Simple: Configuration for using the "Person Search Simple" within an application |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 2 | HR_PSS_SUB_ID |
Character(4) | VARCHAR2(4) NOT NULL | Person Search - Simple: Configuration SubID. |
| 3 | HR_PSS_MULTI_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Person Search - Simple: Configuration option that determines whether user can select multiple People.
Y/N Table Edit Default Value: N |
| 4 | HR_PSS_MAX_ROWS | Number(3,0) | SMALLINT NOT NULL |
Person Search - Simple: Configuration parameter determining the maximum number of rows that can be returned by a Search.
Default Value: 100 |
| 5 | HR_PSS_NAME_AC_SW | Character(1) | VARCHAR2(1) NOT NULL |
Person Search - Simple: Configuration option - determines whether NAME_AC search field is exposed.
Y/N Table Edit Default Value: Y |
| 6 | HR_PSS_EMPLID_SW | Character(1) | VARCHAR2(1) NOT NULL |
Person Search - Simple: Configuration option to expose EmplIDs in search results.
Y/N Table Edit Default Value: N |
| 7 | HR_PSS_HRSTAT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Person Search - Simple: Configuration option - determines how the HR Status checkboxes should render on the Search page.
D=Display Only E=Enterable H=Hidden Default Value: E |
| 8 | HR_PSS_HRSTAT_A_SW | Character(1) | VARCHAR2(1) NOT NULL |
Person Search - Simple: Switch to determine whether persons with a JOB in (A)ctive HR Status should be included.
Y/N Table Edit Default Value: Y |
| 9 | HR_PSS_HRSTAT_I_SW | Character(1) | VARCHAR2(1) NOT NULL |
Person Search - Simple: Switch to determine whether persons with a JOB in (I)nactive HR Status should be included.
Y/N Table Edit Default Value: N |
| 10 | HR_PSS_PERORG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Person Search - Simple: Configuration option - determines how the PerOrg checkboxes should render on the Search page.
D=Display Only E=Enterable H=Hidden Default Value: E |
| 11 | HR_PSS_EMP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Person Search - Simple: Switch to indicate whether Employees should be included in results.
Y/N Table Edit Default Value: Y |
| 12 | HR_PSS_CWR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Person Search - Simple: Switch to indicate whether Contingent Workers should be included in results.
Y/N Table Edit Default Value: N |
| 13 | HR_PSS_POI_SW | Character(1) | VARCHAR2(1) NOT NULL |
Person Search - Simple: Switch to indicate whether Persons of Interest should be included in results.
Y/N Table Edit Default Value: N |
| 14 | POI_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines the Transactional usage of POIs in HRMS.
Prompt Table: POI_TYPE_TBL |