For SJE. Displays the dates of journals with status M, P or V for the Model Journal prompt box.

JRNL_DT_MPV_VW

(SQL View)
Index Back

select business_unit, journal_id, journal_date, jrnl_hdr_status from PS_JRNL_HEADER where jrnl_hdr_status in ('M','P','V') and unpost_seq = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
3 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
4 JRNL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the processing status of a journal entry.
D=Deleted
E=Journal Has Errors
I=Posting Incomplete
M=Valid SJE Model -- Do Not Post
N=No Status - Needs to be Edited
P=Posted to Ledger(s)
T=Journal Entry Incomplete
U=Unposted
V=Valid Journal - Edits Complete
X=Cancelled
Z=Upgrade Journal - Can't Unpost