JPM_PROFILE_IDJPM_CAT_TYPEJPM_CAT_ITEM_IDJPM_ITEM_KEY_IDFT_TP_PITEMS_P2(SQL Table) |
Index Back |
|---|---|
Extract RecordExtract Record for TalentProfileContentType |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_PROFILE_ID |
Character(12) | VARCHAR2(12) NOT NULL | The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile. |
| 2 | 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. |
| 3 | JPM_CAT_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL | Catalog Item Id. Identifies a unique catalog item defintion within a catalog type. |
| 4 | JPM_ITEM_KEY_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification. |
| 5 | FT_ITEMTEXT240_1 | Character(240) | VARCHAR2(240) NOT NULL | Text |
| 6 | FT_ITEMTEXT240_2 | Character(240) | VARCHAR2(240) NOT NULL | Text |
| 7 | FT_ITEMTEXT240_3 | Character(240) | VARCHAR2(240) NOT NULL | Text |
| 8 | FT_ITEMTEXT240_4 | Character(240) | VARCHAR2(240) NOT NULL | Text |
| 9 | FT_ITEMTEXT240_5 | Character(240) | VARCHAR2(240) NOT NULL | Text |
| 10 | FT_ITEMTEXT240_6 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 11 | FT_ITEMTEXT240_7 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 12 | FT_ITEMTEXT240_8 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 13 | FT_ITEMTEXT240_9 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 14 | FT_ITEMTEXT240_10 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 15 | FT_ITEMTEXT240_11 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 16 | FT_ITEMTEXT240_12 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 17 | FT_ITEMTEXT240_13 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 18 | FT_ITEMTEXT240_14 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 19 | FT_ITEMTEXT240_15 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 20 | FT_ITMTXT2000_1 | Long Character(1325) | VARCHAR2(1325) | Text |
| 21 | FT_ITMTXT2000_2 | Long Character(1325) | VARCHAR2(1325) | Text |
| 22 | FT_ITMTXT2000_3 | Long Character(1325) | VARCHAR2(1325) | Text |
| 23 | FT_ITMTXT2000_4 | Long Character(1325) | VARCHAR2(1325) | Text |
| 24 | FT_ITMTXT2000_5 | Long Character(1325) | VARCHAR2(1325) | Text |
| 25 | FT_ITEM_TEXT_1 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 26 | FT_ITEM_TEXT_2 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 27 | FT_ITEM_TEXT_3 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 28 | FT_ITEM_TEXT_4 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 29 | FT_ITEM_TEXT_5 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 30 | FT_ITEM_TEXT_6 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 31 | FT_ITEM_TEXT_7 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 32 | FT_ITEM_TEXT_8 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 33 | FT_ITEM_TEXT_9 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 34 | FT_ITEM_TEXT_10 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 35 | FT_ITEM_TEXT_11 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 36 | FT_ITEM_TEXT_12 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 37 | FT_ITEM_TEXT_13 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 38 | FT_ITEM_TEXT_14 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 39 | FT_ITEM_TEXT_15 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 40 | FT_ITEM_DATE_1 | Date(10) | DATE | Date |
| 41 | FT_ITEM_DATE_2 | Date(10) | DATE | Date |
| 42 | FT_ITEM_DATE_3 | Date(10) | DATE | Date |
| 43 | FT_ITEM_DATE_4 | Date(10) | DATE | Date |
| 44 | FT_ITEM_DATE_5 | Date(10) | DATE | Date |
| 45 | FT_ITEM_DATE_6 | Date(10) | DATE | Date |
| 46 | FT_ITEM_DATE_7 | Date(10) | DATE | Date |
| 47 | FT_ITEM_DATE_8 | Date(10) | DATE | Date |
| 48 | FT_ITEM_DATE_9 | Date(10) | DATE | Date |
| 49 | FT_ITEM_DATE_10 | Date(10) | DATE | Date |
| 50 | FT_ITEM_NUM1 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 51 | FT_ITEM_NUM2 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 52 | FT_ITEM_NUM3 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 53 | FT_ITEM_NUM4 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 54 | FT_ITEM_NUM5 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 55 | FT_ITEM_NUM6 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 56 | FT_ITEM_NUM7 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 57 | FT_ITEM_NUM8 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 58 | FT_ITEM_NUM9 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 59 | FT_ITEM_NUM10 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 60 | FT_ITEM_DEC_1 | Character(18) | VARCHAR2(18) NOT NULL | Item Decimal |
| 61 | FT_ITEM_DEC_2 | Character(18) | VARCHAR2(18) NOT NULL | Item Decimal |
| 62 | FT_ITEM_DEC_3 | Character(18) | VARCHAR2(18) NOT NULL | Item Decimal |
| 63 | FT_ITEM_DEC_4 | Character(18) | VARCHAR2(18) NOT NULL | Item Decimal |
| 64 | FT_ITEM_DEC_5 | Character(18) | VARCHAR2(18) NOT NULL | Item Decimal |
| 65 | FT_ATTR_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | Attribute Category |
| 66 | FT_ATTRIBUTE1 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 67 | FT_ATTRIBUTE2 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 68 | FT_ATTRIBUTE3 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 69 | FT_ATTRIBUTE4 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 70 | FT_ATTRIBUTE5 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 71 | FT_ATTRIBUTE6 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 72 | FT_ATTRIBUTE7 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 73 | FT_ATTRIBUTE8 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 74 | FT_ATTRIBUTE9 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 75 | FT_ATTRIBUTE10 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 76 | FT_ATTRIBUTE11 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 77 | FT_ATTRIBUTE12 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 78 | FT_ATTRIBUTE13 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 79 | FT_ATTRIBUTE14 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 80 | FT_ATTRIBUTE15 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 81 | FT_ATTRIBUTE16 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 82 | FT_ATTRIBUTE17 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 83 | FT_ATTRIBUTE18 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 84 | FT_ATTRIBUTE19 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 85 | FT_ATTRIBUTE20 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 86 | FT_ATTRIBUTE21 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 87 | FT_ATTRIBUTE22 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 88 | FT_ATTRIBUTE23 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 89 | FT_ATTRIBUTE24 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 90 | FT_ATTRIBUTE25 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 91 | FT_ATTRIBUTE26 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 92 | FT_ATTRIBUTE27 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 93 | FT_ATTRIBUTE28 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 94 | FT_ATTRIBUTE29 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 95 | FT_ATTRIBUTE30 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 96 | FT_INFO_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | Attribute Category |
| 97 | FT_ORG_INFO1 | Character(150) | VARCHAR2(150) NOT NULL | ORG_INFORMATION1 |
| 98 | FT_ORG_INFO2 | Character(150) | VARCHAR2(150) NOT NULL | ORG_INFORMATION2 |
| 99 | FT_ORG_INFO3 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION3 |
| 100 | FT_ORG_INFO4 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION4 |
| 101 | FT_ORG_INFO5 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION5 |
| 102 | FT_ORG_INFO6 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION6 |
| 103 | FT_ORG_INFO7 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION7 |
| 104 | FT_ORG_INFO8 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION8 |
| 105 | FT_ORG_INFO9 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION9 |
| 106 | FT_ORG_INFO10 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION10 |
| 107 | FT_ORG_INFO11 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION11 |
| 108 | FT_ORG_INFO12 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION12 |
| 109 | FT_ORG_INFO13 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION13 |
| 110 | FT_ORG_INFO14 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION14 |
| 111 | FT_ORG_INFO15 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION15 |
| 112 | FT_ORG_INFO16 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION16 |
| 113 | FT_ORG_INFO17 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION17 |
| 114 | FT_ORG_INFO18 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION18 |
| 115 | FT_ORG_INFO19 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION19 |
| 116 | FT_ORG_INFO20 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION29 |
| 117 | FT_ORG_INFO21 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION21 |
| 118 | FT_ORG_INFO22 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION22 |
| 119 | FT_ORG_INFO23 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION23 |
| 120 | FT_ORG_INFO24 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION24 |
| 121 | FT_ORG_INFO25 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION25 |
| 122 | FT_ORG_INFO26 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION26 |
| 123 | FT_ORG_INFO27 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION27 |
| 124 | FT_ORG_INFO28 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION28 |
| 125 | FT_ORG_INFO29 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION29 |
| 126 | FT_ORG_INFO30 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION30 |
| 127 | FT_OBJ_VER_NUM | Number(9,0) | DECIMAL(9) NOT NULL | Object Version Number |
| 128 | FT_CREATED_BY | Character(64) | VARCHAR2(64) NOT NULL | Created By |
| 129 | FT_CREATION_DATE | Date(10) | DATE | Creation Date |
| 130 | FT_LAST_UPD_DATE | Date(10) | DATE | Last Updated Date |
| 131 | FT_LAST_UPDATED_BY | Character(64) | VARCHAR2(64) NOT NULL | Last Updated By |
| 132 | FT_LAST_UPD_LOGIN | Character(32) | VARCHAR2(32) NOT NULL | Last Updated Login |