HYP_KK_BD_SRCH (SQL View)	Index Back
Hyperion P&B Trans Header Rec Hyperion P&B Transaction Header Record

HYP_KK_BD_SRCH

(SQL View)

Hyperion P&B Trans Header Rec

Hyperion P&B Transaction Header Record

SELECT A.BUSINESS_UNIT , A.HYP_TRAN_ID , A.ACCOUNTING_DT , A.BD_APPR_STATUS , A.BUDGET_HDR_STATUS FROM %Table(HYP_KK_BD_HDR) A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_GL_NONVW

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 BD_APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on hyperion Budget transaction records
A=Approved
D=Denied
P=Pending

5 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW
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	BD_APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on hyperion Budget transaction records A=Approved D=Denied P=Pending
5	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