ALEX_PROJECT_CODE (Staging table)
| Column name | Data type | Required | Default update able | Data target | Comments |
|---|---|---|---|---|---|
| EXTERNAL_KEY** | VARCHAR (255) | Yes* | No | ALCO_EXTERNAL_KEY.EXTERNAL_KEY | External key – primary key |
| PROJECT_CHARGE_CODE | VARCHAR (255) | Yes* | Yes | ALCO_PROJECT_NUMBER.PROJECT_CHARGE_CODE | Uniquely identifies a project or task. Can be created by concatenating the top project code and the project code, separated by a delimiter. |
| PROJECT_CODE | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.PROJECT_CODE | Project code segment |
| PROJECT_NAME | VARCHAR (255) | Yes* | Yes | ALCO_PROJECT_NUMBER.PROJECT_NAME | Name of project |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_PROJECT_NUMBER.PROJECT_NUM_ACTIVE_STATUS | Flag to indicate whether group is active or inactive.
|
| PROJECT_DESC | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.PROJECT_DESCRIPTION | Description of project |
| LEVEL_1_LEADER_USER_EKEY | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.LEVEL_1_LEADER_ID | External key of level 1 project manager user |
| LEVEL_2_LEADER_USER_EKEY | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.LEVEL_2_LEADER_ID | External key of level 2 project manager user |
| LEVEL_3_LEADER_USER_EKEY | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.LEVEL_3_LEADER_ID | External key of level 3 project manager user |
| LEVEL_4_LEADER_USER_EKEY | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.LEVEL_4_LEADER_ID | External key of level 4 project manager user |
| DEFAULT_REVIEWER_USER_EKEY | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.DEFAULT_REVIEWER_ID | External key of default project reviewer user |
| ALT_DEFAULT_REVIEWER_USER_EKEY | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.ALTERNATIVE_REVIEWER_ID | External key of alternate default project reviewer user |
| IS_REQUIRED | SMALLINT | No | Yes | ALCO_PROJECT_NUMBER.IS_REQUIRED | Determines whether or not this project segment is displayed
in charge-code chooser drop-down control.
|
| CLIENT_EKEY | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.CLIENT_ID | This external key is used to look up the client id of the client associated with this code segment. |
| PARENT_PROJECT_EKEY*** | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.PARENT_PROJECT_CODE | This external key defines the parent charge code. This relationship forms part of the data hierarchical relationship to the code segment parent. |
| CODE_LEVEL | SMALLINT | Yes* | Yes | ALCO_PROJECT_NUMBER.CODE_LEVEL | This field provides the level at which this code segment is in the hierarchical data structure. |
| IS_CHARGEABLE | SMALLINT | No | Yes | ALCO_PROJECT_NUMBER.IS_CHARGEABLE | This flag indicates whether the code segment can be selected
in the hierarchical chooser.
|
| TOP_PROJECT_EKEY*** | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.TOP_PROJECT_CODE | The root project external key |
| OFFICE_EKEY | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.OFFICE_ID | The office external key is used to assign an office ID to the code segment. |
| CHARGE_TYPE_EKEY | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.CHARGE_TYPE_ID | This is the charge type external key of the code segment.
Determines whether the code segment is one of these:
|
| START_DATE | DATETIME | No | Yes | ALCO_PROJECT_NUMBER.START_DATE | Project start date |
| END_DATE | DATETIME | No | Yes | ALCO_PROJECT_NUMBER.END_DATE | Project end date |
| PROJECT_ACTIVITY_TYPE_EKEY | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.PROJECT_ACTIVITY_TYPE_ID | Project activity type external key |
| HIER_PROJECT_NAME | VARCHAR (255) | No | Yes | ALCO_PROJECT_NUMBER.HIER_PROJECT_NAME | The hierarchical project name that is displayed below the project charge code on the Timesheet Line Items panel. |
| PROJECT_ACCOUNTING_ENTITY_CODE | VARCHAR(255) | No | Yes | ALCO_PROJECT_NUMBER.PROJECT_ACCOUNTING_ENTITY_CODE | Stores the accounting entity id |
*System required field
** Value must be unique
*** top_project_ekey and parent_project_ekey must be NULL for a level 1 project