0032121: Some computed columns should not be computed

Description

Some computed columns should be reviewed and updated in case they could be a normal column instead of a computed one:

- processed_logic column in S_TimeExpense table:
select processed from S_TimeExpense TE where TE.S_TimeExpense_id=S_TimeExpense_id

- closedStat column in MA_WorkRequirement table:
select closed from dual

- date_end column in OBRE_Reservation table:
(select end_time from obre_reservation r where r.obre_reservation_id = obre_reservation_id)

- time_end in OBRE_Reservation table:
(select to_char(end_time, 'HH12:MI:SS') from obre_reservation r where r.obre_reservation_id = obre_reservation_id)

- date_start in OBRE_Reservation table:
(select start_time from obre_reservation r where r.obre_reservation_id = obre_reservation_id)

- time_start in OBRE_Reservation table:
(select to_char(start_time, 'HH12:MI:SS') from obre_reservation r where r.obre_reservation_id = obre_reservation_id)

Also some sqllogic of them could be improved:

- lastreconciliation column in FIN_Financial_Account table:
(select max(fr.dateto) from fin_financial_account ff , fin_reconciliation fr where ff.fin_financial_account_id=fr.fin_financial_account_id and ff.fin_financial_account_id=fin_financial_account_id)

Steps To Reproduce

N/A

Issue History
Date Modified	Username	Field	Change
2016-02-04 11:29	aferraz	New Issue
2016-02-04 11:29	aferraz	Assigned To	=> Triage Finance
2016-02-04 11:29	aferraz	Modules	=> Core
2016-02-04 11:29	aferraz	Triggers an Emergency Pack	=> No

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.