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