RETURN TO BANNER EDW META DATA REPORTS LIST
Constituent Employment Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_CONST_EMPLOYMENT_POSITION

Description Constituent employment position dimension table provides information about the employment position for a constituent. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
CONST_EMPLOYMENT_POSITION_KEY   NUMBER       NO
FIELD_OF_WORK It identifies the type of work that this constituent does (accounting, education, banking, etc.). VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
FIELD_OF_WORK_LD The long description for the constituent's field of work. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
FIELD_OF_WORK_SD The short description for the constituent's field of work. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
POSITION_LEVEL The constituent������������������������s relative position level within this organization. VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
POSITION_LEVEL_LD Long description of the position level. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
POSITION_LEVEL_SD Short description of the position level. VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

SYSTEM_LOAD_PROCESS

'CONST_EMPLOYMENT_POSITION_D1B'

NO

NO CONSTITUENT EMPLOYMENT
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO


Ver: 9.0