HP_KK_ENC_RES_L

(SQL Table)
Index Back

Budget Check Response Line

Detail line record of budget check response from financials.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 HP_KK_DOC_ID Number(31,0) DECIMAL(31) NOT NULL Commitment Control Document ID
3 HP_FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year when there is more than one occurence on a record
4 HP_BUDGET_YEAR Number(4,0) SMALLINT NOT NULL Budget Year for Commitment Control
5 HP_KK_DOC_LINE_NBR Number(3,0) SMALLINT NOT NULL Commitment Control Document Line #
6 EXCPTN_TYPE Character(3) VARCHAR2(3) NOT NULL Exception Type
7 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
8 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
9 KK_EXCPTN_STATUS Character(1) VARCHAR2(1) NOT NULL Exception Status
E=Error
W=Warning
10 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
12 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
13 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
14 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
15 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
16 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
17 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
18 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
19 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
20 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
21 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
22 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
23 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
24 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
25 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
26 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
27 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
28 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
29 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
30 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
31 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
32 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1
33 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
34 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
35 MESSAGE_PARM4 Character(30) VARCHAR2(30) NOT NULL Message Parameter 4
36 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values