RORVIEW SCREQIV SDBDEGR SFBETRM SFRSTCR SGBSTDN 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 SIRASGN SMRPRLE SOBTERM SPBPERS SSBFSEC SSBSECT SSBSSEC SSRRTST STVCAMP STVCAST STVCERT STVCHRT STVCOLL STVCOMT STVCREA STVDEGC STVDEGS STVDEPT STVDIVS STVEVEN STVEXAM STVGCHG STVGCMT STVGMOD STVGRST STVHOND STVHONR STVINNM STVNATN STVNCRQ STVNCST STVPREV STVPTRM STVQPTP STVSBGI STVSCHD STVSESS STVSTAT STVSUBJ STVTRMT STVWRSN

Model Academic History Group #1


Model Label : ERD For Portions of Banner Student Academic History Module ( SH% Tables )
Path : BANNER DEV/Student/Academic History/Academic History Group #1

List of Objects

Object Name Object Type Layer Name
RORVIEW TABLE Link_1
SCREQIV TABLE Link_1
SDBDEGR TABLE Link_1
SFBETRM TABLE Link_1
SFRSTCR TABLE Link_1
SGBSTDN TABLE Link_1
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
SIRASGN TABLE Link_1
SMRPRLE TABLE Link_1
SOBTERM TABLE Link_1
SPBPERS TABLE Link_1
SSBFSEC TABLE Link_1
SSBSECT TABLE Link_1
SSBSSEC TABLE Link_1
SSRRTST TABLE Link_1
STVCAMP TABLE Link_1
STVCAST TABLE Link_1
STVCERT TABLE Link_1
STVCHRT TABLE Link_1
STVCOLL TABLE Link_1
STVCOMT TABLE Link_1
STVCREA TABLE Link_1
STVDEGC TABLE Link_1
STVDEGS TABLE Link_1
STVDEPT TABLE Link_1
STVDIVS TABLE Link_1
STVEVEN TABLE Link_1
STVEXAM TABLE Link_1
STVGCHG TABLE Link_1
STVGCMT TABLE Link_1
STVGMOD TABLE Link_1
STVGRST TABLE Link_1
STVHOND TABLE Link_1
STVHONR TABLE Link_1
STVINNM TABLE Link_1
STVNATN TABLE Link_1
STVNCRQ TABLE Link_1
STVNCST TABLE Link_1
STVPREV TABLE Link_1
STVPTRM TABLE Link_1
STVQPTP TABLE Link_1
STVSBGI TABLE Link_1
STVSCHD TABLE Link_1
STVSESS TABLE Link_1
STVSTAT TABLE Link_1
STVSUBJ TABLE Link_1
STVTRMT TABLE Link_1
STVWRSN TABLE Link_1

Comments

Model View

''

Table RORVIEW

Schema Name FAISMGR
Label RORVIEW
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:21:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RORVIEW_SESSION_ID RORVIEW_SESSION_ID VARCHAR2(30) No
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_PIDM RORVIEW_PIDM NUMBER(8,0) No *
RORVIEW_TYPE_IND RORVIEW_TYPE_IND VARCHAR2(1) No
RORVIEW_TERM_CODE RORVIEW_TERM_CODE VARCHAR2(6) Yes *
RORVIEW_TERM_CODE RORVIEW_TERM_CODE VARCHAR2(6) Yes *
RORVIEW_AIDY_CODE RORVIEW_AIDY_CODE VARCHAR2(4) Yes *
RORVIEW_AIDY_CODE RORVIEW_AIDY_CODE VARCHAR2(4) Yes *
RORVIEW_AIDY_CODE RORVIEW_AIDY_CODE VARCHAR2(4) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
RORVIEW_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RORVIEW_TERM_CODE STVTERM_CODE STVTERM
RORVIEW_PIDM TBBESTU_PIDM TBBESTU
RORVIEW_AIDY_CODE RPRATRM_AIDY_CODE RPRATRM
RORVIEW_PIDM RPRATRM_PIDM RPRATRM
RORVIEW_PIDM SGBSTDN_PIDM SGBSTDN
RORVIEW_TERM_CODE SFBETRM_TERM_CODE SFBETRM
RORVIEW_PIDM SFBETRM_PIDM SFBETRM
RORVIEW_PIDM SHRTGPA_PIDM SHRTGPA
RORVIEW_PIDM TBRACCD_PIDM TBRACCD
RORVIEW_PIDM TBBCSTU_STU_PIDM TBBCSTU
RORVIEW_AIDY_CODE RPRAWRD_AIDY_CODE RPRAWRD
RORVIEW_PIDM RPRAWRD_PIDM RPRAWRD

Index

Index Name Index Type Column Name
RORVIEW_KEY_INDEX Unique RORVIEW_SESSION_ID
RORVIEW_KEY_INDEX Unique RORVIEW_PIDM
RORVIEW_KEY_INDEX Unique RORVIEW_TYPE_IND
RORVIEW_KEY_INDEX Unique RORVIEW_TERM_CODE
RORVIEW_KEY_INDEX Unique RORVIEW_AIDY_CODE

Comments

Source Code Comments

View Selection Table

Table SCREQIV

Schema Name SATURN
Label SCREQIV
Server name MALDEV8_B60
Creation Date 06/25/2002 12:37:17:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SCREQIV_SUBJ_CODE SCREQIV_SUBJ_CODE VARCHAR2(4) No *
SCREQIV_SUBJ_CODE SCREQIV_SUBJ_CODE VARCHAR2(4) No *
SCREQIV_CRSE_NUMB SCREQIV_CRSE_NUMB VARCHAR2(5) No *
SCREQIV_EFF_TERM SCREQIV_EFF_TERM VARCHAR2(6) No *
SCREQIV_SUBJ_CODE_EQIV SCREQIV_SUBJ_CODE_EQIV VARCHAR2(4) Yes *
SCREQIV_CRSE_NUMB_EQIV SCREQIV_CRSE_NUMB_EQIV VARCHAR2(5) Yes
SCREQIV_START_TERM SCREQIV_START_TERM VARCHAR2(6) Yes *
SCREQIV_END_TERM SCREQIV_END_TERM VARCHAR2(6) Yes *
SCREQIV_ACTIVITY_DATE SCREQIV_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SCREQIV_SUBJ_CODE SCBCRKY_SUBJ_CODE SCBCRKY
SCREQIV_CRSE_NUMB SCBCRKY_CRSE_NUMB SCBCRKY

Index

Index Name Index Type Column Name
SCREQIV_EQIV_INDEX SCREQIV_SUBJ_CODE_EQIV
SCREQIV_EQIV_INDEX SCREQIV_CRSE_NUMB_EQIV
UK_SCREQIV Unique SCREQIV_SUBJ_CODE
UK_SCREQIV Unique SCREQIV_CRSE_NUMB
UK_SCREQIV Unique SCREQIV_EFF_TERM
UK_SCREQIV Unique SCREQIV_SUBJ_CODE_EQIV
UK_SCREQIV Unique SCREQIV_CRSE_NUMB_EQIV
UK_SCREQIV Unique SCREQIV_START_TERM

Comments

Source Code Comments

Equivalent Course Repeating Table

Columns Comments for SCREQIV_SUBJ_CODE (1)

Source Code Comments

This field defines the subject area of the course.

Columns Comments for SCREQIV_CRSE_NUMB (2)

Source Code Comments

This field defines the course number associated with the subject for the course.

Columns Comments for SCREQIV_EFF_TERM (3)

Source Code Comments

This field identifies the term this version of the course equivalents becomes effective.

Columns Comments for SCREQIV_SUBJ_CODE_EQIV (4)

Source Code Comments

This field defines an equivalent course subject code for the master course. Defining equivalents for a course is optional. An unlimited number of equivalents can be authorized for a course.

Columns Comments for SCREQIV_CRSE_NUMB_EQIV (5)

Source Code Comments

This field defines the course number of the equivalent course. Course numbers are not validated against valid course versions.

Columns Comments for SCREQIV_START_TERM (6)

Source Code Comments

This field specifies the start term of the course version which is equivalent to the course entered in the Key Block.

Columns Comments for SCREQIV_END_TERM (7)

Source Code Comments

This field is used to specify the end term of the course version which is equivalent to the course entered in the Key Block.

Columns Comments for SCREQIV_ACTIVITY_DATE (8)

Source Code Comments

This field specifies the most current date record was created or updated.

Table SDBDEGR

Schema Name SATURN
Label SDBDEGR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:51:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SDBDEGR_ACTIVITY_DATE SDBDEGR_ACTIVITY_DATE DATE No
SDBDEGR_PIDM SDBDEGR_PIDM NUMBER(8,0) No * *
SDBDEGR_DGMR_SEQ_NO SDBDEGR_DGMR_SEQ_NO NUMBER(2,0) No * *
SDBDEGR_BLTN_YEAR SDBDEGR_BLTN_YEAR VARCHAR2(4) No *
SDBDEGR_PRIM_PROGRAM SDBDEGR_PRIM_PROGRAM VARCHAR2(6) No
SDBDEGR_SEC_PROGRAM SDBDEGR_SEC_PROGRAM VARCHAR2(6) Yes
SDBDEGR_LEVL_CODE SDBDEGR_LEVL_CODE VARCHAR2(2) No *
SDBDEGR_DEGS_CODE SDBDEGR_DEGS_CODE VARCHAR2(2) No *
SDBDEGR_GRAD_DATE SDBDEGR_GRAD_DATE DATE Yes
SDBDEGR_APPL_DATE SDBDEGR_APPL_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SDBDEGR_BLTN_YEAR STVACYR_CODE STVACYR
SDBDEGR_PIDM SHRDGMR_PIDM SHRDGMR
SDBDEGR_DGMR_SEQ_NO SHRDGMR_SEQ_NO SHRDGMR
SDBDEGR_DEGS_CODE STVDEGS_CODE STVDEGS
SDBDEGR_LEVL_CODE STVLEVL_CODE STVLEVL

Index

Index Name Index Type Column Name
PK_SDBDEGR Unique SDBDEGR_PIDM
PK_SDBDEGR Unique SDBDEGR_DGMR_SEQ_NO

Comments

Source Code Comments

Ddgree Audit Degree Definition Table

Columns Comments for SDBDEGR_ACTIVITY_DATE (1)

Source Code Comments

This field specifies the date the record was created or updated.

Columns Comments for SDBDEGR_PIDM (2)

Source Code Comments

Internal Identification Number of the student.

Columns Comments for SDBDEGR_DGMR_SEQ_NO (3)

Source Code Comments

This field identifies the sequence number of the student"s degree.

Columns Comments for SDBDEGR_BLTN_YEAR (4)

Source Code Comments

This field identifies the bulletin year associated with the student"s degree.

Columns Comments for SDBDEGR_PRIM_PROGRAM (5)

Source Code Comments

This field identifies the degree program code associated with the primary program of the student"s degree.

Columns Comments for SDBDEGR_SEC_PROGRAM (6)

Source Code Comments

This field identifies the degree program code associated with the secondary program of the student"s degree.

Columns Comments for SDBDEGR_LEVL_CODE (7)

Source Code Comments

Degree Level Code.

Columns Comments for SDBDEGR_DEGS_CODE (8)

Source Code Comments

Degree Program Degree Code.

Columns Comments for SDBDEGR_GRAD_DATE (9)

Source Code Comments

Degree Graduate Date.

Columns Comments for SDBDEGR_APPL_DATE (10)

Source Code Comments

Degree Application Date.

Table SFBETRM

Schema Name SATURN
Label SFBETRM
Server name MALDEV8_B60
Creation Date 04/28/2003 16:17:53:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFBETRM_TERM_CODE SFBETRM_TERM_CODE VARCHAR2(6) No * *
SFBETRM_TERM_CODE SFBETRM_TERM_CODE VARCHAR2(6) No * *
SFBETRM_PIDM SFBETRM_PIDM NUMBER(8,0) No * *
SFBETRM_ESTS_CODE SFBETRM_ESTS_CODE VARCHAR2(2) No *
SFBETRM_ESTS_DATE SFBETRM_ESTS_DATE DATE Yes
SFBETRM_MHRS_OVER SFBETRM_MHRS_OVER NUMBER(9,3) No
SFBETRM_AR_IND SFBETRM_AR_IND VARCHAR2(1) No
SFBETRM_ASSESSMENT_DATE SFBETRM_ASSESSMENT_DATE DATE Yes
SFBETRM_ADD_DATE SFBETRM_ADD_DATE DATE No
SFBETRM_ACTIVITY_DATE SFBETRM_ACTIVITY_DATE DATE No
SFBETRM_RGRE_CODE SFBETRM_RGRE_CODE VARCHAR2(2) Yes *
SFBETRM_TMST_CODE SFBETRM_TMST_CODE VARCHAR2(2) Yes *
SFBETRM_TMST_DATE SFBETRM_TMST_DATE DATE Yes
SFBETRM_TMST_MAINT_IND SFBETRM_TMST_MAINT_IND VARCHAR2(1) Yes
SFBETRM_USER SFBETRM_USER VARCHAR2(30) Yes
SFBETRM_REFUND_DATE SFBETRM_REFUND_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SFBETRM_RGRE_CODE STVRGRE_CODE STVRGRE
SFBETRM_TERM_CODE STVTERM_CODE STVTERM
SFBETRM_ESTS_CODE STVESTS_CODE STVESTS
SFBETRM_TMST_CODE STVTMST_CODE STVTMST
SFBETRM_PIDM SRBRECR_PIDM SRBRECR
SFBETRM_TERM_CODE SRBRECR_TERM_CODE SRBRECR

Index

Index Name Index Type Column Name
PK_SFBETRM Unique SFBETRM_PIDM
PK_SFBETRM Unique SFBETRM_TERM_CODE
SFBETRM_KEY_INDEX2 SFBETRM_TERM_CODE

Comments

Source Code Comments

Student Registration Table

Impact job : SFBETRM_ESTS_CODE SFBETRM_ESTS_CODE

Columns Comments for SFBETRM_TERM_CODE (1)

Source Code Comments

This field identifies term associated with this registration.

Columns Comments for SFBETRM_PIDM (2)

Source Code Comments

Internal Identification Number of the person registered .

Columns Comments for SFBETRM_ESTS_CODE (3)

Source Code Comments

This field identifies the student enrollment status code.

Columns Comments for SFBETRM_ESTS_DATE (4)

Source Code Comments

This field identifies the date associated with the student enrollment status code.

Columns Comments for SFBETRM_MHRS_OVER (5)

Source Code Comments

This field identifies the maximum hours override for this term.

Columns Comments for SFBETRM_AR_IND (6)

Source Code Comments

This field identifies the term charges acceptance indicator.

Columns Comments for SFBETRM_ASSESSMENT_DATE (7)

Source Code Comments

This field identifies the date of the assessment for this term.

Columns Comments for SFBETRM_ADD_DATE (8)

Source Code Comments

This field identifies the date of the initial registration for this term.

Columns Comments for SFBETRM_ACTIVITY_DATE (9)

Source Code Comments

This field specifies the most current date the record was created or updated.

Columns Comments for SFBETRM_RGRE_CODE (10)

Source Code Comments

Student Registration Reason Code.

Columns Comments for SFBETRM_TMST_CODE (11)

Source Code Comments

Most recently calculated time status code.

Columns Comments for SFBETRM_TMST_DATE (12)

Source Code Comments

Date change in time status occurred.

Columns Comments for SFBETRM_TMST_MAINT_IND (13)

Source Code Comments

Flag indicating whether the change in time status was calculated by the system or overridden and updated by a user.

Columns Comments for SFBETRM_USER (14)

Source Code Comments

The ID of the user who updated or created the record.

Columns Comments for SFBETRM_REFUND_DATE (15)

Source Code Comments

Refund by total refund date used in performing fee assessment. Date is needed for refund by total processing to determine the refund period used in the last assessment.

Table SFRSTCR

Schema Name SATURN
Label SFRSTCR
Server name MALDEV8_B60
Creation Date 07/30/2003 16:03:46:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SFRSTCR_TERM_CODE SFRSTCR_TERM_CODE VARCHAR2(6) No * *
SFRSTCR_TERM_CODE SFRSTCR_TERM_CODE VARCHAR2(6) No * *
SFRSTCR_TERM_CODE SFRSTCR_TERM_CODE VARCHAR2(6) No * *
SFRSTCR_TERM_CODE SFRSTCR_TERM_CODE VARCHAR2(6) No * *
SFRSTCR_TERM_CODE SFRSTCR_TERM_CODE VARCHAR2(6) No * *
SFRSTCR_TERM_CODE SFRSTCR_TERM_CODE VARCHAR2(6) No * *
SFRSTCR_TERM_CODE SFRSTCR_TERM_CODE VARCHAR2(6) No * *
SFRSTCR_TERM_CODE SFRSTCR_TERM_CODE VARCHAR2(6) No * *
SFRSTCR_TERM_CODE SFRSTCR_TERM_CODE VARCHAR2(6) No * *
SFRSTCR_TERM_CODE SFRSTCR_TERM_CODE VARCHAR2(6) No * *
SFRSTCR_PIDM SFRSTCR_PIDM NUMBER(8,0) No * *
SFRSTCR_PIDM SFRSTCR_PIDM NUMBER(8,0) No * *
SFRSTCR_PIDM SFRSTCR_PIDM NUMBER(8,0) No * *
SFRSTCR_PIDM SFRSTCR_PIDM NUMBER(8,0) No * *
SFRSTCR_PIDM SFRSTCR_PIDM NUMBER(8,0) No * *
SFRSTCR_PIDM SFRSTCR_PIDM NUMBER(8,0) No * *
SFRSTCR_CRN SFRSTCR_CRN VARCHAR2(5) No * *
SFRSTCR_CRN SFRSTCR_CRN VARCHAR2(5) No * *
SFRSTCR_CRN SFRSTCR_CRN VARCHAR2(5) No * *
SFRSTCR_CRN SFRSTCR_CRN VARCHAR2(5) No * *
SFRSTCR_CRN SFRSTCR_CRN VARCHAR2(5) No * *
SFRSTCR_CLASS_SORT_KEY SFRSTCR_CLASS_SORT_KEY NUMBER(4,0) Yes
SFRSTCR_REG_SEQ SFRSTCR_REG_SEQ NUMBER(4,0) No
SFRSTCR_PTRM_CODE SFRSTCR_PTRM_CODE VARCHAR2(3) Yes *
SFRSTCR_RSTS_CODE SFRSTCR_RSTS_CODE VARCHAR2(2) Yes *
SFRSTCR_RSTS_DATE SFRSTCR_RSTS_DATE DATE Yes
SFRSTCR_ERROR_FLAG SFRSTCR_ERROR_FLAG VARCHAR2(1) Yes
SFRSTCR_MESSAGE SFRSTCR_MESSAGE VARCHAR2(25) Yes
SFRSTCR_BILL_HR SFRSTCR_BILL_HR NUMBER(7,3) Yes
SFRSTCR_WAIV_HR SFRSTCR_WAIV_HR NUMBER(7,3) Yes
SFRSTCR_CREDIT_HR SFRSTCR_CREDIT_HR NUMBER(7,3) Yes
SFRSTCR_BILL_HR_HOLD SFRSTCR_BILL_HR_HOLD NUMBER(7,3) Yes
SFRSTCR_CREDIT_HR_HOLD SFRSTCR_CREDIT_HR_HOLD NUMBER(7,3) Yes
SFRSTCR_GMOD_CODE SFRSTCR_GMOD_CODE VARCHAR2(1) Yes *
SFRSTCR_GRDE_CODE SFRSTCR_GRDE_CODE VARCHAR2(6) Yes
SFRSTCR_GRDE_CODE_MID SFRSTCR_GRDE_CODE_MID VARCHAR2(6) Yes
SFRSTCR_GRDE_DATE SFRSTCR_GRDE_DATE DATE Yes
SFRSTCR_DUPL_OVER SFRSTCR_DUPL_OVER VARCHAR2(1) Yes
SFRSTCR_LINK_OVER SFRSTCR_LINK_OVER VARCHAR2(1) Yes
SFRSTCR_CORQ_OVER SFRSTCR_CORQ_OVER VARCHAR2(1) Yes
SFRSTCR_PREQ_OVER SFRSTCR_PREQ_OVER VARCHAR2(1) Yes
SFRSTCR_TIME_OVER SFRSTCR_TIME_OVER VARCHAR2(1) Yes
SFRSTCR_CAPC_OVER SFRSTCR_CAPC_OVER VARCHAR2(1) Yes
SFRSTCR_LEVL_OVER SFRSTCR_LEVL_OVER VARCHAR2(1) Yes
SFRSTCR_COLL_OVER SFRSTCR_COLL_OVER VARCHAR2(1) Yes
SFRSTCR_MAJR_OVER SFRSTCR_MAJR_OVER VARCHAR2(1) Yes
SFRSTCR_CLAS_OVER SFRSTCR_CLAS_OVER VARCHAR2(1) Yes
SFRSTCR_APPR_OVER SFRSTCR_APPR_OVER VARCHAR2(1) Yes
SFRSTCR_APPR_RECEIVED_IND SFRSTCR_APPR_RECEIVED_IND VARCHAR2(1) Yes
SFRSTCR_ADD_DATE SFRSTCR_ADD_DATE DATE No
SFRSTCR_ACTIVITY_DATE SFRSTCR_ACTIVITY_DATE DATE No
SFRSTCR_LEVL_CODE SFRSTCR_LEVL_CODE VARCHAR2(2) No *
SFRSTCR_CAMP_CODE SFRSTCR_CAMP_CODE VARCHAR2(3) No *
SFRSTCR_RESERVED_KEY SFRSTCR_RESERVED_KEY VARCHAR2(8) Yes
SFRSTCR_ATTEND_HR SFRSTCR_ATTEND_HR NUMBER(9,3) Yes
SFRSTCR_REPT_OVER SFRSTCR_REPT_OVER VARCHAR2(1) Yes
SFRSTCR_RPTH_OVER SFRSTCR_RPTH_OVER VARCHAR2(1) Yes
SFRSTCR_TEST_OVER SFRSTCR_TEST_OVER VARCHAR2(1) Yes
SFRSTCR_CAMP_OVER SFRSTCR_CAMP_OVER VARCHAR2(1) Yes
SFRSTCR_USER SFRSTCR_USER VARCHAR2(30) Yes
SFRSTCR_DEGC_OVER SFRSTCR_DEGC_OVER VARCHAR2(1) Yes
SFRSTCR_PROG_OVER SFRSTCR_PROG_OVER VARCHAR2(1) Yes
SFRSTCR_LAST_ATTEND SFRSTCR_LAST_ATTEND DATE Yes
SFRSTCR_GCMT_CODE SFRSTCR_GCMT_CODE VARCHAR2(7) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SFRSTCR_PTRM_CODE STVPTRM_CODE STVPTRM
SFRSTCR_PIDM SFBETRM_PIDM SFBETRM
SFRSTCR_TERM_CODE SFBETRM_TERM_CODE SFBETRM
SFRSTCR_GCMT_CODE STVGCMT_CODE STVGCMT
SFRSTCR_CAMP_CODE STVCAMP_CODE STVCAMP
SFRSTCR_LEVL_CODE STVLEVL_CODE STVLEVL
SFRSTCR_TERM_CODE STVTERM_CODE STVTERM
SFRSTCR_GMOD_CODE STVGMOD_CODE STVGMOD
SFRSTCR_RSTS_CODE STVRSTS_CODE STVRSTS
SFRSTCR_TERM_CODE SFRENRL_TERM_CODE SFRENRL
SFRSTCR_PIDM SFRENRL_PIDM SFRENRL
SFRSTCR_PIDM TBRACCD_PIDM TBRACCD
SFRSTCR_TERM_CODE TBRACCD_TERM_CODE TBRACCD
SFRSTCR_CRN TBRACCD_CRN TBRACCD
SFRSTCR_TERM_CODE SOBTERM_TERM_CODE SOBTERM
SFRSTCR_TERM_CODE SSRSYLN_TERM_CODE SSRSYLN
SFRSTCR_CRN SSRSYLN_CRN SSRSYLN
SFRSTCR_TERM_CODE RORENRL_TERM_CODE RORENRL
SFRSTCR_PIDM RORENRL_PIDM RORENRL
SFRSTCR_TERM_CODE SHRMRKS_TERM_CODE SHRMRKS
SFRSTCR_PIDM SHRMRKS_PIDM SHRMRKS
SFRSTCR_CRN SHRMRKS_CRN SHRMRKS
SFRSTCR_TERM_CODE SHRSMRK_TERM_CODE SHRSMRK
SFRSTCR_PIDM SHRSMRK_PIDM SHRSMRK
SFRSTCR_CRN