UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
JRNL_LN
Contains detailed information for transactions on each journal as each component is assigned to
one or more chartfield strings.
This record is a child of JRNL_HEADER.
|
| ACCOUNT
| Account
| Example: 141000
|
|
| 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
|
| .
|
| ACTIVITY_ID
| Activity ID
| Example:
|
|
| Type: character
| Format: uppercase
| Length: 15
| Decimals: 0
|
| | Chartfield used for Projects. Represents a specific task for which expense
or revenue are recorded.
|
| |
|
| .
|
| ANALYSIS_TYPE
| Resource Analysis Type
| Example:
|
|
| Type: character
| Format: uppercase
| Length: 3
| Decimals: 0
|
| | Projects and Grant chartfield that is used to track activities and events
re billable to a third party.
|
| |
|
| .
|
| BUDGET_REF
| Budget Reference
| Example: 1999
|
|
| Type: character
| Format: uppercase
| Length: 8
| Decimals: 0
|
| | The Budget Year (Fiscal).
|
| | Lookup values and translations in
BUD_REF_TBL
|
| .
|
| BUSINESS_UNIT
| Business Unit
| Example: UOD01
|
|
| 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
|
|
| 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
|
|
| 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
|
|
| 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).
|
| | Lookup values and translations in
CHARTFIELD3_TBL
|
| .
|
| CLASS_FLD
| Class Field
| Example: 001
|
|
| 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
|
|
| 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
|
| .
|
| FUND_CODE
| Fund Code
| Example: OPBAS
|
|
| 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:
|
|
| Type: character
| Format: uppercase
| Length: 4
| Decimals: 0
|
| | Represents type of adjusting entry for year-end closing.
|
| |
|
| .
|
| JOURNAL_DATE
| Journal Date
| Example: 07/31/2003
|
|
| Type: date
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Date the journal is entered.
|
| |
|
| .
|
| JOURNAL_ID
| Journal ID
| Example: 0000000001
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Identifies and individual journal.
|
| |
|
| .
|
| JOURNAL_LINE
| GL Journal Line Number
| Example: 1
|
|
| Type: number
| Format: uppercase
| Length: 9
| Decimals: 0
|
| | Sequencial number of lines in journal.
|
| |
|
| .
|
| JRNL_LINE_STATUS
| Journal Line Status
| Example: P (POSTED)
|
|
| Type: character
| Format: number
| Length: 1
| Decimals: 0
|
| | Shows whether the journal has errors, has been posted, is valild, a model
journal, or not been edited.
|
| |
|
| .
|
| LEDGER
| Ledger
| Example: ACTUALS
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Name of the ledger that the row is attached.
|
| |
|
| .
|
| LINE_DESCR
| Journal Line Description
| Example:
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Description of the transaction on a row. May be entered by user or the
subsystem.
|
| |
|
| .
|
| MONETARY_AMOUNT
| Monetary Amount
| Example: 00.000
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | The total dollar amount for a chartfield string.
|
| |
|
| .
|
| PROGRAM_CODE
| Program Code
| Example: INST2
|
|
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 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: ARTC37211199000
|
|
| 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:
|
|
| Type: character
| Format: uppercase
| Length: 3
| Decimals: 0
|
| | Paired with statistical amount to tell you the type of units.
|
| |
|
| .
|
| UNPOST_SEQ
| UnPost Sequence
| Example:
|
|
| Type: number
| Format: uppercase
| Length: 2
| Decimals: 0
|
| | Whether a journal has been unposted or not.
|
| |
|
| .
Fields deemed insignificant at UD, or of limited use to general campus users.
|
| AFFILIATE
| Affiliate
|
| AFFILIATE_INTRA1
| Fund Affiliate
|
| AFFILIATE_INTRA2
| Operating Unit Affiliate
|
| ALTACCT
| Alternate Account
|
| BOOK_CODE
| Book Code
|
| BUDGET_DT
| Budget Date
|
| BUDGET_LINE_STATUS
| Budget Checking Line Status
|
| BUDGET_PERIOD
| Budget Period
|
| BUSINESS_UNIT_PC
| PC Business Unit
|
| CLOSING_STATUS
| Closing Status
|
| CURRENCY_CD
| Currency Code
|
| DOC_SEQ_DATE
| Document Sequence Date
|
| DOC_SEQ_NBR
| Document Sequence Number
|
| DOC_SEQ_STATUS
| Document Sequencing Status
|
| DOC_TYPE
| Document Type
|
| EE_PROC_STATUS
| Entry Event Line Status
|
| ENTRY_EVENT
| Entry Event
|
| FOREIGN_AMOUNT
| Foreign Amount
|
| FOREIGN_CURRENCY
| Foreign Currency Code
|
| IU_ANCHOR_FLG
| InterUnit Anchor
|
| IU_TRAN_GRP_NBR
| InterUnit Group Number
|
| JOURNAL_LINE_DATE
| Journal Line Date
|
| JOURNAL_LINE_GFEE
| Entry Event Journal Line
|
| JRNL_LINE_SOURCE
| Journal Line Source
|
| JRNL_LN_REF
| Journal Line Reference
|
| MOVEMENT_FLAG
| Movement Flag
|
| OPERATING_UNIT
| Operating Unit
|
| PROCESS_INSTANCE
| Process Instance
|
| PRODUCT
| Product
|
| RATE_DIV
| Rate Divisor
|
| RATE_MULT
| Rate Multiplier
|
| RESOURCE_CATEGORY
| Resource Category
|
| RESOURCE_SUB_CAT
| Resource SubCategory
|
| RESOURCE_TYPE
| Resource Type
|
| RT_TYPE
| Rate Type
|
| SCENARIO
| Scenario
|
| STATISTIC_AMOUNT
| Statistic Amount
|
| SUSPENDED_LINE
| Suspended Journal Line Number