| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 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 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 5 |
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
|
| 6 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 7 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 8 |
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.
|
| 9 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 10 |
FROM_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
From Date Option
C=Current Date
F=Begin Date - From Period
N=No From Date
P=Process Date
S=Specify Date
T=Begin Date - To Period
Default Value: C
|
| 11 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 12 |
TO_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
To Date Option
C=Current Date
F=End Date - From Period
P=Process Date
S=Specify Date
T=End Date - To Period
Default Value: C
|
| 13 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 14 |
APPL_JRNL_ID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Template Option
A=All Application Journals
V=Specific Application Journal
Default Value: A
|
| 15 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table:
%EDITTABLE2
Set Control Field: BUSINESS_UNIT
|
| 16 |
BUSINESS_UNIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Option
A=All Business Units
V=Specific Business Unit
Default Value: V
|
| 17 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
%EDITTABLE
|
| 18 |
ACCTG_DEF_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Defines the content and source of the accounting transactions that the Journal Generator program of PeopleSoft General Ledger uses to create journal entries. Accounting transactions are populated by PeopleSoft applications or third-party systems for input to the general ledger.
Prompt Table:
JRNLGEN_DEFN_VW
|