Although officially listed as an Infrastructure table, the Application Parameter (APPCTRL) table is one that is part of general system configuration. Options on this table are set once and do not vary by year, fund, department, transaction, or other factors. The table is very generic in its design so that it can host many different types of options with the Parameter Name and Parameter Value fields. Of the controls on this table, those listed below directly relate to the Grant Lifecycle Management subsystem. Note: Any changes to records on this table should be followed by a bounce of all servers used for CGI Advantage Financial.
Grant Lifecycle Management Controls
Parameter |
Description |
Amendment Number Prefix AMND_NUM_PRFX |
Determines the prefix that is used when auto generating the Amendment Number. |
Days to allow to Update in ARRA Data DAYS_TO_VERIFY_ARRA_DATA |
This parameter controls the period in which quarterly ARRA reporting records may be modified. The initial value for this field as established by Federal Rules is 21. Per Federal Rules, quarterly entry may only be modified for 21 days after the end of the quarter ending date. After 21 days, no further changes to the records are allowed and updates should be made in the next quarter. |
Default Grant Cancellation Message DFLT_GRNT_CAN_MSGID |
The default cancellation message for Grant transactions. |
Default Grant Message ID DFLT_GRNT_MSGID |
Indicates the Message ID that the Notify Grant Opportunity process uses, if the Message ID field is blank on the Grant Notification Status Folder (GTNTSF) table. |
Default Grant Message Subject DFLT_GRNT_MSG_SUBJECT |
Indicates the value for the Subject field, if left blank on the Grant Message (GRNTMSG) table. |
Default Grant URL DFLT_GRNT_URL |
The default Grant URL. |
Default Opportunity Transaction Code DFLT_OPPORTUNITY_DOC_CODE |
The default parameter value for this field is GTOP. When the value for the parameter is blank an error is received on the GTAOD and GTAOS pages when attempting to create Opportunity transactions. When a Transaction Code is specified in this Parameter, the Grant Opportunity transactions created directly from the Available Opportunity Detail (GTAOD) or Available Opportunity Summary (GTAOS) pages will be created using this Transaction Code. Note: The specified Transaction Code must also be set up on the Transaction Control (DCTRL) and Auto Numbering (ADNT) tables. Refer to the “Creating Opportunity Transactions from GTAOD and GTAOS” topic for more information. |
Delete Message for a Calendar Alert GRNT_MSG_DEL_ALRT_CAL |
This message is used when a User or Date record is deleted. This message is specifically for Grant Users that have an Alert Type of Calendar. Additional information on this parameter is outlined in the Generate Alerts batch process Run Sheet. |
Delete Message for Detailed Email Alert GRNT_MSG_DEL_ALRT_DETAIL |
This message is used when a User or Date record is deleted. This message is specifically for Grant Users that have an Alert Type of Detailed Email. Additional information on this parameter is outlined in the Generate Alerts batch process Run Sheet. |
Delete Message for Summary Alert GRNT_MSG_DEL_ALRT_SUMM |
This message is used when a User or Date record is deleted. This message is specifically for Grant Users that have an Alert Type of Summary Email. Additional information on this parameter is outlined in the Generate Alerts batch process Run Sheet. |
Transaction Code for CAS transaction CAS_DOC_CD |
The Transaction Code for the CAS transaction. This can be updated to a value other than CAS if a client site decides to clone the CAS transaction and give it a different Transaction Code. |
Due Date Message GRNT_MSG_DUE_ALRT |
Indicates the Message ID that the Generate Alerts Process uses for generating Calendars/E-mails when no Message ID has been defined for the Due Date Message on the Date record. |
Grant Awarded Amount GRNT_AWD_AMT |
A warning message is issued on the Grant Award if the Grant Management Statement field is not populated and the Awarded Amount is greater than this parameter value. Note: You must enter a field type of "Number" instead of "String". For example: Number = 20000 String = 20,000 |
Insert message for all Alert Type GRNT_MSG_INS_ALRT |
This message is used as an Insert Message for newly added users for a Date Code whose alerts are already sent. Additional information on this parameter is outlined in the Generate Alerts batch process Run Sheet. |
Modify Message for a Calendar Alert GRNT_MSG_MOD_ALRT_CAL |
This message is used when the Due Date on a Date Record is modified. This message is specifically for Grant Users that have an Alert Type of Calendar. Additional information on this parameter is outlined in the Generate Alerts batch process Run Sheet. |
Modify Message for Detailed Email Alert GRNT_MSG_MOD_ALRT_DETAIL |
This message is used when the Due Date on a Date Record is modified. This message is specifically for Grant Users that have an Alert Type of Detailed Email. Additional information on this parameter is outlined in the Generate Alerts batch process Run Sheet. |
Modify Message for Summary Alert GRNT_MSG_MOD_ALRT_SUMM |
This message is used when the Due Date on a Date Record is modified. This message is specifically for Grant Users that have an Alert Type of Summary Email. Additional information on this parameter is outlined in the Generate Alerts batch process Run Sheet. |
Summary Alert Message GRNT_MSG_SUMM_ALRT |
The Message ID that the Generate Alerts Process uses for generating email when the Alert Type is Email-Summary. Additional information on this parameter is outlined in the Generate Alerts batch process Run Sheet. |
Grant Opportunity Funding Agency Control GTOP_FUND_AGY_CTL |
The default parameter value for this field is C. Other acceptable values are O or Blank / Null. When a value of C is entered, the Funding Agency field on Opportunity transactions / Status folders is optional when the Grant Opportunity Source Detail field does not equal Other. When a value of C is entered, the Funding Agency field on Opportunity transactions / Status folders is required when the Grant Opportunity Source Detail field equals Other. When a value of O is entered, the Funding Agency field on Opportunity transactions / Status folders is optional. When no value has been entered, the Funding Agency field on Opportunity transactions / Status folders is required. |
Opportunity Transaction Prefix OPPORTUNITY_DOC_PREFIX |
This parameter allows sites to define specific prefixes for the Grant Opportunity transactions automatically generated from the Available Opportunity Detail (GTAOD) and/or Available Opportunity Summary (GTAOS) pages. The default parameter value for this field is ‘****’. |
Opportunity Transaction Submit OPPORTUNITY_DOC_SUBMIT |
The default parameter value for this field is False. When the value for the parameter is set as False the Grant Opportunity transactions are created directly from the Available Opportunity Detail (GTAOD) and Available Opportunity Summary (GTAOS) pages; however, the transactions are not validated or submitted to Final. This setting allows users to make modifications to the Opportunity transactions and then submit the transactions manually. When the value for the parameter is set as True this will facilitate to generate, validate and submit Grant Opportunity transactions directly from the Available Opportunity Detail (GTAOD) and Available Opportunity Summary (GTAOS) pages. |