ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1

Derived Tables Toward Poppy Release
2
StatusIssuePRDerived TableLDP version statusMetadb version statusNotesWhoReviewers
3
merged#744#745po_lines_fund_distributiondonenot neededpo_line_id, fundDistribution values from data array, use finance_funds table to get derived connections from funds to fiscal years to show one fund id over several fiscal years; see issue StefanVandana, Axel
4
In Progress#501, #760feesfines_accounts_actionsneed to change date-related fields to be extracted as timestamptz instead of text; several additional changes needed that are documented in the issueArthur
5
not started791finance_invoice_transactionsadd expense class name and code as well as the external account number extension from the transactions table and the expense class tableStefan
6
not started797
finance_transactions_purchase_orders
add expense classSharon
7
In Progress798notes for orders
metadb query; may need help with LDP version
(from Nassib) It would be helpful to have a derived table that extracts notes for orders, like we do for other tables, but here the order IDs are under the "links" field.Arthur
8
not started799po_instanceadd connections to holdings and itemsNatalya
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100