This view is used to merge unit discipline history with the current unit discipline details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT UDH1.UNIT_CD , UDH1.VERSION_NUMBER , UDH1.DISCIPLINE_GROUP_CD , UDH1.HIST_START_DT , UDH1.HIST_END_DT , UDH1.HIST_WHO , NVL( UDH1.PERCENTAGE , NVL( TO_NUMBER( IGS_AU_GEN_004.AUDP_GET_UDH_COL( UDH1.UNIT_CD , UDH1.VERSION_NUMBER , UDH1.DISCIPLINE_GROUP_CD , UDH1.HIST_END_DT)) , UD1.PERCENTAGE)) , UDH1.CREATED_BY , UDH1.CREATION_DATE , UDH1.LAST_UPDATED_BY , UDH1.LAST_UPDATE_DATE , UDH1.LAST_UPDATE_LOGIN FROM IGS_PS_UNT_DSCP_HIST UDH1 , IGS_PS_UNIT_DSCP UD1 , IGS_PS_UNIT_VER UV WHERE UV.UNIT_CD = UDH1.UNIT_CD AND UV.VERSION_NUMBER = UDH1.VERSION_NUMBER AND UDH1.UNIT_CD = UD1.UNIT_CD (+) AND UDH1.VERSION_NUMBER = UD1.VERSION_NUMBER (+) AND UDH1.DISCIPLINE_GROUP_CD = UD1.DISCIPLINE_GROUP_CD (+) UNION ALL SELECT UD2.UNIT_CD , UD2.VERSION_NUMBER , UD2.DISCIPLINE_GROUP_CD , NVL( MAX(UDH2.HIST_END_DT) , UD2.LAST_UPDATE_DATE) , TO_DATE(NULL) , UD2.LAST_UPDATED_BY , UD2.PERCENTAGE , UD2.CREATED_BY , UD2.CREATION_DATE , UD2.LAST_UPDATED_BY , UD2.LAST_UPDATE_DATE , UD2.LAST_UPDATE_LOGIN FROM IGS_PS_UNT_DSCP_HIST UDH2 , IGS_PS_UNIT_DSCP UD2 WHERE UD2.UNIT_CD = UDH2.UNIT_CD (+) AND UD2.VERSION_NUMBER = UDH2.VERSION_NUMBER (+) AND UD2.DISCIPLINE_GROUP_CD = UDH2.DISCIPLINE_GROUP_CD (+) GROUP BY UD2.UNIT_CD , UD2.VERSION_NUMBER , UD2.DISCIPLINE_GROUP_CD , UD2.PERCENTAGE , UD2.CREATED_BY , UD2.CREATION_DATE , UD2.LAST_UPDATED_BY , UD2.LAST_UPDATE_DATE , UD2.LAST_UPDATE_LOGIN