Docstoc

UD-PS-COMPARISON-8-3-01Final

Document Sample
UD-PS-COMPARISON-8-3-01Final Powered By Docstoc
					                                                                                              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                                                                                                "




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                                       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.




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                                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.




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                                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.




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                                    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




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                                 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                                                                                                    "




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                                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                                                                                                                  "




944ed677-c916-4c8a-b3cc-856159a90524.xls   11/15/2011                                               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                                                                                                                "




944ed677-c916-4c8a-b3cc-856159a90524.xls   11/15/2011                                                  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                                                                                                       "




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                             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                                                                                                    "




944ed677-c916-4c8a-b3cc-856159a90524.xls    11/15/2011                                                  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                                                                                                    "




944ed677-c916-4c8a-b3cc-856159a90524.xls   11/15/2011                                                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.




944ed677-c916-4c8a-b3cc-856159a90524.xls   11/15/2011                                                 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




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                     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




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                     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.




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                     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;




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                     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.




944ed677-c916-4c8a-b3cc-856159a90524.xls     11/15/2011                                     17

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:11/15/2011
language:English
pages:17