Description of OSP$PARAMETER table

Parameter	Description
AWARD_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in award searches
CFDA_CODE	This is used in EDI. The value of this parameter should be the Notice of Opportunity code for CFDA
CLIENT_DOWNLOAD_LOCATION	URL of latest version of Coeus Download. This URL will be displayed in the message if the user is using an outdated version of Coeus
COEUS_CURRENT_VERSION	Current Version of Coeus Database. Users will see a warning message each time they login to the application if their client version is prior to this value.
COEUS_MODULE_AWARD	Module code for Award. Code from osp$coeus_modules table
COEUS_MODULE_DEV_PROPOSAL	Module code for Development Proposal. Code from osp$coeus_modules table
COEUS_MODULE_NEGOTIATION	Module code for Negotiation. Code from osp$coeus_modules table
COEUS_MODULE_PERSON	Module code for Person  Code from osp$coeus_modules table
COEUS_MODULE_PROPOSAL	Module code for Institute Proposal. Code from osp$coeus_modules table
COEUS_MODULE_SUBCONTRACT	Module code for Subcontract. Code from osp$coeus_modules table
COST_SHARING_COMMENT_CODE	Code from osp$comments table (Comment type lookup table) for Cost Sharing Comments
CURRENT_FISCAL_YEAR	MIT SPECIFIC – used in SAP feed
DEFAULT_BUDGET_COST_ELEMENT	Used in award budget – make sure there is a cost element set up in OSP$COST_ELEMENTS
DEFAULT_TABLESPACE	Database default tablespace
DISCLOSURE_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in disclusure searches.
EB_ON_LA_RATE_TYPE_CODE	MIT SPECIFIC
EB_RATE_CLASS_CODE	Code for rate class of type 'EB'. Code from osp$rate_class table WHY DO WE USE THIS
EOM_PROCESS_DATE	Date of previous EOM process. EOM process osp$eom_amount_info_table. This process calculates the change in obligated and anticipated amounts in awards since the last run of EOM process. For every award that was modified or created it inserts a row in osp$eom_amount_info table with the changed amounts
EOM_PROCESS_USER	User who ran the EOM process last time
FELLOWSHIP_OSP_ADMIN	The value for this parameter should be the name of the person who should receive award notice for Fellowships. i.e If award type is Fellowship, this name will be printed in award notice.
FISCAL_CLASS_CODE	Code for report class "Fiscal"
GENERIC_SPONSOR_CODE	Used for printing generic sponsor forms – make sure this sponsor exists in OSP$SPONSOR. We use MIT as the generic sponsor.  This is the sponsor you will use to load generic forms.
INDIRECT_COST_COMMENT_CODE	Comment type code for Indirect cost Comments
INTELLECTUAL_PROPERTY_CLASS_CODE	Report class code for Intellectual property reports
INVOICE_INSTRUCTION_COMMENT_CODE	Comment type code for Invoice instructions
JOBCODE_VALIDATION_ENABLED	Used for validation of job code : cost element mapping in proposal budget.
LA_RATE_CLASS_CODE	MIT SPECIFIC
MIT_IDC_VALIDATION_ENABLED	Used for validation of rates in MIT accounting system.. Value of ‘1’ enables rate pair validation.  If this is set, indirect cost rates must be input in pairs (on and off campus rates) that are validated against values in  osp$valid_rates.
NEGOTIATION_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in negotiation searches
OLDEST_SUPPORTED_VERSION	Oldest version of the client that can be supported by this version of the database. Older version of client applications will not be allowed to connect to the database
PERSON_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in person searches
PROCUREMENT_CLASS_CODE	Report class code for Procurement  reports
PROPERTY_CLASS_CODE	Report class code for Property  reports
PROPOSAL_COMMENT_CODE	Comment type code for general comments in institute proposals
PROPOSAL_IP_REVIEW_COMMENT_CODE	Comment type code for IP review comments
PROPOSAL_IP_REVIEWER_COMMENT_CODE	Comment type code for IP Reviewer Comments
PROPOSAL_LOG_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in proposal log searches
PROPOSAL_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in proposal searches
PROPOSAL_SUMMARY_COMMENT_CODE
PUBLIC_MESSAGE_ID	Controls the ‘message of the day’ along with the value of message_seen in the coeus.ini file.  The parameter value should be set to the message_id of the message you want displayed.  If the value of ‘message_seen’ in coeus.ini is not the same as the value in PUBLIC_MESSAGE_ID, the message will be displayed.  Messages are stored in OSP$MESSAGE table.  When the user clicks the ‘do not show me this anymore’ checkbox, the ini file’s ‘message_seen’ value will be set to the value of the public_message_id. The value of  ‘message_seen’ in the Application section of Coeus.ini should initially be set to 0. To display a new message, insert a new message into osp$message and update the value of ‘public_message_id’ in OSP$PARAMETER with the new message_id.
REPORTING_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in award reporting searches.
ROLODEX_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in rolodex searches
SAP_FEED_ENABLED	MIT SPECIFIC
SCIENCE_CODE_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in science code searches
SPECIAL_RATE_COMMENT_CODE	Comment type code for Special rate comments in awards
SPECIAL_REVIEW_COMMENT_CODE	Comment type code for Special review comments
SPONSOR_FEED_DATE	Timestamp of last SAP Feed.
SPONSOR_FEED_USER	USER who ran the last SAP feed
SPONSOR_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in sponsor  searches
SUBCONTRACT_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in subcontract searches
TECHNICAL_MANAGEMENT_CLASS_CODE	Report class code for Technical/Management  reports
TEMPORARY_TABLESPACE	Database temporary tablespace
UNIT_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in unit searches
USER_RETRIEVE_LIMIT	Limits the maximum number of rows retrieved in user searches
VACATION_ON_LA_RATE_TYPE_CODE	MIT SPECIFIC
VACATION_RATE_CLASS_CODE	Code for rate class of type 'Vacation'. Code from osp$rate_class table