SHBDIPL SHBHEAD SHBRPTR SHRASES SHRCHRT SHRCRSR SHRDCMT SHRDGCM SHRDGDH SHRDGIH SHRDGMR SHRDRTM SHREDIS SHRGPAC SHRGRDE SHRHDR4 SHRIDEN SHRLGPA SHRNCRD SHRNCRS SHRPRGE SHRQPND SHRQPNM SHRRPEQ SHRSUMA SHRSUMS SHRTCKD SHRTCKG SHRTCKL SHRTCKN SHRTGPA SHRTRAM SHRTRCD SHRTRCE SHRTRCR SHRTRIT SHRTTRM

Model Academic History


Model Label : ERD For Banner Student Academic History Module ( SH% Tables )
Path : BANNER DEV/Student/Academic History/Academic History

List of Objects

Object Name Object Type Layer Name
SHBDIPL TABLE Table_1
SHBHEAD TABLE Table_1
SHBRPTR TABLE Table_1
SHRASES TABLE Table_1
SHRCHRT TABLE Table_1
SHRCRSR TABLE Table_1
SHRDCMT TABLE Table_1
SHRDGCM TABLE Table_1
SHRDGDH TABLE Table_1
SHRDGIH TABLE Table_1
SHRDGMR TABLE Table_1
SHRDRTM TABLE Table_1
SHREDIS TABLE Table_1
SHRGPAC TABLE Table_1
SHRGRDE TABLE Table_1
SHRHDR4 TABLE Table_1
SHRIDEN TABLE Table_1
SHRLGPA TABLE Table_1
SHRNCRD TABLE Table_1
SHRNCRS TABLE Table_1
SHRPRGE TABLE Table_1
SHRQPND TABLE Table_1
SHRQPNM TABLE Table_1
SHRRPEQ TABLE Table_1
SHRSUMA TABLE Table_1
SHRSUMS TABLE Table_1
SHRTCKD TABLE Table_1
SHRTCKG TABLE Table_1
SHRTCKL TABLE Table_1
SHRTCKN TABLE Table_1
SHRTGPA TABLE Table_1
SHRTRAM TABLE Table_1
SHRTRCD TABLE Table_1
SHRTRCE TABLE Table_1
SHRTRCR TABLE Table_1
SHRTRIT TABLE Table_1
SHRTTRM TABLE Table_1

Comments

Model View

''

Table SHBDIPL

Schema Name SATURN
Label SHBDIPL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:01:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SHBDIPL_PIDM SHBDIPL_PIDM NUMBER(8,0) No * *
SHBDIPL_DGMR_SEQ_NO SHBDIPL_DGMR_SEQ_NO NUMBER(2,0) No * *
SHBDIPL_ORDER_DATE SHBDIPL_ORDER_DATE DATE Yes
SHBDIPL_MAILED_DATE SHBDIPL_MAILED_DATE DATE Yes
SHBDIPL_PICKUP_DATE SHBDIPL_PICKUP_DATE DATE Yes
SHBDIPL_NAME SHBDIPL_NAME VARCHAR2(60) Yes
SHBDIPL_FEE_IND SHBDIPL_FEE_IND VARCHAR2(1) Yes
SHBDIPL_FEE_DATE SHBDIPL_FEE_DATE DATE Yes
SHBDIPL_DUPL_DIPLOMA SHBDIPL_DUPL_DIPLOMA VARCHAR2(1) Yes
SHBDIPL_STREET1 SHBDIPL_STREET1 VARCHAR2(30) Yes
SHBDIPL_STREET2 SHBDIPL_STREET2 VARCHAR2(30) Yes
SHBDIPL_STREET3 SHBDIPL_STREET3 VARCHAR2(30) Yes
SHBDIPL_CITY SHBDIPL_CITY VARCHAR2(20) Yes
SHBDIPL_STAT_CODE SHBDIPL_STAT_CODE VARCHAR2(3) Yes *
SHBDIPL_ZIP SHBDIPL_ZIP VARCHAR2(10) Yes
SHBDIPL_NATN_CODE SHBDIPL_NATN_CODE VARCHAR2(5) Yes *
SHBDIPL_INNM_CODE SHBDIPL_INNM_CODE VARCHAR2(10) Yes *
SHBDIPL_CERT_CODE SHBDIPL_CERT_CODE VARCHAR2(10) Yes *
SHBDIPL_TERM_CODE_CERT SHBDIPL_TERM_CODE_CERT VARCHAR2(6) Yes *
SHBDIPL_ACTIVITY_DATE SHBDIPL_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SHBDIPL_CERT_CODE STVCERT_CODE STVCERT
SHBDIPL_STAT_CODE STVSTAT_CODE STVSTAT
SHBDIPL_PIDM SHRDGMR_PIDM SHRDGMR
SHBDIPL_DGMR_SEQ_NO SHRDGMR_SEQ_NO SHRDGMR
SHBDIPL_INNM_CODE STVINNM_CODE STVINNM
SHBDIPL_TERM_CODE_CERT STVTERM_CODE STVTERM
SHBDIPL_NATN_CODE STVNATN_CODE STVNATN

Index

Index Name Index Type Column Name
PK_SHBDIPL Unique SHBDIPL_PIDM
PK_SHBDIPL Unique SHBDIPL_DGMR_SEQ_NO

Comments

Source Code Comments

Diploma Information Table

Columns Comments for SHBDIPL_PIDM (1)

Source Code Comments

Internal identification number of the student.

Columns Comments for SHBDIPL_DGMR_SEQ_NO (2)

Source Code Comments

This field identifies the degree number associated with the degree the student is seeking.

Columns Comments for SHBDIPL_ORDER_DATE (3)

Source Code Comments

Date the diploma was ordered by the student.

Columns Comments for SHBDIPL_MAILED_DATE (4)

Source Code Comments

Date the diploma was mailed to the student.

Columns Comments for SHBDIPL_PICKUP_DATE (5)

Source Code Comments

Date the diploma was picked up by the student.

Columns Comments for SHBDIPL_NAME (6)

Source Code Comments

Student name as it will appear on the diploma. Default is legal name, if none, student name.

Columns Comments for SHBDIPL_FEE_IND (7)

Source Code Comments

This field identifies whether an application fee has been assessed.

Columns Comments for SHBDIPL_FEE_DATE (8)

Source Code Comments

This field identifies the date application fee has been assessed.

Columns Comments for SHBDIPL_DUPL_DIPLOMA (9)

Source Code Comments

This field identifies whether the student has requested a duplicate diploma.

Columns Comments for SHBDIPL_STREET1 (10)

Source Code Comments

Street Address Line 1 of diploma address.

Columns Comments for SHBDIPL_STREET2 (11)

Source Code Comments

Street Address Line 2 of diploma address.

Columns Comments for SHBDIPL_STREET3 (12)

Source Code Comments

Street Address Line 3 of diploma address.

Columns Comments for SHBDIPL_CITY (13)

Source Code Comments

City of diploma address.

Columns Comments for SHBDIPL_STAT_CODE (14)

Source Code Comments

State code of diploma address.

Columns Comments for SHBDIPL_ZIP (15)

Source Code Comments

Zip of diploma address.

Columns Comments for SHBDIPL_NATN_CODE (16)

Source Code Comments

Nation code of diploma address.

Columns Comments for SHBDIPL_INNM_CODE (17)

Source Code Comments

This field contains the code of the awarding institution which is used to look up institution name.

Columns Comments for SHBDIPL_CERT_CODE (18)

Source Code Comments

This field identifies the ceremony type being held.

Columns Comments for SHBDIPL_TERM_CODE_CERT (19)

Source Code Comments

This field identifies the term for which the ceremony has been scheduled.

Columns Comments for SHBDIPL_ACTIVITY_DATE (20)

Source Code Comments

This field identifies the most current date a record was created or changed.

Table SHBHEAD

Schema Name SATURN
Label SHBHEAD
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:01:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SHBHEAD_DCMT_SEQNO SHBHEAD_DCMT_SEQNO NUMBER(8,0) No * *
SHBHEAD_DCMT_SEQNO SHBHEAD_DCMT_SEQNO NUMBER(8,0) No * *
SHBHEAD_ID_DATE_KEY SHBHEAD_ID_DATE_KEY NUMBER(6,0) No
SHBHEAD_ID_DOC_KEY SHBHEAD_ID_DOC_KEY NUMBER(3,0) No
SHBHEAD_ID_EDI_KEY SHBHEAD_ID_EDI_KEY VARCHAR2(9) No
SHBHEAD_ID_TPORG SHBHEAD_ID_TPORG VARCHAR2(8) No
SHBHEAD_ACTIVITY_DATE SHBHEAD_ACTIVITY_DATE DATE No
SHBHEAD_PIDM SHBHEAD_PIDM NUMBER(8,0) Yes
SHBHEAD_XSET_CODE SHBHEAD_XSET_CODE VARCHAR2(2) Yes
SHBHEAD_ACKKEY_T SHBHEAD_ACKKEY_T VARCHAR2(9) Yes
SHBHEAD_SEND_DATE SHBHEAD_SEND_DATE VARCHAR2(6) Yes
SHBHEAD_SEND_TIME SHBHEAD_SEND_TIME VARCHAR2(6) Yes
SHBHEAD_STIM_CODE SHBHEAD_STIM_CODE VARCHAR2(2) Yes
SHBHEAD_XPRP_CODE SHBHEAD_XPRP_CODE VARCHAR2(2) Yes
SHBHEAD_XRSN_CODE SHBHEAD_XRSN_CODE VARCHAR2(3) Yes
SHBHEAD_SID_SSNUM SHBHEAD_SID_SSNUM VARCHAR2(9) Yes
SHBHEAD_SID_AGENCY_NUM SHBHEAD_SID_AGENCY_NUM VARCHAR2(30) Yes
SHBHEAD_SID_AGENCY_DESC SHBHEAD_SID_AGENCY_DESC VARCHAR2(80) Yes
SHBHEAD_DOB_QUAL SHBHEAD_DOB_QUAL VARCHAR2(3) Yes
SHBHEAD_DOB_DATE_CODE SHBHEAD_DOB_DATE_CODE VARCHAR2(8) Yes
SHBHEAD_GENDER SHBHEAD_GENDER VARCHAR2(1) Yes
SHBHEAD_MARITAL SHBHEAD_MARITAL VARCHAR2(1) Yes
SHBHEAD_ETHNIC SHBHEAD_ETHNIC VARCHAR2(1) Yes
SHBHEAD_CITIZEN SHBHEAD_CITIZEN VARCHAR2(2) Yes
SHBHEAD_HOME_CNTRY SHBHEAD_HOME_CNTRY VARCHAR2(3) Yes
SHBHEAD_DCMT_IMAGE SHBHEAD_DCMT_IMAGE LONG Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SHBHEAD_DCMT_SEQNO SHRIDEN_DCMT_SEQNO SHRIDEN
SHBHEAD_DCMT_SEQNO SHRHDR4_DCMT_SEQNO SHRHDR4

Index

Index Name Index Type Column Name
PK_SHBHEAD Unique SHBHEAD_DCMT_SEQNO
SHBHEAD_KEY_INDEX2 Unique SHBHEAD_DCMT_SEQNO
SHBHEAD_KEY_INDEX2 Unique SHBHEAD_ID_DATE_KEY
SHBHEAD_KEY_INDEX2 Unique SHBHEAD_ID_DOC_KEY
SHBHEAD_KEY_INDEX2 Unique SHBHEAD_ID_EDI_KEY
SHBHEAD_KEY_INDEX2 Unique SHBHEAD_PIDM

Comments

Source Code Comments

EDI Master Header Table

Columns Comments for SHBHEAD_DCMT_SEQNO (1)

Source Code Comments

EDI Document ID Number

Columns Comments for SHBHEAD_ID_DATE_KEY (2)

Source Code Comments

EDI Document Date Code

Columns Comments for SHBHEAD_ID_DOC_KEY (3)

Source Code Comments

EDI Document Type Code

Columns Comments for SHBHEAD_ID_EDI_KEY (4)

Source Code Comments

EDI Document Key

Columns Comments for SHBHEAD_ID_TPORG (5)

Source Code Comments

EDI Document Key Item

Columns Comments for SHBHEAD_ACTIVITY_DATE (6)

Source Code Comments

EDI Activity Date

Columns Comments for SHBHEAD_PIDM (7)

Source Code Comments

EDI Document Association

Columns Comments for SHBHEAD_XSET_CODE (8)

Source Code Comments

EDI Transaction Set Code

Columns Comments for SHBHEAD_ACKKEY_T (9)

Source Code Comments

EDI Acknowlegement Key

Columns Comments for SHBHEAD_SEND_DATE (10)

Source Code Comments

EDI Send Date

Columns Comments for SHBHEAD_SEND_TIME (11)

Source Code Comments

EDI Send Time

Columns Comments for SHBHEAD_STIM_CODE (12)

Source Code Comments

EDI Time Code

Columns Comments for SHBHEAD_XPRP_CODE (13)

Source Code Comments

EDI Transcript Purpose Code

Columns Comments for SHBHEAD_XRSN_CODE (14)

Source Code Comments

EDI Reason for Sending Transcript

Columns Comments for SHBHEAD_SID_SSNUM (15)

Source Code Comments

EDI Student ID (SSN)

Columns Comments for SHBHEAD_SID_AGENCY_NUM (16)

Source Code Comments

EDI Student ID (Agency Number)

Columns Comments for SHBHEAD_SID_AGENCY_DESC (17)

Source Code Comments

EDI Description of Student ID

Columns Comments for SHBHEAD_DOB_QUAL (18)

Source Code Comments

EDI Date of Birth Qualifier

Columns Comments for SHBHEAD_DOB_DATE_CODE (19)

Source Code Comments

EDI Date of Birth

Columns Comments for SHBHEAD_GENDER (20)

Source Code Comments

EDI Gender or Sex

Columns Comments for SHBHEAD_MARITAL (21)

Source Code Comments

EDI Marital Status Code

Columns Comments for SHBHEAD_ETHNIC (22)

Source Code Comments

EDI Ethnic Code

Columns Comments for SHBHEAD_CITIZEN (23)

Source Code Comments

EDI Citizenship Status

Columns Comments for SHBHEAD_HOME_CNTRY (24)

Source Code Comments

EDI Home Country Code

Columns Comments for SHBHEAD_DCMT_IMAGE (25)

Source Code Comments

Text Image of Transcript

Table SHBRPTR

Schema Name SATURN
Label SHBRPTR
Server name MALDEV8_B60
Creation Date 08/27/2002 00:00:58:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SHBRPTR_ACTIVITY_DATE SHBRPTR_ACTIVITY_DATE DATE No
SHBRPTR_TERM_CODE_EFF SHBRPTR_TERM_CODE_EFF VARCHAR2(6) No * *
SHBRPTR_REPEAT_SEL_IND SHBRPTR_REPEAT_SEL_IND VARCHAR2(1) No
SHBRPTR_REPEAT_PASS_GRADE SHBRPTR_REPEAT_PASS_GRADE VARCHAR2(6) No *
SHBRPTR_REPEAT_GPA_IND SHBRPTR_REPEAT_GPA_IND VARCHAR2(1) No
SHBRPTR_EQUIV_SEL_IND SHBRPTR_EQUIV_SEL_IND RAW(1) Yes
SHBRPTR_EQUIV_PASS_GRADE SHBRPTR_EQUIV_PASS_GRADE RAW(3) Yes
SHBRPTR_EQUIV_GPA_IND SHBRPTR_EQUIV_GPA_IND RAW(1) Yes
SHBRPTR_MULTI_SEL_IND SHBRPTR_MULTI_SEL_IND VARCHAR2(1) No
SHBRPTR_MULTI_PASS_GRADE SHBRPTR_MULTI_PASS_GRADE VARCHAR2(6) No *
SHBRPTR_MULTI_GPA_IND SHBRPTR_MULTI_GPA_IND VARCHAR2(1) No
SHBRPTR_LEVL_CODE SHBRPTR_LEVL_CODE VARCHAR2(2) No * *
SHBRPTR_LEVL_CODE SHBRPTR_LEVL_CODE VARCHAR2(2) No * *
SHBRPTR_LEVL_CODE SHBRPTR_LEVL_CODE VARCHAR2(2) No * *
SHBRPTR_LEVL_CODE SHBRPTR_LEVL_CODE VARCHAR2(2) No * *

Foreign Key information

Column name is Foreign Key For Column on Table
SHBRPTR_LEVL_CODE STVLEVL_CODE STVLEVL
SHBRPTR_TERM_CODE_EFF STVTERM_CODE STVTERM
SHBRPTR_REPEAT_PASS_GRADE SHRGRDE_CODE SHRGRDE
SHBRPTR_MULTI_PASS_GRADE SHRGRDE_CODE SHRGRDE
SHBRPTR_LEVL_CODE SHRGRDE_LEVL_CODE SHRGRDE
SHBRPTR_LEVL_CODE SHRTCKL_LEVL_CODE SHRTCKL
SHBRPTR_LEVL_CODE SFRSTCR_LEVL_CODE SFRSTCR

Index

Index Name Index Type Column Name
PK_SHBRPTR Unique SHBRPTR_TERM_CODE_EFF
PK_SHBRPTR Unique SHBRPTR_LEVL_CODE

Functional domain

Functional Domain
gpa

Comments

Source Code Comments

Repeat/Equivalent Course Rules Table

Columns Comments for SHBRPTR_ACTIVITY_DATE (1)

Source Code Comments

Activity Date. Specifies the date record was created or updated.

Columns Comments for SHBRPTR_TERM_CODE_EFF (2)

Source Code Comments

Effective Term Code. Specifies the effective term of the repeat rules.

Columns Comments for SHBRPTR_REPEAT_SEL_IND (3)

Source Code Comments

Repeat Rule Selection Indicator. Valid values are: F - First occurance of repeat course with a passing grade, H - Occurance with the highest grade, L - Latest occurance.

Columns Comments for SHBRPTR_REPEAT_PASS_GRADE (4)

Source Code Comments

Repeat Rule Passing Grade. Identifies what grade is passing for selection F.

Columns Comments for SHBRPTR_REPEAT_GPA_IND (5)

Source Code Comments

GPA calculation indicator. Options are S-Selected and A-All courses

Columns Comments for SHBRPTR_EQUIV_SEL_IND (6)

Source Code Comments

Equivalent Rule Selection Indicator. Valid values are: F - First occurance of repeated equivalent course with a passing grade, H - Occurance with the highest grade, L - Latest occurance.

Columns Comments for SHBRPTR_EQUIV_PASS_GRADE (7)

Source Code Comments

Equivalent Rule Passing Grade. Identifies what grade is passing for selection F.

Columns Comments for SHBRPTR_EQUIV_GPA_IND (8)

Source Code Comments

This field is not currently used.

Columns Comments for SHBRPTR_MULTI_SEL_IND (9)

Source Code Comments

Multiple Enrollment Selection Indicator. Identifies rule for courses allowed to be repeated. Valid values are: F - First occurance with a passing grade, H - Occurance with the highest grade, L - Latest occurance.

Columns Comments for SHBRPTR_MULTI_PASS_GRADE (10)

Source Code Comments

Multiple Enrollment Passing Grade. Identifies what grade is passing for selection F.

Columns Comments for SHBRPTR_MULTI_GPA_IND (11)

Source Code Comments

This field is not currently used.

Columns Comments for SHBRPTR_LEVL_CODE (12)

Source Code Comments

Repeat/Equivalent Course Level Code.

Table SHRASES

Schema Name SATURN
Label SHRASES
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:02:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SHRASES_DCMT_SEQNO SHRASES_DCMT_SEQNO NUMBER(8,0) No * *
SHRASES_SEQNO SHRASES_SEQNO NUMBER(4,0) No *
SHRASES_ACTIVITY_DATE SHRASES_ACTIVITY_DATE DATE No
SHRASES_START_DATE SHRASES_START_DATE VARCHAR2(6) Yes
SHRASES_SESS_NO SHRASES_SESS_NO NUMBER(3,0) Yes
SHRASES_SCHOOL_YEAR SHRASES_SCHOOL_YEAR VARCHAR2(35) Yes
SHRASES_SNTP_CODE SHRASES_SNTP_CODE VARCHAR2(1) Yes
SHRASES_SESS_NAME SHRASES_SESS_NAME VARCHAR2(35) Yes
SHRASES_SBQL_CODE SHRASES_SBQL_CODE VARCHAR2(3) Yes
SHRASES_BEGIN_DATE SHRASES_BEGIN_DATE VARCHAR2(8) Yes
SHRASES_SEQL_CODE SHRASES_SEQL_CODE VARCHAR2(3) Yes
SHRASES_END_DATE SHRASES_END_DATE VARCHAR2(8) Yes
SHRASES_SLVL_CODE SHRASES_SLVL_CODE VARCHAR2(2) Yes
SHRASES_CRQL_CODE SHRASES_CRQL_CODE VARCHAR2(2) Yes
SHRASES_CURR_CODE SHRASES_CURR_CODE VARCHAR2(20) Yes
SHRASES_CURR_NAME SHRASES_CURR_NAME VARCHAR2(35) Yes
SHRASES_HONR_CODE SHRASES_HONR_CODE VARCHAR2(3) Yes
SHRASES_OVRD_CODE SHRASES_OVRD_CODE VARCHAR2(2) Yes
SHRASES_INST_NAME_OVRD SHRASES_INST_NAME_OVRD VARCHAR2(35) Yes
SHRASES_INQL_CODE_OVRD SHRASES_INQL_CODE_OVRD VARCHAR2(2) Yes
SHRASES_INST_CODE_OVRD SHRASES_INST_CODE_OVRD VARCHAR2(20) Yes
SHRASES_STREET_LINE1_OVRD SHRASES_STREET_LINE1_OVRD VARCHAR2(35) Yes
SHRASES_STREET_LINE2_OVRD SHRASES_STREET_LINE2_OVRD VARCHAR2(35) Yes
SHRASES_CITY_OVRD SHRASES_CITY_OVRD VARCHAR2(30) Yes
SHRASES_STAT_CODE_OVRD SHRASES_STAT_CODE_OVRD VARCHAR2(2) Yes
SHRASES_ZIP_OVRD SHRASES_ZIP_OVRD VARCHAR2(9) Yes
SHRASES_NATN_CODE_OVRD SHRASES_NATN_CODE_OVRD VARCHAR2(3) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SHRASES_DCMT_SEQNO SHBHEAD_DCMT_SEQNO SHBHEAD

Index

Index Name Index Type Column Name
PK_SHRASES Unique SHRASES_DCMT_SEQNO
PK_SHRASES Unique SHRASES_SEQNO

Comments

Source Code Comments

EDI Academic Session Table.

Columns Comments for SHRASES_DCMT_SEQNO (1)

Source Code Comments

EDI Document Sequence Number

Columns Comments for SHRASES_SEQNO (2)

Source Code Comments

EDI Academic Session Sequence Number

Columns Comments for SHRASES_ACTIVITY_DATE (3)

Source Code Comments

EDI Activity Date

Columns Comments for SHRASES_START_DATE (4)

Source Code Comments

EDI Session Start Month/Year

Columns Comments for SHRASES_SESS_NO (5)

Source Code Comments

EDI Specific Session Number

Columns Comments for SHRASES_SCHOOL_YEAR (6)

Source Code Comments

EDI K-12 School Year

Columns Comments for SHRASES_SNTP_CODE (7)

Source Code Comments

EDI Type of Session

Columns Comments for SHRASES_SESS_NAME (8)

Source Code Comments

EDI Name of Session

Columns Comments for SHRASES_SBQL_CODE (9)

Source Code Comments

EDI Format for Date Session Began

Columns Comments for SHRASES_BEGIN_DATE (10)

Source Code Comments

EDI Starting Date

Columns Comments for SHRASES_SEQL_CODE (11)

Source Code Comments

EDI Format of Ending Date

Columns Comments for SHRASES_END_DATE (12)

Source Code Comments

EDI Ending Date

Columns Comments for SHRASES_SLVL_CODE (13)

Source Code Comments

EDI Student Grade Level

Columns Comments for SHRASES_CRQL_CODE (14)

Source Code Comments

EDI Curriculum Code Qualifier

Columns Comments for SHRASES_CURR_CODE (15)

Source Code Comments

EDI Curriculum Code

Columns Comments for SHRASES_CURR_NAME (16)

Source Code Comments

EDI Name of Curriculum

Columns Comments for SHRASES_HONR_CODE (17)

Source Code Comments

EDI Honors or Delinquency Code

Columns Comments for SHRASES_OVRD_CODE (18)

Source Code Comments

EDI Override Institution Code

Columns Comments for SHRASES_INST_NAME_OVRD (19)

Source Code Comments

EDI Institution/Agency

Columns Comments for SHRASES_INQL_CODE_OVRD (20)

Source Code Comments

EDI Institution Code Qualifier

Columns Comments for SHRASES_INST_CODE_OVRD (21)

Source Code Comments

EDI Institution Code

Columns Comments for SHRASES_STREET_LINE1_OVRD (22)

Source Code Comments

EDI Override Institution Address 1

Columns Comments for SHRASES_STREET_LINE2_OVRD (23)

Source Code Comments

EDI Override Institution Address 2

Columns Comments for SHRASES_CITY_OVRD (24)

Source Code Comments

EDI Override Institution City

Columns Comments for SHRASES_STAT_CODE_OVRD (25)

Source Code Comments

EDI Override Institution State

Columns Comments for SHRASES_ZIP_OVRD (26)

Source Code Comments

EDI Override Institution ZIP

Columns Comments for SHRASES_NATN_CODE_OVRD (27)

Source Code Comments

EDI Override Institution Nation Code

Table SHRCHRT

Schema Name SATURN
Label SHRCHRT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:02:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SHRCHRT_PIDM SHRCHRT_PIDM NUMBER(8,0) No * *
SHRCHRT_TERM_CODE SHRCHRT_TERM_CODE VARCHAR2(6) No * *
SHRCHRT_TERM_CODE SHRCHRT_TERM_CODE VARCHAR2(6) No * *
SHRCHRT_CHRT_CODE SHRCHRT_CHRT_CODE VARCHAR2(10) No * *
SHRCHRT_ACTIVE_IND SHRCHRT_ACTIVE_IND VARCHAR2(1) Yes
SHRCHRT_CREA_CODE SHRCHRT_CREA_CODE VARCHAR2(4) Yes *
SHRCHRT_ACTIVITY_DATE SHRCHRT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SHRCHRT_PIDM SHRTTRM_PIDM SHRTTRM
SHRCHRT_TERM_CODE SHRTTRM_TERM_CODE SHRTTRM
SHRCHRT_CHRT_CODE STVCHRT_CODE STVCHRT
SHRCHRT_TERM_CODE STVTERM_CODE STVTERM
SHRCHRT_CREA_CODE STVCREA_CODE STVCREA

Index

Index Name Index Type Column Name
PK_SHRCHRT Unique SHRCHRT_PIDM
PK_SHRCHRT Unique SHRCHRT_TERM_CODE
PK_SHRCHRT Unique SHRCHRT_CHRT_CODE

Comments

Source Code Comments

Cohort Academic History Table

Columns Comments for SHRCHRT_PIDM (1)

Source Code Comments

Internal Person Identification Number

Columns Comments for SHRCHRT_TERM_CODE (2)

Source Code Comments

Term Code

Columns Comments for SHRCHRT_CHRT_CODE (3)

Source Code Comments

Cohort Code

Columns Comments for SHRCHRT_ACTIVE_IND (4)

Source Code Comments

Active Indicator

Columns Comments for SHRCHRT_CREA_CODE (5)

Source Code Comments

Cohort Reason Code

Columns Comments for SHRCHRT_ACTIVITY_DATE (6)

Source Code Comments

The Activity Date

Table SHRCRSR

Schema Name SATURN
Label SHRCRSR
Server name MALDEV8_B60
Creation Date 08/27/2002 00:01:01:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SHRCRSR_DCMT_SEQNO SHRCRSR_DCMT_SEQNO NUMBER(8,0) No *
SHRCRSR_ASES_SEQNO SHRCRSR_ASES_SEQNO NUMBER(4,0) No *
SHRCRSR_ACTIVITY_DATE SHRCRSR_ACTIVITY_DATE DATE No
SHRCRSR_BASI_CODE SHRCRSR_BASI_CODE VARCHAR2(1) Yes
SHRCRSR_CRED_CODE SHRCRSR_CRED_CODE VARCHAR2(1) Yes
SHRCRSR_HOURS_ATTEMPTED SHRCRSR_HOURS_ATTEMPTED NUMBER(11,3) Yes
SHRCRSR_HOURS_EARNED SHRCRSR_HOURS_EARNED NUMBER(11,3) Yes
SHRCRSR_AMCAS_GRADE_QUAL SHRCRSR_AMCAS_GRADE_QUAL VARCHAR2(14) Yes
SHRCRSR_GRADE SHRCRSR_GRADE VARCHAR2(6) Yes
SHRCRSR_HONORS_IND SHRCRSR_HONORS_IND VARCHAR2(1) Yes
SHRCRSR_COURSE_LEVEL SHRCRSR_COURSE_LEVEL VARCHAR2(2) Yes
SHRCRSR_REPEAT_IND SHRCRSR_REPEAT_IND VARCHAR2(1) Yes
SHRCRSR_XCURR_CODE_QUAL SHRCRSR_XCURR_CODE_QUAL VARCHAR2(2) Yes
SHRCRSR_XCURR_CODE SHRCRSR_XCURR_CODE VARCHAR2(20) Yes
SHRCRSR_QUALITY_POINTS SHRCRSR_QUALITY_POINTS NUMBER(17,6) Yes
SHRCRSR_K12_GRADE_LEVEL SHRCRSR_K12_GRADE_LEVEL VARCHAR2(2) Yes
SHRCRSR_SUBJ_CODE SHRCRSR_SUBJ_CODE VARCHAR2(35) Yes
SHRCRSR_CRSE_NUMB SHRCRSR_CRSE_NUMB VARCHAR2(30) Yes
SHRCRSR_CRSE_TITLE SHRCRSR_CRSE_TITLE VARCHAR2(35) Yes
SHRCRSR_K12_DAYS_ATTEND SHRCRSR_K12_DAYS_ATTEND NUMBER(4,0) Yes
SHRCRSR_K12_DAYS_ABSENT SHRCRSR_K12_DAYS_ABSENT NUMBER(4,0) Yes
SHRCRSR_DROP_DATE SHRCRSR_DROP_DATE VARCHAR2(6) Yes
SHRCRSR_OVERRIDE_CODE SHRCRSR_OVERRIDE_CODE VARCHAR2(2) Yes
SHRCRSR_DUPLICATE SHRCRSR_DUPLICATE VARCHAR2(2) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SHRCRSR_DCMT_SEQNO SHBHEAD_DCMT_SEQNO SHBHEAD
SHRCRSR_ASES_SEQNO SHRASES_SEQNO SHRASES

Index

Index Name Index Type Column Name
SHRCRSR_KEY_INDEX SHRCRSR_DCMT_SEQNO
SHRCRSR_KEY_INDEX SHRCRSR_ASES_SEQNO

Comments

Source Code Comments

EDI Course Record Table

Columns Comments for SHRCRSR_DCMT_SEQNO (1)

Source Code Comments

EDI Document ID Number.

Columns Comments for SHRCRSR_ASES_SEQNO (2)

Source Code Comments

EDI Academic Session Sequence Number.

Columns Comments for SHRCRSR_ACTIVITY_DATE (3)

Source Code Comments

EDI Activity Date

Columns Comments for SHRCRSR_BASI_CODE (4)

Source Code Comments

EDI Basis for Academic Credit

Columns Comments for SHRCRSR_CRED_CODE (5)

Source Code Comments

EDI Academic Credit Type Code

Columns Comments for SHRCRSR_HOURS_ATTEMPTED (6)

Source Code Comments

EDI Credit Hours Attempted

Columns Comments for SHRCRSR_HOURS_EARNED (7)

Source Code Comments

EDI Credit Hours Earned

Columns Comments for SHRCRSR_AMCAS_GRADE_QUAL (8)

Source Code Comments

EDI Grading Scheme

Columns Comments for SHRCRSR_GRADE (9)

Source Code Comments

EDI Academic Grade

Columns Comments for SHRCRSR_HONORS_IND (10)

Source Code Comments

EDI Honors Indicator

Columns Comments for SHRCRSR_COURSE_LEVEL (11)

Source Code Comments

EDI Academic Course Level Code

Columns Comments for SHRCRSR_REPEAT_IND (12)

Source Code Comments

EDI Course Repeat or No Count Indicator

Columns Comments for SHRCRSR_XCURR_CODE_QUAL (13)

Source Code Comments

EDI Curriculum Code Qualifier

Columns Comments for SHRCRSR_XCURR_CODE (14)

Source Code Comments

EDI Curriculum Code

Columns Comments for SHRCRSR_QUALITY_POINTS (15)

Source Code Comments

EDI Academic Quality Points

Columns Comments for SHRCRSR_K12_GRADE_LEVEL (16)

Source Code Comments

EDI Course Grade Level (K-12)

Columns Comments for SHRCRSR_SUBJ_CODE (17)

Source Code Comments

EDI Subject Abbreviation

Columns Comments for SHRCRSR_CRSE_NUMB (18)

Source Code Comments

EDI Course Number

Columns Comments for SHRCRSR_CRSE_TITLE (19)

Source Code Comments

EDI Course Title

Columns Comments for SHRCRSR_K12_DAYS_ATTEND (20)

Source Code Comments

EDI Days Attended (K-12)

Columns Comments for SHRCRSR_K12_DAYS_ABSENT (21)

Source Code Comments

EDI Days Absent (K-12)

Columns Comments for SHRCRSR_DROP_DATE (22)

Source Code Comments

EDI Student Drop Date

Columns Comments for SHRCRSR_OVERRIDE_CODE (23)

Source Code Comments

EDI Override Academic Course Source Code

Columns Comments for SHRCRSR_DUPLICATE (24)

Source Code Comments

Indicates a duplicate transfer subj/crse for a given EDI Transcript

Table SHRDCMT

Schema Name SATURN
Label SHRDCMT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:03:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SHRDCMT_PIDM SHRDCMT_PIDM NUMBER(8,0) No *
SHRDCMT_DGMR_SEQ_NO SHRDCMT_DGMR_SEQ_NO NUMBER(2,0) No *
SHRDCMT_SEQNO SHRDCMT_SEQNO NUMBER(23,20) Yes
SHRDCMT_COMMENT SHRDCMT_COMMENT VARCHAR2(60) Yes
SHRDCMT_ACTIVITY_DATE SHRDCMT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SHRDCMT_PIDM SHRDGMR_PIDM SHRDGMR
SHRDCMT_DGMR_SEQ_NO SHRDGMR_SEQ_NO SHRDGMR

Index

Index Name Index Type Column Name
SHRDCMT_KEY_INDEX SHRDCMT_PIDM
SHRDCMT_KEY_INDEX SHRDCMT_DGMR_SEQ_NO
SHRDCMT_KEY_INDEX SHRDCMT_SEQNO

Comments

Source Code Comments

Diploma Comment Table

Columns Comments for SHRDCMT_PIDM (1)

Source Code Comments

Internal identification number of the student.

Columns Comments for SHRDCMT_DGMR_SEQ_NO (2)

Source Code Comments

This field identifies the degree number associated with the degree the student is seeking.

Columns Comments for SHRDCMT_SEQNO (3)

Source Code Comments

This field does not display on the form. It assigns an internal sequence number to each comment created.

Columns Comments for SHRDCMT_COMMENT (4)

Source Code Comments

This field identifies each comment created.

Columns Comments for SHRDCMT_ACTIVITY_DATE (5)

Source Code Comments

This field identifies the most current date a record was created or changed.

Table SHRDGCM

Schema Name SATURN
Label SHRDGCM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:03:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SHRDGCM_PIDM SHRDGCM_PIDM NUMBER(8,0) No *
SHRDGCM_DGMR_SEQ_NO SHRDGCM_DGMR_SEQ_NO NUMBER(2,0) No *
SHRDGCM_SEQNO SHRDGCM_SEQNO NUMBER(23,20) Yes
SHRDGCM_COMMENT SHRDGCM_COMMENT VARCHAR2(60) Yes
SHRDGCM_ACTIVITY_DATE SHRDGCM_ACTIVITY_DATE DATE No

Foreign Key information

Co