JRNL_MAP_SRC_VW

(SQL View)
 Index Back

Journal Header Data For MAP


SELECT DISTINCT H.BUSINESS_UNIT_IU , H.JOURNAL_ID , H.JOURNAL_DATE , H.BUSINESS_UNIT , H.LEDGER_GROUP , H.ADJUSTING_ENTRY , H.FISCAL_YEAR , H.ACCOUNTING_PERIOD , H.JRNL_TOTAL_DEBITS , H.JRNL_TOT_CREDITS , H.DESCR , H.CURRENCY_CD , H.OPRID , %DatePart(H.JRNL_CREATE_DTTM) , H.ATTACHMENT_EXIST , %DatePart(U.EOAWDTTM_MODIFIED) , U.OPRID , U.EOAWORIG_OPRID , U.EOAWDTTM_COMPLETE , S.EOAWTHREAD_ID , U.EOAWSTEP_STATUS , S.EOAWPRCS_ID , S.EOAWDEFN_ID , S.EFFDT , S.EOAWSTEP_NBR , X.ORIGINATORID , X.EOAWREQUESTOR_ID , X.EOAWTHREAD_STATUS , X.EOAWDTTM_MODIFIED , U.DTTM_CREATED , ' ' FROM PS_JRNL_HEADER H , PS_JRNL_AF_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U WHERE H.BUSINESS_UNIT=X.BUSINESS_UNIT_LN AND H.JOURNAL_ID=X.JOURNAL_ID AND H.JOURNAL_DATE=X.JOURNAL_DATE AND H.BUSINESS_UNIT_IU=X.BUSINESS_UNIT AND X.EOAWTHREAD_ID=S.EOAWTHREAD_ID AND X.EOAWPRCS_ID=S.EOAWPRCS_ID AND X.EOAWDEFN_ID=S.EOAWDEFN_ID AND S.EOAWSTEP_INSTANCE=U.EOAWSTEP_INSTANCE AND H.JRNL_HDR_STATUS='V' AND H.BUDGET_HDR_STATUS='V' AND X.EOAWTHREAD_ID=( SELECT MAX(X1.EOAWTHREAD_ID) FROM PS_JRNL_AF_XREF X1 WHERE X1.BUSINESS_UNIT=X.BUSINESS_UNIT AND X1.JOURNAL_ID=X.JOURNAL_ID AND X1.JOURNAL_DATE=X.JOURNAL_DATE AND X1.BUSINESS_UNIT_LN=X.BUSINESS_UNIT_LN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_GL_NONVW

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 BUSINESS_UNIT_LN Character(5) VARCHAR2(5) NOT NULL Line Business Unit

Prompt Table: SP_BU_GL_NONVW

5 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
6 ADJUSTING_ENTRY Character(1) VARCHAR2(1) NOT NULL Adjusting Entry
C=Fiscal Year Close
N=Non-Adjusting Entry
Y=Adjusting Entry
7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
8 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
9 JRNL_TOTAL_DEBITS Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a running total of the debit amounts in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.
10 JRNL_TOT_CREDITS Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a running total of the credit amounts in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.
11 JRNL_DESCR Character(30) VARCHAR2(30) NOT NULL Journal Description
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
14 ENTERED_DT Date(10) DATE Entered on
15 ATTACHMENT_EXIST Character(1) VARCHAR2(1) NOT NULL Attachments Exist
N=N
Y=Y
16 EOAWSTART_DT Date(10) DATE Start Date
17 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
18 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
19 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
20 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
21 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial
22 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
23 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
24 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

25 EOAWSTEP_NBR Number(6,2) DECIMAL(5,2) NOT NULL Sequence number of step in its path
26 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
27 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
28 EOAWTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
A=Approved
C=Complete
D=Denied
E=Pending Denial
H=Hard Deny
I=Initial
N=Not Active
P=Pending
S=Awaiting Further Approvals
T=Terminated
W=Canceled
X=Suspended/Pending Denial
29 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
30 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
31 PRIORITY_FLG Character(1) VARCHAR2(1) NOT NULL Priority Flag
1=High
2=Medium
3=Low