OI_CF1_TFLT_VW

(SQL View)
 Index Back

OTBI: Flatten Tree for CF1

This table contains distinct OTBI: Flatten Tree Name for ChartField1 ChartField

SELECT A.SETID ,%Sql(CHARTFIELD1,A.) ,A.SETID_TREE ,C.BUSINESS_UNIT ,A.FIELD_DESC ,A.TREE_NAME_OTBI ,B.TREE_NAME ,B.TREE_EFFDT ,B.TREE_INEFFDT ,CASE WHEN A.TNODE1 = ' ' THEN NULL ELSE A.TNODE1 END ,CASE WHEN A.TNODE1_DESC = ' ' THEN NULL ELSE A.TNODE1_DESC END ,CASE WHEN A.TNODE2 = ' ' THEN NULL ELSE A.TNODE2 END ,CASE WHEN A.TNODE2_DESC = ' ' THEN NULL ELSE A.TNODE2_DESC END ,CASE WHEN A.TNODE3 = ' ' THEN NULL ELSE A.TNODE3 END ,CASE WHEN A.TNODE3_DESC = ' ' THEN NULL ELSE A.TNODE3_DESC END ,CASE WHEN A.TNODE4 = ' ' THEN NULL ELSE A.TNODE4 END ,CASE WHEN A.TNODE4_DESC = ' ' THEN NULL ELSE A.TNODE4_DESC END ,CASE WHEN A.TNODE5 = ' ' THEN NULL ELSE A.TNODE5 END ,CASE WHEN A.TNODE5_DESC = ' ' THEN NULL ELSE A.TNODE5_DESC END ,CASE WHEN A.TNODE6 = ' ' THEN NULL ELSE A.TNODE6 END ,CASE WHEN A.TNODE6_DESC = ' ' THEN NULL ELSE A.TNODE6_DESC END ,CASE WHEN A.TNODE7 = ' ' THEN NULL ELSE A.TNODE7 END ,CASE WHEN A.TNODE7_DESC = ' ' THEN NULL ELSE A.TNODE7_DESC END ,CASE WHEN A.TNODE8 = ' ' THEN NULL ELSE A.TNODE8 END ,CASE WHEN A.TNODE8_DESC = ' ' THEN NULL ELSE A.TNODE8_DESC END ,CASE WHEN A.TNODE9 = ' ' THEN NULL ELSE A.TNODE9 END ,CASE WHEN A.TNODE9_DESC = ' ' THEN NULL ELSE A.TNODE9_DESC END ,CASE WHEN A.TNODE10 = ' ' THEN NULL ELSE A.TNODE10 END ,CASE WHEN A.TNODE10_DESC = ' ' THEN NULL ELSE A.TNODE10_DESC END ,CASE WHEN A.TNODE11 = ' ' THEN NULL ELSE A.TNODE11 END ,CASE WHEN A.TNODE11_DESC = ' ' THEN NULL ELSE A.TNODE11_DESC END ,CASE WHEN A.TNODE12 = ' ' THEN NULL ELSE A.TNODE12 END ,CASE WHEN A.TNODE12_DESC = ' ' THEN NULL ELSE A.TNODE12_DESC END ,CASE WHEN A.TNODE13 = ' ' THEN NULL ELSE A.TNODE13 END ,CASE WHEN A.TNODE13_DESC = ' ' THEN NULL ELSE A.TNODE13_DESC END ,CASE WHEN A.TNODE14 = ' ' THEN NULL ELSE A.TNODE14 END ,CASE WHEN A.TNODE14_DESC = ' ' THEN NULL ELSE A.TNODE14_DESC END ,CASE WHEN A.TNODE15 = ' ' THEN NULL ELSE A.TNODE15 END ,CASE WHEN A.TNODE15_DESC = ' ' THEN NULL ELSE A.TNODE15_DESC END FROM %Table(OI_TFLT_CF1) A , %Table(OI_TFLT_LOG) B ,%Table(OI_BUTREE_MAP) C ,%Table(FS_CF_TEMPLATE) D WHERE D.ORIG_CF_NAME='CHARTFIELD1' AND B.FIELDNAME=D.FIELDNAME AND A.SETID_TREE = B.SETID AND A.TREE_NAME = B.TREE_NAME AND A.TREE_EFFDT = B.TREE_EFFDT AND A.SETID_TREE = C.SETID AND A.TREE_NAME = C.TREE_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
3 SETID_TREE Character(5) VARCHAR2(5) NOT NULL SetID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 FIELD_DESC Character(30) VARCHAR2(30) NOT NULL Field Description
6 TREE_NAME_OTBI Character(30) VARCHAR2(30) NOT NULL Tree Name
7 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
8 EFF_ST_DT Date(10) DATE Effective Start Date
9 EFF_END_DT Date(10) DATE Effective End Date
10 TNODE1 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
11 TNODE1_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
12 TNODE2 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
13 TNODE2_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
14 TNODE3 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
15 TNODE3_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
16 TNODE4 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
17 TNODE4_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
18 TNODE5 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
19 TNODE5_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
20 TNODE6 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
21 TNODE6_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
22 TNODE7 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
23 TNODE7_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
24 TNODE8 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
25 TNODE8_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
26 TNODE9 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
27 TNODE9_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
28 TNODE10 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
29 TNODE10_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
30 TNODE11 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
31 TNODE11_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
32 TNODE12 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
33 TNODE12_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
34 TNODE13 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
35 TNODE13_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
36 TNODE14 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
37 TNODE14_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description
38 TNODE15 Character(20) VARCHAR2(20) NOT NULL OTBI: Node name
39 TNODE15_DESC Character(30) VARCHAR2(30) NOT NULL OTBI: Tree Node Description