FT_TP_PROFILE

(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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 FT_TP_GUID Character(36) VARCHAR2(36) NOT NULL TalentProfileGUID
4 FT_DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
5 FT_DESCRLONG Long Character(1325) VARCHAR2(1325) Long Description
6 FT_BUS_GROUP_GUID Character(36) VARCHAR2(36) NOT NULL Business Group ID
7 FT_TPT_GUID Character(36) VARCHAR2(36) NOT NULL TalentProfileTypeGUID
8 FT_PROFILE_CODE Character(30) VARCHAR2(30) NOT NULL Profile Code
9 FT_STATUS_CODE Character(1) VARCHAR2(1) NOT NULL Profile Status Code
10 FT_TP_USAGE_CODE Character(1) VARCHAR2(1) NOT NULL Profile Usage Code
11 FT_PERSON_GUID Character(36) VARCHAR2(36) NOT NULL Person GUID
12 FT_PARTY_GUID Character(36) VARCHAR2(36) NOT NULL Person GUID
13 FT_OWNER_PER_GUID Character(36) VARCHAR2(36) NOT NULL Person GUID
14 FT_OBJ_VER_NUM Number(9,0) DECIMAL(9) NOT NULL Object Version Number
15 FT_CREATED_BY Character(64) VARCHAR2(64) NOT NULL Created By
16 FT_CREATION_DATE Date(10) DATE Creation Date
17 FT_LAST_UPD_DATE Date(10) DATE Last Updated Date
18 FT_LAST_UPDATED_BY Character(64) VARCHAR2(64) NOT NULL Last Updated By
19 FT_LAST_UPD_LOGIN Character(32) VARCHAR2(32) NOT NULL Last Updated Login
20 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
21 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

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

Default Value: N

23 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
24 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key
25 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.