Business rules associated with data in the Financial Assurance Module is documented below. All data, whether entered using the user interface or submitted via XML translation must meet these business rules. The business rules are organized by table as found on the structure chart.
|
Number |
Description |
|
FA-000 |
The ACTIVITY LOCATION must be opted in to participate in Financial Assurance translation. (See Documentation / General Help / Application Help / User's Guide / Settings / State Participation) |
|
Number |
Description |
|
FA1-010 |
HANDLER ID must exist in HBASIC. |
|
FA1-020 |
FINANCIAL ASSURANCE TYPE must equal ‘C’, ‘P’, ‘S’, ‘N’, ‘B’, or ‘A’. |
|
FA1-030 |
COST ESTIMATE RESPONSIBLE AGENCY must equal ‘E’ or ‘S’. |
|
FA1-040 |
COST COVERAGE SEQUENCE NUMBER must be greater than zero. |
|
FA1-045 |
If the ACTIVITY LOCATION has indicated that the responsible person information is required then RESPONSIBLE PERSON OWNER and RESPONSIBLE PERSON must be provided. |
|
FA1-050 |
RESPONSIBLE PERSON OWNER must equal the submitter’s agency or null. |
|
FA1-060 |
If RESPONSIBLE PERSON is provided then RESPONSIBLE PERSON OWNER must be provided. If RESPONSIBLE PERSON OWNER is provided then RESPONSIBLE PERSON must be provided. |
|
FA1-070 |
RESPONSIBLE PERSON must be a valid implementer-defined value in LU_STAFF or null. |
|
FA1-080 |
COST ESTIMATE AMOUNT must be greater than or equal to zero. |
|
FA1-090 |
COST ESTIMATE DATE must be on or after October 1, 1980 and no later than today. |
|
FA1-125 |
If FINANCIAL ASSURANCE TYPE equals ‘N’ and COST ESTIMATE AMOUNT is less than 6,000,000 Then NOTES must be provided. |
|
FA1-135 |
If FINANCIAL ASSURANCE TYPE equals ‘S’ and COST ESTIMATE AMOUNT is less than 2,000,000 Then NOTES must be provided. |
|
FA1-145 |
If FINANCIAL ASSURANCE TYPE equals ‘B’ and COST ESTIMATE AMOUNT is less than 8,000,000 Then NOTES must be provided. |
|
FA1-150 |
If COST ESTIMATE REASON equals ‘C’, ‘F’, ‘N’, ‘P’, ‘T’, ‘V’, X’, or ‘W’ Then COST ESTIMATE AMOUNT must equal zero. |
|
FA1-160 |
If FINANCIAL ASSURANCE TYPE = ‘A’ Then COST ESTIMATE REASON must equal ‘A’, ‘C’, ‘F’, ‘I’, ‘N’, ‘R’, ‘S’, ‘T’, ‘V’, or ‘W’. |
|
FA1-170 |
If FINANCIAL ASSURANCE TYPE = ‘C’ Then COST ESTIMATE REASON must equal ‘A’, ‘C’, ‘F’, ‘I’, ‘N’, ‘R’, ‘S’, ‘W’, or ‘X’. |
|
FA1-180 |
If FINANCIAL ASSURANCE TYPE = ‘P’ Then COST ESTIMATE REASON must equal ‘A’, ‘C’, ‘F’, ‘I’, ‘N’, ‘P’, ‘R’, ‘S’, or ‘W’. |
|
FA1-190 |
If FINANCIAL ASSURANCE TYPE = ‘B’, ‘N’, or ‘S’ Then COST ESTIMATE REASON must equal ‘A’, ‘C’, ‘F’, ‘I’, ‘N’, ‘R’, ‘S’, ‘W’, or ‘L’. |
|
FA1-200 |
If COST ESTIMATE REASON equals ‘W’ Then NOTES must be provided. |
|
FA1-210 |
If COST ESTIMATE AMOUNT equals zero Then there cannot be a corresponding record in FLN_COST_MECHANISM_DETAIL4 or FA4. |
|
FA1-230 |
If COST ESTIMATE AMOUNT equals zero Then NOTES must be provided. |
|
FA1-240 |
UPDATE DUE DATE must after the COST ESTIMATE DATE or null. |
|
Number |
Description |
|
FA2-010 |
HANDLER ID, MECHANISM AGENCY, and MECHANISM SEQUENCE NUMBER must exist in FMECHANISM_DETAIL4 or FA3. |
|
FA2-020 |
MECHANISM AGENCY must equal ‘E’ or ‘S’. |
|
FA2-030 |
MECHANISM SEQUENCE NUMBER must be greater than zero. |
|
FA2-040 |
MECHANISM TYPE OWNER must equal ‘HQ’ or the submitter’s agency. |
|
FA2-050 |
MECHANISM TYPE must be a valid nationally-defined mechanism type value or an implementer-defined mechanism type value. |
|
FA2-080 |
PROVIDER must be provided. |
|
FA2-090 |
If MECHANISM EXPIRES equals ‘Y’ in LU_MECHANISM for this MECHANISM TYPE then the EXPIRATION / RELEASE DATE must be provided. |
|
FA2-100 |
ACTIVE MECHANISM must equal 'Y' or 'N'. |
|
FA2-110 |
If PROVIDER CONTACT EMAIL is provided it must be formatted as X@X.AA where X is an alphanumeric character (including some special characters) and A is an alpha character. |
|
Number |
Description |
|
FA3-010 |
HANDLER ID, MECHANISM AGENCY, and MECHANISM SEQUENCE NUMBER must exist in FMECHANISM4 or FA2. |
|
FA3-018 |
MECHANISM DETAIL SEQUENCE NUMBER must be greater than zero. |
|
FA3-020 |
MECHANISM IDENTIFICATION must be provided. |
|
FA3-030 |
FACE VALUE AMOUNT must be greater than or equal to zero. |
|
FA3-040 |
FACILITY FACE VALUE AMOUNT must be greater than or equal to zero. |
|
FA3-050 |
FACE VALUE AMOUNT must be greater than or equal to FACILITY FACE VALUE AMOUNT. |
|
FA3-060 |
EFFECTIVE DATE must be on or after October 1, 1980 and no later than today. |
|
FA3-070 |
EXPIRATION / RELEASE DATE must be after the EFFECTIVE DATE or null. |
|
FA3-080 |
If MECHANISM EXPIRES equals ‘Y’ in LU_MECHANISM for this MECHANISM TYPE then the EXPIRATION / RELEASE DATE must be provided. |
|
FA3-090 |
If MECHANISM TYPE equals 'F' or 'C' then ALTERNATIVE must equal '1' or '2'. |
|
Number |
Description |
|
FA4-010 |
HANDLER ID, FINANCIAL ASSURANCE TYPE, COST ESTIMATE AGENCY, and COST ESTIMATE COVERAGE SEQUENCE NUMBER must exist in FCOST_ESTIMATE4 or FA1. |
|
FA4-020 |
HANDLER ID, MECHANISM AGENCY, MECHANISM SEQUENCE NUMBER, and MECHANISM DETAIL SEQUENCE NUMBER must exist in FMECHANISM_DETAIL4 or FA3. |
|
FA4-030 |
The cost estimate must be linked to a mechanism with the same responsible agency. |
|
FA4-040 |
A record in FA4 cannot correspond to a record in FCOST_ESTIMATE4 or FA1 where COST ESTIMATE AMOUNT equals zero. |