OLD VERSION

CREATE OR REPLACE VIEW INTCOMP_A1_RAMP (ID, MAGNET_NAME, MAGNET_TYPE, MAGNET_STATE, APERTURE_NUMBER, COMPONENT_TYPE, REF_CURRENT, REF_TEMPERATURE, REF_FIELD_MODULE, REF_FIELD_ANGLE, REFERENCE_RADIUS, NORMALIZATION_ORDER, NORMAL_1, SKEW_1, NORMAL_2, SKEW_2, NORMAL_3, SKEW_3, NORMAL_4, SKEW_4, NORMAL_5, SKEW_5, NORMAL_6, SKEW_6, NORMAL_7, SKEW_7, NORMAL_8, SKEW_8, NORMAL_9, SKEW_9, NORMAL_10, SKEW_10, NORMAL_11, SKEW_11, NORMAL_12, SKEW_12, NORMAL_13, SKEW_13, NORMAL_14, SKEW_14, NORMAL_15, SKEW_15, LOGIN_NAME, LOGIN_DATE, NOTES) AS
SELECT T."ID",T."MAGNET_NAME",T."MAGNET_TYPE",T."MAGNET_STATE",T."APERTURE_NUMBER",T."COMPONENT_TYPE",T."REF_CURRENT",T."REF_TEMPERATURE",T."REF_FIELD_MODULE",T."REF_FIELD_ANGLE",T."REFERENCE_RADIUS",T."NORMALIZATION_ORDER",T."NORMAL_1",T."SKEW_1",T."NORMAL_2",T."SKEW_2",T."NORMAL_3",T."SKEW_3",T."NORMAL_4",T."SKEW_4",T."NORMAL_5",T."SKEW_5",T."NORMAL_6",T."SKEW_6",T."NORMAL_7",T."SKEW_7",T."NORMAL_8",T."SKEW_8",T."NORMAL_9",T."SKEW_9",T."NORMAL_10",T."SKEW_10",T."NORMAL_11",T."SKEW_11",T."NORMAL_12",T."SKEW_12",T."NORMAL_13",T."SKEW_13",T."NORMAL_14",T."SKEW_14",T."NORMAL_15",T."SKEW_15",T."LOGIN_NAME",T."LOGIN_DATE",T."NOTES"
FROM F_INT_COMP T
WHERE T.COMPONENT_TYPE = 'ramp'
AND T.APERTURE_NUMBER = 1
AND T.MAGNET_STATE = 'cryomagnet'
--AND T.REF_CURRENT BETWEEN 760-1 AND 760+1
AND ((T.MAGNET_TYPE = 1 AND T.REF_CURRENT BETWEEN 760-1 AND 760+1)
OR (T.MAGNET_TYPE = 2 AND T.REF_CURRENT BETWEEN 760-1 AND 760+1))
--
AND T.REF_TEMPERATURE BETWEEN 1.8-0.3 AND 1.8+0.3
ORDER BY T.MAGNET_NAME, T.APERTURE_NUMBER, round(T.REF_CURRENT);

NEW VERSION

CREATE OR REPLACE VIEW INTCOMP_A1_RAMP (ID, MAGNET_NAME, MAGNET_TYPE, MAGNET_STATE, APERTURE_NUMBER, COMPONENT_TYPE, REF_CURRENT, REF_TEMPERATURE, REF_FIELD_MODULE, REF_FIELD_ANGLE, REFERENCE_RADIUS, NORMALIZATION_ORDER, NORMAL_1, SKEW_1, NORMAL_2, SKEW_2, NORMAL_3, SKEW_3, NORMAL_4, SKEW_4, NORMAL_5, SKEW_5, NORMAL_6, SKEW_6, NORMAL_7, SKEW_7, NORMAL_8, SKEW_8, NORMAL_9, SKEW_9, NORMAL_10, SKEW_10, NORMAL_11, SKEW_11, NORMAL_12, SKEW_12, NORMAL_13, SKEW_13, NORMAL_14, SKEW_14, NORMAL_15, SKEW_15, LOGIN_NAME, LOGIN_DATE, NOTES) AS
SELECT T."ID",T."MAGNET_NAME",T."MAGNET_TYPE",T."MAGNET_STATE",T."APERTURE_NUMBER",T."COMPONENT_TYPE",T."REF_CURRENT",T."REF_TEMPERATURE",T."REF_FIELD_MODULE",T."REF_FIELD_ANGLE",T."REFERENCE_RADIUS",T."NORMALIZATION_ORDER",T."NORMAL_1",T."SKEW_1",T."NORMAL_2",T."SKEW_2",T."NORMAL_3",T."SKEW_3",T."NORMAL_4",T."SKEW_4",T."NORMAL_5",T."SKEW_5",T."NORMAL_6",T."SKEW_6",T."NORMAL_7",T."SKEW_7",T."NORMAL_8",T."SKEW_8",T."NORMAL_9",T."SKEW_9",T."NORMAL_10",T."SKEW_10",T."NORMAL_11",T."SKEW_11",T."NORMAL_12",T."SKEW_12",T."NORMAL_13",T."SKEW_13",T."NORMAL_14",T."SKEW_14",T."NORMAL_15",T."SKEW_15",T."LOGIN_NAME",T."LOGIN_DATE",T."NOTES"
FROM F_INT_COMP T
WHERE T.COMPONENT_TYPE = 'ramp'
AND T.APERTURE_NUMBER = 1
AND T.MAGNET_STATE = 'cryomagnet'
--AND T.REF_CURRENT BETWEEN 760-1 AND 760+1
AND ((T.MAGNET_TYPE = 1 AND T.REF_CURRENT BETWEEN 760-1 AND 760+1)
OR (T.MAGNET_TYPE = 2 AND T.REF_CURRENT BETWEEN 760-1 AND 760+1))
--
AND T.REF_TEMPERATURE BETWEEN 1.8-0.3 AND 1.8+0.3;