Data Dictionary Keyword Search
120 matching records found for
:
Table: ACAD_CALTRM_TBL - Academic Calendar Term Table Description Fields ACAD_CAREER , STRM , DEGR_CONFER_DT , CENSUS_DT , LST_CANCEL_DT , LST_WD_W_PEN_DT , more table detail..
Table: ACAD_DEGR - Student Degree Table Description Fields EMPLID , STDNT_DEGR , DEGREE , ACAD_CAREER , COMPLETION_TERM , DEGR_CONFER_DT , more table detail..
Table: ACAD_DEGR_HONS - Student Degree Honors Table Description Fields EMPLID , STDNT_DEGR , HONORS_CODE , more table detail..
Table: ACAD_DEGR_PLAN - Student Degree Plan Table Description Fields EMPLID , STDNT_DEGR , ACAD_PLAN , ACAD_CAREER , STDNT_CAR_NBR , more table detail..
Table: ACAD_DEGR_SPLN - Student Degree Sub-Plan Table Description Fields EMPLID , STDNT_DEGR , ACAD_PLAN , ACAD_SUB_PLAN , more table detail..
Table: ACAD_GROUP_TBL - Academic Group Table Description Fields ACAD_GROUP , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , more table detail..
Table: ACAD_ORG_TBL - Academic Organization Table Description Fields ACAD_ORG , EFFDT , EFF_STATUS , DESCR , DESCRFORMAL , more table detail..
Table: ACAD_PLAN - Student Academic Plan Table Description Fields EMPLID , ACAD_CAREER , STDNT_CAR_NBR , EFFDT , EFFSEQ , ACAD_PLAN , DECLARE_DT , PLAN_SEQUENCE , REQ_TERM , COMPLETION_TERM , more table detail..
Table: ACAD_PLAN_OWNER - Academic Plan Owner Table Description Fields ACAD_PLAN , EFFDT , ACAD_ORG , more table detail..
Table: ACAD_PLAN_TBL - Academic Plan Table Description Fields ACAD_PLAN , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , DIPLOMA_DESCR , TRNSCR_DESCR , ACAD_PLAN_TYPE , ACAD_PROG , ACAD_CAREER , DEGREE , CIP_CODE , STUDY_FIELD , more table detail..
Table: ACAD_PROG - Student Academic Program Description Fields EMPLID , ACAD_CAREER , STDNT_CAR_NBR , EFFDT , EFFSEQ , ACAD_PROG , PROG_STATUS , PROG_ACTION , ACTION_DT , PROG_REASON , ADMIT_TERM , EXP_GRAD_TERM , REQ_TERM , COMPLETION_TERM , more table detail..
Table: ACAD_PROG_TBL - Academic Program Table Description Fields ACAD_PROG , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , ACAD_CAREER , LEVEL_LOAD_RULE , ACAD_GROUP , CIP_CODE , ACAD_ORG , more table detail..
Table: ACAD_STDNG_ACTN - Academic Standing Action Description Fields EMPLID , ACAD_CAREER , STRM , EFFDT , ACAD_STNDNG_ACTN , ACAD_STNDNG_STAT , more table detail..
Table: ACAD_SUBPLAN - Student Academic Subplan Table Description Fields EMPLID , ACAD_CAREER , STDNT_CAR_NBR , EFFDT , EFFSEQ , ACAD_PLAN , ACAD_SUB_PLAN , more table detail..
Table: ACAD_SUBPLN_TBL - Academic Sub Plan Table Description Fields ACAD_PLAN , ACAD_SUB_PLAN , EFFDT , EFF_STATUS , ACAD_SUBPLAN_TYPE , DESCR , more table detail..
Table: ACCOUNT_SF - Account (Student Financials) Description Fields EMPLID , ACCOUNT_NBR , ACCOUNT_TERM , ACCOUNT_TYPE_SF , ACCOUNT_BALANCE , more table detail..
Table: ADDRESSES - Address Type Description Fields EMPLID , ADDRESS_TYPE , EFFDT , EFF_STATUS , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , STATE , POSTAL , COUNTRY , COUNTY , more table detail..
Table: ADDRESSES4_VW - Addresses View for Curr EffDT Description Fields EMPLID , ADDRESS_TYPE , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , COUNTRY , POSTAL , STATE , more table detail..
Table: ADM_INTERESTS - Admission Interests Description Fields EMPLID , ACAD_CAREER , EFFDT , EXT_SUBJECT_AREA , PRIORITY , more table detail..
Table: ADM_MC_VW - Adm Appl Prog Vw for MC Description Fields EMPLID , ACAD_CAREER , STDNT_CAR_NBR , EFFDT , EFFSEQ , ACAD_PROG , PROG_ACTION , PROG_REASON , PROG_STATUS , ADMIT_TERM , ADMIT_TYPE , LAST_SCH_ATTEND , ADM_APPL_CTR , ACTION_DT , ADM_APPL_COMPLETE , ADM_APPL_CMPLT_DT , ADM_APPL_DT , more table detail..
Table: BLDG_TBL - Building Table Description Fields BLDG_CD , EFFDT , DESCR , more table detail..
Table: CITIZEN_STS_TBL - Citizen Status Table Description Fields COUNTRY , CITIZENSHIP_STATUS , DESCR , more table detail..
Table: CLASS_ATTRIBUTE - Class Attribute Table Description Fields CRSE_ID , CRSE_OFFER_NBR , STRM , SESSION_CODE , CLASS_SECTION , CRSE_ATTR , CRSE_ATTR_VALUE , more table detail..
Table: CLASS_INSTR - Class Instructor Table Description Fields CRSE_ID , CRSE_OFFER_NBR , STRM , SESSION_CODE , CLASS_SECTION , CLASS_MTG_NBR , INSTR_ASSIGN_SEQ , EMPLID , INSTR_ROLE , GRADE_RSTR_ACCESS , more table detail..
Table: CLASS_MTG_PAT - Class Meeting Pattern Table Description Fields CRSE_ID , CRSE_OFFER_NBR , STRM , SESSION_CODE , CLASS_SECTION , CLASS_MTG_NBR , FACILITY_ID , MEETING_TIME_START , MEETING_TIME_END , MON , TUES , WED , THURS , FRI , SAT , SUN , START_DT , END_DT , STND_MTG_PAT , more table detail..
Table: CLASS_TBL - Class Table Description Fields CRSE_ID , STRM , SESSION_CODE , CLASS_SECTION , ACAD_GROUP , SUBJECT , CATALOG_NBR , ACAD_CAREER , DESCR , CLASS_NBR , SSR_COMPONENT , ENRL_STAT , CLASS_STAT , CLASS_TYPE , ENRL_CAP , WAIT_CAP , MIN_ENRL , ENRL_TOT , WAIT_TOT , ACAD_ORG , LOCATION , END_DT , START_DT , COMBINED_SECTION , more table detail..
Table: COUNTRY_TBL - Countries Description Fields COUNTRY , DESCR , more table detail..
Table: CRSE_ATTR_TBL - Course Print Attribute Table Description Fields CRSE_ATTR , EFFDT , DESCR , more table detail..
Table: CRSE_ATTR_VALUE - Course Attribute Value Tbl Description Fields CRSE_ATTR , EFFDT , CRSE_ATTR_VALUE , DESCR , DESCRFORMAL , more table detail..
Table: CRSE_ATTRIBUTES - Course Attribute Tbl Description Fields CRSE_ID , EFFDT , CRSE_ATTR , CRSE_ATTR_VALUE , more table detail..
Table: CRSE_CATALOG - Course Catalog Data Description Fields CRSE_ID , EFFDT , EFF_STATUS , DESCR , UNITS_MINIMUM , UNITS_MAXIMUM , CRSE_REPEATABLE , COURSE_TITLE_LONG , DESCRLONG , more table detail..
Table: CRSE_OFFER - Course Catalog Offerings Description Fields CRSE_ID , EFFDT , CRSE_OFFER_NBR , ACAD_GROUP , SUBJECT , CATALOG_NBR , ACAD_ORG , ACAD_CAREER , more table detail..
Table: DEGR_HONORS_TBL - Degree Honors Table Description Fields HONORS_CODE , EFFDT , DESCR , DESCRFORMAL , more table detail..
Table: DEGREE_TBL - Education Degree Table Description Fields DEGREE , EFFDT , EFF_STATUS , DESCRSHORT , DESCR , DESCRFORMAL , EDUCATION_LVL , more table detail..
Table: ENRL_REQ_DETAIL - Enrollment Request Detail Line Description Fields ENRL_REQUEST_ID , ENRL_REQ_DETL_SEQ , EMPLID , ACAD_CAREER , STRM , CLASS_NBR , ENRL_REQ_ACTION , ENRL_ACTION_REASON , CLASS_NBR_CHG_TO , ENRL_REQ_DETL_STAT , OPRID , DTTM_STAMP_SEC , more table detail..
Table: ETHNIC_GRP_TBL - Ethnic Group Table Description Fields ETHNIC_GRP_CD , DESCR50 , DESCRSHORT , more table detail..
Table: EXT_ACAD_DATA - External Academic Data Description Fields EMPLID , EXT_ORG_ID , EXT_CAREER , EXT_DATA_NBR , RECEIVED_DT , more table detail..
Table: EXT_ACAD_SUM - External Academic Summary Description Fields EMPLID , EXT_ORG_ID , EXT_SUMM_TYPE , CLASS_RANK , CLASS_SIZE , EXT_GPA , CONVERT_GPA , PERCENTILE , more table detail..
Table: EXT_COURSE - External Courses Description Fields EMPLID , EXT_ORG_ID , UNT_TAKEN , CRSE_GRADE_OFF , SCHOOL_SUBJECT , SCHOOL_CRSE_NBR , EXT_TERM , TERM_YEAR , DESCR , more table detail..
Table: EXT_ORG_SCHL_VW - External Organization Schl VW Description Fields EXT_ORG_ID , EFFDT , LS_SCHOOL_TYPE , DESCR , CITY , STATE , COUNTRY , more table detail..
Table: EXT_ORG_TBL - External Organization Table Description Fields EXT_ORG_ID , EFFDT , EFF_STATUS , EXT_ORG_TYPE , PROPRIETORSHIP , DESCR50 , more table detail..
Table: EXT_ORG_TBL_ADM - External Org Admissions Description Fields EXT_ORG_ID , EFFDT , LS_SCHOOL_TYPE , ATP_CD , more table detail..
Table: EXT_SUBJECT_TBL - External Subject Table Description Fields EXT_SUBJECT_AREA , EFFDT , DESCR , more table detail..
Table: FACILITY_TBL - Facility Table Description Fields FACILITY_ID , EFFDT , EFF_STATUS , BLDG_CD , ROOM , DESCR , LOCATION , ROOM_CAPACITY , more table detail..
Table: GRADE_ROSTER - Grade Roster Description Fields STRM , CLASS_NBR , GRD_RSTR_TYPE_SEQ , EMPLID , ACAD_CAREER , CRSE_GRADE_INPUT , GRADE_ROSTER_STAT , more table detail..
Table: GRADE_RSTR_TYPE - Grade Roster Type Description Fields STRM , CLASS_NBR , GRD_RSTR_TYPE_SEQ , GRADE_ROSTER_TYPE , GRADING_STATUS , POSTING_DATE , PARTIAL_POST , more table detail..
Table: INSTR_ADVISOR - Instructor/Advisor table Description Fields EMPLID , EFFDT , EFF_STATUS , ACAD_ORG , INSTR_TYPE , more table detail..
Table: ISIR_CONTROL - ISIR Internals/Control Data Description Fields EMPLID , AID_YEAR , EFFDT , PELL_ELIGIBILITY , EFC_STATUS , more table detail..
Table: ISIR_PARENT - Fed Parent Application Data Description Fields EMPLID , AID_YEAR , EFFDT , NUMBER_IN_FAMILY , NUM_IN_COLLEGE , AGI , more table detail..
Table: ISIR_STUDENT - Fed Student Application Data Description Fields EMPLID , AID_YEAR , EFFDT , AGI , DEPNDNCY_STAT , more table detail..
Table: ITEM_LINE_SF - Item Line Description Fields EMPLID , COMMON_ID , ITEM_NBR , ACCOUNT_NBR , ACCOUNT_TERM , POSTED_DATE , REF1_DESCR , LINE_AMT , ACAD_CAREER , ITEM_TERM , POSTED_DATETIME , OPRID , DESCR , ITEM_TYPE_CD , more table detail..
Table: ITEM_LNDDT_VW - Item Line Due Date (SF) View Description Fields EMPLID , ACCOUNT_NBR , ACCOUNT_TERM , ITEM_TERM , DESCR , ITEM_AMT , ITEM_TYPE , POSTED_DATETIME , POSTED_DATE , more table detail..
Table: ITEM_SF - Item Record Description Fields EMPLID , COMMON_ID , ITEM_NBR , ACCOUNT_NBR , ACCOUNT_TERM , ACAD_YEAR , ITEM_TYPE , ITEM_AMT , ACCOUNT_TYPE_SF , REF1_DESCR , more table detail..
Table: ITEM_TYPE_FA - FA Item Type Table Description Fields ITEM_TYPE , AID_YEAR , EFFDT , DESCR , FA_SOURCE , FEDERAL_ID , FIN_AID_TYPE , REPORT_CODE , more table detail..
Table: ITEM_TYPE_TBL - Item Type Table Description Fields ITEM_TYPE , EFFDT , DESCR , ITEM_TYPE_CD , KEYWORD1 , KEYWORD2 , KEYWORD3 , more table detail..
Table: PROG_ACTION_TBL - Program Action Table Description Fields PROG_ACTION , EFFDT , DESCR , more table detail..
Table: PROG_RSN_TBL - Program Action Reason Table Description Fields PROG_ACTION , PROG_REASON , EFFDT , DESCR , more table detail..
Table: REL_PREF_TBL - Religious Preference Table Description Fields RELIGIOUS_PREF , EFFDT , EFF_STATUS , DESCR , more table detail..
Table: RELATIONSHIPS - Relationships Description Fields EMPLID , EFFDT , EFF_STATUS , PEOPLE_RELATION , EMPLID_RELATED , more table detail..
Table: RELIGIOUS_PREF - Religious Preference Description Fields EMPLID , RELIGIOUS_PREF , more table detail..
Table: SCC_CITIZEN_QVW - Citizenship Query View Description Fields EMPLID , COUNTRY , CITIZENSHIP_STATUS , more table detail..
Table: SCC_DIV_ETH_QVW - Ethnic Diversity Query View Description Fields EMPLID , ETHNIC_GRP_CD , more table detail..
Table: SCC_EMAIL_QVW - Email Addresses Query View Description Fields EMPLID , E_ADDR_TYPE , EMAIL_ADDR , PREF_EMAIL_FLAG , more table detail..
Table: SCC_EMERG_C_QVW - Emergency Contacts Query View Description Fields EMPLID , CONTACT_NAME , PRIMARY_CONTACT , RELATIONSHIP , SAME_ADDRESS_EMPL , ADDRESS_TYPE , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , STATE , POSTAL , SAME_PHONE_EMPL , PHONE_TYPE , PHONE , more table detail..
Table: SCC_EMERG_P_QVW - Emergency Cntct-Phone Quer Vw Description Fields EMPLID , CONTACT_NAME , PHONE , more table detail..
Table: SCC_NAMES_QVW - Person Names Query View Description Fields EMPLID , NAME_TYPE , EFFDT , EFF_STATUS , NAME , LAST_NAME , FIRST_NAME , MIDDLE_NAME , NAME_PREFIX , NAME_SUFFIX , more table detail..
Table: SCC_PER_EFF_QVW - Eff Dated Person Data Query Vw Description Fields EMPLID , EFFDT , MAR_STATUS , MAR_STATUS_DT , SEX , more table detail..
Table: SCC_PERS_NI_QVW - Person National ID Query View Description Fields EMPLID , COUNTRY , NATIONAL_ID , more table detail..
Table: SCC_PERS_PH_QVW - Phone Numbers Query View Description Fields EMPLID , PHONE_TYPE , COUNTRY_CODE , PHONE , PREF_PHONE_FLAG , more table detail..
Table: SCC_PERS_SA_VW - PERSON record Description Fields EMPLID , BIRTHDATE , more table detail..
Table: SCC_VISA_P_QVW - Visa Data Query View Description Fields EMPLID , EFFDT , COUNTRY , VISA_PERMIT_TYPE , VISA_WRKPMT_NBR , VISA_WRKPMT_STATUS , more table detail..
Table: SERVICE_IMPACT - Service Impact Description Fields SRVC_IND_CD , EFFDT , SERVICE_IMPACT , more table detail..
Table: SRVC_IMPACT_TBL - Service Impact Table Description Fields SERVICE_IMPACT , EFFDT , DESCR , more table detail..
Table: SRVC_IN_RSN_TBL - Service Indicator Reason Description Fields SRVC_IND_CD , EFFDT , SRVC_IND_REASON , DESCR , DESCRLONG , DEPTID , more table detail..
Table: SRVC_IND_CD_TBL - Service Indicator Code Table Description Fields SRVC_IND_CD , EFFDT , DESCR , POS_SRVC_INDICATOR , more table detail..
Table: SRVC_IND_DATA - Service Indicator Data Description Fields EMPLID , SRVC_IND_DTTM , SRVC_IND_CD , SRVC_IND_REASON , OPRID , SRVC_IND_ACT_TERM , POS_SRVC_INDICATOR , DEPTID , AMOUNT , COMM_COMMENTS , more table detail..
Table: STATE_TBL - States Description Fields COUNTRY , STATE , DESCR , more table detail..
Table: STDNT_ADVR_HIST - Student Advisor History Description Fields EMPLID , EFFDT , ACAD_CAREER , ACAD_PROG , ADVISOR_ID , more table detail..
Table: STDNT_AWARDS - Student Awards Description Fields EMPLID , AID_YEAR , ITEM_TYPE , ACAD_CAREER , AWARD_STATUS , OFFER_AMOUNT , ACCEPT_AMOUNT , DISBURSED_AMOUNT , FIN_AID_TYPE , DISBURSEMENT_PLAN , SPLIT_CODE , more table detail..
Table: STDNT_AWRD_DISB - Student Award Disbursements Description Fields EMPLID , AID_YEAR , STRM , ACAD_CAREER , ITEM_TYPE , OFFER_BALANCE , ACCEPT_BALANCE , DISBURSED_BALANCE , DISBURSEMENT_ID , more table detail..
Table: STDNT_CAR_TERM - Student Career Term Table Description Fields EMPLID , ACAD_CAREER , STRM , REG_CARD_DATE , WITHDRAW_CODE , WITHDRAW_REASON , WITHDRAW_DATE , STDNT_CAR_NBR , ACAD_PROG_PRIMARY , ACADEMIC_LOAD , ACAD_LEVEL_BOT , ACAD_LEVEL_EOT , ACAD_YEAR , FULLY_ENRL_DT , FULLY_GRADED_DT , ELIG_TO_ENROLL , UNT_TAKEN_PRGRSS , UNT_PASSD_PRGRSS , UNT_TAKEN_GPA , UNT_PASSD_GPA , UNT_TAKEN_NOGPA , UNT_PASSD_NOGPA , UNT_INPROG_GPA , UNT_INPROG_NOGPA , GRADE_POINTS , TOT_TAKEN_PRGRSS , TOT_PASSD_PRGRSS , TOT_TAKEN_GPA , TOT_PASSD_GPA , TOT_TAKEN_NOGPA , TOT_PASSD_NOGPA , TOT_INPROG_GPA , TOT_INPROG_NOGPA , TOT_TRNSFR , TOT_TEST_CREDIT , TOT_OTHER , TOT_CUMULATIVE , TOT_GRADE_POINTS , CUR_GPA , CUM_GPA , REGISTERED , more table detail..
Table: STDNT_CAREER - Student Career Description Fields EMPLID , ACAD_CAREER , CAR_REQ_TERM , more table detail..
Table: STDNT_ENRL - Student Enrollment Table Description Fields EMPLID , ACAD_CAREER , STRM , CLASS_NBR , CRSE_CAREER , SESSION_CODE , STDNT_ENRL_STATUS , ENRL_STATUS_REASON , ENRL_ADD_DT , ENRL_DROP_DT , UNT_TAKEN , UNT_PRGRSS , GRADING_BASIS_ENRL , CRSE_GRADE_OFF , REPEAT_CODE , EARN_CREDIT , INCLUDE_IN_GPA , GRADE_POINTS , RQMNT_DESIGNTN , more table detail..
Table: STDNT_GROUP_TBL - Student Group TBL Description Fields STDNT_GROUP , EFFDT , EFF_STATUS , DESCR , more table detail..
Table: STDNT_GRPS_HIST - Student Group History Description Fields EMPLID , STDNT_GROUP , EFFDT , EFF_STATUS , more table detail..
Table: STDNT_TEST_COMP - Student Test Components Description Fields EMPLID , TEST_ID , TEST_COMPONENT , TEST_DT , SCORE , more table detail..
Table: STUDY_FIELD_TBL - Field of Study Table Description Fields STUDY_FIELD , EFFDT , DESCR , DESCRFORMAL , more table detail..
Table: TERM_TBL - Term Definition Table Description Fields ACAD_CAREER , STRM , DESCR , ACAD_YEAR , TERM_BEGIN_DT , TERM_END_DT , TERM_CATEGORY , more table detail..
Table: TRNS_CRSE_DTL - Student Transfer Course Detail Description Fields EMPLID , ACAD_CAREER , MODEL_NBR , ARTICULATION_TERM , EXT_COURSE_NBR , TERM_YEAR , EXT_TERM , UNT_TAKEN , CRSE_ID , CRSE_GRADE_OFF , GRD_PTS_PER_UNIT , EARN_CREDIT , INCLUDE_IN_GPA , more table detail..
Table: TRNS_CRSE_SCH - Student Transfer Credit School Description Fields EMPLID , ACAD_CAREER , MODEL_NBR , EXT_ORG_ID , more table detail..
Table: TRNS_TEST_DTL - Student Transfer Test Detail Description Fields EMPLID , ACAD_CAREER , ARTICULATION_TERM , TEST_ID , TEST_COMPONENT , TEST_DT , SCORE , CRSE_ID , UNT_TRNSFR , CRSE_GRADE_OFF , EARN_CREDIT , more table detail..
Table: U_AD_SLATE_DATA - SLATE Data Dump Table Description Fields EMPLID , ADM_APPL_NBR , PROG_ACTION , PROG_REASON , ACTION_DATE , U_AD_ADMT_RLEASEDT , DEPOSIT_DATE , RECRUITER_NAME , MAJOR_NAME , MAJOR_NAME_2ND , U_AD_SAT_SR_V , U_AD_SAT_V , U_AD_ACT_SR_V , U_AD_ACT_V , HS_GRAD_DT , CONVERT_GPA , RATING_CMP_VALUE5 , RATING_VALUE , more table detail..
Table: U_CC_PDATA_TBL - 8.9 Refresh PRDATA Table Description Fields EMPLID , NAME , NAME_PREFIX , LAST_NAME , FIRST_NAME , MIDDLE_NAME , NAME_SUFFIX , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , STATE , POSTAL , COUNTRY , COUNTY , ADDRESS1_OTHER , ADDRESS2_OTHER , ADDRESS3_OTHER , ADDRESS4_OTHER , CITY_OTHER , STATE_OTHER , POSTAL_OTHER , COUNTRY_OTHER , COUNTY_OTHER , PHONE , PHONE1 , SEX , RELIGIOUS_PREF , EMAIL_ADDR , AGE , U_CC_ETHNIC_REPORT , U_CC_USA_CIT_STATS , U_CC_CNTRY_OF_CITZ , FERPA , DT_OF_DEATH , MAR_STATUS , more table detail..
Table: U_SA_ACTCMAX_VW - AD - ACT Max Comp score Description Fields EMPLID , COMPMAX , more table detail..
Table: U_SA_ACTEMAX_VW - AD - ACT Max Eng score Description Fields EMPLID , VERBMAX , more table detail..
Table: U_SA_ACTMMAX_VW - AD - ACT Max Math score Description Fields EMPLID , MATHMAX , more table detail..
Table: U_SA_ACTRMAX_VW - AD - ACT Max READ score Description Fields EMPLID , READMAX , more table detail..
Table: U_SA_AUTH_ACCT - Auth Accounts - Self-Service Description Fields OPRID , EMPLID , U_SA_AUTH_AREA , more table detail..
Table: U_SA_AUTH_AREA - Auth Accounts - Self-Service Description Fields U_SA_AUTH_AREA , EFFDT , DESCR , more table detail..
Table: U_SA_AUTH_GRANT - Auth Accounts - Self-Service Description Fields EMPLID , DTTM_STAMP_SEC , U_SA_AUTH_ID , U_SA_AUTH_AREA , U_SA_AUTH_ACTN , more table detail..
Table: U_SA_SATMMAX_VW - AD - SAT Max Math score Description Fields EMPLID , MATHMAX , more table detail..
Table: U_SA_SATVMAX_VW - AD - SAT Max Verb score Description Fields EMPLID , VERBMAX , more table detail..
Table: U_SA_SATWMAX_VW - AD - SAT Max WRIT score Description Fields EMPLID , WRITMAX , more table detail..
Table: U_SA_TOEFMAX_VW - AD - TOEFL Max COMPI score Description Fields EMPLID , U_AD_TOEFLMAX , more table detail..
Table: U_SL_OR_ARO_SES - SL - OR Setup Description Fields STRM , U_SL_OR_SESSION_CD , SESSIONIDNUM , DESCR , FROMDATE , THRUDATE , FROM_DATE , TO_DATE , U_SL_OR_SPACE_TOT , more table detail..
Table: U_SL_OR_STD_ARO - Student ARRO Registration Description Fields EMPLID , STRM , U_SL_OR_SESSION_CD , PREFERRED_NAME , U_SL_ADV_GROUP , ADVISOR_ID , more table detail..
Table: U_SL_OR_STD_CAN - OR/MC Student Cancellation Description Fields EMPLID , STRM , U_SL_OR_SESSION_CD , SESSIONIDNUM , CANCEL , CANCEL_FLAG , more table detail..
Table: U_SL_OR_STD_GST - Student Guest Regis Description Fields EMPLID , STRM , U_SL_OR_SESSION_CD , SESSIONIDNUM , LAST_NAME , FIRST_NAME , more table detail..
Table: U_SR_ACADPG_TBL - Acad Prog Rpt Values Description Fields ACAD_PROG , EFFDT , U_SR_RPT_CAREER , U_SR_RPT_DEG , U_SR_RPT_PROG , U_SR_RPT_CREDIT , U_SR_RPT_A_CAR , U_SR_RPT_A_PROG , U_SR_RPT_IPEDS , more table detail..
Table: U_SR_CARTERM_VW - Student Career Term Table Description Fields EMPLID , ACAD_CAREER , STRM , REG_CARD_DATE , WITHDRAW_CODE , WITHDRAW_REASON , WITHDRAW_DATE , STDNT_CAR_NBR , ACAD_PROG_PRIMARY , ACADEMIC_LOAD , ACAD_LEVEL_BOT , ACAD_LEVEL_EOT , ACAD_YEAR , FULLY_ENRL_DT , FULLY_GRADED_DT , ELIG_TO_ENROLL , UNT_TAKEN_PRGRSS , UNT_PASSD_PRGRSS , UNT_TAKEN_GPA , UNT_PASSD_GPA , UNT_TAKEN_NOGPA , UNT_PASSD_NOGPA , UNT_INPROG_GPA , UNT_INPROG_NOGPA , TOT_TAKEN_PRGRSS , TOT_PASSD_PRGRSS , TOT_TAKEN_GPA , TOT_PASSD_GPA , TOT_TAKEN_NOGPA , TOT_PASSD_NOGPA , TOT_INPROG_GPA , TOT_INPROG_NOGPA , TOT_TRNSFR , TOT_TEST_CREDIT , TOT_OTHER , TOT_CUMULATIVE , REGISTERED , more table detail..
Table: U_SR_CEN_CLASS - Term Class Census Data Description Fields STRM , CLASS_NBR , SUBJECT , CATALOG_NBR , CLASS_SECTION , DESCR , SESSION_CODE , ACAD_CAREER , ACAD_GROUP , CRSE_ID , SSR_COMPONENT , LOCATION , more table detail..
Table: U_SR_CEN_PROG - Student Program Census Data Description Fields EMPLID , U_SR_CAPTURE_CODE , ACAD_CAREER , STDNT_CAR_NBR , ACAD_PROG , ACAD_PLAN , PLAN_SEQUENCE , more table detail..
Table: U_SR_CENCAP_TBL - SR Census Capture Setup Record Description Fields STRM , U_SR_CAPTURE_CODE , U_SR_CAPTURE_TYPE , U_SR_CAPTURE_DATE , DESCR , more table detail..
Table: U_SR_CENSUS_CLS - SR Census Data Capture - Class Description Fields EMPLID , ACAD_CAREER , STRM , U_SR_CAPTURE_CODE , SESSION_CODE , CLASS_NBR , STDNT_ENRL_STATUS , ENRL_STATUS_REASON , UNT_TAKEN , more table detail..
Table: U_SR_CENSUS_TRM - SR Census Data Capture - Term Description Fields EMPLID , ACAD_CAREER , STRM , U_SR_CAPTURE_CODE , REG_CARD_DATE , WITHDRAW_CODE , WITHDRAW_DATE , ACAD_PROG_PRIMARY , ACADEMIC_LOAD , ACAD_LEVEL_BOT , UNT_TAKEN_PRGRSS , REGISTERED , SEX , RELIGIOUS_PREF , U_CC_ETHNIC_REPORT , U_CC_CNTRY_OF_CITZ , U_CC_USA_CIT_STATS , more table detail..
Table: U_SR_CENSUS_TRN - SR Census Data Capture - Trans Description Fields EMPLID , U_SR_CAPTURE_CODE , STDNT_GROUP , U_SR_TRN_HRS_GRP , U_SR_TRN_GPA_GRP , U_SR_TRN_INST_GRP , U_SR_TRN_TYPE_GRP , more table detail..
Table: U_SR_CUM_GPA - SMU Cum Transfer GPA Description Fields EMPLID , LS_GPA , GRADE_POINTS , UNT_TRNSFR , more table detail..
Table: U_SR_HONORS_TBL - Description Fields EMPLID , ACAD_CAREER , STDNT_CAR_NBR , EFFDT , DEGR_HONORS_1 , DEGR_HONORS_2 , more table detail..
Table: U_SR_TRN_CRS_VW - SMU Trnsfr Crse Detail Sum Description Fields EMPLID , ACAD_CAREER , MODEL_NBR , EXT_COURSE_NBR , EXT_ORG_ID , ARTICULATION_TERM , UNT_TAKEN , CRSE_GRADE_OFF , CRSE_ID , UNT_TRNSFR , TERM_YEAR , EXT_TERM , more table detail..
Table: XLATTABLE_VW - Translate Value View Description Fields FIELDNAME , FIELDVALUE , EFFDT , XLATLONGNAME , more table detail..
For updates, corrections or questions Email
Stephen Forrest .
