BO_REQUEST_IDC=Canceled
E=Error
F=Completed
N=New
P=In Progress
Default Value: N
Y/N Table Edit
Default Value: N
Prompt Table: OPRID_VW
BO_REQUEST(SQL Table) |
Index Back |
|---|---|
FSR MasterFinancial Structure Request Master |
| # | 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_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 |
| 3 | BO_REQ_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Financial Structure Request Security Flag
Y/N Table Edit Default Value: N |
| 4 | BO_REQ_REASON | Character(20) | VARCHAR2(20) NOT NULL | Financial Structure Request Reason |
| 5 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 7 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 8 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 9 | GL_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered By |
| 10 | GL_ENTERED_DTTM | DateTime(26) | TIMESTAMP | Entered Date/Time |
| 11 | GL_UPDATED_BY | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 12 | GL_UPDATED_DTTM | DateTime(26) | TIMESTAMP | Updated Date/Time |
| 13 | EOFD_MESSAGE_ID | Character(30) | VARCHAR2(30) NOT NULL | Discussion Message ID |
| 14 | GL_DESCRLONG | Long Character | CLOB | Long Description |