| # |
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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 11 |
AMORTIZATION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Amortization ID
Prompt Table:
AMR_ID_DVW
|
| 12 |
AMORT_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
To Amortization ID
Prompt Table:
AMR_ID_DVW
|
| 13 |
AS_OF_DATE |
Date(10) |
DATE NOT NULL |
As of Date
|
| 14 |
CONSOLIDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidate with other Reqs
N=No
Y=Yes
|
| 15 |
JRNL_EDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Journal(s)
Y/N Table Edit
Default Value: N
|
| 16 |
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
|
| 17 |
JRNL_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Journal(s)
Y/N Table Edit
Default Value: N
|
| 18 |
JRNL_DT_ALT_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Alternate Journal Date Option
BF=Begin Date - From Period
BT=Begin Date - To Period
EF=End Date - From Period
ET=End Date - To Period
RD=Retain Primary Journal Date
|
| 19 |
RTM_PRCS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
On-Demand Process Flag
|