ETL FORM_DATI · Tagetik Application

Routines 1source
Sources: MAP_MAPPATURA, MAP_IMPORT

Code	Description	Extractions	Transformations	Loadings
`FORM_TR_020`	Project Addition Creation & Mapping	1	1	4

ETL Dimensions 127source
Sources: MAP_DIMENSIONE

Semantic mapping of staging fields (CAMPO1…CAMPO130) to functional meanings within this domain. Dimension codes appear in operation input/output and lookup table definitions.

Code Description Acronym Type Identity Usages

1 COD_SCENARIO SCE S 02 4 usages

Type	Field role	Code
Transf. Routine — Transformation	SQL body (CAMPO)	FORM_TR_020 #10
Src.fmt Source Format	Input field	FORM_DATI
Output Output Target	→ COD_SCENARIO	010 015

2 COD_PERIODO PER S 03 2 usages

Type	Field role	Code
Transf. Routine — Transformation	SQL body (CAMPO)	FORM_TR_020 #10
Src.fmt Source Format	Input field	FORM_DATI

3 COD_AZIENDA AZI S 01 4 usages

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI
Output Output Target	→ ATTRIBUTO1	001
Output Output Target	→ COD_AZIENDA	010 015

4 COD_CONTO CON S — 2 usages

Type	Field role	Code
Transf. Routine — Transformation	SQL body (CAMPO)	FORM_TR_020 #10
Src.fmt Source Format	Input field	FORM_DATI

5 COD_DEST1 DEST1 S — 4 usages

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI
Output Output Target	→ ATTRIBUTO2	001
Output Output Target	→ COD_DEST1	010 015

6 COD_DEST2 DEST2 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

7 COD_DEST3 DEST3 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

8 COD_DEST4 DEST4 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

9 COD_DEST5 DEST5 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

10 COD_CATEGORIA CAT S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

11 COD_VALUTA VAL S 11 6 usages

Type	Field role	Code
Transf. Routine — Transformation	SQL body (CAMPO)	FORM_TR_020 #10
Src.fmt Source Format	Input field	FORM_DATI
Output Output Target	→ COD_VALUTA	010 015
Output Output Target	→ COD_VALUTA_ORIGINARIA	010 015

12 COD_VALUTA_ORIGINARIA VALORIG S 12 2 usages

Type	Field role	Code
Transf. Routine — Transformation	SQL body (CAMPO)	FORM_TR_020 #10
Src.fmt Source Format	Input field	FORM_DATI

13 IMPORTO IMP N — 2 usages

Type	Field role	Code
Transf. Routine — Transformation	SQL body (CAMPO)	FORM_TR_020 #10
Src.fmt Source Format	Input field	FORM_DATI

14 IMPORTO_VALUTA_ORIGINARIA IMPORIG N — 2 usages

Type	Field role	Code
Transf. Routine — Transformation	Output dim	FORM_TR_020 #10
Src.fmt Source Format	Input field	FORM_DATI

15 DIM_VERT DVER S — —

16 IMPORTO_VERT IVER N — —

17 IMPORTO_MENS IMEN N — —

18 IMPORTO_PROG IPRO N — —

22 COD_AZI_CTP AZI_CTP S 01 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

23 COD_DEST2_CTP DEST2_CTP S 06 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

24 DATA_1 DATA1 D — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

25 DATA_2 DATA2 D — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

26 DATA_3 DATA3 D — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

27 DATA_4 DATA4 D — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

28 DATA_5 DATA5 D — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

29 IMPORTO_01 IMP01 N — 3 usages

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI
Output Output Target	→ IMPORTO	010
Output Output Target	→ IMPORTO_VALUTA_ORIGINARIA	010

30 IMPORTO_02 IMP02 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

31 IMPORTO_03 IMP03 N — 3 usages

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI
Output Output Target	→ IMPORTO	015
Output Output Target	→ IMPORTO_VALUTA_ORIGINARIA	015

32 IMPORTO_04 IMP04 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

33 IMPORTO_05 IMP05 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

34 IMPORTO_06 IMP06 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

35 IMPORTO_07 IMP07 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

36 IMPORTO_08 IMP08 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

37 IMPORTO_09 IMP09 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

38 IMPORTO_10 IMP10 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

39 IMPORTO_11 IMP11 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

40 IMPORTO_12 IMP12 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

41 IMPORTO_13 IMP13 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

42 IMPORTO_14 IMP14 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

43 IMPORTO_15 IMP15 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

44 IMPORTO_16 IMP16 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

45 IMPORTO_17 IMP17 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

46 IMPORTO_18 IMP18 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

47 IMPORTO_19 IMP19 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

48 IMPORTO_20 IMP20 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

49 IMPORTO_21 IMP21 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

50 IMPORTO_22 IMP22 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

51 IMPORTO_23 IMP23 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

52 IMPORTO_24 IMP24 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

53 IMPORTO_25 IMP25 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

54 IMPORTO_26 IMP26 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

55 IMPORTO_27 IMP27 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

56 IMPORTO_28 IMP28 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

57 IMPORTO_29 IMP29 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

58 IMPORTO_30 IMP30 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

59 IMPORTO_31 IMP31 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

60 IMPORTO_32 IMP32 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

61 IMPORTO_33 IMP33 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

62 IMPORTO_34 IMP34 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

63 IMPORTO_35 IMP35 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

64 IMPORTO_36 IMP36 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

65 IMPORTO_37 IMP37 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

66 IMPORTO_38 IMP38 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

67 IMPORTO_39 IMP39 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

68 IMPORTO_40 IMP40 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

69 IMPORTO_41 IMP41 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

70 IMPORTO_42 IMP42 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

71 IMPORTO_43 IMP43 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

72 IMPORTO_44 IMP44 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

73 IMPORTO_45 IMP45 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

74 IMPORTO_46 IMP46 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

75 IMPORTO_47 IMP47 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

76 IMPORTO_48 IMP48 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

77 IMPORTO_49 IMP49 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

78 IMPORTO_50 IMP50 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

79 IMPORTO_51 IMP51 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

80 IMPORTO_52 IMP52 N — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

81 TESTO_01 TEXT01 S — 5 usages

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI
Output Output Target	→ COD_DEST5	001 005 010 015

82 TESTO_02 TEXT02 S — 3 usages

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI
Output Output Target	→ DESC_DEST50	001
Output Output Target	→ DESC_DEST51	001

83 TESTO_03 TEXT03 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

84 TESTO_04 TEXT04 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

85 TESTO_05 TEXT05 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

86 TESTO_06 TEXT06 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

87 TESTO_07 TEXT07 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

88 TESTO_08 TEXT08 S — 2 usages

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI
Output Output Target	→ COD_DEST5_GERARCHIA	005

89 TESTO_09 TEXT09 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

90 TESTO_10 TEXT10 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

91 TESTO_11 TEXT11 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

92 TESTO_12 TEXT12 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

93 TESTO_13 TEXT13 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

94 TESTO_14 TEXT14 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

95 TESTO_15 TEXT15 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

96 TESTO_16 TEXT16 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

97 TESTO_17 TEXT17 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

98 TESTO_18 TEXT18 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

99 TESTO_19 TEXT19 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

100 TESTO_20 TEXT20 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

101 TESTO_21 TEXT21 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

102 TESTO_22 TEXT22 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

103 TESTO_23 TEXT23 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

104 TESTO_24 TEXT24 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

105 TESTO_25 TEXT25 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

106 TESTO_26 TEXT26 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

107 TESTO_27 TEXT27 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

108 TESTO_28 TEXT28 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

109 TESTO_29 TEXT29 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

110 TESTO_30 TEXT30 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

111 TESTO_31 TEXT31 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

112 TESTO_32 TEXT32 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

113 TESTO_33 TEXT33 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

114 TESTO_34 TEXT34 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

115 TESTO_35 TEXT35 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

116 TESTO_36 TEXT36 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

117 TESTO_37 TEXT37 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

118 TESTO_38 TEXT38 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

119 TESTO_39 TEXT39 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

120 TESTO_40 TEXT40 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

121 TESTO_41 TEXT41 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

122 TESTO_42 TEXT42 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

123 TESTO_43 TEXT43 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

124 TESTO_44 TEXT44 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

125 TESTO_45 TEXT45 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

126 TESTO_46 TEXT46 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

127 TESTO_47 TEXT47 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

128 TESTO_48 TEXT48 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

129 TESTO_49 TEXT49 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

130 TESTO_50 TEXT50 S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	FORM_DATI

Parameters 4source
Sources: MAP_PARAMETRO

Domain-level parameters available as {P_xxx} tokens in filter expressions.

Code	Description	Type	Multi-select	Related dimension	Source detail	Usages
`010`	Scenario	From imported data	Yes	`1` COD_SCENARIO	From imported data	—
`020`	Account	From imported data	Yes	`4` COD_CONTO	From imported data	—
`030`	Entity	From imported data	Yes	`3` COD_AZIENDA	From imported data	—
`040`	Cost Center	From imported data	Yes	`5` COD_DEST1	From imported data	—

Source Formats 1source
Sources: MAP_FORMATO_INPUT, MAP_FORMATO_INPUT_DIMENSIONE

Input data formats read by extractions in this domain.

Code Description Type Fields

FORM_DATI Extraction from Project Additiion Form Database 123

Used by routines FORM_TR_020 Project Addition Creation & Mapping

DB typeQ

SourcesFORM_DATI

Database query

SELECT * FROM FORM_DATI WHERE COD_PROSPETTO = 'TR_020'

Field mapping

#	Dimension	Database column
1	COD_SCENARIO	`COD_SCENARIO`
2	COD_PERIODO	`COD_PERIODO`
3	COD_AZIENDA	`COD_AZIENDA`
4	COD_CONTO	`COD_CONTO`
5	COD_DEST1	`COD_DEST1`
6	COD_DEST2	`COD_DEST2`
7	COD_DEST3	`COD_DEST3`
8	COD_DEST4	`COD_DEST4`
9	COD_DEST5	`COD_DEST5`
10	COD_CATEGORIA	`COD_CATEGORIA`
11	COD_VALUTA	`COD_VALUTA`
12	COD_VALUTA_ORIGINARIA	`COD_VALUTA_ORIGINARIA`
13	IMPORTO	`IMPORTO`
14	IMPORTO_VALUTA_ORIGINARIA	`IMPORTO_VALUTA_ORIGINARIA`
22	COD_AZI_CTP	`COD_AZI_CTP`
23	COD_DEST2_CTP	`COD_DEST2_CTP`
24	DATA_1	`DATA_1`
25	DATA_2	`DATA_2`
26	DATA_3	`DATA_3`
27	DATA_4	`DATA_4`
28	DATA_5	`DATA_5`
29	IMPORTO_01	`IMPORTO_1`
30	IMPORTO_02	`IMPORTO_2`
31	IMPORTO_03	`IMPORTO_3`
32	IMPORTO_04	`IMPORTO_4`
33	IMPORTO_05	`IMPORTO_5`
34	IMPORTO_06	`IMPORTO_6`
35	IMPORTO_07	`IMPORTO_7`
36	IMPORTO_08	`IMPORTO_8`
37	IMPORTO_09	`IMPORTO_9`
38	IMPORTO_10	`IMPORTO_10`
39	IMPORTO_11	`IMPORTO_11`
40	IMPORTO_12	`IMPORTO_12`
41	IMPORTO_13	`IMPORTO_13`
42	IMPORTO_14	`IMPORTO_14`
43	IMPORTO_15	`IMPORTO_15`
44	IMPORTO_16	`IMPORTO_16`
45	IMPORTO_17	`IMPORTO_17`
46	IMPORTO_18	`IMPORTO_18`
47	IMPORTO_19	`IMPORTO_19`
48	IMPORTO_20	`IMPORTO_20`
49	IMPORTO_21	`IMPORTO_21`
50	IMPORTO_22	`IMPORTO_22`
51	IMPORTO_23	`IMPORTO_23`
52	IMPORTO_24	`IMPORTO_24`
53	IMPORTO_25	`IMPORTO_25`
54	IMPORTO_26	`IMPORTO_26`
55	IMPORTO_27	`IMPORTO_27`
56	IMPORTO_28	`IMPORTO_28`
57	IMPORTO_29	`IMPORTO_29`
58	IMPORTO_30	`IMPORTO_30`
59	IMPORTO_31	`IMPORTO_31`
60	IMPORTO_32	`IMPORTO_32`
61	IMPORTO_33	`IMPORTO_33`
62	IMPORTO_34	`IMPORTO_34`
63	IMPORTO_35	`IMPORTO_35`
64	IMPORTO_36	`IMPORTO_36`
65	IMPORTO_37	`IMPORTO_37`
66	IMPORTO_38	`IMPORTO_38`
67	IMPORTO_39	`IMPORTO_39`
68	IMPORTO_40	`IMPORTO_40`
69	IMPORTO_41	`IMPORTO_41`
70	IMPORTO_42	`IMPORTO_42`
71	IMPORTO_43	`IMPORTO_43`
72	IMPORTO_44	`IMPORTO_44`
73	IMPORTO_45	`IMPORTO_45`
74	IMPORTO_46	`IMPORTO_46`
75	IMPORTO_47	`IMPORTO_47`
76	IMPORTO_48	`IMPORTO_48`
77	IMPORTO_49	`IMPORTO_49`
78	IMPORTO_50	`IMPORTO_50`
79	IMPORTO_51	`IMPORTO_51`
80	IMPORTO_52	`IMPORTO_52`
81	TESTO_01	`TESTO_1`
82	TESTO_02	`TESTO_2`
83	TESTO_03	`TESTO_3`
84	TESTO_04	`TESTO_4`
85	TESTO_05	`TESTO_5`
86	TESTO_06	`TESTO_6`
87	TESTO_07	`TESTO_7`
88	TESTO_08	`TESTO_8`
89	TESTO_09	`TESTO_9`
90	TESTO_10	`TESTO_10`
91	TESTO_11	`TESTO_11`
92	TESTO_12	`TESTO_12`
93	TESTO_13	`TESTO_13`
94	TESTO_14	`TESTO_14`
95	TESTO_15	`TESTO_15`
96	TESTO_16	`TESTO_16`
97	TESTO_17	`TESTO_17`
98	TESTO_18	`TESTO_18`
99	TESTO_19	`TESTO_19`
100	TESTO_20	`TESTO_20`
101	TESTO_21	`TESTO_21`
102	TESTO_22	`TESTO_22`
103	TESTO_23	`TESTO_23`
104	TESTO_24	`TESTO_24`
105	TESTO_25	`TESTO_25`
106	TESTO_26	`TESTO_26`
107	TESTO_27	`TESTO_27`
108	TESTO_28	`TESTO_28`
109	TESTO_29	`TESTO_29`
110	TESTO_30	`TESTO_30`
111	TESTO_31	`TESTO_31`
112	TESTO_32	`TESTO_32`
113	TESTO_33	`TESTO_33`
114	TESTO_34	`TESTO_34`
115	TESTO_35	`TESTO_35`
116	TESTO_36	`TESTO_36`
117	TESTO_37	`TESTO_37`
118	TESTO_38	`TESTO_38`
119	TESTO_39	`TESTO_39`
120	TESTO_40	`TESTO_40`
121	TESTO_41	`TESTO_41`
122	TESTO_42	`TESTO_42`
123	TESTO_43	`TESTO_43`
124	TESTO_44	`TESTO_44`
125	TESTO_45	`TESTO_45`
126	TESTO_46	`TESTO_46`
127	TESTO_47	`TESTO_47`
128	TESTO_48	`TESTO_48`
129	TESTO_49	`TESTO_49`
130	TESTO_50	`TESTO_50`

Output Targets — Tagetik 4source
Sources: MAP_EASY_OUTPUT, MAP_EASY_OUTPUT_DIMENSIONE

Tagetik tables written by loadings in this domain.

Code Description Target table Fields

001 Project Code + Description Loading DEST5 5

Written by routines FORM_TR_020 Project Addition Creation & Mapping

Target column	Update	Source — dimension or value	Aggregation
`ATTRIBUTO1`	By dimension	`3` COD_AZIENDA	Group by
`ATTRIBUTO2`	By dimension	`5` COD_DEST1	Group by
`COD_DEST5`	By dimension	`81` TESTO_01	Group by
`DESC_DEST50`	By dimension	`82` TESTO_02	Group by
`DESC_DEST51`	By dimension	`82` TESTO_02	Group by

005 Update Hierarchy DEST5_GERARCHIA_ABBI 3

Written by routines FORM_TR_020 Project Addition Creation & Mapping

Target column	Update	Source — dimension or value	Aggregation
`COD_DEST5`	By dimension	`81` TESTO_01	Group by
`COD_DEST5_GERARCHIA`	By dimension	`88` TESTO_08	Group by
`COD_DEST5_ELEGER`	By value	`ALL`	Group by

010 Update Priority Score Values DATI_SALDI_LORDI 14

Written by routines FORM_TR_020 Project Addition Creation & Mapping

Target column	Update	Source — dimension or value	Aggregation
`COD_SCENARIO`	By dimension	`1` COD_SCENARIO	Group by
`COD_AZIENDA`	By dimension	`3` COD_AZIENDA	Group by
`COD_DEST1`	By dimension	`5` COD_DEST1	Group by
`COD_VALUTA`	By dimension	`11` COD_VALUTA	Group by
`COD_VALUTA_ORIGINARIA`	By dimension	`11` COD_VALUTA	Group by
`IMPORTO`	By dimension	`29` IMPORTO_01	AVG
`IMPORTO_VALUTA_ORIGINARIA`	By dimension	`29` IMPORTO_01	AVG
`COD_DEST5`	By dimension	`81` TESTO_01	Group by
`COD_CATEGORIA`	By value	`010`	Group by
`COD_CONTO`	By value	`ST_300`	Group by
`COD_DEST2`	By value	`PD_500`	Group by
`COD_DEST3`	By value	`CM_500`	Group by
`COD_DEST4`	By value	`EE_500`	Group by
`COD_PERIODO`	By value	`12`	Group by

015 Update Impact Score Values DATI_SALDI_LORDI 14

Written by routines FORM_TR_020 Project Addition Creation & Mapping

Target column	Update	Source — dimension or value	Aggregation
`COD_SCENARIO`	By dimension	`1` COD_SCENARIO	Group by
`COD_AZIENDA`	By dimension	`3` COD_AZIENDA	Group by
`COD_DEST1`	By dimension	`5` COD_DEST1	Group by
`COD_VALUTA`	By dimension	`11` COD_VALUTA	Group by
`COD_VALUTA_ORIGINARIA`	By dimension	`11` COD_VALUTA	Group by
`IMPORTO`	By dimension	`31` IMPORTO_03	AVG
`IMPORTO_VALUTA_ORIGINARIA`	By dimension	`31` IMPORTO_03	AVG
`COD_DEST5`	By dimension	`81` TESTO_01	Group by
`COD_CATEGORIA`	By value	`010`	Group by
`COD_CONTO`	By value	`ST_310`	Group by
`COD_DEST2`	By value	`PD_500`	Group by
`COD_DEST3`	By value	`CM_500`	Group by
`COD_DEST4`	By value	`EE_500`	Group by
`COD_PERIODO`	By value	`12`	Group by

Routine	Loading	Table / Object
`FORM_TR_020`Project Addition Creation & Mapping	`010`Update Priority Score Values	`DATI_SALDI_LORDI`
`FORM_TR_020`Project Addition Creation & Mapping	`015`Update Impact Score Values	`DATI_SALDI_LORDI`

Routine	Loading	Table / Object
`FORM_TR_020`Project Addition Creation & Mapping	`001`Project Code + Description Loading	`DEST5`
`FORM_TR_020`Project Addition Creation & Mapping	`005`Update Hierarchy	`DEST5_GERARCHIA_ABBI`

FORM_DATI

Routines 1sourceSources: MAP_MAPPATURA, MAP_IMPORT

ETL Dimensions 127sourceSources: MAP_DIMENSIONE

Parameters 4sourceSources: MAP_PARAMETRO

Source Formats 1sourceSources: MAP_FORMATO_INPUT, MAP_FORMATO_INPUT_DIMENSIONE

Output Targets — Tagetik 4sourceSources: MAP_EASY_OUTPUT, MAP_EASY_OUTPUT_DIMENSIONE

`FORM_DATI`

Routines 1source
Sources: MAP_MAPPATURA, MAP_IMPORT

ETL Dimensions 127source
Sources: MAP_DIMENSIONE

Parameters 4source
Sources: MAP_PARAMETRO

Source Formats 1source
Sources: MAP_FORMATO_INPUT, MAP_FORMATO_INPUT_DIMENSIONE

Output Targets — Tagetik 4source
Sources: MAP_EASY_OUTPUT, MAP_EASY_OUTPUT_DIMENSIONE