FT_FND_TREEV_TL

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
4 EFFDT Date(10) DATE Effective Date
5 FT_TREE_STRUCT_CD Character(30) VARCHAR2(30) NOT NULL Tree Structure Code
6 FT_TREE_CODE Character(30) VARCHAR2(30) NOT NULL Tree Code
7 FT_SET_ID_GUID Character(36) VARCHAR2(36) NOT NULL Set ID GUID
8 FT_TREE_VER_GUID Character(36) VARCHAR2(36) NOT NULL Tree Version GUID
9 FT_TREE_VER_NAME Character(80) VARCHAR2(80) NOT NULL Tree Version Name
10 FT_DESCRIPTION Character(240) VARCHAR2(240) NOT NULL Description
11 FT_VERSION_COMMENT Long Character(4000) CLOB Version Comment
12 FT_LANGUAGE Character(4) VARCHAR2(4) NOT NULL Language
13 FT_SRC_LANGUAGE Character(4) VARCHAR2(4) NOT NULL Source Language
14 FT_CREATED_BY Character(64) VARCHAR2(64) NOT NULL Created By
15 FT_CREATION_DATE Date(10) DATE Creation Date
16 FT_LAST_UPDATED_BY Character(64) VARCHAR2(64) NOT NULL Last Updated By
17 FT_LAST_UPD_DATE Date(10) DATE Last Updated Date
18 FT_LAST_UPD_LOGIN Character(32) VARCHAR2(32) NOT NULL Last Updated Login
19 FT_ENTERPRISE_ID Number(18,0) DECIMAL(18) NOT NULL Enterprise ID
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