AR_CC_REQUEST

(SQL Table)
Index Back

AR Budget Processor Request

AR Budget Processor Request record

# 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
4 AR_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Transaction Type

Prompt Table: AR_SRC_TRAN_VW

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUARDS_NONVW

6 FROM_DT Date(10) DATE NOT NULL From Date
7 TO_DT Date(10) DATE NOT NULL To Date

Default Value: %DATE

8 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

9 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

10 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
11 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler

Default Value: P

12 RESTART_PI Number(10,0) DECIMAL(10) NOT NULL Restart Process Instance
13 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.