; Setting Up a Business Budget
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Setting Up a Business Budget

VIEWS: 55 PAGES: 17

Setting Up a Business Budget document sample

More Info
  • pg 1
									                                                                                               General Ledger Team's Report
                                                                        On Mapping UD Data Elements to PeopleSoft Panels, Records, (Tables) and Fields

      Panel Name                   Record                  Field Name           Field Long Name              UD Database          UD Field Name                                               Comments
DEPARTMENT                   DEPARTMENT_TBL       DEPTID                Department                          Central Table   Budget Unit and Budget Unit This Panel in PS is used to set up the DEPARTMENT chart field which replaces the
                                                                                                            #72019          Descriptions                last six digits in the UD account code, budget unit and project numbers. (Go, Define
                                                                                                                                                        Business Rules, Design ChartFields, Use, Department, Update display, ok, ok)


DEPARTMENT                   BD_CENTER_LEAF       BD_ROLEUSER           Budgets User                        GADESCFILE      ADMIN-INFO and               We believe that the Budgets User field in PS is similar to the UD data element
                                                                                                                            NAME-ACCT-BROWSE             ADMIN-INFO and NAME-ACCT-BROWSE. (Same Navigation as Department. Go
                                                                                                                                                         to the "Budgets User" field on the panel and click on the drop down box).
DEPARTMENT                   DEPARTMENT_TBL       DESCRLONG             Description                         GADESCFILE      ACCT-TITLE                   We believe the Long description field for department is similar to UD data element
                                                                                                                                                         ACCT-TITLE. (Same Navigation as Department)

DEPARTMENT                   DEPARTMENT_TBL       EFF_STATUS            Status as of Effective Date         GADESCFILE      GA-INACTV-DATE               We believe that the Status field in PS is similar to the UD data element GA-Status
                                                                                                            Central Table   GA-GADESCFILE-STATUS         Codes active, inactive, reactivated, and GA-INACTV-DATE. However, there are no
                                                                                                            #72005          CODES                        matches in PS for the remaining status codes, current budget delete, quasi-inactive,
                                                                                                            #72006          GA-GABALFILE-STATUS          and delete. (Same Navigation as Department)
                                                                                                                            CODES
DEPARTMENT                   DEPARTMENT_TBL       MANAGER_NAME          Manager Name                                                                     Other fields used in PS for setting up the Department chart fields. (Same Navigation
                                                                                                                                                         as Department). Please note: To identify any fields not appearing in the panel use
                                                                                                                                                         "Application Designer".


DEPARTMENT                   DEPARTMENT_TBL       EFFDT                 Effective Date                                                                                                              "
DEPARTMENT                   FUNCLIB_BDINTFC      FUNC_BD_CTR_EXISTS    BD Center Exists                                                                                                            "
DEPARTMENT                   BD_CENTER_LEAF       EFFDT                 Effective Date                                                                                                              "
DEPARTMENT                   BD_CENTER_LEAF       FIELDNAME             Field Name                                                                                                                  "
DEPARTMENT                   BD_CENTER_LEAF       SETID                 SetID                                                                                                                       "
DEPARTMENT                   DEPARTMENT_TBL       SETID                 SetID                                                                                                                       "
DEPARTMENT                   BD_CENTER_LEAF       BUDGET_LOCATION       Budget Center                                                                                                               "
DEPARTMENT                   DEPARTMENT_TBL       DESCR                 Description                                                                                                                 "
DEPARTMENT                   BD_CENTER_LEAF       DEPTID                Department                                                                                                                  "
DEPARTMENT                   BD_CENTER_LEAF       BUSINESS_UNIT         Business Unit                                                                                                               "
FUND_DEFINITION              FUND_TBL             FUND_CODE             Fund                                Central Table   Fund and Fund Descriptions These two panels in PS are used to set up the PS Fund chart field which replaces
FUND_DENINITION2             FUND_TBL             FUND_CODE             Fund                                #71097                                     the first two digits (1-1) in the UD account code. (Go, Define Business Rules, Design
                                                                                                                                                       ChartFields, Use, Fund, Fund Definition, Update display, ok, ok)


FUND_DEFINITION              FUND_TBL             DESCRLONG             Description                                                                      Other fields used in PS for setting up the FUND chart fields (Same Navigation as
                                                                                                                                                         Fund). Please note: To identify any fields not appearing in the panel use
                                                                                                                                                         "Application Designer".
FUND_DEFINITION              FUND_TBL             EFF_STATUS            Status as of Effective Date                                                                                                 "


FUND_DEFINITION              CHARTFD_LBL_WRK      GF_LABEL60            60 Characters Label                                                                                                        "

FUND_DEFINITION              FUND_TBL             EFFDT                 Effective Date                                                                                                             "
FUND_DEFINITION              CHARTFD_LBL_WRK      GF_LABEL3             Label3                                                                                                                     "
FUND_DEFINITION              CHARTFD_LBL_WRK      GF_LABEL2             Label2                                                                                                                     "
FUND_DEFINITION              CHARTFD_LBL_WRK      GF_LABEL1             Label1                                                                                                                     "
FUND_DEFINITION              CHARTFD_LBL_WRK      GF_LABEL61            60 Characters Label                                                                                                        "
FUND_DEFINITION              FUND_TBL             DESCR                 Description                                                                                                                "
FUND_DEFINITION              FUND_TBL             ENC_MAX_VAR_PCT       Enc. Tolerance Percentage                                                                                                  "
FUND_DEFINITION              CHARTFD_LBL_WRK      GF_LABEL62            60 Characters Label                                                                                                        "
FUND_DEFINITION              FUND_TBL             INV_MAX_VAR_AMT       Inventory Tolerance Amount                                                                                                 "
FUND_DEFINITION              FUND_TBL             INV_MAX_VAR_PCT       Inventory Tolerance Percentage                                                                                             "
FUND_DEFINITION              FUND_TBL             PRENC_MAX_VAR_AMT     Preenc. Tolerance Amount                                                                                                   "
FUND_DEFINITION              FUND_TBL             SETID                 SetID                                                                                                                      "
FUND_DEFINITION              FUND_TBL             ENC_MAX_VAR_AMT       Encumbrance Tolerance Amount                                                                                               "
FUND_DEFINITION              FUND_TBL             PRENC_MAX_VAR_PCT     Preenc. Tolerance Percentage                                                                                               "
FUND_DEFINITION2             FUND_ATTRIB_TBL      FUND_ATTRIB_VALUE     Fund Attribute Value                                                                                                       "
FUND_DEFINITION2             FUND_TBL             EFF_STATUS            Status as of Effective Date                                                                                                "




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls   11/10/2010                                                          1
      Panel Name                    Record               Field Name              Field Long Name      UD Database           UD Field Name                                                 Comments
FUND_DEFINITION2             DERIVED              EDITTABLE            Edit Table                                                                                                                "
FUND_DEFINITION2             XLATTABLE            XLATSHORTNAME        Translate Short Name                                                                                                      "
FUND_DEFINITION2             FUND_ATTRIB_TBL      FUND_ATTRIBUTE       Fund Attribute                                                                                                            "
FUND_DEFINITION2             FUND_ATTR_WRK        DESCR60              Description                                                                                                               "
FUND_DEFINITION2             FUND_TBL             SETID                SetID                                                                                                                     "
FUND_DEFINITION2             FUND_TBL             EFFDT                Effective Date                                                                                                            "
FUND_DEFINITION2             FUND_TBL             DESCR                Description                                                                                                               "
GL_ACCOUNT                   GL_ACCOUNT_TBL       ACCOUNT              Account                       GABALFILE        Object Code                 This panel in PS is used to set up the PS ACCOUNT chart field which replaces the
                                                                                                     SRTMAT           Object Code                 UD object code, the last three digits in the UD account code. UD data element
                                                                                                     GATRANFILE       GAT-OBJ-CODE                ACCT-CODE-14 refers to Assets and liabilities. In PS assets will always start with
                                                                                                     GADESCFILE       ACCT-CODE-14                the letter "A" for assets and "L" for liabilities in the chart field account as the first
                                                                                                     GABALFILE        ACCT-CODE-14                digit. (Go, Define Business Rules, Design ChartFields, Use, Account, Account,
                                                                                                     SRTMAT           ACCT-CODE-14                Update display, ok, ok)
                                                                                                     Central Tables   Object Code Description
                                                                                                     #72014
GL_ACCOUNT                   GL_ACCOUNT_TBL       BUD_CONTROL_TYPE     Budget Control Type                                                        Other fields used in PS for setting up the ACCOUNT chart fields. (Same Navigation
                                                                                                                                                  as Account) Please note: To identify any fields not appearing in the panel use
                                                                                                                                                  "Application Designer".

GL_ACCOUNT                   GL_ACCOUNT_TBL       DESCRSHORT           Short Description                                                                                                       "
GL_ACCOUNT                   GL_ACCOUNT_TBL       DESCR                Description                                                                                                             "
GL_ACCOUNT                   GL_ACCOUNT_TBL       EFF_STATUS           Status as of Effective Date                                                                                             "
GL_ACCOUNT                   ACCT_TYPE_TBL        DESCR                Description                                                                                                             "
GL_ACCOUNT                   GL_ACCOUNT_TBL       OPEN_ITEM_TOL_AMT    Reconcile Tolerance                                                                                                     "
GL_ACCOUNT                   GL_ACCOUNT_TBL       SETID                SetID                                                                                                                   "
GL_ACCOUNT                   GL_ACCOUNT_TBL       CURRENCY_CD          Currency Code                                                                                                           "
GL_ACCOUNT                   GL_ACCOUNT_TBL       SYSTEM_MAINT_ACCT    Budgetary Account Only                                                                                                  "
GL_ACCOUNT                   GL_ACCOUNT_TBL       BUDG_OVERRIDE_ACCT   Budget Override Account                                                                                                 "
GL_ACCOUNT                   GL_ACCOUNT_TBL       STATISTICS_ACCOUNT   Statistical Account                                                                                                     "
GL_ACCOUNT                   GL_ACCOUNT_TBL       UNIT_OF_MEASURE      Unit of Measure                                                                                                         "
GL_ACCOUNT                   GL_ACCOUNT_TBL       OPEN_ITEM_EDIT_REC   OpenItem Edit Record                                                                                                    "
GL_ACCOUNT                   GL_ACCOUNT_TBL       EFF_STATUS           Status as of Effective Date                                                                                             "
GL_ACCOUNT                   GL_ACCOUNT_TBL       BALANCE_FWD_SW       Balance Forward                                                                                                         "
GL_ACCOUNT                   GL_ACCOUNT_TBL       OPEN_ITEM_EDIT_FLD   OpenItem Edit Field                                                                                                     "
GL_ACCOUNT                   GL_ACCOUNT_TBL       OPEN_ITEM_DESCR      Description of OpenItem                                                                                                 "
GL_ACCOUNT                   GL_ACCOUNT_TBL       OPEN_ITEM            OpenItem Account                                                                                                        "
GL_ACCOUNT                   GL_ACCOUNT_TBL       ACCOUNT_TYPE         Account Type                                                                                                            "
GL_ACCOUNT                   GL_ACCOUNT_TBL       INVENTORY_ACCOUNT    Inventory Account                                                                                                       "

                                                                                                                                                 This Panel in PS is used to set up the PROGRAM chart field which replaces the 3rd
                                                                                                     Central Tables   Function Code and Function and 4th digits in the UD account code, function. (Go, Define Business Rules,
PROGRAM_DEFINITION           PROGRAM_TBL          PROGRAM_CODE         Program                       #72017           Code Description           Design ChartFields, Use, Program, Update display ok, ok)
                                                                                                                                                  Other fields used in PS for setting up the PROGRAM chart fields. (Same Navigation
                                                                                                                                                  as Program) Please note: To identify any fields not appearing in the panel use
PROGRAM_DEFINITION           PROGRAM_TBL          SETID                SetID                                                                      "Application Designer".


PROGRAM_DEFINITION           PROGRAM_TBL          DESCRLONG            Description                                                                                                             "


PROGRAM_DEFINITION           PROGRAM_TBL          EFF_STATUS           Status as of Effective Date                                                                                             "
PROGRAM_DEFINITION           PROGRAM_TBL          EFFDT                Effective Date                                                                                                          "
PROGRAM_DEFINITION           PROGRAM_TBL          DESCR                Description                                                                                                             "
PROGRAM_DEFINITION           PROGRAM_TBL          MANAGER_NAME         Manager Name                                                                                                            "


                                                                                                                                                  We believe that UD data elements START-DATE and END-DATE are comparable to
PROJECT_ATTRIBUTE1           PROJECT_HEADER       END_DT               End Date                                       END-DATE                    PS Project/Grant start and end date. Go, Define Business Rules, Design chart field,
PROJECT_ATTRIBUTE1           PROJECT_HEADER       START_DT             Start Date                    GADESCFILE       START-DATE                  Use, Project/Grant, Project/Grant, Update/Display, Ok, Ok.




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls   11/10/2010                                                   2
        Panel Name                    Record                Field Name              Field Long Name     UD Database         UD Field Name                                            Comments

                                                                                                                                                The UD Field "Bal-Curr-Bal" is year-to-date balances or net period activity of total
                                                                                                                                                accounting transactions for the current fiscal year. We believe PS creates similar
                                                                                                                                                summary fields using summary ledgers. In PS, net period activity (debits and
                                                                                                                                                credits combined) is stored for each Chartfield combination to which journal entries
                                                                                                                                                have been posted. Year-to-date balances are not stored but are calculated at report
                                                                                                                      Bal-Curr-Bal              time using summary ledgers and time spans. (Go, Process Financial Information,
LEDGER_SUMMARY1              GL_PANELS_WRK            REFRESH_CHARTFLDS   Refresh ChartFields          GABALFILE      Bal-Prev-Bal              Maintain Ledgers, Use, Summary Ledgers, Update/Display)

                                                                                                                                                Other fields used in PS for setting up the "Summary Ledgers". ( Same navigation
                                                                                                                                                as Summary Ledgers). Please note: To identify any fields not appearing in the
LEDGER_SUMMARY1              LED_SUMV_TBL             SELECT_VALUE        Select Value                                                          panel use "Application Designer".
LEDGER_SUMMARY1              LED_DEFN_TBL             SETID               SetID                                                                                                             "
LEDGER_SUMMARY1              GL_PANELS_WRK            SETCNTRLVALUE       Set Control Value                                                                                                 "
LEDGER_SUMMARY1              LED_FLDS_TBL             TREE_NAME           Tree Name                                                                                                         "
LEDGER_SUMMARY1              GL_PANELS_WRK            USE_LEVELS          Use Levels                                                                                                        "
LEDGER_SUMMARY1              GL_PANELS_WRK            TREE_NAME_SETID     TableSet                                                                                                          "
LEDGER_SUMMARY1              LED_FLDS_TBL             TREE_LEVEL          Level Name                                                                                                        "
LEDGER_SUMMARY1              LED_FLDS_TBL             CHARTFIELD          ChartField                                                                                                        "
LEDGER_SUMMARY1              LED_PANELS_WRK           DESCR               Description                                                                                                       "
LEDGER_SUMMARY1              LED_DEFN_TBL             DESCR               Description                                                                                                       "
LEDGER_SUMMARY1              DERIVED                  EDITTABLE           Edit Table                                                                                                        "
LEDGER_SUMMARY1              LED_DEFN_TBL             DETAIL_LEDGER       Detail Ledger ID                                                                                                  "
LEDGER_SUMMARY1              LED_FLDS_TBL             DETAIL_CHARTFIELD   Detail Ledger ChartField                                                                                          "
LEDGER_SUMMARY1              LED_DEFN_TBL             EFFDT               Effective Date                                                                                                    "
LEDGER_SUMMARY1              DERIVED                  EDITTABLE2          Secondary Edit Table                                                                                              "
LEDGER_SUMMARY1              LED_FLDS_TBL             HOW_FIELD_SPECIFY   How Specified                                                                                                     "
LEDGER_SUMMARY1              LED_FLDS_TBL             HOW_FIELD_SPECIFY   How Specified                                                                                                     "
LEDGER_SUMMARY1              LED_FLDS_TBL             HOW_FIELD_SPECIFY   How Specified                                                                                                     "
LEDGER_SUMMARY1              LED_FLDS_TBL             HOW_FIELD_SPECIFY   How Specified                                                                                                     "
LEDGER_SUMMARY1              LED_FLDS_TBL             HOW_FIELD_SPECIFY   How Specified                                                                                                     "
LEDGER_SUMMARY1              LED_FLDS_TBL             HOW_FIELD_SPECIFY   How Specified                                                                                                     "
LEDGER_SUMMARY1              LED_FLDS_TBL             FIELD_SEQUENCE      Field Sequence Number                                                                                             "
LEDGER_SUMMARY1              LED_DEFN_TBL             LEDGER_TEMPLATE     Ledger Template                                                                                                   "
LEDGER_SUMMARY1              LED_DEFN_TBL             LEDGER              Ledger                                                                                                            "
LEDGER_SUMMARY1              LED_TMPLT_TBL            LEDGER_TYPE         Ledger Type                                                                                                       "
                                                                                                                                                The UD field "Bal-Curr-Tran" is the current month transactions. We believe PS
                                                                                                                                                captures these transactions in the Detail Ledger. (Go, Process Financial
LEDGER_DETAIL1               LED_FLDS_TBL             BALANCE_FLAG        Balance by Chartfield        GABAL file     Bal-Curr-Tran             Information, Maintain Ledgers, Use, Detail Ledgers, Update/Display)
                                                                                                                                                Other fields used in PS for setting up the "Detail Ledgers". (Same navigation as
                                                                                                                                                Detail Ledgers). Please note: To identify any fields not appearing in the panel use
LEDGER_DETAIL1               LED_DEFN_TBL             BUDGET_TYPE         Budget Type                                                           "Application Designer".
LEDGER_DETAIL1               LED_FLDS_TBL             CHARTFIELD          ChartField                                                                                                        "
LEDGER_DETAIL1               LED_DEFN_TBL             DESCR               Description                                                                                                       "
LEDGER_DETAIL1               LED_TMPLT_TBL            DESCR               Description                                                                                                       "
LEDGER_DETAIL1               DERIVED                  EDITTABLE           Edit Table                                                                                                        "
LEDGER_DETAIL1               DERIVED                  EDITTABLE2          Secondary Edit Table                                                                                              "
LEDGER_DETAIL1               LED_FLDS_TBL             FIELD_SEQUENCE      Field Sequence Number                                                                                             "
LEDGER_DETAIL1               LED_DEFN_TBL             LEDGER              Ledger                                                                                                            "
LEDGER_DETAIL1               LED_TMPLT_TBL            LEDGER_CLASS        Classification                                                                                                    "
LEDGER_DETAIL1               LED_DEFN_TBL             LEDGER_TEMPLATE     Ledger Template                                                                                                   "
LEDGER_DETAIL1               LED_TMPLT_TBL            LEDGER_TYPE         Ledger Type                                                                                                       "
LEDGER_DETAIL1               LED_FLDS_TBL             RECNAME             Record (Table) Name                                                                                               "
LEDGER_DETAIL1               LED_FLDS_TBL             RECNAME_NO_EFFDT    View - No Effective Date                                                                                          "
LEDGER_DETAIL1               FS_PANELS_WRK            REFRESH_DET_CF      Refresh Detail Chartfields                                                                                        "
LEDGER_DETAIL1               LED_DEFN_TBL             SCENARIO            Scenario                                                                                                          "
LEDGER_DETAIL1               LED_DEFN_TBL             SETID               SetID                                                                                                             "
LEDGER_DETAIL1               XLATTABLE                XLATLONGNAME        Translate Long Name                                                                                               "
                                                                                                       GABAL file     Bal-Curr-Bal-Prior-Year   Same as Bal-Curr-Bal - Change Budget Periods to Prior Year. The path to
                                                                                                                                                establish the budget periods is: Go, Define Business Rules, Design Chart Fields,
                                                                                                                                                Use, Budget Period, Update/Display.




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls       11/10/2010                                                 3
        Panel Name                    Record                Field Name               Field Long Name        UD Database         UD Field Name                                          Comments
                                                                                                           GABAL file     Bal-Curr-Encum           The UD field "Bal-Curr-Encum" is the total of anticipated charges against the
                                                                                                                                                   account. Encumbrances are generated from payroll and purchasing transactions
                                                                                                                                                   and will carryover from the HR and Purchasing modules. The information will be
                                                                                                                                                   summarized in the same way as noted in "Bal_Curr_Bal" above. Please Note: A
                                                                                                                                                   decision was made by the PS HRMS implementation team not to allow for payroll
                                                                                                                                                   and purchasing encumbrances in the initial phase of the HRMS implementation.

                                                                                                           GABAL file     Bal-Prev-Encum           Represents the amount of previous months encumbrances.          See Bal-Curr-Encum.
                                                                                                                                                   Use prior period time span
                                                                                                           GABAL file     Bal-Total-Encum          Summarized Same as above Bal-Curr-Bal. Represents the sum of previous and
                                                                                                                                                   current encumbrances, i.e. commitments for expenditure against this particular
                                                                                                                                                   account.
                                                                                                                                                   The UD data element "BAL-BUDGT-TYPE" has two valid values: '0' = NO BUDGET
                                                                                                                                                   RECORD OR '1' = BUDGET RECORD EXISTS. This data element is used in adhoc
                                                                                                                                                   reporting to either include or exclude budget records. This data element should be
                                                                                                                                                   included in our PS created Data Warehouse. PS supports five budget types:
                                                                                                                                                   Appropriation, Allotment, Organization, Revenue Estimate, and Project/Grant. The
                                                                                                                                                   PS path is Go, Define Business Rules, Administer Budgetary Control, Use,
BUDGETARY_CNTRL              BUDGETARY_CNTRL          BUDGET_CNTRL_TYPE   Budgetary Control Type           GABALFILE      Bal-Budgt-Type           Budgetary Control Parameters, Add.
                                                                                                                                                   Other fields used in PS for Budgetary Control. (Same Navigation as Budget Control
                                                                                                                                                   Type) Please note: To identify any fields not appearing in the panel use
BUDGETARY_CNTRL              BUDGETARY_CNTRL          BUDGET_FLAG_KEY     Control Location                                                         "Application Designer".
BUDGETARY_CNTRL              BUDGETARY_CNTRL          BUDGET_KEY_KEY      Key Location                                                                                                       "
BUDGETARY_CNTRL              BUD_JRN_PNL_WRK          BUD_CONTROL_PARMS   Budgetary Control Parms                                                                                            "
BUDGETARY_CNTRL              BUDGETARY_CNTRL          BUSINESS_UNIT       Business Unit                                                                                                      "
BUDGETARY_CNTRL              BUDGET_CNTR_WRK          BUSINESS_UNIT       Business Unit                                                                                                      "
BUDGETARY_CNTRL              FUNCLIB_FS               LANGUAGE_CD         Language Code                                                                                                      "
BUDGETARY_CNTRL              BUDGETARY_CNTRL          PANEL_SEQ_NBR       Panel Sequence Number                                                                                              "
BUDGETARY_CNTRL              XLATTABLE                XLATLONGNAME        Translate Long Name                                                                                                "
                                                                                                                                                    Represents the percentage of full time for which the employee is budgeted in the
                                                                                                                                                   specified account. Original FTE is the amount at the beginning of the Fiscal Year. In
                                                                                                                                                   PS you can use "Statistics Codes" to represent "Full Time Equivalents". Go, Define
                                                                                                                          Budgt-Full-Time-Equiv    Business Rules, Design Chart Fields, Use, Statistics Codes, Update/Display.
BD_position                  bd_position_vw           FTE                 FTE                              GABAL file     Budgt-Orig-FTE
                                                                                                                                                   This field represents the per hour pay rate earned by the employee. Hourly rate
                                                                                                                                                   applies to salaried staff only. It is currently obtained from UD BTA (Budget turn
                                                                                                                                                   around file). We could not find it in any other panel in GL other than this Grants
                                                                                                                                                   panel. The PS path is Go,Adm Grants, Maint Professionals, Use, Job &
                                                                                                                                                   Employment Data, Job Data1, Add. Hourly Rate is selected from the "Comp Freq"
                                                                                                                                                   field and then the rate is input into the "compensation rate" field.
GM_JOB_DATA1                 JOB                      HOURLY_RT           Hourly Rate                      GABAL file     Budgt-Hrly-Rate
                                                                                                                                                   There is a drop down box in PS listing Job Codes. We believe this is similar to UD
                                                                                                                                                   Job Class. Go, Process Financial Information, Coordinate Budgets, Use, Job
                                                                                                                                                   Codes, Update/display.
BD_JOBCODE_PNL               BD_JOBCODES_VW           JOBCODE             Job Code                         GABAL file     Budgt-Job-Class


                                                                                                                                                   This UD field represents the current budget including all permanent and temporary
                                                                                                                                                   changes occurring during the fiscal year. In PS, this is a calculated field. The PS
                                                                                                                                                   panel for entering the original budget is EXP_BUD_ADD_2 . (Go, Process Financial
                                                                                                                                                   Information, Prepare Controlled Budgets, Use,Organization Budget Journal,
                                                                                                                                                   Organization budget 2, Add) We believe panel name Appropriation_Bal1 is used for
EXP_BUD_ADD_2                BUD_JRNL_HEADER          POST_BUDGET_JRNL    Post Budget Journal   Monetary                                           subsequent changes to the budgeted numbers.Go, Process Financial Info, Prepare
APPROPRIATION_BAL1           BUD_JRNL_LN              MONETARY_AMOUNT     Amount                           GABAL file     Budgt-Net-Budgt          Controlled Budgets, Use, Appropriation Journal, Appropriation Journal 2, Add

                                                                                                                                                   Same as Budgt-Net-Budgt. Change Budget Periods The path to establish the
                                                                                                                                                   budget periods is: Go, Define Business Rules, Design Chart Fields, Use, Budget
                                                                                                                                                   Period, Add, click on Budget Period drop down box and choose Prior Fiscal Year.
                                                                                                                                                   Use prior period Time Span. The path for time spans is Go, Define Business Rules,
BUDGET_PERIOD                BUDGET_PERIOD            BUDGET_PERIOD       Budget Period                                                            Define General Options, Use R-Z, Time Span, Update/Display, choose Set ID:
TIME_SPAN                    TIME_SPAN                TIME_SPAN           Time Span                        GABAL file     Bud-Net-Bud-Prior-Year   UNIV, ok, Choose year to date prior year.




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls       11/10/2010                                                     4
        Panel Name                    Record                  Field Name             Field Long Name      UD Database          UD Field Name                                         Comments
                                                                                                                                               This UD field represents the beginning budget plus any permanent changes made
                                                                                                                                               during the year. In PS, it appears on panel Exp_Bud_Add2. Go, Process Financial
                                                                                                                                               Information, Prepare Controlled budget, Use, Organization Budget Journal,
EXP_BUD_ADD_2                BUD_JRN_PNL_WRK          Current_Bud_Amt      Current Organization Budget   GABAL file      Budgt-Perm-Budgt      Organization Budget 2, Add
                                                                                                                                               This UD field represents the net amount of permanent changes which have been
                                                                                                                                               processed during the year. It appears on Appropriation_Bal1(Go, Process Financial
                                                                                                                                               Information, Prepare Control Budget, Use, Appropriation Journal, Appropriation
                                                                                                                                               Journal 1 and 2, Add.
APPROPRIATION__BAL1          BUD_JRNL_LN              MONETARY_AMOUNT      Monetary Amount               GABAL file      Budgt-Perm-Chng
                                                                                                                                               Valid values for this UD field are Semi-Monthly, Bi weekly. In PS under "Administer
                                                                                                                                               Grants" you have a dropdown box for "Comp. Freq" that allows you to select either
                                                                                                                                               Biweekly or Semimonthly. The PS path is Go, Administer Grants, Maintain
                                                                                                                                               Professionals, Use, Job Employee Data, Job Data1, Add, (Comp Frequency).

GM_JOB_DATA1                 JOB                      COMP_FREQUENCY       Compensation Frequency        GABAL file      Budgt-Smbw
                                                                                                                                               We believe this field will carry over from HR. However, there is a field in PS GL
                                                                                                                                               which may also apply. The path to this field is Go, Administer Grants, Maintain
                                                                                                                                               Professionals, Use, Professional Data, Add. If we are using SS# as employee ID #,
                                                                                                                                               then it goes in the employee ID# field. Input National Id Type (Social Security
                                                                                                                                               Number) and then input the ID number in the National ID field.
GM_PERS_DATA                 PERS_NID                 NATIONAL_ID          National ID                   GABAL file      Budgt-SSN
                                                                                                                                               Budgt-Start-Budgt represents the permanent portion of the total budget amount
                                                                                                                                               effective July 1of the current fiscal year. In PS you will establish the permanent
                                                                                                                                               budget amount effective July 1, XX using the menu "Prepare controlled Budgets".
                                                                                                                                               Go, Process Financial Info, Prepare Controlled Budgets, Use, Organization Budget
                                                                                                                                               Journal, Organization Budget 2, Add, ok.
EXP_BUD_ADD_2                BUD_JRNL_HEADER          POST_BUDGET_JRNL     Post Budget Journal           GABAL file      Budgt-Start-Budgt
                                                                                                                                               We believe this is similar to the "transfer amount" field in PS. Go, Process Financial
                                                                                                                                               Info, Prepare Controlled budget, Use, Appropriation Transfer. Appropriation Transfer
                                                                                                                                               From, Add.
APPROPRIATION_TRN1           BUD_JRN_PNL_WRK          CURRENT_ALLOT_AMT    Current Allotment Amount      GABAL file      Budgt-Temp-Chng
                                                                                                                                               UD Budget Notes are brief descriptions associated with a particular line of funding.
                                                                                                                                               They indicate where the funding came from or went to or act as reminders to the
                                                                                                                                               budget Office for special handling. We believe PS "Standard Notes" could be used
                                                                                                                                               for UD "Budget Notes". The PS path is Go, Define Business Rules, Define General
                                                                                                                                               Options, Use R-Z, Standard Notes, Update/Display All, University, Ok, Ok. Also,
                                                                                                         GABAL file      Budgt-Notes           another option could be PS "Reason Codes" . The PS path is Go, Define Business
                                                                                                         Central Table   GA-Budget Note        Rules, Define General Options, Use R-Z, Reason Codes, Update/Display All,
STD_NOTE                     NOTE_TYPE                DESCR                Description                   #72013          Descriptions          University, Ok, Ok.
                                                                                                                                               Other fields used in PS for Standard Notes. (Same Navigation as Standard Notes)
                                                                                                                                               Please note: To identify any fields not appearing in the panel use "Application
STD_NOTE                     STD_NOTE                 DESCR                Description                                                         Designer".
STD_NOTE                     STD_NOTE_DOC             DOCUMENT_CD          Document Code                                                                                                  "
STD_NOTE                     STD_NOTE                 EFFDT                Effective Date                                                                                                 "
STD_NOTE                     STD_NOTE                 EFF_STATUS           Status as of Effective Date                                                                                    "
STD_NOTE                     STD_NOTE_KEYWD           KEY_WORD             Key Words                                                                                                      "
STD_NOTE                     STD_NOTE                 NOTE_TYPE            Note Type                                                                                                      "
STD_NOTE                     STD_NOTE                 SETID                SetID                                                                                                          "
STD_NOTE                     STD_NOTE                 STD_NOTE_CD          Standard Note Code                                                                                             "
STD_NOTE                     STD_NOTE                 TEXT254              Text                                                                                                           "
STD_NOTE                     OM_DOC_CODE_VW           XLATLONGNAME         Translate Long Name                                                                                            "
                                                                                                                                                We believe that PS "Account Type" (Assets, Expenses, Equity, Liability, and
                                                                                                         GABAL file      Type-of-Acct          Revenue) are similar to the UD Type of Accounts. Go, Define Business Rules,
                                                                                                         SRTMAT          ALER-TYPE             Define General Options, Use A-D, Account Types, Update/Display (choose Univ) 0k,
ACCT_TYPE                    TYPE                     ACCT_TYPE_TBL        ACCOUNT TYPE                  GATRANFILE      GAT-ALER-TYPE         0k
                                                                                                                                                We believe PS Accounting Entry Definition is similar to UD transaction description.
                                                                                                         SRTMAT          TRAN-DESC             Go, Define Business Rules, Define General Options, Use A-D, Accounting Entry
JRNL_GEN_ACCTG_DEF           JRNLGEN_DEFN             ACCTG_DEF_NAME       Accounting Definition Name    GATRANFILE      GAT-TRAN-DESC         Definition, Update/Display, ok




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls       11/10/2010                                                   5
        Panel Name                    Record                Field Name               Field Long Name     UD Database          UD Field Name                                                 Comments
                                                                                                                                                    We believe this will be completed in the PS system 'Installation Options' using
                                                                                                                                                    'Document Sequencing'. PS general ledger is able to use an automatic numbering
                                                                                                                                                    system for journals. If you choose to use this feature, PS will assign a journal a
                                                                                                                                                    number that is one greater than the value viewed in this field. Journal Generator
                                                                                                                                                    also uses this field to assign journal numbers to transactions fed from feeder
                                                                                                        SRTMAT          REF-NUM                     systems. Go, define Business Rules, Define General Options, Use E-P, installation
INSTALLATION_FS1             INSTALLATION_FS          DOC_SEQ              Document Sequencing          GATRANFILE      GAT-REF-NUM                 Options, Overall.
                                                                                                                                                    In PS the Transaction date is the date a transaction actually occurred. The "Journal
                                                                                                                                                    Entry Header" panel contains the journal date which is similar to UD transaction
                                                                                                                                                    date. This data element should be included in the PS created Data Warehouse.
                                                                                                        SRTMAT          TRAN-DATE                   The PS path is Go, Process Financial Information, Process Journals, Use, Journal
JOURNAL_ENTRY1               JRNL_HEADER              JOURNAL_DATE         Date                         GATRANFILE      GAT-TRAN-DATE               Entry, Header, Update/Display.

                                                                                                        SRTMAT          TRAN-AMOUNT                 We believe PS " Journal Line Amount" is similar to UD Transaction Amount. Go,
JROURNAL_ENTRY_2             JRNL_HEADER_IU           JRNL_LINE            Amount                       GATRANFILE      GAT-TRAN-AMT                Process Financial Information, Process Journals, Use, Journal Entry, Lines, Add
                                                                                                        SRTMAT          DEBIT-AMT
                                                                                                        GATRANFILE      GAT-DEBIT-AMT
                                                                                                        SRTMAT          DEBIT-CRED-CODE              We believe in PS "Journal Line Debits" is similar to UD Debit amount. Go, Process
JROURNAL_ENTRY_2             JRNL_HEADER_IU           JRNL_TOTAL_DEBITS    Debits                       GATRANFILE      GAT-DEBIT-CRED-CODE         Financial Information, Process Journals, Use, Journal Entry, Lines, Add
                                                                                                        SRTMAT          CREDIT-AMT                   We believe PS "Credits is similar to UD Credit Amount. Go, Process Financial
                                                                                                        GATRANFILE      GAT-CRED-AMT                Information, Process Journals, Use, Journal Entry, Lines, Add
                                                                                                        SRTMAT          DEBIT-CRED-CODE
JROURNAL_ENTRY_2             JRNL_HEADER_IU           JRNL_TOTAL_DEBITS    Credits                      GATRANFILE      GAT-DEBIT-CRED-CODE


                                                                                                                                                    UD "Batch Control Status Codes" contain the following values: '01' = OPEN; '03' =
                                                                                                                                                    NOT BALANCED; '05' = CLOSED; '07' = APPROVED; '08' = SUBMITTED; '09' =
                                                                                                                                                    PROCESSED; '88' = TO REVERSE; '99' = DELETED. We believe running
                                                                                                                                                    processes with PS "Process Scheduler" and using PS "Process Monitor," which is a
                                                                                                                                                    PeopleSoft Tool used with the Process Scheduler Process, that gives you similar
                                                                                                                                                    batch (or process) control status as UD batch control status codes. The Process
                                                                                                                                                    Monitor is a Peopletool that tracks the status of all completed and pending Process
                                                                                                                                                    Scheduler requests. The "Status' column on the Process Monitor panel provides the
                                                                                                                                                    following status codes: All, Cancel, Cancelled, Delete, Error, Hold, Initiated,
                                                                                                                                                    Processing, Queued, Success, Unsuccessful. The PS path for using the Process
                                                                                                                                                    Monitor is Go, Peopletools, Process Monitor, then click on the "Run Status' drop
                                                                                                        Central Table                               down box. For detail information on "Process Scheduler" see UD field name "Last
                                                                                                        #71020          Batch Control Status code   Load Date" below.



                                                                                                                                                    UD data elements "Last-Load-Date" and Last-Load-Time" are used to control month-
                                                                                                                                                    end processing loads. They identify the date and time a record was created and
                                                                                                                                                    when a record was last loaded. We believe running processes with PS "Process
                                                                                                                                                    Scheduler" gives you similar control data. The PS path for "Process Scheduler" is
                                                                                                                        Last-Load-Date              Go, Process Financial Information, Process Journals, Process, Journal Generator,
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          PROCESS_FREQUENCY    Process Frequency            GABAL file      Last-Load-Time              Update Display, Run from the tool bar.
                                                                                                                                                    Other fields used in PS "Process Scheduler." (Same Navigation as "Process
                                                                                                                                                    Scheduler".) Please note: To identify any fields not appearing in the panel use
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          REQUEST_NBR          Request Number                                                           "Application Designer".
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          SETID                SetID                                                                                                               "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          TO_DT                To Date                                                                                                             "
JRNL_GEN_REQUEST             JRNLGEN_DEFN_VW          SYSTEM_SOURCE        System Source                                                                                                       "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          TO_DT_OPTN           To Date Option                                                                                                      "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          BUSINESS_UNIT        Business Unit                                                                                                       "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          BUSINESS_UNIT_OPTN   Business Unit Option                                                                                                "
JRNL_GEN_REQUEST             DERIVED                  EDITTABLE            Edit Table                                                                                                          "
JRNL_GEN_REQUEST             DERIVED                  EDITTABLE2           Secondary Edit Table                                                                                                "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          APPL_JRNL_ID_OPTN    Template Option                                                                                                     "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          APPL_JRNL_ID         Journal Template                                                                                                    "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          ACCTG_DEF_NAME       Accounting Definition Name                                                                                          "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          FROM_DT              From Date                                                                                                           "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST          FROM_DT_OPTN         From Date Option                                                                                                    "




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls       11/10/2010                                                  6
      Panel Name                   Record                 Field Name            Field Long Name       UD Database          UD Field Name                                               Comments
JRNL_GEN_REQUEST             FS_PANELS_WRK         MAX_LINE_NUMBER     Maximum Line Number Counter                                                                                          "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST       LEDGER_GROUP        Ledger Group                                                                                                         "
JRNL_GEN_REQUEST             JRNLGEN_REQUEST       LEDGER_GROUP_OPTN   Ledger Group Option                                                                                                  "
                                                                                                                                                The detail calendar is used to identify your fiscal accounting years and periods.
                                                                                                                                                When entering a journal entry, the system uses the detail calendar to translate the
                                                                                                                                                journal date to the appropriate posting period and year. Your detail calendar controls
                                                                                                                                                the number and duration of accounting periods that are in your fiscal year. We
                                                                                                     SRTMAT          STMT-DATE                  believe the statement date will be set up in the Detail Calendar. The PS path is Go,
DETAIL_CALENDAR1             CAL_DETP_TBL          BEGIN_DT            Begin Date                    GATRANFILE      GAT-STMT-DATE              Define Business Rules, Define General Options, Use A-D, Detail Calendar, Detail
DETAIL_CALENDAR1             CAL_DETP_TBL          END_DT              End Date                      GABALFILE       STMT-DATE                  Calendar 1, Update/Display.
                                                                                                                                                In conjunction with "Detail Calendars", we believe PS "Time Spans" are used for
                                                                                                                                                statement date control. Within time spans the periods and as of reporting date are
                                                                                                     Central Table                              determined. The PS path for time spans is Go, Define Business Rules, Define
TIME_SPAN                    TIME_SPANS            START_YEAR_TYPE     Start Year Type               #71090          GA- Statement Date Control General Options, use R-Z, Time Spans, Update/Display.
                                                                                                                                                Other fields used in PS "Time Spans." (Same Navigation as "Time Spans".) Please
                                                                                                                                                note: To identify any fields not appearing in the panel use "Application Designer".
TIME_SPAN                    TIME_SPANS            SETID               SetID

TIME_SPAN                    TIME_SPANS            START_PERIOD        Start Period                                                                                                            "
TIME_SPAN                    TIME_SPANS            START_PERIOD_TYPE   Start Period Type                                                                                                       "
TIME_SPAN                    TIME_SPANS            START_YEAR          Start Year                                                                                                              "
TIME_SPAN                    TIME_SPANS            TIME_SPAN           TimeSpan                                                                                                                "
TIME_SPAN                    CAL_DEFN_TBL          CALENDAR_TYPE       Type of Calendar                                                                                                        "
TIME_SPAN                    TIME_SPANS            CALENDAR_ID         Calendar ID                                                                                                             "
TIME_SPAN                    CAL_DEFN_TBL          DESCR               Description                                                                                                             "
TIME_SPAN                    TIME_SPANS            DESCR               Description                                                                                                             "
TIME_SPAN                    TIME_SPANS            END_PERIOD_TYPE     End Period Type                                                                                                         "
TIME_SPAN                    TIME_SPANS            END_PERIOD          End Period                                                                                                              "
TIME_SPAN                    TIME_SPANS            END_YEAR_TYPE       End Year Type                                                                                                           "
TIME_SPAN                    TIME_SPANS            END_YEAR            End Year                                                                                                                "
TIME_SPAN                    TIME_SPANS            INCLUDE_CLOSE_PER   Include Closing Adjustments                                                                                             "
TIME_SPAN                    TIME_SPANS            INCLUDE_BAL_FRWD    Include Balance Forward                                                                                                 "
                                                                                                                                                  We believe PS "Journal Sources" are similar to UD transaction codes and is used to
                                                                                                     Central Table                                identify the origin or source of a journal. The PS path is Go, Define Business Rules,
                                                                                                     #71091          GA- Transaction Codes        Define General Options, Use E-P, Journal Source, Journal Options, Add (In "ADD" a
                                                                                                     SRTMAT          TRAN-CODE                    drop down box is provided with a list of journal sources or transaction codes and
SOURCE1                      SOURCE_TBL            SOURCE              Source                        GATRANFILE      GAT-TRAN-CODE                their description).
                                                                                                                                                  In PS you have the option to either "Recycle' a journal with errors or "Suspend" a
                                                                                                                                                  journal with errors. If the suspend option is selected PS will generate a suspense
                                                                                                                                                  line to bring an out-of-balance journal back into balance and will allow you to correct
                                                                                                                                                  the suspensed line by using the "Journal Suspense Correction" process. This
                                                                                                                                                  process is similar to GA - Suspense/fund Balancing Accounts. The PS path to
                                                                                                     Central Table   GA - Suspense/Fund           correct a suspense line is Go, Process Financial Information, process Journals, Use,
JRNL_SUSP_CORR               JRNL_S_HDR_SRCH       BUSINESS_UNIT       Business Unit                 #71092          Balancing Accounts           Journal Suspense Correction.
                                                                                                                                                  Other fields used in PS "Journal Suspense Correction process." (Same Navigation
                                                                                                                                                  as "Journal Suspense Correction Process ".) Please note: To identify any fields not
                                                                                                                                                  appearing in the panel use "Application Designer".
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        ACCOUNT             Account
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        AFFILIATE           Affiliate                                                                                                             "
JRNL_SUSP_CORR               JRNL_SUS_WK           ASSIGN_FLG          Assign                                                                                                                "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        BUDGET_PERIOD       Budget Period                                                                                                         "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        CLASS_FLD           Class                                                                                                                 "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        CURRENCY_CD         Currency Code                                                                                                         "
JRNL_SUSP_CORR               JRNL_SUS_WK           CURRENCY_CD         Currency Code                                                                                                         "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        DEPTID              Department                                                                                                            "
JRNL_SUSP_CORR               JRNL_SUS_HDR_VW       DESCR254            Long Description                                                                                                      "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        FOREIGN_AMOUNT      Foreign Amount                                                                                                        "
JRNL_SUSP_CORR               JRNL_SUS_WK           FOREIGN_AMT_CR      Credit Amount                                                                                                         "
JRNL_SUSP_CORR               JRNL_SUS_WK           FOREIGN_AMT_DR      Debit Amount                                                                                                          "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        FOREIGN_CURRENCY    Foreign Currency Code                                                                                                 "
JRNL_SUSP_CORR               JRNL_SUS_WK           FOREIGN_CURRENCY    Foreign Currency Code                                                                                                 "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        FUND_CODE           Fund                                                                                                                  "




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls    11/10/2010                                                  7
       Panel Name                   Record                Field Name                Field Long Name      UD Database          UD Field Name                                               Comments
JRNL_SUSP_CORR               JRNL_SUS_HDR_VW       JOURNAL_DATE         Journal Date                                                                                                         "
JRNL_SUSP_CORR               JRNL_S_HDR_SRCH       JOURNAL_DATE         Journal Date                                                                                                         "
JRNL_SUSP_CORR               JRNL_SUS_HDR_VW       JOURNAL_ID           GL Journal ID                                                                                                        "
JRNL_SUSP_CORR               JRNL_S_HDR_SRCH       JOURNAL_ID           GL Journal ID                                                                                                        "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        LEDGER               Ledger                                                                                                               "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        MONETARY_AMOUNT      Monetary Amount                                                                                                      "
JRNL_SUSP_CORR               JRNL_SUS_WK           MONETARY_AMT_CR      Credit Base Amount                                                                                                   "
JRNL_SUSP_CORR               JRNL_SUS_WK           MONETARY_AMT_DR      Debit Base Amount                                                                                                    "
JRNL_SUSP_CORR               JRNL_S_DOCSQ_WK       PB_DOC_SEQ           Document Sequencing                                                                                                  "
JRNL_SUSP_CORR               JRNL_SUS_WK           PB_ERRORS            Display Errors                                                                                                       "
JRNL_SUSP_CORR               JRNL_SUS_WK           PB_GOTO_JRNL_ENTR2   Go To New Journal                                                                                                    "
JRNL_SUSP_CORR               JRNL_SUS_WK           PB_GOTO_JRNL_ENTRY   Go To Original Journal                                                                                               "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        PROGRAM_CODE         Program                                                                                                              "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        PROJECT_ID           Project/Grant                                                                                                        "
JRNL_SUSP_CORR               JRNL_S_HDR_SRCH       SOURCE               Source                                                                                                               "
JRNL_SUSP_CORR               GL_ACCOUNT_TBL        STATISTICS_ACCOUNT   Statistical Account                                                                                                  "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        STATISTICS_CODE      Statistics Code                                                                                                      "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        STATISTIC_AMOUNT     Statistic Amount                                                                                                     "
JRNL_SUSP_CORR               JRNL_SUS_LN_VW        SUSPENDED_LINE       Suspended Journal Line Number                                                                                        "
JRNL_SUSP_CORR               JRNL_SUS_WK           SUSPENDED_LINE       Suspended Journal Line Number                                                                                        "
JRNL_SUSP_CORR               JRNL_SUS_WK           UNIT_OF_MEASURE      Unit of Measure                                                                                                      "

                                                                                                                                                    We believe the funding source used with the Project/Grant Chartfield can be used
                                                                                                                                                    for UD Plant Funds to replace Central table #72018 -- GA-Plant Fund Source Code
                                                                                                                                                    Description. Funding source is not a Chartfield but is used with the Project/Grant
                                                                                                                                                    Chartfield to indicate where monies originated for a particular project or grant. The
                                                                                                                                                    system maintains the maximum funding source amount at all times. Per the Chart of
                                                                                                                                                    Accounts Committee, we will denote source of funds for 8-books through PS
                                                                                                        Central Table   GA - Plant Fund Source      account and through Projects. The PS path is Go, Define Business Rules, Define
FUNDING_SOURCE               FUND_SOURCE_TBL       FUND_SOURCE          Funding Source                  #72018          Code Descriptions           General Options, Use E-P, Funding Source, Update/Display.

                                                                                                                                                    Data elements "Batch-Code-ID" and "SRTMAT-Batch" use the same unique
                                                                                                                                                    'ALPHA' characters to identify batches being processed from a sub-system into the
                                                                                                                                                    General Ledger. For example, "Easy Forms Journal Vouchers" sub-system uses
                                                                                                                                                    "GAEZJVS" for both Batch-Code-ID and SRTMAT-Batch. We believe these fields
                                                                                                                        BATCH-CODE-ID               including "Batch-Number" are similar to PS "Run control ID" and "Process
                                                                                                                        SRTMAT-BATCH                Parameters" that are a part of PS Process Scheduler. Go, Process Financial
JRNL_GEN_REQUEST             JRNLGEN_REQUEST       RUN_CNTL_ID          Run Control ID                  SRTMAT          BATCH-NUMBER                Information, Process Journals, Process, Journal Generator, Update/Display

                                                                                                                                                    Central Table #72102 is used to control journal voucher statement date for
                                                                                                                                                    Electronic journal voucher processing. This is a feature that gives the journal
                                                                                                                                                    voucher originator the flexibility to prepare JV's for the current month or for up to 11
                                                                                                                                                    months in advance. The journal voucher originator selects the appropriate fiscal
                                                                                                                                                    month from the drop down box on the electronic JV and submits as usual. The
                                                                                                                                                    system will release the JV's to be approved within the month selected. A similar
                                                                                                                                                    feature in PS called 'Schedules' allows you to create schedules that you can use to
                                                                                                                                                    automate and control the generation of Standard Journal Entries. You can define
                                                                                                                                                    daily, weekly, monthly, annual, or user-defined schedules. The schedule indicates to
                                                                                                                                                    the system the date to be placed on the standard journals when they are created.
                                                                                                                                                    Schedules control the frequency of processing. The PS path is Go, Define Business
                                                                                                        Central Table   Table #72102 -- GA -        Rules, Define General Options, Use R-Z, Schedules, Add, (type in a Schedule ID),
SCHEDULE                     SCHEDULE_TBL          AUGUST               August                          #72102          Statement Date JV Control   ok
SCHEDULE                     SCHEDULE_TBL          APRIL                April                                                                       Other fields used in PS "Schedules." (Same Navigation as "Schedules".) Please
SCHEDULE                     SCHEDULE_TBL          SETID                SetID                                                                       note: To identify any fields not appearing in the panel use "Application Designer".
SCHEDULE                     SCHEDULE_TBL          JUNE                 June                                                                                                                     "
SCHEDULE                     SCHEDULE_TBL          MONTHCD              Month                                                                                                                    "
SCHEDULE                     SCHEDULE_TBL          NOVEMBER             November                                                                                                                 "
SCHEDULE                     SCHEDULE_TBL          OCTOBER              October                                                                                                                  "
SCHEDULE                     SCHEDULE_TBL          SAT                  Saturday                                                                                                                 "
SCHEDULE                     SCHEDULE_TBL          MAY                  May                                                                                                                      "
SCHEDULE                     SCHEDULE_TBL          SEPTEMBER            September                                                                                                                "




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls    11/10/2010                                                     8
      Panel Name                   Record               Field Name              Field Long Name    UD Database          UD Field Name                                                 Comments
SCHEDULE                     GL_PANELS_WRK        MAX_EVENT           Maximum event occurrence                                                                                           "
SCHEDULE                     SCHEDULE_TBL         SUN                 Sunday                                                                                                             "
SCHEDULE                     SCHEDULE_TBL         THURS               Thursday                                                                                                           "
SCHEDULE                     EVENTS_TBL           TIME_HH             Time - Hour                                                                                                        "
SCHEDULE                     EVENTS_TBL           TIME_MM             Time - Minute                                                                                                      "
SCHEDULE                     SCHEDULE_TBL         TUES                Tuesday                                                                                                            "
SCHEDULE                     SCHEDULE_TBL         WED                 Wednesday                                                                                                          "
SCHEDULE                     SCHEDULE_TBL         SCHEDULE            Schedule ID                                                                                                        "
SCHEDULE                     SCHEDULE_TBL         FEBRUARY            February                                                                                                           "
SCHEDULE                     SCHEDULE_TBL         DAY_OF_WK           Day of the Week                                                                                                    "
SCHEDULE                     SCHEDULE_TBL         DECEMBER            December                                                                                                           "
SCHEDULE                     EVENTS_TBL           DESCR               Description                                                                                                        "
SCHEDULE                     SCHEDULE_TBL         DESCR               Description                                                                                                        "
SCHEDULE                     SCHEDULE_TBL         DESCRLONG           Description                                                                                                        "
SCHEDULE                     SCHEDULE_TBL         MON                 Monday                                                                                                             "
SCHEDULE                     EVENTS_TBL           EVENT_OCCURRENCE    Event Occurrence                                                                                                   "
SCHEDULE                     SCHEDULE_TBL         DAY_OF_MONTH        Day of the Month                                                                                                   "
SCHEDULE                     SCHEDULE_TBL         FREQUENCY           Frequency                                                                                                          "
SCHEDULE                     SCHEDULE_TBL         FRI                 Friday                                                                                                             "
SCHEDULE                     SCHEDULE_TBL         JANUARY             January                                                                                                            "
SCHEDULE                     SCHEDULE_TBL         JULY                July                                                                                                               "
SCHEDULE                     SCHEDULE_TBL         LAST_DAY_OF_MONTH   Last Day of the Month                                                                                              "
SCHEDULE                     SCHEDULE_TBL         MARCH               March                                                                                                              "
SCHEDULE                     EVENTS_TBL           EVENT_DT            Event Date                                                                                                         "
                                                                                                     Central
                                                                                                  Table #50100,
                                                                                                  50101, 71099,
                                                                                                  72007, 72008,
                                                                                                  72009, 72010,
                                                                                                  72028, 72040,    Table #50100-- GA - Fringe
                                                                                                  72041, and      Benefit Rates by Category,
                                                                                                  SRTMAT          Table #50101 -- GA - Fringe
                                                                                                                  Benefit Function/Account
                                                                                                                  Conversion, Table #71099 --
                                                                                                                  GA - Overhead Worker
                                                                                                                  Compensation Rate, Table
                                                                                                                  #72007 -- GA - Overhead
                                                                                                                  Method Description, Table
                                                                                                                  #72008 -- GA - Salary Base
                                                                                                                  Fringe Benefit Accumulation,
                                                                                                                  Table #72009 -- GA -           Central table numbers 50100, 50101, 71099, 72007, 72008, 72009, 72010, 072028,
                                                                                                                  Indirect Cost Distribution,    72040, 72041, and SRTMAT--FRINGE-INDIRECT-INDIC all contain various pieces
                                                                                                                  and Table #72010 -- GA -       of data and methodology used by the UD Overhead/Fringe Benefit program for the
                                                                                                                  Overhead and Fringe            calculation and distribution of monthly overhead return and fringe benefits expense.
                                                                                                                  Source ID, Table #72028 --     We believe PS Grants will be used to calculate and distribute monthly overhead
                                                                                                                  GA - Salary Base Fringe        return (F&A Costs). The PS Grants module is delivered with a process that will
                                                                                                                  Benefit Accumulation #2,       automatically calculate and store facilities and administration (F&A) rates.
                                                                                                                  Table #72040 -- GA -           This process calculates F&A on the applicable sponsor-funded amounts and also
                                                                                                                  Overhead: Map Basic            enables you to calculate waived and cost-shared F&A amounts. The F&A process
                                                                                                                  Revenue Accounts, Table        in PS Grants uses a F&A base tree to identify the accounts under each F&A base
                                                                                                                  #72041 -- GA - Overhead:       that are subject to F&A. Once you designate the base on the tree that will be used,
                                                                                                                  Map Self-Funded                you can then establish the effective dated F&A rates to be used in the calculations.
                                                                                                                  Supplemental Accounts, and     We also believe the PS "Allocation Process" could be used to calculate and
                                                                                                                  SRTMAT -- FRINGE-              distribute monthly fringe benefit expense. The PS navigation paths for both F&A
                                                                                                                  INDIRECT-INDIC.                grants set up and Allocation Process are listed below:
                                                                                                                                                 Go, Define Business Rules, Establish Business Units, Use A-M , F&A Options, F&A
GM_FA_OPTIONS                BUS_UNIT_TBL_GL      BUSINESS_UNIT       Business Unit                                                              Options
                                                                                                                                                 Other fields used in PS "F&A Options." (Same Navigation as "F&A".) Please note:
                                                                                                                                                 To identify any fields not appearing in the panel use "Application Designer".
GM_FA_OPTIONS                GM_FA_OPTIONS2       CHARTFIELD          ChartField
GM_FA_OPTIONS                GM_LBL_WRK           CS_CHARTFIELD_LBL   CS ChartField                                                                                                        "
GM_FA_OPTIONS                GM_FA_OPTIONS        DUE_FROM_ACCOUNT    Due From Account                                                                                                     "
GM_FA_OPTIONS                GM_FA_OPTIONS        DUE_TO_ACCOUNT      Due To Account                                                                                                       "




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls   11/10/2010                                                9
      Panel Name                    Record               Field Name               Field Long Name        UD Database       UD Field Name                                         Comments
GM_FA_OPTIONS                GM_FA_CFS_VW         EDITTABLE            Edit Table                                                                                                     "
GM_FA_OPTIONS                DERIVED              EDIT_FA_CS_CF        CS Chartfield Edit Table                                                                                       "
GM_FA_OPTIONS                GM_FA_OPTIONS        FA_ACCOUNT           F&A Account                                                                                                    "
GM_FA_OPTIONS                GM_LBL_WRK           FA_ACCOUNTS_GB       F&A Accounts                                                                                                   "
GM_FA_OPTIONS                GM_LBL_WRK           FA_BASETREE_GB       Base Tree Info                                                                                                 "
GM_FA_OPTIONS                GM_FA_OPTIONS        FA_CALC_COSTSHARED   Cost Shared F&&A                                                                                               "
GM_FA_OPTIONS                GM_LBL_WRK           FA_CALC_OPTS_GB      F&A Calculation Options                                                                                        "
GM_FA_OPTIONS                GM_FA_OPTIONS        FA_CALC_SPONSOR      Sponsor F&&A                                                                                                   "
GM_FA_OPTIONS                GM_FA_OPTIONS        FA_CALC_WAIVED       Waived F&&A                                                                                                    "
GM_FA_OPTIONS                GM_LBL_WRK           FA_COSTSHR_GB        Cost Sharing                                                                                                   "
GM_FA_OPTIONS                GM_FA_OPTIONS3       FA_CS_FROM_VALUE     Chartfield From Value                                                                                          "
GM_FA_OPTIONS                GM_FA_OPTIONS3       FA_CS_TO_VALUE       Chartfield To Value                                                                                            "
GM_FA_OPTIONS                GM_FA_OPTIONS        FA_OFFSET            F&A Offset Account                                                                                             "
GM_FA_OPTIONS                GM_FA_OPTIONS        TREE_NAME            Tree Name                                                                                                      "
GM_FA_OPTIONS                GM_FA_OPTIONS        TREE_SETID           Tree SetID                                                                                                     "
GM_FA_OFFSET                 GM_FA_OFFSET         BUSINESS_UNIT        Business Unit                                                                                                  "
GM_FA_OFFSET                 GM_FA_OFFSET         CLASS_FLD            Class                                                                                                          "
GM_FA_OFFSET                 GM_FA_OFFSET         DEPTID               Department                                                                                                     "
GM_FA_OFFSET                 CLASS_TBL            DESCR                Description                                                                                                    "
GM_FA_OFFSET                 DEPARTMENT_TBL       DESCR                Description                                                                                                    "
GM_FA_OFFSET                 DEPARTMENT_TBL       DESCR                Description                                                                                                    "
GM_FA_OFFSET                 FUND_TBL             DESCR                Description                                                                                                    "
GM_FA_OFFSET                 PROGRAM_TBL          DESCR                Description                                                                                                    "
GM_FA_OFFSET                 STAT_TBL             DESCR                Description                                                                                                    "
GM_FA_OFFSET                 GM_LBL_WRK           FA_OFFSETS_GB        F&A Offsets                                                                                                    "
GM_FA_OFFSET                 GM_FA_OFFSET         FUND_CODE            Fund                                                                                                           "
GM_FA_OFFSET                 GM_FA_OFFSET         MAJOR_SUBDIVISION    Major Subdivision ID                                                                                           "
GM_FA_OFFSET                 GM_FA_OFFSET         PROGRAM_CODE         Program                                                                                                        "
GM_FA_OFFSET                 GM_FA_OFFSET         STATISTICS_CODE      Statistics Code                                                                                                "
                                                                                                                                           Go, Process Financial Information, Perform Allocations, Use, Allocations, Type,
                                                                                                                                           Update/Display, Choose Univ for Set ID, Ok, Ok, Ok. Other Panels used to perform
                                                                                                                                           Allocations are: Pool, Basis, Target, Target Balance, Offset, Offset Balance,
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       SETID                SetID                                                               Journal Options, Batch Records, and Amount Fields.
                                                                                                                                           Other fields used in PS "Allocation Options." (Same Navigation as "Allocations".)
                                                                                                                                           Please note: To identify any fields not appearing in the panel use "Application
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       EXTENSION_OPCODE     Extension opcode                                                    Designer".
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       EXTENSION_OPCODE     Extension opcode                                                                                               "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       EXTENSION_OPCODE     Extension opcode                                                                                               "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       ALLOC_TYPE           Allocation Type                                                                                                "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       ALLOC_TYPE           Allocation Type                                                                                                "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       EXTENSION_OPCODE     Extension opcode                                                                                               "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       ALLOC_TYPE           Allocation Type                                                                                                "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       EFF_STATUS           Status as of Effective Date                                                                                    "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       EFFDT                Effective Date                                                                                                 "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       EXTENSION_OPCODE     Extension opcode                                                                                               "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       BUDGET_COPY          Budget Copy Flag                                                                                               "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       INTER_UNIT_ALLOC     Inter Business Unit Allocation                                                                                 "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       PROCESS_STEP         Process Step                                                                                                   "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       DESCR                Description                                                                                                    "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       ALLOC_TYPE           Allocation Type                                                                                                "
ALLOC_CALC_OPTN              ALLOC_STEP_TBL       ALLOC_TYPE           Allocation Type                                                                                                "
                                                                                                                                           Data element "TRAN-BRWSE-SEQ" is a field used to identify the transaction
                                                                                                                                           sequence format of a SRTMAT transaction. The sequence is statement date,
                                                                                                                                           account code, object code, line number, and transaction date. We believe the
                                                                                                                                           format sequence used with PS "Journal Entry Lines" is similar to "TRAN-BRWSE-
                                                                                                                                           SEQ". The PS path is GO, Process Financial Information, Process Journals, Use,
JOURNAL_ENTRY2               JRNL_PANELS_WRK      LINE_NBR             Line Number                      SRTMAT         TRAN-BRWSE-SEQ      Journal entry, Lines, Update/Display, OK, OK.
JOURNAL_ENTRY2               JRNL_LN              LEDGER               Ledger                                                                                                         "
JOURNAL_ENTRY2               JRNL_LN              BUSINESS_UNIT        Business Unit                                                                                                  "
JOURNAL_ENTRY2               JRNL_HEADER_IU       BUSINESS_UNIT        Business Unit                                                                                                  "
JOURNAL_ENTRY2               BCM_XFER_WRK         BUSINESS_UNIT        Business Unit                                                                                                  "
JOURNAL_ENTRY2               JRNL_LN              GFEE_ENTRY_EVENT     Entry Event                                                                                                    "




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls   11/10/2010                                                     10
      Panel Name                    Record               Field Name               Field Long Name      UD Database   UD Field Name                                        Comments
JOURNAL_ENTRY2               JRNL_LN              ACCOUNT              Account                                                                                                  "
JOURNAL_ENTRY2               JRNL_LN              FUND_CODE            Fund                                                                                                     "
JOURNAL_ENTRY2               JRNL_LN              DEPTID               Department                                                                                               "
JOURNAL_ENTRY2               JRNL_LN              PROGRAM_CODE         Program                                                                                                  "
JOURNAL_ENTRY2               JRNL_LN              CLASS_FLD            Class                                                                                                    "
JOURNAL_ENTRY2               JRNL_LN              BUDGET_PERIOD        Budget Period                                                                                            "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      BP_OVERRIDE_SHOW     BP Override                                                                                              "
JOURNAL_ENTRY2               FUNCLIB_PCINTFC      PC_FIELDS            Projects                                                                                                 "
JOURNAL_ENTRY2               JRNL_LN              AFFILIATE            Affiliate                                                                                                "
JOURNAL_ENTRY2               JRNL_LN              FOREIGN_AMOUNT       Foreign Amount                                                                                           "
JOURNAL_ENTRY2               JRNL_LN              STATISTICS_CODE      Statistics Code                                                                                          "
JOURNAL_ENTRY2               JRNL_LN              LINE_DESCR           Journal Line Description                                                                                 "
JOURNAL_ENTRY2               XLATTABLE            XLATLONGNAME         Translate Long Name                                                                                      "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      SPEEDTYPE_SHOW       Show SpeedType Edit Box                                                                                  "
                                                                                                                                     Other fields used in PS "Journal Entry Lines" (Same Navigation as "Journal Entry
                                                                                                                                     Lines".) Please note: To identify any fields not appearing in the panel use
JOURNAL_ENTRY2               JRNL_LN              BCM_POST_AMOUNT      BCM Post Amount                                               "Application Designer".
JOURNAL_ENTRY2               JRNL_PANELS_WRK      BUDGET_AMOUNT_TYPE   Budget Amount Type                                                                                       "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_BUDG_CHK          Budget Check                                                                                             "
JOURNAL_ENTRY2               JRNL_HEADER_IU       BCM_HDR_STATUS       Budget Checking Header Status                                                                            "
JOURNAL_ENTRY2               JRNL_LN              BCM_LINE_STATUS      Budget Checking Line Status                                                                              "
JOURNAL_ENTRY2               BCM_XFER_WRK         APPLICATION_TO_BCM   Budget Control Exception                                                                                 "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_COPY              Copy Journal                                                                                             "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      MONETARY_AMT_CR      Credit Base Amount                                                                                       "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      FOREIGN_AMT_CR       Credit Amount                                                                                            "
JOURNAL_ENTRY2               JRNL_LN              CURRENCY_CD          Currency Code                                                                                            "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      MONETARY_AMT_DR      Debit Base Amount                                                                                        "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      FOREIGN_AMT_DR       Debit Amount                                                                                             "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_DELETE            Delete Journal                                                                                           "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_ERRORS            Display Errors                                                                                           "
JOURNAL_ENTRY2               JRNL_DOCSEQ_WRK      PB_DOC_SEQ           Document Sequencing                                                                                      "
JOURNAL_ENTRY2               DERIVED              EDITTABLE            Edit Table                                                                                               "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      VISUAL_RATE_2        Exchange Rate                                                                                            "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_RATE_DETAIL_2     Exchange Rate Detail                                                                                     "
JOURNAL_ENTRY2               JRNL_LN              FOREIGN_CURRENCY     Foreign Currency Code                                                                                    "
JOURNAL_ENTRY2               BCM_XFER_WRK         JOURNAL_ID           GL Journal ID                                                                                            "
JOURNAL_ENTRY2               JRNL_LN              JOURNAL_LINE         GL Journal Line Number                                                                                   "
JOURNAL_ENTRY2               BCM_XFER_WRK         JOURNAL_DATE         Journal Date                                                                                             "
JOURNAL_ENTRY2               JRNL_HEADER_IU       JRNL_HDR_STATUS      Journal Header Status                                                                                    "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_COPY_DOWN         Journal Line Copy Down                                                                                   "
JOURNAL_ENTRY2               JRNL_LN              JRNL_LINE_STATUS     Journal Line Status                                                                                      "
JOURNAL_ENTRY2               JRNL_HEADER_IU       JRNL_TOT_CREDITS     Journal Total Credits                                                                                    "
JOURNAL_ENTRY2               JRNL_HEADER_IU       JRNL_TOTAL_DEBITS    Journal Total Debits                                                                                     "
JOURNAL_ENTRY2               JRNL_HEADER_IU       JRNL_TOTAL_LINES     Journal Total Lines                                                                                      "
JOURNAL_ENTRY2               FUNCLIB_FS           LANGUAGE_CD          Language Code                                                                                            "
JOURNAL_ENTRY2               JRNL_LN              MONETARY_AMOUNT      Monetary Amount                                                                                          "
JOURNAL_ENTRY2               JRNL_LN              MOVEMENT_FLAG        Movement Flag                                                                                            "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      OPEN_ITEM_KEY        Open Item Key                                                                                            "
JOURNAL_ENTRY2               GL_PANELS_WRK        PRINT_FRGN_JRNL      Print                                                                                                    "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_EDIT              Process Edits                                                                                            "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      ERRORS_ONLY          Process Errors Only                                                                                      "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_POST              Process Posting Functions                                                                                "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_GO                Process With Selected Fields                                                                             "
JOURNAL_ENTRY2               JRNL_LN              PROJECT_ID           Project/Grant                                                                                            "
JOURNAL_ENTRY2               JRNL_LN              RT_TYPE              Rate Type                                                                                                "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_REFRESH           Refresh Pushbutton                                                                                       "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_SECONDARY         Secondary Lines                                                                                          "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_FIRST_ROW         Select First Row of Data                                                                                 "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_LAST_ROW          Select Last Row of Data                                                                                  "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_NEXT_GRP          Select Next Group of Rows                                                                                "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_PREVIOUS_GRP      Select Previous Group of Rows                                                                            "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      SETID                SetID                                                                                                    "




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls   11/10/2010                                                   11
      Panel Name                    Record               Field Name              Field Long Name       UD Database           UD Field Name                                               Comments
JOURNAL_ENTRY2               JRNL_LN              STATISTIC_AMOUNT    Statistic Amount                                                                                                      "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_SUBMIT           Submit for Approval                                                                                                   "
JOURNAL_ENTRY2               JRNL_LN              SUSPENDED_LINE      Suspended Journal Line Number                                                                                         "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      TREE_LEVEL_NUM      Tree Level Number                                                                                                     "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      TREE_NAME           Tree Name                                                                                                             "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      UNIT_OF_MEASURE     Unit of Measure                                                                                                       "
JOURNAL_ENTRY2               JRNL_PANELS_WRK      PB_VAT_SIBLING      VAT Sibling Record Fields                                                                                             "
                                                                                                      SRTMAT           ORIG-REC-TRAN
                                                                                                                                                    UD data element "ORIG-REC-TRAN" is a field used to record the exact date and
                                                                                                                                                    time (in hours, minutes and seconds) when a transaction was actually processed in
                                                                                                                                                    the UD General Ledger. We believe the journal generator used in PS to post journal
                                                                                                                                                    entries to the PS General Ledger will provide a similar record of date and time. The
                                                                                                                                                    PS path for Journal Generator processing is Go, Process Financial Information,
JRNL_GEN_REQUEST             JRNL_GEN_REQUEST     PROCESS_FREQUENCY   Process Frequency                                                             Process Journals, Process, Journal Generator, Add or Update/Display.
                                                                                                      GABAL file       Rpt-Type                      No Match. Data element "RPT-TYPE" contains the following valid values: '01' =
                                                                                                                                                    General Ledger, '02' = Current Budget, '04' = Fund Operations, and '08' = Project-to-
                                                                                                                                                    Date. We believe similar 'RPT-TYPES can be created in a PS Data Warehouse by
                                                                                                                                                    using PS Chartfield Values 'Fund' and 'Account'.
                                                                                                      Central Tables   Table #50500 and 50501 --    No match. Per the Chart of Accounts Committee, at this time no effort has been
                                                                                                      #50500, 50501,   General Accounting Fund      made to duplicate the existing University's fund-types within the PS chart of
                                                                                                      50300, and       Types; Table #50300 --       accounts logic. A possible solution could be to use PS trees to identify and
                                                                                                      72015            Categories by Fund Type;     accumulate data for different fund-types.
                                                                                                                       and Table #72015 -- GA -
                                                                                                                       Fund Type Descriptions
                                                                                                      GABAL file       Bal-Encum-Count              No match. We believe similar "Counts" can be obtained through the various PS
                                                                                                                       Bal-Tran-Count               reporting tools such as PS query, iVision, and the Data Warehouse specifically
                                                                                                                       Budgt-Perm-Tran-Count        created to be used with PS financial data.
                                                                                                                       Budgt-Temp-Tran-Count
                                                                                                      Central Table    GA - Employee Class Object
                                                                                                      #50000           Codes                        No Match. Central table #50000 maps employee object codes into categories for
                                                                                                                                                    fringe calculations in Fringe Benefit Program (GAP0700). We believe PS "Trees"
                                                                                                                                                    can be used to map employee object codes into categories for fringe calculations.
                                                                                                      GADESCFILE       RPT-NUMBER                    No Match. UD data element RPT-NUMBER is used to produce special reports.
                                                                                                      Central Table    GA-Report Numbers            We think these reports can be produced in PS using Trees.
                                                                                                      #72012           (Gadescfile)
                                                                                                      GADESCFILE       FUND-PURP                    No Match. UD data element FUND-PURP appears to be used to generate a
                                                                                                      Central Table    GA-Reserve Major Group       Reserve Fund balance report committed to 5 digit code used in conjunction with
                                                                                                      #72021           Codes                        Central tables #72020, # 72021, and # 72022 to produce a Fund Balance Report
                                                                                                      #72022           GA-Reserve Report            with unique sorts and breaks. We believe this report could be produced in PS using
                                                                                                      #72020           GA - Reserve report Fund     Trees.
                                                                                                                       Types
                                                                                                      GABAL file       Bal-Encum-Type             No Match. The UD data element "Bal-Encum-Type" has two values: no
                                                                                                                                                 encumbrance or encumbrance exists. This data element is used in adhoc reporting
                                                                                                                                                 to either include or exclude encumbrances. In PS, we believe this field is located in
                                                                                                                                                 the Purchasing and Payroll modules. This data element should be included in our
                                                                                                                                                 PS created Data Warehouse.
                                                                                                      Central Tables   FAI WEB Control Table and No Match. Table number 50102 contains control parameters for the Internal
                                                                                                      #50102 and       FAI WEB Comments Table Charges WEB EZFORM and Service Provider System and Table number 50103
                                                                                                      50103                                      holds comment lines of documentation to customize the FAI page before a specific
                                                                                                                                                 page can be developed for a service. We believe PS "Trees" can be used to
                                                                                                                                                 maintain FAI Web Control Table and FAI Web Comments Table.


                                                                                                      GADESCFILE       MINS-ACCT-14                 No Match. UD data element 'MINS-ACCT-14' is a superdescriptor of MINS Code
                                                                                                                                                    and ACCT-Code-14 used to display accounts within MINS for Departmental
                                                                                                                                                    Accounting account selection. Departmental Accounting will not be used in PS.

                                                                                                      GADESCFILE       STA                          No Match for UD data element STA. Used to physically remove account codes from
                                                                                                                                                    GADESCFILE. We believe that in PS you can never delete a chart field.




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls   11/10/2010                                                    12
        Panel Name                    Record                Field Name   Field Long Name    UD Database          UD Field Name                                             Comments
                                                                                           GADESCFILE      CFW-INDEX & CFW-TRSF- No Match. UD data element CFW-INDEX is a number associating this fund with a
                                                                                           and Central     INDIC; and GA - Carried   group of self-supporting accounts. All the funds which are related will have this
                                                                                           Table #72090    Forward Close-Out Control number. For example, all Food Service accounts may have a number such as 1100.
                                                                                                                                     UD data element CFW-TRSF-INDIC is a value that identifies this fund as the
                                                                                                                                     account through which Profit/Loss is passed in a self-supporting group of accounts.
                                                                                                                                     Central Table #72090 contains Reserve and Allocations account information for a
                                                                                                                                     'Set' (Group) of accounts for year-end close-our of CFW accounts. We believe that
                                                                                                                                     this will be handled in PS by using Trees or the PS 'Allocation' process.

                                                                                           GADESCFILE,     GADESCFILE - TII-PARNT,        No Match. UD data element TII-PARTN in GADESCFILE is the temporary
                                                                                           Central Table   Centra Table #72091 -- GA -    investment income account to which interest earned on this account should be
                                                                                           #72091, and     TII Control Information, and   credited. Usually it is the account itself. However, many times it is another "Parent"
                                                                                           General         General Accounting 'Other      account from which the original dollars came. Central Table #72091 has been
                                                                                           Accounting      Uses' Menu - Temporary         replaced with "General Accounting Other Uses Menu which contains information
                                                                                           'Other Uses'    investment Income Control      required to do temporary investment processing such as period ending date, monthly
                                                                                           Menu            Information                    interest rate, minimum balance to be applied, and journal voucher number. We
                                                                                                                                          believe that this will be handled in PS by using Trees or PS 'Allocation' process.


                                                                                           GADESCFILE      RE-STMT-NUM         No match. Data element "RE-STMT-NUM" contains the account code to which
                                                                                                                               activity is to be transferred. An automatic journal voucher is generated at month-
                                                                                                                               end to transfer activity from the old account to the new account.
                                                                                           GADESCFILE      DGO-PROJECT-ID      No Match. Departments are imputing a project ID in Departmental Accounting (with
                                                                                           SRTMAT          DGO-EXTRACT-CONTROL project ID stored in GADESCFILE and SRTMAT) which allows a department to
                                                                                           SRTMAT          DGO-PROJECT-ID      group a subset of accounts by project as defined by the department. The
                                                                                                                               department admin has access to all codes within a mins code and can in turn set up
                                                                                                                               sub-projects to group codes by a selected faculty person. We believe the
                                                                                                                               Departmental Accounting System will be replaced by a Data Warehouse specifically
                                                                                                                               created to be used with PS financial data.
                                                                                           GABAL file      Stmt-Acct-Obj-line             No Match. These UD data element names are alternate access keys referred to as
                                                                                                           Stmt-Acct-obj                  "super-descriptors" in our GABALFILE data element dictionary. There is not a
                                                                                                           Stmt-Date-Acct                 corresponding field in PS. However, there could be a use for these types of super-
                                                                                                           Stmt-Obj                       descriptors in our PS created data warehouse.
                                                                                                           Stmt-Unit-Acct-Code
                                                                                                                                          No Match. The UD data element "Last-UPD" is the date the record was last
                                                                                                                                          updated. This is the date used in our General Ledger Trial Balance to indicate "Last
                                                                                           GABAL file      Last-Upd                       Activity".
                                                                                           GABAL file
                                                                                           SRTMAT          Line-Num                       No Match. Potentially we might use account for UD data element line number.
                                                                                           GATRANFILE      GAT-LINE-NUM                   Currently, no decision has been made to track 'People' versus 'Positions' in PS.
                                                                                                                                          No match. The UD data element "Acct-Kind" contains the following valid values: 00
                                                                                                                                          = General Ledger, 11 = Current Budget - Basic, 12 = Current budget - Carried
                                                                                                                                          Forward, 13 = Allocated, 14 = Restricted - Funds 03, 04, and 94 = Restricted -
                                                                                           SRTMAT          ACCT-KIND                      Other. We believe similar values can be created in a PS Data Warehouse by using
                                                                                           GATRANFILE      GAT-ACCT-KIND                  PS Chartfield Value "Funds".
                                                                                                                                          No match. The UD data element "GAT-USER-DB" is a field used by "Supernatural"
                                                                                                                                          users to create their own 'Database" for a limited period of time. This data element
                                                                                           GATRANFILE      GAT-USER-DB                    will not be needed in the PS created Data Warehouse.
                                                                                           GADESCFILE      ACCT-CODE                      No Match for UD data element ACCT-CODE in PS. In PS there is a string of
                                                                                           SRTMAT          ACCT-CODE                      chartfields that equate to our 11 digit account code.
                                                                                           GATRANFILE      GAT-ACCT-CODE
                                                                                           GABALFILE       ACCT-CODE
                                                                                           GADESCFILE      MINS-CODE              No match. We believe UD data element MINS-CODE and all the data element fields
                                                                                           and MINS        MINS-KEY-PNTR; MINS-   in the "MINS" data element dictionary WILL BE REPLACED BY Trees in PS.
                                                                                                           PNTR-KEY; MINS-KEY;
                                                                                                           MINS-PNTR; MINS-ADMIN;
                                                                                                           MINS-DESC; MINS-UP-
                                                                                                           PRFLE; MINS-DOWN-
                                                                                                           PRFLE; and MINS-USER




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls       11/10/2010                                     13
        Panel Name                    Record                Field Name   Field Long Name    UD Database          UD Field Name                                                Comments
                                                                                           Central Table   GA - Daily Trial Control
                                                                                           #71093          Acounts                       No match. The GA Daily Trial Control Accounts consist of 1 and 2 book
                                                                                                                                         revenue/expenditure control accounts for University and State budgeted funds only(
                                                                                                                                         1-9-91-100; 1-9-91-200; 1-9-92-100; 1-9-92-200; 1-9-92-300; 1-9-92-400; 2-9-91-
                                                                                                                                         100;2-9-92-100; and 2-9-92-300). At this time, the Chart of Accounts Committee
                                                                                                                                         believes this will be a calculated on-the-fly reported summary and that PS allows for
                                                                                                                                         an automatic balancing. The Control Accounts also consist of Purchasing and
                                                                                                                                         Payroll encumbrance control accounts (X-9-40-0000-00-000 and X-9-41-0000-00-
                                                                                                                                         200). We believe the daily trial control accounts can be set up in PS accounts and
                                                                                                                                         PS trees can be used to maintain these accounts for daily trial reporting.
                                                                                           Central Table   GA - Asset/Liability Sub-
                                                                                           #71094, 71095   Headings, Asset/Liability No match. Per the Chart of Accounts Committee, asset/liability major headings, sub-
                                                                                           and 71096                                 headings, and titles have been designed in PS chartfield account logic with new
                                                                                                           Titles, and Asset/Liability
                                                                                                           Major-Headings            categories that follow FASB reporting. The new categories are designed to provide
                                                                                                                                     (tree leaf) ranges which roll up and that should allow trial balances and balance
                                                                                                                                     sheets to take advantage of tree reporting. This would allow us to maintain our
                                                                                                                                     current UD major-headings, sub-headings and titles for reporting purposes.
                                                                                           Central Table  GA - Statement of Changes No match. Table #71098 defines assignment of object codes to columns for
                                                                                           #71098, 72023, Column Definition; GA -    selected fund-types in the Statement of Changes report. Table #72023 defines
                                                                                           and 72024      Summary of Changes         assignment of fund/types to columns for selected object codes in the Summary of
                                                                                                          Column definition; and GA- Changes Report portion of the Statement of Changes. Table #72024 defines
                                                                                                          Summary of Changes Row assignment of object codes to rows for summary fund types in the Summary of
                                                                                                          Definition                 Changes Report portion of the Statement of Changes. We believe a similar report
                                                                                                                                     can be developed by using PS tree reporting.
                                                                                           Central Table  GA - Unidel Awards and GA- No match. A special UD program was developed to handle our Unidel Foundation
                                                                                           #72000 and     Unidel Project Amounts and annual reporting requirements. Central table #72000 contains the Unidel award
                                                                                           72011          Descriptions               code and award amount. Central table #72011 contains entries for each award ID
                                                                                                                                     plus the parent award. A description is entered for the first award in a series. The
                                                                                                                                     award amount is entered for each award. The key is parent award ID plus individual
                                                                                                                                     award ID. We believe PS "Trees" could be used to maintain the Unidel data
                                                                                                                                     contained in these tables.
                                                                                           Central Table  GA - Description File      No match. We believe PS "Trees" will be used to control system security and
                                                                                           #72001 and     Administrator Signature    ,therefore, could be used to control description file administrator signature
                                                                                           72002          Conversion and GA-         conversion and description file signature authority codes.
                                                                                                          Description Signature
                                                                                                          Authority Codes

                                                                                           Central Table   GA - Source Code              No match. Per the Chart of Accounts Committee, the current use of source and
                                                                                           #72016          Descriptions                  object is a duplication. The PS Chart design purposely does not intend to carry the
                                                                                                                                         duplication forward. Therefore, no other PS chartfield values will be associated with
                                                                                                                                         PS Revenue accounts. Other chartfield values (such as Dept) may be assigned.
                                                                                                                                         However, remember that in PS, the only required value is PS account, and that may
                                                                                                                                         be all we use for some University-wide revenues.
                                                                                           Central Table   Table #72200 -- DA -         No match. Central table numbers 72200, 72201, 72202, 72203, and 72204 are used
                                                                                           #72200,         Application Variables; Table to control the extraction of transactions from SRTMAT to the Departmental
                                                                                           72201,72202,    #72201 -- DA - GA            Accounting System. We believe the Departmental Accounting System will be
                                                                                           72203, and      Trans.Extract Date Control; replaced by a Data Warehouse specifically created to be used with PS financial
                                                                                           72204           Table #72202 -- DA - Table data.
                                                                                                           of Account Extract and
                                                                                                           Access; Table #72203 -- DA -
                                                                                                           SSN Account List; and Table
                                                                                                           #72204 -- DA - Document
                                                                                                           Type Descriptions




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls       11/10/2010                                     14
        Panel Name                    Record                Field Name   Field Long Name    UD Database            UD Field Name                                                  Comments
                                                                                           Central Table    Table #90018 -- User Group      No match. Central Table numbers 90018, 90028, 90030, 91003, 91008, 91018,
                                                                                           #90018, 90028,   Assignment - general            91028, 91030, 91036, 92003, and 92008 are all used to control User Security
                                                                                           90030, 91003,    Accounting; Table #90028 --     Access to GA Query, Purchasing Query, and the Data Warehouse. We believe PS
                                                                                           91008, 91018,    User Group Assignment -         "Trees" will be used to control user security access.
                                                                                           91028, 91030,    GA History; Table #90030 --
                                                                                           91036, 92003,    User group Assignment - GA
                                                                                           92008            GABAL; Table #91003 --
                                                                                                            Group Options Assignment -
                                                                                                            Batch Control; Table #91008
                                                                                                            -- Group Options
                                                                                                            Assignment - MINS; Table
                                                                                                            #91018 -- Group Options
                                                                                                            Assignment - General
                                                                                                            Accounting; Table #91028 --
                                                                                                            Group Options Assignment -
                                                                                                            Dept. Obligations; Table
                                                                                                            #91030 -- Group Options
                                                                                                            Assignment - GA GABAL;
                                                                                                            Table #91036 -- Group
                                                                                                            Options Assignment -
                                                                                                            Computer User ACTG;
                                                                                                            Table #92003 -- Option
                                                                                                            Description - Batch Control;
                                                                                                            Table #92008 -- Option
                                                                                                            description - MINS;




                                                                                           92018, 92028,     Table #92018 -- Option         No match. Central Table numbers 92018, 92028, 92030, 92036, 97001, 97018, and
                                                                                           92030, 92036,    Descriptions - General          98001 are all used to control User Security Access to GA Query, Purchasing Query,
                                                                                           97001, 97018,    Accounting; Table #92028 --     and the Data Warehouse. We believe PS "Trees" will be used to control user
                                                                                           and 98001        Option Descriptions - DEPT.     security access.
                                                                                                            Obligations; Table #92030 --
                                                                                                            Option Descriptions - GA
                                                                                                            GABAL; Table #92036 --
                                                                                                            Option descriptions -
                                                                                                            Computer User ACTG;
                                                                                                            Table #97001 -- MINS User
                                                                                                            Access - GAQRY; Table
                                                                                                            #97018 -- Non-Menu User
                                                                                                            Access - General
                                                                                                            Accounting; and Table
                                                                                                            #98001 -- MINS Value table -
                                                                                                            Account Code




                                                                                           Central Table    Table #72080 -- GA - Ag         No match. Table #72080 contains people to be extracted for the College of
                                                                                           #72080 and       Extract Interface Control and   Agriculture 'Pay Data Extract' who are not in the conventional departmental
                                                                                           General          General Accounting 'Other       sequence for the College (2100 - 2399). The key is social security number and
                                                                                           Accounting       Uses Menu' - College of         writes a workfile of selected Agriculture transactions and prints a report of selected
                                                                                           'Other Uses'     Agriculture Pay Data Extract    transactions. Central Table #72080 has been replaced with 'General Accounting
                                                                                           Menu                                             Other Uses Menu'. We believe that this will be handled in PS by using Trees and
                                                                                                                                            the Data Warehouse that will be created for PS.
                                                                                           Central Table    Table #72050 -- GA -            No match. Per Jim Green, The 1996 comments for central table #72050 states this
                                                                                           #72050           'Treefile' Control              table will show authorized 'Trees' for indicated user, however, this table is not
                                                                                                                                            currently being used. This table could be similar to how we would control 'Trees' for
                                                                                                                                            users in PS.




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls       11/10/2010                                     15
        Panel Name                    Record                Field Name   Field Long Name    UD Database           UD Field Name                                              Comments
                                                                                           Central Table   Table #72081 -- GA - FAMIS
                                                                                           #72081 and      Warehouse SRTMAT           No match. Central Table #72081 controls extract of transactions from SRTMAT for
                                                                                           72082           Extract Control and Table  the GA Data Warehouse. Updated automatically during extract to provide a 'Time
                                                                                                           #72082 -- GA - FAMIS       Stamp' of date and time of last extract. Central Table #72082 provides a control
                                                                                                           Warehouse File Control     report that displays the statement date and gives a count of transactions extracted
                                                                                                                                      from the GABALFILE and SRTMAT file, and provides Attributes count, Administrator
                                                                                                                                      count, Report numbers count, Facilities count, DA balances count, DA transactions
                                                                                                                                      count, Pay Segment count, SIS count, and Control File count for the GA Data
                                                                                                                                      Warehouse. We believe the current GA Data Warehouse will be replaced by a Data
                                                                                                                                      Warehouse specifically created to be used with PS financial data.
                                                                                           Central Table   Table #72100 -- GA -       No match. Central Tables #72100 and 72101 were used to monitor the use of the
                                                                                           #72100 and      'Download' Monitor and     General Accounting download feature and would display the user, date, and date
                                                                                           72101           Table #72101 -- GA -       /time of use of the 'GA' download feature. Per Jim Green, we used this feature
                                                                                                           'Download' Monitor (New)   when downloading or extracting transactions. We quit using it in 1997 which
                                                                                                                                      coincides with the arrival of the first functional Data Warehouse.
                                                                                           Central Table   Table #72092 -- GA -       No match. Central Table #72092 was used by the General Accounting Office for the
                                                                                           #72092          Calendar Year Deferral     fiscal and calendar year-end deferral processing of their calendar year accounts.
                                                                                                           Control                    The calendar year process has been discontinued for several years. It we were to
                                                                                                                                      use this process in the future, we believe PS 'Trees' or the PS 'Allocation' process
                                                                                                                                      could be used.
                                                                                           Central Table   Table #72098 -- GA -       No match. Central Tables numbers 72098 and 72099 are control tables used by
                                                                                           #72098 and      Tranfile Database Control  General Accounting when creating databases for Supernatural processing. The
                                                                                           72099           and Table #72099 -- GA -   tables identifies users, data base limits, and other database identification criteria.
                                                                                                           Tranfile Database          Data base limit indicates the maximum number of concurrent Databases a user can
                                                                                                           information                create. The absolute maximum is 12. We believe Supernatural processing will be
                                                                                                                                      replaced by a Data Warehouse specifically created to be used with PS financial
                                                                                                                                      data.
                                                                                           GABALFILE,      ACCT-GROUP, ACCT-          No match. Data elements "Acct-Group" , "Acct-Kind", and "GAT-ACCT-KIND" all
                                                                                           SRTMAT,         KIND, and GAT-ACCT-KIND contain the following valid values: '00' = General Ledger, '11' = Unrestricted Basic,
                                                                                           GATRANFILE                                 '12' = Unrestricted Carried Forward, '13' = Allocated, '14' = Restricted (Funds 03,04),
                                                                                                                                      and '94' = Restricted Other. We believe the PS Chartfield Values 'Fund' and
                                                                                                                                      'Account' could be used to create a similar 'Acct-Group' in a PS created Data
                                                                                                                                      Warehouse.
                                                                                           SRTMAT          TAPE-NUM                   No match. Per Jim Green , he could not find this data element used anywhere in
                                                                                                                                      GA.
                                                                                           Central Table   Central Tables #72003--GA- The field names listed under "UD Field Name" all contain data elements for
                                                                                           #72003 and      CANG Cost Base Code        Contracts and Grants processes. The General Ledger Team did not compare these
                                                                                           72004,          Descriptions and #72004--  data elements with PS panels or records. It is our understanding that the Grants
                                                                                           SRTMAT,         GA- CANG Award Type        Team will review and compare these data elements.
                                                                                           GABALFILE,      Codes; SRTMAT--CANG-
                                                                                                           AMT; GABALFILE: CANG-
                                                                                                           BUDGT-AMT, CANG-
                                                                                                           GRANT-TO-DATE-ACTL,
                                                                                                           CANG-BAL-AMT, CANG-
                                                                                                           Award-AMT, and CANG-
                                                                                                           COST-SHARE-AMT;




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls       11/10/2010                                     16
        Panel Name                    Record                Field Name   Field Long Name    UD Database         UD Field Name                                          Comments
                                                                                           GADESCFILE, GADESCFILE: FUND-          The field names listed under "UD Field Name" all contain data elements for
                                                                                           and GAT-CANG- METH, SPNSR-AMT, CANG- Contracts and Grants processes. The General Ledger Team did not compare these
                                                                                           AMT           AWARD-TYPE, CANG-        data elements with PS panels or records. It is our understanding that the Grants
                                                                                                         BASE-CODE, CANG-EQUIP- Team will review and compare these data elements.
                                                                                                         TITLE, CANG-SPNSR,
                                                                                                         CANG-AWARD-NUM,
                                                                                                         CANG-PROG-CODE, FISC-
                                                                                                         CANG-RPT-TYPE, CANG-
                                                                                                         CFDA-CODE,SPAR-REV-
                                                                                                         CODE, SPAR-INVCE-
                                                                                                         COPIES,SPAR-INVCE-
                                                                                                         AGENCY-1and 2, SPAR-
                                                                                                         INVCE-DEPT-1 and 2,SPAR-
                                                                                                         INVCE-CONTACT-1 and 2,
                                                                                                         SPAR-INVCE-STREET-1
                                                                                                         and 2, SPAR-INVCE-CTY-
                                                                                                         ST-ZIP-1 and 2, SPAR-
                                                                                                         SPNSR-AMTS-HIST, SPAR-
                                                                                                         PROJ-TITLE, SPAR-INVCE-
                                                                                                         DATE, SPAR-INVCE-AMT,
                                                                                                         SPAR-INVCE-FORM,
                                                                                                         andCANG-PROG-ACCT-
                                                                                                         CODE; GATRANFILE: GAT-
                                                                                                         CANG-AMT.




                                                                                           GADESCFILE     FACIL-ID-OLD, FACIL-ID-     The field names listed under "UD Field Name" all contain data elements for Facilities
                                                                                                          PCT, FACIL-ID, FACIL-       processes. The General Ledger Team did not compare these data elements with
                                                                                                          COMPONENT, FACIL-           PS panels or records. It is our understanding that the Facilities Projects Team will
                                                                                                          RENOVATION, and FACIL-      review and compare these data elements.
                                                                                                          PCT.




142400bf-4b4f-47dc-97ff-c3b8c11dcace.xls       11/10/2010                                     17

								
To top