CC_KK_CHK_REQ(SQL Table) |
Index Back |
---|---|
Procurement Card KK RequestDate 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. |