ROLENAMEBC_PROJ_REQ_STATUS01=Approved
02=Pending
03=Submitted
04=Canceled
05=Declined
06=Returned
07=Costing
08=Hold
09=Complete
10=Executed
11=Operationally Approved
01=Edit Page
02=View Page
BC_PROJ_ROL(SQL Table) |
Index Back |
|---|---|
Project Request EditRecord contains data on Project Request Edit based on Role, Project Request Status. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 2 | BC_PROJ_REQ_STATUS |
Character(2) | VARCHAR2(2) NOT NULL |
Status of the Project Request.
01=Approved 02=Pending 03=Submitted 04=Canceled 05=Declined 06=Returned 07=Costing 08=Hold 09=Complete 10=Executed 11=Operationally Approved |
| 3 | BC_PROJ_EDIT | Character(2) | VARCHAR2(2) NOT NULL |
This field determines if the Project Request pages are View Only(View) or Updatable(Edit)
01=Edit Page 02=View Page |
| 4 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
| 5 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 6 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 7 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |