FT_FND_LABEL_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

Default Value: %date

5 TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number
6 FT_TREE_STRUCT_CD Character(30) VARCHAR2(30) NOT NULL Tree Structure Code
7 FT_DATA_SOURCE_ID Character(32) VARCHAR2(32) NOT NULL Data Source ID
8 FT_LABEL_ID_GUID Character(36) VARCHAR2(36) NOT NULL Label ID GUID
9 FT_LABEL_NAME Character(80) VARCHAR2(80) NOT NULL Label Name
10 FT_DESCRIPTION Character(240) VARCHAR2(240) NOT NULL Description
11 FT_LANGUAGE Character(4) VARCHAR2(4) NOT NULL Language
12 FT_SRC_LANGUAGE Character(4) VARCHAR2(4) NOT NULL Source Language
13 FT_CREATED_BY Character(64) VARCHAR2(64) NOT NULL Created By
14 FT_CREATION_DATE Date(10) DATE Creation Date
15 FT_LAST_UPDATED_BY Character(64) VARCHAR2(64) NOT NULL Last Updated By
16 FT_LAST_UPD_DATE Date(10) DATE Last Updated Date
17 FT_LAST_UPD_LOGIN Character(32) VARCHAR2(32) NOT NULL Last Updated Login
18 FT_ENTERPRISE_ID Number(18,0) DECIMAL(18) NOT NULL Enterprise ID
19 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
20 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

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

Default Value: N

22 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
23 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key