RETURN TO BANNER EDW META DATA REPORTS LIST


Advancement Degree Star Report

Target Reports:

WDT_ADVANCEMENT_DEGREE - Advancement Degree Dimension
Advancement degree dimension table provides information about a constituent's degree. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_ADVANCEMENT_DEG_ATTR - Advancement Deg Attr Dimension
Advancement degree attribute dimension table provides additional attributes related to a constituent's degree. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_ADVANCEMENT_DEG_COMMENTS - Advancement Deg Comments Dimension
Advancement degree comments dimension table provides comments about a constituent's degree, including advisor name and dissertation title, as applicable. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_ADVANCEMENT_DEG_YEAR - Advancement Deg Year Dimension
Advancement degree year dimension table identifies the degree year and description. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_ADVANCEMENT_HON_DEGREE - Advancement Hon Degree Dimension
Advancement honorary degree dimension table identifies the honorary degree and description. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_ADVANCEMENT_INSTITUTION - Advancement Institution Dimension
Advancement institution dimension table provides information the institution from which a constituent earned a degree, either your institution or another institution. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_ENTITY - Entity Dimension
Entity dimension table provides information about a person or organization. It uses the cleansing rules in the EDW for the short and long descriptions.
WDT_MULTI_SOURCE - Multi Source Dimension
Multi Source Dimension table provides an institution source value when the optional multi-source feature has been applied. Institution source VALUES have a short and long description. Data in this dimension may optionally include a process-oriented identifier and an administrative-oriented identifier for the record used to determine access authorization to this record. The cleansing rules are used in the EDW for the short and long descriptions.

WFT_ADVANCEMENT_DEGREE - Advancement Degree Fact Table
Advancement degree fact table provides measures for any degrees earned by a constituent, either at your institution or any other institution, including secondary and post secondary schools.

Source Reports:

AOBORGN
APBCONS_1
APRADEG
ATVSICC
ATVSICC
CLN_ADVANCEMENT_DEGREE
CLN_ADVANCEMENT_DEG_COMMENTS
CLN_ADVANCEMENT_DEG_YEAR
CLN_ADVANCEMENT_INSTITUTION
CLN_ENTITY
CLN_ENTITY
CLN_MULTI_SOURCE
CLN_MULTI_SOURCE
CONFIDENTIALITY_IND_EXPRESSION
CONSTANT
CONSTANT
CONSTANT
CONSTANT_0
CONSTITUENT_IND_EXPRESSION
EXPRESSIONS
EXP_GET_TO_DT
EXP_TRUNC_CREATE_DT
FULL_NAME_EXPRESSION
GOREMAL
GROUP_COUNT_EXPRESSIONS
MIDDLE_INITIAL_EXPRESSION
NVL_GRP_KEY
No Source
PERSON_IND_EXPRESSION
PREFFERED_PHONE_NUMBER
SPBPERS
SPRIDEN
STVACAT
STVACYR
STVCAMP
STVCOLL
STVCOLL
STVDEGC
STVDLEV
STVSBGI
SYSTEM_LOAD_PROCESS
WCV_DEFAULT_VALUES
WDT_WAREHOUSE_ENTITY
WDT_WAREHOUSE_ENTITY


Ver: 9.0