Skip to main content
CollegeSource Support





how many times to check if an audit is complete






how long to wait between checks (in milliseconds)


Default is False




'O'ff - no log messages output


'F'atal- messages resulting from errors that cause the server process to abort


'E'rror - messages resulting from recoverable errors. The process may not run correctly, but attempts will be made to run to completion.


'W'arn - known data or process anomolies that should be fixed, but do not adversely affect audit results


'I'nfo - general informational messages about the state of processing


'D'ebug - detailed informational messages about the state of processing. The amout of log data created is significantly increased at this setting.


'T'race - fine-grained informational messages about the state of processing. This level of detail is typically useful only to CollegeSource programming staff.


'A'll - same as 'T'race


The COM table to be used when running audits for students when viewing plans and validating plans


There are four different strategies available for resolving the appropriate comKey to use when running audits:
sync - the comKey used will be the value of the program's instcd the roadmap was built from 
mapped - the comKey used will be determined by the program's instcd value the roadmap was built from 
institutionMapped - the comKey used will be determined by the program's instidq, instid, and instcd values the roadmap was built from 
static - the comKey used will be the one configured


 Use the sync option:

 Use the mapped option:
       comrec=mapped: :888,\

 Use the institutionMapped option:
       comrec=institutionMapped:73-007104- :999,\
                                73-007105- :MU,\
                                73-007106- :BUS,\
                                73-007107- :ENG

 Use the static option:


Provides a run option to determine whether only one or a combination of transfer articulation and degree audits will be processed. By default, this is set to 'D' which runs the degree audits only. See the DARwin documentation for further options.


Provides a name that is configured in the daemon specifying the source of the request. This allows the daemon to control which requests it will serve. By default, it's set to blank.


This is the 'operator ID' and depending on the value, will determine which audits users will be able to see. Should you want the user to see any audit run, soprid will be set to *.


Condition code that is assigned to any Planned courses. This condition code represents the 19th position condition code and is part of CONDTB-RES. The default value is 'w'.


The default grade assumed for the student for audit purposes. This setting applies to all courses in a student's plan.




COM value to run for student audits when requesting an audit to be viewed. Can be configured the same way as COMREC above.


COM value to run for audits used when building roamdaps. Can be configured the same way as COMREC above.


Status to set the audit requested by to


If left blank, will default to N for a new request. This value is primarily used for instances where you want to do something with the request from before the daemon actually has a chance to acknowledge the request.

Defaults to true


True - When building plans, if a roadmap contains a courseList indicator for a given roadmap requirement, resolve the list of courses for that courseList name, by going out to the encoding table (REQ_MAIN) and looking for a matching requirement name. Display the returned list of courses for the given sub-requirement within that requirement, rather than the courseList indicator itself.


False - Don't do any kind of look up on courseList name value, just display courseList indicator on roadmap.


Default is #


The default COM BLANKC setting


Default is %


The default COM DERC setting

Audit Data Filters

Audit data filters (or just "filters") can remove certain audit data from audit results (such as certain requirements, sub-requirements, or courses) if you wish. These filters can be handy if you wish to reduce the amount of data that is included in a returned audit. Typical audits contain much more data than a user would prefer to see, so use filters to help with this issue.

There are currently three general sets of filters that differ according to how they apply to the following:

  • Requirements
  • Sub-requirements
  • Acceptable Courses

To enable a filter, simply set the value it is assigned to the value "true". To disable a filter, set the value it is assigned to "false".

Below is an example of one filter that is enabled and one that is disabled:



Some Filters are Already Configured


We have already configured a base set of filters. Once you get up and running, you can come back and fine tune them to your liking.

The following list describes all available filters:

Requirement Filters
  • JobQueueReqHiddenFilter
    • filters the JobQueueReq if hidden = "H"
  • JobQueueReqNoSubrequirementsFilter
    • filters the JobQueueReq if it has no JobQueueSubreqs
  • JobQueueReqAssociatedWithBlankCategoryFilter
    • filters the JobQueueReq if category is blank
  • JobQueueReqAssociatedWithHiddenCategoryFilter
    • filters the JobQueueReq if category = "T"
  • JobQueueReqAssociatedWithTotalGpaCategoryFilter
    • filters the JobQueueReq if totalGpa = "T"
  • JobQueueReqAssociatedWithTotalHourCategoryFilter
    • filters the JobQueueReq if totalHour = "T"
  • JobQueueReqAssociatedWithTranscriptCategoryFilter
    • filters the JobQueueReq if transcript = "T"
  • JobQueueReqNoRequiredCountAndNoRequiredHoursAndNoRequiredSubreqsFilter
    • filters the JobQueueReq if reqct = 0, reqsrq = 0, and reqhrs = 0
Subrequirement Filters
  • JobQueueSubreqHiddenFilter
    • filters the JobQueueSubreq if hidden = "H"
  • JobQueueSubreqNoRequiredHoursFilter
    • filters the JobQueueSubreq if estreqhrs = 0
  • JobQueueSubreqNoCoursesOrAcceptableCoursesFilter
    • filters the JobQueueSubreq if it has no JobQueueCourses and no JobQueueAccepts
Acceptable Courses Filters
  • JobQueueAcceptNonGroupCoursesHiddenFilter
    • filters the JobQueueAccept if hidden = "H" and inner_* and outer_* columns are ZERO
  • jobQueueAcceptGroupCoursesHiddenFilter
    • filters the JobQueueAccept if hidden = "H" AFTER it determines the group relationships.
  • JobQueueAcceptRejectFilter
    • filters the JobQueueAccept if reject does not = "1"
The following configuration for the DARwin JDBC connection only needs to be done if your DARwin and databases are not the same. If this is the case, also follow the instructions in WEB-INF/classes/dars-jdbc-ctx.xml.



JDBC driver class name


net.sourceforge.jtds.jdbc.Driver (MS SQL)


oracle.jdbc.OracleDriver (Oracle)




jdbc:jtds:sqlserver://[DCP:server name]:1433/[DCP:database name] (MS SQL)


jdbc:oracle:thin:@[DCP:server name]:1521/[DCP:database name] (Oracle)


JDBC user name


JDBC password


initial number of connections in database connection pool




max number of connections in database connection pool




minimum number of connections at any time in database connection pool




type of database








should SQL statements be printed to STDOUT?


true - prints SQL statements to STDOUT (careful, this can decrease performance)


false - don't print out SQL statements



true - always set to true


generate performance statistics useful for performance tuning (advanced)


true - generate statistics (careful, this can decrease performance)


false - set to false in a production environment

  • Was this article helpful?