!------------------------------------------------------------------------------- ! ! hkp_sci RESOURCE FILE ! ! ! This file is used to construct the trigger, error, and success status ! fields in the observation status file. ! ! PR 67029 if anymore QUERY statements are added with new data_id's, please ! be sure to add to the OSF_TRIGGERn list below. ! ! !------------------------------------------------------------------------------- ! REVISION HISTORY !------------------------------------------------------------------------------- ! PR ! DATE NUMBER Developer Description ! -------- ------ --------- -------------------------------------------------- ! 05/03/04 50955 Heller Initial version ! Goldst ! 08/20/04 51405 Heller Special multi product cases for nas,aca ! add edt dia and acc queries. ! 08/26/04 51405 Sherbert undo NULL of instrument and times ! Make PODNAME instrument IDs long version ! Fix setting of Query 19's end time ! Add INSTRUMENT code for WF2 so EDT updates work ! 09/16/04 51848 J.Baum Changes for TVI and TVL datasets (cos, wf3) and ! add support for future coa and wfa data_ids. ! Add 2 PODNAME values for old SIs. ! 09/17/04 51692 J.Baum Add CATALOG_LOCK_DIR and CATALOG_LOCK_IDS. ! Also add OSF_HELD completion status. ! 11/08/04 52183 J.Baum Provide HKP data for ACS and NIC orphans and ! add ZERO_RECORDS_ALLOWED for broken asns. Lots ! of changes - moved queries together that process ! the same data_ids - renumbered queries. Added more ! query comments. Isolated ASN class queries. ! Used general queries for asn CAL class that ! handle multiple instruments. ! 01/21/05 52637 J.Baum Update qolink_sms.status to E or N using ! asn_members data or to E for for single datasets. ! Four new queries at end. Also added ! ZERO_RECORDS_ALLOWED = NO rather than defaulting. ! 05/31/05 53016 J.Baum Use hkp_hst_query.lis file ! 02/22/08 58278 Sherbert SM4 Updates ! 01/15/10 64310 Sherbert make pods proprietary ! 04/30/10 64292 Sherbert Discontinue nulling PSO, etc. ! 07/22/10 65295 Sherbert Add new command to set a catalog date; fix MTL/SMS ! 08/25/10 65688 Sherbert Add si for ACM and pso/pep for EDT ! 08/26/10 64600 Sherbert Make DIA/EDT work interactively ! 08/30/10 65745 Sherbert ACS life data_id adjustment; add new sti/cos cums ! 02/10/11 67029 Sherbert add data_id entries to restrict usage ! !------------------------------------------------------------------------------- PROCESS_NAME = update_catdb TASK = DESCRIPTION = 'Updates fields in the archive catalog relations" SYSTEM = OPUS CLASS = ALL ! ! Triggers on OSF event !---------------------------------------------------------------------------- ! EVNT resource. !---------------------------------------------------------------------------- ! POLLING_TIME = 5 ! Response time of the application ! OSF_RANK = 1 ! OSF event ordering. OSF_TRIGGER1.SC = u OSF_TRIGGER1.DATA_ID = acm OSF_TRIGGER2.SC = u OSF_TRIGGER2.DATA_ID = ssi OSF_TRIGGER3.SC = u OSF_TRIGGER3.DATA_ID = csi OSF_TRIGGER4.SC = u OSF_TRIGGER4.DATA_ID = dia OSF_TRIGGER5.SC = u OSF_TRIGGER5.DATA_ID = adm OSF_TRIGGER6.SC = u OSF_TRIGGER6.DATA_ID = cdm OSF_TRIGGER7.SC = u OSF_TRIGGER7.DATA_ID = ndm OSF_TRIGGER8.SC = u OSF_TRIGGER8.DATA_ID = sdm OSF_TRIGGER9.SC = u OSF_TRIGGER9.DATA_ID = wdm OSF_TRIGGER10.SC = u OSF_TRIGGER10.DATA_ID = edt OSF_TRIGGER11.SC = u OSF_TRIGGER11.DATA_ID = edi OSF_TRIGGER12.SC = u OSF_TRIGGER12.DATA_ID = edj OSF_TRIGGER13.SC = u OSF_TRIGGER13.DATA_ID = edl OSF_TRIGGER14.SC = u OSF_TRIGGER14.DATA_ID = edn OSF_TRIGGER15.SC = u OSF_TRIGGER15.DATA_ID = edo OSF_TRIGGER16.SC = u OSF_TRIGGER16.DATA_ID = edu OSF_TRIGGER17.SC = u OSF_TRIGGER17.DATA_ID = edx OSF_TRIGGER18.SC = u OSF_TRIGGER18.DATA_ID = pod OSF_TRIGGER19.SC = u OSF_TRIGGER19.DATA_ID = wf2 OSF_TRIGGER20.SC = u OSF_TRIGGER20.DATA_ID = acs OSF_TRIGGER21.SC = u OSF_TRIGGER21.DATA_ID = sti OSF_TRIGGER22.SC = u OSF_TRIGGER22.DATA_ID = nic OSF_TRIGGER23.SC = u OSF_TRIGGER23.DATA_ID = cos OSF_TRIGGER24.SC = u OSF_TRIGGER24.DATA_ID = wf3 OSF_TRIGGER25.SC = u OSF_TRIGGER25.DATA_ID = sas OSF_TRIGGER26.SC = u OSF_TRIGGER26.DATA_ID = nas OSF_TRIGGER27.SC = u OSF_TRIGGER27.DATA_ID = aca OSF_TRIGGER28.SC = u OSF_TRIGGER28.DATA_ID = coa OSF_TRIGGER29.SC = u OSF_TRIGGER29.DATA_ID = w3a OSF_TRIGGER30.SC = u OSF_TRIGGER30.DATA_ID = tvl OSF_TRIGGER31.SC = u OSF_TRIGGER31.DATA_ID = tvi OSF_PROCESSING.SC = p ! Letter to be used when an OSF is processed. OSF_ERROR.SC = f ! Letter to be used when there is an error. ! PR 60293 Differentiate for catalog error OSF_HELD.SC = h ! Letter to be used if catalog lock is detected OSF_SUCCESS.SC = c ! Letter to be used when it is successful OSF_SUCCESS.CL = w ! ! !---------------------------------------------------------------------------- ! Optional catalog lock keywords. No diagnostic message will appear if these ! keywords are not specified. The CATALOG_LOCK_DIR keywords must be found ! in the pathfile with a path name that ends in a slash (/) or be missing ! from the pathfile, so that the default value in interactive mode is ! CATALOG_LOCK_DIR. The CATALOG_LOCK_IDS must match the science data_ids ! separated by commas with no intervening blanks. If the OSF data_id matches ! any entry in CATALOG_LOCK_IDS, then the directory CATALOG_LOCK_DIR is searched ! for locks. If a lock is found the returned status is OSF_HELD. !---------------------------------------------------------------------------- CATALOG_LOCK_DIR = CATALOG_LOCK_DIR ! directory to find cataloging locks CATALOG_LOCK_IDS = wf2,acs,aca,sti,sas,nic,nas,cos,coa,wf3,w3a ! data_ids to hold ! !---------------------------------------------------------------------------- QUERY_SOURCE = OPUS_DEFINITIONS_DIR:hkp_hst_query.lis ! ! PR 65745/7 less confusing data_id/archive_class QUERY.01.acm = UPDATE_ACS_MAMA QUERY.02.acm = UPDATE_ACS_MAMA_IN_ADS QUERY.03.acm = SET_CAT_COMPLETE_DATE ! ! PR 65745/7 update new table QUERY.01.ssi = UPDATE_STI_CUMULATIVE_IMAGES QUERY.02.ssi = UPDATE_ADS_FOR_STI_CUMULATIVE_IMAGES QUERY.03.ssi = SET_CAT_COMPLETE_DATE ! ! PR 65745/7 update new table QUERY.01.csi = UPDATE_COS_CUMULATIVE_IMAGES QUERY.02.csi = UPDATE_ADS_FOR_COS_CUMULATIVE_IMAGES QUERY.03.csi = SET_CAT_COMPLETE_DATE ! ! PR 64600 For interactive command line tools ! and Dia data from multiple SIs QUERY.01.dia = UPDATE_DIA_INSTRUMENT QUERY.02.dia = SET_CAT_COMPLETE_DATE ! QUERY.01.adm = UPDATE_DIA_INSTRUMENT QUERY.02.adm = SET_CAT_COMPLETE_DATE ! QUERY.01.cdm = UPDATE_DIA_INSTRUMENT QUERY.02.cdm = SET_CAT_COMPLETE_DATE ! QUERY.01.ndm = UPDATE_DIA_INSTRUMENT QUERY.02.ndm = SET_CAT_COMPLETE_DATE ! QUERY.01.sdm = UPDATE_DIA_INSTRUMENT QUERY.02.sdm = SET_CAT_COMPLETE_DATE ! QUERY.01.wdm = UPDATE_DIA_INSTRUMENT QUERY.02.wdm = SET_CAT_COMPLETE_DATE ! ! PR 64600 For interactive command line tools ! and Edt data from multiple SIs QUERY.01.edt = UPDATE_EDT_INSTRUMENT QUERY.02.edt = SET_CAT_COMPLETE_DATE ! QUERY.01.edi = UPDATE_EDT_INSTRUMENT QUERY.02.edi = SET_CAT_COMPLETE_DATE ! QUERY.01.edj = UPDATE_EDT_INSTRUMENT QUERY.02.edj = SET_CAT_COMPLETE_DATE ! QUERY.01.edl = UPDATE_EDT_INSTRUMENT QUERY.02.edl = SET_CAT_COMPLETE_DATE ! QUERY.01.edn = UPDATE_EDT_INSTRUMENT QUERY.02.edn = SET_CAT_COMPLETE_DATE ! QUERY.01.edo = UPDATE_EDT_INSTRUMENT QUERY.02.edo = SET_CAT_COMPLETE_DATE ! QUERY.01.edu = UPDATE_EDT_INSTRUMENT QUERY.02.edu = SET_CAT_COMPLETE_DATE ! QUERY.01.edx = UPDATE_EDT_INSTRUMENT QUERY.02.edx = SET_CAT_COMPLETE_DATE ! QUERY.01.pod = UPDATE_POD_INSTRUMENT QUERY.02.pod = UPDATE_POD_RELEASE_DATE QUERY.03.pod = SET_CAT_COMPLETE_DATE ! QUERY.01.wf2 = UPDATE_ADS_TABLE QUERY.02.wf2 = SCIENCE_UPDATE QUERY.03.wf2 = SET_QOLINK_STATUS_SINGLE QUERY.04.wf2 = SET_CAT_COMPLETE_DATE ! QUERY.01.acs = UPDATE_ADS_TABLE QUERY.02.acs = SCIENCE_UPDATE QUERY.03.acs = SET_QOLINK_STATUS_SINGLE QUERY.04.acs = SET_CAT_COMPLETE_DATE ! QUERY.01.sti = UPDATE_ADS_TABLE QUERY.02.sti = SCIENCE_UPDATE QUERY.03.sti = SET_QOLINK_STATUS_SINGLE QUERY.04.sti = SET_CAT_COMPLETE_DATE ! QUERY.01.nic = UPDATE_ADS_TABLE QUERY.02.nic = SCIENCE_UPDATE QUERY.03.nic = SET_QOLINK_STATUS_SINGLE QUERY.04.nic = SET_CAT_COMPLETE_DATE ! QUERY.01.cos = UPDATE_ADS_TABLE QUERY.02.cos = SCIENCE_UPDATE QUERY.03.cos = SET_QOLINK_STATUS_SINGLE QUERY.04.cos = SET_CAT_COMPLETE_DATE ! QUERY.01.wf3 = UPDATE_ADS_TABLE QUERY.02.wf3 = SCIENCE_UPDATE QUERY.03.wf3 = SET_QOLINK_STATUS_SINGLE QUERY.04.wf3 = SET_CAT_COMPLETE_DATE ! QUERY.01.sas = UPDATE_ASSOC_STATUS QUERY.02.sas = UPDATE_ADS_FOR_ASN QUERY.03.sas = SCIENCE_UPDATE_FOR_ASN QUERY.04.sas = UPDATE_ADS_FOR_ASN_PRODUCTS QUERY.05.sas = SET_QOLINK_STATUS_STIS QUERY.06.sas = SET_CAT_COMPLETE_DATE ! QUERY.01.nas = UPDATE_ASSOC_STATUS QUERY.02.nas = UPDATE_ADS_FOR_ASN QUERY.03.nas = SCIENCE_UPDATE_FOR_ASN QUERY.04.nas = UPDATE_SCIENCE_ORPHANS QUERY.05.nas = UPDATE_ADS_FOR_ASN_PRODUCTS QUERY.06.nas = UPDATE_ADS_ORPHANS QUERY.07.nas = UPDATE_ADS_FOR_NICMOS QUERY.08.nas = SET_QOLINK_STATUS_COLLECTED QUERY.09.nas = SET_QOLINK_STATUS_UNCOLLECTED QUERY.10.nas = SET_CAT_COMPLETE_DATE ! QUERY.01.aca = UPDATE_ASSOC_STATUS QUERY.02.aca = UPDATE_ADS_FOR_ASN QUERY.03.aca = SCIENCE_UPDATE_FOR_ASN QUERY.04.aca = UPDATE_SCIENCE_ORPHANS QUERY.05.aca = UPDATE_ADS_FOR_ASN_PRODUCTS QUERY.06.aca = UPDATE_ADS_ORPHANS QUERY.07.aca = UPDATE_ADS_FOR_ACS QUERY.08.aca = SET_QOLINK_STATUS_COLLECTED QUERY.09.aca = SET_QOLINK_STATUS_UNCOLLECTED QUERY.10.aca = SET_CAT_COMPLETE_DATE ! QUERY.01.coa = UPDATE_ASSOC_STATUS QUERY.02.coa = UPDATE_ADS_FOR_ASN QUERY.03.coa = SCIENCE_UPDATE_FOR_ASN QUERY.04.coa = UPDATE_SCIENCE_ORPHANS QUERY.05.coa = UPDATE_ADS_FOR_ASN_PRODUCTS QUERY.06.coa = UPDATE_ADS_ORPHANS QUERY.07.coa = UPDATE_ADS_FOR_COS QUERY.08.coa = SET_QOLINK_STATUS_COLLECTED QUERY.09.coa = SET_QOLINK_STATUS_UNCOLLECTED QUERY.10.coa = SET_CAT_COMPLETE_DATE ! QUERY.01.w3a = UPDATE_ASSOC_STATUS QUERY.02.w3a = UPDATE_ADS_FOR_ASN QUERY.03.w3a = SCIENCE_UPDATE_FOR_ASN QUERY.04.w3a = UPDATE_SCIENCE_ORPHANS QUERY.05.w3a = UPDATE_ADS_FOR_ASN_PRODUCTS QUERY.06.w3a = UPDATE_ADS_ORPHANS QUERY.07.w3a = UPDATE_ADS_FOR_WFC3 QUERY.08.w3a = SET_QOLINK_STATUS_COLLECTED QUERY.09.w3a = SET_QOLINK_STATUS_UNCOLLECTED QUERY.10.w3a = SET_CAT_COMPLETE_DATE ! QUERY.01.tvl = UPDATE_ADS_FOR_THERMOVAC QUERY.02.tvl = SET_QOLINK_STATUS_SINGLE QUERY.03.tvl = SET_CAT_COMPLETE_DATE ! QUERY.01.tvi = UPDATE_ADS_FOR_THERMOVAC QUERY.02.tvi = SET_QOLINK_STATUS_SINGLE QUERY.03.tvi = SET_CAT_COMPLETE_DATE ! !------------------------------------------------------------------------- ! END OF QUERIES !------------------------------------------------------------------------- ! Instrument code embedded in OSF_DATASET INSTRUMENT.J = ACS INSTRUMENT.N = NICMOS INSTRUMENT.O = STIS INSTRUMENT.U = WFPC2 INSTRUMENT.I = WFC3 INSTRUMENT.L = COS ! ! Archive Class to use for substition ! .data_id = archive_class ! Increase the list for PR 65295 ARCHIVE_CLASS.ACS = CAL ARCHIVE_CLASS.ACA = ASN ARCHIVE_CLASS.SAS = ASN ARCHIVE_CLASS.NAS = ASN ARCHIVE_CLASS.STI = CAL ARCHIVE_CLASS.NIC = CAL ARCHIVE_CLASS.WF2 = CAL ARCHIVE_CLASS.TVI = TVI ARCHIVE_CLASS.WF3 = CAL ARCHIVE_CLASS.W3A = ASN ARCHIVE_CLASS.TVL = TVL ARCHIVE_CLASS.COS = CAL ARCHIVE_CLASS.COA = ASN ARCHIVE_CLASS.ACM = ACM ! PR 65745/7 ARCHIVE_CLASS.SSI = SSI ! PR 65745/7 ARCHIVE_CLASS.POD = POD ! MUST uppercase data_id ARCHIVE_CLASS.SDM = DIA ARCHIVE_CLASS.NDM = DIA ARCHIVE_CLASS.ADM = DIA ARCHIVE_CLASS.WDM = DIA ARCHIVE_CLASS.CDM = DIA ARCHIVE_CLASS.EDI = EDT ARCHIVE_CLASS.EDJ = EDT ARCHIVE_CLASS.EDN = EDT ARCHIVE_CLASS.EDO = EDT ARCHIVE_CLASS.EDL = EDT ARCHIVE_CLASS.EDU = EDT ARCHIVE_CLASS.DIA = DIA ! PR 64600 interactive ARCHIVE_CLASS.EDT = EDT ! PR 64600 interactive ARCHIVE_CLASS.CSI = CSI ! PR 65745 ! ! Instrument number identifiers. Useful for pod files. PODNAME.BD = ACS PODNAME.9A = COS PODNAME.37 = FOC PODNAME.7E = NICMOS PODNAME.49 = STIS PODNAME.A2 = WFPC2 PODNAME.F1 = WFC3 PODNAME.00 = DMP PODNAME.DC = FOS PODNAME.EB = HRS ! ! set by path file OPUS_DB = OPUS_DB ARCH_DB= ARCH_DB ARCH_SERVER = ARCH_SERVER