Docstoc

STUDENT_DATA_DICTIONARY_11-14-05

Document Sample
STUDENT_DATA_DICTIONARY_11-14-05 Powered By Docstoc
					                                                                  Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                                   Data                                                                  For AAA
Data Name                         Data Description                                    Data Format Length Data Source          Data Transformation                        Reports
BANNER_ID                         Advisor's Banner ID                                 VARCHAR2      9    SPRIDEN_ID
CODE                              Code indicating the type of advisor the person is   VARCHAR2      4    SGRADVR_ADVR_CODE
FIRST_NAME                        Advisor's legal first name                          VARCHAR2      30   SPRIDEN_FIRST_NAME
LAST_NAME                         Advisor's legal last name                           VARCHAR2      60   SPRIDEN_LAST_NAME
MIDDLE_NAME                       Advisor's legal middle name                         VARCHAR2      30   SPRIDEN_MI
PIDM                              Advisor's unique identifier in Banner               NUMBER        8    SGRADVR_ADVR_PIDM
                                                                                                         SSBSECT_TERM_CODE,   Expression (SSBSECT_TERM_CODE ||
SK_STDPIDM_TERM                   Surrogate key for the dimension                     VARCHAR2      20   SGRADVR_PIDM         SGRADVR_PIDM)
STD_PIDM                          Student's unique identifier in Banner               NUMBER        8    SGRADVR_PIDM
TERM_CODE                         Term during which the data applies                  VARCHAR2      6    SSBSECT_TERM_CODE




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                            Page 1 of 227                                                    4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                      Page 2 of 227                                       4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                      Page 3 of 227                                       4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                      Page 4 of 227                                       4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                      Page 5 of 227                                       4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                      Page 6 of 227                                       4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                      Page 7 of 227                                       4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                      Page 8 of 227                                       4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                      Page 9 of 227                                       4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                     Page 10 of 227                                       4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                     Page 11 of 227                                       4/21/2012
                                                               Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DADVISOR                          Student Advisors Dimension
                                                                                            Data                                                      For AAA
Data Name                         Data Description                             Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                     Page 12 of 227                                       4/21/2012
                                                                       Banner Reporting Warehouse Documentation (Student)
Table Name                             Table Description
DCONTACT                               Contact Information Dimension
                                                                                                        Data                                                                              For AAA
Data Name                              Data Description                                Data Format     Length Data Source                        Data Transformation                      Reports
                                                                                                              GOREMAL_EMAIL_ADDRESS where
BUSINESS_EMAIL                         Business e-mail address                         VARCHAR2          90   GOREMAL_EMAL_CODE='BUSN'           UNPIVOT_EMAIL
                                                                                                                SPRTELE_PHONE_AREA,
                                                                                                                SPRTELE_PHONE_NUMBER,
                                                                                                                SPRTELE_PHONE_EXT where
                                                                                                                SPRTELE_STATUS_IND is null and
BUSINESS_PHONE                         Business phone number                           VARCHAR2          14     SPRTELE_TELE_CODE='BU'           CONCAT_PHONE and UNPIVOT_PHONE
                                                                                                                GOREMAL_EMAIL_ADDRESS where
CAMPUS_EMAIL                           Campus e-mail address                           VARCHAR2          90     GOREMAL_EMAL_CODE='CAMP'         UNPIVOT_EMAIL
                                                                                                                SPRADDR_CITY where
DIPLOMA_CITY                           Diploma address city                            VARCHAR2          20     SPRADDR_ATYP_CODE = 'DP'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_CNTY_CODE where
DIPLOMA_CNTY_CODE                      Diploma address county code                     VARCHAR2           5     SPRADDR_ATYP_CODE = 'DP'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_CNTY_CODE &
                                                                                                                STVCNTY_DESC where
DIPLOMA_CNTY_NAME                      Diploma address county name                     VARCHAR2          30     SPRADDR_ATYP_CODE = 'DP'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_NATN_CODE where
DIPLOMA_NATN_CODE                      Diploma address nation code                     VARCHAR2           5     SPRADDR_ATYP_CODE = 'DP'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_NATN_CODE &
                                                                                                                STVNATN_NATION where
DIPLOMA_NATN_NAME                      Diploma address nation name                     VARCHAR2          30     SPRADDR_ATYP_CODE = 'DP'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_STAT_CODE where
DIPLOMA_STAT_CODE                      Diploma address state postal code               VARCHAR2           3     SPRADDR_ATYP_CODE = 'DP'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_STREET_LINE1 where
DIPLOMA_STREET1                        Diploma address street line 1                   VARCHAR2          30     SPRADDR_ATYP_CODE = 'DP'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_STREET_LINE2 where
DIPLOMA_STREET2                        Diploma address street line 2                   VARCHAR2          30     SPRADDR_ATYP_CODE = 'DP'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_STREET_LINE3 where
DIPLOMA_STREET3                        Diploma address street line 3                   VARCHAR2          30     SPRADDR_ATYP_CODE = 'DP'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_ZIP where
DIPLOMA_ZIP                            Diploma address zip code                        VARCHAR2          10     SPRADDR_ATYP_CODE = 'DP'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_CITY where
EMR_CNTCT_CITY                         Emergency contact address city                  VARCHAR2          20     SPRADDR_ATYP_CODE = 'EM'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_CNTY_CODE where
EMR_CNTCT_CNTY_CODE                    Emergency contact address county code           VARCHAR2           5     SPRADDR_ATYP_CODE = 'EM'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_CNTY_CODE &
                                                                                                                STVCNTY_DESC where
EMR_CNTCT_CNTY_NAME                    Emergency contact address county name           VARCHAR2          30     SPRADDR_ATYP_CODE = 'EM'         UNPIVOT_ADDRESS
                                                                                                                SPRTELE_INTERNATIONAL where
                                                                                                                SPRTELE_STATUS_IND is null and
EMR_CNTCT_INTNL_PHONE                  Emergency contact international phone number    VARCHAR2          16     SPRTELE_TELE_CODE='EM'           UNPIVOT_PHONE
                                                                                                                SPRADDR_NATN_CODE where
EMR_CNTCT_NATN_CODE                    Emergency contact address nation code           VARCHAR2           5     SPRADDR_ATYP_CODE = 'EM'         UNPIVOT_ADDRESS
                                                                                                                SPRADDR_NATN_CODE &
                                                                                                                STVNATN_NATION where
EMR_CNTCT_NATN_NAME                    Emergency contact address nation name           VARCHAR2          30     SPRADDR_ATYP_CODE = 'EM'         UNPIVOT_ADDRESS
                                                                                                                SPRTELE_PHONE_AREA,
                                                                                                                SPRTELE_PHONE_NUMBER,
                                                                                                                SPRTELE_PHONE_EXT where
                                                                                                                SPRTELE_STATUS_IND is null and
EMR_CNTCT_PHONE                        Emergency contact phone number                  VARCHAR2          14     SPRTELE_TELE_CODE='EM'           CONCAT_PHONE and UNPIVOT_PHONE
                                                                                                                SPRADDR_STAT_CODE where
EMR_CNTCT_STAT_CODE                    Emergency contact address state postal code     VARCHAR2           3     SPRADDR_ATYP_CODE = 'EM'         UNPIVOT_ADDRESS

            3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                           Page 13 of 227                                                                 4/21/2012
                                                                       Banner Reporting Warehouse Documentation (Student)
Table Name                             Table Description
DCONTACT                               Contact Information Dimension
                                                                                                        Data                                                                            For AAA
Data Name                              Data Description                                Data Format     Length Data Source                      Data Transformation                      Reports
                                                                                                              SPRADDR_STREET_LINE1 where
EMR_CNTCT_STREET1                      Emergency contact address street line 1         VARCHAR2          30   SPRADDR_ATYP_CODE = 'EM'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_STREET_LINE2 where
EMR_CNTCT_STREET2                      Emergency contact address street line 2         VARCHAR2          30   SPRADDR_ATYP_CODE = 'EM'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_STREET_LINE3 where
EMR_CNTCT_STREET3                      Emergency contact address street line 3         VARCHAR2          30   SPRADDR_ATYP_CODE = 'EM'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_ZIP where
EMR_CNTCT_ZIP                          Emergency contact address zip code              VARCHAR2          10   SPRADDR_ATYP_CODE = 'EM'         UNPIVOT_ADDRESS
                                                                                                              SPRTELE_INTERNATIONAL where
                                                                                                              SPRTELE_STATUS_IND is null and
FAX_INTNL_PHONE                        Fax international phone number                  VARCHAR2          16   SPRTELE_TELE_CODE='FAX'          UNPIVOT_PHONE
                                                                                                              SPRTELE_PHONE_AREA,
                                                                                                              SPRTELE_PHONE_NUMBER,
                                                                                                              SPRTELE_PHONE_EXT where
                                                                                                              SPRTELE_STATUS_IND is null and
FAX_PHONE                              Fax phone number                                VARCHAR2          14   SPRTELE_TELE_CODE='FAX'          CONCAT_PHONE and UNPIVOT_PHONE
                                                                                                              SPRADDR_CITY where
MAILING_CITY                           Mailing address city                            VARCHAR2          20   SPRADDR_ATYP_CODE = 'MA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_CNTY_CODE where
MAILING_CNTY_CODE                      Mailing address county code                     VARCHAR2          5    SPRADDR_ATYP_CODE = 'MA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_CNTY_CODE &
                                                                                                              STVCNTY_DESC where
MAILING_CNTY_NAME                      Mailing address county name                     VARCHAR2          30   SPRADDR_ATYP_CODE = 'MA'         UNPIVOT_ADDRESS
                                                                                                              SPRTELE_INTERNATIONAL where
                                                                                                              SPRTELE_STATUS_IND is null and
MAILING_INTNL_PHONE                    Mailing address international phone number      VARCHAR2          16   SPRTELE_TELE_CODE='MA'           UNPIVOT_PHONE
                                                                                                              SPRADDR_NATN_CODE where
MAILING_NATN_CODE                      Mailing address nation code                     VARCHAR2          5    SPRADDR_ATYP_CODE = 'MA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_NATN_CODE &
                                                                                                              STVNATN_NATION where
MAILING_NATN_NAME                      Mailing address nation name                     VARCHAR2          30   SPRADDR_ATYP_CODE = 'MA'         UNPIVOT_ADDRESS
                                                                                                              SPRTELE_PHONE_AREA,
                                                                                                              SPRTELE_PHONE_NUMBER,
                                                                                                              SPRTELE_PHONE_EXT where
                                                                                                              SPRTELE_STATUS_IND is null and
MAILING_PHONE                          Mailing address phone number                    VARCHAR2          14   SPRTELE_TELE_CODE='MA'           CONCAT_PHONE and UNPIVOT_PHONE
                                                                                                              SPRADDR_STAT_CODE where
MAILING_STAT_CODE                      Mailing address state postal code               VARCHAR2          3    SPRADDR_ATYP_CODE = 'MA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_STREET_LINE1 where
MAILING_STREET1                        Mailing address street line 1                   VARCHAR2          30   SPRADDR_ATYP_CODE = 'MA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_STREET_LINE2 where
MAILING_STREET2                        Mailing address street line 2                   VARCHAR2          30   SPRADDR_ATYP_CODE = 'MA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_STREET_LINE3 where
MAILING_STREET3                        Mailing address street line 3                   VARCHAR2          30   SPRADDR_ATYP_CODE = 'MA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_ZIP where
MAILING_ZIP                            Mailing address zip code                        VARCHAR2          10   SPRADDR_ATYP_CODE = 'MA'         UNPIVOT_ADDRESS                             x
                                                                                                              SPRTELE_INTERNATIONAL where
                                                                                                              SPRTELE_STATUS_IND is null and
MOBILE_INTNL_PHONE                     Mobile international phone number               VARCHAR2          16   SPRTELE_TELE_CODE='MOB'          UNPIVOT_PHONE




            3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                           Page 14 of 227                                                               4/21/2012
                                                                       Banner Reporting Warehouse Documentation (Student)
Table Name                             Table Description
DCONTACT                               Contact Information Dimension
                                                                                                        Data                                                                            For AAA
Data Name                              Data Description                                Data Format     Length Data Source                      Data Transformation                      Reports
                                                                                                              SPRTELE_PHONE_AREA,
                                                                                                              SPRTELE_PHONE_NUMBER,
                                                                                                              SPRTELE_PHONE_EXT where
                                                                                                              SPRTELE_STATUS_IND is null and
MOBILE_PHONE                           Mobile phone number                             VARCHAR2          14   SPRTELE_TELE_CODE='MOB'          CONCAT_PHONE and UNPIVOT_PHONE
                                                                                                              GOREMAL_EMAIL_ADDRESS where
OFFICIAL_CAMPUS_EMAIL                  Official campus e-mail address                  VARCHAR2          90   GOREMAL_EMAL_CODE='MCCM'         UNPIVOT_EMAIL
                                                                                                              SPRADDR_CITY where
PARENTS_CITY                           Parents address city                            VARCHAR2          20   SPRADDR_ATYP_CODE = 'PA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_CNTY_CODE where
PARENTS_CNTY_CODE                      Parents address county code                     VARCHAR2          5    SPRADDR_ATYP_CODE = 'PA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_CNTY_CODE &
                                                                                                              STVCNTY_DESC where
PARENTS_CNTY_NAME                      Parents address county name                     VARCHAR2          30   SPRADDR_ATYP_CODE = 'PA'         UNPIVOT_ADDRESS
                                                                                                              SPRTELE_INTERNATIONAL where
                                                                                                              SPRTELE_STATUS_IND is null and
PARENTS_INTNL_PHONE                    Parents address international phone number      VARCHAR2          16   SPRTELE_TELE_CODE='PA'           UNPIVOT_PHONE
                                                                                                              SPRADDR_NATN_CODE where
PARENTS_NATN_CODE                      Parents address nation code                     VARCHAR2          5    SPRADDR_ATYP_CODE = 'PA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_NATN_CODE &
                                                                                                              STVNATN_NATION where
PARENTS_NATN_NAME                      Parents address nation name                     VARCHAR2          30   SPRADDR_ATYP_CODE = 'PA'         UNPIVOT_ADDRESS
                                                                                                              SPRTELE_PHONE_AREA,
                                                                                                              SPRTELE_PHONE_NUMBER,
                                                                                                              SPRTELE_PHONE_EXT where
                                                                                                              SPRTELE_STATUS_IND is null and
PARENTS_PHONE                          Parents address phone number                    VARCHAR2          14   SPRTELE_TELE_CODE='PA'           CONCAT_PHONE and UNPIVOT_PHONE
                                                                                                              SPRADDR_STAT_CODE where
PARENTS_STAT_CODE                      Parents address state postal code               VARCHAR2          3    SPRADDR_ATYP_CODE = 'PA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_STREET_LINE1 where
PARENTS_STREET1                        Parents address street line 1                   VARCHAR2          30   SPRADDR_ATYP_CODE = 'PA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_STREET_LINE2 where
PARENTS_STREET2                        Parents address street line 2                   VARCHAR2          30   SPRADDR_ATYP_CODE = 'PA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_STREET_LINE3 where
PARENTS_STREET3                        Parents address street line 3                   VARCHAR2          30   SPRADDR_ATYP_CODE = 'PA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_ZIP where
PARENTS_ZIP                            Parents address zip code                        VARCHAR2          10   SPRADDR_ATYP_CODE = 'PA'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_CITY where
PERMANENT_CITY                         Permanent address city                          VARCHAR2          20   SPRADDR_ATYP_CODE = 'PR'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_CNTY_CODE where
PERMANENT_CNTY_CODE                    Permanent address county code                   VARCHAR2          5    SPRADDR_ATYP_CODE = 'PR'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_CNTY_CODE &
                                                                                                              STVCNTY_DESC where
PERMANENT_CNTY_NAME                    Permanent address county name                   VARCHAR2          30   SPRADDR_ATYP_CODE = 'PR'         UNPIVOT_ADDRESS
                                                                                                              SPRTELE_INTERNATIONAL where
                                                                                                              SPRTELE_STATUS_IND is null and
PERMANENT_INTNL_PHONE                  Permanent address international phone number    VARCHAR2          16   SPRTELE_TELE_CODE='PR'           UNPIVOT_PHONE
                                                                                                              SPRADDR_NATN_CODE where
PERMANENT_NATN_CODE                    Permanent address nation code                   VARCHAR2          5    SPRADDR_ATYP_CODE = 'PR'         UNPIVOT_ADDRESS
                                                                                                              SPRADDR_NATN_CODE &
                                                                                                              STVNATN_NATION where
PERMANENT_NATN_NAME                    Permanent address nation name                   VARCHAR2          30   SPRADDR_ATYP_CODE = 'PR'         UNPIVOT_ADDRESS


            3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                           Page 15 of 227                                                               4/21/2012
                                                                    Banner Reporting Warehouse Documentation (Student)
Table Name                             Table Description
DCONTACT                               Contact Information Dimension
                                                                                                           Data                                                                            For AAA
Data Name                              Data Description                                   Data Format     Length Data Source                      Data Transformation                      Reports
                                                                                                                 SPRTELE_PHONE_AREA,
                                                                                                                 SPRTELE_PHONE_NUMBER,
                                                                                                                 SPRTELE_PHONE_EXT where
                                                                                                                 SPRTELE_STATUS_IND is null and
PERMANENT_PHONE                        Permanent address phone number                     VARCHAR2          14   SPRTELE_TELE_CODE='PR'           CONCAT_PHONE and UNPIVOT_PHONE
                                                                                                                 SPRADDR_STAT_CODE where
PERMANENT_STAT_CODE                    Permanent address state postal code                VARCHAR2          3    SPRADDR_ATYP_CODE = 'PR'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_STREET_LINE1 where
PERMANENT_STREET1                      Permanent address street line 1                    VARCHAR2          30   SPRADDR_ATYP_CODE = 'PR'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_STREET_LINE2 where
PERMANENT_STREET2                      Permanent address street line 2                    VARCHAR2          30   SPRADDR_ATYP_CODE = 'PR'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_STREET_LINE3 where
PERMANENT_STREET3                      Permanent address street line 3                    VARCHAR2          30   SPRADDR_ATYP_CODE = 'PR'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_ZIP where
PERMANENT_ZIP                          Permanent address zip code                         VARCHAR2          10   SPRADDR_ATYP_CODE = 'PR'         UNPIVOT_ADDRESS
                                                                                                                 GOREMAL_EMAIL_ADDRESS where
PERSONAL_EMAIL                         Personal e-mail address                            VARCHAR2          90   GOREMAL_EMAL_CODE='PERS'         UNPIVOT_EMAIL
PIDM                                   Unique identification number in Banner             NUMBER                 SPRIDEN_PIDM
                                                                                                                 SPRADDR_CITY where
SEVIS_FOR_CITY                         SEVIS Foreign address city                         VARCHAR2          20   SPRADDR_ATYP_CODE = 'SF'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_CNTY_CODE where
SEVIS_FOR_CNTY_CODE                    SEVIS Foreign address county code                  VARCHAR2          5    SPRADDR_ATYP_CODE = 'SF'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_CNTY_CODE &
                                                                                                                 STVCNTY_DESC where
SEVIS_FOR_CNTY_NAME                    SEVIS Foreign address county name                  VARCHAR2          30   SPRADDR_ATYP_CODE = 'SF'         UNPIVOT_ADDRESS
                                                                                                                 SPRTELE_INTERNATIONAL where
                                                                                                                 SPRTELE_STATUS_IND is null and
SEVIS_FOR_INTNL_PHONE                  SEVIS Foreign address international phone number   VARCHAR2          16   SPRTELE_TELE_CODE='SF'           UNPIVOT_PHONE
                                                                                                                 SPRADDR_NATN_CODE where
SEVIS_FOR_NATN_CODE                    SEVIS Foreign address nation code                  VARCHAR2          5    SPRADDR_ATYP_CODE = 'SF'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_NATN_CODE &
                                                                                                                 STVNATN_NATION where
SEVIS_FOR_NATN_NAME                    SEVIS Foreign address nation name                  VARCHAR2          30   SPRADDR_ATYP_CODE = 'SF'         UNPIVOT_ADDRESS
                                                                                                                 SPRTELE_PHONE_AREA,
                                                                                                                 SPRTELE_PHONE_NUMBER,
                                                                                                                 SPRTELE_PHONE_EXT where
                                                                                                                 SPRTELE_STATUS_IND is null and
SEVIS_FOR_PHONE                        SEVIS Foreign address phone number                 VARCHAR2          14   SPRTELE_TELE_CODE='SF'           CONCAT_PHONE and UNPIVOT_PHONE
                                                                                                                 SPRADDR_STAT_CODE where
SEVIS_FOR_STAT_CODE                    SEVIS Foreign address state postal code            VARCHAR2          3    SPRADDR_ATYP_CODE = 'SF'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_STREET_LINE1 where
SEVIS_FOR_STREET1                      SEVIS Foreign address street line 1                VARCHAR2          30   SPRADDR_ATYP_CODE = 'SF'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_STREET_LINE2 where
SEVIS_FOR_STREET2                      SEVIS Foreign address street line 2                VARCHAR2          30   SPRADDR_ATYP_CODE = 'SF'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_STREET_LINE3 where
SEVIS_FOR_STREET3                      SEVIS Foreign address street line 3                VARCHAR2          30   SPRADDR_ATYP_CODE = 'SF'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_ZIP where
SEVIS_FOR_ZIP                          SEVIS Foreign address zip code                     VARCHAR2          10   SPRADDR_ATYP_CODE = 'SF'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_CITY where
SEVIS_LOCAL_CITY                       SEVIS Local address city                           VARCHAR2          20   SPRADDR_ATYP_CODE = 'SL'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_CNTY_CODE where
SEVIS_LOCAL_CNTY_CODE                  SEVIS Local address county code                    VARCHAR2          5    SPRADDR_ATYP_CODE = 'SL'         UNPIVOT_ADDRESS


            3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                              Page 16 of 227                                                               4/21/2012
                                                                    Banner Reporting Warehouse Documentation (Student)
Table Name                             Table Description
DCONTACT                               Contact Information Dimension
                                                                                                         Data                                                                              For AAA
Data Name                              Data Description                                 Data Format     Length Data Source                        Data Transformation                      Reports
                                                                                                               SPRADDR_CNTY_CODE &
                                                                                                               STVCNTY_DESC where
SEVIS_LOCAL_CNTY_NAME                  SEVIS Local address county name                  VARCHAR2          30   SPRADDR_ATYP_CODE = 'SL'           UNPIVOT_ADDRESS
                                                                                                               SPRTELE_INTERNATIONAL where
                                                                                                               SPRTELE_STATUS_IND is null and
SEVIS_LOCAL_INTN                       SEVIS Local address international phone number   VARCHAR2          16   SPRTELE_TELE_CODE='SL'             UNPIVOT_PHONE
                                                                                                               SPRADDR_NATN_CODE where
SEVIS_LOCAL_NATN_CODE                  SEVIS Local address nation code                  VARCHAR2          5    SPRADDR_ATYP_CODE = 'SL'           UNPIVOT_ADDRESS
                                                                                                               SPRADDR_NATN_CODE &
                                                                                                               STVNATN_NATION where
SEVIS_LOCAL_NATN_NAME                  SEVIS Local address nation name                  VARCHAR2          30   SPRADDR_ATYP_CODE = 'SL'           UNPIVOT_ADDRESS
                                                                                                                 SPRTELE_PHONE_AREA,
                                                                                                                 SPRTELE_PHONE_NUMBER,
                                                                                                                 SPRTELE_PHONE_EXT where
                                                                                                                 SPRTELE_STATUS_IND is null and
SEVIS_LOCAL_PHONE                      SEVIS Local address phone number                 VARCHAR2          14     SPRTELE_TELE_CODE='SL'           CONCAT_PHONE and UNPIVOT_PHONE
                                                                                                                 SPRADDR_STAT_CODE where
SEVIS_LOCAL_STAT_CODE                  SEVIS Local address state postal code            VARCHAR2           3     SPRADDR_ATYP_CODE = 'SL'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_STREET_LINE1 where
SEVIS_LOCAL_STREET1                    SEVIS Local address street line 1                VARCHAR2          30     SPRADDR_ATYP_CODE = 'SL'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_STREET_LINE2 where
SEVIS_LOCAL_STREET2                    SEVIS Local address street line 2                VARCHAR2          30     SPRADDR_ATYP_CODE = 'SL'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_STREET_LINE3 where
SEVIS_LOCAL_STREET3                    SEVIS Local address street line 3                VARCHAR2          30     SPRADDR_ATYP_CODE = 'SL'         UNPIVOT_ADDRESS
                                                                                                                 SPRADDR_ZIP where
SEVIS_LOCAL_ZIP                        SEVIS Local address zip code                     VARCHAR2          10     SPRADDR_ATYP_CODE = 'SL'         UNPIVOT_ADDRESS
                                                                                                                                                  CONTACT_ID expression
SK_DCONTACT_ID                         Surrogate key for DCONTACT                       VARCHAR2          20     SPRIDEN_PIDM                     (TO_CHAR(SPRIDEN_PIDM))
                                                                                                                 SPRADDR_STREET_LINE1 where
UMC                                    University Mailing Code                          VARCHAR2          30     SPRADDR_ATYP_CODE = 'MC'         UNPIVOT_ADDRESS
                                                                                                                 SPRTELE_PHONE_AREA,
                                                                                                                 SPRTELE_PHONE_NUMBER,
                                                                                                                 SPRTELE_PHONE_EXT where
                                                                                                                 SPRTELE_STATUS_IND is null and
UMC_PHONE                              Campus phone number                              VARCHAR2          14     SPRTELE_TELE_CODE='MC'           CONCAT_PHONE and UNPIVOT_PHONE
                                                                                                                 GOREMAL_EMAIL_ADDRESS where
WEB_HOME_PAGE                          Web Home Page address                            VARCHAR2          90     GOREMAL_EMAL_CODE='WEBH'         UNPIVOT_EMAIL




            3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                            Page 17 of 227                                                                 4/21/2012
                                                                  Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DCOURSE                           Course Dimension
                                                                                                         Data                                                                            For AAA
Data Name                         Data Description                                          Data Format Length Data Source                   Data Transformation                         Reports
BASIC_LEVEL_CODE                  Numeric group course level                                VARCHAR2      10   SSBSECT_CRSE_NUMB             BASIC_LEVEL function
                                                                                                               SSBSECT_CAMP_CODE,
                                                                                                               SSBSECT_INSM_CODE,
                                  Code which indicates whether or not the legislature funds                    SSRATTR_ATTR_CODE,            CRS_BUDGET_CODE function &
BUDGET_CODE                       a course section                                          VARCHAR2      1    SCBSUPP_OCCS_CODE             EXPR_BUDGET                                    x
                                                                                                               SSBSECT_CRSE_NUMB,
BUDGET_LEVEL                      Level grouping used by people doing budget analyses       VARCHAR2      30   SCBSUPP_OCCS_CODE             BUDGET_LEVEL function
                                                                                                               SSBSECT_CAMP_CODE,
                                                                                                               SSBSECT_INSM_CODE,
                                  Code which further breaks up course sections that are                        SSRATTR_ATTR_CODE,            CRS_BUDGET_CODE function &
BUDGET_TYPE                       funded by/reported to the Board of Regents                VARCHAR2      1    SCBSUPP_OCCS_CODE             EXPR_BUDGET                                    x
CENTER_CODE                       Extension center code which conducts a course             VARCHAR2      30   SSBSECT_CAMP_CODE
                                                                                                               SSBSECT_CAMP_CODE &
CENTER_NAME                       Extension center name which conducts a course             VARCHAR2      30   STVCAMP_DESC
                                                                                                               SCBCRSE_COLL_CODE or
COLLEGE_CODE                      College code through which a course is offered            VARCHAR2      2    SIRDPCL_COLL_CODE             COURSE_COLLEGE function                        x
                                                                                                               SCBCRSE_COLL_CODE or
                                                                                                               SIRDPCL_COLL_CODE &
COLLEGE_NAME                      College name through which a course is offered            VARCHAR2      30   STVCOLL_DESC                  COURSE_COLLEGE function
                                  Indicates if a course section is a concurrent enrollment
CONCURRENT_ENROL_IND              course section                                            VARCHAR2      1    SSRATTR_ATTR_CODE             CONCURRENT_ENROL_IND function                  x
CRN                               Course reference number                                   VARCHAR2      30   SSBSECT_CRN
                                  Indicates which course group a cross-listed course
CROSS_LISTED_CODE                 section is part of.                                       VARCHAR2      2    SSRXLST_XLST_GROUP                                                           x
CRS_NUM                           Course Number                                             VARCHAR2      5    SSBSECT_CRSE_NUMB                                                            x
DELIVERY_METHOD                   Course delivery method                                    VARCHAR2      1    SSBSECT_INSM_CODE             CRS_DLVRY_MTHD function                        x
                                                                                                               SCBCRSE_DEPT_CODE or
DEPARTMENT_CODE                   Department code through which a course is offered         VARCHAR2      4    SIRDPCL_DEPT_CODE             COURSE_DEPT function                           x
                                                                                                               SCBCRSE_DEPT_CODE or
                                                                                                               SIRDPCL_DEPT_CODE &
DEPARTMENT_NAME                   Department name through which a course is offered         VARCHAR2      30   STVDEPT_DESC
DESCRIPTION                       Long course description for a course section
END_DATE                          Course section end date                                   DATE               SSBSECT_PTRM_END_DATE                                                        x
FEE                               Fee charged for a course section
                                  Indicates if a course satisfies a general education
GENERAL_ED_IND                    requirement
GRADE_TYPE
HONORS                            Indicates if a course is an honors section

                                  Surrogate key for this table that is a system generated                         SSBSECT_TERM_CODE and      CRS_ID expression (SSBSECT_TERM_CODE
ID                                one up number                                             VARCHAR2       20     SSBSECT_CRN                || SSBSECT_CRN)
INSTRUCTION_METHOD                Course mode of instruction                                VARCHAR2       3      SSBSECT_SCHD_CODE          CRS_INSTR_MTHD function                        x
LINE_ITEM_CODE                    Funding line item code which owns a course                VARCHAR2       2      SSBSECT_CAMP_CODE          LINE_ITEM_CODE function                        x
LINE_ITEM_NAME                    Funding line item name which owns a course                VARCHAR2       30     SSBSECT_CAMP_CODE          LINE_ITEM_NAME function
MAX_ENROLLMENT                    Maximum enrollment capacity of a course section           NUMBER                SSBSECT_MAX_ENRL
                                                                                                                  SSBSECT_CREDIT_HRS or
                                                                                                                  SCBCRSE_CREDIT_HR_LOW or
                                  Maximum credits that may be earned by taking this                               SCBCRSE_CREDIT_HR_HIGH &
MAXIMUM_CREDITS                   course                                                    NUMBER                SCBCRSE_CREDIT_HR_IND      CREDIT_MAX function                            x
                                  Minimum credits that may be earned by taking this                               SSBSECT_CREDIT_HRS or
MINIMUM_CREDITS                   course                                                    NUMBER                SCBCRSE_CREDIT_HR_LOW      CREDIT_MIN function                            x

        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                 Page 18 of 227                                                              4/21/2012
                                                                   Banner Reporting Warehouse Documentation (Student)
Table Name                        Table Description
DCOURSE                           Course Dimension
                                                                                                             Data                                                                            For AAA
Data Name                         Data Description                                              Data Format Length Data Source                         Data Transformation                   Reports
NAME                              Subdepartment through which a course is offered               VARCHAR2      4    SSBSECT_SUBJ_CODE                                                             x
                                  Owner of the course (Main Campus or Continuing
OFFERING_UNIT                     Education)                                                    VARCHAR2       30     SSBSECT_CAMP_CODE                OFFERING_UNIT function                   x
OPEN_SEATS                        Available enrollment in a course section                      NUMBER                SSBSECT_SEATS_AVAIL
OVERALL_LEVEL                     Indicates the overall level of course (Undergrad/Grad)        VARCHAR2       14     SSBSECT_CRSE_NUMB                OVERALL_LEVEL function
PART_OF_TERM                      Part-of-Term that a course is offered                         VARCHAR2       30     SSBSECT_PTRM_CODE
PROGRAM                           Indicates if a course is vocational or academic               VARCHAR2       1      SCBSUPP_OCCS_CODE                COURSE_PROGRAM function                  x
REPEATABLE
SECTION                           Course section identifier                                     VARCHAR2        3     SSBSECT_CRSE_SEQ                                                          x

SERVICE_LEARNING                  Indicates if a course section is a service learning section
                                                                                                                      SSRMEET_BLDG_CODE where
SITE_CODE                         Site code where course section is taught                      VARCHAR2              calculated sequence number is 1   SITE_CODE expression                    x
                                                                                                                      SSRMEET_BLDG_CODE where
                                                                                                                      calculated sequence number is 1 &
SITE_NAME                         Site name where course section is taught                      VARCHAR2              STVBLDG_DESC                                                              x
                                                                                                                      SSRMEET_BLDG_CODE where
                                                                                                                      calculated sequence number is 1 &
SITE_TYPE                         Board of Regents defined site type                            VARCHAR2              Site Type Code from Excel Table   SITE_TYPE expression                    x
START_DATE                        Course section start date                                     DATE                  SSBSECT_PTRM_START_DATE                                                   x
TERM_CODE                         Term code during which a course is offered                    VARCHAR2        6     SSBSECT_TERM_CODE                                                         x
                                                                                                                      SSBSECT_TERM_CODE &
TERM_NAME                         Term name during which a course is offered                    VARCHAR2        6     STVTERM_DESC
                                                                                                                      SCBCRSE_CRSE_TITLE or
TITLE                             Course section short title                                    VARCHAR2        32    SSBSECT_TITLE                     EXPR_CRS_TITLE                          x
TITLE_LONG                        Long course title for a course section                        VARCHAR2       100    SCRSYLN_LONG_COURSE_TITLE




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                     Page 19 of 227                                                              4/21/2012
                                                                     Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DGENPERS                             General Person Dimension
                                                                                                           Data                                                                             For AAA
Data Name                            Data Description                                       Data Format   Length Data Source                              Data Transformation               Reports
BANNER_ID                            Banner Identification Number                           VARCHAR2        9    SPRIDEN_ID                                                                     x
BIRTHDATE                            Date of Birth                                          DATE                 SPBPERS_BIRTH_DATE                                                             x
CITIZENSHIP_CODE                     Citizenship status code                                VARCHAR2        3    SPBPERS_CITZ_CODE                                                              x

CITIZENSHIP_DESC                     Citizenship status description                         VARCHAR2        30      SPBPERS_CITZ_CODE & STVCITZ_DESC
                                     Indicates if person has requested that no
CONFIDENTIALITY                      information be released                                VARCHAR2         1      SPBPERS_CONFID_IND
DEAD_DATE                            Date that a person died                                DATE                    SPBPERS_DEAD_DATE
DECEASED_CODE                        Indicates if a person is dead                          VARCHAR2         1      SPBPERS_DEAD_IND
ETHNICITY_CODE                       Race/Ethnic status code                                VARCHAR2         2      SPBPERS_ETHN_CODE                                                          x
                                                                                                                    SPBPERS_ETHN_CODE &
ETHNICITY_NAME                       Race/Ethnic status description                         VARCHAR2        30      STVETHN_DESC
                                                                                                                    SPRIDEN_FIRST_NAME where
FIRST_NAME                           Legal first name                                       VARCHAR2        30      SPRIDEN_CHANGE_IND is null                                                 x
GENDER_CODE                          Gender                                                 VARCHAR2        1       SPBPERS_SEX                                                                x
HANDICAP_STATUS                                                                                                     sprmedi_medi_code???
                                                                                                                    SPRIDEN_LAST_NAME where
LAST_NAME                            Legal last name                                        VARCHAR2        60      SPRIDEN_CHANGE_IND is null                                                 x
                                     A legacy code that indicates if a student has a
LEGACY_CODE                          relative who previously attended USU                   VARCHAR2         3      SPBPERS_LGCY_CODE
                                     A legacy description of a student who has a relative                           SPBPERS_LGCY_CODE &
LEGACY_DESCRIPTION                   who previously attended USU                            VARCHAR2        30      STVLGCY_DESC
MARITAL_STATUS_CODE                  Marital status code of person                          VARCHAR2        1       SPBPERS_MRTL_CODE
                                                                                                                    SPBPERS_MRTL_CODE &
MARITAL_STATUS_NAME                  Marital status name of person                          VARCHAR2        30      STVMRTL_DESC
                                                                                                                    SPRIDEN_MI where
MIDDLE_NAME                          Legal middle name                                      VARCHAR2        30      SPRIDEN_CHANGE_IND is null                                                 x
NAME_SUFFIX                          Suffix for a student's legal name                      VARCHAR2        20      SPBPERS_NAME_SUFFIX                                                        x
                                     Country of person's citizenship, used for
NATION_CODE_LEGAL                    international students                                 VARCHAR2         5      GOBINTL_NATN_CODE_LEGAL
PIDM                                 Unique identification number in Banner                 NUMBER                  SPRIDEN_PIDM
                                                                                                                    SPRIDEN_FIRST_NAME where
                                                                                                                    SPRIDEN_CHANGE_IND=N and has latest
PREVIOUS_FIRST_NAME                  Previous legal first name of a person                  VARCHAR2        30      SPRIDEN_ACTIVITY_DATE                                                      x
                                                                                                                    SPRIDEN_LAST_NAME where
                                                                                                                    SPRIDEN_CHANGE_IND and has latest
PREVIOUS_LAST_NAME                   Previous legal last name of a person                   VARCHAR2        60      SPRIDEN_ACTIVITY_DATE                                                      x
                                                                                                                    SPRIDEN_MI where
                                                                                                                    SPRIDEN_CHANGE_IND and has latest
PREVIOUS_MIDDLE_NAME                 Previous legal middle name of a person                 VARCHAR2        30      SPRIDEN_ACTIVITY_DATE                                                      x
RELIGION_CODE                        Religious affiliation code                             VARCHAR2        3       SPBPERS_RELG_CODE
                                                                                                                    SPBPERS_RELG_CODE &
RELIGION_NAME                        Religious affiliation name                             VARCHAR2        30      STVRELG_DESC
SK_PERSON_ID                                                                                NUMBER                                                        PERS_ID Sequence
SSN                                  Social Security Number                                 VARCHAR2         9      SPBPERS_SSN                                                                x
VETC_FILE_NUMBER                     Veteran's file number                                  VARCHAR2         5      SPBPERS_VETC_FILE_NUMBER
VETERAN_STATUS                       Veteran status                                         VARCHAR2         5      SPBPERS_VERA_IND
                                     Indicates the VISA type for a foreign person at this                           GORVISA_VTYP_CODE where
VISA_TYPE_CODE                       university                                             VARCHAR2         2      GORVISA_ACTIVITY_DATE is max value




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                       Page 20 of 227                                                           4/21/2012
                                                                   Banner Reporting Warehouse Documentation (Student)
Table Name                            Table Description
DGENSTUD                              General Student Dimension
                                                                                                             Data                                                                                    For AAA
Data Name                             Data Description                                          Data Format Length Data Source                             Data Transformation                       Reports
                                                                                                                   SORTEST_TEST_SCORE where                UNPIVOT_TEST and ACT_COMPOSITE
ACT_COMPOSITE_MAX                     Maximum ACT Composite Score                               VARCHAR2      5    SORTEST_TESC_CODE = A05                 Aggregator                                   x
                                                                                                                   SORTEST_TEST_SCORE where                UNPIVOT_TEST and ACT_ENGLISH
ACT_ENGLISH_MAX                       Maximum ACT English Score                                 VARCHAR2      5    SORTEST_TESC_CODE = A01                 Aggregator                                   x
ACT_ESSAY_MAX                         Maximum ACT Essay Score                                   VARCHAR2      5
                                                                                                                   SORTEST_TEST_SCORE where
ACT_MATH_MAX                          Maximum ACT Math Score                                    VARCHAR2      5    SORTEST_TESC_CODE = A02                 UNPIVOT_TEST and ACT_MATH Aggregator         x
                                                                                                                   SORTEST_TEST_SCORE where                UNPIVOT_TEST and ACT_READING
ACT_READING_MAX                       Maximum ACT Reading Score                                 VARCHAR2      5    SORTEST_TESC_CODE = A03                 Aggregator
                                                                                                                   SORTEST_TEST_SCORE where                UNPIVOT_TEST and ACT_SCIENCE
ACT_SCIENCE_MAX                       Maximum ACT Science Score                                 VARCHAR2      5    SORTEST_TESC_CODE = A04                 Aggregator
                                                                                                                   SORTEST_TEST_SCORE where                UNPIVOT_TEST and ADMISSION_INDEX
ADMISSION_INDEX                       Student's admission score                                 VARCHAR2      5    SORTEST_TESC_CODE = AI                  Aggregator
                                      Total Advanced Placement Credits student has
AP_CREDITS                            transferred                                               NUMBER                                                                                                  x
CLEP_CREDITS                          Total CLEP credits student has transferred                NUMBER                                                                                                  x
                                      Identifies if a student is a member of a                                         Must be populated after Day 15 of
COHORT                                retention/graduation cohort                               VARCHAR2        30     semester                                                                         x
                                      Most recent GMAT Quantitative Score for a graduate                               SORTEST_TEST_SCORE where
GMAT_QUANT_SCORE                      student                                                   VARCHAR2         5     SORTEST_TESC_CODE = G02             UNPIVOT_GRAD_TEST
                                                                                                                       SORTEST_TEST_SCORE where
GMAT_TOTAL_SCORE                      Most recent GMAT Score for a graduate student             VARCHAR2         5     SORTEST_TESC_CODE = G03             UNPIVOT_GRAD_TEST
                                      Most recent GMAT Verbal Score for a graduate                                     SORTEST_TEST_SCORE where
GMAT_VERBAL_SCORE                     student                                                   VARCHAR2         5     SORTEST_TESC_CODE = G01             UNPIVOT_GRAD_TEST
                                      Most recent GRE Analytical Score for a graduate                                  SORTEST_TEST_SCORE where
GRE_ANALYTICAL_SCORE                  student                                                   VARCHAR2         5     SORTEST_TESC_CODE = GR03            UNPIVOT_GRAD_TEST
                                      Most recent GRE Quantitative Score for a graduate                                SORTEST_TEST_SCORE where
GRE_QUANT_SCORE                       student                                                   VARCHAR2         5     SORTEST_TESC_CODE = GR02            UNPIVOT_GRAD_TEST
                                                                                                                       SORTEST_TEST_SCORE where
GRE_VERBAL_SCORE                      Most recent GRE Verbal Score for a graduate student VARCHAR2               5     SORTEST_TESC_CODE = GR01            UNPIVOT_GRAD_TEST

HS_CLASS_RANK                         Rank of student in his/her high school graduating class   NUMBER                 SORHSCH_CLASS_RANK
                                      Number of people in a student's high school
HS_CLASS_SIZE                         graduating class                                          NUMBER                 SORHSCH_CLASS_SIZE
HS_CODE                               Last high school attended by a student                    VARCHAR2        6      SORHSCH_SBGI_CODE                                                                x
HS_GPA                                Student's high school GPA                                 VARCHAR2        24     SORHSCH_GPA
HS_GRADUATION_DATE                    Student's high school graduation date                     DATE                   SORHSCH_GRADUATION_DATE
                                                                                                                       SORHSCH_SBGI_CODE and
HS_NAME                               Name of student's high school                             VARCHAR2        30     STVSBGI_DESC_1
HS_NATN_CODE                          Nation code of student's high school                      VARCHAR2        5      SOBSGBI_NATN_CODE
HS_NATN_NAME                          Nation name of student's high school                      VARCHAR2        30
                                      High school graduation percentile (HS class rank/HS
HS_PERCENTILE                         Class size)                                               NUMBER                 SORHSCH_PERCENTILE
HS_STAT_CODE                          State code of student's high school                       VARCHAR2        3      SOBSGBI_STAT_CODE_1
HS_STAT_NAME                          State name of student's high school                       VARCHAR2        30
HS_TRANSCRIPT_DATE                    Date that the high school transcript was received         DATE                   SORHSCH_TRANS_RECV_DATE
                                      College code of student's program/major during first                             Must be populated after Day 15 of
INITIAL_COLL_CODE                     term at USU                                               VARCHAR2         2     semester                                                                         x
                                      College name of student's program/major during first                             Must be populated after Day 15 of
INITIAL_COLL_NAME                     term at USU                                               VARCHAR2        30     semester                                                                         x


         3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                     Page 21 of 227                                                                     4/21/2012
                                                                  Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DGENSTUD                             General Student Dimension
                                     Degree code of student's program during first term at                          Must be populated after Day 15 of
INITIAL_DEGREE_CODE                  USU                                                      VARCHAR2        5     semester                                                                      x
                                     Degree description of student's program during first                           Must be populated after Day 15 of
INITIAL_DEGREE_DESC                  term at USU                                              VARCHAR2       30     semester                                                                      x
                                     Department code of student's program/major during                              Must be populated after Day 15 of
INITIAL_DEPT_CODE                    first term at USU                                        VARCHAR2        4     semester                                                                      x
                                     Department name of student's program/major during                              Must be populated after Day 15 of
INITIAL_DEPT_NAME                    first term at USU                                        VARCHAR2       30     semester                                                                      x
                                                                                                                    Must be populated after Day 15 of
INITIAL_MAJOR_CIP                    CIP Code of student's major during first term at USU     VARCHAR2        6     semester                                                                      x
                                                                                                                    Must be populated after Day 15 of
INITIAL_MAJOR_CODE                   Student's major code during first term at USU            VARCHAR2        4     semester                                                                      x
                                                                                                                    Must be populated after Day 15 of
INITIAL_MAJOR_DESC                   Student's major description during first term at USU     VARCHAR2       30     semester                                                                      x
                                                                                                                    Must be populated after Day 15 of
INITIAL_PROGRAM_CODE                 Student's program code during first term at USU          VARCHAR2        4     semester                                                                      x
                                                                                                                    Must be populated after Day 15 of
INITIAL_PROGRAM_DESC                 Student's program description during first term at USU   VARCHAR2       30     semester                                                                      x
                                     Most recent Miller's Analogy Test Raw Score for a                              SORTEST_TEST_SCORE where
MILLER_RAW_SCORE                     graduate student                                         VARCHAR2        5     SORTEST_TESC_CODE = M01             UNPIVOT_GRAD_TEST
                                     Student's county code of origin (address at time of
ORIG_CNTY_CODE                       admittance)                                              VARCHAR2        5     SABSUPL_CNTY_CODE_ADMIT                                                       x
                                     Student's county name of origin (address at time of                            SABSUPL_CNTY_CODE_ADMIT and
ORIG_CNTY_NAME                       admittance)                                              VARCHAR2       30     STVCNTY_DESC
                                     Student's country code of origin (address at time of
ORIG_COUNTRY_CODE                    admittance)                                              VARCHAR2        5     SABSUPL_NATN_CODE_ADMIT                                                       x
                                     Student's country name of origin (address at time of                           SABSUPL_NATN_CODE_ADMIT and
ORIG_COUNTRY_NAME                    admittance)                                              VARCHAR2       30     STVNATN_NATION
                                     Student's state code of origin (address at time of
ORIG_STAT_CODE                       admittance)                                              VARCHAR2        3     SABSUPL_STAT_CODE_ADMIT                                                       x
                                     Student's state name of origin (address at time of                             SABSUPL_STAT_CODE_ADMIT and
ORIG_STAT_NAME                       admittance)                                              VARCHAR2       30     STVSTAT
PIDM                                 Unique identifier for a student                          NUMBER                SPRIDEN_PIDM
SAT_ESSAY_MAX                        Maximum SAT Essay Score                                  VARCHAR2        5
                                                                                                                    SORTEST_TEST_SCORE where
SAT_MATH_MAX                         Maximum SAT Math Score                                   NUMBER                SORTEST_TESC_CODE = S01             UNPIVOT_TEST and SAT_MATH Aggregator      x
                                                                                                                    SUM OF SAT_MATH AND
SAT_TOTAL_MAX                        Maximum SAT Total Score                                  NUMBER                SAT_VERBAL                                                                    x
                                                                                                                    SORTEST_TEST_SCORE where            UNPIVOT_TEST and SAT_VERBAL
SAT_VERBAL_MAX                       Maximum SAT Verbal Score                                 NUMBER                SORTEST_TESC_CODE = S02             Aggregator                                x
                                     Student's county of origin (address at time of                                 SABSUPL_CNTY_CODE_ADMIT,
                                     admittance) for reporting to the State Board of                                SABSUPL_STAT_CODE_ADMIT,
SBR_CNTY_CODE                        Regents                                                  VARCHAR2        5     SABSUPL_NATN_CODE_ADMIT             SBR_CNTY function                         x
                                                                                                                    SORTEST_TEST_SCORE where
TOEFL_MAX                            Maximum TOEFL Score                                      VARCHAR2        5     SORTEST_TESC_CODE = T02             UNPIVOT_GRAD_TEST
TRAN_BEGIN_DATE                      Most recent previous institution begin date              DATE                  SORDEGR_ATTEND_FROM
TRAN_DEGREE_CODE                     Most recent previous institution degree code earned      VARCHAR2        6     SORDEGR_DEGC_CODE
                                                                                                                    SORDEGR_DEGC_CODE and
TRAN_DEGREE_NAME                     Most recent previous institution degree name earned      VARCHAR2       30     STVDEGC_DESC
TRAN_END_DATE                        Most recent previous institution end date                DATE                  SORDEGR_ATTEND_TO
                                     Most recent previous institution grade point average
TRAN_GPA                             (GPA)                                                    NUMBER                SORDEGR_GPA_TRANSFERRED                                                       x


        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                   Page 22 of 227                                                                     4/21/2012
                                                                   Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DGENSTUD                             General Student Dimension

TRAN_HOURS                           Most recent previous institution transfer hours   NUMBER                SORDEGR_HOURS_TRANSFERRED               x
TRAN_INSTITUTION_CODE                Most recent previous institution code             VARCHAR2        6     SORPCOL_SBGI_CODE
                                                                                                             SORPCOL_SBGI_CODE and
TRAN_INSTITUTION_NAME                Most recent previous institution name             VARCHAR2       30     STVSBGI_DESC
TRAN_NATN_CODE                       Most recent previous institution nation code      VARCHAR2       5      SOBSGBI_NATN_CODE
TRAN_NATN_NAME                       Most recent previous institution nation name      VARCHAR2       30
TRAN_STAT_CODE                       Most recent previous institution state code       VARCHAR2       3      SOBSGBI_STAT_CODE
TRAN_STAT_NAME                       Most recent previous institution state name       VARCHAR2       30
TSWE_MAX                             Maximum TSWE Score                                VARCHAR2       5




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                            Page 23 of 227                               4/21/2012
                                                                 Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DGENSTUD                             General Student Dimension




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                      Page 24 of 227                  4/21/2012
                                                                        Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DINSTR                               Instructor Dimension

                                                                                                              Data                                                                   For AAA
Data Name                            Data Description                                         Data Format    Length Data Source           Data Transformation                        Reports

FIRST_NAME                           First name of a person who is teaching a course section VARCHAR2           30   SPRIDEN_FIRST_NAME                                                 x

LAST_NAME                            Last name of a person who is teaching a course section   VARCHAR2          60   SPRIDEN_FIRST_NAME                                                 x
                                     Middle name of a person who is teaching a course
MIDDLE_NAME                          section                                                  VARCHAR2          30   SPRIDEN_FIRST_NAME                                                 x
                                                                                                                     SIBINST_PIDM,        expression (SIRASGN_TERM_CODE ||
SK_TERM_INSTR_PIDM                   Surrogate key for the dimension                          VARCHAR2          20   SIRASGN_TERM_CODE    SIBINST_PIDM)
PIDM                                 Unique identifier of a person in Banner                  NUMBER                 SIBINST_PIDM
TERM_CODE                            Term for which data in the row applies                   VARCHAR2          6    SIRASGN_TERM_CODE




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                   Page 25 of 227                                                        4/21/2012
                                                        Banner Reporting Warehouse Documentation (Student)

                                                                                        Data                                                   For AAA
Data Name                            Data Description                   Data Format    Length Data Source    Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 26 of 227                                        4/21/2012
                                                        Banner Reporting Warehouse Documentation (Student)

                                                                                        Data                                                   For AAA
Data Name                            Data Description                   Data Format    Length Data Source    Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 27 of 227                                        4/21/2012
                                                        Banner Reporting Warehouse Documentation (Student)

                                                                                        Data                                                   For AAA
Data Name                            Data Description                   Data Format    Length Data Source    Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 28 of 227                                        4/21/2012
                                                        Banner Reporting Warehouse Documentation (Student)

                                                                                        Data                                                   For AAA
Data Name                            Data Description                   Data Format    Length Data Source    Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 29 of 227                                        4/21/2012
                                                        Banner Reporting Warehouse Documentation (Student)

                                                                                        Data                                                   For AAA
Data Name                            Data Description                   Data Format    Length Data Source    Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 30 of 227                                        4/21/2012
                                                                       Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DMEETING                             Meeting Dimension
                                                                                                      Data                                                                For AAA
Data Name                            Data Description                                 Data Format    Length   Data Source          Data Transformation                    Reports
BEGIN_TIME_1                         Start time of first course meeting               VARCHAR2         4      SSRMEET_BEGIN_TIME   UNPIVOT                                    x
BEGIN_TIME_2                         Start time of second course meeting              VARCHAR2         4      SSRMEET_BEGIN_TIME   UNPIVOT                                    x
BEGIN_TIME_3                         Start time of third course meeting               VARCHAR2         4      SSRMEET_BEGIN_TIME   UNPIVOT                                    x
BLDG_CODE_1                          Building/site of first course meeting            VARCHAR2         4      SSRMEET_BLDG_CODE    UNPIVOT                                    x
BLDG_CODE_2                          Building/site of second course meeting           VARCHAR2         4      SSRMEET_BLDG_CODE    UNPIVOT                                    x
BLDG_CODE_3                          Building/site of third course meeting            VARCHAR2         4      SSRMEET_BLDG_CODE    UNPIVOT                                    x
CRN                                  Course reference number                          VARCHAR2         5      SSBSECT_CRN
                                                                                                              SSRMEET_MON_DAY,
                                                                                                              SSRMEET_TUE_DAY,
                                                                                                              SSRMEET_WED_DAY,
                                                                                                              SSRMEET_THU_DAY,
                                                                                                              SSRMEET_FRI_DAY,
                                                                                                              SSRMEET_SAT_DAY,     CONCATENATION OF ALL DATA SOURCE
DAYS_1                               Days of first course meeting                     VARCHAR2           7    SSRMEET_SUN_DAY      FIELDS and UNPIVOT                        x
                                                                                                              SSRMEET_MON_DAY,
                                                                                                              SSRMEET_TUE_DAY,
                                                                                                              SSRMEET_WED_DAY,
                                                                                                              SSRMEET_THU_DAY,
                                                                                                              SSRMEET_FRI_DAY,
                                                                                                              SSRMEET_SAT_DAY,     CONCATENATION OF ALL DATA SOURCE
DAYS_2                               Days of second course meeting                    VARCHAR2           7    SSRMEET_SUN_DAY      FIELDS and UNPIVOT                        x
                                                                                                              SSRMEET_MON_DAY,
                                                                                                              SSRMEET_TUE_DAY,
                                                                                                              SSRMEET_WED_DAY,
                                                                                                              SSRMEET_THU_DAY,
                                                                                                              SSRMEET_FRI_DAY,
                                                                                                              SSRMEET_SAT_DAY,     CONCATENATION OF ALL DATA SOURCE
DAYS_3                               Days of third course meeting                     VARCHAR2           7    SSRMEET_SUN_DAY      FIELDS and UNPIVOT                        x
END_TIME_1                           End time of first course meeting                 VARCHAR2           4    SSRMEET_END_TIME     UNPIVOT                                   x
END_TIME_2                           End time of second course meeting                VARCHAR2           4    SSRMEET_END_TIME     UNPIVOT                                   x
END_TIME_3                           End time of third course meeting                 VARCHAR2           4    SSRMEET_END_TIME     UNPIVOT                                   x
ROOM_CODE_1                          Room of first course meeting                     VARCHAR2           4    SSRMEET_ROOM_CODE    UNPIVOT                                   x
ROOM_CODE_2                          Room of second course meeting                    VARCHAR2           4    SSRMEET_ROOM_CODE    UNPIVOT                                   x
ROOM_CODE_3                          Room of third course meeting                     VARCHAR2           4    SSRMEET_ROOM_CODE    UNPIVOT                                   x
                                                                                                              SSBSECT_TERM_CODE,   EXPRESSION (SSBSECT_TERM_CODE ||
SK_MEET_ID                           Surrogate key of the meeting dimension           VARCHAR2          30    SSBSECT_CRN          SSBSECT_CRN)
TERM_CODE                            Term during which a course is offered            VARCHAR2           6    SSBSECT_TERM_CODE




         3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                           Page 31 of 227                                                    4/21/2012
                                                        Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DMEETING                            Meeting Dimension
                                                                                       Data                                                    For AAA
Data Name                           Data Description                   Data Format    Length Data Source     Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 32 of 227                                        4/21/2012
                                                        Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DMEETING                            Meeting Dimension
                                                                                       Data                                                    For AAA
Data Name                           Data Description                   Data Format    Length Data Source     Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 33 of 227                                        4/21/2012
                                                        Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DMEETING                            Meeting Dimension
                                                                                       Data                                                    For AAA
Data Name                           Data Description                   Data Format    Length Data Source     Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 34 of 227                                        4/21/2012
                                                        Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DMEETING                            Meeting Dimension
                                                                                       Data                                                    For AAA
Data Name                           Data Description                   Data Format    Length Data Source     Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 35 of 227                                        4/21/2012
                                                        Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DMEETING                            Meeting Dimension
                                                                                       Data                                                    For AAA
Data Name                           Data Description                   Data Format    Length Data Source     Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 36 of 227                                        4/21/2012
                                                                  Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DSTDTERM                            Student Term Dimension
                                                                                                             Data                                                                         For AAA
Data Name                           Data Description                                            Data Format Length Data Source                    Data Transformation                     Reports
                                    Indicates the academic standing of a student during a
ACADEMIC_STANDING                   term                                                        VARCHAR2
ACTIVITY_STATUS                                                                                 VARCHAR2
ADMIT_CODE                          University admissions type                                  VARCHAR2         2   SGBSTDN_ADMT_CODE
                                                                                                                     SGBSTDN_ADMT_CODE and
ADMIT_DESC                          University admissions type                                  VARCHAR2        30   STVADMT_DESC
ADMIT_TERM_CODE                     Term for which admissions type applies                      VARCHAR2         6   SGBSTDN_TERM_CODE_ADMIT
                                    Indicates if a student is receiving athletic aid for
ATHLETE_AID_IND                     participating in a NCAA sport                               VARCHAR2         1   SGRSPRT_ATHL_AID_IND         ATHLETE_IND function                       x
                                    Indicates that a student is participating in at least one
ATHLETE_IND                         NCAA sport during a term                                    VARCHAR2         1   SGRSPRT_ACTC_CODE            ATHLETE_IND function                       x
                                                                                                                     SGBSTDN_LEVL_CODE, sum of
                                                                                                                     SFRSTCR_CREDIT_HR per PIDM
CALC_TIME_STAT_CODE                 Indicates if a student is full- or part-time during the term. VARCHAR2       1   & TERM                       CALC_TIME_STATUS function                  x
                                    Indicates if a student is registered in any continuing
CE_STD_IND                          education courses during a term                               VARCHAR2       1

CENTER_CODE                         Indicates the home center code of the student for a term    VARCHAR2         1   SGBSTDN_CAMP_CODE
                                    Indicates the home center description of the student for                         SGBSTDN_CAMP_CODE and
CENTER_DESC                         a term                                                      VARCHAR2        30   STVCAMP_DESC
                                    The CIP Code of the primary major of the primary                                 SGBSTDN_MAJR_CODE_1 and
CIP1                                program                                                     VARCHAR2         6   STVMAJR_CIPC_CODE                                                       x
                                    The CIP Code of the primary major of the secondary                               SGBSTDN_MAJR_CODE_2 and
CIP2                                program                                                     VARCHAR2         6   STVMAJR_CIPC_CODE                                                       x
                                                                                                                     SGBSTDN_LEVL_CODE,
                                                                                                                     SGBSTDN_STYP_CODE,
                                                                                                                     SGBSTDN_ADMT_CODE,
                                    Indicates the actual level code of a student during a                            STVDEGC_DLEV_CODE,
CLASS_LEVEL_CODE                    term                                                        VARCHAR2         2   SHRLGPA_HOURS_EARNED         CLASS_LEVEL function                       x
                                                                                                                     SGBSTDN_LEVL_CODE,
                                                                                                                     SGBSTDN_STYP_CODE,
                                                                                                                     SGBSTDN_ADMT_CODE,
                                    Indicates the actual level description of a student during                       STVDEGC_DLEV_CODE,
CLASS_LEVEL_DESC                    a term                                                     VARCHAR2         30   SHRLGPA_HOURS_EARNED         CLASS_LEVEL function
COLLEGE_CODE1                       College code of the primary program, primary major         VARCHAR2          2   SGBSTDN_COLL_CODE_1                                                     x
                                                                                                                     SGBSTDN_COLL_CODE_2
COLLEGE_CODE2                       College code of the secondary program, primary major        VARCHAR2         2
                                                                                                                     SGBSTDN_COLL_CODE_1 and
COLLEGE_NAME1                       College name of the primary program, primary major          VARCHAR2        30   STVCOLL_DESC
                                                                                                                     SGBSTDN_COLL_CODE_2 and
COLLEGE_NAME2                       College name of the secondary program, primary major        VARCHAR2        30   STVCOLL_DESC
                                    First concentration code of the primary major of the
                                                                                                                     SGBSTDN_MAJR_CODE_CONC_1
CONCENTRATION_CODE1                 primary program                                             VARCHAR2         4
                                    Second concentration code of the primary major of the                            SGBSTDN_MAJR_CODE_CONC_1
CONCENTRATION_CODE2                 primary program                                             VARCHAR2         4   _2
                                    Third concentration code of the primary major of the                             SGBSTDN_MAJR_CODE_CONC_1
CONCENTRATION_CODE3                 primary program                                             VARCHAR2         4   _3
                                    First concentration code of the primary major of the
                                                                                                                     SGBSTDN_MAJR_CODE_CONC_2
CONCENTRATION_CODE4                 secondary program                                           VARCHAR2         4


        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                    Page 37 of 227                                                            4/21/2012
                                                                  Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DSTDTERM                            Student Term Dimension
                                                                                                                Data                                                                        For AAA
Data Name                           Data Description                                               Data Format Length Data Source              Data Transformation                          Reports
                                    Second concentration code of the primary major of the                             SGBSTDN_MAJR_CODE_CONC_2
CONCENTRATION_CODE5                 secondary program                                              VARCHAR2       4   _2
                                    Third concentration code of the primary major of the                              SGBSTDN_MAJR_CODE_CONC_2
CONCENTRATION_CODE6                 secondary program                                              VARCHAR2       4   _3
                                    First concentration description of the primary major of                           SGBSTDN_MAJR_CODE_CONC_1
CONCENTRATION_DESC1                 the primary program                                            VARCHAR2      30   and STVMAJR_DESC
                                    Second concentration description of the primary major                             SGBSTDN_MAJR_CODE_CONC_1
CONCENTRATION_DESC2                 of the primary program                                         VARCHAR2      30   _2 and STVMAJR_DESC
                                    Third concentration description of the primary major of                           SGBSTDN_MAJR_CODE_CONC_1
CONCENTRATION_DESC3                 the primary program                                            VARCHAR2      30   _3 and STVMAJR_DESC
                                    First concentration description of the primary major of                           SGBSTDN_MAJR_CODE_CONC_2
CONCENTRATION_DESC4                 the secondary program                                          VARCHAR2      30   and STVMAJR_DESC
                                    Second concentration description of the primary major                             SGBSTDN_MAJR_CODE_CONC_2
CONCENTRATION_DESC5                 of the secondary program                                       VARCHAR2      30   _2 and STVMAJR_DESC
                                    Third concentration description of the primary major of                           SGBSTDN_MAJR_CODE_CONC_2
CONCENTRATION_DESC6                 the secondary program                                          VARCHAR2      30   _3 and STVMAJR_DESC
                                    Indicates if a student makes the Dean's List during a
DEANS_LIST                          term                                                           VARCHAR2
DEGREE_CODE1                        Degree code associated with the primary program                VARCHAR2         4   SGBSTDN_DEGC_CODE_1                                                    x
DEGREE_CODE2                        Degree code associated with the secondary program              VARCHAR2         4   SGBSTDN_DEGC_CODE_2
                                                                                                                        SGBSTDN_DEGC_CODE_1 and
DEGREE_DESC1                        Degree description associated with the primary program VARCHAR2                30   STVDEGC_DESC
                                    Degree description associated with the secondary                                    SGBSTDN_DEGC_CODE_2 and
DEGREE_DESC2                        program                                                VARCHAR2                30   STVDEGC_DESC
                                                                                                                        STVDEGC_DLEV_CODE,
                                    Indicates if a student is trying to obtain a degree while at                        SGBSTDN_DEGC_CODE,
DEGREE_INTENT_CODE                  USU and what level that degree is                              VARCHAR2         1   SGBSTDN_MAJR_CODE_1          DEGREE_INTENT function                    x
                                    Department code associated with the primary major of
DEPT_CODE1                          the primary program                                            VARCHAR2         4   SGBSTDN_DEPT_CODE                                                      x
                                    Department code associated with the primary major of
DEPT_CODE2                          the secondary program                                          VARCHAR2         4   SGBSTDN_DEPT_CODE_2
                                    Department name associated with the primary major of                                SGBSTDN_DEPT_CODE and
DEPT_NAME1                          the primary program                                            VARCHAR2        30   STVDEPT_DESC
                                    Department name associated with the primary major of                                SGBSTDN_DEPT_CODE_2 and
DEPT_NAME2                          the secondary program                                          VARCHAR2        30   STVDEPT_DESC
                                                                                                                        SGBSTDN_RESD_CODE and
DETAIL_RESID_CODE                   Detailed residency of a student for tuition purposes           VARCHAR2         5   SGRSATT_ATTS_CODE            DETAIL_RESID function                     x
                                                                                                                        SGBSTDN_RESD_CODE and
DETAIL_RESID_DESC                   Detailed residency of a student for tuition purposes           VARCHAR2        30   SGRSATT_ATTS_CODE            DETAIL_RESID function

                                    Indicates if a student is registered in both main campus
DUP_STD_IND                         and continuing education courses during a term           VARCHAR2               1
                                                                                                                        SGBSTDN_LEVL_CODE,
                                    Code which indicates the entry type of a student during                             SGBSTDN_STYP_CODE,
ENTRY_ACTION_CODE                   a term                                                         VARCHAR2             SGBSTDN_ADMT_CODE            ENTRY_ACTION function                     x
                                                                                                                        SGBSTDN_LEVL_CODE,
                                                                                                                        SGBSTDN_STYP_CODE,
ENTRY_ACTION_DESC                   The entry type description of a student during a term          VARCHAR2             SGBSTDN_ADMT_CODE            ENTRY_ACTION function                     x
                                    Indicates that a student is receiving athletic aid for                              SGRSPRT_ATHL_AID_IND where
FOOTBALL_AID_IND                    playing Football during a term                                 VARCHAR2         1   SGRSPRT_ACTC_CODE='FB'       FILTER_ATHLETES & UNPIVOT_ATHLETES

        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                       Page 38 of 227                                                           4/21/2012
                                                                  Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DSTDTERM                            Student Term Dimension
                                                                                                                Data                                                                        For AAA
Data Name                           Data Description                                               Data Format Length Data Source                    Data Transformation                    Reports
                                    Indicates the student eligibility code for Football during a                      SGRSPRT_ELIG_CODE where
FOOTBALL_ELIG_CODE                  term                                                           VARCHAR2      2    SGRSPRT_ACTC_CODE='FB'         FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Football during
FOOTBALL_IND                        a term                                                         VARCHAR2         8   SGRSPRT_ACTC_CODE = 'FB'     FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the type of leave of absence that a student is
LEAVE_OF_ABSENCE                    on.                                                            VARCHAR2
                                    Indicates the home line item code of the student for a
LINE_ITEM_CODE                      term                                                           VARCHAR2         1   SGBSTDN_CAMP_CODE            STUDENT_LINE function
                                    Indicates the home line item description of the student
                                                                                                                        SGBSTDN_CAMP_CODE
LINE_ITEM_DESC                      for a term                                                     VARCHAR2        30                                STUDENT_LINE function
                                    Indicates if a student is registered in main campus
MAIN_STD_IND                        courses during a term                                          VARCHAR2         1
MAJOR_CODE1                         The primary major code of the primary program                  VARCHAR2         4   SGBSTDN_MAJR_CODE_1
MAJOR_CODE2                         The primary major code of the secondary program                VARCHAR2         4   SGBSTDN_MAJR_CODE_2
                                                                                                                        SGBSTDN_MAJR_CODE_1 and
MAJOR_NAME1                         The primary major name of the primary program                  VARCHAR2        30   STVMAJR_DESC
                                                                                                                        SGBSTDN_MAJR_CODE_2 and
MAJOR_NAME2                         The primary major name of the secondary program                VARCHAR2        30   STVMAJR_DESC
                                    Indicates that a student is receiving athletic aid for                              SGRSPRT_ATHL_AID_IND where
MBASKETBALL_AID_IND                 playing Men's Basketball during a term                         VARCHAR2         1   SGRSPRT_ACTC_CODE='MBB'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Men's Basketball                         SGRSPRT_ELIG_CODE where
MBASKETBALL_ELIG_CODE               during a term                                                  VARCHAR2         2   SGRSPRT_ACTC_CODE='MBB'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Men's
MBASKETBALL_IND                     Basketball during a term                                       VARCHAR2         8   SGRSPRT_ACTC_CODE = 'MBB'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is receiving athletic aid for                              SGRSPRT_ATHL_AID_IND where
MGOLF_AID_IND                       playing Men's Golf during a term                               VARCHAR2         1   SGRSPRT_ACTC_CODE='MGO'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Men's Golf                               SGRSPRT_ELIG_CODE where
MGOLF_ELIG_CODE                     during a term                                                  VARCHAR2         2   SGRSPRT_ACTC_CODE='MGO'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Men's Golf
MGOLF_IND                           during a term                                                  VARCHAR2         8   SGRSPRT_ACTC_CODE = 'MGO' FILTER_ATHLETES & UNPIVOT_ATHLETES
MINOR_CODE1                         The primary minor code of the primary program                  VARCHAR2         4   SGBSTDN_MAJR_CODE_MINR_1
                                                                                                                        SGBSTDN_MAJR_CODE_MINR_1_
MINOR_CODE2                         The secondary minor code of the primary program                VARCHAR2         4   2
MINOR_CODE3                         The primary minor code of the secondary program                VARCHAR2         4   SGBSTDN_MAJR_CODE_MINR_2
                                                                                                                        SGBSTDN_MAJR_CODE_MINR_2_
MINOR_CODE4                         The secondary minor code of the secondary program              VARCHAR2         4   2
                                                                                                                        SGBSTDN_MAJR_CODE_MINR_1
MINOR_DESC1                         The primary minor description of the primary program           VARCHAR2        30   and STVMAJR_CIPC_CODE
                                                                                                                        SGBSTDN_MAJR_CODE_MINR_1_
MINOR_DESC2                         The secondary description minor of the primary program VARCHAR2                30   2 and STVMAJR_CIPC_CODE
                                                                                                                        SGBSTDN_MAJR_CODE_MINR_2
MINOR_DESC3                         The primary minor description of the secondary program         VARCHAR2        30   and STVMAJR_CIPC_CODE
                                    The secondary minor description of the secondary                                    SGBSTDN_MAJR_CODE_MINR_2_
MINOR_DESC4                         program                                                        VARCHAR2        30   2 and STVMAJR_CIPC_CODE
                                    Indicates that a student is receiving athletic aid for                              SGRSPRT_ATHL_AID_IND where
MTENNIS_AID_IND                     playing Men's Tennis during a term                             VARCHAR2         1   SGRSPRT_ACTC_CODE='MTN'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Men's Tennis                             SGRSPRT_ELIG_CODE where
MTENNIS_ELIG_CODE                   during a term                                                  VARCHAR2         2   SGRSPRT_ACTC_CODE='MTN'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Men's Tennis
MTENNIS_IND                         during a term                                                  VARCHAR2         8   SGRSPRT_ACTC_CODE = 'MTN'    FILTER_ATHLETES & UNPIVOT_ATHLETES

        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                       Page 39 of 227                                                           4/21/2012
                                                                  Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DSTDTERM                            Student Term Dimension
                                                                                                               Data                                                                               For AAA
Data Name                           Data Description                                              Data Format Length Data Source                    Data Transformation                           Reports
                                    Indicates that a student is receiving athletic aid for                           SGRSPRT_ATHL_AID_IND where
MTRACK_AID_IND                      playing Men's Track during a term                             VARCHAR2      1    SGRSPRT_ACTC_CODE='MTK'        FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Men's Track                           SGRSPRT_ELIG_CODE where
MTRACK_ELIG_CODE                    during a term                                                 VARCHAR2      2    SGRSPRT_ACTC_CODE='MTK'        FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Men's Track
MTRACK_IND                          during a term                                                 VARCHAR2         8   SGRSPRT_ACTC_CODE = 'MTK'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is receiving athletic aid for                             SGRSPRT_ATHL_AID_IND where
MXCNTRY_AID_IND                     playing Men's Cross Country during a term                     VARCHAR2         1   SGRSPRT_ACTC_CODE='MXC'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Men's Cross                             SGRSPRT_ELIG_CODE where
MXCNTRY_ELIG_CODE                   Country during a term                                         VARCHAR2         2   SGRSPRT_ACTC_CODE='MXC'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Men's Cross
MXCNTRY_IND                         Country during a term                                         VARCHAR2         8   SGRSPRT_ACTC_CODE = 'MXC'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                                                                                                                                    HB75_Waiver function (For
                                    The percentage of the tuition differential waiver offered
                                                                                                                                                    RPRATRM_FUND_CODE in
                                    to the student as stated in 2003 House Bill 75 which
                                                                                                                                                    ("SUS075","SUW075","SGH755") and
                                    enables the different insitutions to offer a waiver for all
                                                                                                                                                    RPRATRM_TERM_CODE = Current Term, if
                                    or some of the differential amount between the non-
                                                                                                                                                    RPRATRM_PAID_AMT=1500 then
                                    resident tuition and resident tuition for those non-
                                                                                                                       RPRATRM_FUND_CODE,           field="050"; if RPRATRM_PAID_AMT=3000
                                    resident students who live near the Utah borders in an
                                                                                                                       RPRATRM_TERM_CODE,           then field="100"; if RPRATRM_PAID_AMT
                                    effort to attract those students to their schools
NONRES_TUITION_WAIV                                                                               VARCHAR2         3   RPRATRM_PAID_AMT             not null then field="ERR"; else field=NULL)      x
OVERALL_LEVEL                       Career level for the student                                  VARCHAR2        14   SGBSTDN_LEVL_CODE
OVERALL_RESID_CODE                  Residency code of a student for tuition purposes              VARCHAR2         5   SGBSTDN_RESD_CODE                                                             x
                                                                                                                       SGBSTDN_RESD_CODE and
OVERALL_RESID_DESC                  Residency description of a student for tuition purposes       VARCHAR2        30   STVRESD_DESC
                                    Indicates if the student belongs to Main Campus or
OWNER                               Continuing Education                                          VARCHAR2         4   SGBSGDN_CAMP_CODE            STUDENT_OWNER function                           x
PIDM                                Unique identifier of a person in Banner                       NUMBER               SGBSTDN_PIDM
PROGRAM_CODE1                       Primary program code                                          VARCHAR2             SGBSTDN_PROGRAM_1
PROGRAM_CODE2                       Secondary program code                                        VARCHAR2             SGBSTDN_PROGRAM_2
                                                                                                                       SGBSTDN_PROGRAM_1 and
PROGRAM_DESC1                       Primary program description                                   VARCHAR2        30   SMRPRLE_PROGRAM_DESC
                                                                                                                       SGBSTDN_PROGRAM_2 and
PROGRAM_DESC2                       Secondary program description                                 VARCHAR2        30   SMRPRLE_PROGRAM_DESC
                                                                                                                                                    STDTERM_ID expression
                                                                                                                       SFBETRM_TERM_CODE and        (SFBETRM_TERM_CODE ||
SK_STD_TRM_ID                       Surrogate key for the student term dimension                  VARCHAR2        30   SGBSTDN_PIDM                 SGBSTDN_PIDM)
STUDENT_TYPE_CODE                   Student term enrollment/entry type code                       VARCHAR2         1   SGBSTDN_STYP_CODE
                                                                                                                       SGBSTDN_STYP_CODE and
STUDENT_TYPE_DESC                   Student term enrollment/entry type description             VARCHAR2           30   STVSTYP_DESC
TERM_CODE                           Term code for which data in the row applies                VARCHAR2            6   SFBETRM_TERM_CODE                                                             x
                                    Indicates if a student is time status during a semester as
TIME_STATUS                         calculated by the Banner System                            VARCHAR2            2   SFBETRM_TMST_CODE
                                                                                                                       SFRSTCR_TERM_CODE,
                                                                                                                       SFRSTCR_PIDM,
                                    Total credits that a student is attempting during a                                SFRSTCR_RSTS_CODE,
TOTAL_CREDITS                       semester                                                      NUMBER               SFRSTCR_CREDIT_HR            TOTAL_CREDITS function                           x
TUITION_RATE_CODE                   Indicates the tuition rate population of the student          VARCHAR2         5   SGBSTDN_RATE_CODE
                                    Indicates that a student is receiving athletic aid for                             SGRSPRT_ATHL_AID_IND where
WBASKETBALL_AID_IND                 playing Women's Basketball during a term                      VARCHAR2         1   SGRSPRT_ACTC_CODE='WBB'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Women's                                 SGRSPRT_ELIG_CODE where
WBASKETBALL_ELIG_CODE               Basketball during a term                                      VARCHAR2         2   SGRSPRT_ACTC_CODE='WBB'      FILTER_ATHLETES & UNPIVOT_ATHLETES
        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                      Page 40 of 227                                                                  4/21/2012
                                                                Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DSTDTERM                            Student Term Dimension
                                                                                                             Data                                                                        For AAA
Data Name                           Data Description                                            Data Format Length Data Source                    Data Transformation                    Reports
                                    Indicates that a student is participating in Women's
WBASKETBALL_IND                     Basketball during a term                                    VARCHAR2         8   SGRSPRT_ACTC_CODE = 'WBB'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is receiving athletic aid for                           SGRSPRT_ATHL_AID_IND where
WGYMNAST_AID_IND                    playing Women's Gymnastics during a term                    VARCHAR2         1   SGRSPRT_ACTC_CODE='GYM'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Women's                               SGRSPRT_ELIG_CODE where
WGYMNAST_ELIG_CODE                  Gymnastics during a term                                    VARCHAR2         2   SGRSPRT_ACTC_CODE='GYM'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Women's
WGYMNAST_IND                        Gymnastics during a term                                    VARCHAR2         8   SGRSPRT_ACTC_CODE = 'GYM'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is receiving athletic aid for                           SGRSPRT_ATHL_AID_IND where
WSOCCER_AID_IND                     playing Women's Soccer during a term                        VARCHAR2         1   SGRSPRT_ACTC_CODE='WSC'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Women's                               SGRSPRT_ELIG_CODE where
WSOCCER_ELIG_CODE                   Soccer during a term                                        VARCHAR2         2   SGRSPRT_ACTC_CODE='WSC'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Women's
WSOCCER_IND                         Soccer during a term                                        VARCHAR2         8   SGRSPRT_ACTC_CODE = 'WSC'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is receiving athletic aid for                           SGRSPRT_ATHL_AID_IND where
WSOFTBALL_AID_IND                   playing Women's Softball during a term                      VARCHAR2         1   SGRSPRT_ACTC_CODE='WSB'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Women's                               SGRSPRT_ELIG_CODE where
WSOFTBALL_ELIG_CODE                 Softball during a term                                      VARCHAR2         2   SGRSPRT_ACTC_CODE='WSB'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Women's
WSOFTBALL_IND                       Softball during a term                                      VARCHAR2         8   SGRSPRT_ACTC_CODE = 'WSB'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is receiving athletic aid for                           SGRSPRT_ATHL_AID_IND where
WTENNIS_AID_IND                     playing Women's Tennis during a term                        VARCHAR2         1   SGRSPRT_ACTC_CODE='WTN'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Women's Tennis                        SGRSPRT_ELIG_CODE where
WTENNIS_ELIG_CODE                   during a term                                               VARCHAR2         2   SGRSPRT_ACTC_CODE='WTN'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Women's
WTENNIS_IND                         Tennis during a term                                        VARCHAR2         8   SGRSPRT_ACTC_CODE = 'WTN'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is receiving athletic aid for                           SGRSPRT_ATHL_AID_IND where
WTRACK_AID_IND                      playing Women's Track during a term                         VARCHAR2         1   SGRSPRT_ACTC_CODE='WTK'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Women's Track                         SGRSPRT_ELIG_CODE where
WTRACK_ELIG_CODE                    during a term                                               VARCHAR2         2   SGRSPRT_ACTC_CODE='WTK'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Women's
WTRACK_IND                          Track during a term                                         VARCHAR2         8   SGRSPRT_ACTC_CODE = 'WTK'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is receiving athletic aid for                           SGRSPRT_ATHL_AID_IND where
WVOLLEYBALL_AID_IND                 playing Women's Volleyball during a term                    VARCHAR2         1   SGRSPRT_ACTC_CODE='WVB'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Women's                               SGRSPRT_ELIG_CODE where
WVOLLEYBALL_ELIG_CODE               Volleyball during a term                                    VARCHAR2         2   SGRSPRT_ACTC_CODE='WVB'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Women's
WVOLLEYBALL_IND                     Volleyball during a term                                    VARCHAR2         8   SGRSPRT_ACTC_CODE = 'WVB'    FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is receiving athletic aid for                           SGRSPRT_ATHL_AID_IND where
WXCNTRY_AID_IND                     playing Women's Cross Country during a term                 VARCHAR2         1   SGRSPRT_ACTC_CODE='WXC'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates the student eligibility code for Women's Cross                         SGRSPRT_ELIG_CODE where
WXCNTRY_ELIG_CODE                   Country during a term                                       VARCHAR2         2   SGRSPRT_ACTC_CODE='WXC'      FILTER_ATHLETES & UNPIVOT_ATHLETES
                                    Indicates that a student is participating in Women's
WXCNTRY_IND                         Cross Country during a term                                 VARCHAR2         8   SGRSPRT_ACTC_CODE = 'WXC'    FILTER_ATHLETES & UNPIVOT_ATHLETES




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                    Page 41 of 227                                                           4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DSTDTERM                            Student Term Dimension
                                                                                           Data                                                     For AAA
Data Name                           Data Description                          Data Format Length Data Source      Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 42 of 227                                        4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DSTDTERM                            Student Term Dimension
                                                                                           Data                                                     For AAA
Data Name                           Data Description                          Data Format Length Data Source      Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 43 of 227                                        4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
Table Name                          Table Description
DSTDTERM                            Student Term Dimension
                                                                                           Data                                                     For AAA
Data Name                           Data Description                          Data Format Length Data Source      Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 44 of 227                                        4/21/2012
                                                                 Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DTSCPTSUM                            Student Transcript Summary Dimension
                                                                                                            Data                                                                 For AAA
Data Name                            Data Description                                          Data Format Length Data Source                  Data Transformation               Reports
                                                                                                                  SHRLGPA_GPA where
                                                                                                                  SHRLGPA_GPA_TYPE_IND='O' &
GR_OVER_GPA                          Overall cumulative graduate level GPA for the student     NUMBER       23,9 SHRL_GPA_LEVL_CODE = 'GR'     Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_GPA_HOURS where
                                     Overall cumulative hours used for graduate GPA                               SHRLGPA_GPA_TYPE_IND='O' &
GR_OVER_GPA_HRS                      calculation                                               NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_QUALITY_POINTS
                                     Overall cumulative graduate points obtained by                               where
                                     multiplying the grade value by the credit hours for the                      SHRLGPA_GPA_TYPE_IND='O' &
GR_OVER_GPA_POINTS                   student                                                   NUMBER       17,6 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_ATTEMPTED
                                                                                                                  where
                                     Overall cumulative graduate hours attempted for the                          SHRLGPA_GPA_TYPE_IND='O' &
GR_OVER_HRS_ATTE                     student                                                   NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                     Overall cumulative graduate hours earned for the                             SHRLGPA_GPA_TYPE_IND='O' &
GR_OVER_HRS_EARNED                   student                                                   NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                     Overall cumulative graduate hours passed for the                             SHRLGPA_GPA_TYPE_IND='O' &
GR_OVER_HRS_PASSED                   student                                                   NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_GPA where
                                                                                                                  SHRLGPA_GPA_TYPE_IND='T' &
GR_TRAN_GPA                          Transfer cumulative graduate GPA for the student          NUMBER       23,9 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_GPA_HOURS where
                                     Transfer cumulative graduate hours used for GPA                              SHRLGPA_GPA_TYPE_IND='T' &
GR_TRAN_GPA_HRS                      calculation                                               NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_QUALITY_POINTS
                                     Transfer cumulative graduate points obtained by                              where
                                     multiplying the grade value by the credit hours for the                      SHRLGPA_GPA_TYPE_IND='T' &
GR_TRAN_GPA_POINTS                   student                                                   NUMBER       17,6 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_ATTEMPTED
                                                                                                                  where
                                     Transfer cumulative graduate hours attempted for the                         SHRLGPA_GPA_TYPE_IND='T' &
GR_TRAN_HRS_ATTE                     student                                                   NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                     Transfer cumulative graduate hours earned for the                            SHRLGPA_GPA_TYPE_IND='T' &
GR_TRAN_HRS_EARNED                   student                                                   NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1                  x
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                     Transfer cumulative graduate hours passed for the                            SHRLGPA_GPA_TYPE_IND='T' &
GR_TRAN_HRS_PASSED                   student                                                   NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_GPA where
                                                                                                                  SHRLGPA_GPA_TYPE_IND='I' &
GR_USU_GPA                           USU cumulative graduate GPA for the student               NUMBER       23,9 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1                  x
                                                                                                                  SHRLGPA_GPA_HOURS where
                                     USU cumulative graduate hours used for GPA                                   SHRLGPA_GPA_TYPE_IND='I' &
GR_USU_GPA_HRS                       calculation                                               NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1

        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                    Page 45 of 227                                                   4/21/2012
                                                                 Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DTSCPTSUM                            Student Transcript Summary Dimension
                                                                                                            Data                                                                 For AAA
Data Name                            Data Description                                          Data Format Length Data Source                  Data Transformation               Reports
                                                                                                                  SHRLGPA_QUALITY_POINTS
                                     USU cumulative graduate points obtained by                                   where
                                     multiplying the grade value by the credit hours for the                      SHRLGPA_GPA_TYPE_IND='I' &
GR_USU_GPA_POINTS                    student                                                   NUMBER       17,6 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_ATTEMPTED
                                                                                                                  where
                                     USU cumulative graduate hours attempted for the                              SHRLGPA_GPA_TYPE_IND='I' &
GR_USU_HRS_ATTEMPTED                 student                                                   NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                     USU cumulative graduate hours earned for the                                 SHRLGPA_GPA_TYPE_IND='I' &
GR_USU_HRS_EARNED                    student                                                   NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1                  x
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                     USU cumulative graduate hours passed for the                                 SHRLGPA_GPA_TYPE_IND='I' &
GR_USU_HRS_PASSED                    student                                                   NUMBER       11,3 SHRLGPA_LEVL_CODE='GR'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_GPA where
                                     Overall cumulative undergraduate level GPA for the                           SHRLGPA_GPA_TYPE_IND='O' &
UG_OVER_GPA                          student                                                   NUMBER       23,9 SHRL_GPA_LEVL_CODE = 'UG'     Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_GPA_HOURS where
                                     Overall cumulative hours used for undergraduate                              SHRLGPA_GPA_TYPE_IND='O' &
UG_OVER_GPA_HRS                      GPA calculation                                           NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_QUALITY_POINTS
                                     Overall cumulative undergraduate points obtained by                          where
                                     multiplying the grade value by the credit hours for the                      SHRLGPA_GPA_TYPE_IND='O' &
UG_OVER_GPA_POINTS                   student                                                   NUMBER       17,6 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_ATTEMPTED
                                                                                                                  where
                                     Overall cumulative undergraduate hours attempted for                         SHRLGPA_GPA_TYPE_IND='O' &
UG_OVER_HRS_ATTE                     the student                                               NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                     Overall cumulative undergraduate hours earned for                            SHRLGPA_GPA_TYPE_IND='O' &
UG_OVER_HRS_EARNED                   the student                                               NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                     Overall cumulative undergraduate hours passed for                            SHRLGPA_GPA_TYPE_IND='O' &
UG_OVER_HRS_PASSED                   the student                                               NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_GPA where
                                     Transfer cumulative undergraduate GPA for the                                SHRLGPA_GPA_TYPE_IND='T' &
UG_TRAN_GPA                          student                                                   NUMBER       23,9 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_GPA_HOURS where
                                     Transfer cumulative undergraduate hours used for                             SHRLGPA_GPA_TYPE_IND='T' &
UG_TRAN_GPA_HRS                      GPA calculation                                           NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_QUALITY_POINTS
                                     Transfer cumulative undergraduate points obtained by                         where
                                     multiplying the grade value by the credit hours for the                      SHRLGPA_GPA_TYPE_IND='T' &
UG_TRAN_GPA_POINTS                   student                                                   NUMBER       17,6 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                    Page 46 of 227                                                   4/21/2012
                                                                 Banner Reporting Warehouse Documentation (Student)
Table Name                             Table Description
DTSCPTSUM                              Student Transcript Summary Dimension
                                                                                                            Data                                                                     For AAA
Data Name                              Data Description                                        Data Format Length Data Source                  Data Transformation                   Reports
                                                                                                                  SHRLGPA_HOURS_ATTEMPTED
                                                                                                                  where
                                       Transfer cumulative undergraduate hours attempted                          SHRLGPA_GPA_TYPE_IND='T' &
UG_TRAN_HRS_ATTE                       for the student                                         NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                       Transfer cumulative undergraduate hours earned for                         SHRLGPA_GPA_TYPE_IND='T' &
UG_TRAN_HRS_EARNED                     the student                                             NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1                      x
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                       Transfer cumulative undergraduate hours passed for                         SHRLGPA_GPA_TYPE_IND='T' &
UG_TRAN_HRS_PASSED                     the student                                             NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_GPA where
                                                                                                                  SHRLGPA_GPA_TYPE_IND='I' &
UG_USU_GPA                             USU cumulative undergraduate GPA for the student NUMBER              23,9 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1                      x
                                                                                                                  SHRLGPA_GPA_HOURS where
                                       USU cumulative undergraduate hours used for GPA                            SHRLGPA_GPA_TYPE_IND='I' &
UG_USU_GPA_HRS                         calculation                                             NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_QUALITY_POINTS
                                       USU cumulative undergraduate points obtained by                            where
                                       multiplying the grade value by the credit hours for the                    SHRLGPA_GPA_TYPE_IND='I' &
UG_USU_GPA_POINTS                      student                                                 NUMBER       17,6 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_ATTEMPTED
                                                                                                                  where
                                       USU cumulative undergraduate hours attempted for                           SHRLGPA_GPA_TYPE_IND='I' &
UG_USU_HRS_ATTEMPTED                   the student                                             NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                       USU cumulative undergraduate hours earned for the                          SHRLGPA_GPA_TYPE_IND='I' &
UG_USU_HRS_EARNED                      student                                                 NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1                      x
                                                                                                                  SHRLGPA_HOURS_EARNED
                                                                                                                  where
                                       USU cumulative undergraduate hours passed for the                          SHRLGPA_GPA_TYPE_IND='I' &
UG_USU_HRS_PASSED                      student                                                 NUMBER       11,3 SHRLGPA_LEVL_CODE='UG'        Unpivot & Unpivot_1
PIDM                                   Unique identifier of a person in Banner                 NUMBER        8,0 SHRLGPA_PIDM
                                                                                                                                               EXPR expression
SK_PIDM                                Surrogate key for the student term dimension    VARCHAR2          30    SHRLGPA_PIDM                    (TO_CHAR(SHRLGPA_PIDM))




          3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                            Page 47 of 227                                                             4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DTSCPTSUM                            Student Transcript Summary Dimension
                                                                                          Data                                                      For AAA
Data Name                            Data Description                        Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                   Page 48 of 227                                       4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DTSCPTSUM                            Student Transcript Summary Dimension
                                                                                          Data                                                      For AAA
Data Name                            Data Description                        Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                   Page 49 of 227                                       4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DTSCPTSUM                            Student Transcript Summary Dimension
                                                                                          Data                                                      For AAA
Data Name                            Data Description                        Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                   Page 50 of 227                                       4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DTSCPTSUM                            Student Transcript Summary Dimension
                                                                                          Data                                                      For AAA
Data Name                            Data Description                        Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                   Page 51 of 227                                       4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
Table Name                           Table Description
DTSCPTSUM                            Student Transcript Summary Dimension
                                                                                          Data                                                      For AAA
Data Name                            Data Description                        Data Format Length Data Source       Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                   Page 52 of 227                                       4/21/2012
                                                                          Banner Reporting Warehouse Documentation (Student)
Table Name                                 Table Description
CRSREG_CUBE                                Course Registration Cube (Fact Table)
                                                                                                                   Data                                                                For AAA
Data Name                                  Data Description                                        Data Format    Length Data Source                 Data Transformation               Reports
                                                                                                                         PIDM from General Student
DGENSTUD_PIDM                              Unique identifier of a person in Banner                 NUMBER           8    Dimension
                                           Credits that a student is/was attempting to earn
ATTEMPT_CREDIT_HR                          with a registration/drop                                NUMBER            7,3   SFRSTCR_CREDIT_HR                                              x
DADVISOR_SK_STDPIDM_TERM                   Surrogate key from DADVISOR                             VARCHAR2          20
                                           Credits that a student earned upon completion of a
EARNED_CREDIT_HRS                          course                                                  NUMBER                                                                                 x
                                           Grade that a student received upon completion of a
GRADE                                      course                                                  VARCHAR2                                                                               x
DCOURSE_ID                                 Surrogate key from DCOURSE                              VARCHAR2          20
GENPERS_SK_PERSON_ID                       Surrogate key from DGENPERS                             NUMBER
DSTDTERM_SK_STD_TRM_ID                     Surrogate key from DSTDTERM                             VARCHAR2          20
DCONTACT_SK_DCONTACT_ID                    Surrogate key from DCONTACT                             VARCHAR2          20
DINSTR_SK_TERM_INSTR_PIDM                  Surrogate key from DINSTR                               VARCHAR2          20
DMEETING_SK_MEET_ID                        Surrogate key from DMEETING                             VARCHAR2          20
DTSCPTSUM_SK_PIDM_LEVEL                    Surrogate key from DTSCPTSUM                            VARCHAR2          20
                                           Unique identifier in Banner of the primary instructor                           SIRASGN_PIDM where
INST_PIDM                                  of a course section                                     NUMBER             8    SIRASGN_PRIMARY_IND='Y'                                        x
COURSE_FEE??
GRADE_TYPE
ADD/DROP
ADD/DROP_DATE

                           Registration status code which indicates whether
REG_STATUS_CODE            an entry in the fact table is a registration or drop.                   VARCHAR2           2    SFRSTCR_RSTS_CODE                                              x
PURGE
REGISTRATION_OVERRIDE_CODE
REGISTRATION_OVERRIDE_NAME
ADVISOR_OVERRIDE_CODE
ADVISOR_OVERRIDE_NAME




         3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                        Page 53 of 227                                                    4/21/2012
                                                            Banner Reporting Warehouse Documentation (Student)
                                                                                           Data                                                    For AAA
Data Name                                Data Description                  Data Format    Length Data Source     Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 54 of 227                                        4/21/2012
                                                            Banner Reporting Warehouse Documentation (Student)
                                                                                           Data                                                    For AAA
Data Name                                Data Description                  Data Format    Length Data Source     Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 55 of 227                                        4/21/2012
                                                            Banner Reporting Warehouse Documentation (Student)
                                                                                           Data                                                    For AAA
Data Name                                Data Description                  Data Format    Length Data Source     Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 56 of 227                                        4/21/2012
                                                            Banner Reporting Warehouse Documentation (Student)
                                                                                           Data                                                    For AAA
Data Name                                Data Description                  Data Format    Length Data Source     Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 57 of 227                                        4/21/2012
                                                            Banner Reporting Warehouse Documentation (Student)
                                                                                           Data                                                    For AAA
Data Name                                Data Description                  Data Format    Length Data Source     Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 58 of 227                                        4/21/2012
                                                                        Banner Reporting Warehouse Documentation (Student)
Table Name                               Table Description
CUBE_INSTR                               Instructor Cube (fact table)
                                                                                                                Data                                                            For AAA
Data Name                                Data Description                                       Data Format    Length Data Source             Data Transformation               Reports
DCOURSE_ID                               Surrogate key from DCOURSE                             VARCHAR2         20
DCRSATTR_SK_ID_TERM_CRN                  Surrogate key from DCRSATTR                            VARCHAR2         20
GENPERS_SK_PERSON_ID                     Surrogate key from DGENPERS                            NUMBER
DINSTR_SK_TERM_INSTR_PIDM                Surrogate key from DINSTR                              VARCHAR2          20
DMEETING_SK_MEET_ID                      Surrogate key from DMEETING                            VARCHAR2          20
                                         The percent of responsibility that an instructor has
                                                                                                                       SIRASGN_PERCENT_RESP
PERCENT_RESP                             in teaching a course section                           NUMBER                                                                             x
                                         Indicates if instructor is primary instructor for a
PRIMARY_IND                              course section                                         VARCHAR2           1   SIRASGN_PRIMARY_IND                                         x




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                       Page 59 of 227                                                4/21/2012
                                                            Banner Reporting Warehouse Documentation (Student)
                                                                                           Data                                                    For AAA
Data Name                                Data Description                  Data Format    Length Data Source     Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 60 of 227                                        4/21/2012
                                                            Banner Reporting Warehouse Documentation (Student)
                                                                                           Data                                                    For AAA
Data Name                                Data Description                  Data Format    Length Data Source     Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 61 of 227                                        4/21/2012
                                                            Banner Reporting Warehouse Documentation (Student)
                                                                                           Data                                                    For AAA
Data Name                                Data Description                  Data Format    Length Data Source     Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 62 of 227                                        4/21/2012
                                                            Banner Reporting Warehouse Documentation (Student)
                                                                                           Data                                                    For AAA
Data Name                                Data Description                  Data Format    Length Data Source     Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 63 of 227                                        4/21/2012
                                                            Banner Reporting Warehouse Documentation (Student)
                                                                                           Data                                                    For AAA
Data Name                                Data Description                  Data Format    Length Data Source     Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 64 of 227                                        4/21/2012
                                                                        Banner Reporting Warehouse Documentation (Student)
Table Name                                 Table Description
DAPPSTUD                                   Applied Students Dimension
                                                                                                            Data                                                                          For AAA
Data Name                                  Data Description                                    Data Format Length Data Source                     Data Transformation                     Reports
ADMIT_TYPE_CODE                            Admissions type of applicant                        VARCHAR2          2 SARADAP_ADMT_CODE
ADMIT_TYPE_DESC                            Description of the admissions type                  VARCHAR2        30 STVADMT_DESC
APPLIED_TERM                               Term of application                                 VARCHAR2          6 SARADAP_TERM_CODE_ENTRY
CAMPUS_CODE                                Applicant desired campus code                       VARCHAR2          3 SARADAP_CAMP_CODE
                                                                                                                                                  SARAPPD_TERM_CODE_ENTRY ||
                                                                                                                                                  SARAPPD_APPL_NO || SARAPPD_SEQ_NO
CAMPUS_DESC                                Description of the desired campus                   VARCHAR2              30   STVCAMP_DESC            || SARAPPD_PIDM
DEGREE_CODE_1                              Applicant primary desired degree code               VARCHAR2               6   SARADAP_DEGREE_CODE_1
DEGREE_CODE_2                              Applicant secondary desired degree code             VARCHAR2               6   SARADAP_DEGREE_CODE_2
DEGREE_NAME_1                              Full name of the primary degree                     VARCHAR2              30   STVDEGC_DESC
DEGREE_NAME_2                              Full name of the secondary degree                   VARCHAR2              30   STVDEGC_DESC
NUM                                        Application number for an application term          NUMBER                     SARADAP_APPL_NO
OVERALL_LEVEL_CODE                         Overall level of applicant code                     VARCHAR2               2   SARADAP_LEVL_CODE
OVERALL_LEVEL_DESC                         Description of the overall level of the applicant   VARCHAR2              30   STVLEVL_DESC
PIDM                                       Applicant identifier                                NUMBER                     SARADAP_PIDM
RESIDENCY_CODE                             Applicant determined residency code                 VARCHAR2               1   SARADAP_RESD_CODE
RESIDENCY_DESC                             Description of the determined residency             VARCHAR2              30   STVRESD_DESC
                                           Unique key generated from the applicant PIDM,                                                          SARADAP_TERM_CODE_ENTRY ||
SK_ID                                      term code, and application number                   VARCHAR2              30                           SARADAP_APPL_NO || SARADAP_PIDM
STATUS_CODE                                Application completion status                       VARCHAR2               1   SARADAP_APST_CODE
STATUS_DESC                                Description of the completion status                VARCHAR2              30   STVAPST_DESC
STUDENT_TYPE_CODE                          Determined student type code of the applicant       VARCHAR2               1   SARADAP_STYP_CODE
STUDENT_TYPE_DESC                          Description of the student type                     VARCHAR2              30   STVSTYP_DESC
COLLEGE_CODE_1                             Desired primary college code of the applicant       VARCHAR2               2   SARADAP_COLL_CODE_1
COLLEGE_NAME_1                             Full name of the primary college                    VARCHAR2              30   STVCOLL_DESC
COLLEGE_CODE_2                             Desired secondary college code of the applicant     VARCHAR2               2   SARADAP_COLL_CODE_2
COLLEGE_NAME_2                             Full name of the secondary college                  VARCHAR2              30   STVCOLL_DESC
DEPARTMENT_CODE_1                          Desired primary department of the applicant         VARCHAR2               4   SARADAP_DEPT_CODE
DEPARTMENT_NAME_1                          Full name of the primary department                 VARCHAR2              30   STVDEPT_DESC
DEPARTMENT_CODE_2                          Desired secondary department of the applicant       VARCHAR2               4   SARADAP_DEPT_CODE_2
DEPARTMENT_NAME_2                          Full name of the secondary department               VARCHAR2              30   STVDEPT_DESC
                                           The primary CIP code for the primary major in the
CIP_1                                      primary program                                     NUMBER                   STVMAJR_CIPC_CODE
MAJOR_CODE_1                               The primary major code for the primary program      VARCHAR2               4 SARADAP_MAJR_CODE_1
MAJOR_NAME_1                               Full name of the primary major                      VARCHAR2              30 STVMAJR_DESC
                                           The secondary CIP code for the secondary major in
CIP_2                                      the secondary program                               NUMBER                     STVMAJR_CIPC_CODE
                                           The secondary major code for the secondary
MAJOR_CODE_2                               program                                             VARCHAR2               4   SARADAP_MAJR_CODE_2
MAJOR_NAME_2                               Full name of the secondary major                    VARCHAR2              30   STVMAJR_DESC
PROGRAM_CODE_1                             Desired primary program code of the applicant       VARCHAR2              12   SARADAP_PROGRAM_1
PROGRAM_NAME_1                             Full name of the primary program                    VARCHAR2              30   SMRPRLE_PROGRAM_DESC

PROGRAM_CODE_2                             Desired secondary program code of the applicant     VARCHAR2              12 SARADAP_PROGRAM_2
PROGRAM_NAME_2                             Full name of the secondary program                  VARCHAR2              30 SMRPRLE_PROGRAM_DESC




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                    Page 65 of 227                                                            4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 66 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 67 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 68 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 69 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 70 of 227                                         4/21/2012
                                                                          Banner Reporting Warehouse Documentation (Student)
Table Name                                Table Description
DADMTSTD                                  Admitted Students Dimension
                                                                                                             Data                                                                     For AAA
Data Name                                 Data Description                                      Data Format Length Data Source                     Data Transformation                Reports
ADMITTED_TERM                             The term a student is admitted                        VARCHAR2          6 SGBSTDN_TERM_CODE_ADMIT
                                          Admission code which describes the entry type of
                                                                                                                           SGBSTDN_ADMT_CODE
ADMITTED_TYPE_CODE                        the student                                           VARCHAR2               2
ADMITTED_TYPE_DESC                        Description of the admission code                     VARCHAR2              30   STVADMT_DESC
CAMPUS_CODE                               Campus code assigned to the student                   VARCHAR2               3   SGBSTDN_CAMP_CODE
CAMPUS_DESC                               Description of the campus code                        VARCHAR2              30   STVCAMP_DESC
DEGREE_CODE_1                             Primary degree code                                   VARCHAR2               6   SGBSTDN_DEGC_CODE_1
DEGREE_CODE_2                             Secondary degree code                                 VARCHAR2               6   SGBSTDN_DEGC_CODE_2
DEGREE_NAME_1                             Full name of primary degree                           VARCHAR2              30   STVDEGC_DESC
DEGREE_NAME_2                             Full name of secondary degree                         VARCHAR2              30   STVDEGC_DESC
EFFECTIVE_TERM                            Term for which student information is active          VARCHAR2               6   SGBSTDN_TERM_CODE_EFF
FEE_RATE_CODE                             Tuition fee rate code determined by term of entry     VARCHAR2               5   SGBSTDN_RATE_CODE
FEE_RATE_DESC                             Description of fee rate code                          VARCHAR2              30   STVRATE_DESC
                                                                                                                                                   SGBSTDN_TERM_CODE_EFF ||
ID                                        Key identifier combining PIDM and term                VARCHAR2              30                           SGBSTDN_PIDM
PIDM                                      Student identifier                                    NUMBER                   SGBSTDN_PIDM
RESIDENCY_CODE                            Residency determined at admissions                    VARCHAR2               1 SGBSTDN_RESD_CODE
RESIDENCY_DESC                            Description of residency code                         VARCHAR2              30 STVRESD_DESC

STATUS_CODE                               Activity status indicator of student record by term   VARCHAR2               2 SGBSTDN_STST_CODE
STATUS_DESCRIPTION                        Description of activity status code                   VARCHAR2              30 STVSTST_DESC
                                          Student type code determined by first-time or
STUDENT_TYPE_CODE                         continuing student                                    VARCHAR2               1   SGBSTDN_STYP_CODE
STUDENT_TYPE_DESC                         Description of student type code                      VARCHAR2              30   STVSTYP_DESC
COLLEGE_CODE_1                            The primary college code of the primary program       VARCHAR2               2   SGBSTDN_COLL_CODE_1
COLLEGE_NAME_1                            Full name of the primary college code                 VARCHAR2              30   STVCOLL_DESC
                                          The secondary college code of the secondary
COLLEGE_CODE_2                            program                                               VARCHAR2               2   SGBSTDN_COLL_CODE_2
COLLEGE_NAME_2                            Full name of the secondary college                    VARCHAR2              30   STVCOLL_DESC
DEPARTMENT_CODE_1                         The primary department of the primary program         VARCHAR2               4   SGBSTDN_DEPT_CODE
DEPARTMENT_NAME_1                         Full name of the primary department                   VARCHAR2              30   STVDEPT_DESC
                                          The secondary department of the secondary
DEPARTMENT_CODE_2                         program                                               VARCHAR2               4   SGBSTDN_DEPT_CODE_2
DEPARTMENT_NAME_2                         Full name of the secondary department                 VARCHAR2              30   STVDEPT_DESC
MAJOR_CODE_1                              The primary major code of the primary program         VARCHAR2               4   SGBSTDN_MAJR_CODE_1
MAJOR_NAME_1                              Full name of the primary major                        VARCHAR2              30   STVMAJR_DESC
                                          The secondary major code of the secondary
MAJOR_CODE_2                              program                                               VARCHAR2               4   SGBSTDN_MAJR_CODE_2
MAJOR_NAME_2                              Full name of the secondary major                      VARCHAR2              30   STVMAJR_DESC
PROGRAM_CODE_1                            The primary program code                              VARCHAR2              12   SGBSTDN_PROGRAM_1
PROGRAM_NAME_1                            Full name of the primary program                      VARCHAR2              30   SMRPRLE_PROGRAM_DESC
PROGRAM_CODE_2                            The secondary program code                            VARCHAR2              12   SGBSTDN_PROGRAM_2
PROGRAM_NAME_2                            Full name of the secondary program                    VARCHAR2              30   SMRPRLE_PROGRAM_DESC




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                     Page 71 of 227                                                           4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                   For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation           Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 72 of 227                                        4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                   For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation           Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 73 of 227                                        4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                   For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation           Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 74 of 227                                        4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                   For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation           Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 75 of 227                                        4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                   For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation           Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 76 of 227                                        4/21/2012
                                                                          Banner Reporting Warehouse Documentation (Student)
Table Name                                Table Description
DDECISION                                 Application Decisions Dimension
                                                                                                           Data                                                                        For AAA
Data Name                                 Data Description                                    Data Format Length Data Source                    Data Transformation                    Reports
APPLICATION_NUMBER                        Application number                                  NUMBER              SARAPPD_APPL_NO
CODE                                      Decision code for application                       VARCHAR2          2 SARAPPD_APDC_CODE
DESCRIPTION                               Description of decision code                        VARCHAR2        30 STVAPDC_DESC
EFFECTIVE_DATE                            Date decision is effective                          DATE                SARAPPD_APDC_DATE
                                                                                                                                                SARAPPD_TERM_CODE_ENTRY ||
                                          Decision ID combined from PIDM, term, application                                                     SARAPPD_APPL_NO || SARAPPD_SEQ_NO
ID                                        number, and decision sequence number                VARCHAR2              18                          || SARAPPD_PIDM
PIDM                                      Unique student identifier                           NUMBER                  SARAPPD_PIDM
SEQUENCE_NUMBER                           Decision sequence number                            NUMBER                  SARAPPD_SEQ_NO
TERM_CODE_ENTRY                           Term of admissions                                  VARCHAR2              6 SARAPPD_TERM_CODE_ENTRY




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                    Page 77 of 227                                                          4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 78 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 79 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 80 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 81 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 82 of 227                                         4/21/2012
                                                                       Banner Reporting Warehouse Documentation (Student)
Table Name                                Table Description
FACCEPTED-CUBE                            Accepted Students Cube (Fact Table)
                                                                                                     Data                                                                       For AAA
Data Name                                 Data Description                              Data Format Length Data Source                   Data Transformation                    Reports
APP_NUM                                   Maximum application number                    NUMBER             SARADAP_APPL_NO               MAX (SARADAP_APPL_NO)
DEC_NUM                                   Maximum decision number                       NUMBER             SARAPPD_SEQ_NO                MAX (SARAPPD_SEQ_NO)
DEC_DATE                                  Maximum decision date                         DATE               SARAPPD_APDC_DATE
PIDM                                      Student ID                                    NUMBER             SGBSTDN_PIDM
                                                                                                                                         SARAPPD_TERM_CODE_ENTRY ||
                                                                                                                                         SARAPPD_APPL_NO || SARAPPD_SEQ_NO
TERM                                      Accepted term                                 VARCHAR2               6 SGBSTDN_TERM_CODE_EFF   || SARAPPD_PIDM
DCONTACT_SK_DCONTACT_ID                   Foreign key to contact dimension              VARCHAR2              30                         See dimension definition
GENPERS_SK_PERSON_ID                      Foreign key to general person dimension       VARCHAR2              30                         See dimension definition
DECISION_ID                               Foreign key to decision dimension             VARCHAR2              30                         See dimension definition
APPSTUD_SK_ID                             Foreign key to applied student dimension      VARCHAR2              30                         See dimension definition
DSTUDATTR_SK_ID_TERM_PIDM                 Foreign key to student attributes dimension   VARCHAR2              30                         See dimension definition
DADMTSTD_ID                               Foreign key to admitted students dimension    VARCHAR2              30                         See dimension definition
DGENSTUD_PIDM                             Foreign key to general student dimension      VARCHAR2              30                         See dimension definition
DSTDTERM_SK_STD_TRM_ID                    Foreign key to student term dimension         VARCHAR2              30                         See dimension definition




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                              Page 83 of 227                                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 84 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 85 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 86 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 87 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 88 of 227                                         4/21/2012
                                                                      Banner Reporting Warehouse Documentation (Student)
Table Name                               Table Description
FAPPSTUD-CUBE                            Applied Students Cube (Fact Table)
                                                                                                    Data                                                                  For AAA
Data Name                                Data Description                              Data Format Length Data Source              Data Transformation                    Reports
APP_NUMBER                               Application number                            NUMBER              SARADAP_APPL_NO
PIDM                                     Student ID                                    NUMBER              SGBSTDN_PIDM
TERM                                     Accepted term                                 VARCHAR2          6 SGBSTDN_TERM_CODE_EFF
DCONTACT_SK_DCONTACT_ID                  Foreign key to contact dimension              VARCHAR2        30                          See dimension definition
                                                                                                                                   SARAPPD_TERM_CODE_ENTRY ||
                                                                                                                                   SARAPPD_APPL_NO || SARAPPD_SEQ_NO
GENPERS_SK_PERSON_ID                     Foreign key to general person dimension       VARCHAR2              30                    || SARAPPD_PIDM
DECISION_ID                              Foreign key to decision dimension             VARCHAR2              30                    See dimension definition
APPSTUD_SK_ID                            Foreign key to applied student dimension      VARCHAR2              30                    See dimension definition
DSTUDATTR_SK_ID_TERM_PIDM                Foreign key to student attributes dimension   VARCHAR2              30                    See dimension definition
DADMTSTD_ID                              Foreign key to admitted students dimension    VARCHAR2              30                    See dimension definition
DGENSTUD_PIDM                            Foreign key to general student dimension      VARCHAR2              30                    See dimension definition
DSTDTERM_SK_STD_TRM_ID                   Foreign key to student term dimension         VARCHAR2              30                    See dimension definition




      3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                              Page 89 of 227                                                    4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 90 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 91 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 92 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 93 of 227                                         4/21/2012
                                                             Banner Reporting Warehouse Documentation (Student)
                                                                                         Data                                                       For AAA
Data Name                                 Data Description                  Data Format Length Data Source        Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 94 of 227                                         4/21/2012
                                                                            Banner Reporting Warehouse Documentation
Table Name                            Table Description
DCRSATTR                              Course Attributes Dimension
                                                                                                                  Data                                                                        For AAA
Data Name                             Data Description                                               Data Format Length Data Source                         Data Transformation               Reports
ASC_PROGRAM                           Indicates if a course is part of the ASC program               VARCHAR2      4    SSRATTR_ATTR_CODE = 'CPAS'          UNPIVOT
ATC_BRIGHAM                           Indicates if a course is a Brigham ATC course section          VARCHAR2      4    SSRATTR_ATTR_CODE = 'CPAB'          UNPIVOT
ATC_LOGAN                             Indicates if a course is a Logan ATC course section            VARCHAR2      4    SSRATTR_ATTR_CODE = 'CPAL'          UNPIVOT
                                      Indicates if a course is a Uintah Basin ATC course
ATC_UINTAH_BASIN                      section                                                        VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPAU'    UNPIVOT
BATC_LOGAN                            Indicates if a course is taught at Logan BATC                  VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPBR'    UNPIVOT
BEIJING_INST_OF_TECH                                                                                 VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPIB'    UNPIVOT
                                      Indicates if a continuing education course section is
BUDGET_RELATED_CIDL                   supposed to be budget related.                                 VARCHAR2             4   SSRATTR_ATTR_CODE = 'CBBR'    UNPIVOT
CAINE_DAIRY_HERDSMAN                                                                                 VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPCD'    UNPIVOT
CAPP_CODING_REQ_FACS                                                                                 VARCHAR2             4   SSRATTR_ATTR_CODE = '^FAC'    UNPIVOT
CENTRO_DE_LA_FAMILIA                                                                                 VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPCF'    UNPIVOT
                                      Indicates if a course section is a concurrent enrollment in
CONCURRENT_BRIGHAM                    the Brigham center.                                            VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPCB'    UNPIVOT
                                      Indicates if a course section is a concurrent enrollment in
CONCURRENT_LOGAN                      the Logan center.                                              VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPCL'    UNPIVOT
                                      Indicates if a course section is a concurrent enrollment in
CONCURRENT_OGDEN                      the Ogden center.                                              VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPCG'    UNPIVOT
                                      Indicates if a course section is a concurrent enrollment in
CONCURRENT_ONLINE                     the Online center.                                             VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPCO'    UNPIVOT
                                      Indicates if a course section is a concurrent enrollment in
CONCURRENT_SOUTHWEST                  the Southwest center.                                          VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPCC'    UNPIVOT
                                      Indicates if a course section is a concurrent enrollment in
CONCURRENT_TOOELE                     the Tooele center.                                             VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPCT'    UNPIVOT
                                      Course reference number for which the course section
CRN                                   attributes apply                                               VARCHAR2             5   SSRATTR_CRN
DIETETICS_SLC                                                                                        VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPDS'    UNPIVOT
ECOSYSTEMS_MGMT                                                                                      VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPES'    UNPIVOT
EDNET                                 Indicates if a course section is taught through EDNet.         VARCHAR2             4   SSRATTR_ATTR_CODE = 'CDE'     UNPIVOT
EDUCERE                                                                                              VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPEU'    UNPIVOT
                                      Indicates if a course section is being taught as part of the
ED_DOCTORATE                          Education Doctorate program.                                   VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPED'    UNPIVOT
                                      Indicates if a course section is being taught as part of the
                                      Family, Consumer and Human Development Masters
FCHD_MASTERS                          program.                                                       VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPFD'    UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the American Institutions
GE_AMER_INST                          requirement.                                                   VARCHAR2             4   SSRATTR_ATTR_CODE = 'AI'      UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Breadth American Institutions
GE_BREADTH_AMER_INST                  requirement.                                                   VARCHAR2             4   SSRATTR_ATTR_CODE = 'BAI'     UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Breadth Creative Arts
GE_BREADTH_CREAT                      requirement.                                                   VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Breadth Life Sciences
GE_BREADTH_LIFE_SCIS                  requirement.                                                   VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Breadth Physical Sciences
GE_BREADTH_PHYS_SCIS                  requirement.                                                   VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT


         3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                        Page 95 of 227                                                           4/21/2012
                                                                          Banner Reporting Warehouse Documentation
Table Name                            Table Description
DCRSATTR                              Course Attributes Dimension
                                                                                                              Data                                                                        For AAA
Data Name                             Data Description                                           Data Format Length Data Source                         Data Transformation               Reports

                                      Indicates if a course section is a General Education
GE_BREADTH_SCIENCES                   course which satisfies the Breadth Sciences requirement.   VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Breadth Social Sciences
GE_BREADTH_SOC_SCIS                   requirement.                                               VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Communications Intensive
GE_COMM_INTENSIVE                     requirement.                                               VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Communications Literacy
GE_COMM_LITERACY                      requirement.                                               VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Depth Humanities & Creative
GE_DEPTH_HUMS_CARTS                   Arts requirement.                                          VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Depth Social Sciences
GE_DEPTH_SOC_SCIS                     requirement.                                               VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

                                      Indicates if a course section is a General Education
GE_INTEGRATIVE_OPTION                 course which satisfies the Integrative Option requirement. VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

                                      Indicates if a course section is a General Education
GE_LEARNING_SKILLS                    course which satisfies the Learning Skills requirement.    VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
GE_LIFE_SCIENCES                      course which satisfies the Life Sciences requirement.      VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Physical Sciences
GE_PHYSICAL_SCIENCES                  requirement.                                               VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Quantitative Intensive
GE_QUANT_INTENSIVE                    requirement.                                               VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Quantitative Literacy
GE_QUANT_LITERACY                     requirement.                                               VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

                                      Indicates if a course section is a General Education
GE_SOCIAL_SCIENCES                    course which satisfies the Social Sciences requirement.    VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Written Communications
GE_WRITTEN_COMM                       requirement.                                               VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is part of the Gifted and
GIFTED_AND_TALENTED                   Talented Program.                                          VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

GRANITE_READ_ENDORSE                                                                             VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

HILL_AFB_IDTC                                                                                    VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

HORTICULTURE_WASATCH                                                                             VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

HPER_MASTER_EDUC                                                                                 VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

         3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                    Page 96 of 227                                                           4/21/2012
                                                                              Banner Reporting Warehouse Documentation
Table Name                             Table Description
DCRSATTR                               Course Attributes Dimension
                                                                                                                  Data                                                                        For AAA
Data Name                              Data Description                                              Data Format Length Data Source                         Data Transformation               Reports

INST_TECH_EDS                                                                                       VARCHAR2              4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                       Indicates if a course section is being taught as part of the
INTL_CHINA                             International Program in China.                              VARCHAR2              4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

                                       Indicates if a course section is being taught as part of the
INTL_HK_SING                           International Program in Hong Kong and Singapore.            VARCHAR2              4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

JOB_CORP_ATC_OGDEN                                                                                   VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

JR_ENGR                                                                                              VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

LIBRARY_MEDIA                                                                                        VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

MASTERS_IT                                                                                           VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

MBA                                                                                                  VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

MBA_DISTANCE                                                                                         VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

MBA_OGDEN                                                                                            VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

MBA_UACPA                                                                                            VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

MBA_UVSC                                                                                             VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

NE_INST_OF_EPE                                                                                       VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

OUT_OF_STATE                           Indicates if a course section is being taught out of state.   VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

PALMYRA                                                                                              VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

PROVO_COLLEGE                                                                                        VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

PSYCH_COUNSELING                                                                                     VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

PUB_ADMIN                                                                                            VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

READING_FIRST                                                                                        VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

RECORDING_FEE                          Indicates if a course section is a recording fee section.     VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

REHAB_PROGRAM                                                                                        VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

REMEDIAL_CRS                           Indicates if a course section is a remedial course section. VARCHAR2               4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

ROUND_RIVER                                                                                          VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

SATELLITE                              Indicates if a course section is taught by satellite.         VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

SEC_READ_ENDORSE                                                                                     VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

          3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                       Page 97 of 227                                                           4/21/2012
                                                                            Banner Reporting Warehouse Documentation
Table Name                            Table Description
DCRSATTR                              Course Attributes Dimension
                                                                                                                  Data                                                                              For AAA
Data Name                             Data Description                                               Data Format Length Data Source                         Data Transformation                     Reports
                                      Indicates if a continuing education course section is
SELF_SUPPORT_CIDL                     supposed to be self supported.                                 VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                                                                                                              SSRATTR_TERM_CODE &            EXPRESSION (SSRATTR_TERM_CODE ||
SK_ID_TERM_CRN                        Surrogate key for the dimension.                               VARCHAR2         20      SSRATTR_CRN                    SSRATTR_CRN)

SPEC_PRGMS_PETE                                                                                      VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

SPEC_PRGMS_RONDA                                                                                     VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

SPEC_PRGMS_VINCE                                                                                     VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

SPED_WASATCH                                                                                     VARCHAR2                 4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is taught as a summer credit
SUMMER_CRED_WORKSHOPS                 workshop.                                                  VARCHAR2                 4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

TECH_WRITING                                                                                         VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
TERM_CODE                             Term for which the course section attributes apply             VARCHAR2             6   SSRATTR_TERM_CODE
                                      Indicates if a course section is being taught as part of the
TETON_SCIENCE                         Teton Science Program.                                         VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a Utah Electronic College
UT_ELEC_COLL                          offering.                                                      VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is being taught as part of the
UT_WRITING_PROJECT                    Utah Writing Project Program.                                  VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is being taught through video
VIDEO_CONFERENCING                    conferencing.                                                  VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

WORKFORCE_SERV_TOOELE                                                                                VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a year-long independent
YEAR_LONG_IND_STUDY                   study section.                                                 VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT

YEAR_LONG_ONLINE                      Indicates if a course section is a year-long online section.   VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a concurrent enrollment in
CONCURRENT_UB                         the Uintah Basin center.                                       VARCHAR2             4   SSRATTR_ATTR_CODE = 'CPCU'    UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Depth Humanities
GE_BREADTH_HUMS                       requirement.                                                   VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Depth Humanities
GE_BREADTH_HUMS_2                     requirement.                                                   VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT
                                      Indicates if a course section is a General Education
                                      course which satisfies the Depth Life & Physical
GE_DEPTH_LP_SCIS                      Sciences requirement.                                          VARCHAR2             4   SSRATTR_ATTR_CODE = 'xxxxxxxx' UNPIVOT




         3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                        Page 98 of 227                                                                 4/21/2012
                                                                            Banner Reporting Warehouse Documentation
Table Name                            Table Description
DSTUDATTR                             Student Attributes Dimension
                                                                                                               Data                                                                      For AAA
Data Name                             Data Description                                            Data Format Length Data Source                       Data Transformation               Reports
AA_AS_GE_WAIVED                                                                                   VARCHAR2      4    SGRSATT_ATTR_CODE = 'AS00'        UNPIVOT
ALTAMONT_HS                                                                                       VARCHAR2      4    SGRSATT_ATTR_CODE = 'HS02'        UNPIVOT
ALTA_HS                                                                                           VARCHAR2      4    SGRSATT_ATTR_CODE = 'HS01'        UNPIVOT
                                      Indicates if a student qualifies as an american indian
AMER_IND_ELIG_RES                     resident.                                                   VARCHAR2            4   SGRSATT_ATTR_CODE = 'AIER'   UNPIVOT
                                      Indicates if a student is participating in an NCAA sport
ATHLETE                               during a term.                                              VARCHAR2            4   SGRSATT_ATTR_CODE = 'ATHL'   UNPIVOT
BEAR_RIVER_HS                                                                                     VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS57'   UNPIVOT
BEAVER_HS                                                                                         VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS03'   UNPIVOT
BEN_LOMAND_HS                                                                                     VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS04'   UNPIVOT
BINGHAM_HS                                                                                        VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS05'   UNPIVOT
BONNEVILLE_HS                                                                                     VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS06'   UNPIVOT
BOX_ELDER_HS                                                                                      VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS56'   UNPIVOT
BRIGHTON_HS                                                                                       VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS07'   UNPIVOT
BRYCE_VALLEY_HS                                                                                   VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS08'   UNPIVOT
CANYON_VIEW_HS                                                                                    VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS52'   UNPIVOT
CEDAR_CITY_HS                                                                                     VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS09'   UNPIVOT
CITY_ACADEMY_HS                                                                                   VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS60'   UNPIVOT
                                      Indicates if a student is participating in the concurrent
CONCURRENT_UG_GR                      engineering undergraduate/graduate degree program.          VARCHAR2            4   SGRSATT_ATTR_CODE = 'CUG'    UNPIVOT
COPPER_HILLS_HS                                                                                   VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS10'   UNPIVOT
DELTA_HS                                                                                          VARCHAR2            4   SGRSATT_ATTR_CODE = 'HS11'   UNPIVOT

DEPENDENT                             Indicates if a student is a dependent of a USU employee. VARCHAR2               4   SGRSATT_ATTR_CODE = 'DEP'    UNPIVOT
                                      Indicates if a student is at USU because he/she was
DISPLACED_BY_KATRINA                  displaced by Hurricane Katrina.                          VARCHAR2               4   SGRSATT_ATTR_CODE = 'KATR'   UNPIVOT
DRC_PARTICIPANT                                                                                VARCHAR2               4   SGRSATT_ATTR_CODE = 'DRC'    UNPIVOT
DUCHESNE_HS                                                                                    VARCHAR2               4   SGRSATT_ATTR_CODE = 'HS12'   UNPIVOT
DUGWAY_HS                                                                                      VARCHAR2               4   SGRSATT_ATTR_CODE = 'HS13'   UNPIVOT
EDUCARE_PA_AGREE                                                                               VARCHAR2               4   SGRSATT_ATTR_CODE = 'ECER'   UNPIVOT
EMPLOYEE                              Indicates if a student is an employee of USU.            VARCHAR2               4   SGRSATT_ATTR_CODE = 'EMP'    UNPIVOT
ENGR_STATE_PARTI                                                                               VARCHAR2               4   SGRSATT_ATTR_CODE = 'ES'     UNPIVOT
ENTERPRISE_HS                                                                                  VARCHAR2               4   SGRSATT_ATTR_CODE = 'HS14'   UNPIVOT
ESCALANTE_HS                                                                                   VARCHAR2               4   SGRSATT_ATTR_CODE = 'HS15'   UNPIVOT

FIRST_GEN_STUDENT                     Indicates if a student is a first generation student at USU. VARCHAR2           4   SGRSATT_ATTR_CODE = 'FGS'    UNPIVOT
FREEMONT_HS                                                                                        VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS16'   UNPIVOT
GRAND_COUNTY_HS                                                                                    VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS17'   UNPIVOT
GRANTSVILLE_HS                                                                                     VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS59'   UNPIVOT
GUNNISON_VALLEY_HS                                                                                 VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS50'   UNPIVOT
HILLCREST_HS                                                                                       VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS18'   UNPIVOT
                                      Indicates if a student is participating in the honors
HONOR_STUD                            program.                                                     VARCHAR2           4   SGRSATT_ATTR_CODE = 'HONR'   UNPIVOT
                                      Indicates if a student is incarcerated while attending USU
INCARCERATED                          through continuing education.                                VARCHAR2           4   SGRSATT_ATTR_CODE = 'INCA'   UNPIVOT
JORDAN_HS                                                                                          VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS19'   UNPIVOT
KANAB_HS                                                                                           VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS20'   UNPIVOT
LAKE_POWELL_HS                                                                                     VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS21'   UNPIVOT
LOGAN_HS                                                                                           VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS55'   UNPIVOT
MALAD_HS                                                                                           VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS54'   UNPIVOT
MANILA_HS                                                                                          VARCHAR2           4   SGRSATT_ATTR_CODE = 'HS22'   UNPIVOT

        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                     Page 99 of 227                                                          4/21/2012
                                                                             Banner Reporting Warehouse Documentation
Table Name                             Table Description
DSTUDATTR                              Student Attributes Dimension
                                                                                                                   Data                                                                           For AAA
Data Name                              Data Description                                               Data Format Length Data Source                        Data Transformation                   Reports
MANTI_HS                                                                                              VARCHAR2      4    SGRSATT_ATTR_CODE = 'HS51'         UNPIVOT
MILFORD_HS                                                                                            VARCHAR2      4    SGRSATT_ATTR_CODE = 'HS23'         UNPIVOT
MORGAN_HS                                                                                             VARCHAR2      4    SGRSATT_ATTR_CODE = 'HS24'         UNPIVOT
MTN_CREST_HS                                                                                          VARCHAR2      4    SGRSATT_ATTR_CODE = 'HS25'         UNPIVOT
                                       Indicates if a student is part of the multicultural student
MULTICULTURAL_STUD                     population.                                                    VARCHAR2             4   SGRSATT_ATTR_CODE = 'MULT'   UNPIVOT
NATL_STUD_EXCH                                                                                        VARCHAR2             4   SGRSATT_ATTR_CODE = 'NSE'    UNPIVOT
                                       Indicates if the student started at USU paying non-
                                       resident tuition, but has now qualified to pay resident
NON_RES_CHANGED_RES                    tuition.                                                       VARCHAR2             4   SGRSATT_ATTR_CODE = 'RCFN'   UNPIVOT
NORTHRIDGE_HS                                                                                         VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS29'   UNPIVOT
N_SANPETE_HS                                                                                          VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS26'   UNPIVOT
N_SEVIER_HS                                                                                           VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS27'   UNPIVOT
N_SUMMIT_HS                                                                                           VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS28'   UNPIVOT
OGDEN_HS                                                                                              VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS30'   UNPIVOT
PANGUITCH_HS                                                                                          VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS31'   UNPIVOT
PIDM                                   Unique identifier of a person in Banner.                       VARCHAR2             4   SGRSATT_PIDM
PIUTE_HS                                                                                              VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS32'   UNPIVOT
POST_HS_TRANSFER                                                                                      VARCHAR2             4   SGRSATT_ATTR_CODE = 'TRAN'   UNPIVOT
PRESTON_HS                                                                                            VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS53'   UNPIVOT
                                       Indicates if a student has reentered college after a 5-year
REENTRY_OUT_5_YR                       absence.                                                    VARCHAR2                4   SGRSATT_ATTR_CODE = 'RA5Y'   UNPIVOT
RICH_HS                                                                                            VARCHAR2                4   SGRSATT_ATTR_CODE = 'HS33'   UNPIVOT
RIVERTON_HS                                                                                        VARCHAR2                4   SGRSATT_ATTR_CODE = 'HS34'   UNPIVOT
                                       Indicates if a student is trying to obtain a second
SECOND_BACH                            bachelor's degree.                                          VARCHAR2                4   SGRSATT_ATTR_CODE = 'SECB'   UNPIVOT
SKY_VIEW_HS                                                                                        VARCHAR2                4   SGRSATT_ATTR_CODE = 'HS35'   UNPIVOT
                                                                                                                               SFBETRM_TERM_CODE &          EXPRESSION (SFBETRM_TERM_CODE ||
SK_ID_TERM_PIDM                        Surrogate key for the student attributes dimension.            VARCHAR2         30      SGRSATT_PIDM                 SGRSATT_PIDM)
                                       Indicates if a student is the spouse of an employee at
SPOUSE                                 USU.                                                           VARCHAR2             4   SGRSATT_ATTR_CODE = 'SPO'    UNPIVOT
                                       Indicates if a student is a senior citizen auditting courses
SR_CITIZEN                             at USU.                                                        VARCHAR2             4   SGRSATT_ATTR_CODE = 'SRC'    UNPIVOT
                                       Indicates if a student is attending USU from another
STUDY_ABROAD_AT_USU                    school through the study abroad program.                       VARCHAR2             4   SGRSATT_ATTR_CODE = 'SA'     UNPIVOT
S_SUMMIT_HS                                                                                           VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS36'   UNPIVOT
TABIONA_HS                                                                                            VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS37'   UNPIVOT

TERM_CODE                              Indicates the term for which the student attributes apply.     VARCHAR2             6   SFBETRM_TERM_CODE
TINTIC_HS                                                                                             VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS38'   UNPIVOT
TOOELE_HS                                                                                             VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS58'   UNPIVOT
TRIO_PARTICIPANT                                                                                      VARCHAR2             4   SGRSATT_ATTR_CODE = 'TRIO'   UNPIVOT
TUACHAN_HS                                                                                            VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS49'   UNPIVOT
UINTAH_HS                                                                                             VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS39'   UNPIVOT
UINTAH_RIVER_HS                                                                                       VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS40'   UNPIVOT
                                       Indicates if a student qualifies as an undocumented
UNDOC_ELIG_RES                         eligible resident.                                             VARCHAR2             4   SGRSATT_ATTR_CODE = 'UDER'   UNPIVOT
UNION_HS                                                                                              VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS41'   UNPIVOT
                                       Indicates if a student is taking courses at USU through
UT_ELEC_COLL                           the Utah Electronic College.                                   VARCHAR2             4   SGRSATT_ATTR_CODE = 'UEC'    UNPIVOT
VALLEY_HS                                                                                             VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS42'   UNPIVOT

         3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                        Page 100 of 227                                                              4/21/2012
                                                                            Banner Reporting Warehouse Documentation
Table Name                            Table Description
DSTUDATTR                             Student Attributes Dimension
                                                                                                             Data                                                                       For AAA
Data Name                             Data Description                                          Data Format Length Data Source                        Data Transformation               Reports
WAYNE_COUNTY_HS                                                                                 VARCHAR2      4    SGRSATT_ATTR_CODE = 'HS43'         UNPIVOT
WEBER_HS                                                                                        VARCHAR2      4    SGRSATT_ATTR_CODE = 'HS44'         UNPIVOT
WENDOVER_HS                                                                                     VARCHAR2      4    SGRSATT_ATTR_CODE = 'HS45'         UNPIVOT
                                      Indicates if a student is taking courses at USU through
WESTERN_GOV_UNIV                      the Western Governor's University.                        VARCHAR2             4   SGRSATT_ATTR_CODE = 'WGU'    UNPIVOT
WESTERN_UG_EXCH                                                                                 VARCHAR2             4   SGRSATT_ATTR_CODE = 'WUE'    UNPIVOT
WEST_SIDE_HS                                                                                    VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS48'   UNPIVOT
W_DESERT_HS                                                                                     VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS46'   UNPIVOT
W_JORDAN_HS                                                                                     VARCHAR2             4   SGRSATT_ATTR_CODE = 'HS47'   UNPIVOT
AA_AS_GE_WAIV_XLPSC                                                                             VARCHAR2             4   SGRSATT_ATTR_CODE = 'ASLP'   UNPIVOT
AA_AS_GE_WAIV_XQLIT                                                                             VARCHAR2             4   SGRSATT_ATTR_CODE = 'ASQL'   UNPIVOT
                                      Indicates if a student qualifies as an active military
MILITARY_RES                          resident.                                                 VARCHAR2             4   SGRSATT_ATTR_CODE = 'MSAU'   UNPIVOT




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                                   Page 101 of 227                                                          4/21/2012
                                                                          Banner Reporting Warehouse Documentation
Table Name                          Table Description
DFINAID                             Financial aid information dimension

                                                                                                  Data                                                  For AAA
Data Name               Data Description                                           Data Format   Length Data Source   Data Transformation               Reports
FUND_CODE
FUND_DESCRIPTION
AID_TYPE_CODE
AID_TYPE_DESCRIPTION
ACT_REQUIREMENT
GPA_MINIMUM_REQUIREMENT
MAX_AMOUNT_AVAILABLE
MAX_AMOUNT_STD
MIN_AMOUNT_STD
MIN_ENROLL_REQUIREMENT
AID_CLASSIFICATION




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                          Page 102 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 103 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 104 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 105 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 106 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 107 of 227                                   4/21/2012
                                                                    Banner Reporting Warehouse Documentation
Table Name                         Table Description
DACCOUNTS                          Accounts information dimension
                                                                                            Data                                                  For AAA
Data Name                          Data Description                          Data Format   Length Data Source   Data Transformation               Reports
CAMPUS
DETAIL_CODE
DETAIL_DESCRIPTION
DETAIL_CATEGORY_CODE
DETAIL_CATEGORY_DESC
SK_ACCOUNT_ID




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                     Page 108 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 109 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 110 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 111 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 112 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 113 of 227                                   4/21/2012
                                                                 Banner Reporting Warehouse Documentation
Table Name                          Table Description
DTERM                               Term information dimension

                                                                                         Data                                                  For AAA
Data Name                           Data Description                      Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                 Page 114 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 115 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 116 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 117 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 118 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 119 of 227                                   4/21/2012
                                                                    Banner Reporting Warehouse Documentation
Table Name                          Table Description
DLETTERS                            Letters information dimension
                                                                                            Data                                                  For AAA
Data Name                           Data Description                         Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                    Page 120 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 121 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 122 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 123 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 124 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 125 of 227                                   4/21/2012
                                                                   Banner Reporting Warehouse Documentation
Table Name                          Table Description
DCOHORT                             Cohort information dimension
                                                                                           Data                                                  For AAA
Data Name                           Data Description                        Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                   Page 126 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation
                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 127 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation
                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 128 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation
                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 129 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation
                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 130 of 227                                   4/21/2012
                                                      Banner Reporting Warehouse Documentation
                                                                              Data                                                  For AAA
Data Name                          Data Description            Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 131 of 227                                   4/21/2012
                                                                    Banner Reporting Warehouse Documentation
Table Name                             Table Description
FAPPLIED                               Applied student fact table
                                                                                             Data                                              For AAA
Data Name                Data Description                                    Data Format    Length Data Source   Data Transformation           Reports
APPLIED_STATUS_CODE
APPLIED_STATUS_DATE
ADMIT_TYPE
PIDM
TERM_CODE
APPLIED_NUMBER
APPLIED_NUMBER_DATE
CAMPUS
APPLIED_RESIDENCY
CURRENT_DECISION_CODE
DECISION_DATE
APPLICATION_SOURCE
ATTRIBUTE_1
ATTRIBUTE_2
INTEREST_1
INTEREST_2
STUDENT_TYPE
MAJOR
DEPT
COLLEGE
DEGREE
CIP
PROGRAM
OVERALL_LEVEL
RECENT_LETTER_TYPE
RECENT_LETTER_ORDER_DATE
RECENT_LETTER_SENT_DATE




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                     Page 132 of 227                                    4/21/2012
                                                          Banner Reporting Warehouse Documentation
                                                                                   Data                                              For AAA
Data Name                              Data Description            Data Format    Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                           Page 133 of 227                                    4/21/2012
                                                          Banner Reporting Warehouse Documentation
                                                                                   Data                                              For AAA
Data Name                              Data Description            Data Format    Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                           Page 134 of 227                                    4/21/2012
                                                          Banner Reporting Warehouse Documentation
                                                                                   Data                                              For AAA
Data Name                              Data Description            Data Format    Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                           Page 135 of 227                                    4/21/2012
                                                          Banner Reporting Warehouse Documentation
                                                                                   Data                                              For AAA
Data Name                              Data Description            Data Format    Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                           Page 136 of 227                                    4/21/2012
                                                          Banner Reporting Warehouse Documentation
                                                                                   Data                                              For AAA
Data Name                              Data Description            Data Format    Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                           Page 137 of 227                                    4/21/2012
                                                                 Banner Reporting Warehouse Documentation
Table Name                         Table Description
FACCEPTED                          Accepted student fact table
                                                                                         Data                                                  For AAA
Data Name               Data Description                                  Data Format   Length Data Source   Data Transformation               Reports
APPLIED_STATUS_CODE
APPLIED_STATUS_DATE
ADMIT_TYPE
PIDM
TERM_CODE
APPLIED_NUMBER
APPLIED_NUMBER_DATE
CAMPUS
APPLIED_RESIDENCY
CURRENT_DECISION_CODE
DECISION_DATE
APPLICATION_SOURCE
ATTRIBUTE_1
ATTRIBUTE_2
INTEREST_1
INTEREST_2
STUDENT_TYPE
MAJOR
DEPT
COLLEGE
DEGREE
CIP
PROGRAM
OVERALL_LEVEL
RECENT_LETTER_TYPE
RECENT_LETTER_ORDER_DATE
RECENT_LETTER_SENT_DATE




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 138 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 139 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 140 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 141 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 142 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 143 of 227                                   4/21/2012
                                                                   Banner Reporting Warehouse Documentation
Table Name                          Table Description
FRECRUITS                           Recruited student fact table
                                                                                          Data                                              For AAA
Data Name                           Data Description                       Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                   Page 144 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 145 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 146 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 147 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 148 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 149 of 227                                   4/21/2012
                                                                           Banner Reporting Warehouse Documentation
Table Name                          Table Description
FFINAID                             Financial aid fact table
                                                                                                  Data                                              For AAA
Data Name                           Data Description                               Data Format   Length Data Source   Data Transformation           Reports
TERM_CODE
YEAR
PIDM
FUND_CODE
OFFERED_AMOUNT
ACCEPTED_AMOUNT
ACCEPT_STATUS
PAID_AMOUNT
DURATION                            Number of terms for which aid is applicable
REASON_CODE
LETTER_CODE
LETTER_DATE
UTILIZED_TERMS??




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                           Page 150 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 151 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 152 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 153 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 154 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 155 of 227                                   4/21/2012
                                                               Banner Reporting Warehouse Documentation
Table Name                          Table Description
FSTDHOLD                            Student holds fact table

                                                                                      Data                                                  For AAA
Data Name                           Data Description                   Data Format   Length Data Source   Data Transformation               Reports
HOLD_CODE
HOLD_START_DATE
HOLD_END_DATE
HOLD_DESCRIPTION
HOLD_ORIGINATOR
HOLD_USERNAME
HOLD_COMMENTS




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                               Page 156 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 157 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 158 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 159 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 160 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation

                                                                              Data                                                  For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation               Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 161 of 227                                   4/21/2012
                                                         Banner Reporting Warehouse Documentation
Table Name                         Table Description
FCOMMENTS                          Comments fact table
                                                                                Data                                              For AAA
Data Name                          Data Description              Data Format   Length Data Source   Data Transformation           Reports
ORIGINATOR_CODE
COMMENT
COMMENT_MODULE




      3330c609-54f7-436e-8afc-fc4aa63f853a.xls                          Page 162 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 163 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 164 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 165 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 166 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 167 of 227                                   4/21/2012
                                                            Banner Reporting Warehouse Documentation
Table Name                          Table Description
FGRAD                               Graduation fact table
                                                                                   Data                                              For AAA
Data Name              Data Description                             Data Format   Length Data Source   Data Transformation           Reports
TERM
PIDM
DEGREE
MAJOR
MAJOR2
MINOR
MINOR2
EMPHASIS
EMPHASIS2
DEGREE_DATE
DEGREE_GPA
COLLEGE
DEPARTMENT
CIP
OWNER
PLAN_TYPE
CERTIFICATE1
CERTIFICATE2
CERTIFICATE3
COMPLETION_DATE
DEGREE_CHECKOUT_STATUS
COMMENCEMENT_RSVP
LATIN_HONORS
USU_CLASS_RANK
USU_CLASS_SIZE
COLLEGE_CLASS_RANK
COLLEGE_CLASS_SIZE




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                            Page 168 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 169 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 170 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 171 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 172 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 173 of 227                                   4/21/2012
                                                                  Banner Reporting Warehouse Documentation
Table Name                          Table Description
FACADHIST                           Academic history fact table

                                                                                          Data                                                  For AAA
Data Name                           Data Description                       Data Format   Length Data Source   Data Transformation               Reports
TERM
PIDM
GRADE
EARNED_CREDIT
REPEATS
GRADE_TYPE
CRN




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                  Page 174 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation

                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 175 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation

                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 176 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation

                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 177 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation

                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 178 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation

                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 179 of 227                                   4/21/2012
                                                                     Banner Reporting Warehouse Documentation
Table Name                          Table Description
FACCTREC                            Accounts receivable fact table
                                                                                             Data                                                  For AAA
Data Name                           Data Description                          Data Format   Length Data Source   Data Transformation               Reports
TERM_CODE
PIDM
TRANSACTION_DATE
DETAIL_CODE
AMOUNT
TRANSACTION_USER




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                     Page 180 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 181 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 182 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 183 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 184 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 185 of 227                                   4/21/2012
                                                         Banner Reporting Warehouse Documentation
Table Name                          Table Description
FLETTERS                            Letters fact table
                                                                                 Data                                                  For AAA
Data Name                           Data Description              Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 186 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 187 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 188 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 189 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 190 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 191 of 227                                   4/21/2012
                                                             Banner Reporting Warehouse Documentation
Table Name                          Table Description
FPOPS                               Populations fact table
                                                                                    Data                                              For AAA
Data Name                           Data Description                 Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                             Page 192 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 193 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 194 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 195 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 196 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                              Data                                              For AAA
Data Name                           Data Description           Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 197 of 227                                   4/21/2012
                                                                    Banner Reporting Warehouse Documentation
Table Name                           Table Description
FCRSATTR                             Course attributes fact table

                                                                                            Data                                              For AAA
Data Name                            Data Description                        Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                     Page 198 of 227                                   4/21/2012
                                                        Banner Reporting Warehouse Documentation

                                                                                Data                                              For AAA
Data Name                            Data Description            Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 199 of 227                                   4/21/2012
                                                        Banner Reporting Warehouse Documentation

                                                                                Data                                              For AAA
Data Name                            Data Description            Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 200 of 227                                   4/21/2012
                                                        Banner Reporting Warehouse Documentation

                                                                                Data                                              For AAA
Data Name                            Data Description            Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 201 of 227                                   4/21/2012
                                                        Banner Reporting Warehouse Documentation

                                                                                Data                                              For AAA
Data Name                            Data Description            Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 202 of 227                                   4/21/2012
                                                        Banner Reporting Warehouse Documentation

                                                                                Data                                              For AAA
Data Name                            Data Description            Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 203 of 227                                   4/21/2012
                                                                    Banner Reporting Warehouse Documentation
Table Name                          Table Description
FSTDATTR                            Student attributes fact table
                                                                                            Data                                                  For AAA
Data Name                           Data Description                         Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                    Page 204 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 205 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 206 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 207 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 208 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 209 of 227                                   4/21/2012
                                                         Banner Reporting Warehouse Documentation
Table Name                          Table Description
FREPEATS                            Repeats fact table
                                                                                 Data                                                  For AAA
Data Name                           Data Description              Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 210 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 211 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 212 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 213 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 214 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 215 of 227                                   4/21/2012
                                                                   Banner Reporting Warehouse Documentation
Table Name                          Table Description
FACADSTND                           Academic standing fact table
                                                                                           Data                                                  For AAA
Data Name                           Data Description                        Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                   Page 216 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 217 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 218 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 219 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 220 of 227                                   4/21/2012
                                                       Banner Reporting Warehouse Documentation
                                                                               Data                                                  For AAA
Data Name                           Data Description            Data Format   Length Data Source   Data Transformation               Reports




        3330c609-54f7-436e-8afc-fc4aa63f853a.xls                       Page 221 of 227                                   4/21/2012
                                                                    Banner Reporting Warehouse Documentation
Table Name                          Table Description
FTRANSSUM                           Transcript summary fact table
                                                                                            Data                                              For AAA
Data Name              Data Description                                      Data Format   Length Data Source   Data Transformation           Reports
DEPT/MAJOR_GPA
EARNED_CREDITS
OVERALL_GPA
COLLEGE_GPA
PIDM
USU_GPA
ATTEMPTED_CREDITS
GRADUATE/UNDERGRADUATE
TERM_GPA
TERM_CODE




      3330c609-54f7-436e-8afc-fc4aa63f853a.xls                                      Page 222 of 227                                   4/21/2012
                                                        Banner Reporting Warehouse Documentation
                                                                                Data                                              For AAA
Data Name                            Data Description            Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 223 of 227                                   4/21/2012
                                                        Banner Reporting Warehouse Documentation
                                                                                Data                                              For AAA
Data Name                            Data Description            Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 224 of 227                                   4/21/2012
                                                        Banner Reporting Warehouse Documentation
                                                                                Data                                              For AAA
Data Name                            Data Description            Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 225 of 227                                   4/21/2012
                                                        Banner Reporting Warehouse Documentation
                                                                                Data                                              For AAA
Data Name                            Data Description            Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 226 of 227                                   4/21/2012
                                                        Banner Reporting Warehouse Documentation
                                                                                Data                                              For AAA
Data Name                            Data Description            Data Format   Length Data Source   Data Transformation           Reports




       3330c609-54f7-436e-8afc-fc4aa63f853a.xls                         Page 227 of 227                                   4/21/2012

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:4/21/2012
language:
pages:227