CC_KK_CHK_REQ

(SQL Table)
Index Back

Procurement Card KK Request

Date Initials Ref# Description 29/08/2023 SS PSFTPO-13581 We ensured that to show legal name in EMPLID prompt as part of preferred name feature enhancement

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 EMPLID_OPTN Character(1) VARCHAR2(1) NOT NULL Employee ID Option
A=All
S=Some
V=Value

Default Value: A

10 EMPLID_FROM Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: %EDITTABLE

11 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL EmplID

Prompt Table: %EDITTABLE

12 CC_VENDOR_OPTN Character(1) VARCHAR2(1) NOT NULL Card Issuer
A=All
S=Some
V=Value

Default Value: A

13 CC_VENDOR_FROM Character(5) VARCHAR2(5) NOT NULL Card Issuer

Prompt Table: CC_CARD_TBL_VW

14 CC_VENDOR_TO Character(5) VARCHAR2(5) NOT NULL Credit Card Supplier

Prompt Table: CC_CARD_TBL_VW

15 BILLING_DT_OPTN Character(1) VARCHAR2(1) NOT NULL Billing Date Option
A=All
S=Some
V=Value

Default Value: A

16 BILLING_DT_FROM Date(10) DATE From Billing Date
17 BILLING_DT_TO Date(10) DATE To Billing Date
18 TRANS_DT_OPTN Character(1) VARCHAR2(1) NOT NULL Transaction Date Option
A=All
S=Some
V=Value

Default Value: A

19 TRANS_DT_FROM Date(10) DATE From Transaction Date
20 TRANS_DT_TO Date(10) DATE Transaction Date to
21 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

22 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

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

Default Value: N

24 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
25 RESTART_PI Number(10,0) DECIMAL(10) NOT NULL Restart Process Instance
26 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.