Application Parameter

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: The value entered must be a number so that twenty thousand is entered as 20000 with no puntuation or symbols.
Insert Message for All Alert Types 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	This parameter controls whether the system should process a Grant Opportunity transaction created from Available Opportunity Detail and Available Opportunity Summary or leave it in Draft so that updates can be made. A setting of False results in the transaction being left unvalidated in Draft.
Include Grant ID in CAS Transaction ID INCL_GRANT_ID_FOR_CAS_DOC_ID_GEN	This parameter determines whether the Grant ID is included in the Cost Accounting Setup Transaction ID generated by the Grant Award transaction when Automatic or Unique Numbering for the CAS transaction is False. If set to True, the Grant ID is included along with a unique value supplemented with a Unique Number record to achieve a total length of 20. If set to False, the system checks the DCTRL entry for the maximum Transaction ID. If a value exists, a Transaction ID of the same length is generated, and if no value is found, a 20-character ID is used.
Use Automatic or Unique Numbering for CAS Transaction USE_ADNT_FOR_CAS_DOC_ID_GEN	This parameter allows the use of Automatic Transaction Numbering instead of the default Unique Number record for the Cost Accounting Setup Transaction ID numbering. If set to True, ADNT is applied with a prefix, date, and variable length under 20. If set to False, a fixed length Unique Number of 20 characters is used.

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: The value entered must be a number so that twenty thousand is entered as 20000 with no puntuation or symbols.

Insert Message for All Alert Types

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

This parameter controls whether the system should process a Grant Opportunity transaction created from Available Opportunity Detail and Available Opportunity Summary or leave it in Draft so that updates can be made. A setting of False results in the transaction being left unvalidated in Draft.

Include Grant ID in CAS Transaction ID

INCL_GRANT_ID_FOR_CAS_DOC_ID_GEN

This parameter determines whether the Grant ID is included in the Cost Accounting Setup Transaction ID generated by the Grant Award transaction when Automatic or Unique Numbering for the CAS transaction is False.

If set to True, the Grant ID is included along with a unique value supplemented with a Unique Number record to achieve a total length of 20.
If set to False, the system checks the DCTRL entry for the maximum Transaction ID. If a value exists, a Transaction ID of the same length is generated, and if no value is found, a 20-character ID is used.

Use Automatic or Unique Numbering for CAS Transaction

USE_ADNT_FOR_CAS_DOC_ID_GEN

This parameter allows the use of Automatic Transaction Numbering instead of the default Unique Number record for the Cost Accounting Setup Transaction ID numbering.

If set to True, ADNT is applied with a prefix, date, and variable length under 20.
If set to False, a fixed length Unique Number of 20 characters is used.