|
***WARNING*** The data (primarily notes / comments) may contain line feeds, carriage returns, and/or end of transmission blocks. These need to be ignored when uploading your data. ***WARNING*** |
The CSV file specifications associated with the tables in the Financial Assurance Module are documented, by table, below.
|
English Name |
Excel Column |
Field Length |
Data Type |
| EPA Handler ID | A |
12 |
Alphanumeric |
| Cost Estimate Activity Location | B |
2 |
Alphanumeric |
|
Financial Assurance Type |
C |
1 |
Alphanumeric |
| Cost Estimate Responsible Agency | D |
1 |
Alphanumeric |
| Cost Coverage Sequence Number | E |
4 |
Integer |
|
Cost Estimate Responsible Person Owner |
F |
2 |
Alphanumeric |
|
Cost Estimate Responsible Person |
G |
5 |
Alphanumeric |
|
Cost Estimate Amount |
H |
13 |
Integer |
|
Cost Estimate Date |
I |
8 |
Date (YYYYMMDD) |
|
Cost Estimate Reason |
J |
1 |
Alphanumeric |
| Update Due Date | K | 8 | Date (YYYYMMDD) |
| Current Cost Estimate Indicator | L | 1 | Alphanumeric |
|
English Name |
Excel Column |
Field Length |
Data Type |
| Cost Estimate Handler ID | A |
12 |
Alphanumeric |
| Cost Estimate Activity Location | B |
2 |
Alphanumeric |
|
Financial Assurance Type |
C |
1 |
Alphanumeric |
| Cost Estimate Responsible Agency | D |
1 |
Alphanumeric |
|
Cost Coverage Sequence Number |
E |
4 |
Integer |
|
Mechanism Handler ID |
F |
12 |
Alphanumeric |
|
Mechanism Activity Location |
G |
2 |
Alphanumeric |
|
Mechanism Agency |
H |
1 |
Alphanumeric |
|
Mechanism Sequence Number |
I |
4 |
Integer |
|
Mechanism Detail Sequence Number |
J |
4 |
Integer |
|
English Name |
Excel Column |
Field Length |
Data Type |
| EPA Handler ID | A |
12 |
Alphanumeric |
| Mechanism Activity Location | B |
2 |
Alphanumeric |
|
Mechanism Agency |
C |
1 |
Alphanumeric |
| Mechanism Sequence Number | D |
4 |
Integer |
| Mechanism Detail Sequence Number | E |
4 |
Integer |
|
Face Value Amount |
F |
13 |
Number |
|
Effective Date |
G |
8 |
Date (YYYYMMDD) |
|
Expiration / Release Date |
H |
8 |
Date (YYYYMMDD) |
| Financial Test / Corporate Guarantee Alternative | I | 1 | Alphanumeric |
| Facility Face Value Amount | J | 13 | Number |
| Current Mechanism Detail Indicator | K | 1 | Alphanumeric |
|
English Name |
Excel Column |
Field Length |
Data Type |
| EPA Handler ID | A |
12 |
Alphanumeric |
| Mechanism Activity Location | B |
2 |
Alphanumeric |
|
Mechanism Agency |
C |
1 |
Alphanumeric |
| Mechanism Sequence Number | D |
4 |
Integer |
| Mechanism Type Owner | E |
2 |
Alphanumeric |
|
Mechanism Type |
F |
1 |
Alphanumeric |
|
Provider |
G |
80 |
Alphanumeric |
|
Provider Contact Name |
H |
33 |
Alphanumeric |
|
Provider Contact Phone Number |
I |
15 |
Alphanumeric |
| Provider Contact Email | J | 80 | Alphanumeric |
|
English Name |
Excel Column |
Field Length |
Data Type |
| Financial Assurance Type Owner | A |
2 |
Alphanumeric |
| Financial Assurance Type | B |
1 |
Alphanumeric |
| Active Status | C |
1 |
Alphanumeric |
| Financial Assurance Type Description | D |
255 |
Alphanumeric |
|
English Name |
Excel Column |
Field Length |
Data Type |
| Cost Estimate Reason Owner | A |
2 |
Alphanumeric |
| Cost Estimate Reason | B |
1 |
Alphanumeric |
| Active Status | C |
1 |
Alphanumeric |
| Cost Estimate Reason Description | D |
255 |
Alphanumeric |
|
English Name |
Excel Column |
Field Length |
Data Type |
| Mechanism Type Owner | A |
2 |
Alphanumeric |
| Mechanism Type | B |
1 |
Alphanumeric |
| Mechanism Expires Indicator | C |
1 |
Alphanumeric |
| Active Status | D |
1 |
Alphanumeric |
| Mechanism Type Description | E |
50 |
Alphanumeric |