FT_TP_PROFILE

#	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.