| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRACSODREPDATA | SOD Reporting Framework content | 3 | REPORTID | Report ID | nvarchar | 50 | 0 | | |
2 | GRACSODREPDUMP | SOD Reporting Framework content | 3 | REPORTID | Report ID | nvarchar | 50 | 0 | | |
3 | GRACSODREPINDEX | SOD Reporting Framework index | 3 | REPORTID | Report ID | nvarchar | 50 | 0 | | |
4 | GRACSODREPSTATUS | Report status | 3 | REPORTID | Report ID | nvarchar | 50 | 0 | | |
TOPBasis Components |
5 | /CRYSTAL/CA_JOB | Publishing job details | 5 | REPORTID | BW Generation tool: GUID in compressed form (CHAR25) | nvarchar | 25 | 0 | | |
TOPCollectionsDisbursements |
6 | ITAGCYTEMPCOLL | Agency Collections: Data for Temporary Collections | 4 | REPORTID | Broker Report Identification | nvarchar | 12 | 0 | | |
TOPInformation System |
7 | TIVISREP | Report of Info System | 1 | REPORTID | ID for Report of Info System | nvarchar | 12 | 0 | | |
8 | TIVISREPT | Reports of Info System (Text) | 2 | REPORTID | ID for Report of Info System | nvarchar | 12 | 0 | | |