PO_KK_RACHK_REQ

(SQL Table)
Index Back

Recpt Accrual Budget Ch'k Rqst

# 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 KK_PROCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Comm Cntrl Process Type
C=Check Budget
D=Delete Previous Activity
P=Provisional check Only

Default Value: C

5 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type

Prompt Table: KK_SOURCE_TRAN

6 SRCE_INSTANCE_OPTN Character(1) VARCHAR2(1) NOT NULL Source Instance Option
A=All Source Instances
V=Single Source Instance Value

Default Value: A

7 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.
8 BUSINESS_UNIT_OPTN Character(1) VARCHAR2(1) NOT NULL Business Unit Option
A=All Business Units
V=Specific Business Unit

Default Value: A

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_PM_NONVW

10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

12 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

13 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler

Default Value: N

14 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
15 RESTART_PI Number(10,0) DECIMAL(10) NOT NULL Restart Process Instance
16 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.
17 ACCOUNTING_DT_OPTN Character(1) VARCHAR2(1) NOT NULL Accounting Date Option
A=All
S=Some
V=Value

Default Value: A

18 ACCOUNTING_DT_FROM Date(10) DATE The range of the accounting entry construction dates
19 ACCOUNTING_DT_TO Date(10) DATE The range of the accounting entry construction dates
20 RECEIVER_ID_OPTN Character(1) VARCHAR2(1) NOT NULL Receiver ID Option
A=All
S=Some
V=Value

Default Value: A

21 RECEIVER_ID_FROM Character(10) VARCHAR2(10) NOT NULL From/To

Prompt Table: RECV_HDR

22 RECEIVER_ID_TO Character(10) VARCHAR2(10) NOT NULL Receiver ID

Prompt Table: RECV_HDR