FT_TP_PROFILE(SQL Table) |
Index Back |
---|---|
Extract RecordExtract 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. |