UD PeopleSoft Financial System - Data Dictionary
Last updated for this Record on 9/8/2003.

JRNL_HEADER

Contains summary information about Journals.
Further details are in this record's child: JRNL_LN.

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)
.
JOURNAL_DATE Journal Date Example: 07/31/2003
KEY Type: date Format: uppercase Length: 10 Decimals: 0
Date the journal is entered.
.
JOURNAL_ID Journal ID Example: 0000000001
KEY Type: character Format: uppercase Length: 10 Decimals: 0
Identifies and individual journal.
.
UNPOST_SEQ UnPost Sequence Example:
KEY Type: number Format: uppercase Length: 2 Decimals: 0
Whether a journal has been unposted or not.
.
ACCOUNTING_PERIOD Accounting Period Example: 001
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.
.
ADJUSTING_ENTRY Adjusting Entry Example: Y
Type: character Format: uppercase Length: 1 Decimals: 0
Journal entry made as part of closing process. Limited to period 991 & 992
.
DESCR Description Example: TO TRANSFER EXPENSES
Type: character Format: lowercase Length: 30 Decimals: 0
Description
.
DTTM_STAMP_SEC Last Update DateTime Example: 2002-12-10-16.28.52.000000
Type: date-time Format: seconds Length: 26 Decimals: 0
Date and time when the journal was last modified.
.
FISCAL_YEAR Fiscal Year Example: 2004
Type: number Format: uppercase Length: 4 Decimals: 0
UD fiscal transaction year. The year runs from 7/1/XX to 6/30/XY..
.
GL_ADJUST_TYPE Adjustment Type Example:
Type: character Format: uppercase Length: 4 Decimals: 0
Represents type of adjusting entry for year-end closing.
.
JRNL_TOT_CREDITS Journal Total Credits Example: 0.000
Type: signed number Format: uppercase Length: 28 Decimals: 3
Shows you the total credits in a journal.
.
JRNL_TOTAL_DEBITS Journal Total Debits Example: 0.000
Type: signed number Format: uppercase Length: 28 Decimals: 3
Shows total debits in a journal.
.
LEDGER_GROUP Ledger Group Example: ACTUALS
Type: character Format: uppercase Length: 10 Decimals: 0
Name of the ledger that the row is attached.
.
POSTED_DATE Date Posted Example: 07/31/2003
Type: date Format: uppercase 10Length: 10 0
Date the journal was posted to the ledger.
.
SOURCE Source Example: 000
Type: character Format: uppercase Length: 3 Decimals: 0
Transaction Source: the subsystem where the tranaction originates. NOT the same as CHARTFIELD2-SOURCE. Equivalent to Legacy Data Warehouse tran_code.
Lookup values and translations in SOURCE_TBL
.
Fields deemed insignificant at UD, or of limited use to general campus users.
ACCTG_DEF_NAME Accounting Definition Name
ADB_DATE Average Daily Balance Date
AUTO_GEN_LINES Auto Generate Lines
BUDGET_HDR_STATUS Budget Checking Header Status
BUSINESS_UNIT_IU Business Unit
CONTROL_TOTAL_STAT Control Total Status
CUR_EFFDT Currency Effective Date
CURRENCY_CD Currency Code
DESCR254 Long Description
DOC_SEQ_DATE Document Sequence Date
DOC_SEQ_NBR Document Sequence Number
DOC_SEQ_STATUS Document Sequencing Status
DOC_TYPE Document Type
EE_HDR_STATUS Entry Event Header Status
EVENT_OCCURRENCE Event Occurrence
FOREIGN_CURRENCY Foreign Currency Code
IU_SYS_TRAN_CD System Transaction
IU_TRAN_CD Transaction Code
JOURNAL_CLASS Journal Class
JOURNAL_DATE_ORIG Orignial Journal Date
JOURNAL_LOCKED Journal Locked for Change
JRNL_BALANCE_STAT Journal Balance Status
JRNL_EDIT_ERR_STAT Journal Edit Error Status
JRNL_HDR_STATUS Journal Header Status
JRNL_NET_UNITS Journal Net Statistical Units
JRNL_PROCESS_REQST Journal Processing Request
JRNL_SUMLED_REQST Post to Summary Ledger
JRNL_TOTAL_LINES Journal Total Lines
KK_AMOUNT_TYPE Commitment Control Amount Type
KK_SKIP Skip Commitment Control In GL
KK_TRAN_BYPAS_FLAG Bypass Budget Checking
KK_TRAN_OVER_DTTM Override Date
KK_TRAN_OVER_FLAG Override Transaction
KK_TRAN_OVER_OPRID Override User ID
LAST_LN_COMMITTED Last Line Committed
LEDGER Ledger
OPRID User ID
PC_DISTRIB_STATUS PC Distribution Status
PROC_PART_ID Process Partition ID
PROCESS_INSTANCE Process Instance
RATE_DIV Rate Divisor
RATE_MULT Rate Multiplier
REVERSAL_ADJ_PER Adjustment Period
REVERSAL_CD Reversal Code
REVERSAL_CD_ADB ADB Reversal Code
REVERSAL_DATE Reversal Date
REVERSAL_DATE_ADB ADB Reversal Date
RT_TYPE Rate Type
SCHEDULE Schedule ID
SJE_TYPE Standard Journal Entry Type
SOURCE_INSTANCE Source Instance
SUSP_RECON_STATUS Suspense Reconciliation Status
SYSTEM_SOURCE System Source
TRANS_REF_NUM Reference Number
TRANSACTION_DATE Transaction Date
UNPOST_JRNL_DATE Unpost Date