HR_SSTEXT_CFG(SQL Table) |
Index Back |
|---|---|
HR Text Catalog ConfigurationThis table contains an entry for each application module that uses the HR Text Catalog. Each entry defines the context keys and associated prompt tables used by the application. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 2 | HR_SSTEXT_SUB_ID |
Character(4) | VARCHAR2(4) NOT NULL | The Sub ID is field that is optionally used to further partition Text Catalog entries within an Object Owner ID. For example, we might want to create a Sub ID to keep Text Catalog entries for Enrollment separate from the Text Catalog entries for the inquiry pages within the eBenefits ObjectOwnerId. |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | 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.
Y/N Table Edit Default Value: Y |
| 5 | HR_SSTEXT_CACHE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Text Catalog configuration switch. Determines whether caching will be used. This setting overrides any request that an application might make to cache the text catalog. Turning this switch off guarantees that caching will NOT occur. Turning it on merely means that an application request to cache the catalog will be honored.
Y/N Table Edit Default Value: Y |
| 6 | HR_SSTEXT_SHOW_ID | Character(1) | VARCHAR2(1) NOT NULL |
Switch that controls whether text from the Text Catalog, or the Text ID will be returned from the Text Catalog API.
Useful for documenting the Text Ids that are implemented on an application page.
Y/N Table Edit Default Value: N |
| 7 | HR_SSTEXT_KEY1_REC | Character(15) | VARCHAR2(15) NOT NULL |
HR Self-Service Text Catalog - stores the prompt table for Key 1.
Prompt Table: PSRECDEFN_VW1 |
| 8 | HR_SSTEXT_KEY1_FLD | Character(18) | VARCHAR2(18) NOT NULL |
HR Self-Service Text Catalog - stores the prompt field name for Key 1.
Prompt Table: HR_SSTEXT_K1_VW |
| 9 | HR_SSTEXT_KEY2_REC | Character(15) | VARCHAR2(15) NOT NULL |
HR Self-Service Text Catalog - stores the prompt table for Key 2.
Prompt Table: PSRECDEFN_VW1 |
| 10 | HR_SSTEXT_KEY2_FLD | Character(18) | VARCHAR2(18) NOT NULL |
HR Self-Service Text Catalog - stores the prompt field name for Key 2.
Prompt Table: HR_SSTEXT_K2_VW |
| 11 | HR_SSTEXT_KEY3_REC | Character(15) | VARCHAR2(15) NOT NULL |
HR Self-Service Text Catalog - stores the prompt table for Key 3.
Prompt Table: PSRECDEFN_VW1 |
| 12 | HR_SSTEXT_KEY3_FLD | Character(18) | VARCHAR2(18) NOT NULL |
HR Self-Service Text Catalog - stores the prompt field name for Key 3.
Prompt Table: HR_SSTEXT_K3_VW |
| 13 | HR_SSTEXT_KEY4_REC | Character(15) | VARCHAR2(15) NOT NULL |
HR Self-Service Text Catalog - stores the prompt table for Key 4.
Prompt Table: PSRECDEFN_VW1 |
| 14 | HR_SSTEXT_KEY4_FLD | Character(18) | VARCHAR2(18) NOT NULL |
HR Self-Service Text Catalog - stores the prompt field name for Key 4.
Prompt Table: HR_SSTEXT_K4_VW |
| 15 | HR_SSTEXT_KEY5_REC | Character(15) | VARCHAR2(15) NOT NULL |
HR Self-Service Text Catalog - stores the prompt table for Key 5
Prompt Table: PSRECDEFN_VW1 |
| 16 | HR_SSTEXT_KEY5_FLD | Character(18) | VARCHAR2(18) NOT NULL |
HR Self-Service Text Catalog - stores the prompt field name for Key 5.
Prompt Table: HR_SSTEXT_K5_VW |
| 17 | HR_SSTEXT_KEY6_REC | Character(15) | VARCHAR2(15) NOT NULL |
HR Self-Service Text Catalog - stores the prompt table for Key 6
Prompt Table: PSRECDEFN_VW1 |
| 18 | HR_SSTEXT_KEY6_FLD | Character(18) | VARCHAR2(18) NOT NULL |
HR Self-Service Text Catalog - stores the prompt field name for Key 6.
Prompt Table: HR_SSTEXT_K6_VW |