FT_EL_ENT_IN

(SQL Table)
 Index Back

FTM Element Entries Inbound

Fusion Structure VO Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FT_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID
2 FT_EL_ENTR_GUID Character(36) VARCHAR2(36) NOT NULL Element Entry GUID
3 FT_EFF_START_DATE Date(10) DATE Effective Start Date
4 FT_EFF_END_DATE Date(10) DATE Effective End Date
5 FT_EL_TYPE_GUID Character(36) VARCHAR2(36) NOT NULL Element Type Guid
6 FT_ENTRY_TYPE Character(30) VARCHAR2(30) NOT NULL Entry Type
7 FT_CREATOR_TYPE Character(30) VARCHAR2(30) NOT NULL Creator Type
8 FT_PERSON_GUID Character(36) VARCHAR2(36) NOT NULL Person GUID
9 FT_CREATOR_ID Character(18) VARCHAR2(18) NOT NULL Creator ID
10 FT_BATCH_ID Character(18) VARCHAR2(18) NOT NULL Batch ID
11 FT_REASON Character(30) VARCHAR2(30) NOT NULL Reason
12 FT_TRGT_ENTR_ID Character(18) VARCHAR2(18) NOT NULL Target Entry ID
13 FT_SUBPRIORITY Character(9) VARCHAR2(9) NOT NULL Subpriority
14 FT_EARNED_DATE Date(10) DATE Date Earned
15 FT_BAL_ADJ_CST_FLG Character(30) VARCHAR2(30) NOT NULL Balance Adjusment Flag
16 FT_ASSIGNMENT_GUID Character(36) VARCHAR2(36) NOT NULL Assignment ID
17 FT_ATTR_CATEGORY Character(30) VARCHAR2(30) NOT NULL Attribute Category
18 FT_ATTRIBUTE1 Character(1) VARCHAR2(1) NOT NULL Attribute
19 FT_ATTRIBUTE2 Character(1) VARCHAR2(1) NOT NULL Attribute
20 FT_ATTRIBUTE3 Character(1) VARCHAR2(1) NOT NULL Attribute
21 FT_ATTRIBUTE4 Character(1) VARCHAR2(1) NOT NULL Attribute
22 FT_ATTRIBUTE5 Character(1) VARCHAR2(1) NOT NULL Attribute
23 FT_ATTRIBUTE6 Character(1) VARCHAR2(1) NOT NULL Attribute
24 FT_ATTRIBUTE7 Character(1) VARCHAR2(1) NOT NULL Attribute
25 FT_ATTRIBUTE8 Character(1) VARCHAR2(1) NOT NULL Attribute
26 FT_ATTRIBUTE9 Character(1) VARCHAR2(1) NOT NULL Attribute
27 FT_ATTRIBUTE10 Character(1) VARCHAR2(1) NOT NULL Attribute
28 FT_ATTRIBUTE11 Character(1) VARCHAR2(1) NOT NULL Attribute
29 FT_ATTRIBUTE12 Character(1) VARCHAR2(1) NOT NULL Attribute
30 FT_ATTRIBUTE13 Character(1) VARCHAR2(1) NOT NULL Attribute
31 FT_ATTRIBUTE14 Character(1) VARCHAR2(1) NOT NULL Attribute
32 FT_ATTRIBUTE15 Character(1) VARCHAR2(1) NOT NULL Attribute
33 FT_ATTRIBUTE16 Character(1) VARCHAR2(1) NOT NULL Attribute
34 FT_ATTRIBUTE17 Character(1) VARCHAR2(1) NOT NULL Attribute
35 FT_ATTRIBUTE18 Character(1) VARCHAR2(1) NOT NULL Attribute
36 FT_ATTRIBUTE19 Character(1) VARCHAR2(1) NOT NULL Attribute
37 FT_ATTRIBUTE20 Character(1) VARCHAR2(1) NOT NULL Attribute
38 FT_INFO_CATEGORY Character(30) VARCHAR2(30) NOT NULL Attribute Category
39 FT_ENTRY_INFO_1 Character(1) VARCHAR2(1) NOT NULL Entry Information
40 FT_ENTRY_INFO_2 Character(1) VARCHAR2(1) NOT NULL Entry Information
41 FT_ENTRY_INFO_3 Character(1) VARCHAR2(1) NOT NULL Entry Information
42 FT_ENTRY_INFO_4 Character(1) VARCHAR2(1) NOT NULL Entry Information
43 FT_ENTRY_INFO_5 Character(1) VARCHAR2(1) NOT NULL Entry Information
44 FT_ENTRY_INFO_6 Character(1) VARCHAR2(1) NOT NULL Entry Information
45 FT_ENTRY_INFO_7 Character(1) VARCHAR2(1) NOT NULL Entry Information
46 FT_ENTRY_INFO_8 Character(1) VARCHAR2(1) NOT NULL Entry Information
47 FT_ENTRY_INFO_9 Character(1) VARCHAR2(1) NOT NULL Entry Information
48 FT_ENTRY_INFO_10 Character(1) VARCHAR2(1) NOT NULL Entry Information
49 FT_ENTRY_INFO_11 Character(1) VARCHAR2(1) NOT NULL Entry Information
50 FT_ENTRY_INFO_12 Character(1) VARCHAR2(1) NOT NULL Entry Information
51 FT_ENTRY_INFO_13 Character(1) VARCHAR2(1) NOT NULL Entry Information
52 FT_ENTRY_INFO_14 Character(1) VARCHAR2(1) NOT NULL Entry Information
53 FT_ENTRY_INFO_15 Character(1) VARCHAR2(1) NOT NULL Entry Information
54 FT_ENTRY_INFO_16 Character(1) VARCHAR2(1) NOT NULL Entry Information
55 FT_ENTRY_INFO_17 Character(1) VARCHAR2(1) NOT NULL Entry Information
56 FT_ENTRY_INFO_18 Character(1) VARCHAR2(1) NOT NULL Entry Information
57 FT_ENTRY_INFO_19 Character(1) VARCHAR2(1) NOT NULL Entry Information
58 FT_ENTRY_INFO_20 Character(1) VARCHAR2(1) NOT NULL Entry Information
59 FT_ENTRY_INFO_21 Character(1) VARCHAR2(1) NOT NULL Entry Information
60 FT_ENTRY_INFO_22 Character(1) VARCHAR2(1) NOT NULL Entry Information
61 FT_ENTRY_INFO_23 Character(1) VARCHAR2(1) NOT NULL Entry Information
62 FT_ENTRY_INFO_24 Character(1) VARCHAR2(1) NOT NULL Entry Information
63 FT_ENTRY_INFO_25 Character(1) VARCHAR2(1) NOT NULL Entry Information
64 FT_ENTRY_INFO_27 Character(1) VARCHAR2(1) NOT NULL Entry Information
65 FT_ENTRY_INFO_28 Character(1) VARCHAR2(1) NOT NULL Entry Information
66 FT_ENTRY_INFO_29 Character(1) VARCHAR2(1) NOT NULL Entry Information
67 FT_ENTRY_INFO_30 Character(1) VARCHAR2(1) NOT NULL Entry Information
68 FT_ENTRY_INFO_26 Character(1) VARCHAR2(1) NOT NULL Entry Information
69 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
70 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

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

Default Value: N

72 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
73 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key