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.
  • 1 = Active
  • 0 = 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.
  • 1 = Yes
  • 0 = No
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.
  • 1 = Yes
  • 0 = No
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:
  • Billable
  • Non-Billable
  • Overhead
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