JPM_CAT_TYPEPrompt Table: JPM_CT_NOHOC_VW
JPM_CAT_ITEM_IDPrompt Table: JPM_CAT_ITEMS
EFFDTDefault Value: %date
LANGUAGE_CDJPM_CAT_ITM_LNG(SQL Table) |
Index Back |
|---|---|
Catalog Items RLangDefines all of the Catalog Items for a particular Catalog Type. Important- All fields that are property fields yet not contained in the property subrecords (required properties) must exist before the property subrecords. All fields that are not properties but need to be fields in the record should be after the properties subrecord/s. Any field placed before the properties subrecords will become required properties for catalog types. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_CAT_TYPE |
Character(12) | VARCHAR2(12) NOT NULL |
The name of the type of items that will be used in a Catalog and or in a Profile.
Prompt Table: JPM_CT_NOHOC_VW |
| 2 | JPM_CAT_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
Prompt Table: JPM_CAT_ITEMS |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | JPM_DESCR90 | Character(90) | VARCHAR2(90) NOT NULL | jpm |
| 6 | JPM_TEXT1325_1 | Long Character(1325) | VARCHAR2(1325) | User Text - 1325 Char |
| 7 | JPM_TEXT1325_2 | Long Character(1325) | VARCHAR2(1325) | User Text - 1325 Char |
| 8 | JPM_TEXT254_1 | Character(254) | VARCHAR2(254) NOT NULL | User Text - 254 Char |
| 9 | JPM_TEXT254_2 | Character(254) | VARCHAR2(254) NOT NULL | User Text - 254 Char |
| 10 | JPM_TEXT254_3 | Character(254) | VARCHAR2(254) NOT NULL | User Text - 254 Char |
| 11 | JPM_TEXT254_4 | Character(254) | VARCHAR2(254) NOT NULL | User Text - 254 Char |
| 12 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 13 | DESCRLONG | Long Character | CLOB | Long Description |