BO_REQ_TREE_VW (SQL View)	Index Back
FSR Tree Financial Structure Request Tree View Designed for Fluid Approval to fetch tree information

BO_REQ_TREE_VW

(SQL View)

FSR Tree

Financial Structure Request Tree View Designed for Fluid Approval to fetch tree information

SELECT T.BO_REQUEST_ID , T.BO_REQ_DTL_NO , T.TREE_NAME , T.TREE_EFFDT , T.TREE_NODE , T.EFFDT_TREE , T.TREE_NODE_TO , T.GL_NEW_NODE_DESCR , T.SEQNUM , T.GL_NODE_LEAF_FLAG , T.GL_NEW_NODE_FLG , T.FLD_REQ_TRE_STATUS , D.BO_REQ_DTL_STATUS , D.SETID , D.FIELDNAME1 , D.FIELDVALUE1 , D.DESCR FROM PS_BO_REQ_TRE_DTL T , PS_BO_REQUEST_DTL D WHERE T.BO_REQUEST_ID = D.BO_REQUEST_ID AND T.BO_REQ_DTL_NO = D.BO_REQ_DTL_NO

Parent record: BO_REQUEST_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Financial Structure Request ID

2 BO_REQ_DTL_NO Number(3,0) SMALLINT NOT NULL Financial Structure Request Detail ID

3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: FLD_REQ_TREE_VW

4 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree

5 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
Prompt Table: FLD_REQ_NODE_VW

6 EFFDT_TREE Date(10) DATE Tree Effective Date

7 TREE_NODE_TO Character(20) VARCHAR2(20) NOT NULL Move/Add to Parent Node
Prompt Table: FLD_REQ_NODE_VW

8 GL_NEW_NODE_DESCR Character(30) VARCHAR2(30) NOT NULL New Node Description

9 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

10 GL_NODE_LEAF_FLAG Character(4) VARCHAR2(4) NOT NULL As Node or Leaf
LEAF=Leaf
NODE=Node

11 GL_NEW_NODE_FLG Character(1) VARCHAR2(1) NOT NULL New Tree Node
Y/N Table Edit
Default Value: N

12 FLD_REQ_TRE_STATUS Character(1) VARCHAR2(1) NOT NULL Field Request Tree Update Status
D=Saved as Draft
F=Failed
N=None
S=Success
Default Value: N

13 BO_REQ_DTL_STATUS Character(1) VARCHAR2(1) NOT NULL Financial Structure Request Detail Status
A=Approved
C=Canceled
D=Denied
E=Error
F=Completed
P=Pending Approval
R=In Review
Default Value: R

14 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

15 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
Prompt Table: BO_REQ_TFLD_VW

16 FIELDVALUE1 Character(30) VARCHAR2(30) NOT NULL Field Value
Prompt Table: %EDITTABLE

17 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Financial Structure Request ID
2	BO_REQ_DTL_NO	Number(3,0)	SMALLINT NOT NULL	Financial Structure Request Detail ID
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: FLD_REQ_TREE_VW
4	TREE_EFFDT	Date(10)	DATE NOT NULL	Effective date of the Tree
5	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name Prompt Table: FLD_REQ_NODE_VW
6	EFFDT_TREE	Date(10)	DATE	Tree Effective Date
7	TREE_NODE_TO	Character(20)	VARCHAR2(20) NOT NULL	Move/Add to Parent Node Prompt Table: FLD_REQ_NODE_VW
8	GL_NEW_NODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	New Node Description
9	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
10	GL_NODE_LEAF_FLAG	Character(4)	VARCHAR2(4) NOT NULL	As Node or Leaf LEAF=Leaf NODE=Node
11	GL_NEW_NODE_FLG	Character(1)	VARCHAR2(1) NOT NULL	New Tree Node Y/N Table Edit Default Value: N
12	FLD_REQ_TRE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Field Request Tree Update Status D=Saved as Draft F=Failed N=None S=Success Default Value: N
13	BO_REQ_DTL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Financial Structure Request Detail Status A=Approved C=Canceled D=Denied E=Error F=Completed P=Pending Approval R=In Review Default Value: R
14	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
15	FIELDNAME1	Character(18)	VARCHAR2(18) NOT NULL	Field Name 1 Prompt Table: BO_REQ_TFLD_VW
16	FIELDVALUE1	Character(30)	VARCHAR2(30) NOT NULL	Field Value Prompt Table: %EDITTABLE
17	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description