Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Banner Relationship Management Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AB_EM_ORGANIZATION

Description Source composite view contains information for all em organization that may be attached to an interaction.

Target Column Business Definition Database Data Type Source Name Source Column
EM_ORGANIZATION EM Organization associated with the Interaction. VARCHAR2(63)

REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LD Long description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_1 EM Organization Level 1 (Root Organization) associated with the Interaction. VARCHAR2(63)

REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LEVEL_1_LD Long description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_1_SD Short description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

DESCRIPTION

EM_ORGANIZATION_LEVEL_2 EM Organization Level 2 (Level below the Root Organization) associated with the Interaction. VARCHAR2(63)

REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LEVEL_2_LD Long description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_2_SD   VARCHAR2(255)

REL_ORGANIZATION

DESCRIPTION

EM_ORGANIZATION_LEVEL_3 EM Organization Level 3 (two levels below the Root Organization) associated with the Interaction. VARCHAR2(63)

REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LEVEL_3_LD Long description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_3_SD Short description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_4 EM Organization Level 4 (three levels below the Root Organization) associated with the Interaction. VARCHAR2(63)

REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LEVEL_4_LD Long description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_4_SD Short description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

DESCRIPTION

EM_ORGANIZATION_LEVEL_5 EM Organization Level 5 (four levels below the Root Organization) associated with the Interaction. VARCHAR2(63)

REL_ORGANIZATION

PRIMARY_KEY

EM_ORGANIZATION_LEVEL_5_LD Long description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

NAME

EM_ORGANIZATION_LEVEL_5_SD Short description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

DESCRIPTION

EM_ORGANIZATION_SD Short description for the EM Organization. VARCHAR2(255)

REL_ORGANIZATION

DESCRIPTION



Ver: