UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 7/10/2003.
UOD_BALANCES
Contains summary amounts for activity during each Accounting Period (starting, monthly, and
year-end adjustment periods) for each Chartfield-String. Also has starting balances, year-to-date
budget changes, and other information to assess financial situation of that Chartfield-String as
of the specified Accounting Period.
|
| ACCOUNT
| Account
| Example: 141000
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Chartfield which characterizes the type of transaction as part of the
transaction string. It identifies the type of revenue, expense, liability
or asset. Corresponds to the legacy 3-digit Object Code.
|
| | Lookup values and translations in
GL_ACCOUNT_TBL
|
| .
|
| ACCOUNTING_PERIOD
| Accounting Period
| Example: 1
|
| KEY
| Type: number
| Format: uppercase
| Length: 3
| Decimals: 0
|
| | Represents the time span where the transactions are recorded. Accounting
periods 1-12 correspond to a month and periods 991 and 992 correspond to
year end close periods.
|
| |
|
| .
|
| BUDGET_REF
| Budget Reference
| Example: 1999
|
| KEY
| Type: character
| Format: uppercase
| Length: 8
| 0Decimals: 0
|
| |
|
| .
|
| BUSINESS_UNIT
| Business Unit
| Example: UOD01
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Legal entity with a tax ID number. Only one exists at UD at this time
(UOD01)
|
| |
|
| .
|
| CHARTFIELD1
| Purpose
| Example: ENGL110000
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Purpose chartfield. Replaces legacy 11 digit account code.
|
| | Lookup values and translations in
CHARTFIELD1_TBL
|
| .
|
| CHARTFIELD2
| Source
| Example: 3300003000
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Source chartfield which tags and tracks contract and grant agency
information, and capital projects.
|
| | Lookup values and translations in
CHARTFIELD2_TBL
|
| .
|
| CHARTFIELD3
| UD Chartfield
| Example: 0000000001
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | The Chartfield which tags transactions with a code that each UDFS user can
interpret as (s)he finds useful (eg. USRVAL1 might mean "Paris" to one user
or department, but mean "Fall lecture series" to another).
|
| |
|
| .
|
| CLASS_FLD
| Class Field
| Example: 001
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | The Chartfield which identifies the faculty member or the staff position to
which salary items apply. Corresponds to the legacy line number.
|
| | Lookup values and translations in
CLASS_CF_TBL
|
| .
|
| DEPTID
| Department
| Example: 02553
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Identifies the administrative budget unit controling one or more Purposes.
Some entries are not actual departments, but are merely nodes on a tree
that organizes departments into a hierarchy for reporting purposes.
|
| | Lookup values and translations in
DEPT_TBL
|
| .
|
| FISCAL_YEAR
| Fiscal Year
| Example: 2003
|
| KEY
| Type: number
| Format: uppercase
| Length: 4
| Decimals: 0
|
| | UD fiscal transaction year. The year runs from 7/1/XX to 6/30/XY..
|
| |
|
| .
|
| FUND_CODE
| Fund Code
| Example: OPBAS
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Each Fund represents a self-balancing entity that produces balance sheets.
Loosely corresponds to Legacy Data Warehouse ACCT_TYPE.
|
| | Lookup values and translations in
FUND_TBL
|
| .
|
| GL_ADJUST_TYPE
| Adjustment Type
| Example: UDC
|
| KEY
| Type: character
| Format: uppercase
| Length: 4
| Decimals: 0
|
| | Represents type of adjusting entry for year-end closing.
|
| |
|
| .
|
| PROGRAM_CODE
| Program Code
| Example: INST2
|
| KEY
| Type: character
| Format: uppercase
| 5Length: 5
| 0
|
| | Identifies the major University function to which a transaction pertains
among an initial list of 3 dozen.
|
| | Lookup values and translations in
PROGRAM_TBL
|
| .
|
| PROJECT_ID
| Project
| Example:
|
| KEY
| Type: character
| Format: uppercase
| Length: 15
| Decimals: 0
|
| | Chartfield which identifies contract and grant activities and facilities
projects (eg. ARTC37211199000). Adds designators to a "Purpose" (eg.
ARTC372111) indicating fiscal year, building, or other coded details.
|
| | Lookup values and translations in
PROJECT_ID_VW
|
| .
|
| STATISTICS_CODE
| Statistics Code
| Example: FTE
|
| KEY
| Type: character
| Format: uppercase
| Length: 3
| Decimals: 0
|
| | Paired with statistical amount to tell you the type of units.
|
| |
|
| .
|
| ACCOUNT_TYPE
| Account Type
| Example: E
|
|
| Type: character
| Format: uppercase
| Length: 1
| Decimals: 0
|
| | Characterizes an account, transaction or balance broadly as Expense,
Revenue, Asset, Liability, or Net Asset.
|
| |
|
| .
|
| EMPLID
| EmplID
| Example: 12356
|
|
| Type: character
| Format: uppercase
| Length: 11
| Decimals: 0
|
| | Employee ID from HR system.
|
| |
|
| .
|
| LASTCHANGEDTTM
| Last Change Refresh Stamp
| Example: 05/01/2003 12:00:00AM
|
|
| Type: date-time
| Format: microseconds
| Length: 26
| Decimals: 0
|
| | Last date/time the row has been updated. Equivalent to Legacy Data
Warehouse last_update.
|
| |
|
| .
|
| NAME
| Name
| Example: Smith,John
|
|
| Type: character
| Format: name
| Length: 50
| Decimals: 0
|
| | Employee name (last,First Middle)
|
| |
|
| .
|
| UOD_ACCOUNT_DESC
| Description
| Example: POSTAGE AND MAIL SERVICE
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Title of an account (from GL_ACCT_TBL). Equivalent to Legacy Data
Warehouse obj_code_desc.
|
| |
|
| .
|
| UOD_BEG_FISC_BAL
| UD Beginning Fiscal Ballance
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Beginning Fiscal Balance
|
| |
|
| .
|
| UOD_BUDGET_FTE
| Budget FTE
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | FTE associated with a budgeted position. Equivalent to legacy Data
Warehouse budget_fte.
|
| |
|
| .
|
| UOD_BUDGREF_DESCR
| Description
| Example: 2003
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | The budget year.
|
| |
|
| .
|
| UOD_CANG_AWARD_AMT
| Cang Award Amount
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Contract and Grant award amount
|
| |
|
| .
|
| UOD_CHRTFLD1_DESCR
| Description
| Example: A&S RECRUITING & MOVING
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Title of Chartfield1-Purpose (from CHARTFIELD1_TBL). Equivalent to legacy
Data Warehouse title.
|
| |
|
| .
|
| UOD_CHRTFLD2_DESCR
| Description
| Example: STATE GIFT ARTS EDUC
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Descriptive name for the source of funding (from CHARTFIELD2_TBL).
|
| |
|
| .
|
| UOD_CHRTFLD3_DESCR
| Description
| Example: USRVAL1
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | UD userfield.
|
| |
|
| .
|
| UOD_CLASS_FD_DESCR
| Description
| Example: 001
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Title of the class field (from CLASS_CF_TBL).
|
| |
|
| .
|
| UOD_CURR_FISC_BAL
| Current Fisc Balance
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Month to date charges for a particular accounting period. Equivalent to
legacy Data Warehouse curr_fisc_bal.
|
| |
|
| .
|
| UOD_DEPTID_DESCR
| Description
| Example: Chemistry
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Department title (from DEPT_TBL).
|
| |
|
| .
|
| UOD_END_ENCUMB
| End Encumburances
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Encumberances at the end of a particular accounting period. Equivalent to
legacy Data Warehouse end_encumb.
|
| |
|
| .
|
| UOD_END_FISC_BAL
| End Fisc Bal
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | The total charges as of the end of a particular accounting period.
Equivalent to legacy Data Warehouse end_fisc_bal.
|
| |
|
| .
|
| UOD_END_FSC_BAL_PR
| End Fisc Bal Prior Yr -1 Tm Sp
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | The total charges as of the end of a particular accounting period in the
Prior Year (with respect to this row's own Fiscal Year and Accounting
Period).
|
| |
|
| .
|
| UOD_FUNDCODE_DESCR
| Description
OPER | ATING BALANCE Example: OPERATING BALANCE
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Fund title (from FUND_TBL).
|
| |
|
| .
|
| UOD_GLADJUST_DESCR
| Description
| Example:
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Description of the adjusting entry (from ADJUST_TYPE_TBL).
|
| |
|
| .
|
| UOD_NET_BUD_PR_YR
| Net Budget Prior Year
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Net budget from Prior Year.
|
| |
|
| .
|
| UOD_NET_BUDGET
| Net Budget Amount
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Current year's net budget.
|
| |
|
| .
|
| UOD_NET_PERM_BUD
| Net Perm Budget
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Current year's budget including all "Permanent" changes.
|
| |
|
| .
|
| UOD_PERM_CHNG_BUD
| Perm Change Budget
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Amount of the current year's permanent budget changes.
|
| |
|
| .
|
| UOD_PROGRAM_DESCR
| Description
| Example: DEPARTMENTAL RESEARCH
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Title of the Program.
|
| |
|
| .
|
| UOD_PROJ_TO_DT_ACT
| Project to Date Actuals
| Example:
|
|
| Type: signed number
uppe | uppercase Format: uppercase
| Length: 28
| Decimals: 3
|
| | Project to date monetary activity since inception.
|
| |
|
| .
|
| UOD_PROJ_TO_DT_BAL
| Project to Date Balances
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Project to date balance.
|
| |
|
| .
|
| UOD_PROJ_TO_DT_BUD
| Project to Date Budget
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Project to date budget (can cross multiple fiscal years).
|
| |
|
| .
|
| UOD_PROJECT_DESCR
| Description
| Example: RODNEY DINING SPRINKLER SYSTEM
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Title of the Project (from PROJECT_ID_VW).
|
| |
|
| .
|
| UOD_START_BUDGET
| Start Budget Beg Bal Curr Yr
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Beginning budget at the start of the fiscal year.
|
| |
|
| .
|
| UOD_STATCD_DESCR
| Description
| Example:
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Title of the statistics code (units of non-monetary amounts) from STAT_TBL.
|
| |
|
| .
|
| UOD_TEMP_CHNG_BUD
| Temp Bud YTD
| Example:
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | Current fiscal year's temporary budget changes.
|
| |
|
| .
Fields deemed insignificant at UD, or of limited use to general campus users.
|
| SCENARIO
| Scenario
|
| UOD_SCENARIO_DESCR
| Description