| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 5 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 6 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
Default Value: N
|
| 7 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
Default Value: N
|
| 8 |
SOURCE_INSTANCE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Identifies a Process Instance (PROCESS_INSTANCE), and is used by the PeopleSoft Process Scheduler to save this identifier.
|
| 9 |
BUSINESS_UNIT_IU |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Business Unit for which InterUnit activity is being generated.
|
| 10 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 11 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
%EDITTABLE2
|
| 12 |
SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
Prompt Table:
%EDITTABLE3
|
| 13 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 14 |
FISCAL_YEAR_FROM |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 15 |
FISCAL_YEAR_TO |
Number(4,0) |
SMALLINT NOT NULL |
Range To Fiscal Year
|
| 16 |
ACCOUNTING_PD_FROM |
Number(3,0) |
SMALLINT NOT NULL |
Range From Accounting Period
|
| 17 |
ACCOUNTING_PD_TO |
Number(3,0) |
SMALLINT NOT NULL |
Range To Accounting Period
|
| 18 |
JOURNAL_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range From Journal ID
Prompt Table:
JRNL_ID_POST_VW
|
| 19 |
JOURNAL_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Range to Journal ID
Prompt Table:
JRNL_ID_POST_VW
|
| 20 |
JOURNAL_DATE_FROM |
Date(10) |
DATE |
Journal Date From
|
| 21 |
JOURNAL_DATE_TO |
Date(10) |
DATE |
To Journal Date
|
| 22 |
PROC_PART_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Partition ID
Prompt Table:
PROC_PART_TBL
|
| 23 |
SRCE_INSTANCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Instance Option
A=All Source Instances
V=Single Source Instance Value
|
| 24 |
BU_IU_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Business Unit Option
A=All InterUnit Business Units
V=Single InterUnit BU Value
|
| 25 |
BUSINESS_UNIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Option
A=All Business Units
V=Specific Business Unit
|
| 26 |
LEDGER_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Ledger Option
A=All Ledgers
V=Single Ledger Value
|
| 27 |
SOURCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Option
A=All Sources
V=Single Source Value
|
| 28 |
SYSTEM_SOURCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
System Source Option
A=All System Sources
V=Single System Source Value
|
| 29 |
FISC_YR_PRD_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Fiscal Year & Period Option
A=All Periods/Years
S=Some Year/Period Values
|
| 30 |
JOURNAL_ID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal ID Option
A=All Journal IDs
S=Some Journal ID Values
|
| 31 |
JOURNAL_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Date Option
A=All Journal Dates
S=Some Journal Date Values
|
| 32 |
PROC_PART_ID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Partition ID
A=All Values
V=Value
|
| 33 |
JRNL_UNPOST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
UnPost Journal(s)
Y/N Table Edit
|
| 34 |
JRNL_DELETE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Posted Journal(s)
L=Logical Delete
P=Physical Delete
R=Retain/Do Not Delete
Y/N Table Edit
Default Value: N
|
| 35 |
JRNL_BGTCHK_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Budget Check option. Used in Journal Edit request or other GL processes (e.g. Allocations, Closing, Revaluation, ...) to flag if journals will be budget checked after they are edited valid.
|
| 36 |
JRNL_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Journal(s)
|
| 37 |
COMMITMENT_CNTL_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on GL
|
| 38 |
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
|
| 39 |
SKIP_OPEN_ITEM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
|
| 40 |
SKIP_ESSBASE_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip Essbase Incremental Load
|
| 41 |
SKIP_SUMLED_UPD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
|
| 42 |
AUTOPLT_RUNCNTL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This run control is for autopilot. Used to edit process request parameters for values that don't make sense for recurring process.
Y/N Table Edit
|
| 43 |
MULTI_SEL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Select Option
Default Value: N
|
| 44 |
RECNAME_MSEL |
Character(15) |
VARCHAR2(15) NOT NULL |
Multiple Select Record name.
|
| 45 |
COMMIT_FREQUENCY |
Number(10,0) |
DECIMAL(10) NOT NULL |
Commit Frequency - Used to determine the commit frequency within a do select loop.
|
| 46 |
FIRST_PASS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
First Pass Switch
|
| 47 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 48 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 49 |
DELETE_LIMIT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Used in GL AE batch processes to perform deletes rather than truncate.
|
| 50 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
Default Value: 0
|
| 51 |
PRCS_START_DATE |
Date(10) |
DATE |
Process Start Date
|
| 52 |
SCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
ID
|
| 53 |
RTBL_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Mode
Y/N Table Edit
Default Value: N
|
| 54 |
USE_GTT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Global Temp Table Flag
Y/N Table Edit
Default Value: N
|
| 55 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|