BO_REQ_DIS_VW

(SQL View)
 Index Back

FSR Discussion

Financial Structure Request with Discussion ID View

SELECT BO_REQUEST_ID , 0 , EOFD_MESSAGE_ID , BO_REQ_REASON , ' ' , ' ' , ' ' , BO_REQ_STATUS , ' ' , GL_ENTERED_BY , ' ' FROM PS_BO_REQUEST UNION SELECT D.BO_REQUEST_ID , D.BO_REQ_DTL_NO , D.EOFD_MESSAGE_ID , M.BO_REQ_REASON , D.SETID , D.FIELDNAME1 , D.FIELDVALUE1 , M.BO_REQ_STATUS , D.BO_REQ_DTL_STATUS , M.GL_ENTERED_BY , D.GL_ROLENAME FROM PS_BO_REQUEST_DTL D , PS_BO_REQUEST M WHERE D.BO_REQUEST_ID = M.BO_REQUEST_ID

# 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 EOFD_MESSAGE_ID Character(30) VARCHAR2(30) NOT NULL Discussion Message ID
4 BO_REQ_REASON Character(20) VARCHAR2(20) NOT NULL Financial Structure Request Reason
5 SETID1 Character(5) VARCHAR2(5) NOT NULL SetID Value
6 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
7 FIELDVALUE1 Character(30) VARCHAR2(30) NOT NULL Field Value
8 BO_REQ_STATUS Character(1) VARCHAR2(1) NOT NULL Financial Structure Request Status
C=Canceled
E=Error
F=Completed
N=New
P=In Progress

Default Value: N

9 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

10 GL_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By
11 GL_ROLENAME Character(30) VARCHAR2(30) NOT NULL Role Name