FT_TP_PITEMS1

(SQL View)
 Index Back

Split View of Extract Record

Split view of Extract Record for TalentProfileContentType

SELECT JPM_PROFILE_ID , JPM_CAT_TYPE , JPM_CAT_ITEM_ID , 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_OBJ_VER_NUM , FT_PROC_MARKER , FT_ERROR_FLAG , FT_BYPASS_FLAG , FT_ALTERNATE_REC , FT_ALTERNATE_KEY FROM PS_FT_TP_PITEMS

# 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_OBJ_VER_NUM Number(9,0) DECIMAL(9) NOT NULL Object Version Number
125 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
126 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

127 FT_BYPASS_FLAG Character(1) VARCHAR2(1) NOT NULL Bypass Flag

Default Value: N

128 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
129 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key