HYP_KK_BD_HDR

(SQL Table)
Index Back

Hyperion P&B Trans Header Rec

Hyperion P&B Transaction Header Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 HYP_TRAN_ID Character(44) VARCHAR2(44) NOT NULL Commitment Control Foreign Key for Transaction Identification.
3 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
4 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
5 BD_APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on hyperion Budget transaction records
A=Approved
D=Denied
P=Pending
6 KK_BUDG_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Budget Entry Type
0=Original
1=Adjustment
2=Transfer Adjustment
3=Transfer Original
4=Closing
5=Roll Forward

Default Value: 0

7 KK_GEN_PARENT Character(1) VARCHAR2(1) NOT NULL Yes/No Indicator - Generate Parent Budgets

Y/N Table Edit

Default Value: N

8 KK_DEFAULT_EE Character(1) VARCHAR2(1) NOT NULL Yes/No Indicator - Use Default Entry Event

Y/N Table Edit

Default Value: N

9 KK_PARENT_ENT_TYPE Character(1) VARCHAR2(1) NOT NULL Indicator - Parent Budget Entry Type
0=Original
1=Adjustment
2=Transfer Adjustment
3=Transfer Original
10 IN_PROCESS Character(1) VARCHAR2(1) NOT NULL Process

Y/N Table Edit

Default Value: N

11 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

Default Value: N

12 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
13 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
14 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance