JPM_PROFILE_IDJPM_CAT_TYPEJPM_CAT_ITEM_IDJPM_ITEM_KEY_IDN=No
Y=Yes
Default Value: N
Default Value: N
FT_TP_PITEMS(SQL View) |
Index Back |
|---|---|
Extract RecordExtract Record for TalentProfileContentType |
| SELECT PS_FT_TP_PITEMS_P1.JPM_PROFILE_ID , PS_FT_TP_PITEMS_P1.JPM_CAT_TYPE , PS_FT_TP_PITEMS_P1.JPM_CAT_ITEM_ID , PS_FT_TP_PITEMS_P1.JPM_ITEM_KEY_ID , JPM_CAT_TYPE2 , JPM_CAT_ITEM_ID2 , JPM_PARENT_KEY_ID , FT_TP_ITEM_GUID , FT_BUS_GROUP_GUID , FT_PARENTITEM_GUID , FT_TP_GUID , FT_TPCT_GUID , FT_TPCI_GUID , FT_SOURCEID_GUID , FT_SOURCE_TYPE , FT_SOURCEKEY1_GUID , FT_SOURCEKEY2_GUID , FT_SOURCEKEY3_GUID , FT_EFF_START_DATE , FT_EFF_END_DATE , FT_TPIQ_GUID , FT_TPIQ_GUID2 , FT_TPRM_GUID , FT_TPRM_GUID2 , FT_TPRM_GUID3 , FT_TPRL_GUID , FT_TPRL_GUID2 , FT_TPRL_GUID3 , FT_INTEREST_LEVEL , FT_MANDATORY , FT_IMPORTANCE , FT_ITEMTEXT240_1 , FT_ITEMTEXT240_2 , FT_ITEMTEXT240_3 , FT_ITEMTEXT240_4 , FT_ITEMTEXT240_5 , FT_ITEMTEXT240_6 , FT_ITEMTEXT240_7 , FT_ITEMTEXT240_8 , FT_ITEMTEXT240_9 , FT_ITEMTEXT240_10 , FT_ITEMTEXT240_11 , FT_ITEMTEXT240_12 , FT_ITEMTEXT240_13 , FT_ITEMTEXT240_14 , FT_ITEMTEXT240_15 , FT_ITMTXT2000_1 , FT_ITMTXT2000_2 , FT_ITMTXT2000_3 , FT_ITMTXT2000_4 , FT_ITMTXT2000_5 , FT_ITEM_TEXT_1 , FT_ITEM_TEXT_2 , FT_ITEM_TEXT_3 , FT_ITEM_TEXT_4 , FT_ITEM_TEXT_5 , FT_ITEM_TEXT_6 , FT_ITEM_TEXT_7 , FT_ITEM_TEXT_8 , FT_ITEM_TEXT_9 , FT_ITEM_TEXT_10 , FT_ITEM_TEXT_11 , FT_ITEM_TEXT_12 , FT_ITEM_TEXT_13 , FT_ITEM_TEXT_14 , FT_ITEM_TEXT_15 , FT_ITEM_DATE_1 , FT_ITEM_DATE_2 , FT_ITEM_DATE_3 , FT_ITEM_DATE_4 , FT_ITEM_DATE_5 , FT_ITEM_DATE_6 , FT_ITEM_DATE_7 , FT_ITEM_DATE_8 , FT_ITEM_DATE_9 , FT_ITEM_DATE_10 , FT_ITEM_NUM1 , FT_ITEM_NUM2 , FT_ITEM_NUM3 , FT_ITEM_NUM4 , FT_ITEM_NUM5 , FT_ITEM_NUM6 , FT_ITEM_NUM7 , FT_ITEM_NUM8 , FT_ITEM_NUM9 , FT_ITEM_NUM10 , FT_ITEM_DEC_1 , FT_ITEM_DEC_2 , FT_ITEM_DEC_3 , FT_ITEM_DEC_4 , FT_ITEM_DEC_5 , FT_ATTR_CATEGORY , FT_ATTRIBUTE1 , FT_ATTRIBUTE2 , FT_ATTRIBUTE3 , FT_ATTRIBUTE4 , FT_ATTRIBUTE5 , FT_ATTRIBUTE6 , FT_ATTRIBUTE7 , FT_ATTRIBUTE8 , FT_ATTRIBUTE9 , FT_ATTRIBUTE10 , FT_ATTRIBUTE11 , FT_ATTRIBUTE12 , FT_ATTRIBUTE13 , FT_ATTRIBUTE14 , FT_ATTRIBUTE15 , FT_ATTRIBUTE16 , FT_ATTRIBUTE17 , FT_ATTRIBUTE18 , FT_ATTRIBUTE19 , FT_ATTRIBUTE20 , FT_ATTRIBUTE21 , FT_ATTRIBUTE22 , FT_ATTRIBUTE23 , FT_ATTRIBUTE24 , FT_ATTRIBUTE25 , FT_ATTRIBUTE26 , FT_ATTRIBUTE27 , FT_ATTRIBUTE28 , FT_ATTRIBUTE29 , FT_ATTRIBUTE30 , FT_INFO_CATEGORY , FT_ORG_INFO1 , FT_ORG_INFO2 , FT_ORG_INFO3 , FT_ORG_INFO4 , FT_ORG_INFO5 , FT_ORG_INFO6 , FT_ORG_INFO7 , FT_ORG_INFO8 , FT_ORG_INFO9 , FT_ORG_INFO10 , FT_ORG_INFO11 , FT_ORG_INFO12 , FT_ORG_INFO13 , FT_ORG_INFO14 , FT_ORG_INFO15 , FT_ORG_INFO16 , FT_ORG_INFO17 , FT_ORG_INFO18 , FT_ORG_INFO19 , FT_ORG_INFO20 , FT_ORG_INFO21 , FT_ORG_INFO22 , FT_ORG_INFO23 , FT_ORG_INFO24 , FT_ORG_INFO25 , FT_ORG_INFO26 , FT_ORG_INFO27 , FT_ORG_INFO28 , FT_ORG_INFO29 , FT_ORG_INFO30 , FT_OBJ_VER_NUM , FT_CREATED_BY , FT_CREATION_DATE , FT_LAST_UPD_DATE , FT_LAST_UPDATED_BY , FT_LAST_UPD_LOGIN , COUNTRY , FT_COUNTRY_GUID , FT_STATE_GUID , FT_DESCR30 , FT_ITEM_GUID1 , FT_ITEM_GUID2 , FT_ITEM_GUID3 , FT_ITEM_GUID4 , FT_ITEM_GUID5 , FT_ITEM_GUID6 , FT_ITEM_GUID7 , FT_ITEM_GUID8 , FT_ITEM_GUID9 , FT_ITEM_GUID10 , FT_PROC_MARKER , FT_ERROR_FLAG , FT_BYPASS_FLAG , FT_ALTERNATE_REC , FT_ALTERNATE_KEY , FT_SYS_DATA_FLG_CT , FT_SYS_DATA_FLG_IQ , FT_SYSTEM_DATA_FLG , JPM_JP_QUAL_SET , JPM_JP_QUAL_SET2 FROM PS_FT_TP_PITEMS_P1 , PS_FT_TP_PITEMS_P2 WHERE PS_FT_TP_PITEMS_P1.JPM_PROFILE_ID = PS_FT_TP_PITEMS_P2.JPM_PROFILE_ID AND PS_FT_TP_PITEMS_P1.JPM_CAT_TYPE = PS_FT_TP_PITEMS_P2.JPM_CAT_TYPE AND PS_FT_TP_PITEMS_P1.JPM_CAT_ITEM_ID = PS_FT_TP_PITEMS_P1.JPM_CAT_ITEM_ID AND PS_FT_TP_PITEMS_P1.JPM_ITEM_KEY_ID = PS_FT_TP_PITEMS_P2.JPM_ITEM_KEY_ID |
| # | 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 | JPM_CAT_TYPE2 | Character(12) | VARCHAR2(12) NOT NULL | Secondary content item type (as in a related item- such as a child or a supporting item of another item). |
| 6 | JPM_CAT_ITEM_ID2 | Character(12) | VARCHAR2(12) NOT NULL | Secondary content item id (as in a related item- such as a child or a supporting item of another item). |
| 7 | JPM_PARENT_KEY_ID | Number(12,0) | DECIMAL(12) NOT NULL | This is the JPM_ITEM_KEY_ID of the item in the profile that is the parent or driving item of the item. Example- a sub competency may have the item key id of the competency as the parent key. It is used to link more than one item together in a profile where a relationship was established. |
| 8 | FT_TP_ITEM_GUID | Character(36) | VARCHAR2(36) NOT NULL | TalentProfileGUID |
| 9 | FT_BUS_GROUP_GUID | Character(36) | VARCHAR2(36) NOT NULL | Business Group ID |
| 10 | FT_PARENTITEM_GUID | Character(36) | VARCHAR2(36) NOT NULL | TalentProfileGUID |
| 11 | FT_TP_GUID | Character(36) | VARCHAR2(36) NOT NULL | TalentProfileGUID |
| 12 | FT_TPCT_GUID | Character(36) | VARCHAR2(36) NOT NULL | TalentProfileContentType GUID |
| 13 | FT_TPCI_GUID | Character(36) | VARCHAR2(36) NOT NULL | TalentProfileContentItem GUID |
| 14 | FT_SOURCEID_GUID | Character(36) | VARCHAR2(36) NOT NULL | Source ID |
| 15 | FT_SOURCE_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Source Type |
| 16 | FT_SOURCEKEY1_GUID | Character(36) | VARCHAR2(36) NOT NULL | TalentProfileSourceKey GUID |
| 17 | FT_SOURCEKEY2_GUID | Character(36) | VARCHAR2(36) NOT NULL | TalentProfileSourceKey GUID |
| 18 | FT_SOURCEKEY3_GUID | Character(36) | VARCHAR2(36) NOT NULL | TalentProfileSourceKey GUID |
| 19 | FT_EFF_START_DATE | Date(10) | DATE | Effective Start Date |
| 20 | FT_EFF_END_DATE | Date(10) | DATE | Effective End Date |
| 21 | FT_TPIQ_GUID | Character(36) | VARCHAR2(36) NOT NULL | TPInstanceQualifierGUID |
| 22 | FT_TPIQ_GUID2 | Character(36) | VARCHAR2(36) NOT NULL | TPInstanceQualifierGUID |
| 23 | FT_TPRM_GUID | Character(36) | VARCHAR2(36) NOT NULL | Rating Model GUID |
| 24 | FT_TPRM_GUID2 | Character(36) | VARCHAR2(36) NOT NULL | Rating Model GUID |
| 25 | FT_TPRM_GUID3 | Character(36) | VARCHAR2(36) NOT NULL | Rating Model GUID |
| 26 | FT_TPRL_GUID | Character(36) | VARCHAR2(36) NOT NULL | Rating Level GUID |
| 27 | FT_TPRL_GUID2 | Character(36) | VARCHAR2(36) NOT NULL | Rating Level GUID |
| 28 | FT_TPRL_GUID3 | Character(36) | VARCHAR2(36) NOT NULL | Rating Level GUID |
| 29 | FT_INTEREST_LEVEL | Character(30) | VARCHAR2(30) NOT NULL | Interest Level |
| 30 | FT_MANDATORY | Character(30) | VARCHAR2(30) NOT NULL | Mandatory |
| 31 | FT_IMPORTANCE | Character(30) | VARCHAR2(30) NOT NULL | Importance |
| 32 | FT_ITEMTEXT240_1 | Character(240) | VARCHAR2(240) NOT NULL | Text |
| 33 | FT_ITEMTEXT240_2 | Character(240) | VARCHAR2(240) NOT NULL | Text |
| 34 | FT_ITEMTEXT240_3 | Character(240) | VARCHAR2(240) NOT NULL | Text |
| 35 | FT_ITEMTEXT240_4 | Character(240) | VARCHAR2(240) NOT NULL | Text |
| 36 | FT_ITEMTEXT240_5 | Character(240) | VARCHAR2(240) NOT NULL | Text |
| 37 | FT_ITEMTEXT240_6 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 38 | FT_ITEMTEXT240_7 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 39 | FT_ITEMTEXT240_8 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 40 | FT_ITEMTEXT240_9 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 41 | FT_ITEMTEXT240_10 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 42 | FT_ITEMTEXT240_11 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 43 | FT_ITEMTEXT240_12 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 44 | FT_ITEMTEXT240_13 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 45 | FT_ITEMTEXT240_14 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 46 | FT_ITEMTEXT240_15 | Character(1) | VARCHAR2(1) NOT NULL | Text |
| 47 | FT_ITMTXT2000_1 | Long Character(1325) | VARCHAR2(1325) | Text |
| 48 | FT_ITMTXT2000_2 | Long Character(1325) | VARCHAR2(1325) | Text |
| 49 | FT_ITMTXT2000_3 | Long Character(1325) | VARCHAR2(1325) | Text |
| 50 | FT_ITMTXT2000_4 | Long Character(1325) | VARCHAR2(1325) | Text |
| 51 | FT_ITMTXT2000_5 | Long Character(1325) | VARCHAR2(1325) | Text |
| 52 | FT_ITEM_TEXT_1 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 53 | FT_ITEM_TEXT_2 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 54 | FT_ITEM_TEXT_3 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 55 | FT_ITEM_TEXT_4 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 56 | FT_ITEM_TEXT_5 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 57 | FT_ITEM_TEXT_6 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 58 | FT_ITEM_TEXT_7 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 59 | FT_ITEM_TEXT_8 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 60 | FT_ITEM_TEXT_9 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 61 | FT_ITEM_TEXT_10 | Character(30) | VARCHAR2(30) NOT NULL | Item text |
| 62 | FT_ITEM_TEXT_11 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 63 | FT_ITEM_TEXT_12 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 64 | FT_ITEM_TEXT_13 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 65 | FT_ITEM_TEXT_14 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 66 | FT_ITEM_TEXT_15 | Character(1) | VARCHAR2(1) NOT NULL | Item text |
| 67 | FT_ITEM_DATE_1 | Date(10) | DATE | Date |
| 68 | FT_ITEM_DATE_2 | Date(10) | DATE | Date |
| 69 | FT_ITEM_DATE_3 | Date(10) | DATE | Date |
| 70 | FT_ITEM_DATE_4 | Date(10) | DATE | Date |
| 71 | FT_ITEM_DATE_5 | Date(10) | DATE | Date |
| 72 | FT_ITEM_DATE_6 | Date(10) | DATE | Date |
| 73 | FT_ITEM_DATE_7 | Date(10) | DATE | Date |
| 74 | FT_ITEM_DATE_8 | Date(10) | DATE | Date |
| 75 | FT_ITEM_DATE_9 | Date(10) | DATE | Date |
| 76 | FT_ITEM_DATE_10 | Date(10) | DATE | Date |
| 77 | FT_ITEM_NUM1 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 78 | FT_ITEM_NUM2 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 79 | FT_ITEM_NUM3 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 80 | FT_ITEM_NUM4 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 81 | FT_ITEM_NUM5 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 82 | FT_ITEM_NUM6 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 83 | FT_ITEM_NUM7 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 84 | FT_ITEM_NUM8 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 85 | FT_ITEM_NUM9 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 86 | FT_ITEM_NUM10 | Character(18) | VARCHAR2(18) NOT NULL | Item Number |
| 87 | FT_ITEM_DEC_1 | Character(18) | VARCHAR2(18) NOT NULL | Item Decimal |
| 88 | FT_ITEM_DEC_2 | Character(18) | VARCHAR2(18) NOT NULL | Item Decimal |
| 89 | FT_ITEM_DEC_3 | Character(18) | VARCHAR2(18) NOT NULL | Item Decimal |
| 90 | FT_ITEM_DEC_4 | Character(18) | VARCHAR2(18) NOT NULL | Item Decimal |
| 91 | FT_ITEM_DEC_5 | Character(18) | VARCHAR2(18) NOT NULL | Item Decimal |
| 92 | FT_ATTR_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | Attribute Category |
| 93 | FT_ATTRIBUTE1 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 94 | FT_ATTRIBUTE2 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 95 | FT_ATTRIBUTE3 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 96 | FT_ATTRIBUTE4 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 97 | FT_ATTRIBUTE5 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 98 | FT_ATTRIBUTE6 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 99 | FT_ATTRIBUTE7 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 100 | FT_ATTRIBUTE8 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 101 | FT_ATTRIBUTE9 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 102 | FT_ATTRIBUTE10 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 103 | FT_ATTRIBUTE11 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 104 | FT_ATTRIBUTE12 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 105 | FT_ATTRIBUTE13 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 106 | FT_ATTRIBUTE14 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 107 | FT_ATTRIBUTE15 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 108 | FT_ATTRIBUTE16 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 109 | FT_ATTRIBUTE17 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 110 | FT_ATTRIBUTE18 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 111 | FT_ATTRIBUTE19 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 112 | FT_ATTRIBUTE20 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 113 | FT_ATTRIBUTE21 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 114 | FT_ATTRIBUTE22 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 115 | FT_ATTRIBUTE23 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 116 | FT_ATTRIBUTE24 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 117 | FT_ATTRIBUTE25 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 118 | FT_ATTRIBUTE26 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 119 | FT_ATTRIBUTE27 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 120 | FT_ATTRIBUTE28 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 121 | FT_ATTRIBUTE29 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 122 | FT_ATTRIBUTE30 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 123 | FT_INFO_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | Attribute Category |
| 124 | FT_ORG_INFO1 | Character(150) | VARCHAR2(150) NOT NULL | ORG_INFORMATION1 |
| 125 | FT_ORG_INFO2 | Character(150) | VARCHAR2(150) NOT NULL | ORG_INFORMATION2 |
| 126 | FT_ORG_INFO3 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION3 |
| 127 | FT_ORG_INFO4 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION4 |
| 128 | FT_ORG_INFO5 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION5 |
| 129 | FT_ORG_INFO6 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION6 |
| 130 | FT_ORG_INFO7 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION7 |
| 131 | FT_ORG_INFO8 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION8 |
| 132 | FT_ORG_INFO9 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION9 |
| 133 | FT_ORG_INFO10 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION10 |
| 134 | FT_ORG_INFO11 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION11 |
| 135 | FT_ORG_INFO12 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION12 |
| 136 | FT_ORG_INFO13 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION13 |
| 137 | FT_ORG_INFO14 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION14 |
| 138 | FT_ORG_INFO15 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION15 |
| 139 | FT_ORG_INFO16 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION16 |
| 140 | FT_ORG_INFO17 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION17 |
| 141 | FT_ORG_INFO18 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION18 |
| 142 | FT_ORG_INFO19 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION19 |
| 143 | FT_ORG_INFO20 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION29 |
| 144 | FT_ORG_INFO21 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION21 |
| 145 | FT_ORG_INFO22 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION22 |
| 146 | FT_ORG_INFO23 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION23 |
| 147 | FT_ORG_INFO24 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION24 |
| 148 | FT_ORG_INFO25 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION25 |
| 149 | FT_ORG_INFO26 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION26 |
| 150 | FT_ORG_INFO27 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION27 |
| 151 | FT_ORG_INFO28 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION28 |
| 152 | FT_ORG_INFO29 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION29 |
| 153 | FT_ORG_INFO30 | Character(1) | VARCHAR2(1) NOT NULL | ORG_INFORMATION30 |
| 154 | FT_OBJ_VER_NUM | Number(9,0) | DECIMAL(9) NOT NULL | Object Version Number |
| 155 | FT_CREATED_BY | Character(64) | VARCHAR2(64) NOT NULL | Created By |
| 156 | FT_CREATION_DATE | Date(10) | DATE | Creation Date |
| 157 | FT_LAST_UPD_DATE | Date(10) | DATE | Last Updated Date |
| 158 | FT_LAST_UPDATED_BY | Character(64) | VARCHAR2(64) NOT NULL | Last Updated By |
| 159 | FT_LAST_UPD_LOGIN | Character(32) | VARCHAR2(32) NOT NULL | Last Updated Login |
| 160 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 161 | FT_COUNTRY_GUID | Character(36) | VARCHAR2(36) NOT NULL | CountryGUID |
| 162 | FT_STATE_GUID | Character(50) | VARCHAR2(50) NOT NULL | StateGUID |
| 163 | FT_DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 164 | FT_ITEM_GUID1 | Character(36) | VARCHAR2(36) NOT NULL | Item Number |
| 165 | FT_ITEM_GUID2 | Character(36) | VARCHAR2(36) NOT NULL | Item Number |
| 166 | FT_ITEM_GUID3 | Character(36) | VARCHAR2(36) NOT NULL | Item Number |
| 167 | FT_ITEM_GUID4 | Character(36) | VARCHAR2(36) NOT NULL | Item Number |
| 168 | FT_ITEM_GUID5 | Character(36) | VARCHAR2(36) NOT NULL | Item Number |
| 169 | FT_ITEM_GUID6 | Character(36) | VARCHAR2(36) NOT NULL | Item Number |
| 170 | FT_ITEM_GUID7 | Character(36) | VARCHAR2(36) NOT NULL | Item Number |
| 171 | FT_ITEM_GUID8 | Character(36) | VARCHAR2(36) NOT NULL | Item Number |
| 172 | FT_ITEM_GUID9 | Character(36) | VARCHAR2(36) NOT NULL | Item Number |
| 173 | FT_ITEM_GUID10 | Character(36) | VARCHAR2(36) NOT NULL | Item Number |
| 174 | FT_PROC_MARKER | Character(36) | VARCHAR2(36) NOT NULL | Process marker field |
| 175 | FT_ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
N=No Y=Yes Default Value: N |
| 176 | FT_BYPASS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Bypass Flag
Default Value: N |
| 177 | FT_ALTERNATE_REC | Character(50) | VARCHAR2(50) NOT NULL | Source Record |
| 178 | FT_ALTERNATE_KEY | Character(254) | VARCHAR2(254) NOT NULL | Alternate Key |
| 179 | FT_SYS_DATA_FLG_CT | Character(1) | VARCHAR2(1) NOT NULL | This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. |
| 180 | FT_SYS_DATA_FLG_IQ | Character(1) | VARCHAR2(1) NOT NULL | This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. |
| 181 | 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. |
| 182 | JPM_JP_QUAL_SET | Character(12) | VARCHAR2(12) NOT NULL | 1st Instance Qualifier Set Name for a JPM Profile Item |
| 183 | JPM_JP_QUAL_SET2 | Character(12) | VARCHAR2(12) NOT NULL | 2nd Instance Qualifier Set Name for a JPM Profile Item |