JPM_CAT_TYPEPrompt Table: JPM_CT_NOHOC_VW
JPM_CAT_ITEM_IDPrompt Table: JPM_CAT_ITEMS
EFFDTDefault Value: %date
N=No
Y=Yes
Default Value: N
Default Value: N
FT_TPCI_CITEMS(SQL Table) |
Index Back |
|---|---|
Catalog Items - Talent MgmtDefines 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 |
Effective Date
Default Value: %date |
| 4 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
| 5 | FT_TPCI_GUID | Character(36) | VARCHAR2(36) NOT NULL | TalentProfileContentItem GUID |
| 6 | FT_BUS_GROUP_GUID | Character(36) | VARCHAR2(36) NOT NULL | Business Group ID |
| 7 | FT_TPCT_GUID | Character(36) | VARCHAR2(36) NOT NULL | TalentProfileContentType GUID |
| 8 | FT_TPCI_CODE | Character(30) | VARCHAR2(30) NOT NULL | ContentItem Code |
| 9 | FT_NAME | Character(240) | VARCHAR2(240) NOT NULL | Name |
| 10 | FT_ITEM_DESCR_LONG | Long Character(1325) | VARCHAR2(1325) | Item Description |
| 11 | FT_EFF_START_DATE | Date(10) | DATE | Effective Start Date |
| 12 | FT_EFF_END_DATE | Date(10) | DATE | Effective End Date |
| 13 | FT_TPRM_GUID | Character(36) | VARCHAR2(36) NOT NULL | Rating Model GUID |
| 14 | FT_COUNTRY_GUID | Character(36) | VARCHAR2(36) NOT NULL | CountryGUID |
| 15 | FT_MODULE_ID | Character(32) | VARCHAR2(32) NOT NULL | Module Id |
| 16 | FT_TPCI_SUPPL_CODE | Character(30) | VARCHAR2(30) NOT NULL | Content Supplier Code |
| 17 | FT_CO_KEYFLEX_GUID | Character(36) | VARCHAR2(36) NOT NULL | Rating Model GUID |
| 18 | FT_ITEM_TEXT_TL_1 | Character(240) | VARCHAR2(240) NOT NULL | Item text |
| 19 | FT_ITEM_TEXT_TL_2 | Character(240) | VARCHAR2(240) NOT NULL | Item text |
| 20 | FT_ITEM_TEXT_TL_3 | Character(240) | VARCHAR2(240) NOT NULL | Item text |
| 21 | FT_ITEM_TEXT_TL_4 | Character(240) | VARCHAR2(240) NOT NULL | Item text |
| 22 | FT_ITEM_TEXT_TL_5 | Character(240) | VARCHAR2(240) NOT NULL | Item text |
| 23 | FT_ITEM_TEXT_TL_6 | Character(240) | VARCHAR2(240) NOT NULL | Item text |
| 24 | FT_ITEM_TEXT_TL_7 | Character(240) | VARCHAR2(240) NOT NULL | Item text |
| 25 | FT_ITEM_TEXT_TL_8 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 26 | FT_ITEM_TEXT_TL_9 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 27 | FT_ITEM_TEXT_TL_10 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 28 | FT_ITEM_TEXT_TL_11 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 29 | FT_ITEM_TEXT_TL_12 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 30 | FT_ITEM_TEXT_TL_13 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 31 | FT_ITEM_TEXT_TL_14 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 32 | FT_ITEM_TEXT_TL_15 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 33 | FT_DESCRLONG | Long Character(1325) | VARCHAR2(1325) | Long Description |
| 34 | FT_ITEM_NUM1 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 35 | FT_ITEM_NUM2 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 36 | FT_ITEM_NUM3 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 37 | FT_ITEM_NUM4 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 38 | FT_ITEM_NUM5 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 39 | FT_ITEM_NUM6 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 40 | FT_ITEM_NUM7 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 41 | FT_ITEM_NUM8 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 42 | FT_ITEM_NUM9 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 43 | FT_ITEM_NUM10 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 44 | FT_ITEM_DATE_1 | Date(10) | DATE | Date |
| 45 | FT_ITEM_DATE_2 | Date(10) | DATE | Date |
| 46 | FT_ITEM_DATE_3 | Date(10) | DATE | Date |
| 47 | FT_ITEM_DATE_4 | Date(10) | DATE | Date |
| 48 | FT_ITEM_DATE_5 | Date(10) | DATE | Date |
| 49 | FT_ITEM_DATE_6 | Date(10) | DATE | Date |
| 50 | FT_ITEM_DATE_7 | Date(10) | DATE | Date |
| 51 | FT_ITEM_DATE_8 | Date(10) | DATE | Date |
| 52 | FT_ITEM_DATE_9 | Date(10) | DATE | Date |
| 53 | FT_ITEM_DATE_10 | Date(10) | DATE | Date |
| 54 | FT_ITEM_TEXT_1 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 55 | FT_ITEM_TEXT_2 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 56 | FT_ITEM_TEXT_3 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 57 | FT_ITEM_TEXT_4 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 58 | FT_ITEM_TEXT_5 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 59 | FT_ITEM_TEXT_6 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 60 | FT_ITEM_TEXT_7 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 61 | FT_ITEM_TEXT_8 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 62 | FT_ITEM_TEXT_9 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 63 | FT_ITEM_TEXT_10 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 64 | FT_ITEM_TEXT_11 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 65 | FT_ITEM_TEXT_12 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 66 | FT_ITEM_TEXT_13 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 67 | FT_ITEM_TEXT_14 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 68 | FT_ITEM_TEXT_15 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 69 | FT_ITEM_TEXT_16 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 70 | FT_ITEM_TEXT_17 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 71 | FT_ITEM_TEXT_18 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 72 | FT_ITEM_TEXT_19 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 73 | FT_ITEM_TEXT_20 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 74 | FT_ITEM_TEXT_21 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 75 | FT_ITEM_TEXT_22 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 76 | FT_ITEM_TEXT_23 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 77 | FT_ITEM_TEXT_24 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 78 | FT_ITEM_TEXT_25 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 79 | FT_ITEM_TEXT_26 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 80 | FT_ITEM_TEXT_27 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 81 | FT_ITEM_TEXT_28 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 82 | FT_ITEM_TEXT_29 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 83 | FT_ITEM_TEXT_30 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 84 | FT_INFO_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | Attribute Category |
| 85 | FT_ORG_INFO1 | Character(150) | VARCHAR2(150) NOT NULL | ORG_INFORMATION1 |
| 86 | FT_ORG_INFO2 | Character(150) | VARCHAR2(150) NOT NULL | ORG_INFORMATION2 |
| 87 | FT_ORG_INFO3 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION3 |
| 88 | FT_ORG_INFO4 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION4 |
| 89 | FT_ORG_INFO5 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION5 |
| 90 | FT_ORG_INFO6 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION6 |
| 91 | FT_ORG_INFO7 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION7 |
| 92 | FT_ORG_INFO8 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION8 |
| 93 | FT_ORG_INFO9 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION9 |
| 94 | FT_ORG_INFO10 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION10 |
| 95 | FT_ORG_INFO11 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION11 |
| 96 | FT_ORG_INFO12 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION12 |
| 97 | FT_ORG_INFO13 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION13 |
| 98 | FT_ORG_INFO14 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION14 |
| 99 | FT_ORG_INFO15 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION15 |
| 100 | FT_ORG_INFO16 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION16 |
| 101 | FT_ORG_INFO17 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION17 |
| 102 | FT_ORG_INFO18 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION18 |
| 103 | FT_ORG_INFO19 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION19 |
| 104 | FT_ORG_INFO20 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION29 |
| 105 | FT_ORG_INFO21 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION21 |
| 106 | FT_ORG_INFO22 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION22 |
| 107 | FT_ORG_INFO23 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION23 |
| 108 | FT_ORG_INFO24 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION24 |
| 109 | FT_ORG_INFO25 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION25 |
| 110 | FT_ORG_INFO26 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION26 |
| 111 | FT_ORG_INFO27 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION27 |
| 112 | FT_ORG_INFO28 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION28 |
| 113 | FT_ORG_INFO29 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION29 |
| 114 | FT_ORG_INFO30 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION30 |
| 115 | FT_ATTR_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | Attribute Category |
| 116 | FT_ATTRIBUTE1 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 117 | FT_ATTRIBUTE2 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 118 | FT_ATTRIBUTE3 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 119 | FT_ATTRIBUTE4 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 120 | FT_ATTRIBUTE5 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 121 | FT_ATTRIBUTE6 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 122 | FT_ATTRIBUTE7 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 123 | FT_ATTRIBUTE8 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 124 | FT_ATTRIBUTE9 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 125 | FT_ATTRIBUTE10 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 126 | FT_ATTRIBUTE11 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 127 | FT_ATTRIBUTE12 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 128 | FT_ATTRIBUTE13 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 129 | FT_ATTRIBUTE14 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 130 | FT_ATTRIBUTE15 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 131 | FT_ATTRIBUTE16 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 132 | FT_ATTRIBUTE17 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 133 | FT_ATTRIBUTE18 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 134 | FT_ATTRIBUTE19 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 135 | FT_ATTRIBUTE20 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 136 | FT_ATTRIBUTE21 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 137 | FT_ATTRIBUTE22 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 138 | FT_ATTRIBUTE23 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 139 | FT_ATTRIBUTE24 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 140 | FT_ATTRIBUTE25 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 141 | FT_ATTRIBUTE26 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 142 | FT_ATTRIBUTE27 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 143 | FT_ATTRIBUTE28 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 144 | FT_ATTRIBUTE29 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 145 | FT_ATTRIBUTE30 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 146 | FT_OBJ_VER_NUM | Number(9,0) | DECIMAL(9) NOT NULL | Object Version Number |
| 147 | FT_CREATED_BY | Character(64) | VARCHAR2(64) NOT NULL | Created By |
| 148 | FT_CREATION_DATE | Date(10) | DATE | Creation Date |
| 149 | FT_LAST_UPD_DATE | Date(10) | DATE | Last Updated Date |
| 150 | FT_LAST_UPDATED_BY | Character(64) | VARCHAR2(64) NOT NULL | Last Updated By |
| 151 | FT_LAST_UPD_LOGIN | Character(32) | VARCHAR2(32) NOT NULL | Last Updated Login |
| 152 | FT_PROC_MARKER | Character(36) | VARCHAR2(36) NOT NULL | Process marker field |
| 153 | FT_ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
N=No Y=Yes Default Value: N |
| 154 | FT_BYPASS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Bypass Flag
Default Value: N |
| 155 | FT_ALTERNATE_REC | Character(50) | VARCHAR2(50) NOT NULL | Source Record |
| 156 | FT_ALTERNATE_KEY | Character(254) | VARCHAR2(254) NOT NULL | Alternate Key |
| 157 | FT_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. |