| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRevenue |
1 | OIUE1_LSSL_SUM | Legal Suspense Summary | 40 | BA_ST_CD | State Code | nvarchar | 2 | 0 | | |
2 | OIUE2_ESCH_DTL | Proc 2.0 - Escheat - Owner Details | 41 | BA_ST_CD | State Code | nvarchar | 2 | 0 | | |
3 | OIUE2_ESCH_DTLH | Proc 2.0 - Escheat - Owner Detail History | 41 | BA_ST_CD | State Code | nvarchar | 2 | 0 | | |
4 | OIUE2_ESCH_RPDTH | Proc 2.0 - Escheat - Report Detail - Holder | 3 | BA_ST_CD | Proc 2.0 - Escheat - Resident State | nvarchar | 2 | 0 | | |
5 | OIUE2_ESCH_RPDTP | Proc 2.0 - Escheat - Report Detail - Property | 3 | BA_ST_CD | Proc 2.0 - Escheat - Resident State | nvarchar | 2 | 0 | | |
6 | OIUE2_ESCH_RPDTS | Proc 2.0 - Escheat - Report Detail - Summary | 3 | BA_ST_CD | Proc 2.0 - Escheat - Resident State | nvarchar | 2 | 0 | | |
7 | OIUE2_ESCH_SF | Proc 2.0 - Escheat - State Smart Form Config | 2 | BA_ST_CD | Proc 2.0 - Escheat - Resident State | nvarchar | 2 | 0 | | |
8 | OIUE2_ESCH_SUM | Proc 2.0 - Escheat - Owner Summary | 6 | BA_ST_CD | Proc 2.0 - Escheat - Resident State | nvarchar | 2 | 0 | | |
9 | OIUE2_ESCH_SUMH | Proc 2.0 - Escheat - Owner Summary History | 6 | BA_ST_CD | Proc 2.0 - Escheat - Resident State | nvarchar | 2 | 0 | | |
10 | OIUE2_ESCH_SUS | Proc 2.0 - Escheat - Excluded Suspense Reason Codes | 2 | BA_ST_CD | Proc 2.0 - Escheat - Resident State | nvarchar | 2 | 0 | | |
11 | OIUE2_ESCROW_DTL | Proc 2.0 - WY Escrow - Owner Details | 41 | BA_ST_CD | State Code | nvarchar | 2 | 0 | | |
12 | OIUH_CM_BA | Oil and Gas appl table | 18 | BA_ST_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |