[lrp.tools]:

ADD_TO_LRP_LIST			tell batch SPIKE to pick up proposal for planning.
ARCHIVE_LRPS			moves old LRPS/PWS to archive_assist.
AUTO_LRP_JOBS			bootstrap job to execute nightly LRP tools.
AVAILABLE   			shows what is available for building during a given time slice.
BASELINE_LRP			baseline a particular LRP.
BASELINE_REPORTS		reports generated at conclusion of baselining process.
CHECK_CWV_PW			makes the CWV/PW plot...does it still work?
CHECK_FOR_CW_SIZE               Prints summary of CW durations and number of CW per SU (currently for cycle 5).
CHECK_FOR_DATED_PWS		Lists SUs with expired PWs or open PWs and SU not set to scheduling.
CHECK_FOR_PW_SIZE               Prints summary of PW durations and number of PW per SU.
CHECK_FOR_ZERO_PW
CHOP_HOLE   			lop specified hole in plan window.
CLEANUP_CW
CLEANUP_LRPS			part of the ARCHIVE_LRPS process.
CLEAN_POOL_PWOPEN.COM
CLEAN_POOL_TOOL.COM
COPY_LRP    			copy one LRP into another.
COPY_PROP_INTO_LRP		copy proposal/LRP from one LRP into another.
COPY_VISIT_INTO_LRP             copy visit from one LRP into another.
CREATE_C6_USCS.COM
CREATE_CAL_LRP			
CREATE_CYC6_EARLY_USC           
CREATE_FOC_USC
CREATE_GTO_WFII_USCS            batch tool for tagging Cycle 6 GTOs with USCs.
CREATE_LCAL_USC
CREATE_LOCK_USC                 
CREATE_METEOR_USC		tool in work for creating USCs for meteor storm hiders.
CREATE_NEEDED_FOC_USCS          
CREATE_NIC2CORON_USCS		batch tool for tagging NIC2 coronographic visits with USCs.
CREATE_NIC3CAMP_USC             batch tool for tagging NIC3s with campaign USCs.
CREATE_NIC3_USCS		batch tool for tagging NIC3s with USCs.
CREATE_NIC_CRYO_USCS            batch tool for tagging nicmos with CRYO USCs.
CREATE_NIC_FOM_USCS		obsolete
CREATE_NON_SPEC_USC             
CREATE_NSSC_USC
CREATE_OK_USCS                  create an OK usc for configured USCs.
CREATE_SPEC_USC
CREATE_STISCCD_ACQPEAK_USCS     obsolete
CREATE_STISMAMA_ACQPEAK		obsolete
CREATE_STISMAMA_ACQPEAK_USCS    obsolete
CREATE_STISMAMA_BIGSPEC_USCS	obsolete
CREATE_STISNUV_IM_USCS          obsolete
CREATE_STIS_DIFFUSE_USCS	obsolete
CREATE_STIS_TIMETAG_USCS        obsolete
CREATE_STIS_TINYSPEC_USCS3	obsolete
CREATE_SW_FGS_USC               
CREATE_USC  			create a generic USC.
CREATE_WFPC_C7_USCS		batch tool for tagging Cycle 7 WFPCs with USCS.
CREATE_WOODS_USC                obsolete tool for tagging WFPC WOODS filter visits.
CWV2USC     			map CWVs into a USC.
DANNY_NIC_RPT			report for Golombek (batched in baseline).
DB_CHECK    			check status of database processes.
DELETE_LRP  			deletes a lrp (warning does not check if it is or was a baselined lrp).
DELETE_VISIT_FROM_LRP.COM
DEL_OVERRIDE_ORIENT.COM
DEL_USCS    			interactive tool for deleting USCs.
DEL_USCS_AUTO
DIFF_LRPS   			diff_report on two LRPs.
DIFF_LRPS_ARCHIVE               
DIFF_LRPS_CS 			a diff_lrps that includes the contact scientist name
DIFF_LRPS_CS_BYCS               a diff_lrps with CS name ordered by CS
DIFF_LRPS_CS_BYPC		diff_lrps with some things ordered by program coordinator
DIFF_LRPS_OLD 
DOIT        			COM file to run other com files...obsolete??
DUMMY_DIFF			???
EXECUTE_POOL_CLEAN		tool in auto baseline to execute the pool_clean tool.
EXPIRE_LIST 			tool for showing visits expiring in near future.
FAILED				exec time order of failed visits.
FILLERS				????
FILLERSX			????
FILLERSX1			????
FIND_SCHED_OUTSIDE
FIND_SPEC_SUS 
GETPROP    			database grab on full proposal.
GETSU       			database grab on one sunit.
JUSTDATED   
LANDIT      			landscape print a file.
LATEST_CALS 			display latest baselined calendars.
LATEST_LRPS			display latest baselined, released & created lrps
LATE_ADD    			record & show sunits/props foisted on lrp lately.
LATE_ADD_DEV
LISTNEW_INSTS_USCS
LOGSHEET_INFO 
LRP_ACCOUNTING                  
LRP_CYC4_SUMMARY
LRP_CYC5_SUMMARY               
LRP_CYC7_SUMMARY
LRP_EVENTS  			tool for recording & showing events stored in lrp_track.
LRP_GTO_SUMMARY                 
LRP_SMOV_SUMMARY
LRP_SS_SUMMARY                  
LRP_SUMMARY 			Makes the lrp summary report???????
MAIN       			run the main.sql in the current working directory.
MAKE_FGS_REPROCESS_REC          
MAKE_PRIORITY_REC
MAKE_SUPERSNAP.COM
MAKE_TOO_REC
MANUAL_RELEASE_LRP              
MASS       
MERGE_CAL_LRP 			tool run in baseline_lrp to copy INTERNAL_CAL into LRP.
MOD_PW      
MORNING_DIFF			part of the automated release process.
MOVE_IT     			identify visits with windows that can/can't move into requested area.
MOVE_IT_NEW
MOVE_IT_X
MOVE_PW     
NEW_PROP_INFO 
NIC3S_REPORT			report status of all NIC3s.
NICCORON_REPORT			report on nic coronagraphs (currently only does SNAPs--yes, broken).
NICCOR_SNAP_REPORT.COM
NIC_SUS_FOR_WEEK
NIGHTLY_WORK			runs the nightly diff report.
OLD_MAIN    			obsolete
OPMSEARCH.COM
OPM_REPORTS.COM
ORBITS_IN_INTERVAL		how many orbits are in a given interval?
ORBIT_SUMMARY 
PC_REPORTS 			PC reports (batched in baseline).
PC_UNSCHED  			PC unschedulables reports (batched in baseline).
PWVER_REPLAN_PWCHECK            
PWVER_REPLAN_SULISTS
PW_AFTER_SGD.COM
PW_FIXUP    			Runs the SQL that dinks the PWs...obsolete??
PW_INTERSECT
RELEASE_LRP 			releases LRP (run from planning account).
RELEASE_LRP_OLD			" obsolete version.
RESTORE_ARCHIVED_LRP            copy an LRP from the archive into assist.
SCHED_IN_INTERVAL.COM
SCHED_IN_INTERVAL_SUMMARY.COM
SCR2        
SCRIPTCHANGE 
SET_DINK    			 Generates the records to allow the PW changes to occur...obsolete??
SMALL_CWS.COM
SRCH        
STISTEST_ENVIRO.COM
SUBMIT_AUTO_LRP_JOBS		startup file for the bootstrap of AUTO_LRP_JOBS.
SUBMIT_BASELINE_REPORTS         distributed reports for PCs after baseline.
SUBMIT_BASELINE_REPORTS_EASY	easy submit job for post-baseline reports.
SUBMIT_BASELINE_REPORTS_EASY_0300 	" submit at given time.
SUBMIT_BASELINE_REPORTS_EASY_0600	" submit at given time.
SUBMIT_BASELINE_REPORTS_EASY_1220.COM
SUBMIT_BASELINE_REPORTS_NOW.COM
SUBMIT_NIGHTLY_WORK		submits nightly LRP copy & diff report.
SU_HISTORY  			plan window history of an sunit.
SU_HISTORY_ALL                  obsolete.  see su_history.
SU_HISTORY_BASE			obsolete.  see su_history.
TARGETS_INA_BOX			given an integer box on the sky, what unexecuted visits are there?
UNSCHED     			show unschedulables for prop.
UPDATE_CAL_LRP
UPDATE_PRIORITY_REC             
USE_OPERATIONAL_DB		redefine environment to point at operational db.
USE_TEST_DB 			redefine environment to point at testdb.
VISITS      
VISITS_SCHED_IN_INTERVAL.COM
VISIT_INFO  
WHATS_SUPER			shows what is in the supersnap pool.
WHAT_SCHED.COM
WHOPC      			who is the pc for a proposal.
WHY_PROP_NOT_IN_LRP             
WWW_REPORTS 
ZERO_ORBITS			what prime visits have zero estimated orbits.

sql_dir:

ADD_TARTYPE.SQL				used in conjunction with CREATE_TEMPSU_TABLES to add target types.
BAD_PWS_STATUS_RPT.SQL			baseline report.
BIG_SUMMARY_REPORT_BRAD.SQL
BIG_SUMMARY_REPORT_STATES.SQL
CAL_NOPW_RPT.SQL
CREATE_ACCOUNTING_FILE.SQL
CREATE_INSTRUMENTS.SQL
CREATE_SI_TABLE.SQL			creates instrument usage temp table.
CREATE_SR_TABLE.SQL			creates special requirement temp table.
CREATE_TABLE.SQL      
CREATE_TEMPPREP.SQL			
CREATE_TEMPSU_TABLES.SQL		fundamental temp tables.
CTT_SAFED.SQL
CUR_SMS_DATES1.SQL			temp table of sms boundaries (used in CLEAN POOL)
CUR_SMS_DATES1X.SQL			...work in progress.
CUR_SMS_DATES2.SQL			companion to CUR_SMS_DATES1.SQL.
CWV_END_BEFORE_PW.SQL			baseline report.
CYC5_PW_AFTER_150_WITH_CW.SQL		old baseline report.
CYC5_PW_AFTER_P2_RPT.SQL
CYC7_NON_NIC.SQL
CYC7_WF_SUS.SQL
DANNYS_NIC_RPT.SQL			a post-baseline report
DIFF_LRPS.RPT				
DIFF_LRPS_RPT1.SQL			proposals dropped report.
DIFF_LRPS_RPT2.SQL			dropped report.
DIFF_LRPS_RPT3.SQL			lost PWs report.
DIFF_LRPS_RPT4-5.SQL			new SUs w/ PWs report.
DIFF_LRPS_RPT4.SQL			new SUs w/out PWs report.
DIFF_LRPS_RPT5.SQL			gained PWs report.
DIFF_LRPS_RPT6.SQL			status differences report.
DIFF_LRPS_RPT7.SQL			changed flt. ready dates 
DIFF_LRPS_RPT7CS.SQL			" include CS.
DIFF_LRPS_RPT7CS_BYCS.SQL		" include CS & order by CS.
DIFF_LRPS_RPT7CS_BYPC.SQL		" include CS & order by PC.
DIFF_LRPS_RPT7CS_BYSU.SQL		" include CS & order by SU.
DIFF_LRPS_RPT8.SQL			...???
DO_ALL_PLOTS.SQL
EST_ORBITS_RPT.SQL			
EXPANDED_TEMPSU_TABLES.SQL		...aborted restructuring of create_tempsu_tables
EXPIRE_WEEK_TABLE.SQL
FOOTER.TXT
GIN1ORB.SQL				visits grouped within 1 orbit cleanup of create_tempsu_tables.
INST_TABLE.SQL
INTERNAL_SUS_RPT.SQL
INTERSECT.SQL
LARGE_VISITS_SCHEDULED_RPT.SQL		old baseline report. 
LATEST_LRPS.SQL				returns latest created/baselined/released LRPs.
LIST_HST_ORBIT_FITS.SQL
LINKSUNITS.SQL	
LMC_RPT.SQL
LOAD_USC_XXX.SQL
LONG_SUS_CWV_PW_RPT.SQL
LONG_SUS_PENDING.SQL			old baseline report.
LRP_PLOT.SQL				plot resources all externals.
LRP_PLOT_4ORB.SQL
LRP_PLOT_4ORBPLUS.SQL
LRP_PLOT_5ORB.SQL
LRP_PLOT_6ORB.SQL
LRP_PLOT_7ORBPLUS.SQL
LRP_PLOT_CAL.SQL
LRP_PLOT_CORONO.SQL			plot resources for nic coronagraphs.
LRP_PLOT_CW_SAAHIDERS.SQL
LRP_PLOT_CYCLE6.SQL			plot resources for all external cycle 6.
LRP_PLOT_GTO.SQL			
LRP_PLOT_MAMAONLY.SQL			plot resources for external mamas.
LRP_PLOT_NIC.SQL			plot resources for all nicmos programs.
LRP_PLOT_NIC_ANY.SQL			plot resources for all external nicmos usage.
LRP_PLOT_NIC_GTO.SQL			plot resources for all external GTO nicmos.
LRP_PLOT_NONSTIS.SQL			plot resources for all external stis usage.
LRP_PLOT_NO_STIS_NIC.SQL		plot resources for non-STIS||NIC usage.
LRP_PLOT_STIS.SQL			plot resources for stis programs.
LRP_PLOT_STIS_ANY.SQL			plot resources for all stis usage.
LRP_PLOT_STIS_ANY_GTO.SQL		plot resources for any stis GTO usage.
LRP_PLOT_STIS_CCDONLY.SQL		plot resources for STIS CCD-only usage.
LRP_PLOT_TIGHTLINKS.SQL
LRP_PLOT_TIMETAG.SQL			plot resources for STIS timetag visits.
LRP_PLOT_WFPC2_C7.SQL			plot resources for C7 WFPC.
LRP_READY_NOPWS_RPT.SQL			baseline report.
MAIN.SQL
MV_CYC6.SQL
MV_CYC6_INFO.SQL
MV_FROM_CROWDED_AREA_RPT.SQL
NEW_DATED_RPT.SQL			baseline report.  dates PWs.
NIC_MOVE_EARLY_RPT.SQL			old baseline report.  NICMOS that can move earlier in LRP (obsolete?)
NIC_PW_AFTER_P2.SQL
NIC_SR.SQL
NIC_SUS_FOR_WEEK_RPT.SQL
NOT_PLANNED_SCHEDULABLE_RPT.SQL		baseline report.  not planned, but schedulable report
OPEN_NOT_READY.SQL			
ORBITS_IN_INTERVAL.SQL			used by orbits_in_interval_tool.
ORBIT_SUMMARY.SQL
ORBIT_SUMMARY_PROCESSOR.SQL
ORBIT_SUMMARY_REPORTTEMPLATE.SQL
PULL_FORWARD_RPT.SQL
PW_BEYOND_CWV.SQL			baseline report.  PW/CWV mismatch.
PW_FOR_AREA.SQL
QSCHED_POOL_SUS_RPT.SQL			old baseline report.
SAA_CURR_PW_RPT.SQL
SAA_LG_ORBS.SQL
SCHED_NOPW_RPT.SQL
SMALL_CWV_RPT.SQL
SMALL_CW_RPT.SQL
SMALL_PW_RPT.SQL
SNAPINC_TEMPSU_TABLES.SQL
STIS_MOVE_EARLY.SQL
SUPERSNAP_RPT.SQL
SUS_BY_CW_RPT.SQL
SUS_FOR_WEEK_RPT.SQL
SUS_SCHEDULING_NO_CWV_RPT.SQL		baseline report.
SUS_WITH_CWV_BEFORE_P2_RPT.SQL		baseline report.
SU_LIST.SQL
TEMPSU_TEST.SQL
TEST_SAFE1.SQL
TEST_SCHED.SQL
TSU_CWV.SQL
TSU_INSTRUMENTS.SQL
TSU_LINKSUNITS.SQL
TSU_LRPTRACK.SQL
TSU_SR.SQL
TSU_TAR_TYPE.SQL
TSU_TEMPEXP.SQL
TSU_USCS.SQL
TSU_USC_NAMES.SQL
TSU_VSR.SQL
UNSCHED_PC_RPT.SQL
UPDATE_INSTRUMENTS.SQL
USC_USC_CONFLICT_RPT.SQL		baseline report.
XXXSUM.SQL
ZERO_SEC_PW_RPT.SQL			baseline report.