ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
StateDW Table and Field Matrix
current as of 1/17/2024Contact financesupport@utah.gov with any questions.
2
In order to maintain data integrity you only have viewer access. To expand the grouped rows, make a copy of the document.
3
Table Names, click + on the left, to expand/collapse COMMENTSJOINS (minimum recommendations)
4
ABS_DOC_ACTGField NameTypeSizeABS tables contain data for documents such as GAX*'s, GAE, GMA. Information in this table can be used to query both open and closed payment transactions. DOC_CD, DOC_DEPT_CD, DOC_ID and DOD_VERS_NO. There are time its necessary to join using the DOC_VEND_LN_NO as well.
63
64
ABS_DOC_HDRField NameTypeSizeDOC_CD, DOC_DEPT_CD, DOC_ID and DOD_VERS_NO.
65
ABS_DOC_HDRDOC_CATShort Text8
66
ABS_DOC_HDRDOC_TYPShort Text8
67
ABS_DOC_HDRDOC_CDShort Text8
68
ABS_DOC_HDRDOC_DEPT_CDShort Text4
69
ABS_DOC_HDRDOC_IDShort Text20
70
ABS_DOC_HDRDOC_VERS_NONumeric16
71
ABS_DOC_HDRDOC_FUNC_CDNumeric16
72
ABS_DOC_HDRDOC_LAST_DTDate With Time8
73
ABS_DOC_HDRDOC_PHASE_CDNumeric16
74
ABS_DOC_HDRDOC_BFYNumeric16
75
ABS_DOC_HDRDOC_FY_DCNumeric16
76
ABS_DOC_HDRDOC_PER_DCNumeric16
77
ABS_DOC_HDRDOC_FQTRNumeric16
78
ABS_DOC_HDRDOC_STA_CDNumeric16
79
ABS_DOC_HDRDOC_CLSD_DTDate With Time8
80
ABS_DOC_HDRDOC_CLSD_AMNumeric16
81
ABS_DOC_HDRBANK_ACCT_CDShort Text4
82
ABS_DOC_HDRDOC_ACTU_AMNumeric16
83
ABS_DOC_HDRPYMT_AMNumeric16
84
ABS_DOC_HDRDISC_AMNumeric16
85
ABS_DOC_HDRDOC_DSCRShort Text60
86
ABS_DOC_HDRDOC_NMShort Text60
87
ABS_DOC_HDRDEPT_CDShort Text4
88
ABS_DOC_HDRDOC_CREA_DTDate With Time8
89
ABS_DOC_HDRCURR_FYNumeric16
90
ABS_DOC_HDRCURR_PERNumeric16
91
ABS_DOC_HDRDOC_UNIT_CDShort Text4
92
ABS_DOC_HDRDOC_REC_DT_DCDate With Time8
93
94
ABS_DOC_VENDField NameTypeSizeDOC_CD, DOC_DEPT_CD, DOC_ID and DOD_VERS_NO. There are time its necessary to join using the DOC_VEND_LN_NO as well.
95
ABS_DOC_VENDDOC_CATShort Text8
96
ABS_DOC_VENDDOC_TYPShort Text8
97
ABS_DOC_VENDDOC_CDShort Text8
98
ABS_DOC_VENDDOC_DEPT_CDShort Text4
99
ABS_DOC_VENDDOC_IDShort Text20
100
ABS_DOC_VENDDOC_VERS_NONumeric16
101
ABS_DOC_VENDDOC_VEND_LN_NONumeric16
102
ABS_DOC_VENDVEND_CUST_CDShort Text20
103
ABS_DOC_VENDLGL_NMShort Text60
104
ABS_DOC_VENDALIAS_NMShort Text60
105
ABS_DOC_VENDDOC_PHASE_CDNumeric16
106
ABS_DOC_VENDDOC_FUNC_CDNumeric16
107
ABS_DOC_VENDAD_IDShort Text20
108
ABS_DOC_VENDCURR_FYNumeric16
109
ABS_DOC_VENDCURR_PERNumeric16
110
ABS_DOC_VENDAD_LN_1Short Text75
111
ABS_DOC_VENDAD_LN_2Short Text75
112
ABS_DOC_VENDCITYShort Text60
113
ABS_DOC_VENDSTShort Text2
114
ABS_DOC_VENDZIPShort Text10
115
ABS_DOC_VENDCNTAC_IDShort Text20
116
ABS_DOC_VENDPRIN_CNTACShort Text60
117
ABS_DOC_VENDVEND_DISB_CATShort Text4
118
ABS_DOC_VENDSCHED_PYMT_DTDate With Time8
119
ABS_DOC_VENDDISB_PRTY_CDNumeric16
120
121
ACA_PayrollField NameTypeSizeNo personal information is contained in this table, EIN, but no names
128
129
Accounting_PeriodField NameTypeSizeThis table contains data for reporting, to translate a calendar date, into the logic needed for Fiscal Year and months, July 1, to June 30th.
139
140
Account TypeField NameTypeSizeAccount_Type, consolidates Posting Codes from FINET Transactions.
143
144
Accounting JournalField NameTypeSizeAccounting Journal provides the end user detail, at the line item level, for transactions within FINET. Do not join the accounting journal table with the accounting journal summary table.
243
244
Accounting_Journal_SummaryField NameTypeSizeAccounting Journal Summary contains nearly all transactions from FINET. Make sure to use as much criteria within your query as possible. The Accounting Journal Summary will provide detail at the transaction level. If you want more details such as each line from a transaction, you must use the Accounting Journal. Running a query without using criteria with the accounting journal will crash your system, it is an extremely large table.Doc_Department, Document_Code, Document_ID, Document_Version_Number: these are the minimum joins. However there are many additional fields, depending upon you other table(s) where additional fields can be used in a join.
298
299
ActivityField NameTypeSizeDefined by each agency/department. See Activity Table for values. Can be any combination of letters and numbers.
315
316
AD_DOC_HDRField NameTypeSizeAutomatic Disbursements, payment details.
341
342
Address_TypeField NameTypeSize
345
346
AP_PD_CHK_AND_AP_CHK_RECONField NameTypeSizeAP_PD_CHK_AND_AP_CHK_RECON is a unique custom table, combining two key tables to all you to search for a payment and that payments status.
363
364
Appropriation_ClassField NameTypeSizeAppropriation Class table contains the Appropriation Class structure
372
373
Appropriation_UnitField NameTypeSizeAlso refered as "Appropriation Unit". The Legislature authorizes spending by "Appropriaiton Line items" in Legislative Bills each year. Those Line Items are then broken down into Units which represent programs within the Line Item. All budgeted funds have a Alphanumeric Appoprioation Unit. All other funds use the fund number as the appropraiton unit. Appropriaiton units are established by the LFA for budgeting.
386
387
Balance Sheet AccountField NameTypeSize0xxx-4xxx - Assets, 5xxx-6xxx - liabilities, 7xxx - Fund balance/equity
400
401
Balance_Sheet_GroupField NameTypeSize
407
408
Balance Sheet TypeField NameTypeSize
414
415
Bank Account BalanceField NameTypeSize
428
429
Beginning BalanceField NameTypeSize
439
440
BGAA_DOC_LNField NameTypeSize
473
474
Bud_Stru_31_Lvl_1Field NameTypeSize
524
525
Budget_Structure_AppropField NameTypeSizeBudget Struction Appropriation provides data from multiple FINET tables, to summarize budget details.
578