Module: Work Asset Analytics
Type: Dimension
PRJ_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PRJ_ID | VARCHAR2 | 12 | True | Project | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ACCOUNT_SEGMENT | VARCHAR2 | 254 | Account Segment | ||||
| ACT_END_DT | DATE | 0 | End Date | ||||
| ACT_START_DT | DATE | 0 | Start Date | ||||
| ALLOW_CHARGE_FLG | VARCHAR2 | 4 | Allow Charge | ||||
| BUDGET_AMT | NUMBER | 17 | 3 | Budget Amount | |||
| EST_END_DT | DATE | 0 | Estimated End Date | ||||
| EST_START_DT | DATE | 0 | Estimated Start Date | ||||
| PRJ_NUM | VARCHAR2 | 38 | Project Number | ||||
| PRJ_STATUS_CD | VARCHAR2 | 38 | Project Status | ||||
| PROJECT_DESCR100 | VARCHAR2 | 100 | Project Description | ||||
| PROJECT_DESCRLONG | VARCHAR2 | 4000 | Project Detailed Description | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |