Get documents about "Land Contract Free Ohio Template - Excel
Description
Land Contract Free Ohio Template document sample
Document Sample
FIN Operational Reporting Warehouse
Data Dictionaries by Warehouse Subject Area
Last Updated: 7/15/2010
OAKS FIN Operational Reporting Data Warehouse
Warehouse ERD Diagram
7/15/2010 5:21 PM 2 of 150
OAKS FIN Operational Reporting Data Warehouse
FIN - Data Dictionary: Column Descriptions
Data Dictionary Template
Column Name Column Description
Oracle PeopleSoft ERP System Tables
Table Name The name of the physical database table associated with the record being described. All PeopleSoft table names begin with PS_ and are followed
by the record name. Refer to the related HCM System ERD diagrams for more information
Field The name of each field contained within the respective database table. Enumerations of fields can be found in the HCM System ERD diagrams,
PeopleSoft Application Designer, or via a direct query of the PeopleTools tables. Also, there are a number of PeopleBooks which explain the
table layouts. Fields should be listed in the same order as they appear in the record definition with keys at the top.
Field Description The description of each field that appears within the respective record definition. Field descriptions are available in PeopleSoft Application
Designer. Also, there are a number of PeopleBooks which explain the table layouts.
Oracle PeopleSoft OWS Tables
Table Name The name of the physical database table associated with the record being described. All PeopleSoft table names begin with PS_ and are followed
by the record name. Refer to the related HCM System ERD diagrams for more information
Field The name of each field contained within the respective database table. Enumerations of fields can be found in the HCM System ERD diagrams,
PeopleSoft Application Designer, or via a direct query of the PeopleTools tables. Also, there are a number of PeopleBooks which explain the
table layouts. Fields should be listed in the same order as they appear in the record definition with keys at the top.
Field Description The description of each field that appears within the respective record definition. Field descriptions are available in PeopleSoft Application
Designer. Also, there are a number of PeopleBooks which explain the table layouts.
Oracle PeopleSoft Reporting Table
Table Name The name of the physical database table associated with the fact or dimension record being described. All PeopleSoft table names begin with
PS_ and are followed by the record name. Refer to the related ERD diagrams for more information
Field The name of each field contained within the respective database table. Enumerations of fields can be found in the ERD diagrams, PeopleSoft
Application Designer, or via a direct query of the PeopleTools tables. Also, for facts and dimensions, there are a number of PeopleBooks which
explain the table layouts. Fields should be listed in the same order as they appear in the record definition with keys at the top.
Field Type The PeopleSoft-specified data type for each field. Field data types can be found in PeopleSoft Application Designer, or via a direct query of the
PeopleTools tables. Also, for facts and dimensions, there are a number of PeopleBooks which explain the table layouts.
Field Length The field size as specified in PeopleSoft. For decimal values, please use INTEGER_SIZE.DECIMAL_PLACES notation for the field size. Field
sizes can be found in PeopleSoft Application Designer, or via a direct query of the PeopleTools tables. Also, for facts and dimensions, there are a
number of PeopleBooks which explain the table layouts.
Field Description The description of each field that appears within the respective record definition. Field descriptions are available in PeopleSoft Application
Designer. Also, for facts and dimensions, there are a number of PeopleBooks which explain the table layouts.
Key Field For each field, insert a Y in this column if the field is part of the key structure for the table. Key structures are depicted in PeopleSoft Application
Designer. Also, for facts and dimensions, there are a number of PeopleBooks which explain the table layouts.
Required Field For each field, insert a Y in this column if this is a required field in the record layout. Required fields are depicted in PeopleSoft Application
Designer. Also, for facts and dimensions, there are a number of PeopleBooks which explain the table layouts.
Comments Any comments which need to be captured regarding each field.
Business Metadata Design
Table Business Name The business name of the table as it will be specified within the buiness intelligence tool. For example PS_D_EMP_JOB would be named
Employee Job Dimension in the business metadata. This will be the value that is seen by users who are not familiar with the data model and
needs to be as clear as possible.
Field Business Name The business name of the field as it will be specified within the buiness intelligence tool. This will be the value that is seen by users who are not
familiar with the data model and needs to be as clear as possible.
Field Business Description The business description for the field as it will be specified in the business intelligence tool. The description should be as verbose as appropriate.
This will be the value that is seen by users who are not familiar with the data model and needs to be as clear as possible.
7/15/2010 5:21 PM 3 of 150
OAKS FIN Operational Reporting Data Warehouse
FIN - Data Dictionary: Reporting Subject Area
Subject Area Materialized View or View Reporting Tables Description Of Reporting Tables ERP Tables Used OWS Source Tables Used
Name
Assets PS_OH_AM_ASSET_VW OAKS Asset Reporting Table The OAKS Asset Reporting Table is used to capture physical PS_ASSET PS_OH_S_ASSET
asset information. Examples of physical information include asset PS_PARENT_ASSET PS_OH_S_ PRNT_ASSET
description, manufacturer, location, custodian and condition. PS_ASSET_ACQ_DET PS_OH_S_AM_ACQ_DET
PS_ASSET_LOCATION PS_OH_S_AM_LOCAT
PS_AM_LOCATION_TBL PS_OH_S_AM_LOC_TBL
PS_LEASE PS_OH_S_LEASE
PS_LEASE_SCHED PS_OH_S_LEASE_SCHD
PS_LEASE_SCH_ID PS_OH_S_LSE_SCH_ID
PS_ASSET_ ATTRIBUTE PS_OH_S_AM_ATTRIB
PS_ASSET_CUSTODIAN PS_OH_S_AM_ CUSTOD
PS_OH_ASSET_BLDG PS_OH_S_OH_AM_BLDG
PS_CATEGORY_TBL PS_OH_S_CATEG_TBL
PS_ASSET_CLASS_TBL PS_OH_S_AM_CLASS
PS_PROFILE_TBL PS_OH_S_PRFILE_TBL
PS_ASSET_FSC PS_OH_S_ASSET_FSC
PS_FED_SUP_CLASS PS_OH_S_FED_SCLASS
PS_BUS_UNIT_TBL_FS PS_OH_S_BUS_UNT_FS
PS_ASSET_COMMENTS PS_OH_S_AM_COMMENT
Available Assets PS_OH_AM_ASSET_VW OAKS Available Assets Reporting The OAKS Available Assets Reporting Table is used to capture PS_ASSET PS_OH_S_ASSET
Table physical asset information for only available assets. Examples of PS_PARENT_ASSET PS_OH_S_ PRNT_ASSET
physical information include asset description, manufacturer, PS_ASSET_ACQ_DET PS_OH_S_AM_ACQ_DET
location, custodian and condition. PS_ASSET_LOCATION PS_OH_S_AM_LOCAT
PS_AM_LOCATION_TBL PS_OH_S_AM_LOC_TBL
PS_LEASE PS_OH_S_LEASE
PS_LEASE_SCHED PS_OH_S_LEASE_SCHD
PS_LEASE_SCH_ID PS_OH_S_LSE_SCH_ID
PS_ASSET_ ATTRIBUTE PS_OH_S_AM_ATTRIB
PS_ASSET_CUSTODIAN PS_OH_S_AM_ CUSTOD
PS_OH_ASSET_BLDG PS_OH_S_OH_AM_BLDG
PS_CATEGORY_TBL PS_OH_S_CATEG_TBL
PS_ASSET_CLASS_TBL PS_OH_S_AM_CLASS
PS_PROFILE_TBL PS_OH_S_PRFILE_TBL
PS_ASSET_FSC PS_OH_S_ASSET_FSC
PS_FED_SUP_CLASS PS_OH_S_FED_SCLASS
PS_BUS_UNIT_TBL_FS PS_OH_S_BUS_UNT_FS
PS_ASSET_COMMENTS PS_OH_S_AM_COMMENT
Asset Accounting PS_OH_AM_ACCTG_VW OAKS Asset Accounting The Asset Accounting Reporting Table is used to store the PS_ASSET PS_OH_S_ASSET
Reporting Table accounting information for each asset. PS_BOOK PS_OH_S_BOOK
PS_DIST_LN PS_OH_S_DIST_LN
Asset Cost PS_OH_AM_COST_VW OAKS Asset Cost Reporting The Asset Cost Reporting Table is used to store the cost PS_ASSET PS_OH_S_ASSET
Table transactions associated with an asset. PS_BOOK PS_OH_S_BOOK
PS_COST PS_OH_S_COST
PS_RETIREMENT PS_OH_S_RETIREMENT
Asset Depreciation PS_OH_AM_DEPR_VW OAKS Asset Depreciation The Asset Depreciation Reporting Table is used to store the PS_ASSET PS_OH_S_ASSET
Reporting Table depreciation information for each asset. PS_BOOK PS_OH_S_BOOK
PS_DEPRECIATION PS_OH_S_AM_DEPR
Billing PS_OH_BILLNG_VW OAKS Billing Reporting Table The OAKS Billing Reporting Table provides users with information PS_BI_HDR PS_BI_HDR
related to billing invoices, and associated accounting and pending PS_BI_HDR_NOTE PS_OH_S_BI_HDR_NOT
item information. PS_BI_LINE PS_BI_LINE
PS_BI_LINE_NOTE PS_OH_S_BI_LNE_NOT
PS_BI_ACCT_ENTRY PS_OH_S_BI_ACCT_EN
PS_BI_INSTALL_SCHE PS_OH_S_BI_INSTALL
PS_BI_SCHEDULE PS_OH_S_BI_SCHED
PS_BI_LINE_DST PS_OH_S_BI_LNE_DST
7/15/2010 5:21 PM 4 of 150
OAKS FIN Operational Reporting Data Warehouse
FIN - Data Dictionary: Reporting Subject Area
Subject Area Materialized View or View Reporting Tables Description Of Reporting Tables ERP Tables Used OWS Source Tables Used
Name
General Ledger Journal PS_OH_JRNL_TRN_VW OAKS Journal Transaction The Journal Transaction Reporting Table holds information about PS_JRNL_HEADER PS_JRNL_HEADER
Transaction Reporting Table the business unit, ledger, journal ID, journal date, line description, PS_JRNL_LN PS_JRNL_LN
who entered the journal, the source of the transaction (Accounts PS_SOURCE_TBL PS_OH_S_SOURCE_TBL
Payable, Accounts Receivable, Human Resources, etc.) and the PSXLATITEM PSXLATITEM
Chartfield distributions. The various tables are pulled into one PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
easy-to-use reporting table. PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
General Ledger Ledger PS_OH_LEDGER_VW OAKS Ledger Balance Reporting The Ledger Balance Reporting Table holds information about the PS_LEDGER PS_LEDGER
Balance Table business unit, ledger, Chartfields, and the posted total amount. PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
The various tables are pulled into one easy-to-use reporting table. PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
General Ledger Commitment PS_OH_KK_BUDGET_VW OAKS Commitment Control The OAKS Commitment Control Budgets Reporting Table PS_KK_BUDGET_HDR PS_KK_BUDGET_HDR
Control Budgets Budgets Reporting Table contains detailed budget journal data such as budget journal ID, PS_KK_BUDGET_LN PS_KK_BUDGET_LN
date, and budget journal descriptions. All budget journals, PSXLATITEM PSXLATITEM
regardless of budget ledger, will be included in this table. PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
General Ledger Commitment PS_OH_LEDGER_KK_VW OAKS Commitment Control The Commitment Control Ledger Reporting Table holds PS_LEDGER_KK PS_LEDGER_KK
Control Ledger Ledger Reporting Table information about the ledger balances for each budget, pre- PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
encumbrance, encumbrance, and expense ledger for all PS_DEPT_TBL PS_DEPT_TBL
accounting periods and fiscal years. The various tables are pulled PS_FUND_TBL PS_FUND_TBL
into one easy-to-use reporting table. PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
7/15/2010 5:21 PM 5 of 150
OAKS FIN Operational Reporting Data Warehouse
FIN - Data Dictionary: Reporting Subject Area
Subject Area Materialized View or View Reporting Tables Description Of Reporting Tables ERP Tables Used OWS Source Tables Used
Name
General Ledger Commitment PS_OH_KK_LIQUID_VW OAKS Commitment Control The Commitment Control Liquidation Reporting Table holds PS_KK_ACTIVITY_LOG PS_OH_S_KK_ACT_LOG
Control Liquidation Liquidation Reporting Table information about the ledger balances for each budget, pre- PS_KK_SOURCE_HDR PS_OH_S_KK_SRC_HDR
encumbrance, encumbrance, and expense ledger for all PS_KK_SOURCE_LN PS_OH_S_KK_SRC_LN
accounting periods and fiscal years. PS_KK_LIQUIDATION PS_OH_S_KK_LIQUIDT
PSXLATITEM PSXLATITEM
PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
General Ledger Commitment PS_OH_KK_RFRNCD_VW OAKS Commitment Control The Commitment Control Referenced Reporting Table holds PS_KK_ACTIVITY_LOG PS_OH_S_KK_ACT_LOG
Control Referenced Referenced Reporting Table information about the ledger balances for each budget, pre- PS_KK_SOURCE_HDR PS_OH_S_KK_SRC_HDR
encumbrance, encumbrance, and expense ledger for all PS_KK_SOURCE_LN PS_OH_S_KK_SRC_LN
accounting periods and fiscal years. PS_KK_LIQUIDATION PS_OH_S_KK_LIQUIDT
PS_KK_REFERENCED PS_OH_S_KK_RFRNCD
PSXLATITEM PSXLATITEM
PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
General Ledger Grants PS_OH_GRANT_VW OAKS General Ledger Grants The General Ledger Grants Reporting table will include an agency- PS_OH_S_GRANT_TBL PS_OH_S_GRANT_TBL
Reporting Table use field to allow state agencies flexibility to use this field to query PS_OH_S_GRANT_TBL2 PS_OH_S_GRANT_TBL2
and report on their grants from this field. The table also will PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
include OAKS-generated information on the user and the date of PS_DEPT_TBL PS_DEPT_TBL
the last record update. The CAS lifetime revenues and PS_FUND_TBL PS_FUND_TBL
expenditures can be queried at the fund level, if desired. The PS_PRODUCT_TBL PS_PRODUCT_TBL
various tables are pulled into one easy-to-use reporting table. PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
GL Lifetime Expenditure and PS_OH_LFE_EXREV_VW OAKS GL Lifetime Expenditure The base Reporting Table holds information about the PS_GL_ACCOUNT_TBL PS_S_GL_ACCT_TBL
Revenue and Revenue ChartFields, monetary and posted and total amount from staging PS_LEDGER_KK PS_LEDGER_KK
table queries. PS_LEDGER PS_LEDGER
PS_VCHR_ACCTG_LINE PS_VCHR_ACCTG_LINE
PS_VOUCHER PS_VOUCHER
PS_PYMNT_VCHR_XREF PS_PYMNT_VCHR_XREF
PS_ITEM PS_ITEM
PS_ITEM_DST PS_ITEM_DST
PS_SET_CNTRL_TBL PS_SET_CNTRL_TBL
PS_GL_ACCOUNT_TBL PS_S_GL_ACCT_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
General Ledger Account PS_OH_FN_GL_ACT_VW OAKS General Ledger Account The General Ledger Account Configuration reporting table PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
Configuration Configuration Reporting Table specifies the balance sheet account or operating account.
General Ledger Department PS_OH_FN_DEPT_VW OAKS General Ledger The General Ledger Department Configuration, chartfield PS_DEPT_TBL PS_DEPT_TBL
Configuration Department Configuration reporting table is used to capture the financial management view
Reporting Table of the State's agencies, boards, and commissions.
7/15/2010 5:21 PM 6 of 150
OAKS FIN Operational Reporting Data Warehouse
FIN - Data Dictionary: Reporting Subject Area
Subject Area Materialized View or View Reporting Tables Description Of Reporting Tables ERP Tables Used OWS Source Tables Used
Name
General Ledger Fund PS_OH_FN_FUND_VW OAKS General Ledger Fund The General Ledger Fund Configuration, chartfield reporting table PS_FUND_TBL PS_FUND_TBL
Configuration Configuration Reporting Table is defined as a financial and accounting entity with a self-
balancing set of accounts. It records cash and other financial
resources, with related liabilities, fund balance and any
corresponding changes which are segregated for the purpose of
carrying on specific activities or attaining certain objective in
accordance with special regulations, restrictions, or limitations.
General Ledger Appropriation PS_OH_FN_PROD_VW OAKS General Ledger The General Ledger Appropriation Line Item Configuration PS_PRODUCT_TBL PS_PRODUCT_TBL
Configuration Appropriation Line Item reporting table is seven-character code that identifies and defines
Configuration Reporting Table an appropriation in the Ohio Administrative Knowledge System
(OAKS). For example, in ALI CAP-010, the line item is identified
as capital (CAP) and the type of expense 010, for capital
improvements. Line item codes are used by the legislature for
appropriation purposes and by OAKS for budgeting and reporting.
General Ledger Program PS_OH_FN_PROG_VW OAKS General Ledger Program The General Ledger Program Configuration, chartfield is used to PS_PROGRAM_TBL PS_PROGRAM_TBL
Configuration Configuration Reporting Table capture groups of related activities that cross organizational
boundaries and are directed towards the accomplishment of a set
of recognizable objectives.
General Ledger Project PS_OH_FN_PROJ_VW OAKS General Ledger Project The General Ledger Project Configuration, chartfield reporting PS_PROJECT PS_PROJECT
Configuration table is used to capture and controls project and grant
Configuration Reporting Table
information.
General Ledger Class PS_OH_FN_CLS_CF_VW OAKS General Ledger Class The General Ledger Class Chartfield Configuration reporting table PS_CLASS_CF_TBL PS_CLASS_CF_TBL
Chartfield Configuration Chartfield Configuration Reporting when combined with a Fund, Organization, Program Code, and
Table Budget Reference, it identifies the activity for an appropriation
which identifies the Class chartfield.
General Ledger Chartfield PS_OH_CF_ATTRIB_VW OAKS General Ledger Chartfield The General Ledger Chartfield Attribute Configuration reporting PS_CF_ATTRIB_TBL PS_OH_S_CFATTR_TBL
Attribute Configuration Attribute Configuration Reporting table specifies the balance sheet account or operating account.
Table
General Ledger Chartfield 1 PS_OH_FN_CH+C34FLD1_V OAKS General Ledger ChartField The General Ledger Chartfield 1 Configuration reporting table is PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
Configuration W 1 Configuration Reporting Table used to capture specific activities associated with Projects/Grants
transactions. It will be included in the Budget Structures.
General Ledger Chartfield 2 PS_OH_FN_CHFLD2_VW OAKS General Ledger ChartField The General Ledger Chartfield 2 Configuration reporting table is PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
Configuration 2 Configuration Reporting Table used for capturing Agency specific values that are not captured by
any of the other chartfields. May be used to capture data formerly
coded in Function, Activity or Extension. It will not be included in
the Budget Structures.
General Ledger Chartfield 3 PS_OH_FN_CHFLD3_VW OAKS General Ledger ChartField The General Ledger Chartfield 3 Configuration reporting table is PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
Configuration 3 Configuration Reporting Table Agency Use for OAKS.
General Ledger Operating Unit PS_OH_FN_OP_UNT_VW OAKS General Ledger Operating The General Ledger Operating Unit Configuration chartfield PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
Configuration Unit Configuration Reporting reporting table is used for intra-unit accounting between entities.
Table This chartfield is delivered with an association to the operating
unit chartfield but it can be associated with any fully configurable
chartfield.
General Ledger Budget PS_OH_FN_BUD_RF_VW OAKS General Ledger Budget The General Ledger Budget Reference Configuration reporting PS_BUD_REF_TBL PS_BUD_REF_TBL
Reference Configuration Reference Configuration table is used to identify unique budgets, which is necessary when
Reporting Table individual budgets share budget keys and overlapping budget
periods. Budget reference values can be used as a balancing
chartfield to maintain a balanced set of books by budget.
7/15/2010 5:21 PM 7 of 150
OAKS FIN Operational Reporting Data Warehouse
FIN - Data Dictionary: Reporting Subject Area
Subject Area Materialized View or View Reporting Tables Description Of Reporting Tables ERP Tables Used OWS Source Tables Used
Name
Purchasing - Purchase Order PS_OH_PO_TRANS_VW OAKS Purchasing - Purchase The Purchasing - Purchase Order Reporting Table provides users PS_PO_LINE_DISTRIB PS_PO_LINE_DISTRIB
Order Reporting Table with access to detailed information for all purchase orders PS_PO_HDR PS_PO_HDR
(open,closed,etc) at the Chartfield distribution level. The various PSXLATITEM PSXLATITEM
tables are pulled into a single reporting table. PS_VENDOR PS_VENDOR
PS_VENDOR_ADDR PS_VENDOR_ADDR
PS_LOCATION_TBL PS_LOCATION_TBL
PS_PO_LINE PS_PO_LINE
PS_ITM_CAT_TBL PS_ITM_CAT_TBL
PS_PO_LINE_SHIP PS_PO_LINE_SHIP
PS_SHIPTO_TBL PS_SHIPTO_TBL
PS_CHNG_RQST PS_OH_S_CHG_REQ
PS_CHNG_RQST_DTL PS_OH_S_CHG_REQ_DL
PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
Purchasing - Items PS_OH_PO_ITEMS_VW OAKS Purchasing - Items The Purchasing - Items Reporting Table provides users with PS_ITM_VNDR_UOM_PR PS_ITM_VNDR_UOM_PR
Reporting Table access to detailed information and pricing history on all vendor PS_ITM_CAT_TBL PS_ITM_CAT_TBL
items. Included in this table will be the item ID, vendor, category PS_MASTER_ITEM_TBL PS_MASTER_ITEM_TBL
CD, manufacturer, item description, vendor price history, and who PS_ITM_SHIPTO PS_OH_S_ITM_SHIPTO
approved and last modified the item information. The various PS_SHIPTO_TBL PS_SHIPTO_TBL
tables are pulled into a single reporting table. PS_PURCH_ITEM_ATTR PS_OH_S_PUR_ITM_AT
PS_ITM_VENDOR PS_ITM_VENDOR
PSXLATITEM PSXLATITEM
Purchasing - Contract PS_OH_CONTRACT_VW OAKS Purchasing - Contract The Purchasing - Contract Reporting Table will provide users with PS_CNTRCT_DEFAULTS PS_OH_S_CTRCT_DFLT
Reporting Table access to detailed information for all vendor contracts. The PS_CNTRCT_LINE PS_CNTRCT_LINE
various tables are pulled into one easy-to-use reporting table. PS_VENDOR PS_VENDOR
PS_CNTRCT_HDR PS_CNTRCT_HDR
PS_ITM_CAT_ TBL PS_ITM_CAT_ TBL
Purchasing - Requisition PS_OH_REQUISTN_VW OAKS Purchasing - Requisition The Purchasing - Requisition Reporting Table will provide users PS_REQ_LN_DISTRIB PS_REQ_LN_DISTRIB
Reporting Table with access to detailed information for all requisitions (open, PS_REQ_HDR PS_REQ_HDR
closed, etc) at the Chartfield distribution level. The various tables PS_OH_REQ_HDR PS_OH_S_REQ_HDR
are pulled into one easy-to-use reporting table. PS_LOCATION_TBL PS_LOCATION_TBL
PS_REQ_LINE PS_REQ_LINE
PS_VENDOR PS_VENDOR
PS_ITM_CAT_TBL PS_ITM_CAT_TBL
PS_REQ_LINE_SHiP PS_OH_S_REQ_LN_SHP
PS_SHIPTO_TBL PS_SHIPTO_TBL
PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
7/15/2010 5:21 PM 8 of 150
OAKS FIN Operational Reporting Data Warehouse
FIN - Data Dictionary: Reporting Subject Area
Subject Area Materialized View or View Reporting Tables Description Of Reporting Tables ERP Tables Used OWS Source Tables Used
Name
Purchasing - Return to Vendor PS_OH_RTV_VW OAKS Purchasing - Return to The Purchasing - Return to Vendor Reporting Table will provide PS_RTV_LN_DISTRIB PS_RTV_LN_DISTRIB
Vendor Reporting Table users with access to information regarding return to vendor PS_RTV_HDR PS_RTV_HDR
transactions which occur when goods or services purchased are PS_VENDOR_ADDR PS_VENDOR_ADDR
returned to a vendor. The various tables are pulled into one easy- PS_VENDOR PS_VENDOR
to-use reporting table. PS_RTV_LN PS_RTV_LN
PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
Purchasing - Receipt PS_OH_RECEIPT_VW OAKS Purchasing - Receipt The Purchasing - Receipt Reporting Table will provide users with PS_RECV_LN_DISTRIB PS_RECV_LN_DISTRIB
Reporting Table detail information for all goods received, inspected, returned, and PS_RECV_HDR PS_RECV_HDR
put away. This area stores receiver information at the ChartField PS_SHIPTO_TBL PS_SHIPTO_TBL
distribution level. The various tables are pulled into a single PS_VENDOR PS_VENDOR
reporting table. PS_RECV_LN_SHIP PS_RECV_LN_SHIP
PS_ITM_CAT_TBL PS_ITM_CAT_TBL
PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
Purchasing - eControlling PS_OH_ECB_VW OAKS eControlling Board Waiver The eControlling Board Waiver Reporting Table will provide users PS_OH_ECB_WAIVERS PS_OH_ECB_WAIVERS
Board Waiver Reporting Table with access to information regarding Controlling Board Waivers. PS_VENDOR PS_VENDOR
Purchasing - Vendor Spend PS_OH_THRSHLD_VW OAKS Vendor Spend Reporting The Vendor Spend Reporting Table will provide users with access PS_OH_THRSHLD_STAT PS_OH_THRSHLD_STAT
Table to encumbrance and expense information per vendor by fiscal PS_VENDOR PS_VENDOR
year.
Purchasing - DAS Release and PS_OH_RP_DAS_VW OAKS DAS Release and Permit The DAS Release and Permit Reporting Table will provide users PS_OH_RP_DAS PS_OH_RP_DAS
Permit Reporting Table with access to DAS Release and Permit detailed information. PS_DEPT_TBL PS_DEPT_TBL
PS_VENDOR PS_VENDOR
Purchasing - OIT Release and PS_OH_RP_OIT_VW OAKS OIT Release and Permit The OIT Release and Permit Reporting Table will provide users PS_OH_RP_OIT PS_OH_RP_OIT
Permit Reporting Table with access to OIT Release and Permit detailed information. PS_VENDOR PS_VENDOR
PS_CNTRCT_HDR PS_CNTRCT_HDR
Accounts Receivable PS_OH_CUSTOMER_VW OAKS Customer Information The Customer Information Reporting Table holds information PS_CUSTOMER PS_CUSTOMER
Customer Information Reporting Table about details related to accounts receivable customers, including: PS_CUST_ADDR_SEQ PS_OH_S_CUST_AD_SQ
name, shipping, address, contact, payment and billing information. PS_CONTACT PS_OH_S_CONTACT
The various tables are pulled into one easy-to-use reporting table. PS_CONTACT_PHN PS_OH_S_CNTACT_PHN
PSXLATITEM PSXLATITEM
PS_CUST_ADDRESS PS_CUST_ADDRESS
PS_CUST_OPTION PS_OH_S_CUST_OPTN
PS_CONTACT_CUST PS_OH_S_CNTCT_CUST
7/15/2010 5:21 PM 9 of 150
OAKS FIN Operational Reporting Data Warehouse
FIN - Data Dictionary: Reporting Subject Area
Subject Area Materialized View or View Reporting Tables Description Of Reporting Tables ERP Tables Used OWS Source Tables Used
Name
Accounts Receivables PS_OH_AR_PAYMNT_VW OAKS Receivables Payment The Receivables Payment Information Reporting Table will PS_PAYMENT_ITEM PS_PAYMENT_ITEM
Payment Information Information Reporting Table provide users with access to information about miscellaneous PS_PAY_MISC_DST PS_PAY_MISC_DST
receipts and customer payment information. PS_PAYMENT_ID_CUST PS_OH_S_PAY_ID_CST
PS_PAYMENT_ID_ITEM PS_OH_S_PAY_ID_ITM
PS_DEPOSIT_CONTROL PS_DEPOSIT_CONTROL
PS_PAYMENT PS_PAYMENT
PSXLATITEM PSXLATITEM
PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_CF_ATTRIB_TBL PS_OH_S_CFATTR_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
Accounts Receivables Pending PS_OH_PNDNG_ITEM_VW OAKS Receivables Pending Item The Receivables Pending Item Information Reporting Table holds PS_PENDING_DST PS_PENDING_DST
Item Information Reporting Table detail information for payments applied to pending items. PS_PENDING_ITEM PS_PENDING_ITEM
Included in this table will be the business unit, Customer ID, item PS_GROUP_CONTROL PS_GROUP_CONTROL
(invoice number), Deposit ID, payment amount, and Chartfield PSXLATITEM PSXLATITEM
distributions. PS_GL_ACCOUNT PS_GL_ACCOUNT
PS_BUD_REF_TBL PS_BUD_REF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
Accounts Receivables Item PS_OH_AR_ITEM_VW OAKS Receivables Item The Receivables Item Information Reporting Table holds detail PS_ITEM_DST PS_ITEM_DST
Information Reporting Table information for payments applied to items. Included in this table PS_ITEM PS_ITEM
will be the business unit, Customer ID, item (invoice number), PS_GROUP_CONTROL PS_GROUP_CONTROL
Deposit ID, payment amount, and Chartfield distributions. PS_ITEM_ACTIVITY PS_ITEM_ACTIVITY
PSXLATITEM PSXLATITEM
PS_GL_ACCOUNT PS_GL_ACCOUNT
PS_BUD_REF_TBL PS_BUD_REF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_FUND_TBL PS_FUND_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
PS_PROJECT PS_PROJECT
Accounts Payable Vendors PS_OH_VENDOR_VW OAKS Vendor Reporting Table The Vendor Reporting Table will provide users with detail PS_VENDOR PS_VENDOR
information for all vendors. It stores vendor and related payment PS_VENDOR_ADDR PS_VENDOR_ADDR
information. Also included is vendor location, address, phone and PS_VENDOR_LOC PS_VENDOR_LOC
government certificate. PS_VENDOR_PAY PS_OH_S_VNDR_PAY
PS_VNDR_GOV_CERT PS_VNDR_GOV_CERT
PS_VENDOR_ADDR_PHN PS_OH_S_VNDR_ADDPH
PS_VENDOR_ID_NBRS PS_VENDOR_ID_NBRS
7/15/2010 5:21 PM 10 of 150
OAKS FIN Operational Reporting Data Warehouse
FIN - Data Dictionary: Reporting Subject Area
Subject Area Materialized View or View Reporting Tables Description Of Reporting Tables ERP Tables Used OWS Source Tables Used
Name
Accounts Payable Vouchers PS_OH_VOUCHER_VW OAKS Voucher Reporting Table The Voucher Reporting Table holds information at the chartfield PS_VOUCHER PS_VOUCHER
distribution level. Therefore, all amount and quantity fields are PSXLATITEM PSXLATITEM
reflective at this level. Included in this table will be the business PS_VOUCHER_LINE PS_VOUCHER_LINE
unit, voucher ID, the description of the voucher items, date PS_DISTRIB_LINE PS_OH_DISTRIB_LINE
entered, who entered the voucher, and the chartfield distribution PS_VCHR_VNDR_INFO PS_VCHR_VNDR_INFO
for each voucher item. PS_VCHR_VNDR_BANK PS_VCHR_VNDR_BANK
PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_PROJECT PS_PROJECT
PS_FUND_TBL PS_FUND_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
Accounts Payable Payments PS_OH_PYMNT_VW OAKS Accounts Payable The OAKS Payment Reporting table will provide users with detail PS_PAYMENT_TBL PS_PAYMENT_TBL
Payments Reporting Table information for all payments generated out of the OAKS Accounts PS_PYMNT_ADVICE PS_PYMNT_ADVICE
Payable module. This table stores information relating to warrant PS_PYMNT_VCHR_XREF PS_PYMNT_VCHR_XREF
number, or EFT payment number, vendor paid, gross payment PSXLATITEM PSXLATITEM
amount, discount taken, payment date, etc.
Accounts Payable P-Card PS_OH_PCARD_VW OAKS P-CARD Information The P-CARD Information Reporting Table holds detail information PS_CC_CARD_DATA PS_CC_CARD_DATA
Reporting Table for all charges/transactions made with procurement cards. PS_CC_TRANS_LINE PS_CC_TRANS_LINE
Included in this table will be the employee ID, credit card number, PS_CC_TRANS_DIST PS_CC_TRANS_DIST
billing date, merchant, amount, and the related chartfields. PS_CC_CARD_DATA_EX PS_CC_CARD_DATA_EX
PS_PERSONAL_DATA PS_PERSONAL_DATA
PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
PS_BUD_REF_TBL PS_BUD_REF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_PROJECT PS_PROJECT
PS_FUND_TBL PS_FUND_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
Accounts Payable Voucher PS_OH_VCHR_ACCT_VW OAKS Voucher Accounting The Voucher Accounting Information reporting table holds PS_VCHR_ACCTG_LINE PS_VCHR_ACCTG_LINE
Accounting Information Reporting Table accounting information for expenditures and payments processed PS_GL_ACCOUNT_TBL PS_GL_ACCOUNT_TBL
through the OAKS Accounts Payable system. PS_BUD_REF_TBL PS_BUD_REF_TBL
PS_CHARTFIELD1_TBL PS_CHARTFIELD1_TBL
PS_CHARTFIELD2_TBL PS_CHARTFIELD2_TBL
PS_CHARTFIELD3_TBL PS_CHARTFIELD3_TBL
PS_CLASS_CF_TBL PS_CLASS_CF_TBL
PS_DEPT_TBL PS_DEPT_TBL
PS_PROJECT PS_PROJECT
PS_FUND_TBL PS_FUND_TBL
PS_OPER_UNIT_TBL PS_OPER_UNIT_TBL
PS_PRODUCT_TBL PS_PRODUCT_TBL
PS_PROGRAM_TBL PS_PROGRAM_TBL
Accounts Payable ECAC PS_OH_ECAC_VW OAKS ECAC Reporting Table The ECAC Reporting Table holds information that will be used for PS_OH_ECAC_TBL PS_OH_S_ECAC_TBL
eCommerce transactions.
Accounts Payable Speed Chart PS_OH_SPDCHRT_VW OAKS Speed Chart Information The Speed Chart Information Reporting Table is used for Speed PS_SPEEDCHART_DTL PS_OH_S_SC_DTL
Reporting Table Charts (pseudo codes). PS_SPEEDCHART_HDR PS_OH_S_SC_HDR
PSXLATITEM PSXLATITEM
Account Tree Relationship PS_OH_R_ACCOUNT_VW OAKS Account Tree Relationship The OAKS Account Tree Relationship Table is used to capture N/A N/A
Reporting Tree Table data from the recursive relationship of the Account Tree.
Account Tree Hierarchical PS_OH_H_ACCOUNT_VW OAKS Account Tree Hierarchical The OAKS Account Tree Hierarchical Reporting Table is used to N/A N/A
Reporting Tree Reporting Table capture data from the account hierarchy table for the flattened and
de-normalized Account Tree.
7/15/2010 5:21 PM 11 of 150
OAKS FIN Operational Reporting Data Warehouse
FIN - Data Dictionary: Reporting Subject Area
Subject Area Materialized View or View Reporting Tables Description Of Reporting Tables ERP Tables Used OWS Source Tables Used
Name
Department Tree Relationship PS_OH_R_DEPT_VW OAKS Department Tree The OAKS Department Tree Relationship Table is used to N/A N/A
Reporting Tree Relationship Table capture data from the recursive relationship of the Department
Tree.
Department Tree Hierarchical PS_OH_H_DEPT_VW OAKS Department Tree The OAKS Department Tree Hierarchical Reporting Table is used N/A N/A
Reporting Tree Hierarchical Reporting Table to capture data from the Department hierarchy table for the
flattened and de-normalized Department Tree.
Fund Tree Relationship PS_OH_R_FUND_VW OAKS Fund Tree Relationship The OAKS Fund Tree Relationship Table is used to capture data N/A N/A
Reporting Tree Table from the recursive relationship of the Fund Tree.
Fund Tree Hierarchical PS_OH_H_FUND_VW OAKS Fund Tree Hierarchical The OAKS Fund Tree Hierarchical Reporting Table is used to N/A N/A
Reporting Tree Reporting Table capture data from the Fund hierarchy table for the flattened and
de-normalized Fund Tree.
Program Tree Relationship PS_OH_R_PROGRAM_VW OAKS Program Tree Relationship The OAKS Program Tree Relationship Table is used to capture N/A N/A
Reporting Tree Table data from the recursive relationship of the Program Tree.
Program Tree Hierarchical PS_OH_H_PROGRAM_VW OAKS Program Tree Hierarchical The OAKS Program Tree Hierarchical Reporting Table is used to N/A N/A
Reporting Tree Reporting Table capture data from the Program hierarchy table for the flattened
and de-normalized Program Tree.
Product Tree Relationship PS_OH_R_PRODUCT_VW OAKS Product Tree Relationship The OAKS Product Tree Relationship Table is used to capture N/A N/A
Reporting Tree Reporting Table data from the recursive relationship of the Product Tree.
Product Tree Hierarchical PS_OH_H_PRODUCT_VW OAKS Product Tree Hierarchical The OAKS Product Tree Hierarchical Reporting Table is used to N/A N/A
Reporting Tree Reporting Table capture data from the Product hierarchy table for the flattened and
de-normalized Product Tree.
7/15/2010 5:21 PM 12 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Assets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
4 1 PS_ASSET BUSINESS_UNIT Business Unit OH_AM_ASSET_VW BUSINESS_UNIT Character 5 Business Unit Y OAKS Asset Reporting Table The OAKS Asset Reporting Table Business Unit Business Unit is an operational subset of an organization.
2 PS_ASSET ASSET_ID Asset ID OH_AM_ASSET_VW ASSET_ID Character 12 Asset ID Y is used to capture physical asset Asset ID Asset ID is the distinct number assigned to an asset when it is
information. Examples of physical entered into the system. It uniquely defines an asset within a
5 information include asset Business Unit.
3 PS_ASSET PARENT_ID Parent ID OH_AM_ASSET_VW PARENT_ID Character 12 Parent ID Y description, manufacturer, location, Parent ID For child assets, this field contains the parent asset's Asset ID.
6 custodian and condition.
4 PS_ASSET_ACQ_DET SEQUENCE_NBR_6 Asset Acquisition Sequence Number OH_AM_ASSET_VW SEQUENCE_NBR_6 Number 6 Asset Acquisition Sequence Number Y Asset Acquisition Sequence Number This field is used to sequence acquisition detail rows.
7
5 PS_ASSET_LOCATION EFFDT Location Effective Date OH_AM_ASSET_VW OH_AM_LOC_EFFDT Date 10 Asset Location Effective Date Y Asset Location Effective Date Effective Date from the Asset Location table. (Default Format:
yyyy-mm-dd).
8
6 PS_ASSET_LOCATION EFFSEQ Location Effective Sequence OH_AM_ASSET_VW OH_AM_LOC_EFFSEQ Nbr 3 Asset Location Effective Sequence Y Asset Location Effective Sequence The sequence number of the asset location. This will be one
unless the asset has had more than one location for a given
9 effective date.
7 PS_LOCATION_TBL EFFDT Location Effective Date OH_AM_ASSET_VW OH_LOC_EFFDT Date 10 Location Effective Date Location Effective Date Effective Date from Location table. (Default Format: yyyy-mm-
10 dd).
8 PS_AM_LOCATION_TBL EFFDT AM Location Table Effective Date OH_AM_ASSET_VW OH_LOC_TBL_EFFDT Date 10 AM Location Effective Date Y AM Location Effective Date Effective Date from the AM Location table. (Default Format: yyyy-
11 mm-dd).
9 PS_LEASE_SCHED PYMNT_DT Lease Schedule Payment Date OH_AM_ASSET_VW PYMNT_DT Date 10 Lease Schedule Payment Date Y Lease Schedule Payment Date For leased assets, these are the dates on which lease payments
12 are made. (Default Format: yyyy-mm-dd).
10 PS_ASSET_ATTRIBUTE EFFDT Asset Attribute Effective Date OH_AM_ASSET_VW OH_AM_ATTR_EFFDT Date 10 Asset Attribute Effective Date Y Asset Attribute Effective Date Effective Date from the Asset Attribute table. (Default Format:
13 yyyy-mm-dd).
11 PS_ASSET_CUSTODIAN EFFDT Asset Custodian Effective Date OH_AM_ASSET_VW OH_AM_CUST_EFFDT Date 10 Asset Custodian Effective Date Y Asset Custodian Effective Date Effective Date from the Asset Custodian table. (Default Format:
14 yyyy-mm-dd).
12 PS_ASSET_CUSTODIAN EFFSEQ Asset Custodian Effective Sequence OH_AM_ASSET_VW OH_AM_CUST_EFFSEQ Number 3 Asset Custodian Effective Sequence Y Asset Custodian Effective Sequence The sequence number of the asset‘s custodian. This will be one
unless the asset has had more than one custodian for a given
15 effective date.
13 PS_CATEGORY_TBL EFFDT Category Effective Date OH_AM_ASSET_VW OH_CATEG_EFFDT Date 10 Category Effective Date Category Effective Date Effective Date from the Category table. (Default Format: yyyy-
16 mm-dd).
14 PS_ASSET_CLASS_TBL EFFDT Asset Class Effective Date OH_AM_ASSET_VW OH_AM_CLASS_EFFDT Date 10 Class Effective Date Class Effective Date Effective Date from the Asset Class table. (Default Format: yyyy-
17 mm-dd).
15 PS_ASSET TAG_NUMBER Tag Number OH_AM_ASSET_VW TAG_NUMBER Character 12 Tag Number Tag Number For personal property, Tag Number is the number from an asset's
barcode label. For real property, Tag Number is a smart-coded
18 value that uniquely identifies an asset.
16 PS_ASSET DESCR Asset Description OH_AM_ASSET_VW OH_ASSET_DESCR Character 30 Asset Description Asset Description Description of the asset.
19
17 PS_ASSET ASSET_STATUS Asset Status OH_AM_ASSET_VW ASSET_STATUS Character 1 Asset Status Asset Status Asset Status is the current state of an asset within its lifecycle
20 (e.g., In Service, Disposed).
18 OH_AM_ASSET_VW OH_AM_STATUS_DESCR Character 30 Asset Status Description Asset Status Description Description of the Asset Status.
21
19 PS_ASSET FINANCIAL_ASSET_SW Capitalized Asset OH_AM_ASSET_VW FINANCIAL_ASSET_SW Character 1 Capitalized Asset Capitalized Asset Signifies whether an asset‘s cost has been capitalized (Y/N).
22
20 PS_ASSET AVAIL_SW Asset is Available OH_AM_ASSET_VW AVAIL_SW Character 1 Asset is Available Asset is Available Indicates whether the asset has been identified as available and
23 not being used.
21 PS_ASSET AVAIL_CONTACT Available Contact Name OH_AM_ASSET_VW AVAIL_CONTACT Character 30 Available Contact Name Available Contact Name Name of the person that should be contacted when the asset is
marked as "available" in the system.
24
22 PS_ASSET AVAIL_PHONE Available Contact Phone OH_AM_ASSET_VW AVAIL_PHONE Character 12 Available Contact Phone Available Contact Phone Phone number of the person that should be contacted when the
asset is marked as "available" in the system.
25
23 PS_ASSET ACQUISITION_CD Acquisition Code OH_AM_ASSET_VW ACQUISITION_CD Character 1 Acquisition Code Acquisition Code The Acquisition Code is the method through which an asset was
acquired (e.g., Purchased, Leased, Constructed, Donated).
26
24 PS_ASSET ACQUISITION_DT Acquisition Date OH_AM_ASSET_VW ACQUISITION_DT Date 10 Acquisition Date Acquisition Date Date the asset was acquired. (Default Format: yyyy-mm-dd).
27
25 PS_ASSET REPLACEMENT_COST Replacement Cost OH_AM_ASSET_VW REPLACEMENT_COST Sign 28 Replacement Cost Replacement Cost Indicates how much it would cost to replace an asset.
28
26 PS_ASSET REPLACE_COST_DT Replacement Cost Last Update OH_AM_ASSET_VW REPLACE_COST_DT Date 10 Replacement Cost Last Update Replacement Cost Last Update Date on which the asset‘s Replacement Cost was last updated.
(Default Format: yyyy-mm-dd).
29
30 27 PS_ASSET LEASE_ASSET_ID Leased Asset ID OH_AM_ASSET_VW LEASE_ASSET_ID Character 12 Leased Asset ID Leased Asset ID Displays the Asset ID of a leased asset.
28 PS_ASSET PROFILE_ID Asset Profile ID OH_AM_ASSET_VW PROFILE_ID Character 10 Asset Profile ID Asset Profile ID Asset Profile ID is a categorization code assigned to an asset that
defaults information about it (e.g., Useful Life) based on asset
31 type.
29 PS_ASSET ASSET_CLASS Asset Class OH_AM_ASSET_VW ASSET_CLASS Character 10 Asset Class Asset Class Asset Class is a category that defines an asset for reporting
32 purposes.
33 30 PS_ASSET MANUFACTURER Asset Manufacturer OH_AM_ASSET_VW MANUFACTURER Character 30 Manufacturer Manufacturer Company that made or produced an asset.
31 PS_ASSET MODEL Asset Model OH_AM_ASSET_VW MODEL Character 30 Model Model Number or name assigned to an equipment item by the
34 manufacturer.
35 32 PS_ASSET SERIAL_ID Serial Number OH_AM_ASSET_VW SERIAL_ID Character 20 Serial Number Serial Number Serial Number is a unique number that identifies an asset.
33 PS_ASSET PRODUCTION_DT Production Date OH_AM_ASSET_VW PRODUCTION_DT Date 10 Production Date Production Date The Production Date field contains the last date an asset was
counted in a physical inventory. (Default format: yyyy-mm-dd).
36
34 PS_ASSET LIFE Useful Life OH_AM_ASSET_VW LIFE Number 10 Useful Life Useful Life Useful Life is the number of periods (months) over which an asset
37 will be depreciated.
35 PS_ASSET HAZARDOUS_SW Hazardous Asset OH_AM_ASSET_VW OH_HAZARDOUS_SW Character 1 Hazardous Asset Hazardous Asset The Hazardous Asset field is used to identify that an asset is
considered predominant and/or significant hazardous material.
38
39 36 PS_PARENT_ASSET DESCR Parent Asset Description OH_AM_ASSET_VW OH_PARENT_AM_DESCR Character 30 Parent Asset Description Parent Asset Description Description of a parent asset.
37 PS_ASSET_ACQ_DET SYSTEM_SOURCE Asset Acquisition System Source OH_AM_ASSET_VW SYSTEM_SOURCE Character 3 System Source System Source The System Source identifies assets that have originated from the
40 OAKS Purchasing/Accounts Payable modules.
38 PS_ASSET_ACQ_DET CAPIITALIZATION_SW Capitalized Switch OH_AM_ASSET_VW OH_CAPIITALIZE_SW Character 1 Capitalization Status Capitalization Status Identifies the capitalization status of an acquisition detail row
41 (e.g., 1= To Be Capitalized, 2 = Already Capitalized).
39 PS_ASSET_ACQ_DET BUSINESS_UNIT_PO Purchasing Business Unit OH_AM_ASSET_VW BUSINESS_UNIT_PO Character 5 Purchasing Business Unit Purchasing Business Unit The Purchasing Business Unit is the agency that purchased the
42 asset.
40 PS_ASSET_ACQ_DET PO_ID Purchase Order Number OH_AM_ASSET_VW PO_ID Character 10 Purchase Order ID Purchase Order ID The Purchase Order ID field contains the asset‘s PO number for
assets that originate from the OAKS Purchasing/Accounts
43 Payable modules.
41 PS_ASSET_ACQ_DET BUSINESS_UNIT_AP Accounts Payable Business Unit OH_AM_ASSET_VW BUSINESS_UNIT_AP Character 5 Accounts Payable Business Unit Accounts Payable Business Unit The Accounts Payable Business Unit is the agency that
44 processed the voucher for the asset.
42 PS_ASSET_ACQ_DET VOUCHER_ID Voucher ID OH_AM_ASSET_VW VOUCHER_ID Character 8 Voucher ID Voucher ID The Voucher ID field contains the identifying number for the
45 voucher that paid for the asset.
43 PS_ASSET_ACQ_DET INVOICE_DT Invoice Date OH_AM_ASSET_VW INVOICE_DT Date 10 Invoice Date Invoice Date Invoice Date is the date on which the invoice for the asset was
46 received. (Default Format: yyyy-mm-dd).
7/15/20105:21 PM 13 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Assets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
44 PS_ASSET_ACQ_DET VENDOR_ID Vendor ID OH_AM_ASSET_VW OH_ACQ_VENDOR_ID Character 10 Vendor ID Vendor ID The Vendor ID is the identification number for the vendor from
47 which the asset was purchased.
48 45 PS_ASSET_ACQ_DET VENDOR_NAME Vendor Name OH_AM_ASSET_VW OH_VENDOR_NAME Character 30 Vendor Name Vendor Name The name of the vendor from which the asset was purchased.
49 46 PS_ASSET_ACQ_DET INVOICE_ID Invoice ID OH_AM_ASSET_VW INVOICE_ID Character 30 Invoice ID Invoice ID Invoice ID is the identification number of the asset‘s invoice.
47 PS_ASSET_ACQ_DET OPERATING_UNIT Operating Unit OH_AM_ASSET_VW OPERATING_UNIT Character 8 ISTV Xref ISTV Xref Operating Unit is used to record the ISTV Cross Reference
50 agency.
48 PS_OPER_UNIT_TBL DESCR ISTV XRef Description OH_AM_ASSET_VW OH_OPER_DESCR Character 30 ISTV XRef Description ISTV Xref Description Intra-State Transfer Voucher Cross Reference Description is free
51 flow text up to 30 characters.
49 PS_ASSET_ACQ_DET PRODUCT Product OH_AM_ASSET_VW PRODUCT Character 6 Appropriation Line Item Appropriation Line Item The Product chartfield is used by the State to capture
Appropriation Line Item (ALI), the legal spending authority by the
budget bill, and will be required on encumbrance and expense
52 transaction.
50 PS_PRODUCT_TBL DESCR Appropriation Line Item Description OH_AM_ASSET_VW OH_PROD_DESCR Character 30 Appropriation Line Item Description Appropriation Line Item Description Appropriation Line Item Description is free flow text up to 30
characters.
53
51 PS_ASSET_ACQ_DET FUND_CODE Fund Code OH_AM_ASSET_VW FUND_CODE Character 5 Fund Code Fund Code The Fund chartfield defines a fiscal and accounting entity with a
self-balancing set of accounts. It records cash and other financial
resources, together with related liabilities and residual equities or
balances, and any corresponding changes. Required on all
transactions.
54
52 PS_FUND_TBL DESCR Fund Description OH_AM_ASSET_VW OH_FUND_DESCR Character 30 Fund Description Fund Code Description Fund Code Description is free flow text up to 30 characters.
55
53 PS_ASSET_ACQ_DET CLASS_FLD Class Field OH_AM_ASSET_VW CLASS_FLD Character 5 Service Location Service Location Class field is used to capture the concept of Service Location
(state, county, city, district, building, etc.). This will allow the
state to track spending in relation to a geographical designation.
56
54 PS_CLASS_CF_TBL DESCR Service Location Description OH_AM_ASSET_VW OH_CLASS_DESCR Character 30 Service Location Description Service Location Description Service Location Description is free flow text up to 30 characters.
57
55 PS_ASSET_ACQ_DET PROGRAM_CODE Program Code OH_AM_ASSET_VW PROGRAM_CODE Character 5 Program Code Program Code The Program chartfield is used to capture the enterprise program
concept. The Program chartfield will enable the State to capture
the cost of providing a specific good or service in response to an
identified social or individual need or problem. Programs are
specific to an agency. Required on encumbrance and expense
58 transactions.
56 PS_PROGRAM_TBL DESCR Program Description OH_AM_ASSET_VW OH_PROG_DESCR Character 30 Program Description Program Code Description Program Code Description is free flow text up to 30 characters.
59
57 PS_ASSET_ACQ_DET BUDGET_REF Budget Reference OH_AM_ASSET_VW BUDGET_REF Character 8 Budget Reference Budget Reference The Budget Reference field is used to capture the federal fiscal
year for informational purposes. Some agencies have identified a
need to use this chartfield to identify the year for other purposes
not fulfilled by the system generated accounting and budget
period dates(e.g., the state fiscal year when recording indirect
costs in subsequent fiscal years). When not used to identify a
year for informational purposes, an agency may use this chartfield
to break an Appropriation Line Item into units for budget control.
60
58 PS_BUD_REF_TBL DESCR Budget Reference Description OH_AM_ASSET_VW OH_BUDG_DESCR Character 30 Budget Reference Description Budget Reference Description Budget Reference Description is free flow text up to 30
characters.
61
59 PS_ASSET_ACQ_DET CHARTFIELD1 Project ID OH_AM_ASSET_VW CHARTFIELD1 Character 10 Project ID Project ID Chartfield 1 is used to track project transactions when the project
costing module functionality is not required. Prior to the
implementation of the project costing module, all project
transactions will be tracked in this chartfield. A project is defined
as authorized expenditures for a specific purpose over a defined
period of time, and may cross fiscal years, fund, or departments.
Projects may be capital or non-capital, but are differentiated from
on-going operations by their lifecycle. This chartfield gives
agencies the ability to track project activity and grant activity in
62 separate chartfields.
60 PS_CHARTFIELD1_TBL DESCR Project Chartfield 1 Description OH_AM_ASSET_VW OH_CHFD1_DESCR Character 30 Project Description Project ID Description Project ID Description is free flow text up to 30 characters.
63
61 PS_ASSET_ACQ_DET CHARTFIELD2 Reporting ID OH_AM_ASSET_VW CHARTFIELD2 Character 10 Reporting ID Reporting ID Chartfield 2 is used to fulfill agency reporting requirements as
64 they relate to activities, tasks, or cost centers.
62 PS_CHARTFIELD2_TBL DESCR Reporting Chartfield 2 Description OH_AM_ASSET_VW OH_CHFD2_DESCR Character 30 Reporting Description Reporting ID Description Reporting ID Description is free flow text up to 30 characters.
65
63 PS_ASSET_ACQ_DET CHARTFIELD3 Agency Use OH_AM_ASSET_VW CHARTFIELD3 Character 10 Agency Use Agency Use Chartfield 3 is used to fulfill agency reporting requirements as
66 they relate to activities, tasks, or cost centers.
7/15/20105:21 PM 14 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Assets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
64 PS_CHARTFIELD3_TBL DESCR Agency Use Chartfield 3 Description OH_AM_ASSET_VW OH_CHFD3_DESCR Character 30 Agency Use Description Agency Use Description Agency Use Description is free flow text up to 30 characters.
67
65 PS_ASSET_ACQ_DET PROJECT_ID Project Identifier OH_AM_ASSET_VW PROJECT_ID Character 15 Grant/Project ID Grant/Project ID The Project ID chartfield is used to capture grant and project
transactions. All grant transactions will be tracked in this
chartfield to facilitate enterprise-wide reporting. This chartfield
may also be used to track project transactions after the project
costing module is implemented if an agency chooses to use the
project costing module functionality. This chartfield is designed to
track grant and project financial activity, which can cross budget
years, funds and departments. It is the gateway to the project
68 costing module functionality.
66 PS_PROJECT DESCR Grant/Project Description OH_AM_ASSET_VW OH_PROJ_DESCR Character 30 Grant/Project Description Grant/Project ID Description Grant/Project ID Description is free flow text up to 30 characters.
69
67 PS_ASSET_ACQ_DET DEPTID Department Identifier OH_AM_ASSET_VW DEPTID Character 10 Department ID Department ID The Department chartfield identifies the financial management
organizational entity associated with a particular financial
transaction. The State will use this chartfield to capture the State
and agency organization chart. Required on encumbrance,
70 expense, and revenue transactions.
68 PS_DEPT_TBL DESCR Department Description OH_AM_ASSET_VW OH_DEPT_DESCR Character 30 Department Description Department ID Description Department ID Description is free flow text up to 30 characters.
71
69 PS_ASSET_ACQ_DET CATEGORY Asset Category OH_AM_ASSET_VW CATEGORY Character 5 Asset Category Asset Category The Asset Category field classifies assets by major asset
class/type for financial reporting purposes (e.g., Machinery &
72 Equipment, Land, Buildings).
73 70 PS_ASSET_ACQ_DET BUSINESS_UNIT_RECV Receiving Business Unit OH_AM_ASSET_VW BUSINESS_UNIT_RECV Character 5 Receiving Business Unit Receiving Business Unit The Business Unit of the agency that received the asset.
74 71 PS_ASSET_ACQ_DET RECEIVER_ID Receipt ID OH_AM_ASSET_VW RECEIVER_ID Character 10 Receipt ID Receipt ID Receipt ID is the identification number of the asset‘s receipt.
72 PS_ASSET_LOCATION LOCATION Asset Location OH_AM_ASSET_VW LOCATION Character 10 Location Code Location Code Location is the unique code identifying the location where an
75 asset resides.
73 PS_ASSET_LOCATION DOCUMENT_ID Asset Location Document ID OH_AM_ASSET_VW DOCUMENT_ID Character 12 Asset Location Document ID Asset Location Document ID The Document ID field can be used by agencies to track an
76 asset‘s specific location within a building.
74 PS_ASSET_LOCATION EFF_STATUS Location Effective Status OH_AM_ASSET_VW OH_LOC_EFF_STATUS Character 1 Location Effective Status Location Effective Status The effective status (Active or Inactive) as of the effective date in
77 Location.
75 PS_ASSET_LOCATION DESCR Location Description OH_AM_ASSET_VW OH_LOC_DESCR Character 30 Location Description Location Description Description of a location.
78
79 76 PS_ASSET_LOCATION BUILDING Building OH_AM_ASSET_VW BUILDING Character 10 Building Building Building is a description of a location's structure.
77 PS_ASSET_LOCATION JURISDICTION Jurisdiction OH_AM_ASSET_VW JURISDICTION Character 5 Jurisdiction Jurisdiction The Jurisdiction field contains the agency which requested that
80 the location be created.
81 78 PS_ASSET_LOCATION ADDRESS1 Building Address Line 1 OH_AM_ASSET_VW ADDRESS1 Character 55 Address Address Address is a location's street address.
82 79 PS_ASSET_LOCATION CITY Building City OH_AM_ASSET_VW CITY Character 30 City City City is the city of a location's address.
83 80 PS_ASSET_LOCATION STATE Building State OH_AM_ASSET_VW STATE Character 6 State State State is the state of a location's address.
84 81 PS_ASSET_LOCATION POSTAL Building Zip OH_AM_ASSET_VW POSTAL Character 12 Postal Postal Postal is the postal/zip code of a location's address.
85 82 PS_ASSET_LOCATION COUNTY Building County OH_AM_ASSET_VW COUNTY Character 30 County County County is the county in which a location resides.
83 PS_AM_LOCATION_TBL EFF_STATUS AM Location Table Effective Status OH_AM_ASSET_VW OH_LOC_TBL_STATUS Character 1 AM Location Effective Status AM Location Effective Status The effective status (Active or Inactive) as of the effective date in
86 the AM Location table.
84 PS_AM_LOCATION_TBL LATITUDE Building Latitude OH_AM_ASSET_VW OH_LATITUDE Sign 12 Latitude Latitude Latitude is the angular distance north or south of the equator for a
87 location.
85 PS_AM_LOCATION_TBL LONGITUDE Building Longitude OH_AM_ASSET_VW LONGITUDE Sign 12 Longitude Longitude Longitude is the angular distance east or west from the Prime
88 Meridian for a location.
89 86 PS_LEASE LEASE_ID Lease ID OH_AM_ASSET_VW LEASE_ID Character 30 Lease ID Lease ID A leased asset‘s lease identification number.
87 PS_LEASE VENDOR_ID Leased Asset - Vendor ID OH_AM_ASSET_VW OH_LSE_VENDOR_ID Character 10 Leased Asset - Vendor ID Leased Asset - Vendor ID For leased assets, the name of the Vendor ID is the identification
number for the vendor from which the asset was leased.
90
88 PS_LEASE LEASE_DT Lease Date OH_AM_ASSET_VW LEASE_DT Date 10 Lease Date Lease Date For leased assets, the Lease Date is the date on which the lease
91 commences. (Default Format: yyyy-mm-dd).
89 PS_LEASE MRP Minimum Rental Payment OH_AM_ASSET_VW MRP Sign 28 Minimum Rental Payment Minimum Rental Payment The Minimum Rental Payment entered is used to calculate the
92 lease payment schedule.
90 PS_LEASE EXECUTORY_COSTS Executory Costs OH_AM_ASSET_VW EXECUTORY_COSTS Sign 28 Executory Costs Executory Costs Executory Costs are expense incurred (e.g., insurance ,
maintenance costs) on a leased property, are examples of such
93 costs.
91 PS_LEASE MLP Minimum Lease Payment OH_AM_ASSET_VW MLP Sign 28 Minimum Lease Payment Minimum Lease Payment The Minimum Lease Payments (MLP) are the rental payments
that the lessee is obligated to make in connection with the leased
94 property.
92 PS_LEASE PV_MLP Present Value of Minimum Lease Payment OH_AM_ASSET_VW PV_MLP Sign 28 Present Value of Minimum Lease Present Value of Minimum Lease This field displays the present value of the lease payments for a
95 Payment Payment step lease.
93 PS_LEASE CAP_LEASE_AMT Capitalized Lease Amount OH_AM_ASSET_VW CAP_LEASE_AMT Sign 28 Capitalized Lease Amount Capitalized Lease Amount For leased assets, the Capitalized Lease Amount is the total cost.
96
94 PS_LEASE GUAR_RESIDUAL Guaranteed Residual Value OH_AM_ASSET_VW GUAR_RESIDUAL Sign 28 Guaranteed Residual Value Guaranteed Residual Value For leased assets, Asset Management calculates depreciation
based on the amount of the residual value of the leased asset
guaranteed by the lessee to the lessor and considered as part of
the minimum lease payments.
97
98 95 PS_LEASE ACTUAL_RESIDUAL Actual Residual Value OH_AM_ASSET_VW ACTUAL_RESIDUAL Sign 28 Actual Residual Value Actual Residual Value For leased assets, this field contains the actual residual value.
96 PS_LEASE TSFR_OWNERSHIP_FLG Transfer Ownership OH_AM_ASSET_VW TSFR_OWNERSHIP_FLG Character 1 Transfer Ownership Transfer Ownership For leased assets, the Transfer Ownership field is used when
ownership of the asset will be transferred to the state at the end of
99 the lease period.
97 PS_LEASE RENEWAL_OPTION Bargain Renewal Option OH_AM_ASSET_VW RENEWAL_OPTION Character 1 Bargain Renewal Option Bargain Renewal Option For leased assets, this field is selected if the lease includes a
Bargain Renewal Option (BRO), which requires a payment if the
lease agreement grants the lessee the right to renew or extend
the lease. If the agreement specifies that the lease must be
renewed or extended, a penalty might be required for failure to
100 renew.
98 PS_LEASE RENEWAL_PENALTY Renewal Payment Penalty OH_AM_ASSET_VW RENEWAL_PENALTY Sign 28 Renewal Payment Penalty Renewal Payment Penalty The Renewal Payment Penalty is the penalty amount that might
101 be required for failure to renew a lease.
7/15/20105:21 PM 15 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Assets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
99 PS_LEASE BPO Bargain Purchase Option OH_AM_ASSET_VW BPO Character 1 Bargain Purchase Option Bargain Purchase Option For leased assets, this field is selected if the lease includes a
Bargain Purchase Option (BPO) which represents a payment by
the lessee to the lessor at the end of the lease term, allowing the
102 lessee to obtain title to the leased property.
100 PS_LEASE BPO_PAYMENT Bargain Purchase Option Payment OH_AM_ASSET_VW BPO_PAYMENT Sign 28 Bargain Purchase Option Payment Bargain Purchase Option Payment For leased assets, the Bargain Purchase Option Payment field
contains the amount of the payment made at the end of the lease
term that allows the lessee to obtain title to the leased property.
103
101 PS_LEASE IMPLICIT_RATE Implicit Interest Rate OH_AM_ASSET_VW IMPLICIT_RATE Number 7 Implicit Interest Rate Implicit Interest Rate For leased assets, the Interest Rate is the approximate
percentage of profit the lessor gains by leasing the asset to you.
This number is an annual interest rate percentage in whole
104 numbers.
102 PS_LEASE BORROW_RATE Incremental Borrowing Rate OH_AM_ASSET_VW BORROW_RATE Number 7 Incremental Borrowing Rate Incremental Borrowing Rate The Incremental Borrowing Rate is the interest rate that you
would have incurred at the inception of the lease if you had
borrowed the necessary funds to purchase the leased asset. This
number is an annual interest rate percentage in whole numbers.
105
103 PS_LEASE LEASE_TYPE Lease Type OH_AM_ASSET_VW LEASE_TYPE Character 1 Lease Type Lease Type For leased assets, the Lease Type field is used to identify the
106 lease as capital or operating.
104 PS_LEASE LEASE_TERM Lease Term in Periods OH_AM_ASSET_VW LEASE_TERM Number 6 Lease Term in Periods Lease Term in Periods For leased assets, the Lease Term is number of periods in the
107 lease.
105 PS_LEASE FMV Fair Market Value OH_AM_ASSET_VW FMV Sign 28 Fair Market Value Fair Market Value For leased assets, the system calculates the capitalized lease
amount using the lesser of the Present value of Lease Payments
and Fair Market Value field values. If the Fair Market Value is
less than the Present value of Lease Payments, the capitalized
lease amount equals the Fair Market Value.
108
106 PS_LEASE EST_LIFE Estimated Life OH_AM_ASSET_VW EST_LIFE Number 6 Estimated Life Estimated Life For leased assets, the Estimated Life defaults to the number of
periods entered in the Lease Term field, unless the field is
109 updated by a user.
107 PS_LEASE PYMNT_SCHED_ID Payment Schedule ID OH_AM_ASSET_VW PYMNT_SCHED_ID Character 2 Payment Schedule ID Payment Schedule ID For leased assets, the Payment Schedule ID defaults the
110 payment frequency and number of periods.
108 PS_LEASE STEP_LEASE_FLAG Step Lease Flag OH_AM_ASSET_VW STEP_LEASE_FLAG Character 1 Step Lease Flag Step Lease Flag For leased assets, the Step Lease field is used when there are
variable payment amounts and/or variable timing over the term of
111 the lease.
109 PS_LEASE ACCEPTANCE_DT Lease Acceptance Date OH_AM_ASSET_VW ACCEPTANCE_DT Date 10 Lease Acceptance Date Lease Acceptance Date For leased assets, the Acceptance Date indicates the date the
lease contract is accepted (signed and returned to the lessor).
112 (Default Format: yyyy-mm-dd).
110 PS_LEASE LEASE_PYMT_TYPE Lease Payment Type OH_AM_ASSET_VW LEASE_PYMT_TYPE Character 1 Lease Payment Type Lease Payment Type For leased assets, the Lease Payment Type denotes whether the
113 lease is paid in advance or in arrears.
111 PS_LEASE EXPIRATION_DT Lease Expiration Date OH_AM_ASSET_VW EXPIRATION_DT Date 10 Lease Expiration Date Lease Expiration Date For leased assets, the Lease Expiration Date represents the last
114 lease payment date. (Default Format: yyyy-mm-dd).
112 PS_LEASE LEASE_COMMENCE_DT Lease Commence Date OH_AM_ASSET_VW LEASE_COMMENCE_DT Date 10 Lease Commence Date Lease Commence Date For leased assets, the Lease Commence Date represents the first
115 lease payment date. (Default Format: yyyy-mm-dd).
113 PS_LEASE LEASE_END_DT Lease End Date OH_AM_ASSET_VW LEASE_END_DT Date 10 Lease End Date Lease End Date For leased assets, the Lease End Date is the date on which the
lease terminates. This is an information-only field and is not used
in the calculation of the lease payment schedule. (Default
116 Format: yyyy-mm-dd).
114 PS_LEASE LEASE_RECEIPT_DT Lease Receipt Date OH_AM_ASSET_VW LEASE_RECEIPT_DT Date 10 Lease Receipt Date Lease Receipt Date For leased assets, the Lease Receipt Date is the date on which
the leased asset is received. This is an information-only field and
is not used in the calculation of the lease payment schedule.
117 (Default Format: yyyy-mm-dd).
115 PS_LEASE INTERIM_RENT Monthly Interim Rent OH_AM_ASSET_VW INTERIM_RENT Sign 28 Monthly Interim Rent Monthly Interim Rent For leased assets, this is the amount of monthly interim rent,
which is common for quarterly leases. Interim rent starts on the
acceptance date and ends on the commencement date of the
lease. Once the lease officially begins, the normal rental payment
118 amount is tracked by the lease payment schedule.
116 PS_LEASE_SCHED INTEREST_EXPENSE Lease Schedule Interest Expense OH_AM_ASSET_VW INTEREST_EXPENSE Sign 28 Lease Schedule Interest Expense Lease Schedule Interest Expense For leased assets, the Interest Expense field tracks the monthly
119 interest amount.
117 PS_LEASE_SCHED OBLIGATION_REDUCE Lease Schedule Obligation Reduction OH_AM_ASSET_VW OBLIGATION_REDUCE Sign 28 Lease Schedule Obligation Reduction Lease Schedule Obligation Reduction This field contains the obligation reduction by period for the lease
120 amount.
118 PS_LEASE_SCHED PYMNT_FREQUENCY Lease Schedule Payment Frequency OH_AM_ASSET_VW PYMNT_FREQUENCY Character 1 Lease Schedule Payment Frequency Lease Schedule Payment Frequency For leased assets, this field contains the frequency of the lease
121 payments (e.g., quarterly).
119 PS_LEASE_SCHED SCHED_PYMNT_TYPE Lease Schedule Payment Type OH_AM_ASSET_VW SCHED_PYMNT_TYPE Character 1 Lease Schedule Payment Type Lease Schedule Payment Type Type of lease payment schedule (C=Capital Interim Rent, I-
122 Interim Rent, N=Normal Rent).
120 PS_LEASE_SCH_ID NUM_PAY_PERIODS_YR Number of Lease Payment Periods OH_AM_ASSET_VW OH_NUM_PAY_PDS_YR Number 4 Number of Lease Payment Periods Number of Lease Payment Periods For leased assets, this field contains the number of lease
123 payment periods.
124 121 PS_ASSET_ATTRIBUTE ASSET_COLOR Asset Color OH_AM_ASSET_VW OH_ASSET_COLOR Character 15 Asset Color Asset Color This field contains the color of the asset.
125 122 PS_ASSET_ATTRIBUTE ASSET_WEIGHT Asset Weight OH_AM_ASSET_VW OH_ASSET_WEIGHT Number 13 Asset Weight Asset Weight This field contains the weight of the asset.
123 PS_ASSET_ATTRIBUTE WEIGHT_UM Asset Weight Unit of Measure OH_AM_ASSET_VW OH_WEIGHT_UM Character 3 Asset Weight Unit of Measure Asset Weight Unit of Measure This field contains the Unit of Measure for the weight of the asset
126 (e.g., lbs).
127 124 PS_ASSET_ATTRIBUTE ASSET_HEIGHT Asset Height OH_AM_ASSET_VW OH_ASSET_HEIGHT Number 13 Asset Height Asset Height This field contains the height of the asset.
125 PS_ASSET_ATTRIBUTE HEIGHT_UM Asset Height Unit of Measure OH_AM_ASSET_VW OH_HEIGHT_UM Character 3 Asset Height Unit of Measure Asset Height Unit of Measure This field contains the Unit of Measure for the height of the asset
128 (e.g., ft).
129 126 PS_ASSET_ATTRIBUTE ASSET_WIDTH Asset Width OH_AM_ASSET_VW OH_ASSET_WIDTH Number 13 Asset Width Asset Width This field contains the width of the asset.
127 PS_ASSET_ATTRIBUTE WIDTH_UM Asset Width Unit of Measure OH_AM_ASSET_VW OH_WIDTH_UM Character 3 Asset Width Unit of Measure Asset Width Unit of Measure This field contains the Unit of Measure for the width of the asset
130 (e.g., in).
128 PS_ASSET_ATTRIBUTE ASSET_LENGTH Asset Length OH_AM_ASSET_VW OH_ASSET_LENGTH Number 13 Asset Length Asset Length This field contains the length of the asset. For land assets, this
131 field will be used by the state to track acreage.
129 PS_ASSET_ATTRIBUTE LENGTH_UM Asset Length Unit of Measure OH_AM_ASSET_VW OH_LENGTH_UM Character 3 Asset Length Unit of Measure Asset Length Unit of Measure This field contains the Unit of Measure for the length of the asset.
For land assets, ―acres‖ should be selected in this field.
132
133 130 PS_ASSET_ATTRIBUTE ASSET_CAPACITY Asset Capacity OH_AM_ASSET_VW OH_ASSET_CAPACITY Number 13 Asset Capacity Asset Capacity This field contains the capacity of the asset.
131 PS_ASSET_ATTRIBUTE CAPACITY_UM Asset Capacity Unit of Measure OH_AM_ASSET_VW OH_CAPACITY_UM Character 3 Asset Capacity Unit of Measure Asset Capacity Unit of Measure This field contains the Unit of Measure for the capacity of the
134 asset.
135 132 PS_ASSET_ATTRIBUTE POWER_RATING Asset Power Rating OH_AM_ASSET_VW OH_POWER_RATING Number 13 Asset Power Rating Asset Power Rating This field contains the asset‘s power rating.
133 PS_ASSET_ATTRIBUTE POWER_RATING_UM Asset Power Rating Unit of Measure OH_AM_ASSET_VW OH_POWER_RATING_UM Character 3 Asset Power Rating Unit of Measure Asset Power Rating Unit of Measure This field contains the Unit of Measure for the asset‘s power
136 rating.
134 PS_ASSET_CUSTODIAN CUSTODIAN Asset Custodian OH_AM_ASSET_VW CUSTODIAN Character 30 Asset Custodian Asset Custodian The name of the state employee that is responsible for the asset.
137
135 PS_ASSET_CUSTODIAN EMPLID Asset Custodian Employee ID OH_AM_ASSET_VW EMPLID Character 11 Asset Custodian Employee ID Asset Custodian Employee ID The Employee ID of the state employee that is responsible for the
asset.
138
7/15/20105:21 PM 16 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Assets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
136 PS_ASSET_CUSTODIAN OFFSITE_SW Offsite OH_AM_ASSET_VW OH_OFFSITE_SW Character 1 Offsite Offsite The Offsite field is used to flag an asset that is located off the
premises.
139
137 PS_OH_ASSET_BLDG OH_BLDG_USE Building Use OH_AM_ASSET_VW OH_BLDG_USE Character 70 Building Use Building Use The Building Use field contains the functions or activities that are
140 performed in a building.
138 PS_OH_ASSET_BLDG OH_BLDG_CNSTRUC Building Construction Type OH_AM_ASSET_VW OH_BLDG_CNSTRUC Character 70 Construction Type Construction Type The Construction Type field contains the primary material(s) used
141 to construct a building.
142 139 PS_OH_ASSET_BLDG OH_BLDG_YR Year Building was Built OH_AM_ASSET_VW OH_BLDG_YR Nbr 4 Year Built Year Built Year Built is the year in which a building was constructed.
140 PS_OH_ASSET_BLDG OH_BLDG_STORY Building Stories Above Ground OH_AM_ASSET_VW OH_BLDG_STORY Nbr 4 Stories Above Ground Stories Above Ground Stories Above Ground is the number of floors that a building has
143 above ground.
141 PS_OH_ASSET_BLDG OH_BLDG_SPRINK Building Sprinkler System OH_AM_ASSET_VW OH_BLDG_SPRINK Character 1 Building Sprinkler System 3 translate values Sprinkler System Sprinkler System identifies whether a building has a sprinkler
144 system.
142 PSXLATITEM XLATLONGNAME XLAT Long Name OH_AM_ASSET_VW OH_BLDG_SPRK_DESCR Character 30 Building Sprinkler System Description Sprinkler System Description Description of the building Sprinkler System – 30 character text.
145
143 PS_OH_ASSET_BLDG OH_BLDG_ALARM Building Alarm System OH_AM_ASSET_VW OH_BLDG_ALARM Character 1 Alarm System 4 translate values Alarm System Alarm System identifies whether a building has a fire alarm,
146 burglar alarm, both types of alarms, or no alarm system.
147 144 PSXLATITEM XLATLONGNAME XLAT Long Name OH_AM_ASSET_VW OH_BLDG_ALRM_DESCR Character 30 Alarm System Description Alarm System Description Description of the building Alarm System – 30 character text.
145 PS_OH_ASSET_BLDG OH_BLDG_SQ_FT Building Square Footage OH_AM_ASSET_VW OH_BLDG_SQ_FT Nbr 15 Square Feet Square Feet Square Feet is the measurement of the total area of a building.
148
149 146 PS_OH_ASSET_BLDG OH_BLDG_APPRAIS Building Appraised Value OH_AM_ASSET_VW OH_BLDG_APPRAIS Character 27 Appraised Value Appraised Value The Appraised Value of the building.
150 147 PS_OH_ASSET_BLDG OH_BLDG_REP_RISK Report to Risk Management OH_AM_ASSET_VW OH_BLDG_REP_RISK Character 1 Report to Risk Management 2 translate values (Y/N) Report to Risk Management Report to Risk Management (Y/N).
148 PS_OH_ASSET_BLDG OH_BLDG_GROUPID Building Group ID OH_AM_ASSET_VW OH_BLDG_GROUPID Character 15 Building Group ID Building Group ID The Building Group ID is a distinct number that identifies a group
151 of buildings.
149 PS_OH_ASSET_BLDG OH_CONDITION_CD Condition Code OH_AM_ASSET_VW OH_CONDITION_CD Character 1 Condition Code 6 translate values Condition Code Condition Code is the current physical state of an asset (e.g.,
152 New, Fair).
150 PSXLATITEM XLATLONGNAME XLAT Long Name OH_AM_ASSET_VW OH_COND_CD_DESCR Character 30 Condition Code Description Condition Code Description Description of the building Condition Code – 30 character text.
153
151 PS_CATEGORY_TBL EFF_STATUS Category Effective Status OH_AM_ASSET_VW OH_CATEG_EFFSTATUS Character 1 Category Effective Status Category Effective Status The effective status (Active or Inactive) as of the effective date in
154 the Category table.
152 PS_CATEGORY_TBL DESCR Category Description OH_AM_ASSET_VW OH_CATEG_DESCR Character 30 Category Description Category Description This field contains the description of the value in the Asset
155 Category field.
153 PS_ASSET_CLASS_TBL EFF_STATUS Asset Class Effective Status OH_AM_ASSET_VW OH_AM_CLSS_EFFSTAT Character 1 Class Effective Status Class Effective Status The effective status (Active or Inactive) as of the effective date in
156 the Asset Class table.
154 PS_ASSET_CLASS_TBL DESCR50 Asset Class Description OH_AM_ASSET_VW DESCR50 Character 50 Asset Class Description Asset Class Description This field contains the description of the value in the Asset Class
157 field.
155 PS_PROFILE_TBL DESCR Profile Description OH_AM_ASSET_VW OH_PROFILE_DESCR Character 30 Asset Profile Description Asset Profile Description This field contains the description of the value in the Asset Profile
158 field.
156 PS_ASSET_FSC FSC_CODE Federal Hazardous Code OH_AM_ASSET_VW OH_FSC_CODE Character 5 Federal Hazardous Code Federal Hazardous Code For assets that are flagged with the Hazardous Asset field, this
field contains the code that identifies the reason why the asset is
159 hazardous.
157 PS_FED_SUP_CLASS ITEMS_CONTAINED Items Contained OH_AM_ASSET_VW OH_ITEMS_CONTAINED Character 50 Hazardous Items Contained Hazardous Items Contained For assets that are flagged with the Hazardous Asset field, this
160 field contains the description of why the asset is hazardous.
161 158 PS_BUS_UNIT_TBL_FS DESCR Business Unit Description OH_AM_ASSET_VW OH_BUS_UNIT_DESCR Character 30 Business Unit Description Business Unit Description Business Unit is an operational subset of an organization.
159 PS_ASSET_COMMENTS COMMENTS Asset Comments OH_AM_ASSET_VW OH_CNV_COMMENT Character 2000 Asset Comments Conversion Comments The Conversion Comments field contains the text that was
inserted into the Comments field in Asset Management during the
conversion from the Fixed Asset Management System (FAMS).
Certain data fields from FAMS that were not mapped to
equivalent fields in Asset Management were converted into the
Comments field for reference purposes. This field will not be
populated in the reporting warehouse for assets that were entered
162 into OAKS after the conversion.
7/15/20105:21 PM 17 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Available Assets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
4 1 PS_ASSET BUSINESS_UNIT Business Unit OH_AM_ASSET_VW BUSINESS_UNIT Character 5 Business Unit Y OAKS Available Assets Reporting The OAKS Available Assets Business Unit Business Unit is an operational subset of an organization.
2 PS_ASSET ASSET_ID Asset ID OH_AM_ASSET_VW ASSET_ID Character 12 Asset ID Y Table Reporting Table is used to capture Asset ID Asset ID is the distinct number assigned to an asset when it is
physical asset information for only entered into the system. It uniquely defines an asset within a
5 available assets. Examples of Business Unit.
3 PS_ASSET PARENT_ID Parent ID OH_AM_ASSET_VW PARENT_ID Character 12 Parent ID Y physical information include asset Parent ID For child assets, this field contains the parent asset's Asset ID.
6 description, manufacturer, location,
4 PS_ASSET_ACQ_DET SEQUENCE_NBR_6 Asset Acquisition Sequence Number OH_AM_ASSET_VW SEQUENCE_NBR_6 Number 6 Asset Acquisition Sequence Number Y custodian and condition. Asset Acquisition Sequence Number This field is used to sequence acquisition detail rows.
7
5 PS_ASSET_LOCATION EFFDT Location Effective Date OH_AM_ASSET_VW OH_AM_LOC_EFFDT Date 10 Asset Location Effective Date Y Asset Location Effective Date Effective Date from the Asset Location table. (Default Format:
yyyy-mm-dd).
8
6 PS_ASSET_LOCATION EFFSEQ Location Effective Sequence OH_AM_ASSET_VW OH_AM_LOC_EFFSEQ Nbr 3 Asset Location Effective Sequence Y Asset Location Effective Sequence The sequence number of the asset location. This will be one
unless the asset has had more than one location for a given
9 effective date.
7 PS_LOCATION_TBL EFFDT Location Effective Date OH_AM_ASSET_VW OH_LOC_EFFDT Date 10 Location Effective Date Location Effective Date Effective Date from Location table. (Default Format: yyyy-mm-
10 dd).
8 PS_AM_LOCATION_TBL EFFDT AM Location Table Effective Date OH_AM_ASSET_VW OH_LOC_TBL_EFFDT Date 10 AM Location Effective Date Y AM Location Effective Date Effective Date from the AM Location table. (Default Format: yyyy-
11 mm-dd).
9 PS_LEASE_SCHED PYMNT_DT Lease Schedule Payment Date OH_AM_ASSET_VW PYMNT_DT Date 10 Lease Schedule Payment Date Y Lease Schedule Payment Date For leased assets, these are the dates on which lease payments
12 are made. (Default Format: yyyy-mm-dd).
10 PS_ASSET_ATTRIBUTE EFFDT Asset Attribute Effective Date OH_AM_ASSET_VW OH_AM_ATTR_EFFDT Date 10 Asset Attribute Effective Date Y Asset Attribute Effective Date Effective Date from the Asset Attribute table. (Default Format:
13 yyyy-mm-dd).
11 PS_ASSET_CUSTODIAN EFFDT Asset Custodian Effective Date OH_AM_ASSET_VW OH_AM_CUST_EFFDT Date 10 Asset Custodian Effective Date Y Asset Custodian Effective Date Effective Date from the Asset Custodian table. (Default Format:
14 yyyy-mm-dd).
12 PS_ASSET_CUSTODIAN EFFSEQ Asset Custodian Effective Sequence OH_AM_ASSET_VW OH_AM_CUST_EFFSEQ Number 3 Asset Custodian Effective Sequence Y Asset Custodian Effective Sequence The sequence number of the asset‘s custodian. This will be one
unless the asset has had more than one custodian for a given
15 effective date.
13 PS_CATEGORY_TBL EFFDT Category Effective Date OH_AM_ASSET_VW OH_CATEG_EFFDT Date 10 Category Effective Date Category Effective Date Effective Date from the Category table. (Default Format: yyyy-
16 mm-dd).
14 PS_ASSET_CLASS_TBL EFFDT Asset Class Effective Date OH_AM_ASSET_VW OH_AM_CLASS_EFFDT Date 10 Class Effective Date Class Effective Date Effective Date from the Asset Class table. (Default Format: yyyy-
17 mm-dd).
15 PS_ASSET TAG_NUMBER Tag Number OH_AM_ASSET_VW TAG_NUMBER Character 12 Tag Number Tag Number For personal property, Tag Number is the number from an asset's
barcode label. For real property, Tag Number is a smart-coded
18 value that uniquely identifies an asset.
16 PS_ASSET DESCR Asset Description OH_AM_ASSET_VW OH_ASSET_DESCR Character 30 Asset Description Asset Description Description of the asset.
19
17 PS_ASSET ASSET_STATUS Asset Status OH_AM_ASSET_VW ASSET_STATUS Character 1 Asset Status Asset Status Asset Status is the current state of an asset within its lifecycle
20 (e.g., In Service, Disposed).
18 OH_AM_ASSET_VW OH_AM_STATUS_DESCR Character 30 Asset Status Description Asset Status Description Description of the Asset Status.
21
19 PS_ASSET FINANCIAL_ASSET_SW Capitalized Asset OH_AM_ASSET_VW FINANCIAL_ASSET_SW Character 1 Capitalized Asset Capitalized Asset Signifies whether an asset‘s cost has been capitalized (Y/N).
22
20 PS_ASSET AVAIL_SW Asset is Available OH_AM_ASSET_VW AVAIL_SW Character 1 Asset is Available Asset is Available Indicates whether the asset has been identified as available and
23 not being used.
21 PS_ASSET AVAIL_CONTACT Available Contact Name OH_AM_ASSET_VW AVAIL_CONTACT Character 30 Available Contact Name Available Contact Name Name of the person that should be contacted when the asset is
marked as "available" in the system.
24
22 PS_ASSET AVAIL_PHONE Available Contact Phone OH_AM_ASSET_VW AVAIL_PHONE Character 12 Available Contact Phone Available Contact Phone Phone number of the person that should be contacted when the
asset is marked as "available" in the system.
25
23 PS_ASSET ACQUISITION_CD Acquisition Code OH_AM_ASSET_VW ACQUISITION_CD Character 1 Acquisition Code Acquisition Code The Acquisition Code is the method through which an asset was
acquired (e.g., Purchased, Leased, Constructed, Donated).
26
24 PS_ASSET ACQUISITION_DT Acquisition Date OH_AM_ASSET_VW ACQUISITION_DT Date 10 Acquisition Date Acquisition Date Date the asset was acquired. (Default Format: yyyy-mm-dd).
27
25 PS_ASSET REPLACEMENT_COST Replacement Cost OH_AM_ASSET_VW REPLACEMENT_COST Sign 28 Replacement Cost Replacement Cost Indicates how much it would cost to replace an asset.
28
26 PS_ASSET REPLACE_COST_DT Replacement Cost Last Update OH_AM_ASSET_VW REPLACE_COST_DT Date 10 Replacement Cost Last Update Replacement Cost Last Update Date on which the asset‘s Replacement Cost was last updated.
(Default Format: yyyy-mm-dd).
29
30 27 PS_ASSET LEASE_ASSET_ID Leased Asset ID OH_AM_ASSET_VW LEASE_ASSET_ID Character 12 Leased Asset ID Leased Asset ID Displays the Asset ID of a leased asset.
28 PS_ASSET PROFILE_ID Asset Profile ID OH_AM_ASSET_VW PROFILE_ID Character 10 Asset Profile ID Asset Profile ID Asset Profile ID is a categorization code assigned to an asset that
defaults information about it (e.g., Useful Life) based on asset
31 type.
29 PS_ASSET ASSET_CLASS Asset Class OH_AM_ASSET_VW ASSET_CLASS Character 10 Asset Class Asset Class Asset Class is a category that defines an asset for reporting
32 purposes.
33 30 PS_ASSET MANUFACTURER Asset Manufacturer OH_AM_ASSET_VW MANUFACTURER Character 30 Manufacturer Manufacturer Company that made or produced an asset.
31 PS_ASSET MODEL Asset Model OH_AM_ASSET_VW MODEL Character 30 Model Model Number or name assigned to an equipment item by the
34 manufacturer.
35 32 PS_ASSET SERIAL_ID Serial Number OH_AM_ASSET_VW SERIAL_ID Character 20 Serial Number Serial Number Serial Number is a unique number that identifies an asset.
33 PS_ASSET PRODUCTION_DT Production Date OH_AM_ASSET_VW PRODUCTION_DT Date 10 Production Date Production Date The Production Date field contains the last date an asset was
counted in a physical inventory. (Default format: yyyy-mm-dd).
36
34 PS_ASSET LIFE Useful Life OH_AM_ASSET_VW LIFE Number 10 Useful Life Useful Life Useful Life is the number of periods (months) over which an asset
37 will be depreciated.
35 PS_ASSET HAZARDOUS_SW Hazardous Asset OH_AM_ASSET_VW OH_HAZARDOUS_SW Character 1 Hazardous Asset Hazardous Asset The Hazardous Asset field is used to identify that an asset is
considered predominant and/or significant hazardous material.
38
39 36 PS_PARENT_ASSET DESCR Parent Asset Description OH_AM_ASSET_VW OH_PARENT_AM_DESCR Character 30 Parent Asset Description Parent Asset Description Description of a parent asset.
37 PS_ASSET_ACQ_DET SYSTEM_SOURCE Asset Acquisition System Source OH_AM_ASSET_VW SYSTEM_SOURCE Character 3 System Source System Source The System Source identifies assets that have originated from the
40 OAKS Purchasing/Accounts Payable modules.
38 PS_ASSET_ACQ_DET CAPIITALIZATION_SW Capitalized Switch OH_AM_ASSET_VW OH_CAPIITALIZE_SW Character 1 Capitalization Status Capitalization Status Identifies the capitalization status of an acquisition detail row
41 (e.g., 1= To Be Capitalized, 2 = Already Capitalized).
39 PS_ASSET_ACQ_DET BUSINESS_UNIT_PO Purchasing Business Unit OH_AM_ASSET_VW BUSINESS_UNIT_PO Character 5 Purchasing Business Unit Purchasing Business Unit The Purchasing Business Unit is the agency that purchased the
42 asset.
40 PS_ASSET_ACQ_DET PO_ID Purchase Order Number OH_AM_ASSET_VW PO_ID Character 10 Purchase Order ID Purchase Order ID The Purchase Order ID field contains the asset‘s PO number for
assets that originate from the OAKS Purchasing/Accounts
43 Payable modules.
41 PS_ASSET_ACQ_DET BUSINESS_UNIT_AP Accounts Payable Business Unit OH_AM_ASSET_VW BUSINESS_UNIT_AP Character 5 Accounts Payable Business Unit Accounts Payable Business Unit The Accounts Payable Business Unit is the agency that
44 processed the voucher for the asset.
42 PS_ASSET_ACQ_DET VOUCHER_ID Voucher ID OH_AM_ASSET_VW VOUCHER_ID Character 8 Voucher ID Voucher ID The Voucher ID field contains the identifying number for the
45 voucher that paid for the asset.
43 PS_ASSET_ACQ_DET INVOICE_DT Invoice Date OH_AM_ASSET_VW INVOICE_DT Date 10 Invoice Date Invoice Date Invoice Date is the date on which the invoice for the asset was
46 received. (Default Format: yyyy-mm-dd).
7/15/20105:21 PM 18 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Available Assets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
44 PS_ASSET_ACQ_DET VENDOR_ID Vendor ID OH_AM_ASSET_VW OH_ACQ_VENDOR_ID Character 10 Vendor ID Vendor ID The Vendor ID is the identification number for the vendor from
47 which the asset was purchased.
48 45 PS_ASSET_ACQ_DET VENDOR_NAME Vendor Name OH_AM_ASSET_VW OH_VENDOR_NAME Character 30 Vendor Name Vendor Name The name of the vendor from which the asset was purchased.
49 46 PS_ASSET_ACQ_DET INVOICE_ID Invoice ID OH_AM_ASSET_VW INVOICE_ID Character 30 Invoice ID Invoice ID Invoice ID is the identification number of the asset‘s invoice.
47 PS_ASSET_ACQ_DET OPERATING_UNIT Operating Unit OH_AM_ASSET_VW OPERATING_UNIT Character 8 ISTV Xref ISTV Xref Operating Unit is used to record the ISTV Cross Reference
50 agency.
48 PS_OPER_UNIT_TBL DESCR ISTV XRef Description OH_AM_ASSET_VW OH_OPER_DESCR Character 30 ISTV XRef Description ISTV Xref Description Intra-State Transfer Voucher Cross Reference Description is free
51 flow text up to 30 characters.
49 PS_ASSET_ACQ_DET PRODUCT Product OH_AM_ASSET_VW PRODUCT Character 6 Appropriation Line Item Appropriation Line Item The Product chartfield is used by the State to capture
Appropriation Line Item (ALI), the legal spending authority by the
budget bill, and will be required on encumbrance and expense
52 transaction.
50 PS_PRODUCT_TBL DESCR Appropriation Line Item Description OH_AM_ASSET_VW OH_PROD_DESCR Character 30 Appropriation Line Item Description Appropriation Line Item Description Appropriation Line Item Description is free flow text up to 30
characters.
53
51 PS_ASSET_ACQ_DET FUND_CODE Fund Code OH_AM_ASSET_VW FUND_CODE Character 5 Fund Code Fund Code The Fund chartfield defines a fiscal and accounting entity with a
self-balancing set of accounts. It records cash and other financial
resources, together with related liabilities and residual equities or
balances, and any corresponding changes. Required on all
transactions.
54
52 PS_FUND_TBL DESCR Fund Description OH_AM_ASSET_VW OH_FUND_DESCR Character 30 Fund Description Fund Code Description Fund Code Description is free flow text up to 30 characters.
55
53 PS_ASSET_ACQ_DET CLASS_FLD Class Field OH_AM_ASSET_VW CLASS_FLD Character 5 Service Location Service Location Class field is used to capture the concept of Service Location
(state, county, city, district, building, etc.). This will allow the
state to track spending in relation to a geographical designation.
56
54 PS_CLASS_CF_TBL DESCR Service Location Description OH_AM_ASSET_VW OH_CLASS_DESCR Character 30 Service Location Description Service Location Description Service Location Description is free flow text up to 30 characters.
57
55 PS_ASSET_ACQ_DET PROGRAM_CODE Program Code OH_AM_ASSET_VW PROGRAM_CODE Character 5 Program Code Program Code The Program chartfield is used to capture the enterprise program
concept. The Program chartfield will enable the State to capture
the cost of providing a specific good or service in response to an
identified social or individual need or problem. Programs are
specific to an agency. Required on encumbrance and expense
58 transactions.
56 PS_PROGRAM_TBL DESCR Program Description OH_AM_ASSET_VW OH_PROG_DESCR Character 30 Program Description Program Code Description Program Code Description is free flow text up to 30 characters.
59
57 PS_ASSET_ACQ_DET BUDGET_REF Budget Reference OH_AM_ASSET_VW BUDGET_REF Character 8 Budget Reference Budget Reference The Budget Reference field is used to capture the federal fiscal
year for informational purposes. Some agencies have identified a
need to use this chartfield to identify the year for other purposes
not fulfilled by the system generated accounting and budget
period dates(e.g., the state fiscal year when recording indirect
costs in subsequent fiscal years). When not used to identify a
year for informational purposes, an agency may use this chartfield
to break an Appropriation Line Item into units for budget control.
60
58 PS_BUD_REF_TBL DESCR Budget Reference Description OH_AM_ASSET_VW OH_BUDG_DESCR Character 30 Budget Reference Description Budget Reference Description Budget Reference Description is free flow text up to 30
characters.
61
59 PS_ASSET_ACQ_DET CHARTFIELD1 Project ID OH_AM_ASSET_VW CHARTFIELD1 Character 10 Project ID Project ID Chartfield 1 is used to track project transactions when the project
costing module functionality is not required. Prior to the
implementation of the project costing module, all project
transactions will be tracked in this chartfield. A project is defined
as authorized expenditures for a specific purpose over a defined
period of time, and may cross fiscal years, fund, or departments.
Projects may be capital or non-capital, but are differentiated from
on-going operations by their lifecycle. This chartfield gives
agencies the ability to track project activity and grant activity in
62 separate chartfields.
60 PS_CHARTFIELD1_TBL DESCR Project Chartfield 1 Description OH_AM_ASSET_VW OH_CHFD1_DESCR Character 30 Project Description Project ID Description Project ID Description is free flow text up to 30 characters.
63
61 PS_ASSET_ACQ_DET CHARTFIELD2 Reporting ID OH_AM_ASSET_VW CHARTFIELD2 Character 10 Reporting ID Reporting ID Chartfield 2 is used to fulfill agency reporting requirements as
64 they relate to activities, tasks, or cost centers.
62 PS_CHARTFIELD2_TBL DESCR Reporting Chartfield 2 Description OH_AM_ASSET_VW OH_CHFD2_DESCR Character 30 Reporting Description Reporting ID Description Reporting ID Description is free flow text up to 30 characters.
65
63 PS_ASSET_ACQ_DET CHARTFIELD3 Agency Use OH_AM_ASSET_VW CHARTFIELD3 Character 10 Agency Use Agency Use Chartfield 3 is used to fulfill agency reporting requirements as
66 they relate to activities, tasks, or cost centers.
7/15/20105:21 PM 19 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Available Assets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
64 PS_CHARTFIELD3_TBL DESCR Agency Use Chartfield 3 Description OH_AM_ASSET_VW OH_CHFD3_DESCR Character 30 Agency Use Description Agency Use Description Agency Use Description is free flow text up to 30 characters.
67
65 PS_ASSET_ACQ_DET PROJECT_ID Project Identifier OH_AM_ASSET_VW PROJECT_ID Character 15 Grant/Project ID Grant/Project ID The Project ID chartfield is used to capture grant and project
transactions. All grant transactions will be tracked in this
chartfield to facilitate enterprise-wide reporting. This chartfield
may also be used to track project transactions after the project
costing module is implemented if an agency chooses to use the
project costing module functionality. This chartfield is designed to
track grant and project financial activity, which can cross budget
years, funds and departments. It is the gateway to the project
68 costing module functionality.
66 PS_PROJECT DESCR Grant/Project Description OH_AM_ASSET_VW OH_PROJ_DESCR Character 30 Grant/Project Description Grant/Project ID Description Grant/Project ID Description is free flow text up to 30 characters.
69
67 PS_ASSET_ACQ_DET DEPTID Department Identifier OH_AM_ASSET_VW DEPTID Character 10 Department ID Department ID The Department chartfield identifies the financial management
organizational entity associated with a particular financial
transaction. The State will use this chartfield to capture the State
and agency organization chart. Required on encumbrance,
70 expense, and revenue transactions.
68 PS_DEPT_TBL DESCR Department Description OH_AM_ASSET_VW OH_DEPT_DESCR Character 30 Department Description Department ID Description Department ID Description is free flow text up to 30 characters.
71
69 PS_ASSET_ACQ_DET CATEGORY Asset Category OH_AM_ASSET_VW CATEGORY Character 5 Asset Category Asset Category The Asset Category field classifies assets by major asset
class/type for financial reporting purposes (e.g., Machinery &
72 Equipment, Land, Buildings).
73 70 PS_ASSET_ACQ_DET BUSINESS_UNIT_RECV Receiving Business Unit OH_AM_ASSET_VW BUSINESS_UNIT_RECV Character 5 Receiving Business Unit Receiving Business Unit The Business Unit of the agency that received the asset.
74 71 PS_ASSET_ACQ_DET RECEIVER_ID Receipt ID OH_AM_ASSET_VW RECEIVER_ID Character 10 Receipt ID Receipt ID Receipt ID is the identification number of the asset‘s receipt.
72 PS_ASSET_LOCATION LOCATION Asset Location OH_AM_ASSET_VW LOCATION Character 10 Location Code Location Code Location is the unique code identifying the location where an
75 asset resides.
73 PS_ASSET_LOCATION DOCUMENT_ID Asset Location Document ID OH_AM_ASSET_VW DOCUMENT_ID Character 12 Asset Location Document ID Asset Location Document ID The Document ID field can be used by agencies to track an
76 asset‘s specific location within a building.
74 PS_LOCATION_TBL EFF_STATUS Location Effective Status OH_AM_ASSET_VW OH_LOC_EFF_STATUS Character 1 Location Effective Status Location Effective Status The effective status (Active or Inactive) as of the effective date in
77 Location.
75 PS_LOCATION_TBL DESCR Location Description OH_AM_ASSET_VW OH_LOC_DESCR Character 30 Location Description Location Description Description of a location.
78
79 76 PS_LOCATION_TBL BUILDING Building OH_AM_ASSET_VW BUILDING Character 10 Building Building Building is a description of a location's structure.
77 PS_LOCATION_TBL JURISDICTION Jurisdiction OH_AM_ASSET_VW JURISDICTION Character 5 Jurisdiction Jurisdiction The Jurisdiction field contains the agency which requested that
80 the location be created.
81 78 PS_LOCATION_TBL ADDRESS1 Building Address Line 1 OH_AM_ASSET_VW ADDRESS1 Character 55 Address Address Address is a location's street address.
82 79 PS_LOCATION_TBL CITY Building City OH_AM_ASSET_VW CITY Character 30 City City City is the city of a location's address.
83 80 PS_LOCATION_TBL STATE Building State OH_AM_ASSET_VW STATE Character 6 State State State is the state of a location's address.
84 81 PS_LOCATION_TBL POSTAL Building Zip OH_AM_ASSET_VW POSTAL Character 12 Postal Postal Postal is the postal/zip code of a location's address.
85 82 PS_LOCATION_TBL COUNTY Building County OH_AM_ASSET_VW COUNTY Character 30 County County County is the county in which a location resides.
83 PS_AM_LOCATION_TBL EFF_STATUS AM Location Table Effective Status OH_AM_ASSET_VW OH_LOC_TBL_STATUS Character 1 AM Location Effective Status AM Location Effective Status The effective status (Active or Inactive) as of the effective date in
86 the AM Location table.
84 PS_AM_LOCATION_TBL LATITUDE Building Latitude OH_AM_ASSET_VW OH_LATITUDE Sign 12 Latitude Latitude Latitude is the angular distance north or south of the equator for a
87 location.
85 PS_AM_LOCATION_TBL LONGITUDE Building Longitude OH_AM_ASSET_VW LONGITUDE Sign 12 Longitude Longitude Longitude is the angular distance east or west from the Prime
88 Meridian for a location.
89 86 PS_LEASE LEASE_ID Lease ID OH_AM_ASSET_VW LEASE_ID Character 30 Lease ID Lease ID A leased asset‘s lease identification number.
87 PS_LEASE VENDOR_ID Leased Asset - Vendor ID OH_AM_ASSET_VW OH_LSE_VENDOR_ID Character 10 Leased Asset - Vendor ID Leased Asset - Vendor ID For leased assets, the name of the Vendor ID is the identification
number for the vendor from which the asset was leased.
90
88 PS_LEASE LEASE_DT Lease Date OH_AM_ASSET_VW LEASE_DT Date 10 Lease Date Lease Date For leased assets, the Lease Date is the date on which the lease
91 commences. (Default Format: yyyy-mm-dd).
89 PS_LEASE MRP Minimum Rental Payment OH_AM_ASSET_VW MRP Sign 28 Minimum Rental Payment Minimum Rental Payment The Minimum Rental Payment entered is used to calculate the
92 lease payment schedule.
90 PS_LEASE EXECUTORY_COSTS Executory Costs OH_AM_ASSET_VW EXECUTORY_COSTS Sign 28 Executory Costs Executory Costs Executory Costs are expense incurred (e.g., insurance ,
maintenance costs) on a leased property, are examples of such
93 costs.
91 PS_LEASE MLP Minimum Lease Payment OH_AM_ASSET_VW MLP Sign 28 Minimum Lease Payment Minimum Lease Payment The Minimum Lease Payments (MLP) are the rental payments
that the lessee is obligated to make in connection with the leased
94 property.
92 PS_LEASE PV_MLP Present Value of Minimum Lease Payment OH_AM_ASSET_VW PV_MLP Sign 28 Present Value of Minimum Lease Present Value of Minimum Lease This field displays the present value of the lease payments for a
95 Payment Payment step lease.
93 PS_LEASE CAP_LEASE_AMT Capitalized Lease Amount OH_AM_ASSET_VW CAP_LEASE_AMT Sign 28 Capitalized Lease Amount Capitalized Lease Amount For leased assets, the Capitalized Lease Amount is the total cost.
96
94 PS_LEASE GUAR_RESIDUAL Guaranteed Residual Value OH_AM_ASSET_VW GUAR_RESIDUAL Sign 28 Guaranteed Residual Value Guaranteed Residual Value For leased assets, Asset Management calculates depreciation
based on the amount of the residual value of the leased asset
guaranteed by the lessee to the lessor and considered as part of
the minimum lease payments.
97
98 95 PS_LEASE ACTUAL_RESIDUAL Actual Residual Value OH_AM_ASSET_VW ACTUAL_RESIDUAL Sign 28 Actual Residual Value Actual Residual Value For leased assets, this field contains the actual residual value.
96 PS_LEASE TSFR_OWNERSHIP_FLG Transfer Ownership OH_AM_ASSET_VW TSFR_OWNERSHIP_FLG Character 1 Transfer Ownership Transfer Ownership For leased assets, the Transfer Ownership field is used when
ownership of the asset will be transferred to the state at the end of
99 the lease period.
97 PS_LEASE RENEWAL_OPTION Bargain Renewal Option OH_AM_ASSET_VW RENEWAL_OPTION Character 1 Bargain Renewal Option Bargain Renewal Option For leased assets, this field is selected if the lease includes a
Bargain Renewal Option (BRO), which requires a payment if the
lease agreement grants the lessee the right to renew or extend
the lease. If the agreement specifies that the lease must be
renewed or extended, a penalty might be required for failure to
100 renew.
98 PS_LEASE RENEWAL_PENALTY Renewal Payment Penalty OH_AM_ASSET_VW RENEWAL_PENALTY Sign 28 Renewal Payment Penalty Renewal Payment Penalty The Renewal Payment Penalty is the penalty amount that might
101 be required for failure to renew a lease.
7/15/20105:21 PM 20 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Available Assets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
99 PS_LEASE BPO Bargain Purchase Option OH_AM_ASSET_VW BPO Character 1 Bargain Purchase Option Bargain Purchase Option For leased assets, this field is selected if the lease includes a
Bargain Purchase Option (BPO) which represents a payment by
the lessee to the lessor at the end of the lease term, allowing the
102 lessee to obtain title to the leased property.
100 PS_LEASE BPO_PAYMENT Bargain Purchase Option Payment OH_AM_ASSET_VW BPO_PAYMENT Sign 28 Bargain Purchase Option Payment Bargain Purchase Option Payment For leased assets, the Bargain Purchase Option Payment field
contains the amount of the payment made at the end of the lease
term that allows the lessee to obtain title to the leased property.
103
101 PS_LEASE IMPLICIT_RATE Implicit Interest Rate OH_AM_ASSET_VW IMPLICIT_RATE Number 7 Implicit Interest Rate Implicit Interest Rate For leased assets, the Interest Rate is the approximate
percentage of profit the lessor gains by leasing the asset to you.
This number is an annual interest rate percentage in whole
104 numbers.
102 PS_LEASE BORROW_RATE Incremental Borrowing Rate OH_AM_ASSET_VW BORROW_RATE Number 7 Incremental Borrowing Rate Incremental Borrowing Rate The Incremental Borrowing Rate is the interest rate that you
would have incurred at the inception of the lease if you had
borrowed the necessary funds to purchase the leased asset. This
number is an annual interest rate percentage in whole numbers.
105
103 PS_LEASE LEASE_TYPE Lease Type OH_AM_ASSET_VW LEASE_TYPE Character 1 Lease Type Lease Type For leased assets, the Lease Type field is used to identify the
106 lease as capital or operating.
104 PS_LEASE LEASE_TERM Lease Term in Periods OH_AM_ASSET_VW LEASE_TERM Number 6 Lease Term in Periods Lease Term in Periods For leased assets, the Lease Term is number of periods in the
107 lease.
105 PS_LEASE FMV Fair Market Value OH_AM_ASSET_VW FMV Sign 28 Fair Market Value Fair Market Value For leased assets, the system calculates the capitalized lease
amount using the lesser of the Present value of Lease Payments
and Fair Market Value field values. If the Fair Market Value is
less than the Present value of Lease Payments, the capitalized
lease amount equals the Fair Market Value.
108
106 PS_LEASE EST_LIFE Estimated Life OH_AM_ASSET_VW EST_LIFE Number 6 Estimated Life Estimated Life For leased assets, the Estimated Life defaults to the number of
periods entered in the Lease Term field, unless the field is
109 updated by a user.
107 PS_LEASE PYMNT_SCHED_ID Payment Schedule ID OH_AM_ASSET_VW PYMNT_SCHED_ID Character 2 Payment Schedule ID Payment Schedule ID For leased assets, the Payment Schedule ID defaults the
110 payment frequency and number of periods.
108 PS_LEASE STEP_LEASE_FLAG Step Lease Flag OH_AM_ASSET_VW STEP_LEASE_FLAG Character 1 Step Lease Flag Step Lease Flag For leased assets, the Step Lease field is used when there are
variable payment amounts and/or variable timing over the term of
111 the lease.
109 PS_LEASE ACCEPTANCE_DT Lease Acceptance Date OH_AM_ASSET_VW ACCEPTANCE_DT Date 10 Lease Acceptance Date Lease Acceptance Date For leased assets, the Acceptance Date indicates the date the
lease contract is accepted (signed and returned to the lessor).
112 (Default Format: yyyy-mm-dd).
110 PS_LEASE LEASE_PYMT_TYPE Lease Payment Type OH_AM_ASSET_VW LEASE_PYMT_TYPE Character 1 Lease Payment Type Lease Payment Type For leased assets, the Lease Payment Type denotes whether the
113 lease is paid in advance or in arrears.
111 PS_LEASE EXPIRATION_DT Lease Expiration Date OH_AM_ASSET_VW EXPIRATION_DT Date 10 Lease Expiration Date Lease Expiration Date For leased assets, the Lease Expiration Date represents the last
114 lease payment date. (Default Format: yyyy-mm-dd).
112 PS_LEASE LEASE_COMMENCE_DT Lease Commence Date OH_AM_ASSET_VW LEASE_COMMENCE_DT Date 10 Lease Commence Date Lease Commence Date For leased assets, the Lease Commence Date represents the first
115 lease payment date. (Default Format: yyyy-mm-dd).
113 PS_LEASE LEASE_END_DT Lease End Date OH_AM_ASSET_VW LEASE_END_DT Date 10 Lease End Date Lease End Date For leased assets, the Lease End Date is the date on which the
lease terminates. This is an information-only field and is not used
in the calculation of the lease payment schedule. (Default
116 Format: yyyy-mm-dd).
114 PS_LEASE LEASE_RECEIPT_DT Lease Receipt Date OH_AM_ASSET_VW LEASE_RECEIPT_DT Date 10 Lease Receipt Date Lease Receipt Date For leased assets, the Lease Receipt Date is the date on which
the leased asset is received. This is an information-only field and
is not used in the calculation of the lease payment schedule.
117 (Default Format: yyyy-mm-dd).
115 PS_LEASE INTERIM_RENT Monthly Interim Rent OH_AM_ASSET_VW INTERIM_RENT Sign 28 Monthly Interim Rent Monthly Interim Rent For leased assets, this is the amount of monthly interim rent,
which is common for quarterly leases. Interim rent starts on the
acceptance date and ends on the commencement date of the
lease. Once the lease officially begins, the normal rental payment
118 amount is tracked by the lease payment schedule.
116 PS_LEASE_SCHED INTEREST_EXPENSE Lease Schedule Interest Expense OH_AM_ASSET_VW INTEREST_EXPENSE Sign 28 Lease Schedule Interest Expense Lease Schedule Interest Expense For leased assets, the Interest Expense field tracks the monthly
119 interest amount.
117 PS_LEASE_SCHED OBLIGATION_REDUCE Lease Schedule Obligation Reduction OH_AM_ASSET_VW OBLIGATION_REDUCE Sign 28 Lease Schedule Obligation Reduction Lease Schedule Obligation Reduction This field contains the obligation reduction by period for the lease
120 amount.
118 PS_LEASE_SCHED PYMNT_FREQUENCY Lease Schedule Payment Frequency OH_AM_ASSET_VW PYMNT_FREQUENCY Character 1 Lease Schedule Payment Frequency Lease Schedule Payment Frequency For leased assets, this field contains the frequency of the lease
121 payments (e.g., quarterly).
119 PS_LEASE_SCHED SCHED_PYMNT_TYPE Lease Schedule Payment Type OH_AM_ASSET_VW SCHED_PYMNT_TYPE Character 1 Lease Schedule Payment Type Lease Schedule Payment Type Type of lease payment schedule (C=Capital Interim Rent, I-
122 Interim Rent, N=Normal Rent).
120 PS_LEASE_SCH_ID NUM_PAY_PERIODS_YR Number of Lease Payment Periods OH_AM_ASSET_VW OH_NUM_PAY_PDS_YR Number 4 Number of Lease Payment Periods Number of Lease Payment Periods For leased assets, this field contains the number of lease
123 payment periods.
124 121 PS_ASSET_ATTRIBUTE ASSET_COLOR Asset Color OH_AM_ASSET_VW OH_ASSET_COLOR Character 15 Asset Color Asset Color This field contains the color of the asset.
125 122 PS_ASSET_ATTRIBUTE ASSET_WEIGHT Asset Weight OH_AM_ASSET_VW OH_ASSET_WEIGHT Number 13 Asset Weight Asset Weight This field contains the weight of the asset.
123 PS_ASSET_ATTRIBUTE WEIGHT_UM Asset Weight Unit of Measure OH_AM_ASSET_VW OH_WEIGHT_UM Character 3 Asset Weight Unit of Measure Asset Weight Unit of Measure This field contains the Unit of Measure for the weight of the asset
126 (e.g., lbs).
127 124 PS_ASSET_ATTRIBUTE ASSET_HEIGHT Asset Height OH_AM_ASSET_VW OH_ASSET_HEIGHT Number 13 Asset Height Asset Height This field contains the height of the asset.
125 PS_ASSET_ATTRIBUTE HEIGHT_UM Asset Height Unit of Measure OH_AM_ASSET_VW OH_HEIGHT_UM Character 3 Asset Height Unit of Measure Asset Height Unit of Measure This field contains the Unit of Measure for the height of the asset
128 (e.g., ft).
129 126 PS_ASSET_ATTRIBUTE ASSET_WIDTH Asset Width OH_AM_ASSET_VW OH_ASSET_WIDTH Number 13 Asset Width Asset Width This field contains the width of the asset.
127 PS_ASSET_ATTRIBUTE WIDTH_UM Asset Width Unit of Measure OH_AM_ASSET_VW OH_WIDTH_UM Character 3 Asset Width Unit of Measure Asset Width Unit of Measure This field contains the Unit of Measure for the width of the asset
130 (e.g., in).
128 PS_ASSET_ATTRIBUTE ASSET_LENGTH Asset Length OH_AM_ASSET_VW OH_ASSET_LENGTH Number 13 Asset Length Asset Length This field contains the length of the asset. For land assets, this
131 field will be used by the state to track acreage.
129 PS_ASSET_ATTRIBUTE LENGTH_UM Asset Length Unit of Measure OH_AM_ASSET_VW OH_LENGTH_UM Character 3 Asset Length Unit of Measure Asset Length Unit of Measure This field contains the Unit of Measure for the length of the asset.
For land assets, ―acres‖ should be selected in this field.
132
133 130 PS_ASSET_ATTRIBUTE ASSET_CAPACITY Asset Capacity OH_AM_ASSET_VW OH_ASSET_CAPACITY Number 13 Asset Capacity Asset Capacity This field contains the capacity of the asset.
131 PS_ASSET_ATTRIBUTE CAPACITY_UM Asset Capacity Unit of Measure OH_AM_ASSET_VW OH_CAPACITY_UM Character 3 Asset Capacity Unit of Measure Asset Capacity Unit of Measure This field contains the Unit of Measure for the capacity of the
134 asset.
135 132 PS_ASSET_ATTRIBUTE POWER_RATING Asset Power Rating OH_AM_ASSET_VW OH_POWER_RATING Number 13 Asset Power Rating Asset Power Rating This field contains the asset‘s power rating.
133 PS_ASSET_ATTRIBUTE POWER_RATING_UM Asset Power Rating Unit of Measure OH_AM_ASSET_VW OH_POWER_RATING_UM Character 3 Asset Power Rating Unit of Measure Asset Power Rating Unit of Measure This field contains the Unit of Measure for the asset‘s power
136 rating.
134 PS_ASSET_CUSTODIAN CUSTODIAN Asset Custodian OH_AM_ASSET_VW CUSTODIAN Character 30 Asset Custodian Asset Custodian The name of the state employee that is responsible for the asset.
137
135 PS_ASSET_CUSTODIAN EMPLID Asset Custodian Employee ID OH_AM_ASSET_VW EMPLID Character 11 Asset Custodian Employee ID Asset Custodian Employee ID The Employee ID of the state employee that is responsible for the
asset.
138
7/15/20105:21 PM 21 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Available Assets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
136 PS_ASSET_CUSTODIAN OFFSITE_SW Offsite OH_AM_ASSET_VW OH_OFFSITE_SW Character 1 Offsite Offsite The Offsite field is used to flag an asset that is located off the
premises.
139
137 PS_OH_ASSET_BLDG OH_BLDG_USE Building Use OH_AM_ASSET_VW OH_BLDG_USE Character 70 Building Use Building Use The Building Use field contains the functions or activities that are
140 performed in a building.
138 PS_OH_ASSET_BLDG OH_BLDG_CNSTRUC Building Construction Type OH_AM_ASSET_VW OH_BLDG_CNSTRUC Character 70 Construction Type Construction Type The Construction Type field contains the primary material(s) used
141 to construct a building.
142 139 PS_OH_ASSET_BLDG OH_BLDG_YR Year Building was Built OH_AM_ASSET_VW OH_BLDG_YR Nbr 4 Year Built Year Built Year Built is the year in which a building was constructed.
140 PS_OH_ASSET_BLDG OH_BLDG_STORY Building Stories Above Ground OH_AM_ASSET_VW OH_BLDG_STORY Nbr 4 Stories Above Ground Stories Above Ground Stories Above Ground is the number of floors that a building has
143 above ground.
141 PS_OH_ASSET_BLDG OH_BLDG_SPRINK Building Sprinkler System OH_AM_ASSET_VW OH_BLDG_SPRINK Character 1 Building Sprinkler System 3 translate values Sprinkler System Sprinkler System identifies whether a building has a sprinkler
144 system.
142 PSXLATITEM XLATLONGNAME XLAT Long Name OH_AM_ASSET_VW OH_BLDG_SPRK_DESCR Character 30 Building Sprinkler System Description Sprinkler System Description Description of the building Sprinkler System – 30 character text.
145
143 PS_OH_ASSET_BLDG OH_BLDG_ALARM Building Alarm System OH_AM_ASSET_VW OH_BLDG_ALARM Character 1 Alarm System 4 translate values Alarm System Alarm System identifies whether a building has a fire alarm,
146 burglar alarm, both types of alarms, or no alarm system.
147 144 PSXLATITEM XLATLONGNAME XLAT Long Name OH_AM_ASSET_VW OH_BLDG_ALRM_DESCR Character 30 Alarm System Description Alarm System Description Description of the building Alarm System – 30 character text.
145 PS_OH_ASSET_BLDG OH_BLDG_SQ_FT Building Square Footage OH_AM_ASSET_VW OH_BLDG_SQ_FT Nbr 15 Square Feet Square Feet Square Feet is the measurement of the total area of a building.
148
149 146 PS_OH_ASSET_BLDG OH_BLDG_APPRAIS Building Appraised Value OH_AM_ASSET_VW OH_BLDG_APPRAIS Character 27 Appraised Value Appraised Value The Appraised Value of the building.
150 147 PS_OH_ASSET_BLDG OH_BLDG_REP_RISK Report to Risk Management OH_AM_ASSET_VW OH_BLDG_REP_RISK Character 1 Report to Risk Management 2 translate values (Y/N) Report to Risk Management Report to Risk Management (Y/N).
148 PS_OH_ASSET_BLDG OH_BLDG_GROUPID Building Group ID OH_AM_ASSET_VW OH_BLDG_GROUPID Character 15 Building Group ID Building Group ID The Building Group ID is a distinct number that identifies a group
151 of buildings.
149 PS_OH_ASSET_BLDG OH_CONDITION_CD Condition Code OH_AM_ASSET_VW OH_CONDITION_CD Character 1 Condition Code 6 translate values Condition Code Condition Code is the current physical state of an asset (e.g.,
152 New, Fair).
150 PSXLATITEM XLATLONGNAME XLAT Long Name OH_AM_ASSET_VW OH_COND_CD_DESCR Character 30 Condition Code Description Condition Code Description Description of the building Condition Code – 30 character text.
153
151 PS_CATEGORY_TBL EFF_STATUS Category Effective Status OH_AM_ASSET_VW OH_CATEG_EFFSTATUS Character 1 Category Effective Status Category Effective Status The effective status (Active or Inactive) as of the effective date in
154 the Category table.
152 PS_CATEGORY_TBL DESCR Category Description OH_AM_ASSET_VW OH_CATEG_DESCR Character 30 Category Description Category Description This field contains the description of the value in the Asset
155 Category field.
153 PS_ASSET_CLASS_TBL EFF_STATUS Asset Class Effective Status OH_AM_ASSET_VW OH_AM_CLSS_EFFSTAT Character 1 Class Effective Status Class Effective Status The effective status (Active or Inactive) as of the effective date in
156 the Asset Class table.
154 PS_ASSET_CLASS_TBL DESCR50 Asset Class Description OH_AM_ASSET_VW DESCR50 Character 50 Asset Class Description Asset Class Description This field contains the description of the value in the Asset Class
157 field.
155 PS_PROFILE_TBL DESCR Profile Description OH_AM_ASSET_VW OH_PROFILE_DESCR Character 30 Asset Profile Description Asset Profile Description This field contains the description of the value in the Asset Profile
158 field.
156 PS_ASSET_FSC FSC_CODE Federal Hazardous Code OH_AM_ASSET_VW OH_FSC_CODE Character 5 Federal Hazardous Code Federal Hazardous Code For assets that are flagged with the Hazardous Asset field, this
field contains the code that identifies the reason why the asset is
159 hazardous.
157 PS_FED_SUP_CLASS ITEMS_CONTAINED Items Contained OH_AM_ASSET_VW OH_ITEMS_CONTAINED Character 50 Hazardous Items Contained Hazardous Items Contained For assets that are flagged with the Hazardous Asset field, this
160 field contains the description of why the asset is hazardous.
161 158 PS_BUS_UNIT_TBL_FS DESCR Business Unit Description OH_AM_ASSET_VW OH_BUS_UNIT_DESCR Character 30 Business Unit Description Business Unit Description Business Unit is an operational subset of an organization.
159 PS_ASSET_COMMENTS COMMENTS Asset Comments OH_AM_ASSET_VW OH_CNV_COMMENT Character 2000 Asset Comments Conversion Comments The Conversion Comments field contains the text that was
inserted into the Comments field in Asset Management during the
conversion from the Fixed Asset Management System (FAMS).
Certain data fields from FAMS that were not mapped to
equivalent fields in Asset Management were converted into the
Comments field for reference purposes. This field will not be
populated in the reporting warehouse for assets that were entered
162 into OAKS after the conversion.
7/15/20105:21 PM 22 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Asset Accounting
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
4 1 PS_ASSET BUSINESS_UNIT Business Unit OH_AM_ACCTG_VW BUSINESS_UNIT Character 5 Business Unit Y OAKS Asset Accounting The Asset Accounting Reporting Business Unit Business Unit is an operational subset of an organization.
2 PS_ASSET ASSET_ID Asset ID OH_AM_ACCTG_VW ASSET_ID Character 12 Asset ID Y Reporting Table Table is used to store the Asset ID Asset ID is the distinct number assigned to an asset when it is
accounting information for each entered into the system. It uniquely defines an asset within a
5 asset. Business Unit.
6 3 PS_BOOK BOOK Asset Book OH_AM_ACCTG_VW BOOK Character 10 Asset Book Y Asset Book Stores an asset‘s depreciation information (e.g., Useful Life).
4 PS_DIST_LN DTTM_STAMP Distribution Date/Time Stamp OH_AM_ACCTG_VW DTTM_STAMP Date/Time 26 Distribution Date/Time Stamp Y Distribution Date/Time Stamp Indicates the date/time the accounting entry was created.
7 (Default Format: yyyy-mm-dd).
5 PS_DIST_LN CF_SEQNO Distribution CF Sequence Number OH_AM_ACCTG_VW CF_SEQNO Number 6 Distribution CF Sequence Number Y Distribution CF Sequence Number Sequence number for each cost associated with a particular
8 asset.
6 PS_DIST_LN ACCOUNT Account OH_AM_ACCTG_VW ACCOUNT Character 10 Account ID Y Account ID The Account Chartfield is used to specify the balance sheet
account or operating account (i.e. expenditure or revenue object
codes) on financial transactions. Required on all transactions.
9
10 7 PS_GL_ACCOUNT DESCR Account Description OH_AM_ACCTG_VW OH_ACCT_DESCR Character 30 Account Description Account ID Description Account ID Description is free flow text up to 30 characters.
8 PS_DIST_LN DISTRIBUTION_TYPE Distribution Type OH_AM_ACCTG_VW DISTRIBUTION_TYPE Character 2 Distribution Type Y 45 translate values Distribution Type The Distribution Type field displays the accounting entry
distribution for this transaction (e.g., Fixed Asset, Depreciation
11 Expense).
9 PS_DIST_LN TRANS_TYPE Transaction Type OH_AM_ACCTG_VW TRANS_TYPE Character 3 Transaction Type Y 17 translate values Transaction Type Transaction Type identifies the transaction that occurred (e.g.,
12 addition, retirement).
10 PS_DIST_LN ACCOUNTING_DT Accounting Date OH_AM_ACCTG_VW ACCOUNTING_DT Date 10 Accounting Date Y Accounting Date Date that the transaction was booked or sent to accounting in the
13 system. (Default Format: yyyy-mm-dd).
11 PS_DIST_LN TRANS_IN_OUT Transaction In/Out OH_AM_ACCTG_VW TRANS_IN_OUT Character 1 Transaction In/Out Y 3 translate values Transaction In/Out The Transfer In/Out field identifies which type of transfer occurred
14 ('I' = In, 'O' = Out).
12 PS_DIST_LN DEPTID Department ID OH_AM_ACCTG_VW DEPTID Character 10 Department ID Y Department ID The Department chartfield identifies the financial management
organizational entity associated with a particular financial
transaction. The State will use this chartfield to capture the State
and agency organization chart. Required on encumbrance,
15 expense, and revenue transactions.
13 PS_DEPT_TBL DESCR Department Description PS_OH_BILLNG_VW OH_DEPT_DESCR Character 30 Department Description Department ID Description Department ID Description is free flow text up to 30 characters.
16
14 PS_DIST_LN OPERATING_UNIT Operating Unit OH_AM_ACCTG_VW OPERATING_UNIT Character 8 ISTV Xref Y ISTV Xref Operating Unit is used to record the ISTV Cross Reference
17 agency.
15 PS_OPER_UNIT_TBL DESCR ISTV XRef Description PS_OH_BILLNG_VW OH_OPER_DESCR Character 30 ISTV XRef Description ISTV Xref Description Intra-State Transfer Voucher Cross Reference Description is free
18 flow text up to 30 characters.
16 PS_DIST_LN PRODUCT Product OH_AM_ACCTG_VW PRODUCT Character 6 Appropriation Line Item Y Appropriation Line Item The Product chartfield is used by the State to capture
Appropriation Line Item (ALI), the legal spending authority by the
budget bill, and will be required on encumbrance and expense
19 transaction.
17 PS_PRODUCT_TBL DESCR Appropriation Line Item Description PS_OH_BILLNG_VW OH_PROD_DESCR Character 30 Appropriation Line Item Description Appropriation Line Item Description Appropriation Line Item Description is free flow text up to 30
20 characters.
18 PS_DIST_LN FUND_CODE Fund Code OH_AM_ACCTG_VW FUND_CODE Character 5 Fund Code Y Fund Code The Fund chartfield defines a fiscal and accounting entity with a
self-balancing set of accounts. It records cash and other financial
resources, together with related liabilities and residual equities or
balances, and any corresponding changes. Required on all
21 transactions.
22 19 PS_FUND_TBL DESCR Fund Description PS_OH_BILLNG_VW OH_FUND_DESCR Character 30 Fund Description Fund Code Description Fund Code Description is free flow text up to 30 characters.
20 PS_DIST_LN CLASS_FLD Class Field OH_AM_ACCTG_VW CLASS_FLD Character 5 Service Location Y Service Location Class field is used to capture the concept of Service Location
(state, county, city, district, building, etc.). This will allow the
state to track spending in relation to a geographical designation.
23
21 PS_CLASS_CF_TBL DESCR Service Location Description PS_OH_BILLNG_VW OH_CLASS_DESCR Character 30 Service Location Description Service Location Description Service Location Description is free flow text up to 30 characters.
24
22 PS_DIST_LN PROGRAM_CODE Program Code OH_AM_ACCTG_VW PROGRAM_CODE Character 5 Program Code Y Program Code The Program chartfield is used to capture the enterprise program
concept. The Program chartfield will enable the State to capture
the cost of providing a specific good or service in response to an
identified social or individual need or problem. Programs are
specific to an agency. Required on encumbrance and expense
25 transactions.
23 PS_PROGRAM_TBL DESCR Program Description PS_OH_BILLNG_VW OH_PROG_DESCR Character 30 Program Description Program Code Description Program Code Description is free flow text up to 30 characters.
26
24 PS_DIST_LN BUDGET_REF Budget Reference OH_AM_ACCTG_VW BUDGET_REF Character 8 Budget Reference Y Budget Reference The Budget Reference field is used to capture the federal fiscal
year for informational purposes. Some agencies have identified a
need to use this chartfield to identify the year for other purposes
not fulfilled by the system generated accounting and budget
period dates(e.g., the state fiscal year when recording indirect
costs in subsequent fiscal years). When not used to identify a
year for informational purposes, an agency may use this chartfield
to break an Appropriation Line Item into units for budget control.
27
25 PS_BUD_REF_TBL DESCR Budget Reference Description PS_OH_BILLNG_VW OH_BUDG_DESCR Character 30 Budget Reference Description Budget Reference Description Budget Reference Description is free flow text up to 30
28 characters.
26 PS_DIST_LN CHARTFIELD1 Project OH_AM_ACCTG_VW CHARTFIELD1 Character 10 Project ID Y Project ID Chartfield 1 is used to track project transactions when the project
costing module functionality is not required. Prior to the
implementation of the project costing module, all project
transactions will be tracked in this chartfield. A project is defined
as authorized expenditures for a specific purpose over a defined
period of time, and may cross fiscal years, fund, or departments.
Projects may be capital or non-capital, but are differentiated from
on-going operations by their lifecycle. This chartfield gives
agencies the ability to track project activity and grant activity in
29 separate chartfields.
30 27 PS_CHARTFIELD1_TBL DESCR Project Chartfield 1 Description PS_OH_BILLNG_VW OH_CHFD1_DESCR Character 30 Project Description Project ID Description Project ID Description is free flow text up to 30 characters.
28 PS_DIST_LN CHARTFIELD2 Reporting OH_AM_ACCTG_VW CHARTFIELD2 Character 10 Reporting ID Y Reporting ID Chartfield 2 is used to fulfill agency reporting requirements as
31 they relate to activities, tasks, or cost centers.
32 29 PS_CHARTFIELD2_TBL DESCR Reporting Chartfield 2 Description PS_OH_BILLNG_VW OH_CHFD2_DESCR Character 30 Reporting Description Reporting ID Description Reporting ID Description is free flow text up to 30 characters.
30 PS_DIST_LN CHARTFIELD3 Agency Use OH_AM_ACCTG_VW CHARTFIELD3 Character 10 Agency Use Y Agency Use Chartfield 3 is used to fulfill agency reporting requirements as
33 they relate to activities, tasks, or cost centers.
34 31 PS_CHARTFIELD3_TBL DESCR Agency Use Chartfield 3 Description PS_OH_BILLNG_VW OH_CHFD3_DESCR Character 30 Agency Use Description Agency Use Description Agency Use Description is free flow text up to 30 characters.
32 PS_DIST_LN PROJECT_ID Project Identifier OH_AM_ACCTG_VW PROJECT_ID Character 15 Grant/Project ID Y Grant/Project ID The Project ID chartfield is used to capture grant and project
transactions. All grant transactions will be tracked in this
chartfield to facilitate enterprise-wide reporting. This chartfield
may also be used to track project transactions after the project
costing module is implemented if an agency chooses to use the
project costing module functionality. This chartfield is designed to
track grant and project financial activity, which can cross budget
years, funds and departments. It is the gateway to the project
35 costing module functionality.
7/15/20105:21 PM 23 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Asset Accounting
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
33 PS_PROJECT DESCR Grant/Project Description PS_OH_BILLNG_VW OH_PROJ_DESCR Character 30 Grant/Project Description Grant/Project ID Description Grant/Project ID Description is free flow text up to 30 characters.
36
34 PS_DIST_LN CATEGORY Asset Category OH_AM_ACCTG_VW CATEGORY Character 5 Asset Category Y Asset Category The Asset Category field classifies assets by major asset
class/type for financial reporting purposes (e.g., Machinery &
37 Equipment, Land, Buildings).
35 PS_ASSET TAG_NUMBER Tag Number OH_AM_ACCTG_VW TAG_NUMBER Character 12 Tag Number Tag Number For personal property, Tag Number is the number from an asset's
barcode label. For real property, Tag Number is a smart-coded
38 value that uniquely identifies an asset.
39 36 PS_ASSET DESCR Asset Description OH_AM_ACCTG_VW OH_ASSET_DESCR Character 30 Asset Description Asset Description Description of the asset.
37 PS_ASSET ASSET_STATUS Asset Status OH_AM_ACCTG_VW ASSET_STATUS Character 1 Asset Status Asset Status Asset Status is the current state of an asset within its lifecycle
40 (e.g., In Service, Disposed).
41 38 PSXLATITEM XLATLONGNAME XLAT Long Name OH_AM_ACCTG_VW OH_AM_STATUS_DESCR Character 30 Asset Status Description Asset Status Description Description of the Asset Status.
39 PS_BOOK IN_SERVICE_DT In Service Date OH_AM_ACCTG_VW IN_SERVICE_DT Date 10 In Service Date In Service Date Date when an asset was placed in service. (Default Format: yyyy-
42 mm-dd).
43 40 PS_BOOK IN_SERVICE_PD In Service Period OH_AM_ACCTG_VW IN_SERVICE_PD Nbr 3 In Service Period In Service Period Period in which an asset was placed in service.
44 41 PS_BOOK IN_SERVICE_FY In Service Fiscal Year OH_AM_ACCTG_VW IN_SERVICE_FY Nbr 4 In Service Fiscal Year In Service Fiscal Year Fiscal year in which an asset was placed in service.
42 PS_BOOK BEGIN_DEPR_DT Begin Depreciation Date OH_AM_ACCTG_VW BEGIN_DEPR_DT Date 10 Begin Depreciation Date Begin Depreciation Date Date when an asset begins depreciating. The combination of the
In Service Date and the Depreciation Convention determines
when depreciation begins. (Default Format: yyyy-mm-dd).
45
46 43 PS_BOOK BEGIN_DEPR_PD Begin Depreciation Period OH_AM_ACCTG_VW BEGIN_DEPR_PD Nbr 3 Begin Depreciation Period Begin Depreciation Period Period in which an asset begins depreciating.
47 44 PS_BOOK BEGIN_DEPR_FY Begin Depreciation Fiscal Year OH_AM_ACCTG_VW BEGIN_DEPR_FY Nbr 4 Begin Depreciation Fiscal Year Begin Depreciation Fiscal Year Fiscal year in which an asset begins depreciating.
45 PS_BOOK BEGIN_CALC_DT Begin Calculation Date OH_AM_ACCTG_VW BEGIN_CALC_DT Date 10 Begin Calculation Date Begin Calculation Date Date when an asset‘s depreciation calculations start. Begin Calc
Date can never occur before the Begin Depreciation Date.
48 (Default Format: yyyy-mm-dd).
49 46 PS_BOOK BEGIN_CALC_PD Begin Calculation Period OH_AM_ACCTG_VW BEGIN_CALC_PD Nbr 3 Begin Calculation Period Begin Calculation Period Period in which an asset‘s depreciation calculations start.
47 PS_BOOK BEGIN_CALC_FY Begin Calculation Fiscal Year OH_AM_ACCTG_VW BEGIN_CALC_FY Nbr 4 Begin Calculation Fiscal Year Begin Calculation Fiscal Year Fiscal year in which an asset‘s depreciation calculations start.
50
48 PS_BOOK DEPR_STATUS Depreciation Status OH_AM_ACCTG_VW DEPR_STATUS Character 1 Depreciation Status Translate values are D, N Depreciation Status An asset's depreciation status: Depreciable/Non-Depreciable.
51
49 PS_BOOK LIFE Useful Life OH_AM_ACCTG_VW LIFE Nbr 4 Useful Life Useful Life Useful Life is the number of periods (months) over which an asset
52 will be depreciated.
50 PS_BOOK SUSPEND_STATUS Suspend Depreciation Status OH_AM_ACCTG_VW SUSPEND_STATUS Character 1 Suspend Depreciation Status Y/N field Suspend Depreciation Status Displays ―Y‖ when an asset has its depreciation suspended.
53 Displays ―N‖ when an asset has its depreciation resumed.
51 PS_BOOK SUSPEND_DT Suspend Depreciation Date OH_AM_ACCTG_VW SUSPEND_DT Date 10 Suspend Depreciation Date Suspend Depreciation Date Date when an asset‘s depreciation was suspended. (Default
54 Format: yyyy-mm-dd).
52 PS_BOOK RESUME_DT Resume Depreciation Date OH_AM_ACCTG_VW RESUME_DT Date 10 Resume Depreciation Date Resume Depreciation Date Date when an asset‘s depreciation was resumed after being
55 suspended. (Default Format: yyyy-mm-dd).
56 53 PS_BOOK LIFE_IN_YRS Useful Life in Years OH_AM_ACCTG_VW LIFE_IN_YRS Nbr 4.1 Useful Life in Years Useful Life in Years An asset‘s useful life in years.
54 PS_BOOK RETIREMENT_DT Retirement Date OH_AM_ACCTG_VW OH_BOOK_RETIRE_DT Date 10 Book - Retirement Date Book - Retirement Date This field displays the date on which an asset was retired.
57 (Default Format: yyyy-mm-dd).
55 PS_DIST_LN APPL_JRNL_ID Journal Template OH_AM_ACCTG_VW APPL_JRNL_ID Character 10 Journal Template Journal Template General Ledger journal template used to create the journal entry
58 for the asset accounting line.
59 56 PS_DIST_LN AMOUNT Amount OH_AM_ACCTG_VW AMOUNT Sign 23.3 Amount Amount The cost amount associated with a transaction.
57 PS_DIST_LN JOURNAL_ID Journal Identifier OH_AM_ACCTG_VW JOURNAL_ID Character 10 Journal Identifier Journal Identifier The Journal ID field displays the number of the journal entry that
60 will be processed in the General Ledger.
58 PS_DIST_LN JOURNAL_DATE Journal Date OH_AM_ACCTG_VW JOURNAL_DATE Date 10 Journal Date Journal Date Displays of the journal entry date. (Default Format: yyyy-mm-dd)
61
62 59 PS_DIST_LN JOURNAL_LINE GL Journal Line Number OH_AM_ACCTG_VW JOURNAL_LINE Number 9 GL Journal Line Number GL Journal Line Number Displays the journal entry's line number.
60 PS_DIST_LN GL_DISTRIB_STATUS GL Distribution Status OH_AM_ACCTG_VW GL_DISTRIB_STATUS Character 1 GL Distribution Status 9 translate values GL Distribution Status Displays whether the transaction has been distributed to the
63 General Ledger.
61 PS_DIST_LN LEDGER_GROUP GL Ledger Group OH_AM_ACCTG_VW LEDGER_GROUP Character 10 GL Ledger Group GL Ledger Group Ledger Group into which the accounting entry will be generated
64 (e.g., Full Accrual).
62 PS_DIST_LN LEDGER GL Ledger OH_AM_ACCTG_VW LEDGER Character 10 GL Ledger GL Ledger Ledger into which the accounting entry will be generated (e.g.,
65 Full Accrual).
66 63 PS_DIST_LN FISCAL_YEAR Fiscal Year OH_AM_ACCTG_VW FISCAL_YEAR Number 4 Fiscal Year Fiscal Year Fiscal Year in which the accounting entry was created.
67 64 PS_DIST_LN ACCOUNTING_PERIOD Accounting Period OH_AM_ACCTG_VW ACCOUNTING_PERIOD Number 3 Accounting Period Accounting Period Accounting period in which the accounting entry was created.
65 PS_DIST_LN IU_ANCHOR_FLG Inter Unit Anchor Flag OH_AM_ACCTG_VW IU_ANCHOR_FLG Character 1 Inter Unit Anchor Flag Y/N Flag Inter Unit Anchor Flag Y/N flag used to specify which transaction line is the
Inter/IntraUnit anchor flag (the line that contains the anchor
68 Business Unit and ChartFields).
66 PS_DIST_LN IU_SYS_TRAN_CD Inter Unit System Transfer Code OH_AM_ACCTG_VW IU_SYS_TRAN_CD Character 8 Inter Unit System Transfer Code Inter Unit System Transfer Code System Transactions are delivered system data, representing the
activities that can require interunit or intraunit accounting entries.
69
70 67 PS_DIST_LN IUT_JOURNAL_ID Inter Unit Transfer Journal ID OH_AM_ACCTG_VW OH_IUT_JOURNAL_ID Character 30 Inter Unit Transfer Journal ID Inter Unit Transfer Journal ID Identifies a journal entry for AM's interunit transfers.
68 PS_DIST_LN TRANSFER_BU Transfer Business Unit OH_AM_ACCTG_VW TRANSFER_BU Character 5 Transfer Business Unit Transfer Business Unit For assets that have been transferred ―out‖ of a Business Unit,
this field contains the Business Unit to which the asset was
transferred. For assets that have been transferred ―in‖ from
another Business Unit, this field contains the original Business
71 Unit.
69 PS_DIST_LN TRANSFER_ASSET_ID Transfer Asset ID OH_AM_ACCTG_VW TRANSFER_ASSET_ID Character 12 Transfer Asset ID Transfer Asset ID For assets that have been transferred ―out‖ of a Business Unit,
this field contains the asset‘s new Asset ID in the Business Unit
to which the asset was transferred. For assets that have been
transferred ―in‖ from another Business Unit, this field contains the
Asset ID from the original Business Unit.
72
73 70 PS_DIST_LN REVERSE_STATUS Reverse Status OH_AM_ACCTG_VW OH_REVERSE_STATUS Character 1 Reverse Status Reverse Status Status of a reversed accounting entry.
71 PS_DIST_LN REVERSE_DTTM_STAMP Reverse Date/Time Stamp OH_AM_ACCTG_VW OH_REVERSE_DTTM_ST Dttm 26 Reverse Date/Time Stamp Reverse Date/Time Stamp Indicates the date/time the accounting entry was reversed.
74 (Default Format: yyyy-mm-dd).
7/15/20105:21 PM 24 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Asset Cost
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
4 1 PS_ASSET BUSINESS_UNIT Business Unit OH_AM_COST_VW BUSINESS_UNIT Character 5 Business Unit Y OAKS Asset Cost Reporting Table The Asset Cost Reporting Table is Business Unit Business Unit is an operational subset of an organization.
2 PS_ASSET ASSET_ID Asset ID OH_AM_COST_VW ASSET_ID Character 12 Asset ID Y used to store the cost transactions Asset ID Asset ID is the distinct number assigned to an asset when it is
associated with an asset. entered into the system. It uniquely defines an asset within a
5 Business Unit.
6 3 PS_BOOK BOOK Asset Book OH_AM_COST_VW BOOK Character 10 Asset Book Y Asset Book Stores an asset‘s depreciation information (e.g., Useful Life).
4 PS_COST DTTM_STAMP Cost Date/Time Stamp OH_AM_COST_VW OH_COST_DTTM_STAMP Date/Time 26 Cost Date/Time Stamp Y Cost Date/Time Stamp Indicates the date/time a transaction was performed. (Default
7 Format: yyyy-mm-dd).
5 PS_COST CF_SEQNO CF Sequence Number OH_AM_COST_VW CF_SEQNO Number 6 CF Sequence Number Y CF Sequence Number Sequence number for each cost associated with a particular asset
8
6 PS_RETIREMENT DTTM_STAMP Retirement Date/Time Stamp OH_AM_COST_VW OH_RET_DTTM_STAMP Dttm 26 Retirement Date/Time Stamp Y Retirement Date/Time Stamp Indicates the date/time a retirement transaction was performed.
9 (Default Format: yyyy-mm-dd).
7 PS_ASSET TAG_NUMBER Tag Number OH_AM_COST_VW TAG_NUMBER Character 12 Tag Number Tag Number For personal property, Tag Number is the number from an asset's
barcode label. For real property, Tag Number is a smart-coded
10 value that uniquely identifies an asset.
11 8 PS_ASSET DESCR Asset Description OH_AM_COST_VW OH_ASSET_DESCR Character 30 Asset Description Asset Description Description of the asset.
9 PS_ASSET ASSET_STATUS Asset Status OH_AM_COST_VW ASSET_STATUS Character 1 Asset Status Asset Status Asset Status is the current state of an asset within its lifecycle
12 (e.g., In Service, Disposed).
13 10 PSXLATITEM XLATLONGNAME XLAT Long Name OH_AM_COST_VW OH_AM_STATUS_DESCR Character 30 Asset Status Description Asset Status Description Description of the Asset Status.
11 PS_BOOK IN_SERVICE_DT In Service Date OH_AM_COST_VW IN_SERVICE_DT Date 10 In Service Date In Service Date Date when an asset was placed in service. (Default Format: yyyy-
14 mm-dd).
15 12 PS_BOOK IN_SERVICE_PD In Service Period OH_AM_COST_VW IN_SERVICE_PD Nbr 3 In Service Period In Service Period Period in which an asset was placed in service.
16 13 PS_BOOK IN_SERVICE_FY In Service Fiscal Year OH_AM_COST_VW IN_SERVICE_FY Nbr 4 In Service Fiscal Year In Service Fiscal Year Fiscal year in which an asset was placed in service.
14 PS_BOOK BEGIN_DEPR_DT Begin Depreciation Date OH_AM_COST_VW BEGIN_DEPR_DT Date 10 Begin Depreciation Date Begin Depreciation Date Date when an asset begins depreciating. The combination of the
In Service Date and the Depreciation Convention determines
when depreciation begins. (Default Format: yyyy-mm-dd).
17
18 15 PS_BOOK BEGIN_DEPR_PD Begin Depreciation Period OH_AM_COST_VW BEGIN_DEPR_PD Nbr 3 Begin Depreciation Period Begin Depreciation Period Period in which an asset begins depreciating.
19 16 PS_BOOK BEGIN_DEPR_FY Begin Depreciation Fiscal Year OH_AM_COST_VW BEGIN_DEPR_FY Nbr 4 Begin Depreciation Fiscal Year Begin Depreciation Fiscal Year Fiscal year in which an asset begins depreciating.
17 PS_BOOK BEGIN_CALC_DT Begin Calculation Date OH_AM_COST_VW BEGIN_CALC_DT Date 10 Begin Calculation Date Begin Calculation Date Date when an asset‘s depreciation calculations start. Begin Calc
Date can never occur before the Begin Depreciation Date.
20 (Default Format: yyyy-mm-dd).
21 18 PS_BOOK BEGIN_CALC_PD Begin Calculation Period OH_AM_COST_VW BEGIN_CALC_PD Nbr 3 Begin Calculation Period Begin Calculation Period Period in which an asset‘s depreciation calculations start.
19 PS_BOOK BEGIN_CALC_FY Begin Calculation Fiscal Year OH_AM_COST_VW BEGIN_CALC_FY Nbr 4 Begin Calculation Fiscal Year Begin Calculation Fiscal Year Fiscal year in which an asset‘s depreciation calculations start.
22
20 PS_BOOK DEPR_STATUS Depreciation Status OH_AM_COST_VW DEPR_STATUS Character 1 Depreciation Status Translate values are D, N Depreciation Status An asset's depreciation status: Depreciable/Non-Depreciable.
23
21 PS_BOOK LIFE Useful Life OH_AM_COST_VW LIFE Nbr 4 Useful Life Useful Life Useful Life is the number of periods (months) over which an asset
24 will be depreciated.
22 PS_BOOK SUSPEND_STATUS Suspend Depreciation Status OH_AM_COST_VW SUSPEND_STATUS Character 1 Suspend Depreciation Status Y/N field Suspend Depreciation Status Displays ―Y‖ when an asset has its depreciation suspended.
25 Displays ―N‖ when an asset has its depreciation resumed.
23 PS_BOOK SUSPEND_DT Suspend Depreciation Date OH_AM_COST_VW SUSPEND_DT Date 10 Suspend Depreciation Date Suspend Depreciation Date Date when an asset‘s depreciation was suspended. (Default
26 Format: yyyy-mm-dd).
24 PS_BOOK RESUME_DT Resume Depreciation Date OH_AM_COST_VW RESUME_DT Date 10 Resume Depreciation Date Resume Depreciation Date Date when an asset‘s depreciation was resumed after being
27 suspended. (Default Format: yyyy-mm-dd).
28 25 PS_BOOK LIFE_IN_YRS Useful Life in Years OH_AM_COST_VW LIFE_IN_YRS Nbr 4.1 Useful Life in Years Useful Life in Years An asset‘s useful life in years.
26 PS_BOOK RETIREMENT_DT Book - Retirement Date OH_AM_COST_VW OH_BOOK_RETIRE_DT Date 10 Book - Retirement Date Book - Retirement Date This field displays the date on which an asset was retired.
29 (Default Format: yyyy-mm-dd).
27 PS_COST OPERATING_UNIT Operating Unit OH_AM_COST_VW OPERATING_UNIT Character 8 ISTV Xref ISTV Xref Operating Unit is used to record the ISTV Cross Reference
30 agency.
28 PS_OPER_UNIT_TBL DESCR ISTV XRef Description PS_OH_BILLNG_VW OH_OPER_DESCR Character 30 ISTV XRef Description ISTV Xref Description Intra-State Transfer Voucher Cross Reference Description is free
31 flow text up to 30 characters.
29 PS_COST PRODUCT Product OH_AM_COST_VW PRODUCT Character 6 Appropriation Line Item Appropriation Line Item The Product chartfield is used by the State to capture
Appropriation Line Item (ALI), the legal spending authority by the
budget bill, and will be required on encumbrance and expense
32 transaction.
30 PS_PRODUCT_TBL DESCR Appropriation Line Item Description PS_OH_BILLNG_VW OH_PROD_DESCR Character 30 Appropriation Line Item Description Appropriation Line Item Description Appropriation Line Item Description is free flow text up to 30
33 characters.
31 PS_COST FUND_CODE Fund Code OH_AM_COST_VW FUND_CODE Character 5 Fund Code Fund Code The Fund chartfield defines a fiscal and accounting entity with a
self-balancing set of accounts. It records cash and other financial
resources, together with related liabilities and residual equities or
balances, and any corresponding changes. Required on all
34 transactions.
35 32 PS_FUND_TBL DESCR Fund Description PS_OH_BILLNG_VW OH_FUND_DESCR Character 30 Fund Description Fund Code Description Fund Code Description is free flow text up to 30 characters.
33 PS_COST CLASS_FLD Class Field OH_AM_COST_VW CLASS_FLD Character 5 Service Location Service Location Class field is used to capture the concept of Service Location
(state, county, city, district, building, etc.). This will allow the
state to track spending in relation to a geographical designation.
36
34 PS_CLASS_CF_TBL DESCR Service Location Description PS_OH_BILLNG_VW OH_CLASS_DESCR Character 30 Service Location Description Service Location Description Service Location Description is free flow text up to 30 characters.
37
35 PS_COST PROGRAM_CODE Program Code OH_AM_COST_VW PROGRAM_CODE Character 5 Program Code Program Code The Program chartfield is used to capture the enterprise program
concept. The Program chartfield will enable the State to capture
the cost of providing a specific good or service in response to an
identified social or individual need or problem. Programs are
specific to an agency. Required on encumbrance and expense
38 transactions.
36 PS_PROGRAM_TBL DESCR Program Description PS_OH_BILLNG_VW OH_PROG_DESCR Character 30 Program Description Program Code Description Program Code Description is free flow text up to 30 characters.
39
37 PS_COST BUDGET_REF Budget Reference OH_AM_COST_VW BUDGET_REF Character 8 Budget Reference Budget Reference The Budget Reference field is used to capture the federal fiscal
year for informational purposes. Some agencies have identified a
need to use this chartfield to identify the year for other purposes
not fulfilled by the system generated accounting and budget
period dates(e.g., the state fiscal year when recording indirect
costs in subsequent fiscal years). When not used to identify a
year for informational purposes, an agency may use this chartfield
to break an Appropriation Line Item into units for budget control.
40
38 PS_BUD_REF_TBL DESCR Budget Reference Description PS_OH_BILLNG_VW OH_BUDG_DESCR Character 30 Budget Reference Description Budget Reference Description Budget Reference Description is free flow text up to 30
41 characters.
39 PS_COST CHARTFIELD1 Project ID OH_AM_COST_VW CHARTFIELD1 Character 10 Project ID Project ID Chartfield 1 is used to track project transactions when the project
costing module functionality is not required. Prior to the
implementation of the project costing module, all project
transactions will be tracked in this chartfield. A project is defined
as authorized expenditures for a specific purpose over a defined
period of time, and may cross fiscal years, fund, or departments.
Projects may be capital or non-capital, but are differentiated from
on-going operations by their lifecycle. This chartfield gives
agencies the ability to track project activity and grant activity in
42 separate chartfields.
7/15/20105:21 PM 25 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Asset Cost
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
43 40 PS_CHARTFIELD1_TBL DESCR Project Chartfield 1 Description PS_OH_BILLNG_VW OH_CHFD1_DESCR Character 30 Project Description Project ID Description Project ID Description is free flow text up to 30 characters.
41 PS_COST CHARTFIELD2 Reporting ID OH_AM_COST_VW CHARTFIELD2 Character 10 Reporting ID Reporting ID Chartfield 2 is used to fulfill agency reporting requirements as
44 they relate to activities, tasks, or cost centers.
45 42 PS_CHARTFIELD2_TBL DESCR Reporting Chartfield 2 Description PS_OH_BILLNG_VW OH_CHFD2_DESCR Character 30 Reporting Description Reporting ID Description Reporting ID Description is free flow text up to 30 characters.
43 PS_COST CHARTFIELD3 Agency Use OH_AM_COST_VW CHARTFIELD3 Character 10 Agency Use Agency Use Chartfield 3 is used to fulfill agency reporting requirements as
46 they relate to activities, tasks, or cost centers.
47 44 PS_CHARTFIELD3_TBL DESCR Agency Use Chartfield 3 Description PS_OH_BILLNG_VW OH_CHFD3_DESCR Character 30 Agency Use Description Agency Use Description Agency Use Description is free flow text up to 30 characters.
45 PS_COST PROJECT_ID Project Identifier OH_AM_COST_VW PROJECT_ID Character 15 Grant/Project ID Grant/Project ID The Project ID chartfield is used to capture grant and project
transactions. All grant transactions will be tracked in this
chartfield to facilitate enterprise-wide reporting. This chartfield
may also be used to track project transactions after the project
costing module is implemented if an agency chooses to use the
project costing module functionality. This chartfield is designed to
track grant and project financial activity, which can cross budget
years, funds and departments. It is the gateway to the project
48 costing module functionality.
46 PS_PROJECT DESCR Grant/Project Description PS_OH_BILLNG_VW OH_PROJ_DESCR Character 30 Grant/Project Description Grant/Project ID Description Grant/Project ID Description is free flow text up to 30 characters.
49
47 PS_COST DEPTID Department ID OH_AM_COST_VW DEPTID Character 10 Department ID Department ID The Department chartfield identifies the financial management
organizational entity associated with a particular financial
transaction. The State will use this chartfield to capture the State
and agency organization chart. Required on encumbrance,
50 expense, and revenue transactions.
48 PS_DEPT_TBL DESCR Department Description PS_OH_BILLNG_VW OH_DEPT_DESCR Character 30 Department Description Department ID Description Department ID Description is free flow text up to 30 characters.
51
49 PS_COST CATEGORY Asset Category OH_AM_COST_VW CATEGORY Character 5 Asset Category Asset Category The Asset Category field classifies assets by major asset
class/type for financial reporting purposes (e.g., Machinery &
52 Equipment, Land, Buildings).
50 PS_COST TRANS_TYPE Transaction Type OH_AM_COST_VW TRANS_TYPE Character 3 Transaction Type 17 translate values Transaction Type Transaction Type identifies the transaction that occurred (e.g.,
53 addition, retirement).
51 PS_COST TRANS_IN_OUT Transaction In/Out OH_AM_COST_VW TRANS_IN_OUT Character 1 Transaction In/Out 3 translate values Transaction In/Out The Transfer In/Out field identifies which type of transfer occurred
54 ('I' = In, 'O' = Out).
52 PS_COST TRANS_DT Transaction Date OH_AM_COST_VW TRANS_DT Date 10 Transaction Date Transaction Date Actual date that the transaction occurred. (Default Format: yyyy-
55 mm-dd).
53 PS_COST ACCOUNTING_DT Cost - Accounting Date OH_AM_COST_VW OH_COST_ACCTG_DT Date 10 Cost - Accounting Date Cost - Accounting Date Date that the transaction was booked or sent to accounting in the
56 system. (Default Format: yyyy-mm-dd).
57 54 PS_COST QUANTITY Quantity OH_AM_COST_VW OH_COST_QUANTITY Sign 11.4 Quantity Quantity An asset‘s quantity.
58 55 PS_COST TXN_COST Transaction Cost OH_AM_COST_VW OH_TXN_COST Sign 23.3 Transaction Cost Transaction Cost Cost amount associated with a transaction.
59 56 PS_COST COST Total Cost OH_AM_COST_VW COST Sign 23.3 Total Cost Total Cost An asset's total cost.
57 PS_COST TRANSFER_BU Transfer Asset Business Unit OH_AM_COST_VW TRANSFER_BU Character 5 Transfer Asset Business Unit Transfer Business Unit For assets that have been transferred ―out‖ of a Business Unit,
this field contains the Business Unit to which the asset was
transferred. For assets that have been transferred ―in‖ from
another Business Unit, this field contains the original Business
60 Unit.
58 PS_COST TRANSFER_ASSET_ID Transfer Asset ID OH_AM_COST_VW TRANSFER_ASSET_ID Character 12 Transfer Asset ID Transfer Asset ID For assets that have been transferred ―out‖ of a Business Unit,
this field contains the asset‘s new Asset ID in the Business Unit
to which the asset was transferred. For assets that have been
transferred ―in‖ from another Business Unit, this field contains the
Asset ID from the original Business Unit.
61
62 59 PS_COST OPRID User ID OH_AM_COST_VW OPRID Character 30 User ID User ID The User ID of the person that performed the transaction.
7/15/20105:21 PM 26 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Asset Depreciation
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
4 1 PS_ASSET BUSINESS_UNIT Business Unit OH_AM_DEPR_VW BUSINESS_UNIT Character 5 Business Unit Y OAKS Asset Depreciation The Asset Depreciation Reporting Business Unit Business Unit is an operational subset of an organization.
2 PS_ASSET ASSET_ID Asset ID OH_AM_DEPR_VW ASSET_ID Character 12 Asset ID Y Reporting Table Table is used to store the Asset ID Asset ID is the distinct number assigned to an asset when it is
depreciation information for each entered into the system. It uniquely defines an asset within a
5 asset. Business Unit.
6 3 PS_BOOK BOOK Asset Book OH_AM_DEPR_VW BOOK Character 10 Asset Book Y Asset Book Stores an asset‘s depreciation information (e.g., Useful Life).
7 4 PS_DEPRECIATION DTTM_STAMP Date/Time Stamp OH_AM_DEPR_VW DTTM_STAMP Date 10 Date/Time Stamp Y Depreciation Date/Time Stamp Depreciation Date/Time Stamp
5 PS_DEPRECIATION CF_SEQNO Depreciation CF Sequence Number OH_AM_DEPR_VW CF_SEQNO Number 6 Depreciation CF Sequence Number Y Depreciation CF Sequence Number Sequence number for each cost associated with a particular
8 asset.
6 PS_DEPRECIATION FISCAL_YEAR Fiscal Year OH_AM_DEPR_VW FISCAL_YEAR Number 4 Fiscal Year Y Fiscal Year Represents the fiscal year in which the depreciation was taken.
9
7 PS_DEPRECIATION START_PD Start Period OH_AM_DEPR_VW START_PD Nbr 3 Start Period Y Start Period Represents the start period for which the depreciation was taken.
10
8 PS_DEPRECIATION END_PD End Period OH_AM_DEPR_VW END_PD Nbr 3 End Period Y End Period Represents the end period for which the depreciation was taken.
11
9 PS_DEPRECIATION TRANS_TYPE Action OH_AM_DEPR_VW TRANS_TYPE Character 3 Action Y Transaction Type Transaction Type identifies the transaction that occurred (e.g.,
12 addition, retirement).
10 PS_DEPRECIATION TRANS_IN_OUT Transaction In/Out OH_AM_DEPR_VW TRANS_IN_OUT Character 1 Transaction In/Out Y Transaction In/Out The Transfer In/Out field identifies which type of transfer occurred
13 ('I' = In, 'O' = Out).
11 PS_DEPRECIATION TRANS_DT Transaction Date OH_AM_DEPR_VW TRANS_DT Date 10 Transaction Date Y Transaction Date Actual date that the transaction occurred. (Default Format: yyyy-
14 mm-dd).
12 PS_ASSET TAG_NUMBER Tag Number OH_AM_DEPR_VW TAG_NUMBER Character 12 Tag Number Tag Number For personal property, Tag Number is the number from an asset's
barcode label. For real property, Tag Number is a smart-coded
15 value that uniquely identifies an asset.
16 13 PS_ASSET DESCR Asset Description OH_AM_DEPR_VW OH_ASSET_DESCR Character 30 Asset Description Asset Description Description of the asset.
14 PS_ASSET ASSET_STATUS Asset Status OH_AM_DEPR_VW ASSET_STATUS Character 1 Asset Status Asset Status Asset Status is the current state of an asset within its lifecycle
17 (e.g., In Service, Disposed).
18 15 PSXLATITEM XLATLONGNAME XLAT Long Name OH_AM_DEPR_VW OH_AM_STATUS_DESCR Character 30 Asset Status Description Asset Status Description Description of the Asset Status.
16 PS_BOOK IN_SERVICE_DT In Service Date OH_AM_DEPR_VW IN_SERVICE_DT Date 10 In Service Date In Service Date Date when an asset was placed in service. (Default Format: yyyy-
19 mm-dd).
20 17 PS_BOOK IN_SERVICE_PD In Service Period OH_AM_DEPR_VW IN_SERVICE_PD Nbr 3 In Service Period In Service Period Period in which an asset was placed in service.
21 18 PS_BOOK IN_SERVICE_FY In Service Fiscal Year OH_AM_DEPR_VW IN_SERVICE_FY Nbr 4 In Service Fiscal Year In Service Fiscal Year Fiscal year in which an asset was placed in service.
19 PS_BOOK BEGIN_DEPR_DT Begin Depreciation Date OH_AM_DEPR_VW BEGIN_DEPR_DT Date 10 Begin Depreciation Date Begin Depreciation Date Date when an asset begins depreciating. The combination of the
In Service Date and the Depreciation Convention determines
when depreciation begins. (Default Format: yyyy-mm-dd).
22
23 20 PS_BOOK BEGIN_DEPR_PD Begin Depreciation Period OH_AM_DEPR_VW BEGIN_DEPR_PD Nbr 3 Begin Depreciation Period Begin Depreciation Period Period in which an asset begins depreciating.
24 21 PS_BOOK BEGIN_DEPR_FY Begin Depreciation Fiscal Year OH_AM_DEPR_VW BEGIN_DEPR_FY Nbr 4 Begin Depreciation Fiscal Year Begin Depreciation Fiscal Year Fiscal year in which an asset begins depreciating.
22 PS_BOOK BEGIN_CALC_DT Begin Calculation Date OH_AM_DEPR_VW BEGIN_CALC_DT Date 10 Begin Calculation Date Begin Calculation Date Date when an asset‘s depreciation calculations start. Begin Calc
Date can never occur before the Begin Depreciation Date.
25 (Default Format: yyyy-mm-dd).
26 23 PS_BOOK BEGIN_CALC_PD Begin Calculation Period OH_AM_DEPR_VW BEGIN_CALC_PD Nbr 3 Begin Calculation Period Begin Calculation Period Period in which an asset‘s depreciation calculations start.
24 PS_BOOK BEGIN_CALC_FY Begin Calculation Fiscal Year OH_AM_DEPR_VW BEGIN_CALC_FY Nbr 4 Begin Calculation Fiscal Year Begin Calculation Fiscal Year Fiscal year in which an asset‘s depreciation calculations start.
27
25 PS_BOOK DEPR_STATUS Depreciation Status OH_AM_DEPR_VW DEPR_STATUS Character 1 Depreciation Status Translate values are D, N Depreciation Status An asset's depreciation status: Depreciable/Non-Depreciable.
28
26 PS_BOOK LIFE Useful Life OH_AM_DEPR_VW LIFE Nbr 4 Useful Life Useful Life Useful Life is the number of periods (months) over which an asset
29 will be depreciated.
27 PS_BOOK SUSPEND_STATUS Suspend Depreciation Status OH_AM_DEPR_VW SUSPEND_STATUS Character 1 Suspend Depreciation Status Y/N field Suspend Depreciation Status Displays ―Y‖ when an asset has its depreciation suspended.
30 Displays ―N‖ when an asset has its depreciation resumed.
28 PS_BOOK SUSPEND_DT Suspend Depreciation Date OH_AM_DEPR_VW SUSPEND_DT Date 10 Suspend Depreciation Date Suspend Depreciation Date Date when an asset‘s depreciation was suspended. (Default
31 Format: yyyy-mm-dd).
29 PS_BOOK RESUME_DT Resume Depreciation Date OH_AM_DEPR_VW RESUME_DT Date 10 Resume Depreciation Date Resume Depreciation Date Date when an asset‘s depreciation was resumed after being
32 suspended. (Default Format: yyyy-mm-dd).
33 30 PS_BOOK LIFE_IN_YRS Useful Life in Years OH_AM_DEPR_VW LIFE_IN_YRS Nbr 4.1 Useful Life in Years Useful Life in Years An asset‘s useful life in years.
31 PS_BOOK RETIREMENT_DT Book - Retirement Date OH_AM_DEPR_VW OH_BOOK_RETIRE_DT Date 10 Book - Retirement Date Book - Retirement Date This field displays the date on which an asset was retired.
34 (Default Format: yyyy-mm-dd).
32 PS_DEPRECIATION OPERATING_UNIT Operating Unit OH_AM_DEPR_VW OPERATING_UNIT Character 8 ISTV Xref ISTV Xref Operating Unit is used to record the ISTV Cross Reference
35 agency.
33 PS_OPER_UNIT_TBL DESCR ISTV XRef Description PS_OH_BILLNG_VW OH_OPER_DESCR Character 30 ISTV XRef Description ISTV Xref Description Intra-State Transfer Voucher Cross Reference Description is free
36 flow text up to 30 characters.
34 PS_DEPRECIATION PRODUCT Product OH_AM_DEPR_VW PRODUCT Character 6 Appropriation Line Item Appropriation Line Item The Product chartfield is used by the State to capture
Appropriation Line Item (ALI), the legal spending authority by the
budget bill, and will be required on encumbrance and expense
37 transaction.
35 PS_PRODUCT_TBL DESCR Appropriation Line Item Description PS_OH_BILLNG_VW OH_PROD_DESCR Character 30 Appropriation Line Item Description Appropriation Line Item Description Appropriation Line Item Description is free flow text up to 30
38 characters.
36 PS_DEPRECIATION FUND_CODE Fund Code OH_AM_DEPR_VW FUND_CODE Character 5 Fund Code Fund Code The Fund chartfield defines a fiscal and accounting entity with a
self-balancing set of accounts. It records cash and other financial
resources, together with related liabilities and residual equities or
balances, and any corresponding changes. Required on all
39 transactions.
40 37 PS_FUND_TBL DESCR Fund Description PS_OH_BILLNG_VW OH_FUND_DESCR Character 30 Fund Description Fund Code Description Fund Code Description is free flow text up to 30 characters.
38 PS_DEPRECIATION CLASS_FLD Class Field OH_AM_DEPR_VW CLASS_FLD Character 5 Service Location Service Location Class field is used to capture the concept of Service Location
(state, county, city, district, building, etc.). This will allow the
state to track spending in relation to a geographical designation.
41
39 PS_CLASS_CF_TBL DESCR Service Location Description PS_OH_BILLNG_VW OH_CLASS_DESCR Character 30 Service Location Description Service Location Description Service Location Description is free flow text up to 30 characters.
42
40 PS_DEPRECIATION PROGRAM_CODE Program Code OH_AM_DEPR_VW PROGRAM_CODE Character 5 Program Code Program Code The Program chartfield is used to capture the enterprise program
concept. The Program chartfield will enable the State to capture
the cost of providing a specific good or service in response to an
identified social or individual need or problem. Programs are
specific to an agency. Required on encumbrance and expense
43 transactions.
41 PS_PROGRAM_TBL DESCR Program Description PS_OH_BILLNG_VW OH_PROG_DESCR Character 30 Program Description Program Code Description Program Code Description is free flow text up to 30 characters.
44
42 PS_DEPRECIATION BUDGET_REF Budget Reference OH_AM_DEPR_VW BUDGET_REF Character 8 Budget Reference Budget Reference The Budget Reference field is used to capture the federal fiscal
year for informational purposes. Some agencies have identified a
need to use this chartfield to identify the year for other purposes
not fulfilled by the system generated accounting and budget
period dates(e.g., the state fiscal year when recording indirect
costs in subsequent fiscal years). When not used to identify a
year for informational purposes, an agency may use this chartfield
to break an Appropriation Line Item into units for budget control.
45
43 PS_BUD_REF_TBL DESCR Budget Reference Description PS_OH_BILLNG_VW OH_BUDG_DESCR Character 30 Budget Reference Description Budget Reference Description Budget Reference Description is free flow text up to 30
46 characters.
7/15/20105:21 PM 27 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls OAKS Operational Reporting Data Warehouse
FIN - Asset Management Reporting Data Dictionary: Asset Depreciation
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
44 PS_DEPRECIATION CHARTFIELD1 Project OH_AM_DEPR_VW CHARTFIELD1 Character 10 Project ID Project ID Chartfield 1 is used to track project transactions when the project
costing module functionality is not required. Prior to the
implementation of the project costing module, all project
transactions will be tracked in this chartfield. A project is defined
as authorized expenditures for a specific purpose over a defined
period of time, and may cross fiscal years, fund, or departments.
Projects may be capital or non-capital, but are differentiated from
on-going operations by their lifecycle. This chartfield gives
agencies the ability to track project activity and grant activity in
47 separate chartfields.
48 45 PS_CHARTFIELD1_TBL DESCR Project Chartfield 1 Description PS_OH_BILLNG_VW OH_CHFD1_DESCR Character 30 Project Description Project ID Description Project ID Description is free flow text up to 30 characters.
46 PS_DEPRECIATION CHARTFIELD2 Reporting OH_AM_DEPR_VW CHARTFIELD2 Character 10 Reporting ID Reporting ID Chartfield 2 is used to fulfill agency reporting requirements as
49 they relate to activities, tasks, or cost centers.
50 47 PS_CHARTFIELD2_TBL DESCR Reporting Chartfield 2 Description PS_OH_BILLNG_VW OH_CHFD2_DESCR Character 30 Reporting Description Reporting ID Description Reporting ID Description is free flow text up to 30 characters.
48 PS_DEPRECIATION CHARTFIELD3 Agency Use OH_AM_DEPR_VW CHARTFIELD3 Character 10 Agency Use Agency Use Chartfield 3 is used to fulfill agency reporting requirements as
51 they relate to activities, tasks, or cost centers.
52 49 PS_CHARTFIELD3_TBL DESCR Agency Use Chartfield 3 Description PS_OH_BILLNG_VW OH_CHFD3_DESCR Character 30 Agency Use Description Agency Use Description Agency Use Description is free flow text up to 30 characters.
50 PS_DEPRECIATION PROJECT_ID Project Identifier OH_AM_DEPR_VW PROJECT_ID Character 15 Grant/Project ID Grant/Project ID The Project ID chartfield is used to capture grant and project
transactions. All grant transactions will be tracked in this
chartfield to facilitate enterprise-wide reporting. This chartfield
may also be used to track project transactions after the project
costing module is implemented if an agency chooses to use the
project costing module functionality. This chartfield is designed to
track grant and project financial activity, which can cross budget
years, funds and departments. It is the gateway to the project
53 costing module functionality.
51 PS_PROJECT DESCR Grant/Project Description PS_OH_BILLNG_VW OH_PROJ_DESCR Character 30 Grant/Project Description Grant/Project ID Description Grant/Project ID Description is free flow text up to 30 characters.
54
52 PS_DEPRECIATION DEPTID Department ID OH_AM_DEPR_VW DEPTID Character 10 Department ID Department ID The Department chartfield identifies the financial management
organizational entity associated with a particular financial
transaction. The State will use this chartfield to capture the State
and agency organization chart. Required on encumbrance,
55 expense, and revenue transactions.
53 PS_DEPT_TBL DESCR Department Description PS_OH_BILLNG_VW OH_DEPT_DESCR Character 30 Department Description Department ID Description Department ID Description is free flow text up to 30 characters.
56
54 PS_DEPRECIATION CATEGORY Asset Category OH_AM_DEPR_VW CATEGORY Character 5 Asset Category Asset Category The Asset Category field classifies assets by major asset
class/type for financial reporting purposes (e.g., Machinery &
57 Equipment, Land, Buildings).
58 55 PS_DEPRECIATION YTD_FLAG Original Reserve OH_AM_DEPR_VW YTD_FLAG Character 1 Original Reserve Year to Date Depreciation Flag Year to Date Flag
56 PS_DEPRECIATION ACTIVITY_SW Activity Switch OH_AM_DEPR_VW ACTIVITY_SW Character 1 Activity Switch Activity Switch This is a numeric field that identifies whether a transaction is an
active chartfield combination for an asset. When the sum of the
activity switch for a chartfield combination for an asset = 0, then
59 the chartfield combination is active.
60 57 PS_DEPRECIATION DEPR Depreciation Amount OH_AM_DEPR_VW DEPR Sign 23.3 Depreciation Amount Depreciation Amount Period Depreciation
61 58 PS_DEPRECIATION DEPR_YTD Year to Date Depreciation OH_AM_DEPR_VW DEPR_YTD Sign 23.3 Year to Date Depreciation Year to Date Depreciation Total depreciation for the current year.
7/15/20105:21 PM 28 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls
OAKS Operational Reporting Data Warehouse
FIN - Billing Reporting Data Dictionary: Billing
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
1 PS_BI_HDR BUSINESS_UNIT Business Unit PS_OH_BILLNG_VW BUSINESS_UNIT Character 5 Business Unit Y OAKS Billing Reporting Table The OAKS Billing Reporting Table Agency Billing Business Unit The Business Unit represents an agency or sub-set of an agency
provides users with information that is independent with regard to one or more operational or
4 related to billing invoices, and accounting functions.
5 2 PS_BI_HDR INVOICE Invoice PS_OH_BILLNG_VW INVOICE Character 22 Invoice Y associated accounting and pending Invoice Identifier Billing invoice number.
6 3 PS_BI_HDR_NOTE NOTES_SEQ_NUM Notes Sequence Number PS_OH_BILLNG_VW OH_HDR_NT_SEQ_NO Numeric 38 Notes Sequence Number Y item information. Header Notes Sequence Number Notes sequence number for header note on invoice.
4 PS_BI_LINE LINE_SEQ_NUM Sequence PS_OH_BILLNG_VW OH_LN_LN_SEQ Numeric 38 Sequence Y Invoice Line - Line Sequence Billing invoice line number to which the accounting line is
7 Number associated.
5 PS_BI_LINE_NOTE LINE_SEQ_NUM Sequence PS_OH_BILLNG_VW OH_LN_NT_LN_SEQ Numeric 38 Sequence Y Line Note - Line Sequence Number Bill line sequence number on which note is defined on bill line.
8
9 6 PS_BI_LINE_NOTE NOTES_SEQ_NUM Notes Sequence Num PS_OH_BILLNG_VW OH_LN_NT_SEQ_NO Numeric 38 Notes Sequence Num Y Line Notes Sequence Number Notes sequence number for bill line note on invoice.
10 PS_BI_INSTALL_SCHE EVENT_OCCURRENCE Occurrence PS_OH_BILLNG_VW OH_INST_EVNT_OC Numeric 3 Event Occurrence Y Install Event Occurrence Sequential number for each bill listed in the installment bill
10 schedule.
11 PS_BI_SCHEDULE EVENT_OCCURRENCE Occurrence PS_OH_BILLNG_VW OH_SCHED_EVNT_OC Numeric 3 Event Occurrence Y Schedule - Event Occurrence Sequential number for each bill listed in the recurring bill
11 schedule.
12
13 57 PS_BI_HDR BILL_TO_CUST_ID Customer PS_OH_BILLNG_VW BILL_TO_CUST_ID Character 15 Customer Customer Identifier Customer ID of the customer that is being billed.
14 58 PS_BI_HDR BILL_STATUS Bill Status PS_OH_BILLNG_VW BILL_STATUS Character 3 Bill Status Bill Status Status of the bill.
59 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_BILL_STAT_DESCR Character 30 Bill Status Description Bill Status Description Description of the value shown in the Bill Status field - 30
15 character text.
16 60 PS_BI_HDR CONTRACT_NUM Contract Number PS_OH_BILLNG_VW OH_HDR_CNT_NUM Character 25 Contract Number Invoice Header - Contract Number Contract number associated with the bill.
17 61 PS_BI_HDR INVOICE_TYPE Invoice Type PS_OH_BILLNG_VW INVOICE_TYPE Character 3 Invoice Type Invoice Type Type of invoice - original or adjustment invoice.
18 62 PS_BI_HDR CONSOL_HDR Consolidated Header PS_OH_BILLNG_VW CONSOL_HDR Character 1 Consolidated Header Consolidated Header Invoice number of the consolidated bill.
63 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_CONSL_HDR_DESCR Character 30 Consolidated Header Description Consolidated Header Description Description of the value shown in the Consolidated Header field -
19 30 character text.
20 64 PS_BI_HDR CONSOL_KEY Invoice Consolidation Key PS_OH_BILLNG_VW CONSOL_KEY Character 22 Invoice Consolidation Key Consolidation Key Identifier that describes a group of consolidated bills.
65 PS_BI_HDR CONSOL_CUST_ID Consolidation Customer ID PS_OH_BILLNG_VW CONSOL_CUST_ID Character 15 Consolidation Customer ID Consolidated Customer Identifier Customer Identifier of the customer to whom the consolidated
21 bills are being billed to.
66 PS_BI_HDR CONSOL_INVOICE Consolidation Invoice PS_OH_BILLNG_VW CONSOL_INVOICE Character 22 Consolidation Invoice Consolidated Invoice Identifier Specifies the invoice number associated with a consolidated bill.
22
67 PS_BI_HDR ORIGINAL_INVOICE Original Invoice PS_OH_BILLNG_VW OH_HDR_ORIG_INV Character 22 Original Invoice Header Original Invoice Identifier Specifies the original invoice number, from which adjustment bills
23 may be created.
68 PS_BI_HDR PRIOR_ADJ_INVOICE Prior Adjusted Invoice PS_OH_BILLNG_VW OH_HDR_PRI_A_INV Character 22 Prior Adjusted Invoice Invoice Header - Adjusted Prior Invoice number of previously adjusted invoice.
24 Invoice Identifier
69 PS_BI_HDR NEXT_ADJ_INVOICE Next Adjusted Invoice PS_OH_BILLNG_VW OH_HDR_NEXT_INV Character 22 Next Adjusted Invoice Invoice Header - Adjusted Next Invoice number of next subsequently adjusted invoice.
25 Invoice Identifier
70 PS_BI_HDR LATEST_INVOICE Latest Invoice PS_OH_BILLNG_VW OH_HDR_LATE_INV Character 22 Latest Invoice Invoice Header - Adjusted Latest Invoice number of last adjustment made from original invoice.
26 Invoice Identifier
27 71 PS_BI_HDR ADJUSTED_FLAG Adjusted Flag PS_OH_BILLNG_VW OH_HDR_ADJ_FLG Character 1 Adjusted Flag Invoice Header - Adjusted Flag Flag indicator that invoice was adjusted.
72 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_ADJ_FLG_DESCR Character 30 Adjusted Flag Description Invoice Header - Adjusted Flag Description of the value shown in the Invoice Header - Adjusted
28 Description Flag field - 30 character text.
73 PS_BI_HDR BILL_TYPE_ID Bill Type Identifier PS_OH_BILLNG_VW BILL_TYPE_ID Character 3 Bill Type Identifier Bill Type Identifier Agency defined identifier code to indicate type of billing invoice.
29
74 PS_BI_HDR BILL_CYCLE_ID Billing Cycle Identifier PS_OH_BILLNG_VW BILL_CYCLE_ID Character 10 Billing Cycle Identifier Billing Cycle Identifier Identifier code to indicate the billing cycle on the invoice including
values for Daily, Recurring and Installments billing cycles.
30
31 75 PS_BI_HDR HDR_FIELDS_KEY Header Fields Key PS_OH_BILLNG_VW HDR_FIELDS_KEY Character 30 Header Fields Key Header Fields Key Code or value to relate bill line(s) to a particular bill header.
32 76 PS_BI_HDR BILLING_FREQUENCY Billing Frequency PS_OH_BILLNG_VW BILLING_FREQUENCY Character 3 Billing Frequency Billing Frequency Indicator of frequency of the billing invoice.
77 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_BILL_FREQ_DESCR Character 30 Billing Frequency Description Billing Frequency Description Description of the value shown in the Billing Frequency field - 30
33 character text.
78 PS_BI_HDR TEMPLATE_IVC_FLG Template Invoice Flag PS_OH_BILLNG_VW TEMPLATE_IVC_FLG Character 1 Template Invoice Flag Template Invoice Flag Flag indicator that invoice is a template invoice for recurring or
34 installment bills.
79 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_IVC_FLG_DESCR Character 30 Template Invoice Flag Description Template Invoice Flag Description Description of the value shown in the Template Invoice Flag field -
35 30 character text.
80 PS_BI_HDR TEMPLATE_INVOICE Template Invoice PS_OH_BILLNG_VW TEMPLATE_INVOICE Character 22 Template Invoice Template Invoice Identifier Invoice number of template invoice used for recurring or
36 installment bills.
81 PS_BI_HDR RECURRING_START_DT Recurring Start Date PS_OH_BILLNG_VW RECURRING_START_DT Date 10 Recurring Start Date Recurring Start Date Start Date for which the recurring bill schedule will generate an
37 invoice. (Default Format: yyyy-mm-dd)
82 PS_BI_HDR RECURRING_END_DT Recurring End Date PS_OH_BILLNG_VW RECURRING_END_DT Date 10 Recurring End Date Recurring End Date End Date for which the recurring bill schedule will generate an
38 invoice. (Default Format: yyyy-mm-dd)
83 PS_BI_HDR FROM_DT From Date PS_OH_BILLNG_VW FROM_DT Date 10 From Date Beginning Service Date Beginning Service Date for which the invoice is billed. (Default
39 Format: yyyy-mm-dd)
84 PS_BI_HDR TO_DT To Date PS_OH_BILLNG_VW TO_DT Date 10 To Date Ending Service Date Ending Service Date for which the invoice is billed. (Default
40 Format: yyyy-mm-dd)
85 PS_BI_HDR ADDRESS_SEQ_NUM Address Sequence Number PS_OH_BILLNG_VW ADDRESS_SEQ_NUM Numeric 38 Address Sequence Number Address Sequence Number Address Sequence Number of customer to which the invoice is
41 billed.
86 PS_BI_HDR BILL_TO_MEDIA Bill To Media PS_OH_BILLNG_VW BILL_TO_MEDIA Character 1 Bill To Media Bill To Media Indicates how invoices will be sent to the customer - print, fax, or
42 email.
87 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_BL_TO_MED_DESCR Character 30 Bill To Media Description Bill To Media Description Description of the value shown in the Bill To Media field - 30
43 character text.
88 PS_BI_HDR CNTCT_SEQ_NUM Contact Sequence Number PS_OH_BILLNG_VW CNTCT_SEQ_NUM Numeric 38 Contact Sequence Number Contact Sequence Number Contact sequence number of customer's contact at the indicated
44 customer address on the invoice.
45 89 PS_BI_HDR NAME1 Name 1 PS_OH_BILLNG_VW NAME1 Character 40 Name 1 Customer Contact Name Name of customer's contact at the indicated address.
90 PS_BI_HDR BILL_INQUIRY_PHONE Bill Inquiry Phone PS_OH_BILLNG_VW BILL_INQUIRY_PHONE Character 24 Bill Inquiry Phone Bill Inquiry Phone Phone number to which customers may call for invoice inquiries
46 or issues.
47 91 PS_BI_HDR BILLING_SPECIALIST Billing Specialist PS_OH_BILLNG_VW BILLING_SPECIALIST Character 8 Billing Specialist Billing Specialist Agency billing user that created the invoice.
92 PS_BI_HDR PYMNT_TERMS_CD Payment Terms Code PS_OH_BILLNG_VW PYMNT_TERMS_CD Character 5 Payment Terms Code Payment Terms Code Specifies how the payment due date is calculated based on the
48 invoice date.
93 PS_BI_HDR BANK_ACCT_KEY Bank Account Key PS_OH_BILLNG_VW BANK_ACCT_KEY Character 4 Bank Account Key Bank Account Key Unique identifier that indicates the remit to address displayed on
49 the billing invoice.
94 PS_BI_HDR PAID_AMT Paid Amount PS_OH_BILLNG_VW PAID_AMT Numeric 26,3 Paid Amount Paid Amount Amount already paid for the item charged on the billing invoice.
50
95 PS_BI_HDR FORWARD_BAL_AMT Forwarding Balance PS_OH_BILLNG_VW FORWARD_BAL_AMT Numeric 26,3 Forwarding Balance Forwarding Balance Remaining open balance of a previous invoice or receivable item
51 that is included in the billing invoice.
52 96 PS_BI_HDR INVOICE_AMOUNT Invoice Amount PS_OH_BILLNG_VW INVOICE_AMOUNT Numeric 26,3 Invoice Amount Invoice Amount Total invoice amount.
53 97 PS_BI_HDR INVOICE_DT Invoice Date PS_OH_BILLNG_VW OH_HDR_INV_DT Date 10 Invoice Date Invoice Header - Invoice Date Date of invoice. (Default Format: yyyy-mm-dd)
54 98 PS_BI_HDR DT_INVOICED Date Invoiced PS_OH_BILLNG_VW DT_INVOICED Date 10 Date Invoiced Date Invoiced Date invoice was created. (Default Format: yyyy-mm-dd)
99 PS_BI_HDR DUE_DT Due Date PS_OH_BILLNG_VW DUE_DT Date 10 Due Date Due Date Date on which payment for the invoice is due. (Default Format:
55 yyyy-mm-dd)
56 100 PS_BI_HDR IVC_PRINTED_FLG Invoice Printed Flag PS_OH_BILLNG_VW IVC_PRINTED_FLG Character 1 Invoice Printed Flag Invoice Printed Flag Flag indicates that the invoice was printed.
101 PS_BI_HDR IVC_PRINTED_DT Invoice Printed Date PS_OH_BILLNG_VW IVC_PRINTED_DT Date 10 Invoice Printed Date Invoice Print Date Date on which the invoice was printed. (Default Format: yyyy-
57 mm-dd)
102 PS_BI_HDR PRELOAD_IND Preload Indicator PS_OH_BILLNG_VW PRELOAD_IND Character 1 Preload Indicator Preload Indicator Flag indicates the status of the invoice with regard to the PreLoad
58 Process (BIPRELD). Values are 1, 2, 3.
7/15/20105:21 PM 29 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls
OAKS Operational Reporting Data Warehouse
FIN - Billing Reporting Data Dictionary: Billing
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
103 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_PLOAD_IND_DESCR Character 30 Preload Indicator Description Preload Indicator Description Description of the value shown in the Preload Indicator field - 30
character text. 1=Pending - Invoices ready to be processed;
2=Done - Invoices processed with no errors; 3=ComboEdit Error -
59 Invoices contain combo edit error
106 PS_BI_HDR AR_ENTRY_CREATED AR Entry Created PS_OH_BILLNG_VW AR_ENTRY_CREATED Character 1 AR Entry Created Accounts Receivable Entry Created Flag indicates that the invoice was created as a pending item in
Flag Accounts Receivable by the Load AR Pending Item process.
60
107 PS_BI_HDR GL_ENTRY_CREATED GL Entry Created PS_OH_BILLNG_VW GL_ENTRY_CREATED Character 1 GL Entry Created General Ledger Entry Created Flag Flag indicates that the accounting entries associated on the
invoice were created in General Ledger by the Load GL
61 Accounting Entries process.
108 PS_BI_HDR BILL_STATUS_TEXT Bill Status Text PS_OH_BILLNG_VW BILL_STATUS_TEXT Character 12 Bill Status Text Bill Status Text Text used to indicate invoice was created by the copy bill or group
62 of bills process.
109 PS_BI_HDR PO_REF PO Reference PS_OH_BILLNG_VW OH_HDR_PO_REF Character 30 PO Reference Invoice Header - Purchase Order Specifies the purchase order number associated with an invoice.
63 Reference
110 PS_BI_HDR ORDER_NO Order Number PS_OH_BILLNG_VW OH_HDR_ORDER_NO Character 10 Order Number Header Order Number Identifies a customer order number that appears as a reference on
64 the billing invoice header.
111 PS_BI_HDR ORDER_DATE Order Date PS_OH_BILLNG_VW OH_HDR_ORDER_DT Date 10 Order Date Header Order Date Date of customer order associated with billing invoice header.
65 (Default Format: yyyy-mm-dd)
112 PS_BI_HDR ERROR_STATUS_BI Error Status PS_OH_BILLNG_VW OH_HDR_ERROR Character 4 Error Status Bill Header Error Status Code indicator of type of error found on the bill header during the
66 Finalize and Print process.
113 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_HDR_ERR_DESCR Character 30 Error Status Description Bill Header Error Status Description Description of the value shown in the Bill Header Error Status
67 field - 30 character text.
68 114 PS_BI_HDR PAYMENT_METHOD Payment Method PS_OH_BILLNG_VW PAYMENT_METHOD Character 3 Payment Method Payment Method Projected payment method for billing invoice.
115 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_PAY_METH_DESCR Character 30 Payment Method Description Payment Method Description Description of the value shown in the Payment Method field - 30
69 character text.
70 116 PS_BI_HDR PAID_REFERENCE Pre-payment Reference PS_OH_BILLNG_VW PAID_REFERENCE Character 30 Pre-payment Reference Pre-payment Reference Identifier for pre-payment made for invoice.
117 PS_BI_HDR TOT_EXD_AMT Total Extended Amount PS_OH_BILLNG_VW TOT_EXD_AMT Numeric 26,3 Total Extended Amount Total Extended Invoice Amount Total invoice amount, after unit price and quantity are calculated
71 for all bill lines.
118 PS_BI_HDR REPRINT_GROUP_ID Reprint Group ID PS_OH_BILLNG_VW REPRINT_GROUP_ID Character 30 Reprint Group ID Reprint Group Identifier Group Identifier to indicate the group of bills that were reprinted.
72
73 119 PS_BI_HDR MAST_CONTR_ID Master Contract ID PS_OH_BILLNG_VW MAST_CONTR_ID Character 25 Master Contract ID Master Contract Number Master contract number associated with the billing invoice.
74 120 PS_BI_HDR SO_ID Service Order ID PS_OH_BILLNG_VW SO_ID Character 10 Service Order ID Service Order Identifier Service Order Identifier associated the billing invoice.
121 PS_BI_HDR USER_DT1 User Date1 PS_OH_BILLNG_VW OH_HDR_USR_DT1 Date 10 User Date1 Invoice Service Period From Date Service Period Beginning Date for invoice. Can be used to
represent service dates for ISTV transactions. (Default Format:
75 yyyy-mm-dd)
122 PS_BI_HDR USER_DT2 User Date2 PS_OH_BILLNG_VW OH_HDR_USR_DT2 Date 10 User Date2 Invoice Service Period To Date Service Period End Date for invoice. Can be used to represent
service dates for ISTV transactions. (Default Format: yyyy-mm-
76 dd)
123 PS_BI_HDR ADD_DTTM Date Time Added PS_OH_BILLNG_VW OH_HDR_AD_DTTM Date 10 Date Time Added Header Date Time Added Date and time stamp of when invoice was created. (Default
77 Format: yyyy-mm-dd)
124 PS_BI_HDR LAST_UPDATE_DTTM Last Update Date Time PS_OH_BILLNG_VW OH_HDR_UPDATE Date 10 Last Update Date Time Header Date Time Last Update Date and time stamp of when invoice was last modified prior to
78 finalizing and printing. (Default Format: yyyy-mm-dd)
125 PS_BI_HDR LAST_MAINT_OPRID Last Maintained By Operator ID PS_OH_BILLNG_VW OH_HDR_MAINT Character 30 Last Maintained By Operator ID Header Last Update User Identifier User Identifier of last person that modified the invoice prior to
79 finalizing and printing.
80 126 PS_BI_HDR_NOTE STD_NOTE_FLAG Standard Note Flag PS_OH_BILLNG_VW OH_HDR_NT_NT_FLG Character 1 Standard Note Flag Header Standard Note Flag Flag indicates note to be printed on invoice.
81 127 PS_BI_HDR_NOTE STD_NOTE_CD Standard Note Code PS_OH_BILLNG_VW OH_HDR_NT_NT_CD Character 10 Standard Note Code Header Standard Note Code Unique identifier for predefined note text used on bill header.
82 128 PS_BI_HDR_NOTE NOTE_TYPE Note Type PS_OH_BILLNG_VW OH_HDR_NT_NT_TYP Character 10 Note Type Header Note Type Unique identifier for type of note used on bill header.
129 PS_BI_HDR_NOTE INTERNAL_FLAG Internal Only Flag PS_OH_BILLNG_VW OH_HDR_NT_INT_FLG Character 1 Internal Only Flag Internal Only Flag Flag indicates note will be kept internal and will not print on the
83 invoice.
84 130 PS_BI_HDR_NOTE TEXT254 Text PS_OH_BILLNG_VW OH_HDR_NT_TEXT Character 254 Text Header Note Text Text for note on the bill header.
131 PS_BI_HDR_NOTE ADD_DTTM Date Time Added PS_OH_BILLNG_VW OH_HDR_NT_AD_DTTM Date 10 Date Time Added Header Note Date Time Added Date and time stamp of when note was added to the invoice
85 header. (Default Format: yyyy-mm-dd)
132 PS_BI_HDR_NOTE LAST_UPDATE_DTTM Last Update Date Time PS_OH_BILLNG_VW OH_HDR_NT_UPDATE Date 10 Last Update Date Time Header Note Date Time Last Update Date and time stamp of when note was last modified on the
header prior to finalizing and printing. (Default Format: yyyy-mm-
86 dd)
133 PS_BI_HDR_NOTE LAST_MAINT_OPRID Last Maintained By Operator ID PS_OH_BILLNG_VW OH_HDR_NT_MAINT Character 30 Last Maintained By Operator ID Header Note Last Update User User Identifier of last person that modified the header note prior to
87 Identifier finalizing and printing.
88 134 PS_BI_INSTALL_SCHE INSTALL_NBR Install Number PS_OH_BILLNG_VW INSTALL_NBR Numeric 38 Install Number Number of Installments Number of installments in the bill schedule.
89 135 PS_BI_INSTALL_SCHE INSTALLMENT_AMT Installment Amount PS_OH_BILLNG_VW INSTALLMENT_AMT Numeric 26,3 Installment Amount Installment Amount Amount of installment bill based on installment bill schedule.
136 PS_BI_INSTALL_SCHE EVENT_DT Event Date PS_OH_BILLNG_VW OH_INST_EVNT_DT Date 10 Event Date Install Event Date Generated date for each installment bill listed in the installment
90 bill schedule.
137 PS_BI_INSTALL_SCHE INVOICE_DT Invoice Date PS_OH_BILLNG_VW OH_INST_INV_DT Date 10 Invoice Date Install Invoice Date Invoice date on installment bill template. (Default Format: yyyy-
91 mm-dd)
138 PS_BI_INSTALL_SCHE BI_HDR_FROM_DT Header From Date PS_OH_BILLNG_VW OH_INST_HDR_FRM Date 10 Header From Date Install Header From Date Beginning Billing Date on installment bill header. (Default
92 Format: yyyy-mm-dd)
139 PS_BI_INSTALL_SCHE BI_HDR_TO_DT Header To Date PS_OH_BILLNG_VW OH_INST_HDR_TO Date 10 Header To Date Install Header To Date Ending Billing Date on installment bill header. (Default Format:
93 yyyy-mm-dd)
140 PS_BI_INSTALL_SCHE ACCOUNTING_DT Accounting Date PS_OH_BILLNG_VW OH_INST_ACCT_DT Date 10 Accounting Date Install Accounting Date Accounting date of installment bill transaction. (Default Format:
94 yyyy-mm-dd)
95 141 PS_BI_INSTALL_SCHE GENERATED_FLAG Generated Flag PS_OH_BILLNG_VW OH_INST_GEN_FLG Character 1 Generated Flag Install Generated Flag Flag indicates installment bill was generated by the system.
96 142 PS_BI_INSTALL_SCHE GENERATED_INVOICE Generated Invoice PS_OH_BILLNG_VW OH_INST_GEN_INV Character 22 Generated Invoice Install Invoice Identifier Invoice number of generated installment bill.
143 PS_BI_INSTALL_SCHE GENERATED_DATE Generated Date PS_OH_BILLNG_VW OH_INST_GEN_DT Date 10 Generated Date Install Generated Date Invoice date of generated installment bill. (Default Format: yyyy-
97 mm-dd)
144 PS_BI_INSTALL_SCHE CPY_STATUS Copy Status PS_OH_BILLNG_VW OH_INST_CPY_STAT Character 3 Copy Status Install Copy Status Status of copying installment bill, used by copy bill or group of
98 bills process.
145 PS_BI_INSTALL_SCHE PRIOR_CPY_INVOICE Prior Copy Invoice PS_OH_BILLNG_VW OH_INST_PRI_C_INV Character 22 Prior Copy Invoice Invoice Line - Install Prior Invoice Invoice number of originally copied installment bill.
99 Identifier
146 PS_BI_INSTALL_SCHE ADD_DTTM Date Time Added PS_OH_BILLNG_VW OH_INST_AD_DTTM Date 10 Date Time Added Install Date Time Added Date and time stamp of when installment bill schedule was
100 created. (Default Format: yyyy-mm-dd)
147 PS_BI_INSTALL_SCHE LAST_UPDATE_DTTM Last Update Date Time PS_OH_BILLNG_VW OH_INST_UPDATE Date 10 Last Update Date Time Install Last Update Date Time Date and time stamp of when installment bill schedule was last
101 modified. (Default Format: yyyy-mm-dd)
148 PS_BI_INSTALL_SCHE LAST_MAINT_OPRID Last Maintained By Operator ID PS_OH_BILLNG_VW OH_INST_MAINT Character 30 Last Maintained By Operator ID Install Last Update User Identifier User ID of last person that modified the installment bill schedule.
102
103 149 PS_BI_LINE INVOICE_LINE Invoice Line PS_OH_BILLNG_VW INVOICE_LINE Numeric 38 Invoice Line Invoice Line Invoice line number of bill line.
150 PS_BI_LINE ORIGINAL_INVOICE Original Invoice PS_OH_BILLNG_VW OH_LN_ORIG_INV Character 22 Original Invoice Line Original Invoice Identifier Original invoice number from which adjustment invoices were
104 created.
151 PS_BI_LINE ORIGINAL_LINE_SEQ Original Line Sequence PS_OH_BILLNG_VW ORIGINAL_LINE_SEQ Numeric 38 Original Line Sequence Original Invoice Line Sequence Original invoice line sequence number from which adjustment
105 Number invoices were created.
152 PS_BI_LINE NEXT_ADJ_INVOICE Next Adjusted Invoice PS_OH_BILLNG_VW OH_LN_NEXT_INV Character 22 Next Adjusted Invoice Invoice Line - Adjusted Next Invoice Invoice number of next subsequently adjusted invoice.
106 Identifier
153 PS_BI_LINE NEXT_ADJ_LINE_SEQ Next Adjusted Line Sequence PS_OH_BILLNG_VW NEXT_ADJ_LINE_SEQ Numeric 38 Next Adjusted Line Sequence Adjusted Next Invoice Line Sequence Invoice line sequence number of next subsequently adjusted
107 Number invoice.
154 PS_BI_LINE PRIOR_ADJ_INVOICE Prior Adjusted Invoice PS_OH_BILLNG_VW OH_LN_PRI_A_INV Character 22 Prior Adjusted Invoice Invoice Line - Adjusted Prior Invoice Invoice number of previously adjusted invoice.
108 Identifier
155 PS_BI_LINE PRIOR_ADJ_LINE_SEQ Prior Adjusted Line Sequence PS_OH_BILLNG_VW PRIOR_ADJ_LINE_SEQ Numeric 38 Prior Adjusted Line Sequence Adjusted Prior Invoice Line Sequence Invoice line sequence number of previously adjusted invoice.
109 Number
110 156 PS_BI_LINE LATEST_INVOICE Latest Invoice PS_OH_BILLNG_VW OH_LN_LATE_INV Character 22 Latest Invoice Adjusted Latest Invoice Identifier Invoice number of last adjustment made from original invoice.
7/15/20105:21 PM 30 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls
OAKS Operational Reporting Data Warehouse
FIN - Billing Reporting Data Dictionary: Billing
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
157 PS_BI_LINE LATEST_LINE_SEQ Latest Line Sequence PS_OH_BILLNG_VW LATEST_LINE_SEQ Numeric 38 Latest Line Sequence Adjusted Latest Invoice Line Invoice line sequence number of last adjustment made from
111 Sequence Number original invoice.
112 158 PS_BI_LINE ADJ_LINE_TYPE Adjusted Line Type PS_OH_BILLNG_VW ADJ_LINE_TYPE Character 3 Adjusted Line Type Adjusted Line Type Type of adjustment made on bill line.
159 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_LN_TYP_DESCR Character 30 Adjusted Line Type Description Adjusted Line Type Description Description of the value shown in the Adjusted Line Type field -
113 30 character text.
114 160 PS_BI_LINE ADJUSTED_FLAG Adjusted Flag PS_OH_BILLNG_VW OH_LN_ADJ_FLG Character 1 Adjusted Flag Invoice Line - Adjusted Flag Flag indicates bill line was adjusted.
161 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_LN_FLG_DESCR Character 30 Adjusted Flag Description Invoice Line - Adjusted Flag Description of the value shown in the Invoice Line - Adjusted Flag
115 Description field - 30 character text.
162 PS_BI_LINE CHARGE_FROM_DT From Date for line charges PS_OH_BILLNG_VW CHARGE_FROM_DT Date 10 From Date for line charges Line Charge From Date Beginning Billing Date for bill line charge item. (Default Format:
116 yyyy-mm-dd)
163 PS_BI_LINE CHARGE_TO_DT Through date for charges PS_OH_BILLNG_VW CHARGE_TO_DT Date 10 Through date for charges Line Charge To Date Ending Billing Date for bill line charge item. (Default Format:
117 yyyy-mm-dd)
118 164 PS_BI_LINE IDENTIFIER Identifier PS_OH_BILLNG_VW IDENTIFIER Character 18 Identifier Charge Code Identifier Unique charge code identifier for item on bill line.
119 165 PS_BI_LINE DESCR Description PS_OH_BILLNG_VW DESCR Character 30 Description Charge Item Description Description of charge item on bill line.
120 166 PS_BI_LINE UNIT_OF_MEASURE Used on an approval rule set. PS_OH_BILLNG_VW UNIT_OF_MEASURE Character 3 Used on an approval rule set. Unit of Measure Unit of measure for charge item on bill line.
121 167 PS_BI_LINE QTY Quantity PS_OH_BILLNG_VW QTY Numeric 15,4 Quantity Charge Item Quantity Quantity of charge item on bill line.
168 PS_BI_LINE ORIG_QTY Original Quantity PS_OH_BILLNG_VW ORIG_QTY Numeric 15,4 Original Quantity Original Quantity Original Quantity of charge item on bill line, prior to bill
122 adjustment.
123 169 PS_BI_LINE UNIT_AMT Unit Price PS_OH_BILLNG_VW UNIT_AMT Numeric 15,4 Unit Price Unit Price Unit price of charge item on bill line.
124 170 PS_BI_LINE PRICE_RECALC_FLG Recalculate Price PS_OH_BILLNG_VW PRICE_RECALC_FLG Character 1 Recalculate Price Recalculate Price Flag Flag indicates price was re-calculated on bill line.
125 171 PS_BI_LINE GROSS_EXTENDED_AMT Gross Extended PS_OH_BILLNG_VW GROSS_EXTENDED_AMT Numeric 26,3 Gross Extended Gross Extended Amount Total bill line amount prior to tax.
126 172 PS_BI_LINE NET_EXTENDED_AMT Net Extended Amt PS_OH_BILLNG_VW NET_EXTENDED_AMT Numeric 26,3 Net Extended Amt Net Extended Amount Total bill line amount after tax.
173 PS_BI_LINE ORIG_AMOUNT Origninal Amount PS_OH_BILLNG_VW ORIG_AMOUNT Numeric 26,3 Origninal Amount Original Amount Original total bill line amount, prior to adjustment on adjustment
127 invoice.
128 174 PS_BI_LINE TOT_LINE_DST_AMT Total Line Distribution Amount PS_OH_BILLNG_VW TOT_LINE_DST_AMT Numeric 26,3 Total Line Distribution Amount Total Line Distribution Amount Total bill line amount distributed from total invoice amount.
129 175 PS_BI_LINE LAST_NOTE_SEQ_NUM Last note sequence number PS_OH_BILLNG_VW LAST_NOTE_SEQ_NUM Numeric 38 Last note sequence number Line Last Note Sequence Number Last note sequence number associated with bill line.
104 PS_BI_LINE ENTRY_TYPE Entry Type PS_OH_BILLNG_VW ENTRY_TYPE Character 5 Entry Type Entry Type Specifies the type of transaction associated with an invoice. The
values are the same as in Accounts Receivable. The entry type
remains with the invoice after it is posted in Accounts Receivable.
130
105 PS_BI_LINE ENTRY_REASON Entry Reason PS_OH_BILLNG_VW ENTRY_REASON Character 5 Entry Reason Entry Reason Specifies an entry reason that further explains the entry type
associated with an invoice. The values are the same as in
131 Accounts Receivable.
176 PS_BI_LINE PO_REF PO Reference PS_OH_BILLNG_VW OH_LN_PO_REF Character 30 PO Reference Invoice Line - Purchase Order Specifies the purchase order number associated with the invoice.
132 Reference
177 PS_BI_LINE PO_LINE PO Line PS_OH_BILLNG_VW PO_LINE Numeric 38 PO Line Purchase Order Line Specifies the lines number of a purchase order number
133 associated with the invoice.
134 178 PS_BI_LINE CONTRACT_NUM Contract Number PS_OH_BILLNG_VW OH_LN_CNT_NO Character 25 Contract Number Invoice Line - Contract Number Specifies contract number associated with the invoice.
179 PS_BI_LINE CONTRACT_DT Contract Date PS_OH_BILLNG_VW CONTRACT_DT Date 10 Contract Date Contract Date Specifies contract date for contract number associated with the
135 invoice. (Default Format: yyyy-mm-dd)
180 PS_BI_LINE CONTRACT_TYPE Contract Type PS_OH_BILLNG_VW CONTRACT_TYPE Character 15 Contract Type Contract Type Specifies type of contract for contract number associated with the
136 invoice.
181 PS_BI_LINE ORDER_NO Order Number PS_OH_BILLNG_VW OH_LN_ORDER_NO Character 10 Order Number Line Order Number Identifies a customer order number that appears as a reference on
137 the billing invoice line.
182 PS_BI_LINE ORDER_DATE Order Date PS_OH_BILLNG_VW OH_LN_ORDER_DT Date 10 Order Date Line Order Date Date of customer order associated with billing invoice line.
138 (Default Format: yyyy-mm-dd)
183 PS_BI_LINE ERROR_STATUS_BI Error Status PS_OH_BILLNG_VW OH_LN_ERROR Character 4 Error Status Bill Line Error Status Code indicator of type of error found on the bill header during the
139 Finalize and Print process.
184 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_BILLNG_VW OH_LN_ERR_DESCR Character 30 Error Status Description Bill Line Error Status Description Description of the value shown in the Bill Line Error Status field -
140 30 character text.
185 PS_BI_LINE CONTRACT_LINE_NUM Contract Line Number PS_OH_BILLNG_VW CONTRACT_LINE_NUM Numeric 38 Contract Line Number Contract Line Number Specifies contract line number for contract number associated
141 with the invoice.
186 PS_BI_LINE BUSINESS_UNIT_AMTO Asset Business Unit To PS_OH_BILLNG_VW BUSINESS_UNIT_AMTO Character 5 Asset Business Unit To Asset Business Unit Agency Asset Management Business Unit associated with billing
142 invoice.
143 187 PS_BI_LINE ASSET_ID Asset Identification PS_OH_BILLNG_VW ASSET_ID Character 12 Asset Identification Asset Identification Asset Identifier associated with billing invoice.
144 188 PS_BI_LINE PROFILE_ID Asset Profile ID PS_OH_BILLNG_VW PROFILE_ID Character 10 Asset Profile ID Asset Profile Identifier Asset profile associated with billing invoice.
145 189 PS_BI_LINE COST_TYPE Cost Type PS_OH_BILLNG_VW COST_TYPE Character 1 Cost Type Asset Cost Type Asset cost type associated with billing invoice.
190 PS_BI_LINE USER_DT1 User Date1 PS_OH_BILLNG_VW OH_LN_USR_DT1 Date 10 User Date1 Invoice Line Service Period From Service Period Beginning Date for invoice line. Can be used to
Date represent service dates for ISTV transactions. (Default Format:
146 yyyy-mm-dd)
191 PS_BI_LINE USER_DT2 User Date2 PS_OH_BILLNG_VW OH_LN_USR_DT2 Date 10 User Date2 Invoice Line Service Period To Date Service Period End Date for invoice line. Can be used to
represent service dates for ISTV transactions. (Default Format:
147 yyyy-mm-dd)
192 PS_BI_LINE ADD_DTTM Date Time Added PS_OH_BILLNG_VW OH_LN_AD_DTTM Date 10 Date Time Added Line Date Time Added Date and time stamp of when invoice was created. (Default
148 Format: yyyy-mm-dd)
193 PS_BI_LINE LAST_UPDATE_DTTM Last Update Date Time PS_OH_BILLNG_VW OH_LN_UPDATE Date 10 Last Update Date Time Line Last Update Date Time Date and time stamp of when invoice was last modified prior to
149 finalizing and printing. (Default Format: yyyy-mm-dd)
194 PS_BI_LINE LAST_MAINT_OPRID Last Maintained By Operator ID PS_OH_BILLNG_VW OH_LN_MAINT Character 30 Last Maintained By Operator ID Line Last Update User Identifier User Identifier of last person that modified the invoice prior to
150 finalizing and printing.
195 PS_BI_LINE_DST PERCENTAGE Percentage PS_OH_BILLNG_VW PERCENTAGE Numeric 5,2 Percentage Percentage Percent of total invoice amount on accounting distribution line for
151 specific bill line.
152 196 PS_BI_LINE_DST AMOUNT Amount PS_OH_BILLNG_VW AMOUNT Numeric 26,3 Amount Amount Amount on accounting distribution line for specific bill line.
197 PS_BI_LINE_DST DST_ID Distribution Code PS_OH_BILLNG_VW DST_ID Character 10 Distribution Code Distribution Code Unique distribution code identifies accounting distribution
153 chartfield values for specific bill line.
198 PS_BI_LINE_DST LAST_UPDATE_DTTM Last Update Date Time PS_OH_BILLNG_VW OH_LN_DST_UPDATE Date 10 Last Update Date Time Distribution Last Update Date Time Date and time stamp of when bill line accounting distribution line
was last modified prior to finalizing and printing. (Default Format:
154 yyyy-mm-dd)
199 PS_BI_LINE_DST LAST_MAINT_OPRID Last Maintained By Operator ID PS_OH_BILLNG_VW OH_LN_DST_MAINT Character 30 Last Maintained By Operator ID Distribution Last Update User User Identifier of last person that modified the bill line accounting
155 Identifier distribution line prior to finalizing and printing.
156 200 PS_BI_LINE_NOTE STD_NOTE_FLAG Standard Note Flag PS_OH_BILLNG_VW OH_LN_NT_NT_FLG Character 1 Standard Note Flag Line Standard Note Flag Flag indicates note to be printed on invoice.
157 201 PS_BI_LINE_NOTE NOTE_TYPE Note Type PS_OH_BILLNG_VW OH_LN_NT_NT_TYP Character 10 Note Type Line Note Type Unique identifier for type of note used on bill line.
202 PS_BI_LINE_NOTE INTERNAL_FLAG Internal Only Flag PS_OH_BILLNG_VW OH_LN_NT_INT_FLG Character 1 Internal Only Flag Internal Note Flag Flag indicates note will be kept internal and will not print on the
158 invoice.
159 203 PS_BI_LINE_NOTE TEXT254 Text PS_OH_BILLNG_VW OH_LN_NT_TEXT Character 254 Text Line Note Text Text for note on the bill line.
160 204 PS_BI_LINE_NOTE STD_NOTE_CD Standard Note Code PS_OH_BILLNG_VW OH_LN_NT_NT_CD Character 10 Standard Note Code Line Standard Note Code Unique identifier for predefined note text used on bill line.
205 PS_BI_LINE_NOTE ADD_DTTM Date Time Added PS_OH_BILLNG_VW OH_LN_NT_AD_DTTM Date 10 Date Time Added Line Note Date Time Added Date and time stamp of when note was added to the bill line.
161 (Default Format: yyyy-mm-dd)
206 PS_BI_LINE_NOTE LAST_UPDATE_DTTM Last Update Date Time PS_OH_BILLNG_VW OH_LN_NT_UPDATE Date 10 Last Update Date Time Line Note Last Update Date Time Date and time stamp of when note was last modified on the bill
line prior to finalizing and printing. (Default Format: yyyy-mm-dd)
162
207 PS_BI_LINE_NOTE LAST_MAINT_OPRID Last Maintained By Operator ID PS_OH_BILLNG_VW OH_LN_NT_MAINT Character 30 Last Maintained By Operator ID Line Note Last Update User Identifier User ID of last person that modified the bill line note prior to
163 finalizing and printing.
208 PS_BI_SCHEDULE EVENT_DT Event Date PS_OH_BILLNG_VW OH_SCHED_EVNT_DT Date 10 Event Date Schedule - Event Date Generated date for each recurring bill listed in the recurring bill
164 schedule.
209 PS_BI_SCHEDULE INVOICE_DT Invoice Date PS_OH_BILLNG_VW OH_SCHED_INV_DT Date 10 Invoice Date Schedule - Invoice Date Invoice date on recurring bill template. (Default Format: yyyy-mm-
165 dd)
210 PS_BI_SCHEDULE BI_HDR_FROM_DT Header From Date PS_OH_BILLNG_VW OH_SCHED_HDR_FRM Date 10 Header From Date Recurrence Header From Date Beginning Billing Date on recurring bill header. (Default Format:
166 yyyy-mm-dd)
7/15/20105:21 PM 31 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls
OAKS Operational Reporting Data Warehouse
FIN - Billing Reporting Data Dictionary: Billing
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
211 PS_BI_SCHEDULE BI_HDR_TO_DT Header To Date PS_OH_BILLNG_VW OH_SCHED_HDR_TO Date 10 Header To Date Recurrence Header To Date Ending Billing Date on recurring bill header. (Default Format:
167 yyyy-mm-dd)
168 212 PS_BI_SCHEDULE GENERATED_FLAG Generated Flag PS_OH_BILLNG_VW OH_SCHED_GEN_FLG Character 1 Generated Flag Recurrence Generated Flag Flag indicates recurring bill was generated by the system.
169 213 PS_BI_SCHEDULE GENERATED_INVOICE Generated Invoice PS_OH_BILLNG_VW OH_SCHED_GEN_INV Character 22 Generated Invoice Recurrence Invoice Identifier Invoice number of generated recurring bill.
214 PS_BI_SCHEDULE GENERATED_DATE Generated Date PS_OH_BILLNG_VW OH_SCHED_GEN_DT Date 10 Generated Date Recurrence Invoice Date Invoice date of generated recurring bill. (Default Format: yyyy-
170 mm-dd)
215 PS_BI_SCHEDULE CPY_STATUS Copy Status PS_OH_BILLNG_VW OH_SCHED_CPY_STAT Character 3 Copy Status Recurrence Copy Status Status of copying recurring bill, used by copy bill or group of bills
171 process.
172 216 PS_BI_SCHEDULE PRIOR_CPY_INVOICE Prior Copy Invoice PS_OH_BILLNG_VW OH_SCHED_PRI_C_INV Character 22 Prior Copy Invoice Recurrence Prior Invoice Identifier Invoice number of originally copied recurring bill.
217 PS_BI_SCHEDULE AUTO_GEN_LN_DT Auto Generated Line Date PS_OH_BILLNG_VW AUTO_GEN_LN_DT Date 10 Auto Generated Line Date Recurrence Auto Generate Date Flag indicates system will use dates defined on the header on bill
173 lines for recurring bills, such as From/To Dates.
218 PS_BI_SCHEDULE ADD_DTTM Date Time Added PS_OH_BILLNG_VW OH_SCHED_AD_DTTM Date 10 Date Time Added Recurrence Date Time Added Date and time stamp of when recurring bill schedule was created.
174 (Default Format: yyyy-mm-dd)
219 PS_BI_SCHEDULE LAST_UPDATE_DTTM Last Update Date Time PS_OH_BILLNG_VW OH_SCHED_UPDATE Date 10 Last Update Date Time Recurrence Last Update Date Time Date and time stamp of when recurring bill schedule was last
175 modified. (Default Format: yyyy-mm-dd)
220 PS_BI_SCHEDULE LAST_MAINT_OPRID Last Maintained By Operator ID PS_OH_BILLNG_VW OH_SCHED_MAINT Character 30 Last Maintained By Operator ID Recurrence Last Update User User ID of last person that modified the recurring bill schedule.
176 Identifier
177
178
7/15/20105:21 PM 32 of 150
OAKS Operational Reporting Data Warehouse
FIN - General Ledger Journal Transaction Reporting Data Dictionary: Journal Transaction
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
1 PS_JRNL_HEADER BUSINESS_UNIT General Ledger Business Unit from Journal. PS_OH_JRNL_TRN_VW BUSINESS_UNIT Character 5 General Ledger Business Unit from Y OAKS Journal Transaction The Journal Transaction Business Unit General Ledger Business Unit. The Business Unit represents an
Journal. Reporting Table Reporting Table holds information agency or sub-set of an agency that is independent with regard
4 about the business unit, ledger, to one or more operational or accounting functions.
2 PS_JRNL_HEADER JOURNAL_ID Identifies a journal entry, consisting of a PS_OH_JRNL_TRN_VW JOURNAL_ID Character 10 Identifies a journal entry, consisting of Y journal ID, journal date, line Journal Identifier Journal Identifier is an alphanumeric identifier which together
header and one or more lines. The Journal a header and one or more lines. The description, who entered the with the journal business unit and journal date forms a unique
ID itself does not have to be unique, but Journal ID itself does not have to be journal, the source of the identifier for the PeopleSoft journals.
together with the journal business unit and unique, but together with the journal transaction (Accounts Payable,
journal date, it forms a unique journal business unit and journal date, it Accounts Receivable, Human
identifier. forms a unique journal identifier. Resources, etc.) and the
5 chartField distributions. The
3 PS_JRNL_HEADER JOURNAL_DATE Specifies the date the journal was created. PS_OH_JRNL_TRN_VW JOURNAL_DATE Date 10 Specifies the date the journal was Y various tables are pulled into one Journal Date The date the journal was created. This determines to which
created. easy-to-use reporting table. period the system posts the journals, unless it is an adjusting
entry. This date is defaulted to the current day's date, but a
journal can be back dated or future dated within an open period.
6
4 PS_JRNL_HEADER UNPOST_SEQ Identifies the sequence of journal entries PS_OH_JRNL_TRN_VW UNPOST_SEQ Number 2 Identifies the sequence of journal Y Unpost Sequence Number When a journal is unposted, a new reversing entry is
when a journal is "unposted". When a entries when a journal is "unposted". automatically created with an Unpost Sequence of "1".
journal is posted the UnPost Sequence is When a journal is posted the UnPost
automatically set to "0". When a journal is Sequence is automatically set to "0".
unposted, a new reversing entry is When a journal is unposted, a new
automatically created with an UnPost reversing entry is automatically
Sequence of "1". created with an UnPost Sequence of
7 "1".
5 PS_JRNL_LN LEDGER Ledger PS_OH_JRNL_TRN_VW LEDGER Character 10 Ledger Y Ledger A ledger consists of posted balances that represents a set of
books for a business unit. Ledgers store the posted net activity
for a set of ChartField values by accounting period and by fiscal
year. Ledgers are maintained primarily through journal entries.
8
6 PS_JRNL_LN JOURNAL_LINE General Ledger Journal Line Number PS_OH_JRNL_TRN_VW JOURNAL_LINE Number 9 General Ledger Journal Line Number Y General Ledger Journal Line Refers to each accounting line entered in PeopleSoft General
Number Ledger Create Journal Entries consisting of appropriate
9 ChartField and accounting values.
10
7 PS_JRNL_HEADER BUSINESS_UNIT_IU Specifies the Business Unit for which PS_OH_JRNL_TRN_VW BUSINESS_UNIT_IU Character 5 Specifies the Business Unit for which Business Unit InterUnit Specifies the Business Unit (STATE) for which InterUnit activity
InterUnit activity is being generated. InterUnit activity is being generated. is being generated.
11
8 PS_JRNL_HEADER ADJUSTING_ENTRY Adjusting Entry PS_OH_JRNL_TRN_VW ADJUSTING_ENTRY Character 1 Adjusting Entry Adjusting Entry Select Adjusting Entry from the drop down list if this is an
adjusting entry. The journal entry posts to the displayed
adjustment fiscal year and period. If this is not an adjusting
entry, you cannot change the accounting period value. The
journal date determines the accounting period to which the entry
12 posts.
9 PS_JRNL_HEADER FISCAL_YEAR Fiscal Year PS_OH_JRNL_TRN_VW FISCAL_YEAR Number 4 Fiscal Year Fiscal Year Fiscal Year. Displays the year based on the beginning date of
13 the period. You can change this year.
10 PS_JRNL_HEADER ACCOUNTING_PERIOD Identifies a time period to which you post PS_OH_JRNL_TRN_VW ACCOUNTING_PERIOD Number 3 Identifies a time period to which you Accounting Period Identifies a time period to which you post transactions. An
transactions. Typically, an accounting period post transactions. Typically, an accounting period has a beginning date and an ending date,
represents a month, but it can also represent accounting period represents a month, and is defined in the calendar table.
a week, a day, or any user-defined interval. but it can also represent a week, a
An accounting period has a beginning date day, or any user-defined interval. An
and an ending date, and is defined in the accounting period has a beginning
calendar table. date and an ending date, and is
14 defined in the calendar table.
11 PS_JRNL_HEADER ADB_DATE Specifies the daily date to use when Average PS_OH_JRNL_TRN_VW ADB_DATE Date 10 Specifies the daily date to use when Average Daily Balance Date Specifies the daily date to use when Average Daily Balancing is
Daily Balancing is activated. The date is Average Daily Balancing is activated. activated. The date is determined by the daily calendar
determined by the daily calendar associated The date is determined by the daily associated with the General Ledger Business Unit to which the
with the General Ledger Business Unit to calendar associated with the General journal is posted. When Average Daily Balance processing is
which the journal is posted. When ADB Ledger Business Unit to which the not activated, the Average Daily Balance Date defaults to the
processing is not activated, the ADB_Date journal is posted. When ADB date on the Journal Header (JOURNAL_DATE).
defaults to the date on the Journal Header processing is not activated, the
(JOURNAL_DATE). ADB_Date defaults to the date on the
Journal Header (JOURNAL_DATE).
15
12 PS_JRNL_HEADER LEDGER_GROUP Ledger Group PS_OH_JRNL_TRN_VW LEDGER_GROUP Character 10 Ledger Group Ledger Group A ledger group can have one primary ledger and zero to nine
secondary ledgers. PeopleSoft General Ledger posts to the
ledgers within the group according to the rules that you
16 establish
13 PS_JRNL_HEADER REVERSAL_CD A flag that indicates if a journal entry should PS_OH_JRNL_TRN_VW REVERSAL_CD Character 1 A flag that indicates if a journal entry Reversal Code A flag that indicates if a journal entry should be automatically
be automatically reversed, and if so, with should be automatically reversed, and reversed, and if so, with what date. When associated with a
what date. When associated with a reversal if so, with what date. When associated reversal entry, it indicates that the entry was created
entry, it indicates that the entry was created with a reversal entry, it indicates that automatically by the reversal process.
automatically by the reversal process. the entry was created automatically by
the reversal process.
17
14 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_JRNL_TRN_VW OH_RVRSL_CD_DESCR Character 30 Reversal Code Description Reversal Code Description A flag that indicates if a journal entry should be automatically
18 reversed, and if so, with what date – gives the Xlat value.
15 PS_JRNL_HEADER REVERSAL_DATE Specifies the date for an automatic reversal PS_OH_JRNL_TRN_VW REVERSAL_DATE Date 10 Specifies the date for an automatic Reversal Date Specifies the date for an automatic reversal journal entry. The
journal entry. The date must be within the reversal journal entry. The date must date must be within the calendar of the target (posting) ledger.
calendar of the target (posting) ledger. be within the calendar of the target PeopleSoft General Ledger automatically creates and populates
PeopleSoft General Ledger automatically (posting) ledger. PeopleSoft General a journal entry with this date. The Reversal Date is used to
creates and populates a journal entry with Ledger automatically creates and populate the journal date and fiscal year of the reversing entry.
this date. populates a journal entry with this If you specify a reversal date that is before the journal date or a
date. date on a nonworking day and there is a Holiday List ID
assigned to the business unit, you will receive an error
message. The system will not reset the reversal date, and you
must re-enter a date that is after the journal date and is a
19 working day.
16 PS_JRNL_HEADER REVERSAL_ADJ_PER Adjustment Period PS_OH_JRNL_TRN_VW REVERSAL_ADJ_PER Number 3 Adjustment Period Reversal Adjustment Period Enables you to select the reversal adjustment period for which
20 the new journal is to be created.
17 PS_JRNL_HEADER REVERSAL_CD_ADB Average Daily Balance Reversal Code PS_OH_JRNL_TRN_VW REVERSAL_CD_ADB Character 1 Average Daily Balance Reversal Code Reversal Code for Average Daily Average Daily Balance Reversal Code. Average Daily Balance
21 Balance determines which calculation method the system uses.
18 PS_JRNL_HEADER REVERSAL_DATE_ADB Average Daily Balance Reversal Date PS_OH_JRNL_TRN_VW REVERSAL_DATE_ADB Date 10 Average Daily Balance Reversal Date Reversal Date for Average Daily If you enter a date on a non-working day, and there is a holiday
Balance list ID assigned to the business unit, you'll receive an error
message. The system won't reset the Average Daily Balance
reversal date for you; you must re-enter a date that is a working
day. If you specify an Average Daily Balance reversal date that
is on or before the Average Daily Balance date, you will receive
22 an error message.
23 19 PS_JRNL_HEADER UNPOST_JRNL_DATE Unposted Journal Date PS_OH_JRNL_TRN_VW UNPOST_JRNL_DATE Date 10 Unposted Journal Date Unpost Journal Date Unpost Date. The date you enter in the Unpost Date field
20 PS_JRNL_HEADER JRNL_TOTAL_LINES Represents a running total of the number of PS_OH_JRNL_TRN_VW JRNL_TOTAL_LINES Number 9 Represents a running total of the Total Journal Lines in a Journal Represents a running total of the number of lines in a journal
lines in a journal entry. It is maintained by number of lines in a journal entry. It is Entry entry. It is maintained by PeopleSoft General Ledger as lines
PeopleSoft General Ledger as lines are maintained by PeopleSoft General are entered.
24 entered. Ledger as lines are entered.
21 PS_JRNL_HEADER JRNL_TOTAL_DEBITS Represents a running total of the debit PS_OH_JRNL_TRN_VW JRNL_TOTAL_DEBITS Signed Number 23.3 Represents a running total of the debit Total Journal Debits in a Journal Represents a running total of the debit amounts in a journal
amounts in a journal entry. It is maintained amounts in a journal entry. It is Entry entry. It is maintained by PeopleSoft General Ledger as lines
by PeopleSoft General Ledger as lines are maintained by PeopleSoft General are entered.
25 entered. Ledger as lines are entered.
7/15/20105:21 PM 33 of 150
OAKS Operational Reporting Data Warehouse
FIN - General Ledger Journal Transaction Reporting Data Dictionary: Journal Transaction
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
22 PS_JRNL_HEADER JRNL_TOT_CREDITS Represents a running total of the credit PS_OH_JRNL_TRN_VW JRNL_TOT_CREDITS Signed Number 24.3 Represents a running total of the Total Journal Credits in a Journal Represents a running total of the credit amounts in a journal
amounts in a journal entry. It is maintained credit amounts in a journal entry. It is Entry entry. It is maintained by PeopleSoft General Ledger as lines
by PeopleSoft General Ledger as lines are maintained by PeopleSoft General are entered.
26 entered. Ledger as lines are entered.
23 PS_JRNL_HEADER JRNL_NET_UNITS Represents a running total of the statistical PS_OH_JRNL_TRN_VW JRNL_NET_UNITS Signed Number 13.2 Represents a running total of the Net Statistical Units for a Journal Represents a running total of the statistical units in a journal
units in a journal entry. It is a hash total statistical units in a journal entry. It is Entry entry. It is a hash total since there may be different types of
since there may be different types of units of a hash total since there may be units of measure reflected in a single journal. It is maintained by
measure reflected in a single journal. It is different types of units of measure PeopleSoft General Ledger as lines are entered.
maintained by PeopleSoft General Ledger as reflected in a single journal. It is
lines are entered. maintained by PeopleSoft General
27 Ledger as lines are entered.
24 PS_JRNL_HEADER SOURCE Identifies the origin of a journal entry and PS_OH_JRNL_TRN_VW SOURCE Character 3 Identifies the origin of a journal entry Source or Origin of a Journal Identifies the origin of a journal entry and defines journal entry
defines journal entry error handling options. and defines journal entry error Entry error handling options. The journal source provides a means of
The journal source provides a means of handling options. The journal source selectively tracking, reporting, and inquiring on journal entries.
selectively tracking, reporting, and inquiring provides a means of selectively It can be almost anything within the enterprise - a subsystem
on journal entries. It can be almost anything tracking, reporting, and inquiring on that generates transactions, a department, or even an
within the enterprise - a subsystem that journal entries. It can be almost individual.
generates transactions, a department, or anything within the enterprise - a
even an individual. subsystem that generates
transactions, a department, or even
28 an individual.
25 PS_SOURCE_TBL DESCR Journal Source Description is free flow text PS_OH_JRNL_TRN_VW OH_SOURCE_DESCR Character 30 Journal Source Description is free flow Journal Source Description Journal Source Description is free flow text up to 30 characters.
29 up to 30 characters. text up to 30 characters.
26 PS_JRNL_HEADER TRANS_REF_NUM Identifies a document, person, invoice, date, PS_OH_JRNL_TRN_VW TRANS_REF_NUM Character 8 Identifies a document, person, invoice, Transfer Reference Number for a Identifies a document, person, invoice, date, or any other piece
or any other piece of information that is date, or any other piece of information Journal Entry of information that is associated with a journal entry. The
associated with a journal entry. The journal that is associated with a journal entry. journal reference is helpful if you need to trace back to the
reference is helpful if you need to trace back The journal reference is helpful if you source of the transaction.
to the source of the transaction. need to trace back to the source of the
30 transaction.
27 PS_JRNL_HEADER JRNL_BALANCE_STAT A flag that indicates whether or not a journal PS_OH_JRNL_TRN_VW JRNL_BALANCE_STAT Character 1 A flag that indicates whether or not a Journal Balance Statistic A flag that indicates whether or not a journal is in balance. A
is in balance. A balanced journal is one in journal is in balance. A balanced balanced journal is one in which the debit and credit lines net to
which the debit and credit lines net to zero. journal is one in which the debit and zero. This field is maintained by the journal edit program of
This field is maintained by the journal edit credit lines net to zero. This field is PeopleSoft General Ledger.
program of PeopleSoft General Ledger. maintained by the journal edit
program of PeopleSoft General
31 Ledger.
28 PS_JRNL_HEADER CONTROL_TOTAL_STAT A flag that indicates whether or not the PS_OH_JRNL_TRN_VW CONTROL_TOTAL_STAT Character 1 A flag that indicates whether or not the Control Totals for a Journal Entry A flag that indicates whether or not the control totals match the
control totals match the entry totals for a control totals match the entry totals entry totals for a journal entry. The status is either (E)
journal entry. The status is either (E) for a journal entry. The status is indicating an error or (V) indicating that the match is OK.
indicating an error or (V) indicating that the either (E) indicating an error or (V)
32 match is OK. indicating that the match is OK.
29 PS_JRNL_HEADER JRNL_EDIT_ERR_STAT A flag that indicates whether or not there are PS_OH_JRNL_TRN_VW JRNL_EDIT_ERR_STAT Character 1 A flag that indicates whether or not Edit Errors in a Journal Entry A flag that indicates whether or not there are edit errors in a
edit errors in a journal entry. there are edit errors in a journal entry. journal entry.
33
30 PS_JRNL_HEADER JRNL_HDR_STATUS A flag that indicates the processing status of PS_OH_JRNL_TRN_VW JRNL_HDR_STATUS Character 1 A flag that indicates the processing Journal Header Status A flag that indicates the processing status of a journal entry.
34 a journal entry. status of a journal entry.
31 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_JRNL_TRN_VW OH_JHDR_STAT_DESC Character 30 Journal Header Status Description Journal Header Status A flag that indicates the processing status of a journal entry.
35 Description
32 PS_JRNL_HEADER SUSP_RECON_STATUS A flag that indicates whether or not there are PS_OH_JRNL_TRN_VW SUSP_RECON_STATUS Character 1 A flag that indicates whether or not Suspense Reconciliation Status in A flag that indicates whether or not there are suspense
suspense transactions in a journal, and if so, there are suspense transactions in a a Journal transactions in a journal, and if so, whether or not they have
whether or not they have been corrected and journal, and if so, whether or not they been corrected and posted.
36 posted. have been corrected and posted.
33 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_JRNL_TRN_VW OH_RECONSTAT_DESC Character 30 Suspense Reconciliation Status Suspense Reconciliation Status in A flag that indicates whether or not there are suspense
Description a Journal Description transactions in a journal, and if so, whether or not they have
been corrected and posted.
37
34 PS_JRNL_HEADER JRNL_PROCESS_REQST A flag that determines when a journal is PS_OH_JRNL_TRN_VW JRNL_PROCESS_REQST Character 1 A flag that determines when a journal Journal Process Request A flag that determines when a journal is ready for posting.
ready for posting. Some examples of the is ready for posting. Some examples Some examples of the request flag are Approved to Post,
request flag are Approved to Post, Denied, of the request flag are Approved to Denied, and Pending Approval.
and Pending Approval. Post, Denied, and Pending Approval.
38
35 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_JRNL_TRN_VW OH_JRNL_RQST_DESCR Character 30 Journal Process Request Description Journal Process Request A flag that determines when a journal is ready for posting.
Description Some examples of the request flag are Approved to Post,
39 Denied, and Pending Approval.
36 PS_JRNL_HEADER JRNL_SUMLED_REQST Post to Journal Summary Ledger Request PS_OH_JRNL_TRN_VW JRNL_SUMLED_REQST Character 1 Post to Journal Summary Ledger Post Journal To Summary Ledger Post to Summary Ledger. Summary ledgers store combined
Request account balances from detail ledgers. Update the summary
ledgers at the same time that you post changes to the detail
ledgers as part of the Journal Post process. This updates only
preexisting summary ledgers, which include business unit,
summary ledger name, fiscal, and accounting period
40 information.
37 PS_JRNL_HEADER SJE_TYPE A flag that indicates the type of Standard PS_OH_JRNL_TRN_VW SJE_TYPE Character 1 A flag that indicates the type of Standard Journal Entry Type A flag that indicates the type of Standard Journal Entry (SJE),
Journal Entry (SJE), which can be either Standard Journal Entry (SJE), which which can be either Template or Recurring. If the type is
Template or Recurring. If the type is can be either Template or Recurring. Recurring you must also specify a schedule (SCHEDULE).
Recurring you must also specify a schedule If the type is Recurring you must also
(SCHEDULE). specify a schedule (SCHEDULE).
41
38 PS_JRNL_HEADER SCHEDULE Schedule Identifier PS_OH_JRNL_TRN_VW SCHEDULE Character 10 Schedule Identifier Schedule Schedules are used to automate and control the generation of
recurring journal entries. You can define daily, weekly, monthly,
or annual schedules for recurring transactions such as closing
schedules or schedule specific user-defined events such as
42 expense report due dates.
39 PS_JRNL_HEADER EVENT_OCCURRENCE Identifies a user-defined event on a schedule PS_OH_JRNL_TRN_VW EVENT_OCCURRENCE Number 3 Identifies a user-defined event on a Event Occurrence Identifies a user-defined event on a schedule for automatically
for automatically creating standard and schedule for automatically creating creating standard and recurring journal entries. Event
recurring journal entries. Event Occurrence standard and recurring journal entries. Occurrence is a number associated with a date for creation of
is a number associated with a date for Event Occurrence is a number the journal.
creation of the journal. associated with a date for creation of
43 the journal.
40 PS_JRNL_HEADER POSTED_DATE Specifies the date that a journal entry is PS_OH_JRNL_TRN_VW POSTED_DATE Date 10 Specifies the date that a journal entry Posted Date Specifies the date that a journal entry is posted. This field is
posted. This field is maintained by the is posted. This field is maintained by maintained by the posting program of PeopleSoft General
posting program of PeopleSoft General the posting program of PeopleSoft Ledger.
44 Ledger. General Ledger.
41 PS_JRNL_HEADER SOURCE_INSTANCE Identifies a Process Instance PS_OH_JRNL_TRN_VW SOURCE_INSTANCE Number 10.4 Identifies a Process Instance Source Instance Identifies a Process Instance and is used by the PeopleSoft
(PROCESS_INSTANCE), and is used by the (PROCESS_INSTANCE), and is used Process Scheduler to save this identifier.
PeopleSoft Process Scheduler to save this by the PeopleSoft Process Scheduler
45 identifier. to save this identifier.
42 PS_JRNL_HEADER TRANSACTION_DATE Transaction Date PS_OH_JRNL_TRN_VW TRANSACTION_DATE Date 10 Transaction Date Transaction Date Transaction Date denotes the date this transaction occurred.
46
47 43 PS_JRNL_HEADER LAST_LN_COMMITTED Last Line Committed PS_OH_JRNL_TRN_VW LAST_LN_COMMITTED Number 6 Last Line Committed Last Line Committed Last Line Committed in a journal transaction.
44 PS_JRNL_HEADER OPRID A User's ID PS_OH_JRNL_TRN_VW OPRID Character 30 A User's ID Operator Identifier The Operator Identifier associated with creating this row on the
48 Journal Line.
45 PS_JRNL_HEADER DTTM_STAMP_SEC Specifies the date and time of the last update PS_OH_JRNL_TRN_VW DTTM_STAMP_SEC Date Time 26 Specifies the date and time of the last Date and Time Stamp Specifies the date and time of the last update to an entry. This
to an entry. This field is maintained by Stamp update to an entry. This field is field is maintained by PeopleSoft and is used in a variety of
PeopleSoft and is used in a variety of maintained by PeopleSoft and is used contexts.
49 contexts. in a variety of contexts.
50 PS_JRNL_HEADER DESCR Description PS_OH_JRNL_TRN_VW OH_JRNHDR_DESCR Character 30 Journal Header Description Journal Header Description Journal Header Description free flow text for length of 30.
51 46 PS_JRNL_LN CURRENCY_CD Currency Code PS_OH_JRNL_TRN_VW CURRENCY_CD Character 3 Currency Code Currency Code Currency code for the base currency amount.
7/15/20105:21 PM 34 of 150
OAKS Operational Reporting Data Warehouse
FIN - General Ledger Journal Transaction Reporting Data Dictionary: Journal Transaction
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
47 PS_JRNL_HEADER SYSTEM_SOURCE Identifies the application or source system PS_OH_JRNL_TRN_VW SYSTEM_SOURCE Character 3 Identifies the application or source Source System Identifies the application or source system that generated a
that generated a journal entry. system that generated a journal entry. journal entry.
52
48 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_JRNL_TRN_VW OH_SYS_SRC_DESCR Character 30 Source System Description Source System Description Identifies the application or source system that generated a
53 journal entry.
49 PS_JRNL_HEADER ACCTG_DEF_NAME Defines the content and source of the PS_OH_JRNL_TRN_VW ACCTG_DEF_NAME Character 10 Defines the content and source of the Accounting Definition Name Defines the content and source of the accounting transactions
accounting transactions that the Journal accounting transactions that the that the Journal Generator program of PeopleSoft General
Generator program of PeopleSoft General Journal Generator program of Ledger uses to create journal entries. Accounting transactions
Ledger uses to create journal entries. PeopleSoft General Ledger uses to are populated by PeopleSoft applications or third-party systems
Accounting transactions are populated by create journal entries. Accounting for input to the general ledger.
PeopleSoft applications or third-party transactions are populated by
systems for input to the general ledger. PeopleSoft applications or third-party
systems for input to the general
54 ledger.
55 50 PS_JRNL_HEADER PC_DISTRIB_STATUS Project Costing Distribution Status PS_OH_JRNL_TRN_VW PC_DISTRIB_STATUS Character 1 Project Costing Distribution Status Project Distribution Status Project Distribution Status
51 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_JRNL_TRN_VW OH_PCDSTRB_DESCR Character 30 Project Costing Distribution Status Project Distribution Status Value description for Project Distribution Status.
56 Description Description
57 52 PS_JRNL_HEADER BUDGET_HDR_STATUS Budget Header Status PS_OH_JRNL_TRN_VW BUDGET_HDR_STATUS Character 1 Budget Header Status Budget Header Status Records Budget Header Checking results
53 PS_JRNL_HEADER KK_AMOUNT_TYPE Commitment Control Amount Type PS_OH_JRNL_TRN_VW KK_AMOUNT_TYPE Character 1 Commitment Control Amount Type Commitment Control Amount Commitment Control Amount Type determines which
Type Commitment Control ledger is updated by the source
58 transaction.
54 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_JRNL_TRN_VW OH_KK_AMNT_DESCR Character 30 Commitment Control Amount Type Commitment Control Amount Commitment Control Amount Type describes which
Description Type Description Commitment Control ledger is updated by the source
59 transaction.
55 PS_JRNL_HEADER KK_TRAN_OVER_FLAG Commitment Control Source Transaction PS_OH_JRNL_TRN_VW KK_TRAN_OVER_FLAG Character 1 Commitment Control Source Commitment Control Source Commitment Control Source Transaction Override Flag.
60 Override Flag Transaction Override Flag Transaction Override Flag
56 PS_JRNL_HEADER KK_TRAN_OVER_OPRID Commitment Control Source Transaction PS_OH_JRNL_TRN_VW KK_TRAN_OVER_OPRID Character 30 Commitment Control Source Commitment Control Source If you selected the Override option and you override the budget
Override Operator Transaction Override Operator for a transaction, the system updates this field with your User
Transaction Override Operator ID
61 Identifier.
57 PS_JRNL_HEADER KK_TRAN_OVER_DTTM Commitment Control Source Transaction PS_OH_JRNL_TRN_VW KK_TRAN_OVER_DTTM Date Time 26 Commitment Control Source Commitment Control Source If you override a budget transaction, the system updates this
62 Override Date/Time Stamp Transaction Override Date/Time Transaction Override Datetime field with the transaction date.
58 PS_JRNL_HEADER KK_SKIP The field is used in Journal Header record. If PS_OH_JRNL_TRN_VW KK_SKIP Character 1 The field is used in Journal Header Skip Commitment Control Budget The field is used in Journal Header record. If its value is '1', the
its value is '1', the journal will skip record. If its value is '1', the journal Checking journal will skip commitment control budget checking. Usually,
commitment control budget checking. will skip commitment control budget the journal created from Journal Generator for accounting
Usually, the journal created from Journal checking. Usually, the journal created entries which have been budget checked already will have '1'
Generator for accounting entries which have from Journal Generator for accounting populated in this field. When the System Source supports
been budget checked already will have '1' entries which have been budget commitment control, the system selects the Skip Commitment
populated in this field. checked already will have '1' Control in GL check box and makes it unavailable for clearing,
populated in this field. because commitment control functions are done at the
63 application level.
64 59 PS_JRNL_HEADER JOURNAL_LOCKED Journal Locked for Change PS_OH_JRNL_TRN_VW JOURNAL_LOCKED Character 1 Journal Locked for Change Journal Locked Journal Locked for Change
60 PS_JRNL_HEADER GL_ADJUST_TYPE Adjustment Type PS_OH_JRNL_TRN_VW GL_ADJUST_TYPE Character 4 Adjustment Type General Ledger Adjustment Type The field used to designate a journal entry as a type of adjusting
65 entry.
66 61 PS_JRNL_HEADER JOURNAL_DATE_ORIG Orignial Journal Date PS_OH_JRNL_TRN_VW JOURNAL_DATE_ORIG Date 10 Orignial Journal Date Original Journal Date Original Journal Date
67 62 PS_JRNL_HEADER JOURNAL_CLASS Journal Class PS_OH_JRNL_TRN_VW JOURNAL_CLASS Character 10 Journal Class Journal Class Journal Class
63 PS_JRNL_HEADER KK_TRAN_BYPAS_FLAG Bypass Budget Checking Flag PS_OH_JRNL_TRN_VW KK_TRAN_BYPAS_FLAG Character 1 Bypass Budget Checking Flag Commitment Control Bypass Commitment Control Bypass Budget Checking
68 Budget Checking
64 PS_JRNL_HEADER IU_SYS_TRAN_CD System Transactions are delivered system PS_OH_JRNL_TRN_VW IU_SYS_TRAN_CD Character 8 System Transactions are delivered InterUnit or IntraUnit Systems System Transactions are delivered system data, representing
data, representing the activities that can system data, representing the Transaction Codes the activities that can require interunit or intraunit accounting
require interunit or intraunit accounting activities that can require interunit or entries.
69 entries. intraunit accounting entries.
65 PS_JRNL_HEADER IU_TRAN_CD Transaction Codes are user-defined. They PS_OH_JRNL_TRN_VW IU_TRAN_CD Character 8 Transaction Codes are user-defined. InterUnit or IntraUnit Transaction Transaction Codes are user-defined. They are mapped to the
are mapped to the delivered System They are mapped to the delivered Codes delivered System Transactions. InterUnit and IntraUnit
Transactions. InterUnit and IntraUnit System Transactions. InterUnit and Templates are keyed by Transaction Code, allowing users to
Templates are keyed by Transaction code, IntraUnit Templates are keyed by vary their accounting by transaction.
allowing users to vary their accounting by Transaction code, allowing users to
70 transaction. vary their accounting by transaction.
66 PS_JRNL_HEADER JRNL_CREATE_DTTM Journal Creation Date/Time PS_OH_JRNL_TRN_VW JRNL_CREATE_DTTM Date Time 26 Journal Creation Date/Time Journal Creation Date Time Journal Creation Date Time
71 Stamp
67 PS_JRNL_HEADER DESCR254 Description of length 254 PS_OH_JRNL_TRN_VW OH_JRNHDR_DESCR254 Character 254 Description of length 254 Description of length 254 Description is free flow text up to 254characters for additional
72 descriptions.
73 68 PS_JRNL_LN ACCOUNT Account PS_OH_JRNL_TRN_VW ACCOUNT Character 10 Account Account Specifies the balance sheet account or operating account
69 PS_JRNL_LN ALTACCT Alternate Account PS_OH_JRNL_TRN_VW ALTACCT Character 10 Alternate Account Alternate Account Alternate Account classifies the nature of a transaction for
74 regulatory authorities. Use it for statutory accounting.
70 PS_JRNL_LN DEPTID Department Identifier PS_OH_JRNL_TRN_VW DEPTID Character 10 Department Identifier Department Identifier Identifies the financial management organizational entity
75 associated with a particular financial transaction.
71 PS_JRNL_LN PROJECT_ID Grant/Project Identifier PS_OH_JRNL_TRN_VW PROJECT_ID Character 15 Grant/Project Identifier Grant/Project Identifier Grant/Project. Captures and controls project and grant
76 information.
77 72 PS_JRNL_LN BUDGET_PERIOD Budget Period PS_OH_JRNL_TRN_VW BUDGET_PERIOD Character 8 Budget Period Budget Period Budget Period
78 73 PS_JRNL_LN SCENARIO Scenario PS_OH_JRNL_TRN_VW SCENARIO Character 10 Scenario Scenario Scenario
74 PS_JRNL_LN STATISTICS_CODE Statistics Code PS_OH_JRNL_TRN_VW STATISTICS_CODE Character 3 Statistics Code Statistics Code A field for designating a code for the type of any non-monetary
amounts which are to be captured in the GL Journals. An
example might be a code for "Floor Space." A unit of measure
79 is designated for any Statistical Code.
80 75 PS_JRNL_LN MONETARY_AMOUNT Monetary Amount PS_OH_JRNL_TRN_VW MONETARY_AMOUNT Signed Number 23.3 Monetary Amount Monetary Amount Monetary Amount. Base currency amount.
81 76 PS_JRNL_LN STATISTIC_AMOUNT Statistic Amount PS_OH_JRNL_TRN_VW STATISTIC_AMOUNT Signed Number 13.2 Statistic Amount Statistic Amount Statistic Amount
77 PS_JRNL_LN JRNL_LN_REF Journal Line Reference PS_OH_JRNL_TRN_VW JRNL_LN_REF Character 10 Journal Line Reference Journal Line Reference The journal line reference used to track the source of the
transaction. This field is optional. The journal line reference is
populated from the defined field name if you select the Retain
Detail option on the Journal Generator Template -
Summarization page. If no field name is defined, the system
takes the journal line reference from the Journal Generator
82 template defaults.
83 78 PS_JRNL_LN SUSPENDED_LINE Suspended Journal Line Number PS_OH_JRNL_TRN_VW SUSPENDED_LINE Number 9 Suspended Journal Line Number Suspended Journal Line Number Suspended Journal Line Number
79 PS_JRNL_LN LINE_DESCR Journal Line Description PS_OH_JRNL_TRN_VW LINE_DESCR Character 30 Journal Line Description Journal Line Description Use this optional field to describe a transaction. This is
populated from the defined field name if you select the Retain
Detail option on the Journal Generator Template -
Summarization page. If no field name is defined, the system
takes the journal line description from the Journal Generator
84 template defaults.
80 PS_JRNL_LN JRNL_LINE_STATUS Journal Line Status PS_OH_JRNL_TRN_VW JRNL_LINE_STATUS Character 1 Journal Line Status Journal Line Status A flag that indicates the stage of processing of a Journal Entry.
85
86 81 PS_JRNL_LN JOURNAL_LINE_DATE Journal Line Date PS_OH_JRNL_TRN_VW JOURNAL_LINE_DATE Date 30 Journal Line Date Journal Line Date Journal Line Date
87 82 PS_JRNL_LN FOREIGN_AMOUNT Foreign Amount PS_OH_JRNL_TRN_VW FOREIGN_AMOUNT Signed Number 23.3 Foreign Amount Foreign Amount The amount in the entry currency.
83 PS_JRNL_LN JRNL_LINE_SOURCE Journal Line Source PS_OH_JRNL_TRN_VW JRNL_LINE_SOURCE Character 3 Journal Line Source Journal Line Source Identifies the origin of a journal line and defines journal entry
error handling options. The journal source provides a means of
selectively tracking, reporting, and inquiring on journal entries.
It can be almost anything within the enterprise – a subsystem
that generates transactions, a department, or even an
88 individual.
84 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_JRNL_TRN_VW OH_JRNLNSRC_DESCR Character 30 Journal Line Source Description Description that identifies the origin of a journal line and defines
journal entry error handling options. The journal source provides
a means of selectively tracking, reporting, and inquiring on
89 journal entries.
85 PS_JRNL_LN BUSINESS_UNIT_PC Project Costing Business Unit PS_OH_JRNL_TRN_VW BUSINESS_UNIT_PC Character 5 Project Costing Business Unit Project Business Unit A project business unit for PeopleSoft Expenses to use. Select
Projects User Preferences to use the project business unit
stored in the user profile or select Specify to enter a different
90 business unit to filter on.
86 PS_JRNL_LN ACTIVITY_ID Activity Identifier PS_OH_JRNL_TRN_VW ACTIVITY_ID Character 15 Activity Identifier Activity Identifier The activity ID assigned to the individual tasks or events that
91 you want to update in a project.
92 87 PS_JRNL_LN ANALYSIS_TYPE Analysis Type PS_OH_JRNL_TRN_VW ANALYSIS_TYPE Character 3 Analysis Type Analysis Type Analysis Type
7/15/20105:21 PM 35 of 150
OAKS Operational Reporting Data Warehouse
FIN - General Ledger Journal Transaction Reporting Data Dictionary: Journal Transaction
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
88 PS_JRNL_LN RESOURCE_TYPE Resource Type PS_OH_JRNL_TRN_VW RESOURCE_TYPE Character 5 Resource Type Resource Type The resource category, such as labor, associated with a given
cost. Used in conjunction with resource category, resource
93 subcategories, and resource groups.
89 PS_JRNL_LN RESOURCE_CATEGORY Resource Category PS_OH_JRNL_TRN_VW RESOURCE_CATEGORY Character 5 Resource Category Resource Category Used to specifically refine resource types, similar to the
relationship between entry type and entry reason in PeopleSoft
Receivables. For example, if you have a resource type of labor
but want to break it down further for tracking purposes, you
might define resource categories of architect hours, carpenter
94 hours, plumber hours, and electrician hours.
90 PS_JRNL_LN RESOURCE_SUB_CAT Resource Sub-Category PS_OH_JRNL_TRN_VW RESOURCE_SUB_CAT Character 5 Resource Sub-Category Resource Subcategory Used to refine resource categories. For example, if you have a
resource type of labor and resource categories of architect
hours, carpenter hours, and plumber hours, you might want
95 resource subcategories of regular hours and overtime hours.
96 91 PS_JRNL_LN BUDGET_DT Budget Date PS_OH_JRNL_TRN_VW BUDGET_DT Date 10 Budget Date Budget Date Budget Date
92 PS_JRNL_LN BUDGET_LINE_STATUS Budget Checking Line Status PS_OH_JRNL_TRN_VW BUDGET_LINE_STATUS Character 1 Budget Checking Line Status Budget Checking Line Status Use this optional field to flag the budget status as Error or Valid
(with warning), to access the Commitment Control page, where
you can see the error or warning messages. You can also flag
the journal to make it pass budget checking, even though it
97 exceeds the budgeted amount.
98 93 PS_JRNL_LN CLOSING_STATUS Closing Status PS_OH_JRNL_TRN_VW CLOSING_STATUS Character 1 Closing Status Closing Status Closing Status
99 94 PS_JRNL_LN JOURNAL_LINE_GFEE Entry Event Journal Line PS_OH_JRNL_TRN_VW JOURNAL_LINE_GFEE Number 9 Entry Event Journal Line Entry Event Journal Line Entry Event Journal Line
100 95 PS_JRNL_LN IU_TRAN_GRP_NBR InterUnit Group Number PS_OH_JRNL_TRN_VW IU_TRAN_GRP_NBR Number 4 InterUnit Group Number InterUnit Group Number InterUnit Group Number
101 96 PS_JRNL_LN IU_ANCHOR_FLG InterUnit Anchor PS_OH_JRNL_TRN_VW IU_ANCHOR_FLG Character 1 InterUnit Anchor InterUnit Anchor InterUnit Anchor
97 PS_JRNL_LN OPERATING_UNIT Operating Unit PS_OH_JRNL_TRN_VW OPERATING_UNIT Character 8 Operating Unit ISTV Xref Operating Unit is used to record the ISTVCross Reference
102 agency.
98 PS_JRNL_LN PRODUCT Product Chartfield PS_OH_JRNL_TRN_VW PRODUCT Character 6 Product Chartfield Product/Appropriation Line Item Appropriation Line Item will capture ALI and legal spending
authority by budget bill required on encumbrance and expense
103 transaction.
99 PS_JRNL_LN FUND_CODE Fund Code Chartfield PS_OH_JRNL_TRN_VW FUND_CODE Character 5 Fund Code Chartfield Fund Code Fund Code. Defines a fiscal and accounting entity with a self
balancing set of accounts. The Fund ChartField is defined as a
financial and accounting entity with a self-balancing set of
accounts. It records cash and other financial resources, with
related liabilities, fund balance and any corresponding changes
which are segregated for the purpose of carrying on specific
activities or attaining certain objective in accordance with
104 special regulations, restrictions, or limitations.
100 PS_JRNL_LN CLASS_FLD Service Location (Class Field) Chartfield PS_OH_JRNL_TRN_VW CLASS_FLD Character 5 Service Location (Class Field) Service Location Service Location – state, county, city, district, building, etc. this
Chartfield will allow the state to track spending in relation to a
105 geographical designation.
101 PS_JRNL_LN PROGRAM_CODE Program Code Chartfield PS_OH_JRNL_TRN_VW PROGRAM_CODE Character 5 Program Code Chartfield Program Code Program Code. Used to capture the enterprise program
106 concept.
102 PS_JRNL_LN BUDGET_REF Budget Reference Chartfield PS_OH_JRNL_TRN_VW BUDGET_REF Character 8 Budget Reference Chartfield Budget Reference Use to identify unique budgets, which is necessary when
individual budgets share budget keys and overlapping budget
107 periods.
103 PS_JRNL_LN AFFILIATE Affiliate PS_OH_JRNL_TRN_VW AFFILIATE Character 5 Affiliate Affiliate Used to map transactions between business units when using a
108 single interunit account.
104 PS_JRNL_LN AFFILIATE_INTRA1 Fund Affiliate PS_OH_JRNL_TRN_VW AFFILIATE_INTRA1 Character 10 Fund Affiliate Fund Affiliate Use to correlate transactions between funds when using a
109 single intraunit account.
105 PS_JRNL_LN AFFILIATE_INTRA2 Operating Unit Affiliate PS_OH_JRNL_TRN_VW AFFILIATE_INTRA2 Character 10 Operating Unit Affiliate ISTV Xref Affiliate ISTVCross Reference Affiliate. Is used to correlate transactions
between Operating Units when using a single intraunit account.
110
106 PS_JRNL_LN CHARTFIELD1 Project Chartfield PS_OH_JRNL_TRN_VW CHARTFIELD1 Character 10 Project Chartfield Chartfield1/Project Project Chartfield 1. Used to fulfill agency reporting
requirements as they relate to activities, tasks, or cost centers.
111
107 PS_JRNL_LN CHARTFIELD2 Reporting Chartfield PS_OH_JRNL_TRN_VW CHARTFIELD2 Character 10 Reporting Chartfield Chartfield2/Reporting Reporting Chartfield 2. Used to fulfill agency reporting
requirements as they relate to activities, tasks, or cost centers.
112
108 PS_JRNL_LN CHARTFIELD3 Agency Use Chartfield PS_OH_JRNL_TRN_VW CHARTFIELD3 Character 10 Agency Use Chartfield Chartfield3/Agency Use Agency Use Chartfield 3 . Used to fulfill agency reporting
requirements as they relate to activities, tasks, or cost centers.
113
114 109 PS_GL_ACCOUNT_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_ACCT_DESCR Character 30 Account Description Account Description Account Description is free flow text up to 30 characters.
115 110 PS_DEPT_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_DEPT_DESCR Character 30 Department Description Department Description Department Description is free flow text up to 30 characters.
116 111 PS_FUND_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_FUND_DESCR Character 30 Fund Description Fund Description Fund Description is free flow text up to 30 characters.
112 PS_PRODUCT_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_PROD_DESCR Character 30 Appropriation Line Item Description Appropriation Line Item Appropriation Line Item Description is free flow text up to 30
117 Description characters.
118 113 PS_PROGRAM_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_PROG_DESCR Character 30 Program Description Program Description Program Description is free flow text up to 30 characters.
119 114 PS_PROJECT DESCR Description PS_OH_JRNL_TRN_VW OH_PROJ_DESCR Character 30 Grant/Project Description Grant/Project Description Grant/Project Description
115 PS_CLASS_CF_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_CLASS_DESCR Character 30 Service Location Description Service Location Description Service Location Description is free flow text up to 30
120 characters.
121 116 PS_CHARTFIELD1_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_CHFD1_DESCR Character 30 Project Description Project Description Project Description is free flow text up to 30 characters.
122 117 PS_CHARTFIELD2_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_CHFD2_DESCR Character 30 Reporting Description Reporting Description Reporting Description is free flow text up to 30 characters.
123 118 PS_CHARTFIELD3_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_CHFD3_DESCR Character 30 Agency Use Description Agency Use Description Agency Use Description is free flow text up to 30 characters.
119 PS_OPER_UNIT_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_OPER_DESCR Character 30 Intra-State Transfer Voucher Xref ISTV Xref Description Intra-State Transfer Voucher Cross Reference Description is
124 Description free flow text up to 30 characters.
120 PS_BUD_REF_TBL DESCR Description PS_OH_JRNL_TRN_VW OH_BUDG_DESCR Character 30 Budget Reference Description Budget Reference Description Budget Reference Description is free flow text up to 30
125 characters.
126
7/15/20105:21 PM 36 of 150
OAKS EPM Operational Reporting Data Warehouse
FIN - GL Ledger Data Dictionary: Ledger Balance
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
TABLE BUSINESS
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
1 PS_LEDGER ACCOUNT Account PS_OH_LEDGER_VW ACCOUNT Character 10 Account Y OAKS Ledger Balance The Ledger Balance Account The Account Chartfield is used to specify the asset, liability,
Reporting Table Reporting Table holds equity, revenue, expense or transfer value for each financial
4 information about the transaction.
5 2 PS_LEDGER ACCOUNTING_PERIOD Accounting Period PS_OH_LEDGER_VW ACCOUNTING_PERIOD Number 3 Accounting Period Y business unit, ledger, Accounting Period The period of time to which the transaction was posted.
3 PS_LEDGER BUDGET_REF Budget Refernce PS_OH_LEDGER_VW BUDGET_REF Character 8 Budget Refernce Y ChartFields, and the Budget Refernce Use to identify unique budgets, which is necessary when
posted total amount. The individual budgets share budget keys and overlapping budget
various tables are pulled periods. Budget reference values can be used as a balancing
6 into one easy-to-use ChartField to maintain a balanced set of books by budget.
4 PS_LEDGER BUSINESS_UNIT Business Unit PS_OH_LEDGER_VW BUSINESS_UNIT Character 5 Business Unit Y reporting table. Business Unit The Business Unit represents an agency or subset of an agency
that is independent with regard to one or more operational or
7 accounting functions.
5 PS_LEDGER CHARTFIELD1 Project PS_OH_LEDGER_VW CHARTFIELD1 Character 10 Project Y Project Project is used to capture specific activities associated with
Projects/Grants transactions. It will be included in the Budget
8 Structures.
6 PS_LEDGER CHARTFIELD2 Reporting PS_OH_LEDGER_VW CHARTFIELD2 Character 10 Reporting N Reporting Reporting is used for capturing Agency specific values that are
not captured by any of the other ChartFields. May be used to
capture data formerly coded in Function, Activity or Extension.
9 It will not be included in the Budget Structures.
10 7 PS_LEDGER CHARTFIELD3 Agency Use PS_OH_LEDGER_VW CHARTFIELD3 Character 10 Agency Use Y Agency Use Agency Use
8 PS_LEDGER CURRENCY_CD Currency Code PS_OH_LEDGER_VW CURRENCY_CD Character 3 Currency Code Y Currency Code The code used to represent the type of currency (USD = US
dollars) being used on the transaction. Defaults to the base
11 code currency for the ledger group
9 PS_LEDGER DEPTID Department PS_OH_LEDGER_VW DEPTID Character 10 Department Y Department The Department ChartField is used to capture the financial
management view of the State's agencies, boards, and
12 commissions.
13 10 PS_LEDGER FISCAL_YEAR Fiscal Year PS_OH_LEDGER_VW FISCAL_YEAR Number 4 Fiscal Year Y Fiscal Year The Budgeting and Accounting Year of the State of Ohio.
11 PS_LEDGER FUND_CODE Fund Code PS_OH_LEDGER_VW FUND_CODE Character 5 Fund Code Y Fund Code The Fund ChartField is defined as a financial and accounting
entity with a self-balancing set of accounts. It records cash and
other financial resources, with related liabilities, fund balance
and any corresponding changes which are segregated for the
purpose of carrying on specific activities or attaining certain
objective in accordance with special regulations, restrictions, or
14 limitations.
12 PS_LEDGER GL_ADJUST_TYPE Adjustment Type PS_OH_LEDGER_VW GL_ADJUST_TYPE Character 4 Adjustment Type Y Adjustment Type The field used to designate a journal entry as a type of adjusting
15 entry.
13 PS_LEDGER LEDGER Ledger PS_OH_LEDGER_VW LEDGER Character 2 Ledger Y Ledger A ledger is a set of posted balances that represents a set of
books for a business unit. Ledgers store the posted net activity
for a set of ChartField values by accounting period and by fiscal
16 year.
14 PS_LEDGER OPERATING_UNIT ISTV XRef PS_OH_LEDGER_VW OPERATING_UNIT Character 8 ISTV XRef Y ISTV XRef Operating Unit is used to record the Interstate Voucher cross-
17 reference agency.
15 PS_LEDGER PRODUCT Appropriation Line Item PS_OH_LEDGER_VW PRODUCT Character 6 Appropriation Line Item Y Appropriation Line Item ALI. Seven-character code that identifies and defines an
appropriation in the Ohio Administrative Knowledge System
(OAKS). For example, in ALI CAP-010, the line item is identified
as capital (CAP) and the type of expense 010, for capital
improvements. Line item codes are used by the legislature for
appropriation purposes and by OAKS for budgeting and
18 reporting.
16 PS_LEDGER PROGRAM_CODE Program Code PS_OH_LEDGER_VW PROGRAM_CODE Character 5 Program Code Y Program Code The Program ChartField is used to capture groups of related
activities that cross organizational boundaries and are directed
towards the accomplishment of a set of recognizable objectives.
19
17 PS_LEDGER PROJECT_ID Grant/Project PS_OH_LEDGER_VW PROJECT_ID Character 15 Grant/Project Number Y Grant/Project Number The Projects ChartField is used to capture and control project
20 and grant information.
18 PS_LEDGER STATISTICS_CODE Statistics Code PS_OH_LEDGER_VW STATISTICS_CODE Character 4 Statistics Code Y Statistics Code A field for designating a code for the type of any non-monetary
amounts which are to be captured in the GL Journals. An
example might be a code for "Floor Space." A unit of measure
21 is designated for any Statistical Code.
22
19 PS_LEDGER AFFILIATE Affiliate PS_OH_LEDGER_VW AFFILIATE Character 5 Affiliate Affiliate Used to map transactions between business units when using a
23 single interunit account.
20 PS_LEDGER AFFILIATE_INTRA1 Fund Affiliate PS_OH_LEDGER_VW AFFILIATE_INTRA1 Character 10 Fund Affiliate Fund Affiliate Use to correlate transactions between funds when using a
24 single intraunit account.
21 PS_LEDGER AFFILIATE_INTRA2 ISTV XRef Affiliate PS_OH_LEDGER_VW AFFILIATE_INTRA2 Character 10 ISTV XRef Affiliate ISTV XRef Affiliate Interstate Voucher Cross Reference Affiliate is used to correlate
transactions between Operating Units when using a single
25 intraunit account.
22 PS_LEDGER ALTACCT Alternate Account PS_OH_LEDGER_VW ALTACCT Character 10 Alternate Account Alternate Account Alternate Account classifies the nature of a transaction for
26 regulatory authorities. Use it for statutory accounting.
27 23 PS_LEDGER BASE_CURRENCY Base Currency PS_OH_LEDGER_VW BASE_CURRENCY Character 3 Base Currency Base Currency Base Currency
24 PS_LEDGER CLASS_FLD Service Location PS_OH_LEDGER_VW CLASS_FLD Character 5 Service Location Service Location Service Location - state, county, city, district, building, etc. this
will allow the state to track spending in relation to a
28 geographical designation.
25 PS_LEDGER DTTM_STAMP_SEC Last Update DateTime PS_OH_LEDGER_VW DTTM_STAMP_SEC Date Time Stamp 26 Last Update DateTime Last Update DateTime Date of Last Update each time that the row is updated, the
29 system stamps the row with the last updated date and time.
26 PS_LEDGER POSTED_BASE_AMT Posted Base Amount PS_OH_LEDGER_VW POSTED_BASE_AMT Signed Number 23.3 Posted Base Amount Posted Base Amount Posted Base Amount contains the transaction amount for the
journal transaction. Debit amounts are positive and credit
amounts are negative. The Posted Total Amount, Posted Base
Amount and Posted Transaction amounts record the same
value for each transaction. The OAKS Financials Team
recommends the Posted Total Amount field be used in reports
developed in EPM since this is the amount field used in
reporting from production. In PeopleSoft applications where
transactions are recorded in foreign currency values these fields
are used to record the transactions in the foreign base currency
and calculate the equivalent U.S. dollar values. All transactions
are recorded in OAKS using U.S. dollar amounts only.
30
27 PS_LEDGER POSTED_TOTAL_AMT Posted Total Amount PS_OH_LEDGER_VW POSTED_TOTAL_AMT Signed Number 23.3 Posted Total Amount Posted Total Amount Posted Total Amount contains the transaction amount for the
journal transaction. Debit amounts are positive and credit
amounts are negative. The Posted Total Amount, Posted Base
Amount and Posted Transaction amounts record the same
value for each transaction. The OAKS Financials Team
recommends the Posted Total Amount field be used in reports
developed in EPM since this is the amount field used in
reporting from production. In PeopleSoft applications where
transactions are recorded in foreign currency values these fields
are used to record the transactions in the foreign base currency
and calculate the equivalent U.S. dollar values. All transactions
are recorded in OAKS using U.S. dollar amounts only.
31
7/15/20105:21 PM 37 of 150
OAKS EPM Operational Reporting Data Warehouse
FIN - GL Ledger Data Dictionary: Ledger Balance
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
TABLE BUSINESS
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME DESCRIPTION FIELD BUSINESS NAME FIELD BUSINESS DESCRIPTION
28 PS_LEDGER POSTED_TRAN_AMT Posted Transaction Amount PS_OH_LEDGER_VW POSTED_TRAN_AMT Signed Number 23.3 Posted Transaction Amount Posted Transaction Amount Posted Transaction Amount contains the transaction amount for
the journal transaction. Debit amounts are positive and credit
amounts are negative. The Posted Total Amount, Posted Base
Amount and Posted Transaction amounts record the same
value for each transaction. The OAKS Financials Team
recommends the Posted Total Amount field be used in reports
developed in EPM since this is the amount field used in
reporting from production. In PeopleSoft applications where
transactions are recorded in foreign currency values these fields
are used to record the transactions in the foreign base currency
and calculate the equivalent U.S. dollar values. All transactions
are recorded in OAKS using U.S. dollar amounts only.
32
33 29 PS_GL_ACCOUNT_TBL DESCR Description PS_OH_LEDGER_VW OH_ACCT_DESCR Character 30 Account Description Account Description Account Description is free flow text up to 30 characters.
34 30 PS_DEPT_TBL DESCR Description PS_OH_LEDGER_VW OH_DEPT_DESCR Character 30 Department Description Department Description Department Description is free flow text up to 30 characters.
35 31 PS_FUND_TBL DESCR Description PS_OH_LEDGER_VW OH_FUND_DESCR Character 30 Fund Description Fund Description Fund Description is free flow text up to 30 characters.
32 PS_PRODUCT_TBL DESCR Description PS_OH_LEDGER_VW OH_PROD_DESCR Character 30 Appropriation Line Item Description Appropriation Line Item Appropriation Line Item Description is free flow text up to 30
36 Description characters.
37 33 PS_PROGRAM_TBL DESCR Description PS_OH_LEDGER_VW OH_PROG_DESCR Character 30 Program Description Program Description Program Description is free flow text up to 30 characters.
38 34 PS_PROJECT DESCR Description PS_OH_LEDGER_VW OH_PROJ_DESCR Character 30 Grant/Project Description Grant/Project Description Grant/Project Description
35 PS_CLASS_CF_TBL DESCR Description PS_OH_LEDGER_VW OH_CLASS_DESCR Character 30 Service Location Description Service Location Description Service Location Description is free flow text up to 30
39 characters.
40 36 PS_CHARTFIELD1_TBL DESCR Description PS_OH_LEDGER_VW OH_CHFD1_DESCR Character 30 Project Description Project Description Project Description
41 37 PS_CHARTFIELD2_TBL DESCR Description PS_OH_LEDGER_VW OH_CHFD2_DESCR Character 30 Reporting Description Reporting Description Reporting Description is free flow text up to 30 characters.
42 38 PS_CHARTFIELD3_TBL DESCR Description PS_OH_LEDGER_VW OH_CHFD3_DESCR Character 30 Agency Use Description Agency Use Description Agency Use Description is free flow text up to 30 characters.
39 PS_OPER_UNIT_TBL DESCR Description PS_OH_LEDGER_VW OH_OPER_DESCR Character 30 ISTV XRef Description ISTV XRef Description ISTV Cross Reference Description is free flow text up to 30
43 characters.
40 PS_BUD_REF_TBL DESCR Description PS_OH_LEDGER_VW OH_BUDG_DESCR Character 30 Budget Reference Description Budget Reference Description Budget Reference Description is free flow text up to 30
44 characters.
45
7/15/20105:21 PM 38 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls
OAKS EPM Operational Reporting Data Warehouse
FIN - GL Commitment Control Budgets Data Dictionary: Commitment Control Budgets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
1 PS_KK_BUDGET_LN BUSINESS_UNIT Business Unit PS_OH_KK_BUDGET_VW BUSINESS_UNIT Character 10 Business Unit Y OAKS Commitment Control The OAKS Commitment Control Business Unit General Ledger Business Unit. The Business Unit represents an
Budgets Reporting Table Budgets Reporting Table contains agency or sub-set of an agency that is independent with regard to
4 detailed budget journal data such one or more operational or accounting functions.
2 PS_KK_BUDGET_LN JOURNAL_ID Identifies a journal entry, consisting of a PS_OH_KK_BUDGET_VW JOURNAL_ID Character 10 Identifies a journal entry, consisting of a Y as budget journal ID, date, and Journal Identifier Journal Identifier is an alphanumeric identifier which together with
header and one or more lines. The J ournal ID header and one or more lines. The budget journal descriptions. All the journal business unit and journal date forms a unique identifier
itself does not have to be unique, but together Journal ID itself does not have to be budget journals, regardless of for the PeopleSoft journals.
with the journal busin ess unit and journal unique, but together with the journal budget ledger, will be included in
date, it forms a unique journal identifier. business unit and journal date, it forms this table.
a unique journal identifier.
5
3 PS_KK_BUDGET_LN JOURNAL_DATE Specifies the date the journal was created. PS_OH_KK_BUDGET_VW JOURNAL_DATE Date 10 Specifies the date the journal was Y Journal Date The date the journal was created. This determines to which
created. period the system posts the journals, unless it is an adjusting
entry. This date is defaulted to the current day's date, but a
journal can be back dated or future dated within an open period.
6
4 PS_KK_BUDGET_LN UNPOST_SEQ Identifies the sequence of journal entries when PS_OH_KK_BUDGET_VW UNPOST_SEQ Number 2 Identifies the sequence of journal Y Unpost Sequence Number When a journal is unposted, a new reversing entry is
a journal is "unposted". When a journal is entries when a journal is "unposted". automatically created with an Unpost Sequence of "1".
posted the UnPost Sequence is automatically When a journal is posted the UnPost
set to "0". When a jou rnal is unposted, a new Sequence is automatically set to "0".
reversing entry is automatically created with an When a journal is unposted, a new
UnPost Sequence of "1". reversing entry is automatically created
with an UnPost Sequence of "1".
7
5 PS_KK_BUDGET_LN JOURNAL_LINE Uniquely identifies a journal line with a PS_OH_KK_BUDGET_VW JOURNAL_LINE Number 9 Uniquely identifies a journal line with a Y Journal Line Number Refers to each accounting line entered in PeopleSoft General
sequence number. Within a single jour nal sequence number. Within a single jour Ledger Create Journal Entries consisting of appropriate chartfield
entry, the line sequence begins with 1 and nal entry, the line sequence begins and accounting values.
automatically increments by 1 for each with 1 and automatically increments by
succeeding journal line. There can be any 1 for each succeeding journal line.
number of lines associated with a journal There can be any number of lines
heade associated with a journal heade
8
6 PS_KK_BUDGET_HDR LEDGER_GROUP Ledger Group PS_OH_KK_BUDGET_VW LEDGER_GROUP Character 10 Ledger Group Ledger Group A ledger group can have one primary ledger and zero to nine
secondary ledgers. PeopleSoft General Ledger posts to the
ledgers within the group according to the rules that you establish.
9
7 PS_KK_BUDGET_HDR KK_BUDG_TRANS_TYPE Budget Entry Type PS_OH_KK_BUDGET_VW KK_BUDG_TRANS_TYPE Character 1 Budget Entry Type Budget Entry Type A field which describes the purpose of the budget journal.
Choices are as follow: Original, Adjustment, Transfer Original,
10 Transfer Adjustment, Closing or Roll Forward.
8 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_KK_BUDGET_VW OH_BDTRN_TYP_DESCR Character 30 XLAT Long Name Budget Entry Type Description Budget Entry Type Description is free flow text up to 30
11 characters.
9 PS_KK_BUDGET_HDR JRNL_PROCESS_REQST A flag that determines when a journal is ready PS_OH_KK_BUDGET_VW JRNL_PROCESS_REQST Character 1 A flag that determines when a journal Journal Process Request A flag that determines when a journal is ready for posting. Some
for posting. Some examples of t he request is ready for posting. Some examples of examples of the request flag are Approved to Post, Denied, and
flag are Approved to Post, Denied, and t he request flag are Approved to Post, Pending Approval.
12 Pending Approval. Denied, and Pending Approval.
10 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_KK_BUDGET_VW OH_JRNL_RQST_DESCR Character 30 XLAT Long Name Journal Process Request Description Journal Process Request Description is free flow text up to 30
13 characters.
11 PS_KK_BUDGET_HDR CUR_EFFDT Specifies the effective date associated with the PS_OH_KK_BUDGET_VW CUR_EFFDT Date 10 Specifies the effective date associated Currency Effective Date Specifies the effective date associated with the currency used as
currency used as the base curre ncy for the with the currency used as the base the base currency for the Business Unit on the Journal Entry
Business Unit on the Journal Entry Header. curre ncy for the Business Unit on the Header.
Journal Entry Header.
14
12 PS_KK_BUDGET_HDR BD_HDR_STATUS Budget Header Status: N - Posting has not PS_OH_KK_BUDGET_VW BD_HDR_STATUS Character 1 Budget Header Status: N - Posting has Budget Header Status Budget Header Status: N - Posting has not been run against the
been run against the journal E - T he journal not been run against the journal E - T journal E - The journal has failed edits V - The journal has passed
has failed edits V - The journal has passed he journal has failed edits V - The edits but cannot be posted due to monetary related issues S -
edits but cannot be post ed due to monetary journal has passed edits but cannot be One ore more journal lines have failed the security edits
related issues S - One ore more journal lines post ed due to monetary related issues
have failed th e security edits S - One ore more journal lines have
failed th e security edits
15
13 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_KK_BUDGET_VW OH_BD_H_STAT_DESCR Character 30 XLAT Long Name Budget Header Status Description Budget Header Status Description is free flow text up to 30
16 characters.
17 14 PS_KK_BUDGET_HDR CF_VALUE ChartField Value PS_OH_KK_BUDGET_VW CF_VALUE Character 18 ChartField Value Chartfield Value Not used in Budget Header table.
15 PS_KK_BUDGET_HDR JRNL_TOT_CREDITS Represents a running total of the credit PS_OH_KK_BUDGET_VW JRNL_TOT_CREDITS Signed Number 28 Represents a running total of the credit Total Journal Credits in a Journal Represents a running total of the credit amounts in a journal
amounts in a journal entry. It is main tained by amounts in a journal entry. It is Entry entry. It is maintained by PeopleSoft General Ledger as lines are
PeopleSoft General Ledger as lines are maintained by PeopleSoft General entered.
18 entered. Ledger as lines are entered.
16 PS_KK_BUDGET_HDR JRNL_TOTAL_DEBITS Represents a running total of the debit PS_OH_KK_BUDGET_VW JRNL_TOTAL_DEBITS Signed Number 28 Represents a running total of the debit Total Journal Debits in a Journal Represents a running total of the debit amounts in a journal entry.
amounts in a journal entry. It is maint ained by amounts in a journal entry. It is Entry It is maintained by PeopleSoft General Ledger as lines are
PeopleSoft General Ledger as lines are maintained by PeopleSoft General entered.
19 entered. Ledger as lines are entered.
17 PS_KK_BUDGET_HDR JRNL_TOTAL_LINES Represents a running total of the number of PS_OH_KK_BUDGET_VW JRNL_TOTAL_LINES Number 9 Represents a running total of the Total Journal Lines in a Journal Entry Represents a running total of the number of lines in a journal
lines in a journal entry. It is mai ntained by number of lines in a journal entry. It is entry. It is maintained by PeopleSoft General Ledger as lines are
PeopleSoft General Ledger as lines are maintained by PeopleSoft General entered.
20 entered. Ledger as lines are entered.
18 PS_KK_BUDGET_HDR POSTED_DATE Specifies the date that a journal entry is PS_OH_KK_BUDGET_VW POSTED_DATE Date 10 Specifies the date that a journal entry is Posted Date Specifies the date that a journal entry is posted. This field is
posted. This field is maintained by the posting posted. This field is maintained by the maintained by the posting program of PeopleSoft General Ledger.
program of PeopleSoft General Ledger. posting program of PeopleSoft General
21 Ledger.
19 PS_KK_BUDGET_HDR SYSTEM_SOURCE Identifies the application or source system that PS_OH_KK_BUDGET_VW SYSTEM_SOURCE Character 3 Identifies the application or source Source System Identifies the application or source system that generated a
generated a journal entry. R elease 8.80 - system that generated a journal entry. journal entry.
11/14/2002 - RVlasic - Removed GDM Release 8.80 - 11/14/2002 - RVlasic -
(JrnlGen - Deduction Management ) from Removed GDM (JrnlGen - Deduction
Translate Values. Management ) from Translate Values.
22
20 PSXLATITEM XLATLONGNAME XLAT Long Name PS_OH_KK_BUDGET_VW OH_SYS_SRC_DESCR Character 30 XLAT Long Name Source System Description Source System Description is free flow text up to 30 characters.
23
21 PS_KK_BUDGET_HDR DTTM_STAMP_SEC Specifies the date and time of the last update PS_OH_KK_BUDGET_VW DTTM_STAMP_SEC DateTime 26 Specifies the date and time of the last Last Update Date and Time Stamp Specifies the date and time of the last update to an entry. This
to an entry. This field is maint ained by update to an entry. This field is maint field is maintained by PeopleSoft and is used in a variety of
PeopleSoft and is used in a variety of contexts. ained by PeopleSoft and is used in a contexts.
24 variety of contexts.
22 PS_KK_BUDGET_HDR OPRID A user's ID PS_OH_KK_BUDGET_VW OPRID Character 30 A user's ID Operator Identifier The Operator Identifier associated with creating this row on the
25 Journal Line.
26 23 PS_KK_BUDGET_HDR DESCR Description PS_OH_KK_BUDGET_VW DESCR Character 30 Description Budget Description Description of the budget name associated with this record.
24 PS_KK_BUDGET_HDR SOURCE_INSTANCE Identifies a Process Instance PS_OH_KK_BUDGET_VW SOURCE_INSTANCE Number 15 Identifies a Process Instance Source Instance Identifies a Process Instance and is used by the PeopleSoft
(PROCESS_INSTANCE), and is used by the (PROCESS_INSTANCE), and is used Process Scheduler to save this identifier.
PeopleSoft Process Scheduler to save this by the PeopleSoft Process Scheduler
27 identifier. to save this identifier.
7/15/20105:21 PM 39 of 150
fe89f118-b1ba-4248-a849-b7c5d0e07ca2.xls
OAKS EPM Operational Reporting Data Warehouse
FIN - GL Commitment Control Budgets Data Dictionary: Commitment Control Budgets
A B C D I J K L M N O P Q R S T U V
1 PEOPLESOFT ORACLE ERP TABLES (OAKS FIN Source System) PEOPLESOFT ORACLE TABLES - Operational Reporting Warehouse (EPM Reporting Table) Business Metadata Design
2 FIELD FIELD FIELD FIELD KEY REQ
3 ID TABLE NAME FIELD DESCRIPTION TABLE NAME FIELD TYPE LENGTH DESCRIPTION FLD FLD Comments TABLE BUSINESS NAME TABLE BUSINESS DESCRIPTION FIELD BUSINESS NAME
25 PS_KK_BUDGET_HDR FISCAL_YEAR Fiscal Year PS_OH_KK_BUDGET_VW FISCAL_YEAR Number 4 Fiscal Year Fiscal Year Fiscal Year. Displays the year based on the beginning date of the
28 period. You can change this year.
26 PS_KK_BUDGET_HDR ACCOUNTING_PERIOD Identifies a time period to which you post PS_OH_KK_BUDGET_VW ACCOUNTING_PERIOD Number 3 Identifies a time period to which you Accounting Period Identifies a time period to which you post transactions. An
transactions. Typically, an accounti ng period post transactions. Typically, an accounting period has a beginning date and an ending date, and
represents a month, but it can also represent a accounting period represents a month, is defined in the calendar table.
week, a day, or any us er-defined interval. An but it can also represent a week, a day,
accounting period has a beginning date and an or any user-defined interval. An
ending dat e, and is define accounting period has a beginning date
and an ending date, and is define
29
27 PS_KK_BUDGET_HDR IN_PROCESS_FLG In process flag PS_OH_KK_BUDGET_VW IN_PROCESS_FLG Character 1 In process flag In Process Flag Displays whether the transaction is currently being budget
30 checked.
28 PS_KK_BUDGET_HDR JRNL_CREATE_DTTM Journal Creation Date Time PS_OH_KK_BUDGET_VW JRNL_CREATE_DTTM DateTime 26 Journal Creation Date Time Journal Creation Date Time Displays the date at which the journal was created within the
31 system.
29 PS_KK_BUDGET_HDR DESCR254 Description of length 254 PS_OH_KK_BUDGET_VW DESCR254 Character 254 Description of length 254 Description of length 254 Description is free flow text up to 254characters for additional
32 descriptions.
30 PS_KK_BUDGET_LN LEDGER Ledger PS_OH_KK_BUDGET_VW LEDGER Character 10 Ledger Ledger A ledger consists of posted balances that represent a set of books
for a business unit. Ledgers store the posted net activity for a set
of chartfield values by accounting period and by fiscal year.
Ledgers are maintained primarily through journal entries.
33
31 PS_KK_BUDGET_LN BUDGET_PERIOD Budget Period PS_OH_KK_BUDGET_VW BUDGET_PERIOD Character 8 Budget Period Budget Period Budget Period clarifies a budget amount over a certain calendar
34 period(s).
32 PS_KK_BUDGET_LN ACCOUNT Account PS_OH_KK_BUDGET_VW ACCOUNT Character 10 Account Account ID The Account Chartfield is used to specify the balance sheet
account or operating account (i.e. expenditure or revenue object
codes) on financial transactions. Required on all transactions.
Revenue accounts will begin with the value of "4".
35
36 33 PS_GL_ACCOUNT_TBL DESCR Account Description PS_OH_KK_BUDGET_VW OH_ACCT_DESCR Character 30 Account Description Account ID Description Account ID Description is free flow text up to 30 characters.
34 PS_KK_BUDGET_LN DEPTID Department PS_OH_KK_BUDGET_VW DEPTID Character 10 Department Department ID The Department Chartfield identifies the financial management
organizational entity associated with a particular financial
transaction. The State will use this chartfield to capture the State
and agency organization chart. Required on encumbrance,
expense, and revenue transactions.
37
35 PS_DEPT_TBL DESCR Department Description PS_OH_KK_BUDGET_VW OH_DEPT_DESCR Character 30 Department Description Department ID Description Department ID Description is free flow text up to 30 characters.
38
36 PS_KK_BUDGET_LN OPERATING_UNIT Operating Unit ChartField PS_OH_KK_BUDGET_VW OPERATING_UNIT Character 8 Operating Unit ChartField ISTV Xref Operating Unit is used to record the ISTV Cross Reference
39 agency.
37 PS_OPER_UNIT_TBL DESCR ISTV XRef Description PS_OH_KK_BUDGET_VW OH_OPER_DESCR Character 30 ISTV XRef Description ISTV Xref Description Intra-State Transfer Voucher Cross Reference Description is free
40 flow text up to 30 characters.
38 PS_KK_BUDGET_LN PRODUCT Product ChartField PS_OH_KK_BUDGET_VW PRODUCT Character 1 Product ChartField Appropriation Line Item The Product chartfield is used by the State to capture
Appropriation Line Item (ALI), the legal spending authority by the
budget bill, and will be required on encumbrance and expense
41 transaction.
39 PS_PRODUCT_TBL DESCR Appropriation Line Item Description PS_OH_KK_BUDGET_VW OH_PROD_DESCR Character 30 Appropriation Line Item Description Appropriation Line Item Description Appropriation Line Item Description is free flow text up to 30
42 characters.
40 PS_KK_BUDGET_LN FUND_CODE Fund Code PS_OH_KK_BUDGET_VW FUND_CODE Character 5 Fund Code Fund Code The Fund chartfield defines a fiscal and accounting entity with a
self-balancing set of accounts. It records cash and other financial
resources, together with related liabilities and residual equities or
balances, and any corresponding changes. Required on all
43 transactions.
44 41 PS_FUND_TBL DESCR Fund Description PS_OH_KK_BUDGET_VW OH_FUND_DESCR Character 30 Fund Description Fund Code Description Fund Code Description is free