BUILDING PROJECT Table
View exposing facilities building project master records including project identifiers, status, milestone dates, budget attributes, organizational contacts, and related project administration attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALTERNATE_ADDRESS |
Alternate address as provided by the source. |
VARCHAR2 |
30 |
ALTERNATE_CONTACT |
Alternate contact as provided by the source. |
VARCHAR2 |
60 |
ALTERNATE_EMAIL |
Alternate email as provided by the source. |
VARCHAR2 |
30 |
ALTERNATE_PHONE |
Alternate phone as provided by the source. |
VARCHAR2 |
30 |
APPROVING_ENTITY |
Approving entity as provided by the source. |
VARCHAR2 |
50 |
BUILDING_PROJECT_KEY |
Surrogate key identifying the building project. |
NUMBER |
38 |
CREATE_BY |
Create by as provided by the source. |
VARCHAR2 |
50 |
CREATE_DATE |
Date associated with create. |
DATE |
|
CRSP_BUDGET |
Crsp budget as provided by the source. |
NUMBER |
16,2 |
CRSP_BUDGET_DESCRIPTION |
Description of crsp budget. |
VARCHAR2 |
4000 |
CRSP_DECISION |
Crsp decision as provided by the source. |
VARCHAR2 |
5 |
CRSP_PRELIMINARY_BUDGET |
Crsp preliminary budget as provided by the source. |
NUMBER |
16,2 |
CRSP_STATUS |
Crsp status as provided by the source. |
CHAR |
|
DATE_CONSTRUCTION_COMPLETION |
Date construction completion as provided by the source. |
DATE |
|
DATE_CONSTRUCTION_START |
Date construction start as provided by the source. |
DATE |
|
DATE_FINANCAL_CLOSE |
Date financal close as provided by the source. |
DATE |
|
DEAN_OR_SENIOR_OFFICER |
Dean or senior officer as provided by the source. |
VARCHAR2 |
255 |
FLAG_BUILDING_SET_BY_USER |
Flag building set by user as provided by the source. |
CHAR |
|
FUNDING_COMMENT |
Funding comment as provided by the source. |
VARCHAR2 |
255 |
IS_ACTIVE_PROJECT |
Indicator identifying whether active project (Y/N). |
CHAR |
|
MODIFY_BY |
Modify by as provided by the source. |
VARCHAR2 |
50 |
MODIFY_DATE |
Date associated with modify. |
DATE |
|
OCCUPANCY_DATE |
Date associated with occupancy. |
DATE |
|
ORGANIZATION_MAJOR |
Organization major as provided by the source. |
VARCHAR2 |
60 |
PRIMARY_BUILDING |
Primary building as provided by the source. |
VARCHAR2 |
20 |
PROJECT_APPROVED_DATE |
Date associated with project approved. |
DATE |
|
PROJECT_COMMENT |
Project comment as provided by the source. |
VARCHAR2 |
100 |
PROJECT_ID |
Business identifier for the project. |
VARCHAR2 |
40 |
PROJECT_NAME |
Project name as provided by the source. |
VARCHAR2 |
150 |
PROJECT_START_DATE |
Date associated with project start. |
DATE |
|
PROJECT_STATUS |
Project status as provided by the source. |
VARCHAR2 |
50 |
RECIPIENT_DLC_NAME |
Recipient dlc name as provided by the source. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |