| # |
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 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
Default Value: 9999
|
| 4 |
SRCE_INSTANCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Instance Option
A=All Source Instances
V=Single Source Instance Value
Default Value: A
|
| 5 |
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.
|
| 6 |
BU_IU_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Business Unit Option
A=All InterUnit Business Units
V=Single InterUnit BU Value
Default Value: A
|
| 7 |
BUSINESS_UNIT_IU |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Business Unit for which InterUnit activity is being generated.
Prompt Table:
SP_BU_GL_NONVW
|
| 8 |
BUSINESS_UNIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Option
A=All Business Units
V=Specific Business Unit
Default Value: V
|
| 9 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 10 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 11 |
LEDGER_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Ledger Option
A=All Ledgers
V=Single Ledger Value
Default Value: V
|
| 12 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
%EDITTABLE2
|
| 13 |
SOURCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Option
A=All Sources
V=Single Source Value
Default Value: V
|
| 14 |
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
|
| 15 |
SYSTEM_SOURCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
System Source Option
A=All System Sources
V=Single System Source Value
Default Value: A
|
| 16 |
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.
|
| 17 |
PROC_PART_ID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Partition ID
A=All Values
V=Value
Default Value: A
|
| 18 |
PROC_PART_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Partition ID
Prompt Table:
PROC_PART_TBL
|
| 19 |
JOURNAL_ID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal ID Option
A=All Journal IDs
S=Some Journal ID Values
Default Value: A
|
| 20 |
JOURNAL_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range From Journal ID
Prompt Table:
JRNL_ID_NPS_DVW
|
| 21 |
JOURNAL_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Range to Journal ID
Prompt Table:
JRNL_ID_NPS_DVW
|
| 22 |
JOURNAL_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Date Option
A=All Journal Dates
S=Some Journal Date Values
Default Value: A
|
| 23 |
JOURNAL_DATE_FROM |
Date(10) |
DATE |
Journal Date From
|
| 24 |
JOURNAL_DATE_TO |
Date(10) |
DATE |
To Journal Date
|
| 25 |
JRNL_EDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Journal(s)
Y/N Table Edit
Default Value: Y
|
| 26 |
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.
Y/N Table Edit
Default Value: N
|
| 27 |
JRNL_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Journal(s)
Y/N Table Edit
Default Value: N
|
| 28 |
JRNL_UNPOST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
UnPost Journal(s)
Y/N Table Edit
Default Value: N
|
| 29 |
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
|
| 30 |
JRNL_REEDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Edit Previously Edited
Y/N Table Edit
Default Value: N
|
| 31 |
JRNL_REEDIT_OPTN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Edit Commitment Control Adjustment Journals
Y/N Table Edit
Default Value: N
|
| 32 |
MARK_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
Default Value: N
|
| 33 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 34 |
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
|
| 35 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
Default Value: N
|
| 36 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 37 |
GOTO_RUN_STATS |
Character(1) |
VARCHAR2(1) NOT NULL |
Go To Process Status
Default Value: N
|
| 38 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 39 |
RECALC_EXCHNG_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
Default Value: N
|
| 40 |
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
Default Value: N
|
| 41 |
MULTI_SEL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Select Option
Y/N Table Edit
Default Value: N
|
| 42 |
RECNAME_MSEL |
Character(15) |
VARCHAR2(15) NOT NULL |
Multiple Select Record name.
|
| 43 |
SCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Scenario ID
|
| 44 |
RTBL_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Mode
Y/N Table Edit
Default Value: N
|
| 45 |
RTBL_COMBO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Combination Edit Flag
Y/N Table Edit
Default Value: N
|
| 46 |
USE_GTT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Global Temp Table Flag
Y/N Table Edit
Default Value: N
|