GL_AUD_JRNL_ARC (SQL Table)	Index Back
Journal Audit Logging Table

GL_AUD_JRNL_ARC

(SQL Table)

Journal Audit Logging Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_GL_NONVW

4 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.

5 JOURNAL_DATE Date(10) DATE NOT NULL Specifies the date the journal was created.

6 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".

7 JRNL_PROC_NAME Character(2) VARCHAR2(2) NOT NULL Journal process name for audit trail.
01=Journal Entry
02=Mark Journal for Posting
03=Mark Journal for Unposting
04=Journal Suspense Correction
05=Copy Journal
06=Create Standard Entry
07=External Flat File
08=Spreadsheet Import Batch
09=Edit Journal
10=Spreadsheet Import Online
11=Generate Journals
12=Allocation
13=Post Journal
14=Request Ledger Close
15=Process Multi-Currency
16=Consolidation
17=Equitization
18=Reversal Journals
19=BookCode Journals
20=Unpost Journals
21=Amortization Generate Journals
22=Mass Delete Journals

8 FS_EVENT_CODE Character(15) VARCHAR2(15) NOT NULL Event code

9 AUDLOG_DTTM DateTime(26) TIMESTAMP Date and time that the event occurred.

10 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

12 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

13 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

14 MESSAGE_TEXT_254 Character(254) VARCHAR2(254) NOT NULL Message Text

15 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text

16 BATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Batch Action

17 PURGE_OPTN Character(1) VARCHAR2(1) NOT NULL Purge History without Archive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_GL_NONVW
4	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.
5	JOURNAL_DATE	Date(10)	DATE NOT NULL	Specifies the date the journal was created.
6	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
7	JRNL_PROC_NAME	Character(2)	VARCHAR2(2) NOT NULL	Journal process name for audit trail. 01=Journal Entry 02=Mark Journal for Posting 03=Mark Journal for Unposting 04=Journal Suspense Correction 05=Copy Journal 06=Create Standard Entry 07=External Flat File 08=Spreadsheet Import Batch 09=Edit Journal 10=Spreadsheet Import Online 11=Generate Journals 12=Allocation 13=Post Journal 14=Request Ledger Close 15=Process Multi-Currency 16=Consolidation 17=Equitization 18=Reversal Journals 19=BookCode Journals 20=Unpost Journals 21=Amortization Generate Journals 22=Mass Delete Journals
8	FS_EVENT_CODE	Character(15)	VARCHAR2(15) NOT NULL	Event code
9	AUDLOG_DTTM	DateTime(26)	TIMESTAMP	Date and time that the event occurred.
10	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
12	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
13	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
14	MESSAGE_TEXT_254	Character(254)	VARCHAR2(254) NOT NULL	Message Text
15	MESSAGE_PARM	Character(254)	VARCHAR2(254) NOT NULL	Message Parameter Text
16	BATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Batch Action
17	PURGE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Purge History without Archive