FT_TP_PITEMS_P1

(SQL Table)
 Index Back

Extract Record

Extract 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 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 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
33 FT_COUNTRY_GUID Character(36) VARCHAR2(36) NOT NULL CountryGUID
34 FT_STATE_GUID Character(50) VARCHAR2(50) NOT NULL StateGUID
35 FT_DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
36 FT_ITEM_GUID1 Character(36) VARCHAR2(36) NOT NULL Item Number
37 FT_ITEM_GUID2 Character(36) VARCHAR2(36) NOT NULL Item Number
38 FT_ITEM_GUID3 Character(36) VARCHAR2(36) NOT NULL Item Number
39 FT_ITEM_GUID4 Character(36) VARCHAR2(36) NOT NULL Item Number
40 FT_ITEM_GUID5 Character(36) VARCHAR2(36) NOT NULL Item Number
41 FT_ITEM_GUID6 Character(36) VARCHAR2(36) NOT NULL Item Number
42 FT_ITEM_GUID7 Character(36) VARCHAR2(36) NOT NULL Item Number
43 FT_ITEM_GUID8 Character(36) VARCHAR2(36) NOT NULL Item Number
44 FT_ITEM_GUID9 Character(36) VARCHAR2(36) NOT NULL Item Number
45 FT_ITEM_GUID10 Character(36) VARCHAR2(36) NOT NULL Item Number
46 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
47 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

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

Default Value: N

49 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
50 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key
51 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.
52 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.
53 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.
54 JPM_JP_QUAL_SET Character(12) VARCHAR2(12) NOT NULL 1st Instance Qualifier Set Name for a JPM Profile Item
55 JPM_JP_QUAL_SET2 Character(12) VARCHAR2(12) NOT NULL 2nd Instance Qualifier Set Name for a JPM Profile Item