# ==========================================================
# OQ Tool working scripts
#
# DB consistency check - common constants
# ==========================================================
DEF PIC_TYPE_WMF WMF
DEF PIC_TYPE_BMP BMP
#DEF CS_AC_DDT_ID        153
#DEF CS_AT_DDT_ID        104
#DEF CS_BL_DDT_ID        106
#DEF CS_BR_DDT_ID        107
#DEF CS_BR_RN_DDT_ID     105
#DEF CS_CC_DDT_ID        169
#DEF CS_CCM_DDT_ID       108
#DEF CS_CCR_DDT_ID       109
#DEF CS_CFA_DDT_ID       110
#DEF CS_CFS_DDT_ID       111
#DEF CS_CFV_DDT_ID       112
#DEF CS_CG_DDT_ID        113
#DEF CS_CP_DDT_ID        114
#DEF CS_DDF_DDT_ID       124
#DEF CS_DDT_DDT_ID       125
DEF CS_FL_DDT_ID         116
#DEF CS_IC_DDT_ID        117
#DEF CS_ICC_DDT_ID       118
#DEF CS_INJ_DDT_ID       119
#DEF CS_INJ_CC_DDT_ID    170
#DEF CS_MT_DDT_ID        120
#DEF CS_PK_DDT_ID        122
#DEF CS_PP_DDT_ID        123
DEF CS_QY_DDT_ID         128
#DEF CS_RD_DDT_ID        129
#DEF CS_RN_DDT_ID        131
#DEF CS_RNG_DDT_ID       132
#DEF CS_RR_DDT_ID        152
#DEF CS_RR_RN_DDT_ID     133
DEF CS_RT_DDT_ID         134
DEF CS_RTE_DDT_ID        178
#DEF CS_RTG_DDT_ID       186
DEF CS_RTS_DDT_ID        177
#DEF CS_SCP_DDT_ID       184
#DEF CS_SM_DDT_ID        137
#DEF CS_SO_DDT_ID        136
#DEF CS_SP_DDT_ID        138
#DEF CS_SPP_DDT_ID       139
#DEF CS_SQ_DDT_ID        140
#DEF CS_TCM_DDT_ID       141
#DEF CS_TCR_DDT_ID       142
#DEF CS_TS_DDT_ID        161
DEF CS_UIE_DDT_ID        143
DEF CS_UIS_DDT_ID        144
#DEF CS_UISF_DDT_ID      147
#DEF CS_UISF_SCP_DDT_ID  185
DEF CS_UISV_DDT_ID       148
#DEF CS_UISV_UISF_DDT_ID 149
#DEF CS_US_DDT_ID        150
#DEF CS_DUMMY_DDT_ID     100
#DEF CS_CT_DDT_ID        219
#DEF CS_CTV_DDT_ID       220


DEF AD_TYPE_INVALID     0
DEF AD_TYPE_BACKGROUND  1
DEF AD_TYPE_INTERACTIVE 2
DEF AD_TYPE_SPOOLER     3

DEF AQ_FREQTSID_DAILY   544
DEF AQ_FREQTSID_MONTHLY 545
DEF AQ_FREQTSID_WEEKLY  546

DEF AR_TSID_AUTOMATED_ARCHIVE 547
DEF AR_TSID_MANUAL_ARCHIVE    548

DEF AT_TSID_ADDED_TO_BATCH_REQUEST      500
DEF AT_TSID_ARCHIVED                    249
DEF AT_TSID_DEARCHIVED                  250
DEF AT_TSID_DELETED_FROM_BATCH_REQUEST  510
DEF AT_TSID_EDIT_CUSTOM_FIELD           246
DEF AT_TSID_LOADED_AS_PART_OF_BATCH     531
DEF AT_TSID_LOADED_AS_PART_OF_SEQUENCE  532
DEF AT_TSID_LOADED_TO_DISK              533
DEF AT_TSID_NEW                         251
DEF AT_TSID_READ_ONLY                   254
DEF AT_TSID_REOPEN                      234
DEF AT_TSID_REPROCESSED_IN_BATCH_REVIEW 519
DEF AT_TSID_SAMPLE_NAME_CHANGED         253
DEF AT_TSID_STATUS_CHANGED              252
DEF AT_TSID_STUDY_CHANGED               539

DEF CC_DEADVOLUNITTSID_PCT      201
DEF CC_DEADVOLUNITTSID_NONE_BKT 255
DEF CC_DEADVOLUNITTSID_MIN      226
DEF CC_DEADVOLUNITTSID_ML       227

DEF CCM_CALCTSID_MEAN      225
DEF CCM_CALCTSID_SUM       238
DEF CCM_CALCTSID_UNDEFINED 241

DEF CCM_CALCMTTSID_GROUP_AMOUNT_CALIBRATION 214
DEF CCM_CALCMTTSID_NO_CALIBRATION           228

DEF CFA_FILLTYPE_INVALID 0
DEF CFA_FILLTYPE_USER    1
DEF CFA_FILLTYPE_EXPR    2
DEF CFA_FILLTYPE_SYSTEM  3

DEF CFS_USETYPE_CHEMSTORE      0
DEF CFS_USETYPE_VALIDATHIDDEN  1
DEF CFS_USETYPE_VALIDATPROTECT 2
DEF CFS_USETYPE_VALIDATEDIT    3
DEF CFS_USETYPE_SYSTEMHIDDEN   4
DEF CFS_USETYPE_SYSTEMPROTECT  5
DEF CFS_USETYPE_SYSTEMEDIT     6

DEF CFS_VALTYPE_INVALID   0
DEF CFS_VALTYPE_BOOL      1
DEF CFS_VALTYPE_ENUM      2
DEF CFS_VALTYPE_INTEGER   3
DEF CFS_VALTYPE_REAL      4
DEF CFS_VALTYPE_STRING    5
DEF CFS_VALTYPE_DATE_TIME 6

DEF CP_TYPETSID_GROUP    247
DEF CP_TYPETSID_PEAK_SUM 248
DEF CP_TYPETSID_TARGET   239
DEF CP_TYPETSID_UNKNOWN  242

DEF CPI_TYPE_INVALID           0
DEF CPI_TYPE_SIMPLE_STAT       1
DEF CPI_TYPE_REGRESSION_STAT   2
DEF CPI_TYPE_REGRESSION_CURVE  3
DEF CPI_TYPE_REGRESSION_ORIGIN 4
DEF CPI_TYPE_REGRESSION_WEIGHT 5

DEF DDF_CATEG_INVALID      0
DEF DDF_CATEG_INTERNAL     1
DEF DDF_CATEG_SAMPLE       2
DEF DDF_CATEG_COMPOUND     3
DEF DDF_CATEG_CUSTOM_FIELD 4
DEF DDF_CATEG_REPORT_ONLY  5

DEF DDF_DEFALIGN_INVALID 0
DEF DDF_DEFALIGN_LEFT    1
DEF DDF_DEFALIGN_RIGHT   2
DEF DDF_DEFALIGN_CENTER  3

DEF DDF_DTATYPE_INVALID 0
DEF DDF_DTATYPE_BOOL    1
DEF DDF_DTATYPE_SHORT   2
DEF DDF_DTATYPE_LONG    3
DEF DDF_DTATYPE_REAL    4
DEF DDF_DTATYPE_STR     5
DEF DDF_DTATYPE_LSTR    6
DEF DDF_DTATYPE_BLOB    7
DEF DDF_DTATYPE_DATE    8
DEF DDF_DTATYPE_GUID    9
DEF DDF_DTATYPE_PAGE    10
DEF DDF_DTATYPE_VIRTUAL 11
DEF DDF_DTATYPE_YESNO   12

DEF DS_LOCKTYPE_PRIVATELY    0
DEF DS_LOCKTYPE_NONPRIVATELY 1

DEF INJ_TSID_BLANK    207
DEF INJ_TSID_EXTERNAL 212
DEF INJ_TSID_INJ_PROG 258
DEF INJ_TSID_MANUAL   223
DEF INJ_TSID_NORMAL   231
DEF INJ_TSID_UNKNOWN  242

DEF INJ_CC_POSTSID_FRONT   213
DEF INJ_CC_POSTSID_LEFT    221
DEF INJ_CC_POSTSID_REAR    233
DEF INJ_CC_POSTSID_RIGHT   235
DEF INJ_CC_POSTSID_UNKNOWN 242

DEF LB_RSNTSID_ACCOUNT_LOCKED 540
DEF LB_RSNTSID_APPROVED_RUNS 501
DEF LB_RSNTSID_ARCHIVED_RUNS 502
DEF LB_RSNTSID_ARCHIVED_RUNS_WITH_DELETE 503
DEF LB_RSNTSID_ASSIGN_STUDY_TO_USER 537
DEF LB_RSNTSID_CHANGED_PASSWORD 504
DEF LB_RSNTSID_CLEARED_PASSWORD 507
DEF LB_RSNTSID_CREATED_BATCH 534
DEF LB_RSNTSID_CREATED_NEW_USER 508
DEF LB_RSNTSID_DEARCHIVED_RUNS 509
DEF LB_RSNTSID_DEASSIGN_STUDY_FROM_USER 538
DEF LB_RSNTSID_DELETED_ARCHIVE_DEARCHIVE_REQUEST 535
DEF LB_RSNTSID_DELETED_PENDING_BATCH 536
DEF LB_RSNTSID_DELETED_RUNS 511
DEF LB_RSNTSID_DELETED_SPOOLER_JOBS 527
DEF LB_RSNTSID_EDIT_CUSTOM_FIELDS 512
DEF LB_RSNTSID_EMAIL_NOTIFICATION 541
DEF LB_RSNTSID_FAILED_TO_LOG_ON 513
DEF LB_RSNTSID_LOGGED_OFF 514
DEF LB_RSNTSID_MIGRATED_DATA 515
DEF LB_RSNTSID_MODIFIED_ARCHIVE 525
DEF LB_RSNTSID_MODIFIED_ARCHIVE_WITH_DELETE 526
DEF LB_RSNTSID_MODIFIED_PERMISSIONS 516
DEF LB_RSNTSID_PRIVATE_LOCK_CRACKED 554
DEF LB_RSNTSID_REJECTED_RUNS 517
DEF LB_RSNTSID_REOPENED_RUNS 518
DEF LB_RSNTSID_SESSION_LOCKED 528
DEF LB_RSNTSID_SESSION_UNLOCKED 529
DEF LB_RSNTSID_SUCCESSFULLY_LOGGED_ON 522
DEF LB_RSNTSID_SUCCESSFULLY_LOGGED_ON_AS_MANAGER 523
DEF LB_RSNTSID_SUCCESSFULLY_LOGGED_ON_AS_OPERATOR 524
DEF LB_RSNTSID_UPDATED_DATABASE_SCHEMA 530
DEF LB_RSNTSID_USER_DEACTIVATED 553
DEF LB_RSNTSID_USER_REACTIVATED 555
DEF LB_RSNTSID_USER_DISPLAY_NAME_CHANGED 556
DEF LB_RSNTSID_CREATED_NEW_VERSION_OF_CALCULATION_TEMPLATE 557
DEF LB_RSNTSID_CREATED_CALCULATION_TEMPLATE 558

DEF MT_QNTTSID_AREA_PCT   206
DEF MT_QNTTSID_ESTD       211
DEF MT_QNTTSID_ESTD_PCT   256
DEF MT_QNTTSID_HEIGHT_PCT 216
DEF MT_QNTTSID_ISTD       220
DEF MT_QNTTSID_ISTD_PCT   257
DEF MT_QNTTSID_NORM_PCT   230
DEF MT_QNTTSID_UNKNOWN    242

DEF PK_CALPKTSID_IGNORE    217
DEF PK_CALPKTSID_MAIN      222
DEF PK_CALPKTSID_NONE      229
DEF PK_CALPKTSID_QUALIFIER 232

DEF RNG_USETYPE_INVALID        0
DEF RNG_USETYPE_CHEMSTORESTUDY 1
DEF RNG_USETYPE_VALIDATSTUDY   2

DEF RR_DESTFILEFMT_INVALID 0
DEF RR_DESTFILEFMT_HTML    1
DEF RR_DESTFILEFMT_CSV     2
DEF RR_DESTFILEFMT_XML     3
DEF RR_DESTFILEFMT_TXT     4

DEF RR_DESTTYPE_INVALID       0
DEF RR_DESTTYPE_PRINTER       1
DEF RR_DESTTYPE_FILE          2
DEF RR_DESTTYPE_SCREEN        3
DEF RR_DESTTYPE_PRINT_PREVIEW 4

DEF RTE_TYPE_INVALID      0
DEF RTE_TYPE_CHART        1
DEF RTE_TYPE_CHROMATOGRAM 2
DEF RTE_TYPE_CRITERIA     3
DEF RTE_TYPE_HEADER       4
DEF RTE_TYPE_PAGE_BREAK   5
DEF RTE_TYPE_REGRESSION   6
DEF RTE_TYPE_SPECTRUM     7
DEF RTE_TYPE_TABLE        8

DEF RTS_TYPE_INVALID     0
DEF RTS_TYPE_PAGE_HEADER 1
DEF RTS_TYPE_CONTAINER   2
DEF RTS_TYPE_PAGE_BREAK  3
DEF RTS_TYPE_PAGE_FOOTER 4

DEF SCP_USAGE_UNSPECIFIED        0
DEF SCP_USAGE_OVERALL_SUMMARY    1
DEF SCP_USAGE_GROUP_SUMMARY      2
DEF SCP_USAGE_REGRESSION_SUMMARY 3

DEF SO_CPRMT_NONE       0
DEF SO_CPRMT_COMPRESSED 1

DEF SO_DTATYPE_INVALID      0
DEF SO_DTATYPE_RD_FILE      1
DEF SO_DTATYPE_MT_FILE      2
DEF SO_DTATYPE_SQ_FILE      3
DEF SO_DTATYPE_GLP_FILE     4
DEF SO_DTATYPE_CG_PICTURE   5
DEF SO_DTATYPE_SP_PICTURE   6
DEF SO_DTATYPE_GRAPHIC_FILE 7

DEF SP_EXTSID_APEX        203
DEF SP_EXTSID_DOWNSLOPE   210
DEF SP_EXTSID_UNSPECIFIED 243
DEF SP_EXTSID_UPSLOPE     244

DEF SP_SPTSID_MASS        224
DEF SP_SPTSID_UNSPECIFIED 243
DEF SP_SPTSID_UV_VIS      245

DEF SPP_SMTSID_BLANK       207
DEF SPP_SMTSID_CALIBRATION 208
DEF SPP_SMTSID_CHECKOUT    209
DEF SPP_SMTSID_SAMPLE      236
DEF SPP_SMTSID_SEQ_CONTROL 237
DEF SPP_SMTSID_UNSPECIFIED 243

DEF TCM_QNTDTATSID_AREA   205
DEF TCM_QNTDTATSID_HEIGHT 215

DEF UIS_TYPE_INVALID    0
DEF UIS_TYPE_SP_REVIEW  1
DEF UIS_TYPE_CPD_REVIEW 2

DEF UISF_CATEG_INVALID      0
DEF UISF_CATEG_INTERNAL     1
DEF UISF_CATEG_SAMPLE       2
DEF UISF_CATEG_COMPOUND     3
DEF UISF_CATEG_CUSTOM_FIELD 4

DEF UISF_FLDTYPE_INVALID    0
DEF UISF_FLDTYPE_DATABASE   1
DEF UISF_FLDTYPE_CUSTOM     2
DEF UISF_FLDTYPE_CALCULATED 3
DEF UISF_FLDTYPE_CUSTCALC   4

DEF UISF_RPTCATEG_INVALID    0
DEF UISF_RPTCATEG_INJ        1
DEF UISF_RPTCATEG_RUN        2
DEF UISF_RPTCATEG_SIGNAL     3
DEF UISF_RPTCATEG_CPD        4
DEF UISF_RPTCATEG_PK         5
DEF UISF_RPTCATEG_COLCONFIG  6
DEF UISF_RPTCATEG_INSTCOMP   7
DEF UISF_RPTCATEG_ARCHLOG    8
DEF UISF_RPTCATEG_AUDITTRAIL 9
DEF UISF_RPTCATEG_BATCHREQ   10
DEF UISF_RPTCATEG_RPT        11
DEF UISF_RPTCATEG_RPTREQ     12

DEF UISF_USAGE_INVALID   0
DEF UISF_USAGE_AXIS      1
DEF UISF_USAGE_COLUMN    2
DEF UISF_USAGE_REPEAT    3
DEF UISF_USAGE_SORT      4
DEF UISF_USAGE_GROUP     5
DEF UISF_USAGE_HEADER    6
DEF UISF_USAGE_FILTER    7
DEF UISF_USAGE_EMBEDDED  8
DEF UISF_USAGE_POOL      9
DEF UISF_USAGE_DESCFIELD 10

DEF UISV_TYPE_INVALID            0
DEF UISV_TYPE_TABLE_VIEW         1
DEF UISV_TYPE_CHART_VIEW         2
DEF UISV_TYPE_REVIEW             3
DEF UISV_TYPE_TABLE_VIEW_REG     4
DEF UISV_TYPE_CHART_VIEW_REG     5
DEF UISV_TYPE_NOT_USED1          6
DEF UISV_TYPE_TABLE_VIEW_SUM     7
DEF UISV_TYPE_CHART_VIEW_SUM     8
DEF UISV_TYPE_NOT_USED2          9
DEF UISV_TYPE_CHART_VIEW_RES     10
DEF UISV_TYPE_ARCHIVE_VIEW       11
DEF UISV_TYPE_TABLE_VIEW_REG_GEN 12
DEF UISV_TYPE_STAT_PARAM_SUM     13
DEF UISV_TYPE_STAT_PARAM_REG     14

