XM_ PROJECT_NUMBER
| Entity Name | XM_PROJECT_NUMBER | 
|---|---|
| Entity Type | Independent | 
| Definition | A unique identifier assigned to a specific project within an organization. | 
Attributes
| Attribute | Datatype | Width | Definition | 
|---|---|---|---|
| PROJECT_NUMBER_ID | Integer | 11 | |
| PROJECT_USER_ID | Integer | 1 | |
| LEVEL_1_PROJECT_CODE | Varchar | 132 | |
| LEVEL_1_PROJECT_NAME | Varchar | 83 | |
| LEVEL_2_PROJECT_CODE | Varchar | 176 | |
| LEVEL_2_PROJECT_NAME | Varchar | 159 | |
| LEVEL_3_PROJECT_CODE | Varchar | 188 | |
| LEVEL_3_PROJECT_NAME | Varchar | 12 | |
| CLIENT_CODE | Varchar | 40 | |
| CLIENT_NAME | Varchar | 132 | |
| CODE_LEVEL | Integer | 1 | |
| IS_CHARGEABLE | Integer | 1 | |
| START_DATE | DateTime | ||
| END_DATE | DateTime | ||
| CHARGE_NAME | Varchar | 12 | |
| DEFAULT_REVIEWER_ID | Integer | 11 | |
| CHANGE_TIMESTAMP | DateTime | ||
| EXTERNAL_KEY | Varchar | 29 | |
| ACTIVE_STATUS | Varchar | 10 | |
| PROJECT_DESCRIPTION | Varchar | 255 | |
| ALTERNATE_REVIEWER_ID | Integer | 1 |