Toggle search
Toggle menu
862
3.8K
30.2K
279.1K
Catglobe Wiki
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

CGS Constants list: Difference between revisions

From Catglobe Wiki
More actions
← Older edit
VisualWikitext
No edit summary
No edit summary
 
(37 intermediate revisions by 4 users not shown)
Line 1: Line 1:
=== Search type constants ===  
= CGScript Constants List =
 
=== Search type constants ===
 
<source lang="sql">
<source lang="sql">
NAME_SEARCH_TYPE_ANYWHERE
NAME_SEARCH_TYPE_ANYWHERE
Line 7: Line 10:
</source>
</source>


=== Resource access constant ===
<source lang="sql">
RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR
</source>
=== Resource type constant ===


=== Resource type constant ===
<source lang="sql">
<source lang="sql">
Resource_Type_ResourceTemplate
Resource_Type_ResourceTemplate
Line 46: Line 57:
</source>
</source>


=== Resource access constant ===  
=== Resource access constant ===
 
<source lang="sql">
<source lang="sql">
RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_OBSERVER
Line 52: Line 64:
RESOURCE_ACCESS_ADMINISTRATOR
RESOURCE_ACCESS_ADMINISTRATOR
</source>
</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>
=== QuestionnaireStatus constant ===
<source lang="sql">
QUESTIONNAIRE_STATUS_CLOSED: 1
QUESTIONNAIRE_STATUS_PAUSED: 2
QUESTIONNAIRE_STATUS_ACTIVE: 3
QUESTIONNAIRE_STATUS_OPEN_FOR_TEST: 4
</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
[[Category:Functions]]

Latest revision as of 04:23, 18 March 2022

CGScript Constants List

Search type constants

NAME_SEARCH_TYPE_ANYWHERE
NAME_SEARCH_TYPE_END
NAME_SEARCH_TYPE_IDENTICAL
NAME_SEARCH_TYPE_START

Resource access constant

RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR

Resource type constant

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

Resource access constant

RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR

Task constant

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

Task status constant

TASK_STATUS_NEEDACCEPTANCE
TASK_STATUS_INPROGRESS
TASK_STATUS_APPROVED
TASK_STATUS_AWAITINGAPPROVAL

User constant

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

Questionnaire constant

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

QuestionnaireStatus constant

QUESTIONNAIRE_STATUS_CLOSED: 1
QUESTIONNAIRE_STATUS_PAUSED: 2
QUESTIONNAIRE_STATUS_ACTIVE: 3
QUESTIONNAIRE_STATUS_OPEN_FOR_TEST: 4

CATI CGS constant

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

CATI list type constant

CATI_MAIN
CATI_ONGOING
CATI_APPOINTMENT 
CATI_FINISHED 
CATI_RETRY

QAS constant

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

Project constant

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

Bulk mail constant

BULKMAIL_OBJECT
BULKMAIL_NAME
BULKMAIL_PARENT_RESOURCE_ID
BULKMAIL_MAIL_TEMPLTE_ID
BULKMAIL_TEMPLATE_RESOURCE_ID

Group constant

GROUP_RESOURCE_ID
GROUP_NAME
GROUP_TEMPLATE_RESOURCE_ID
GROUP_PARENT_RESOURCE_ID
GROUP_TIME_REGISTRATION
GROUP_MAN_HOURS
GROUP_CALCULATED_MAN_HOURS

Folder constant

FOLDER_RESOURCE_ID
FOLDER_NAME
FOLDER_PARENT_RESOURCE_ID
FOLDER_TEMPLATE_RESOURCE_ID
FOLDER_TIME_REGISTRATION
FOLDER_TIME_BUDGET
FOLDER_MAN_HOURS
FOLDER_DESCRIPTION

Data cache - custom column constant

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

Ledger entry constant

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

Invoice constant

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

Diagrams constants

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

Diagrams Known Color constants

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

Table Diagram constants

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

Table Diagram style constants

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


Back to DATA page

Retrieved from "https://testwiki.catglobe.com/index.php?title=CGS_Constants_list&oldid=240329"