# ==========================================================
# OQ Tool working scripts
#
# DB DATA check - common part for both, Oracle and Access db's
# ==========================================================


### CS_AD
DATA /v=$AD_TYPE_INVALID _
     /v=$AD_TYPE_BACKGROUND _
     /v=$AD_TYPE_INTERACTIVE _
     /v=$AD_TYPE_SPOOLER _
     CS_AD AD_TYPE
     
### CS_AQ
DATA /v=$AQ_FREQTSID_DAILY _
     /v=$AQ_FREQTSID_MONTHLY _
     /v=$AQ_FREQTSID_WEEKLY _
     CS_AQ AQ_FREQTSID   
     
### CS_AR     
DATA /v=$AR_TSID_AUTOMATED_ARCHIVE _
     /v=$AR_TSID_MANUAL_ARCHIVE _
     CS_AR AR_TSID

### CS_AT
     DATA /v=$AT_TSID_ADDED_TO_BATCH_REQUEST _
     /v=$AT_TSID_ARCHIVED _
     /v=$AT_TSID_DEARCHIVED _
     /v=$AT_TSID_DELETED_FROM_BATCH_REQUEST _
     /v=$AT_TSID_EDIT_CUSTOM_FIELD _
     /v=$AT_TSID_LOADED_AS_PART_OF_BATCH _
     /v=$AT_TSID_LOADED_AS_PART_OF_SEQUENCE _
     /v=$AT_TSID_LOADED_TO_DISK _
     /v=$AT_TSID_NEW _
     /v=$AT_TSID_READ_ONLY _
     /v=$AT_TSID_REOPEN _
     /v=$AT_TSID_REPROCESSED_IN_BATCH_REVIEW _
     /v=$AT_TSID_SAMPLE_NAME_CHANGED _
     /v=$AT_TSID_STATUS_CHANGED _
     /v=$AT_TSID_STUDY_CHANGED _
     CS_AT AT_TSID

### CS_CC
DATA /v=$CC_DEADVOLUNITTSID_PCT _
     /v=$CC_DEADVOLUNITTSID_NONE_BKT _
     /v=$CC_DEADVOLUNITTSID_MIN _
     /v=$CC_DEADVOLUNITTSID_ML _
     CS_CC CC_DEADVOLUNITTSID

### CS_CCM     
DATA /v=$CCM_CALCTSID_MEAN _
     /v=$CCM_CALCTSID_SUM _
     /v=$CCM_CALCTSID_UNDEFINED _
     CS_CCM CCM_CALCTSID

### CS_CCM
DATA /v=$CCM_CALCMTTSID_GROUP_AMOUNT_CALIBRATION _
     /v=$CCM_CALCMTTSID_NO_CALIBRATION _
     CS_CCM CCM_CALCMTTSID
     
### CS_CFA
DATA /v=$CFA_FILLTYPE_INVALID _
     /v=$CFA_FILLTYPE_USER _
     /v=$CFA_FILLTYPE_EXPR _
     /v=$CFA_FILLTYPE_SYSTEM _
     CS_CFA CFA_FILLTYPE
     
### CS_CFS     
DATA /v=$CFS_VALTYPE_INVALID _
     /v=$CFS_VALTYPE_BOOL _
     /v=$CFS_VALTYPE_ENUM _
     /v=$CFS_VALTYPE_INTEGER _
     /v=$CFS_VALTYPE_REAL _
     /v=$CFS_VALTYPE_STRING _
     /v=$CFS_VALTYPE_DATE_TIME _
     CS_CFS CFS_VALTYPE

### CS_CFS     
DATA /v=$CFS_USETYPE_CHEMSTORE _
     /v=$CFS_USETYPE_VALIDATHIDDEN _
     /v=$CFS_USETYPE_VALIDATPROTECT _
     /v=$CFS_USETYPE_VALIDATEDIT _
     /v=$CFS_USETYPE_SYSTEMHIDDEN _
     /v=$CFS_USETYPE_SYSTEMPROTECT _
     /v=$CFS_USETYPE_SYSTEMEDIT _
     CS_CFS CFS_USETYPE

### CS_CG     
DATA /i /n='<none>' /v=$PIC_TYPE_WMF _
	 CS_CG CG_PICFMT


### CS_CP	 
DATA /v=$CP_TYPETSID_GROUP _
     /v=$CP_TYPETSID_PEAK_SUM _
     /v=$CP_TYPETSID_TARGET _
     /v=$CP_TYPETSID_UNKNOWN _
     CS_CP CP_TYPETSID
     
### CS_CPI     
DATA /v=$CPI_TYPE_INVALID _
     /v=$CPI_TYPE_SIMPLE_STAT _
     /v=$CPI_TYPE_REGRESSION_STAT _
     /v=$CPI_TYPE_REGRESSION_CURVE _
     /v=$CPI_TYPE_REGRESSION_ORIGIN _
     /v=$CPI_TYPE_REGRESSION_WEIGHT _
     CS_CPI CPI_TYPE

### CS_DDF     
DATA /v=$DDF_CATEG_INVALID _
     /v=$DDF_CATEG_INTERNAL _
     /v=$DDF_CATEG_SAMPLE _
     /v=$DDF_CATEG_COMPOUND _
     /v=$DDF_CATEG_CUSTOM_FIELD _
     /v=$DDF_CATEG_REPORT_ONLY _
     CS_DDF DDF_CATEG

### CS_DDF     
DATA /v=$DDF_DEFALIGN_INVALID _
     /v=$DDF_DEFALIGN_LEFT _
     /v=$DDF_DEFALIGN_RIGHT _
     /v=$DDF_DEFALIGN_CENTER _
     CS_DDF DDF_DEFALIGN

### CS_DDF     
DATA /v=$DDF_DTATYPE_INVALID _
     /v=$DDF_DTATYPE_BOOL _
     /v=$DDF_DTATYPE_SHORT _
     /v=$DDF_DTATYPE_LONG _
     /v=$DDF_DTATYPE_REAL _
     /v=$DDF_DTATYPE_STR _
     /v=$DDF_DTATYPE_LSTR _
     /v=$DDF_DTATYPE_BLOB _
     /v=$DDF_DTATYPE_DATE _
     /v=$DDF_DTATYPE_GUID _
     /v=$DDF_DTATYPE_PAGE _
     /v=$DDF_DTATYPE_VIRTUAL _
     /v=$DDF_DTATYPE_YESNO _
     CS_DDF DDF_DTATYPE

### CS_DDF     
DATA /v=$DDF_DTATYPE_INVALID _
     /v=$DDF_DTATYPE_BOOL _
     /v=$DDF_DTATYPE_SHORT _
     /v=$DDF_DTATYPE_LONG _
     /v=$DDF_DTATYPE_REAL _
     /v=$DDF_DTATYPE_STR _
     /v=$DDF_DTATYPE_LSTR _
     /v=$DDF_DTATYPE_BLOB _
     /v=$DDF_DTATYPE_DATE _
     /v=$DDF_DTATYPE_GUID _
     /v=$DDF_DTATYPE_PAGE _
     /v=$DDF_DTATYPE_VIRTUAL _
     /v=$DDF_DTATYPE_YESNO _
     CS_DDF DDF_UIDTATYPE

### CS_DS
DATA /v=$DS_LOCKTYPE_PRIVATELY _
     /v=$DS_LOCKTYPE_NONPRIVATELY _
     CS_DS DS_LOCKTYPE

### CS_INJ     
DATA /v=$INJ_TSID_BLANK _
     /v=$INJ_TSID_EXTERNAL _
     /v=$INJ_TSID_INJ_PROG _
     /v=$INJ_TSID_MANUAL _
     /v=$INJ_TSID_NORMAL _
     /v=$INJ_TSID_UNKNOWN _
     CS_INJ INJ_TSID

### CS_INJ_CC     
DATA /v=$INJ_CC_POSTSID_FRONT _
     /v=$INJ_CC_POSTSID_LEFT _
     /v=$INJ_CC_POSTSID_REAR _
     /v=$INJ_CC_POSTSID_RIGHT _
     /v=$INJ_CC_POSTSID_UNKNOWN _
     CS_INJ_CC INJ_CC_POSTSID

### CS_LB     
DATA /v=$LB_RSNTSID_ACCOUNT_LOCKED _
     /v=$LB_RSNTSID_APPROVED_RUNS _
     /v=$LB_RSNTSID_ARCHIVED_RUNS _
     /v=$LB_RSNTSID_ARCHIVED_RUNS_WITH_DELETE _
     /v=$LB_RSNTSID_ASSIGN_STUDY_TO_USER _
     /v=$LB_RSNTSID_CHANGED_PASSWORD _
     /v=$LB_RSNTSID_CLEARED_PASSWORD _
     /v=$LB_RSNTSID_CREATED_BATCH _
     /v=$LB_RSNTSID_CREATED_NEW_USER _
     /v=$LB_RSNTSID_DEARCHIVED_RUNS _
     /v=$LB_RSNTSID_DEASSIGN_STUDY_FROM_USER _
     /v=$LB_RSNTSID_DELETED_ARCHIVE_DEARCHIVE_REQUEST _
     /v=$LB_RSNTSID_DELETED_PENDING_BATCH _
     /v=$LB_RSNTSID_DELETED_RUNS _
     /v=$LB_RSNTSID_DELETED_SPOOLER_JOBS _
     /v=$LB_RSNTSID_EDIT_CUSTOM_FIELDS _
     /v=$LB_RSNTSID_EMAIL_NOTIFICATION _
     /v=$LB_RSNTSID_FAILED_TO_LOG_ON _
     /v=$LB_RSNTSID_LOGGED_OFF _
     /v=$LB_RSNTSID_MIGRATED_DATA _
     /v=$LB_RSNTSID_MODIFIED_ARCHIVE _
     /v=$LB_RSNTSID_MODIFIED_ARCHIVE_WITH_DELETE _
     /v=$LB_RSNTSID_MODIFIED_PERMISSIONS _
     /v=$LB_RSNTSID_PRIVATE_LOCK_CRACKED _
     /v=$LB_RSNTSID_REJECTED_RUNS _
     /v=$LB_RSNTSID_REOPENED_RUNS _
     /v=$LB_RSNTSID_SESSION_LOCKED _
     /v=$LB_RSNTSID_SESSION_UNLOCKED _
     /v=$LB_RSNTSID_SUCCESSFULLY_LOGGED_ON _
     /v=$LB_RSNTSID_SUCCESSFULLY_LOGGED_ON_AS_MANAGER _
     /v=$LB_RSNTSID_SUCCESSFULLY_LOGGED_ON_AS_OPERATOR _
     /v=$LB_RSNTSID_UPDATED_DATABASE_SCHEMA _
     /v=$LB_RSNTSID_USER_DEACTIVATED _
     /v=$LB_RSNTSID_USER_REACTIVATED _
     /v=$LB_RSNTSID_USER_DISPLAY_NAME_CHANGED _
     /v=$LB_RSNTSID_CREATED_NEW_VERSION_OF_CALCULATION_TEMPLATE _
     /v=$LB_RSNTSID_CREATED_CALCULATION_TEMPLATE _
     CS_LB LB_RSNTSID

### CS_MT
DATA /v=$MT_QNTTSID_AREA_PCT _
     /v=$MT_QNTTSID_ESTD _
     /v=$MT_QNTTSID_ESTD_PCT _
     /v=$MT_QNTTSID_HEIGHT_PCT _
     /v=$MT_QNTTSID_ISTD _
     /v=$MT_QNTTSID_ISTD_PCT _
     /v=$MT_QNTTSID_NORM_PCT _
     /v=$MT_QNTTSID_UNKNOWN _
     CS_MT MT_QNTTSID

### CS_PK
DATA /v=$PK_CALPKTSID_IGNORE _
     /v=$PK_CALPKTSID_MAIN _
     /v=$PK_CALPKTSID_NONE _
     /v=$PK_CALPKTSID_QUALIFIER _
     CS_PK PK_CALPKTSID

### CS_RNG
DATA /v=$RNG_USETYPE_INVALID _
     /v=$RNG_USETYPE_CHEMSTORESTUDY _
     /v=$RNG_USETYPE_VALIDATSTUDY _
     CS_RNG RNG_USETYPE

### CS_RR
DATA /v=$RR_DESTTYPE_INVALID _
     /v=$RR_DESTTYPE_PRINTER _
     /v=$RR_DESTTYPE_FILE _
     /v=$RR_DESTTYPE_SCREEN _
     /v=$RR_DESTTYPE_PRINT_PREVIEW _
     CS_RR RR_DESTTYPE

### CS_RR     
DATA /v=$RR_DESTFILEFMT_INVALID _
     /v=$RR_DESTFILEFMT_HTML _
     /v=$RR_DESTFILEFMT_CSV _
     /v=$RR_DESTFILEFMT_XML _
     /v=$RR_DESTFILEFMT_TXT _
     CS_RR RR_DESTFILEFMT

### CS_RSO     
DATA /v=$SO_CPRMT_NONE _
     /v=$SO_CPRMT_COMPRESSED _
     CS_RSO RSO_CPRMT

### CS_RSO     
DATA /v=$SO_DTATYPE_INVALID _
     /v=$SO_DTATYPE_GRAPHIC_FILE _
     CS_RSO RSO_DTATYPE

### CS_RTE     
DATA /v=$RTE_TYPE_INVALID _
     /v=$RTE_TYPE_CHART _
     /v=$RTE_TYPE_CHROMATOGRAM _
     /v=$RTE_TYPE_CRITERIA _
     /v=$RTE_TYPE_HEADER _
     /v=$RTE_TYPE_PAGE_BREAK _
     /v=$RTE_TYPE_REGRESSION _
     /v=$RTE_TYPE_SPECTRUM _
     /v=$RTE_TYPE_TABLE _
     CS_RTE RTE_TYPE

### CS_RTG
DATA /i /n='<none>' _
     /v=$PIC_TYPE_WMF _
     /v=$PIC_TYPE_BMP _
     CS_RTG RTG_PICFMT
     
### CS_RTS
DATA /v=$RTS_TYPE_INVALID _
     /v=$RTS_TYPE_PAGE_HEADER _
     /v=$RTS_TYPE_CONTAINER _
     /v=$RTS_TYPE_PAGE_BREAK _
     /v=$RTS_TYPE_PAGE_FOOTER _
     CS_RTS RTS_TYPE

### CS_SCP
DATA /v=$CS_UISV_DDT_ID _
     /v=$CS_RTS_DDT_ID _
     /v=$CS_RTE_DDT_ID _
     CS_SCP DDT_ID_SETTING

### CS_SCP     
DATA /v=$SCP_USAGE_UNSPECIFIED _
     /v=$SCP_USAGE_OVERALL_SUMMARY _
     /v=$SCP_USAGE_GROUP_SUMMARY _
     /v=$SCP_USAGE_REGRESSION_SUMMARY _
     CS_SCP SCP_USAGE

### CS_SP          
DATA /i /n='<none>' /v=$PIC_TYPE_WMF _
	 CS_SP SP_PICFMT

### CS_SP	 
DATA /v=$SP_EXTSID_APEX _
     /v=$SP_EXTSID_DOWNSLOPE _
     /v=$SP_EXTSID_UNSPECIFIED _
     /v=$SP_EXTSID_UPSLOPE _
     CS_SP SP_EXTSID

### CS_SP     
DATA /v=$SP_SPTSID_MASS _
     /v=$SP_SPTSID_UNSPECIFIED _
     /v=$SP_SPTSID_UV_VIS _
     CS_SP SP_SPTSID

### CS_SPP
DATA /v=$SPP_SMTSID_BLANK _
     /v=$SPP_SMTSID_CALIBRATION _
     /v=$SPP_SMTSID_CHECKOUT _
     /v=$SPP_SMTSID_SAMPLE _
     /v=$SPP_SMTSID_SEQ_CONTROL _
     /v=$SPP_SMTSID_UNSPECIFIED _
     CS_SPP SPP_SMTSID

### CS_TCM     
DATA /v=$TCM_QNTDTATSID_AREA _
     /v=$TCM_QNTDTATSID_HEIGHT _
     CS_TCM TCM_QNTDTATSID

### CS_UISF
DATA /v=$CS_UIS_DDT_ID _
     /v=$CS_RT_DDT_ID _
     /v=$CS_RTS_DDT_ID _
     /v=$CS_RTE_DDT_ID _
     CS_UISF DDT_ID_SETTING

### CS_UISF     
DATA /v=$UISF_FLDTYPE_INVALID _
     /v=$UISF_FLDTYPE_DATABASE _
     /v=$UISF_FLDTYPE_CUSTOM _
     /v=$UISF_FLDTYPE_CALCULATED _
     CS_UISF UISF_FLDTYPE

### CS_UISF
DATA /v=$UISF_CATEG_INVALID _
     /v=$UISF_CATEG_INTERNAL _
     /v=$UISF_CATEG_SAMPLE _
     /v=$UISF_CATEG_COMPOUND _
     /v=$UISF_CATEG_CUSTOM_FIELD _
     CS_UISF UISF_CATEG

### CS_UISF
DATA /v=$UISF_RPTCATEG_INVALID _
     /v=$UISF_RPTCATEG_INJ _
     /v=$UISF_RPTCATEG_RUN _
     /v=$UISF_RPTCATEG_SIGNAL _
     /v=$UISF_RPTCATEG_CPD _
     /v=$UISF_RPTCATEG_PK _
     /v=$UISF_RPTCATEG_COLCONFIG _
     /v=$UISF_RPTCATEG_INSTCOMP _
     /v=$UISF_RPTCATEG_ARCHLOG _
     /v=$UISF_RPTCATEG_AUDITTRAIL _
     /v=$UISF_RPTCATEG_BATCHREQ _
     /v=$UISF_RPTCATEG_RPT _
     /v=$UISF_RPTCATEG_RPTREQ _
     CS_UISF UISF_RPTCATEG

### CS_UISF     
DATA /v=$UISF_USAGE_INVALID _
     /v=$UISF_USAGE_AXIS _
     /v=$UISF_USAGE_COLUMN _
     /v=$UISF_USAGE_REPEAT _
     /v=$UISF_USAGE_SORT _
     /v=$UISF_USAGE_GROUP _
     /v=$UISF_USAGE_HEADER _
     /v=$UISF_USAGE_FILTER _
     /v=$UISF_USAGE_EMBEDDED _
     /v=$UISF_USAGE_POOL _
     /v=$UISF_USAGE_DESCFIELD _
     CS_UISF UISF_USAGE


### CS_UISF
DATA /v=$UISV_TYPE_INVALID _
     /v=$UISV_TYPE_TABLE_VIEW _
     /v=$UISV_TYPE_CHART_VIEW _
     /v=$UISV_TYPE_REVIEW _
     /v=$UISV_TYPE_TABLE_VIEW_REG _
     /v=$UISV_TYPE_CHART_VIEW_REG _
     /v=$UISV_TYPE_NOT_USED1 _
     /v=$UISV_TYPE_TABLE_VIEW_SUM _
     /v=$UISV_TYPE_CHART_VIEW_SUM _
     /v=$UISV_TYPE_NOT_USED2 _
     /v=$UISV_TYPE_CHART_VIEW_RES _
     /v=$UISV_TYPE_ARCHIVE_VIEW _
     /v=$UISV_TYPE_TABLE_VIEW_REG_GEN _
     /v=$UISV_TYPE_STAT_PARAM_SUM _
     /v=$UISV_TYPE_STAT_PARAM_REG _
     CS_UISV UISV_TYPE


