View source for CGS Constants list

= CGScript Constants List =

=== Search type constants ===

<source lang="sql">
NAME_SEARCH_TYPE_ANYWHERE
NAME_SEARCH_TYPE_END
NAME_SEARCH_TYPE_IDENTICAL
NAME_SEARCH_TYPE_START
</source>

=== Resource access constant ===

<source lang="sql">
RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR
</source>

=== Resource type constant ===

<source lang="sql">
Resource_Type_ResourceTemplate
Resource_Type_User
Resource_Type_Group
Resource_Type_ReportTemplate
Resource_Type_Project
Resource_Type_Folder
Resource_Type_QuestionnaireTemplate
Resource_Type_Attachment
Resource_Type_Questionnaire
Resource_Type_Report
Resource_Type_MessageTemplate
Resource_Type_Image
Resource_Type_Layout
Resource_Type_Product
Resource_Type_MessageFolder
Resource_Type_EmailAccount
Resource_Type_Diagram
Resource_Type_Asset
Resource_Type_WorkFlow
Resource_Type_QuestionnaireScript
Resource_Type_TabulationScript
Resource_Type_LayoutTemplate
Resource_Type_Coding
Resource_Type_Task
Resource_Type_System
Resource_Type_DataCacheSpecification
Resource_Type_TaskSet
Resource_Type_PaperQuestionnaire
Resource_Type_SampleRequest
Resource_Type_BulkMail
Resource_Type_Function
Resource_Type_DCSExport
Resource_Type_TestCase
Resource_Type_BulkSms
</source>

=== Resource access constant ===

<source lang="sql">
RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR
</source>

=== Task constant ===

<source lang="sql">
TASK_RESOURCE_ID
TASK_CASE_NUMBER
TASK_NAME
TASK_PARENT_RESOURCE_ID
TASK_TEMPLATE_RESOURCE_ID
TASK_TIME_REGISTRATION
TASK_COMPLETED
TASK_TESTCASE
TASK_RESPONSIBLE_RESOURCE_ID
TASK_SUPERVISOR_RESOURCE_ID
TASK_OBSERVER
TASK_OBSERVER_INHERIT_ACCESS
TASK_STATUS
TASK_ACCEPTANCE_DEADLINE
TASK_COMPLETION_DEADLINE
TASK_APPROVAL_DEADLINE
TASK_ACTUAL_START_DATE
TASK_ACTUAL_END_DATE
TASK_APPROVED_DATE
TASK_MAN_HOURS
TASK_DESCRIPTION
</source>

=== Task status constant ===

<source lang="sql">
TASK_STATUS_NEEDACCEPTANCE
TASK_STATUS_INPROGRESS
TASK_STATUS_APPROVED
TASK_STATUS_AWAITINGAPPROVAL
</source>

=== User constant ===

<source lang="sql">
USER_RESOURCE_ID
USER_NAME
USER_TEMPLATE_RESOURCE_ID
USER_PASSWORD
USER_TIME_REGISTRATION
USER_MAN_HOURS
USER_CALCULATED_MAN_HOURS
USER_PHONE_NUMBER
USER_ACCESS_EXPIRATION
USER_PROTECTED_UNTIL
USER_LANGUAGE
USER_CULTURE
USER_EMAIL
USER_FIRST_NAME
USER_MIDDLE_NAME
USER_LAST_NAME
USER_CURRENCY
USER_DISCOUNT
USER_POINT_BALANCE
USER_TIMEZONE
USER_ADDRESS
USER_CITY
USER_ZIPCODE
USER_REGION
USER_COUNTRY
USER_POSTBOX
USER_WEBSITE
USER_DELETED
USER_DISABLED
USER_MASK
</source>

=== Questionnaire constant ===

<source lang="sql">
QUESTIONNAIRE_OBJECT_TYPE
QUESTIONNAIRE_RESOURCE_ID
QUESTIONNAIRE_NAME
QUESTIONNAIRE_RESOURCE_TEMPLATE_RESOURCE_ID
QUESTIONNAIRE_PARENT_RESOURCE_ID
QUESTIONNAIRE_TEMPLATE_RESOURCE_ID
QUESTIONNAIRE_TIME_REGISTRATION
QUESTIONNAIRE_COMPLETED
QUESTIONNAIRE_DISPLAY_IN_MY_QUESTIONNAIRE
QUESTIONNAIRE_USE_OLD_VIEWER
QUESTIONNAIRE_ALIAS
QUESTIONNAIRE_LAYOUT_RESOURCE_ID
QUESTIONNAIRE_TIME_ESTIMATE
QUESTIONNAIRE_STATUS
QUESTIONNAIRE_TARGET
QUESTIONNAIRE_CATI_OUTCOME_SET
QUESTIONNAIRE_AUTOMATIC_RELEASE_DATE
QUESTIONNAIRE_DEVELOPMENT_START_DATE
QUESTIONNAIRE_AUTOMATIC_CLOSE_DATE
QUESTIONNAIRE_DEVELOPMENT_END_DATE
QUESTIONNAIRE_MAN_HOURS
QUESTIONNAIRE_DESCRIPTION
</source>

=== CATI CGS constant ===

<source lang="sql">
CATI_OBJECT_TYPE
CATI_CONTACT_ID
CATI_CONTACT_INTERVIEWER_USER_RESOURCE_ID
CATI_CONTACT_START_DATE
CATI_CONTACT_END_DATE
CATI_CONTACT_OUTCOME_STATUS_ID
CATI_CONTACT_OUTCOME_STATUS_AS_TEXT
CATI_CONTACT_DESCRIPTION
</source>

=== CATI list type constant ===

<source lang="sql">
CATI_MAIN
CATI_ONGOING
CATI_APPOINTMENT 
CATI_FINISHED 
CATI_RETRY 
</source>

=== QAS constant ===

<source lang="sql">
QAS_OBJECT_TYPE
QAS_ID
QAS_QUESTIONNAIRE_RESOURCE_ID
QAS_USER_RESOURCE_ID
QAS_TEST
QAS_STATUS
QAS_COMPLETED
QAS_STARTDATE
QAS_ENDDATE
QAS_GUID
QAS_CATI_APPOINTMENT
QAS_CATI_LIST_TYPE
QAS_CATI_TIMES_CALLED
</source>

=== Project constant ===

<source lang="sql">
PROJECT_RESOURCE_ID
PROJECT_NAME
PROJECT_TEMPLATE_RESOURCE_ID
PROJECT_TIME_REGISTRATION
PROJECT_COMPLETED
PROJECT_PARENT_RESOURCE_ID
PROJECT_CODE
PROJECT_PROPOSE_CODE
PROJECT_CLIENT_REF_NO
PROJECT_TIME_BUDGET
PROJECT_CALCULATED_MAN_HOURS
PROJECT_PLANNED_START_DATE
PROJECT_ACTUAL_START_DATE
PROJECT_PLANNED_END_DATE
PROJECT_ACTUAL_END_DATE
</source>

=== Bulk mail constant ===

<source lang="sql">
BULKMAIL_OBJECT
BULKMAIL_NAME
BULKMAIL_PARENT_RESOURCE_ID
BULKMAIL_MAIL_TEMPLTE_ID
BULKMAIL_TEMPLATE_RESOURCE_ID
</source>

=== Group constant ===

<source lang="sql">
GROUP_RESOURCE_ID
GROUP_NAME
GROUP_TEMPLATE_RESOURCE_ID
GROUP_PARENT_RESOURCE_ID
GROUP_TIME_REGISTRATION
GROUP_MAN_HOURS
GROUP_CALCULATED_MAN_HOURS
</source>

=== Folder constant ===

<source lang="sql">
FOLDER_RESOURCE_ID
FOLDER_NAME
FOLDER_PARENT_RESOURCE_ID
FOLDER_TEMPLATE_RESOURCE_ID
FOLDER_TIME_REGISTRATION
FOLDER_TIME_BUDGET
FOLDER_MAN_HOURS
FOLDER_DESCRIPTION
</source>

=== Data cache - custom column constant ===

<source lang="sql">
CUSTOM_COLUMN_TYPE_NUMBER
CUSTOM_COLUMN_TYPE_BOOLEAN
CUSTOM_COLUMN_TYPE_STRING
CUSTOM_COLUMN_DATA_TYPE
CUSTOM_COLUMN_TEXT
CUSTOM_COLUMN_NAME
CUSTOM_COLUMN_OPTIONS
CUSTOM_COLUMN_OPTION_EXPRESSION
CUSTOM_COLUMN_OPTION_VALUE
CUSTOM_COLUMN_OPTION_TEXT
</source>

=== Ledger entry constant ===

<source lang="sql">
LEDGER_ENTRY_ID
LEDGER_RESOURCE_ID
LEDGER_ENTRY_NAME
LEDGER_ENTRY_DESCRIPTION
LEDGER_ENTRY_UNIT
LEDGER_ENTRY_COST
LEDGER_ENTRY_CURRENCY_ID
LEDGER_ENTRY_EXCHANGE_RATE
LEDGER_ENTRY_AMOUNT_SELECTED_CURRENCY
LEDGER_ENTRY_AMOUNT_DEFAULT_CURRENCY
</source>

=== Invoice constant ===

<source lang="sql">
INVOICE_RESOURCE_ID
INVOICE_PART
INVOICE_PARENT_RESOURCE_ID
INVOICE_TEMPLATE_RESOURCE_ID
INVOICE_SUBMITTED
INVOICE_REVENUE_TYPE
INVOICE_CUSTOMER
INVOICE_REPRESENTATIVE
INVOICE_ADDRESS_TO
INVOICE_EARNER
INVOICE_REFERENCE
INVOICE_INVOICE_DATE
INVOICE_DUE_DATE
INVOICE_PAID_DATE
INVOICE_SUBMITTED_DATE
INVOICE_LEDGER
INVOICE_TOTAL
// Address to constant
INVOICE_CUSTOMER
INVOICE_REPRESENTATIVE
</source>

=== Diagrams constants ===

<source lang="sql">
Diagram_ShowModeType_Percentage
Diagram_ShowModeType_Absolute
Diagram_ShowModeType_Both
Diagram_ChartType_Table
Diagram_ChartType_Line
Diagram_ChartType_Bar
Diagram_ChartType_Pie
Diagram_ChartType_Radar
// Direction Type
Diagram_DirectionType_Vertical
Diagram_DirectionType_Horizontal
// Back Plane Style
Diagram_BackPlaneStyle_Rectangle
Diagram_BackPlaneStyle_Ellipse
Diagram_BackPlaneStyle_Circle
Diagram_BackPlaneStyle_CutEdgeRectangle
Diagram_BackPlaneStyle_SmoothEdgeRectangle
Diagram_BackPlaneStyle_NotSet
// Fill Type 
Diagram_FillType_NoFill
Diagram_FillType_SolidFill
// HAlignment
Diagram_HAlignment_Center
Diagram_HAlignment_Left
Diagram_HAlignment_Right
Diagram_HAlignment_NotSet
// VAlignment
Diagram_VAlignment_Center
Diagram_VAlignment_Top
Diagram_VAlignment_Bottom
Diagram_VAlignment_NotSet
// Visibility
Diagram_Visibility_True
Diagram_Visibility_Visible
Diagram_Visibility_NotVisible
Diagram_Visibility_False
Diagram_Visibility_NotSet
// Fill constant
DIAGRAM_FILL_STYLE_COLOR
DIAGRAM_FILL_STYLE_TYPE
DIAGRAM_FILL_STYLE_INHERIT
// Font constant
DIAGRAM_FONT_STYLE_FACE
DIAGRAM_FONT_STYLE_SIZE
DIAGRAM_FONT_STYLE_COLOR
DIAGRAM_FONT_STYLE_BOLD
DIAGRAM_FONT_STYLE_ITALIC
DIAGRAM_FONT_STYLE_UNDERLINE
DIAGRAM_FONT_STYLE_INHERIT
</source>

=== Diagrams Known Color constants ===

<source lang="sql">
Diagram_KnownColor_ActiveBorder
Diagram_KnownColor_ActiveCaption
Diagram_KnownColor_ActiveCaptionText
Diagram_KnownColor_AppWorkspace
Diagram_KnownColor_Control
Diagram_KnownColor_ControlDark
Diagram_KnownColor_ControlDarkDark
Diagram_KnownColor_ControlLight
Diagram_KnownColor_ControlLightLight
Diagram_KnownColor_ControlText
Diagram_KnownColor_Desktop
Diagram_KnownColor_GrayText
Diagram_KnownColor_Highlight
Diagram_KnownColor_HighlightText
Diagram_KnownColor_HotTrack
Diagram_KnownColor_InactiveBorder
Diagram_KnownColor_InactiveCaption
Diagram_KnownColor_InactiveCaptionText
Diagram_KnownColor_Info
Diagram_KnownColor_InfoText
Diagram_KnownColor_Menu
Diagram_KnownColor_MenuText
Diagram_KnownColor_ScrollBar
Diagram_KnownColor_Window
Diagram_KnownColor_WindowFrame
Diagram_KnownColor_WindowText
Diagram_KnownColor_Transparent
Diagram_KnownColor_AliceBlue
Diagram_KnownColor_AntiqueWhite
Diagram_KnownColor_Aqua
Diagram_KnownColor_Aquamarine
Diagram_KnownColor_Azure
Diagram_KnownColor_Beige
Diagram_KnownColor_Bisque
Diagram_KnownColor_Black
Diagram_KnownColor_BlanchedAlmond
Diagram_KnownColor_Blue
Diagram_KnownColor_BlueViolet
Diagram_KnownColor_Brown
Diagram_KnownColor_BurlyWood
Diagram_KnownColor_CadetBlue
Diagram_KnownColor_Chartreuse
Diagram_KnownColor_Chocolate
Diagram_KnownColor_Coral
Diagram_KnownColor_CornflowerBlue
Diagram_KnownColor_Cornsilk
Diagram_KnownColor_Crimson
Diagram_KnownColor_Cyan
Diagram_KnownColor_DarkBlue
Diagram_KnownColor_DarkCyan
Diagram_KnownColor_DarkGoldenrod
Diagram_KnownColor_DarkGray
Diagram_KnownColor_DarkGreen
Diagram_KnownColor_DarkKhaki
Diagram_KnownColor_DarkMagenta
Diagram_KnownColor_DarkOliveGreen
Diagram_KnownColor_DarkOrange
Diagram_KnownColor_DarkOrchid
Diagram_KnownColor_DarkRed
Diagram_KnownColor_DarkSalmon
Diagram_KnownColor_DarkSeaGreen
Diagram_KnownColor_DarkSlateBlue
Diagram_KnownColor_DarkSlateGray
Diagram_KnownColor_DarkTurquoise
Diagram_KnownColor_DarkViolet
Diagram_KnownColor_DeepPink
Diagram_KnownColor_DeepSkyBlue
Diagram_KnownColor_DimGray
Diagram_KnownColor_DodgerBlue
Diagram_KnownColor_Firebrick
Diagram_KnownColor_FloralWhite
Diagram_KnownColor_ForestGreen
Diagram_KnownColor_Fuchsia
Diagram_KnownColor_Gainsboro
Diagram_KnownColor_GhostWhite
Diagram_KnownColor_Gold
Diagram_KnownColor_Goldenrod
Diagram_KnownColor_Gray
Diagram_KnownColor_Green
Diagram_KnownColor_GreenYellow
Diagram_KnownColor_Honeydew
Diagram_KnownColor_HotPink
Diagram_KnownColor_IndianRed
Diagram_KnownColor_Indigo
Diagram_KnownColor_Ivory
Diagram_KnownColor_Khaki
Diagram_KnownColor_Lavender
Diagram_KnownColor_LavenderBlush
Diagram_KnownColor_LawnGreen
Diagram_KnownColor_LemonChiffon
Diagram_KnownColor_LightBlue
Diagram_KnownColor_LightCoral
Diagram_KnownColor_LightCyan
Diagram_KnownColor_LightGoldenrodYellow
Diagram_KnownColor_LightGray
Diagram_KnownColor_LightGreen
Diagram_KnownColor_LightPink
Diagram_KnownColor_LightSalmon
Diagram_KnownColor_LightSeaGreen
Diagram_KnownColor_LightSkyBlue
Diagram_KnownColor_LightSlateGray
Diagram_KnownColor_LightSteelBlue
Diagram_KnownColor_LightYellow
Diagram_KnownColor_Lime
Diagram_KnownColor_LimeGreen
Diagram_KnownColor_Linen
Diagram_KnownColor_Magenta
Diagram_KnownColor_Maroon
Diagram_KnownColor_MediumAquamarine
Diagram_KnownColor_MediumBlue
Diagram_KnownColor_MediumOrchid
Diagram_KnownColor_MediumPurple
Diagram_KnownColor_MediumSeaGreen
Diagram_KnownColor_MediumSlateBlue
Diagram_KnownColor_MediumSpringGreen
Diagram_KnownColor_MediumTurquoise
Diagram_KnownColor_MediumVioletRed
Diagram_KnownColor_MidnightBlue
Diagram_KnownColor_MintCream
Diagram_KnownColor_MistyRose
Diagram_KnownColor_Moccasin
Diagram_KnownColor_NavajoWhite
Diagram_KnownColor_Navy
Diagram_KnownColor_OldLace
Diagram_KnownColor_Olive
Diagram_KnownColor_OliveDrab
Diagram_KnownColor_Orange
Diagram_KnownColor_OrangeRed
Diagram_KnownColor_Orchid
Diagram_KnownColor_PaleGoldenrod
Diagram_KnownColor_PaleGreen
Diagram_KnownColor_PaleTurquoise
Diagram_KnownColor_PaleVioletRed
Diagram_KnownColor_PapayaWhip
Diagram_KnownColor_PeachPuff
Diagram_KnownColor_Peru
Diagram_KnownColor_Pink
Diagram_KnownColor_Plum
Diagram_KnownColor_PowderBlue
Diagram_KnownColor_Purple
Diagram_KnownColor_Red
Diagram_KnownColor_RosyBrown
Diagram_KnownColor_RoyalBlue
Diagram_KnownColor_SaddleBrown
Diagram_KnownColor_Salmon
Diagram_KnownColor_SandyBrown
Diagram_KnownColor_SeaGreen
Diagram_KnownColor_SeaShell
Diagram_KnownColor_Sienna
Diagram_KnownColor_Silver
Diagram_KnownColor_SkyBlue
Diagram_KnownColor_SlateBlue
Diagram_KnownColor_SlateGray
Diagram_KnownColor_Snow
Diagram_KnownColor_SpringGreen
Diagram_KnownColor_SteelBlue
Diagram_KnownColor_Tan
Diagram_KnownColor_Teal
Diagram_KnownColor_Thistle
Diagram_KnownColor_Tomato
Diagram_KnownColor_Turquoise
Diagram_KnownColor_Violet
Diagram_KnownColor_Wheat
Diagram_KnownColor_White
Diagram_KnownColor_WhiteSmoke
Diagram_KnownColor_Yellow
Diagram_KnownColor_YellowGreen
Diagram_KnownColor_ButtonFace
Diagram_KnownColor_ButtonHighlight
Diagram_KnownColor_ButtonShadow
Diagram_KnownColor_GradientActiveCaption
Diagram_KnownColor_GradientInactiveCaption
Diagram_KnownColor_MenuBar
Diagram_KnownColor_MenuHighlight
</source>

=== Table Diagram constants ===

<source lang="sql">
TableDiagram_AllTable
TableDiagram_ColumnHeader
TableDiagram_ColumnHeaderLevel1
TableDiagram_ColumnHeaderLevel2
TableDiagram_ColumnHeaderLevel3
TableDiagram_RowHeader
TableDiagram_RowHeaderLevel1
TableDiagram_RowHeaderLevel2
TableDiagram_RowHeaderLevel3
TableDiagram_AbsoluteColumn
TableDiagram_AbsoluteColumnHeader
TableDiagram_AbsoluteColumnValue
TableDiagram_PercentageColumn
TableDiagram_PercentageColumnHeader
TableDiagram_PercentageColumnValue
TableDiagram_TotalColumn
TableDiagram_TotalColumnHeader
TableDiagram_TotalColumnValue
TableDiagram_TotalRow
TableDiagram_TotalRowHeader
TableDiagram_TotalRowValue
TableDiagram_AnswerRow
TableDiagram_AnswerRowAlternate
TableDiagram_VarianceRow
TableDiagram_VarianceRowHeader
TableDiagram_VarianceRowValue
TableDiagram_AverageRow
TableDiagram_AverageRowHeader
TableDiagram_AverageRowValue
TableDiagram_StdDevRow
TableDiagram_StdDevRowHeader
TableDiagram_StdDevRowValue
TableDiagram_StdErrorRow
TableDiagram_StdErrorRowHeader
TableDiagram_StdErrorRowValue
TableDiagram_MedianRow
TableDiagram_MedianRowHeader
TableDiagram_MedianRowValue
TableDiagram_QuantilesRow
TableDiagram_QuantilesRowHeader
TableDiagram_QuantilesRowValue
TableDiagram_PercentileRow
TableDiagram_PercentileRowHeader
TableDiagram_PercentileRowValue
TableDiagram_SignificanceRow
TableDiagram_SignificanceRowHeader
TableDiagram_SignificanceRowValue
TableDiagram_CountAnswerRow
TableDiagram_CountAnswerRowHeader
TableDiagram_CountAnswerRowValue
TableDiagram_TotalRespondentRow
TableDiagram_TotalRespondentRowHeader
TableDiagram_TotalRespondentRowValue
TableDiagram_WeightRow
TableDiagram_WeightRowHeader
TableDiagram_WeightRowValue
TableDiagram_QuestionHeader
</source>

=== Table Diagram style constants ===

<source lang="sql">
TABLE_DIAGRAM_STYLE_FILL,
TABLE_DIAGRAM_STYLE_DECIMAL
TABLE_DIAGRAM_STYLE_FONT
TABLE_DIAGRAM_STYLE_VALIGN
TABLE_DIAGRAM_STYLE_HALIGN
TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER
TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER
TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER
TABLE_DIAGRAM_STYLE_BORDER_STYLE
</source><br/>Back to [[DATA]] page