BUILDING PROJECT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALTERNATE_ADDRESS |
XXX |
VARCHAR2 |
30 |
ALTERNATE_CONTACT |
XXX |
VARCHAR2 |
60 |
ALTERNATE_EMAIL |
XXX |
VARCHAR2 |
30 |
ALTERNATE_PHONE |
XXX |
VARCHAR2 |
30 |
APPROVING_ENTITY |
XXX |
VARCHAR2 |
50 |
BUILDING_PROJECT_KEY |
XXX |
NUMBER |
38 |
CREATE_BY |
XXX |
VARCHAR2 |
50 |
CREATE_DATE |
Date when UROP applicatioan initiated. |
DATE |
|
CRSP_BUDGET |
XXX |
NUMBER |
16,2 |
CRSP_BUDGET_DESCRIPTION |
XXX |
VARCHAR2 |
4000 |
CRSP_DECISION |
XXX |
VARCHAR2 |
5 |
CRSP_PRELIMINARY_BUDGET |
XXX |
NUMBER |
16,2 |
CRSP_STATUS |
XXX |
CHAR |
|
DATE_CONSTRUCTION_COMPLETION |
XXX |
DATE |
|
DATE_CONSTRUCTION_START |
XXX |
DATE |
|
DATE_FINANCAL_CLOSE |
XXX |
DATE |
|
DEAN_OR_SENIOR_OFFICER |
XXX |
VARCHAR2 |
255 |
FLAG_BUILDING_SET_BY_USER |
XXX |
CHAR |
|
FUNDING_COMMENT |
XXX |
VARCHAR2 |
255 |
IS_ACTIVE_PROJECT |
XXX |
CHAR |
|
MODIFY_BY |
XXX |
VARCHAR2 |
50 |
MODIFY_DATE |
XXX |
DATE |
|
OCCUPANCY_DATE |
XXX |
DATE |
|
ORGANIZATION_MAJOR |
XXX |
VARCHAR2 |
60 |
PRIMARY_BUILDING |
XXX |
VARCHAR2 |
20 |
PROJECT_APPROVED_DATE |
XXX |
DATE |
|
PROJECT_COMMENT |
XXX |
VARCHAR2 |
100 |
PROJECT_ID |
Project ID, may or may not be the same as the Project WBS ID (will be different if there is a hierarchy). |
VARCHAR2 |
40 |
PROJECT_NAME |
XXX |
VARCHAR2 |
150 |
PROJECT_START_DATE |
XXX |
DATE |
|
PROJECT_STATUS |
Status of an UROP project. Examples: Approved, Cancelled, Rejected. |
VARCHAR2 |
50 |
RECIPIENT_DLC_NAME |
XXX |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |