Tables and Views for SATURN as of 24-MAY-2004 11:21am
Date: 24-MAY-2004 Page: 1
TABLE: BGCRSETXT1
CREATOR: SATURN
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TEXT1_SUBJ_CODE VARCHAR2 4 YES
TEXT1_CRSE_NUMB VARCHAR2 5 YES
TEXT1_TEXT CLOB 4000 YES
TEXT1_TEXT2 CLOB 4000 YES
Date: 24-MAY-2004 Page: 2
TABLE: BGSCRTEXT
CREATOR: SATURN
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRTEXT_SUBJ_CODE VARCHAR2 4 NO
SCRTEXT_CRSE_NUMB VARCHAR2 5 NO
SCRTEXT_EFF_TERM VARCHAR2 6 NO
SCRTEXT_TEXT_CODE VARCHAR2 1 YES
SCRTEXT_SEQNO NUMBER 23 20 YES
SCRTEXT_TEXT VARCHAR2 60 YES
SCRTEXT_ACTIVITY_DATE DATE 7 NO
Date: 24-MAY-2004 Page: 3
TABLE: CATL_REC_B
CREATOR: SATURN
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
CATLB_SUBJ_KEY VARCHAR2 4 YES
CATLB_CRSE_KEY VARCHAR2 5 YES
CATLB_START_TERM_KEY VARCHAR2 4 YES
CATLB_SUBJ_2011 VARCHAR2 4 YES
CATLB_SUBJ_DESC_2011 VARCHAR2 30 YES
CATLB_CRSE_2012 VARCHAR2 5 YES
CATLB_CRSE_TITLE_2017 VARCHAR2 30 YES
CATLB_START_TERM_2017 VARCHAR2 4 YES
CATLB_START_TERM_DESC_2005 VARCHAR2 15 YES
CATLB_END_TERM_2017 VARCHAR2 4 YES
CATLB_END_TERM_DESC_2005 VARCHAR2 15 YES
Date: 24-MAY-2004 Page: 4
TABLE: CATL_REC_G
CREATOR: SATURN
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
CATLG_SUBJ_KEY VARCHAR2 4 YES
CATLG_CRSE_KEY VARCHAR2 6 YES
CATLG_START_TERM_KEY VARCHAR2 6 YES
CATLG_CRSE_RSTRN_TYPE VARCHAR2 2 YES
CATLG_CRSE_RSTRN_CODE VARCHAR2 4 YES
CATLG_CRSE_RSTRN_FLAG VARCHAR2 1 YES
Date: 24-MAY-2004 Page: 5
TABLE: EXCEPTIONS
CREATOR: SATURN
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ROW_ID ROWID 10 YES
OWNER VARCHAR2 30 YES
TABLE_NAME VARCHAR2 30 YES
CONSTRAINT VARCHAR2 30 YES
Date: 24-MAY-2004 Page: 6
TABLE: GJBJOBS_INSTALL
CREATOR: SATURN
saturn GJBJOBS rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBJOBS_NAME VARCHAR2 30 NO
GJBJOBS_TITLE VARCHAR2 30 NO
GJBJOBS_ACTIVITY_DATE DATE 7 NO
GJBJOBS_SYSI_CODE VARCHAR2 2 YES
GJBJOBS_JOB_TYPE_IND VARCHAR2 1 YES
GJBJOBS_DESC VARCHAR2 240 YES
GJBJOBS_COMMAND_NAME VARCHAR2 30 YES
GJBJOBS_PRNT_FORM VARCHAR2 30 YES
GJBJOBS_PRNT_CODE VARCHAR2 30 YES
GJBJOBS_LINE_COUNT NUMBER 3 YES
GJBJOBS_VALIDATION VARCHAR2 30 YES
Date: 24-MAY-2004 Page: 7
TABLE: GJBPDEF_INSTALL
CREATOR: SATURN
saturn GJBPDEF rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDEF_JOB VARCHAR2 30 NO
GJBPDEF_NUMBER VARCHAR2 2 NO
GJBPDEF_DESC VARCHAR2 30 NO
GJBPDEF_LENGTH NUMBER 2 NO
GJBPDEF_TYPE_IND VARCHAR2 1 NO
GJBPDEF_OPTIONAL_IND VARCHAR2 1 NO
GJBPDEF_SINGLE_IND VARCHAR2 1 NO
GJBPDEF_ACTIVITY_DATE DATE 7 NO
GJBPDEF_LOW_RANGE VARCHAR2 30 YES
GJBPDEF_HIGH_RANGE VARCHAR2 30 YES
GJBPDEF_HELP_TEXT VARCHAR2 78 YES
GJBPDEF_VALIDATION VARCHAR2 30 YES
GJBPDEF_LIST_VALUES VARCHAR2 30 YES
Date: 24-MAY-2004 Page: 8
TABLE: GJBPDFT_INSTALL
CREATOR: SATURN
saturn GJBPDFT rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDFT_JOB VARCHAR2 30 NO
GJBPDFT_NUMBER VARCHAR2 2 NO
GJBPDFT_ACTIVITY_DATE DATE 7 NO
GJBPDFT_USER_ID VARCHAR2 30 YES
GJBPDFT_VALUE VARCHAR2 30 YES
GJBPDFT_JPRM_CODE VARCHAR2 15 YES
Date: 24-MAY-2004 Page: 9
TABLE: GJBPVAL_INSTALL
CREATOR: SATURN
saturn GJBPVAL rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPVAL_JOB VARCHAR2 30 NO
GJBPVAL_NUMBER VARCHAR2 2 NO
GJBPVAL_VALUE VARCHAR2 30 NO
GJBPVAL_DESC VARCHAR2 30 NO
GJBPVAL_ACTIVITY_DATE DATE 7 NO
Date: 24-MAY-2004 Page: 10
TABLE: GUBBHLP_INSTALL
CREATOR: SATURN
saturn GUBBHLP rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBBHLP_FORM_NAME VARCHAR2 30 NO
GUBBHLP_BLOCK_NAME VARCHAR2 30 YES
GUBBHLP_FIELD_NAME VARCHAR2 30 YES
GUBBHLP_TEXT LONG NO
GUBBHLP_ACTIVITY_DATE DATE 7 NO
Date: 24-MAY-2004 Page: 11
TABLE: GUBOBJS_INSTALL
CREATOR: SATURN
saturn GUBOBJS rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBOBJS_NAME VARCHAR2 30 NO
GUBOBJS_DESC VARCHAR2 80 NO
GUBOBJS_OBJT_CODE VARCHAR2 10 NO
GUBOBJS_SYSI_CODE VARCHAR2 2 NO
GUBOBJS_USER_ID VARCHAR2 30 NO
GUBOBJS_ACTIVITY_DATE DATE 7 NO
GUBOBJS_HELP_IND VARCHAR2 1 NO
GUBOBJS_EXTRACT_ENABLED_IND VARCHAR2 1 NO
Date: 24-MAY-2004 Page: 12
TABLE: GURAOBJ_INSTALL
CREATOR: SATURN
saturn GURAOBJ rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURAOBJ_OBJECT VARCHAR2 30 NO
GURAOBJ_DEFAULT_ROLE VARCHAR2 30 NO
GURAOBJ_CURRENT_VERSION VARCHAR2 10 NO
GURAOBJ_SYSI_CODE VARCHAR2 2 NO
GURAOBJ_ACTIVITY_DATE DATE 7 NO
GURAOBJ_CHECKSUM VARCHAR2 30 YES
Date: 24-MAY-2004 Page: 13
TABLE: GURDMOD_INSTALL
CREATOR: SATURN
saturn GURDMOD rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURDMOD_CODE VARCHAR2 30 YES
GURDMOD_DATE DATE 7 YES
GURDMOD_APPLIED_BY_USER VARCHAR2 30 YES
GURDMOD_OBJECT VARCHAR2 30 YES
GURDMOD_DESC VARCHAR2 255 YES
Date: 24-MAY-2004 Page: 14
TABLE: GURMENU_INSTALL
CREATOR: SATURN
saturn GURMENU rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURMENU_NAME VARCHAR2 30 NO
GURMENU_OBJ_NAME VARCHAR2 30 NO
GURMENU_SORT_SEQ NUMBER NO
GURMENU_USER_ID VARCHAR2 30 NO
GURMENU_ACTIVITY_DATE DATE 7 NO
GURMENU_DESC VARCHAR2 80 YES
Date: 24-MAY-2004 Page: 15
TABLE: GUROPTM_INSTALL
CREATOR: SATURN
saturn GUROPTM rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUROPTM_SORT_SEQ NUMBER 5 2 YES
GUROPTM_TYPE_IND VARCHAR2 1 NO
GUROPTM_FORM_NAME VARCHAR2 30 NO
GUROPTM_NAME1 VARCHAR2 30 NO
GUROPTM_NAME1_DESC VARCHAR2 60 YES
GUROPTM_NAME2 VARCHAR2 61 YES
GUROPTM_CAPACITY VARCHAR2 1 YES
GUROPTM_TRG_NAME VARCHAR2 30 YES
GUROPTM_TRG_TYPE VARCHAR2 1 YES
GUROPTM_BLOCK_VALID VARCHAR2 30 YES
GUROPTM_ACTIVITY_DATE DATE 7 YES
GUROPTM_USER_ID VARCHAR2 30 NO
GUROPTM_FORM_TO_BE_CALLED VARCHAR2 30 YES
Date: 24-MAY-2004 Page: 16
TABLE: MB_TEMP_ZZZ
CREATOR: SATURN
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
EMPLID VARCHAR2 11 YES
EMPL_RCD_NBR NUMBER 4 YES
EFFDT DATE 7 YES
EFFSEQ NUMBER 4 YES
NAME VARCHAR2 40 YES
NAME_PREFIX VARCHAR2 4 YES
EMAIL_ADDRESS VARCHAR2 70 YES
STREET1 VARCHAR2 30 YES
STREET2 VARCHAR2 30 YES
CITY VARCHAR2 17 YES
STATE VARCHAR2 2 YES
ZIP VARCHAR2 10 YES
COUNTRY VARCHAR2 3 YES
HOME_PHONE VARCHAR2 12 YES
CAR_PHONE VARCHAR2 12 YES
SSN VARCHAR2 9 YES
SIN VARCHAR2 9 YES
PER_STATUS VARCHAR2 1 YES
ORIG_HIRE_DT DATE 7 YES
SEX VARCHAR2 1 YES
BIRTHDATE DATE 7 YES
BIRTHPLACE VARCHAR2 30 YES
DT_OF_DEATH DATE 7 YES
MAR_STATUS VARCHAR2 1 YES
MAR_STATUS_DT DATE 7 YES
FORMER_NAME VARCHAR2 40 YES
ETHNIC_GROUP VARCHAR2 1 YES
DISABLED VARCHAR2 1 YES
DISABLED_VET VARCHAR2 1 YES
MILITARY_STATUS VARCHAR2 1 YES
HIGHEST_EDUC_LVL VARCHAR2 1 YES
CITIZENSHIP_CNTRY VARCHAR2 3 YES
CITIZENSHIP_CNTRY2 VARCHAR2 3 YES
CITIZENSHIP_CNTRY3 VARCHAR2 3 YES
CITIZENSHIP_STATUS VARCHAR2 1 YES
US_WORK_ELIGIBILTY VARCHAR2 1 YES
VISA_NBR VARCHAR2 15 YES
VISA_EXPIRE_DT DATE 7 YES
VISA_TYPE VARCHAR2 2 YES
PASSPORT_NBR VARCHAR2 15 YES
PASSPORT_EXPIRE_DT DATE 7 YES
Date: 24-MAY-2004 Page: 17
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PASSPORT_COUNTRY VARCHAR2 3 YES
HIRE_DT DATE 7 YES
REHIRE_DT DATE 7 YES
CMPNY_SENIORITY_DT DATE 7 YES
SERVICE_DT DATE 7 YES
EXPECTED_RETURN_DT DATE 7 YES
TERMINATION_DT DATE 7 YES
LAST_DATE_WORKED DATE 7 YES
SUITABLE_FOR_REHIR VARCHAR2 1 YES
OWN_5PERCENT_CO VARCHAR2 1 YES
REFERRAL_SOURCE VARCHAR2 2 YES
BUSINESS_TITLE VARCHAR2 30 YES
FT_STUDENT VARCHAR2 1 YES
SUPERVISOR_ID VARCHAR2 11 YES
UNITED_WAY_AREACD VARCHAR2 2 YES
UNION_CD VARCHAR2 4 YES
BARG_UNIT VARCHAR2 1 YES
UNION_SENIORITY_DT DATE 7 YES
PROBATION_DT DATE 7 YES
CREDIT_ASSOC_ID VARCHAR2 10 YES
SECURITY_CLEARANCE VARCHAR2 1 YES
WORK_PHONE VARCHAR2 12 YES
PROFILE_UPDATE_DT DATE 7 YES
LAST_PROFILE_DT DATE 7 YES
DEPTID VARCHAR2 10 YES
JOBCODE VARCHAR2 6 YES
POSITION_NBR VARCHAR2 8 YES
EMPL_STATUS VARCHAR2 1 YES
ACTION VARCHAR2 3 YES
ACTION_DT DATE 7 YES
ACTION_REASON VARCHAR2 3 YES
LOCATION VARCHAR2 5 YES
JOB_ENTRY_DT DATE 7 YES
SHIFT VARCHAR2 1 YES
REG_TEMP VARCHAR2 1 YES
FULL_PART_TIME VARCHAR2 1 YES
FLSA_STATUS VARCHAR2 1 YES
OFFICER_CD VARCHAR2 1 YES
COMPANY VARCHAR2 3 YES
PAYGROUP VARCHAR2 3 YES
EMPL_TYPE VARCHAR2 1 YES
HOLIDAY_SCHEDULE VARCHAR2 4 YES
STD_HOURS NUMBER 4 2 YES
EEO_CLASS VARCHAR2 1 YES
SAL_ADMIN_PLAN VARCHAR2 3 YES
Date: 24-MAY-2004 Page: 18
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GRADE VARCHAR2 3 YES
GRADE_ENTRY_DT DATE 7 YES
STEP NUMBER 4 YES
STEP_ENTRY_DT DATE 7 YES
GL_PAY_TYPE VARCHAR2 6 YES
COMP_FREQUENCY VARCHAR2 1 YES
COMPRATE NUMBER 11 3 YES
CHANGE_AMT NUMBER 11 3 YES
CHANGE_PCT NUMBER 6 3 YES
ANNUAL_RT NUMBER 10 2 YES
MONTHLY_RT NUMBER 9 2 YES
HOURLY_RT NUMBER 7 3 YES
ANNL_BENEF_BASE_RT NUMBER 10 2 YES
SHIFT_RT NUMBER 6 3 YES
SHIFT_FACTOR NUMBER 4 3 YES
CURRENCY_CD VARCHAR2 3 YES
JOBTITLE VARCHAR2 30 YES
JOBTITLE_ABBRV VARCHAR2 10 YES
EEO1CODE VARCHAR2 1 YES
EEO4CODE VARCHAR2 1 YES
EEO5CODE VARCHAR2 2 YES
EEO6CODE VARCHAR2 1 YES
EEO_JOB_GROUP VARCHAR2 2 YES
JOB_FAMILY VARCHAR2 6 YES
DEPTNAME VARCHAR2 30 YES
DEPTNAME_ABBRV VARCHAR2 10 YES
MANAGER_ID VARCHAR2 11 YES
EEO4_FUNCTION VARCHAR2 2 YES
FROMDATE DATE 7 YES
ASOFDATE DATE 7 YES
FILE_NBR VARCHAR2 6 YES
PEBEMPL_PIDM NUMBER 8 NO
PEBEMPL_EMPL_STATUS VARCHAR2 1 NO
PEBEMPL_COAS_CODE_HOME VARCHAR2 1 YES
PEBEMPL_ORGN_CODE_HOME VARCHAR2 6 NO
PEBEMPL_COAS_CODE_DIST VARCHAR2 1 YES
PEBEMPL_ORGN_CODE_DIST VARCHAR2 6 NO
PEBEMPL_ECLS_CODE VARCHAR2 2 NO
PEBEMPL_LCAT_CODE VARCHAR2 2 NO
PEBEMPL_BCAT_CODE VARCHAR2 2 NO
PEBEMPL_FIRST_HIRE_DATE DATE 7 NO
PEBEMPL_CURRENT_HIRE_DATE DATE 7 NO
PEBEMPL_ADJ_SERVICE_DATE DATE 7 NO
PEBEMPL_SENIORITY_DATE DATE 7 NO
PEBEMPL_LREA_CODE VARCHAR2 2 YES
Date: 24-MAY-2004 Page: 19
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEBEMPL_LOA_BEG_DATE DATE 7 YES
PEBEMPL_LOA_END_DATE DATE 7 YES
PEBEMPL_TREA_CODE VARCHAR2 2 YES
PEBEMPL_TERM_DATE DATE 7 YES
PEBEMPL_I9_FORM_IND VARCHAR2 1 YES
PEBEMPL_I9_DATE DATE 7 YES
PEBEMPL_I9_EXPIRE_DATE DATE 7 YES
PEBEMPL_ACTIVITY_DATE DATE 7 NO
PEBEMPL_WKPR_CODE VARCHAR2 4 YES
PEBEMPL_FLSA_IND VARCHAR2 1 NO
PEBEMPL_STGR_CODE VARCHAR2 2 YES
PEBEMPL_DAYS_IN_CANADA NUMBER 3 YES
PEBEMPL_1042_RECIPIENT_CD VARCHAR2 2 YES
PEBEMPL_INTERNAL_FT_PT_IND VARCHAR2 1 NO
PEBEMPL_DICD_CODE VARCHAR2 3 YES
PEBEMPL_EGRP_CODE VARCHAR2 4 YES
PEBEMPL_IPEDS_SOFT_MONEY_IND VARCHAR2 1 YES
PEBEMPL_FIRST_WORK_DATE DATE 7 YES
PEBEMPL_LAST_WORK_DATE DATE 7 YES
PEBEMPL_CALIF_PENSION_IND VARCHAR2 1 YES
PEBEMPL_NRSI_CODE VARCHAR2 4 YES
PEBEMPL_SSN_LAST_NAME VARCHAR2 20 YES
PEBEMPL_SSN_FIRST_NAME VARCHAR2 15 YES
PEBEMPL_SSN_MI VARCHAR2 15 YES
PEBEMPL_SSN_SUFFIX VARCHAR2 4 YES
SPRIDEN_PIDM NUMBER 8 NO
SPRIDEN_ID VARCHAR2 9 NO
SPRIDEN_LAST_NAME VARCHAR2 60 NO
SPRIDEN_FIRST_NAME VARCHAR2 15 YES
SPRIDEN_MI VARCHAR2 15 YES
SPRIDEN_CHANGE_IND VARCHAR2 1 YES
SPRIDEN_ENTITY_IND VARCHAR2 1 YES
SPRIDEN_ACTIVITY_DATE DATE 7 NO
SPRIDEN_USER VARCHAR2 30 YES
SPRIDEN_ORIGIN VARCHAR2 30 YES
SPRIDEN_SEARCH_LAST_NAME VARCHAR2 60 YES
SPRIDEN_SEARCH_FIRST_NAME VARCHAR2 15 YES
SPRIDEN_SEARCH_MI VARCHAR2 15 YES
SPRIDEN_SOUNDEX_LAST_NAME CHAR 4 YES
SPRIDEN_SOUNDEX_FIRST_NAME CHAR 4 YES
SPRIDEN_NTYP_CODE VARCHAR2 4 YES
SPBPERS_PIDM NUMBER 8 NO
SPBPERS_SSN VARCHAR2 9 YES
SPBPERS_BIRTH_DATE DATE 7 YES
SPBPERS_LGCY_CODE VARCHAR2 1 YES
Date: 24-MAY-2004 Page: 20
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SPBPERS_ETHN_CODE VARCHAR2 2 YES
SPBPERS_MRTL_CODE VARCHAR2 1 YES
SPBPERS_RELG_CODE VARCHAR2 2 YES
SPBPERS_SEX VARCHAR2 1 YES
SPBPERS_CONFID_IND VARCHAR2 1 YES
SPBPERS_DEAD_IND VARCHAR2 1 YES
SPBPERS_VETC_FILE_NUMBER VARCHAR2 10 YES
SPBPERS_LEGAL_NAME VARCHAR2 60 YES
SPBPERS_PREF_FIRST_NAME VARCHAR2 15 YES
SPBPERS_NAME_PREFIX VARCHAR2 20 YES
SPBPERS_NAME_SUFFIX VARCHAR2 20 YES
SPBPERS_ACTIVITY_DATE DATE 7 NO
SPBPERS_VERA_IND VARCHAR2 1 YES
SPBPERS_CITZ_IND VARCHAR2 1 YES
SPBPERS_DEAD_DATE DATE 7 YES
SPBPERS_PIN RAW 1 YES
SPBPERS_CITZ_CODE VARCHAR2 2 YES
SPBPERS_HAIR_CODE VARCHAR2 2 YES
SPBPERS_EYES_CODE VARCHAR2 2 YES
SPBPERS_CITY_BIRTH VARCHAR2 20 YES
SPBPERS_STAT_CODE_BIRTH VARCHAR2 3 YES
SPBPERS_DRIVER_LICENSE VARCHAR2 20 YES
SPBPERS_STAT_CODE_DRIVER VARCHAR2 3 YES
SPBPERS_NATN_CODE_DRIVER VARCHAR2 5 YES
SPBPERS_UOMS_CODE_HEIGHT VARCHAR2 4 YES
SPBPERS_HEIGHT NUMBER 2 YES
SPBPERS_UOMS_CODE_WEIGHT VARCHAR2 4 YES
SPBPERS_WEIGHT NUMBER 4 YES
SPBPERS_SDVET_IND VARCHAR2 1 YES
SPBPERS_LICENSE_ISSUED_DATE DATE 7 YES
SPBPERS_LICENSE_EXPIRES_DATE DATE 7 YES
SPBPERS_INCAR_IND VARCHAR2 1 YES
SPBPERS_WEBID RAW 1 YES
SPBPERS_WEB_LAST_ACCESS RAW 1 YES
SPBPERS_PIN_DISABLED_IND RAW 1 YES
SPBPERS_ITIN NUMBER 9 YES
SPRADDR_PIDM NUMBER 8 NO
SPRADDR_ATYP_CODE VARCHAR2 2 NO
SPRADDR_SEQNO NUMBER 2 NO
SPRADDR_FROM_DATE DATE 7 YES
SPRADDR_TO_DATE DATE 7 YES
SPRADDR_STREET_LINE1 VARCHAR2 30 YES
SPRADDR_STREET_LINE2 VARCHAR2 30 YES
SPRADDR_STREET_LINE3 VARCHAR2 30 YES
SPRADDR_CITY VARCHAR2 20 NO
Date: 24-MAY-2004 Page: 21
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SPRADDR_STAT_CODE VARCHAR2 3 YES
SPRADDR_ZIP VARCHAR2 10 YES
SPRADDR_CNTY_CODE VARCHAR2 5 YES
SPRADDR_NATN_CODE VARCHAR2 5 YES
SPRADDR_PHONE_AREA VARCHAR2 3 YES
SPRADDR_PHONE_NUMBER VARCHAR2 7 YES
SPRADDR_PHONE_EXT VARCHAR2 4 YES
SPRADDR_STATUS_IND VARCHAR2 1 YES
SPRADDR_ACTIVITY_DATE DATE 7 NO
SPRADDR_USER VARCHAR2 30 YES
SPRADDR_ASRC_CODE VARCHAR2 4 YES
SPRADDR_DELIVERY_POINT NUMBER 2 YES
SPRADDR_CORRECTION_DIGIT NUMBER 1 YES
SPRADDR_CARRIER_ROUTE VARCHAR2 4 YES
SPRADDR_GST_TAX_ID VARCHAR2 15 YES
SPRADDR_REVIEWED_IND VARCHAR2 1 YES
SPRADDR_REVIEWED_USER VARCHAR2 30 YES
SPRTELE_PIDM NUMBER 8 NO
SPRTELE_SEQNO NUMBER 3 NO
SPRTELE_TELE_CODE VARCHAR2 4 NO
SPRTELE_ACTIVITY_DATE DATE 7 NO
SPRTELE_PHONE_AREA VARCHAR2 3 YES
SPRTELE_PHONE_NUMBER VARCHAR2 7 YES
SPRTELE_PHONE_EXT VARCHAR2 4 YES
SPRTELE_STATUS_IND VARCHAR2 1 YES
SPRTELE_ATYP_CODE VARCHAR2 2 YES
SPRTELE_ADDR_SEQNO NUMBER 2 YES
SPRTELE_PRIMARY_IND VARCHAR2 1 YES
SPRTELE_UNLIST_IND VARCHAR2 1 YES
SPRTELE_COMMENT VARCHAR2 60 YES
SPRTELE_INTL_ACCESS VARCHAR2 16 YES
Date: 24-MAY-2004 Page: 22
SEQUENCE: SABASEQ
CREATOR: SATURN
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999
Increment: 1
Last Number: 90
Cache Size: 20
Order Option: ORDERED
Cycle Option: NOCYCLE
Date: 24-MAY-2004 Page: 23
TABLE: SABAUDF
CREATOR: SATURN
Application User Defined Fields Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABAUDF_TERM_CODE_EFF VARCHAR2 6 NO This is the effective term.
SABAUDF_FLAG1_DESC VARCHAR2 20 YES
SABAUDF_FLAG2_DESC VARCHAR2 20 YES
SABAUDF_FLAG3_DESC VARCHAR2 20 YES
SABAUDF_FLAG4_DESC VARCHAR2 20 YES
SABAUDF_FLAG5_DESC VARCHAR2 20 YES
SABAUDF_FLAG6_DESC VARCHAR2 20 YES
SABAUDF_FLAG7_DESC VARCHAR2 20 YES
SABAUDF_FLAG8_DESC VARCHAR2 20 YES
SABAUDF_FLAG9_DESC VARCHAR2 20 YES
SABAUDF_FLAG10_DESC VARCHAR2 20 YES
SABAUDF_DATA1_DESC VARCHAR2 20 YES
SABAUDF_DATA2_DESC VARCHAR2 20 YES
SABAUDF_DATA3_DESC VARCHAR2 20 YES
SABAUDF_DATA4_DESC VARCHAR2 20 YES
SABAUDF_DATA5_DESC VARCHAR2 20 YES
SABAUDF_DATA6_DESC VARCHAR2 20 YES
SABAUDF_DATA7_DESC VARCHAR2 20 YES
SABAUDF_DATA8_DESC VARCHAR2 20 YES
SABAUDF_DATA9_DESC VARCHAR2 20 YES
SABAUDF_DATA10_DESC VARCHAR2 20 YES
SABAUDF_DATA11_DESC VARCHAR2 20 YES
SABAUDF_DATA12_DESC VARCHAR2 20 YES
SABAUDF_DATA13_DESC VARCHAR2 20 YES
SABAUDF_DATA14_DESC VARCHAR2 20 YES
SABAUDF_DATA15_DESC VARCHAR2 20 YES
SABAUDF_DATA16_DESC VARCHAR2 20 YES
SABAUDF_DATA17_DESC VARCHAR2 20 YES
SABAUDF_DATA18_DESC VARCHAR2 20 YES
SABAUDF_DATA19_DESC VARCHAR2 20 YES
SABAUDF_DATA20_DESC VARCHAR2 20 YES
SABAUDF_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
Date: 24-MAY-2004 Page: 24
TABLE: SABBTCH
CREATOR: SATURN
Admission Report Id Selection Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABBTCH_PIDM NUMBER 8 NO Internal identification number of student.
SABBTCH_TERM_CODE VARCHAR2 6 NO This field identifies the term for which information
is to be generated.
SABBTCH_APPL_NO NUMBER 4 NO This field identifies the application number
associated with the student record.
SABBTCH_JOB_NAME VARCHAR2 7 NO This field identifies the name of the job to be
generated.
SABBTCH_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 25
TABLE: SABECRL
CREATOR: SATURN
Electronic Admissions Control Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABECRL_WAPP_CODE VARCHAR2 2 NO Web Application Code
SABECRL_PROC_LABEL VARCHAR2 5 NO Procedure Label
SABECRL_PROC_LABEL_DESC VARCHAR2 30 NO Procedure Label Description
SABECRL_REQUIRED_IND VARCHAR2 1 NO Procedure Required Indicator
SABECRL_OVERRIDE_IND VARCHAR2 1 NO Procedure Over-Ride Indicator
SABECRL_SYSTEM_REQ_IND VARCHAR2 1 NO System Requirement Indicator
SABECRL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 24-MAY-2004 Page: 26
TABLE: SABECTM
CREATOR: SATURN
EDI Cross-Reference Term Code Rules
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABECTM_START_DATE DATE 7 NO Starting Date of Date Range for associated Term
SABECTM_END_DATE DATE 7 NO End Date of Date Range for associated Term
SABECTM_TERM_CODE VARCHAR2 6 NO Term associated with the Date Range
SABECTM_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 24-MAY-2004 Page: 27
TABLE: SABIDEN
CREATOR: SATURN
Person ID Control Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABIDEN_AIDM NUMBER 8 NO Person Reference Number
SABIDEN_PIDM NUMBER 8 NO Person PIDM Reference
SABIDEN_SRCE_IND VARCHAR2 1 NO Source of Record
SABIDEN_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SABIDEN_ID_EDI VARCHAR2 9 YES EDI ID
Date: 24-MAY-2004 Page: 28
SEQUENCE: SABISEQ
CREATOR: SATURN
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999
Increment: 1
Last Number: 1
Cache Size: 20
Order Option: ORDERED
Cycle Option: NOCYCLE
Date: 24-MAY-2004 Page: 29
TABLE: SABNSTU
CREATOR: SATURN
Electronic Admissions Non-Student Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABNSTU_ID VARCHAR2 9 NO ID NUmber
SABNSTU_AIDM NUMBER 8 NO Person Reference Number
SABNSTU_LOCKED_IND VARCHAR2 1 NO Web Access Lock Indicator
SABNSTU_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SABNSTU_XMIT_SEQNO NUMBER 8 YES EDI Transmission Packet Reference
SABNSTU_PIN VARCHAR2 6 YES Individuals Selected PIN Number
SABNSTU_APPID VARCHAR2 6 YES WWW Update Control String
SABNSTU_WEB_LAST_ACCESS DATE 7 YES Date and Time of Last Web Access
SABNSTU_LAST_LOGIN_DATE DATE 7 YES Last Date and Time of Web Login
SABNSTU_LOGIN_ATTEMPTS NUMBER 2 YES Number of Web Login Attempts
SABNSTU_PREV_APPID VARCHAR2 6 YES Previous Application ID
Date: 24-MAY-2004 Page: 30
TABLE: SABSTUD
CREATOR: SATURN
Electronic Admissions Student Record Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABSTUD_PIDM NUMBER 8 NO Student PIDM Reference
SABSTUD_AIDM NUMBER 8 NO Person Reference Number
SABSTUD_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 24-MAY-2004 Page: 31
TABLE: SABSUPL
CREATOR: SATURN
Application Supplemental Information Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABSUPL_PIDM NUMBER 8 NO
SABSUPL_TERM_CODE_ENTRY VARCHAR2 6 NO
SABSUPL_APPL_NO NUMBER 2 NO
SABSUPL_CNTY_CODE_ADMIT VARCHAR2 5 YES
SABSUPL_CNTY_ADMIT_RURAL VARCHAR2 1 YES
SABSUPL_STAT_CODE_ADMIT VARCHAR2 3 YES
SABSUPL_NATN_CODE_ADMIT VARCHAR2 5 YES
SABSUPL_CITY_BIRTH VARCHAR2 20 YES
SABSUPL_CNTY_CODE_BIRTH VARCHAR2 5 YES
SABSUPL_CNTY_BIRTH_RURAL VARCHAR2 1 YES
SABSUPL_STAT_CODE_BIRTH VARCHAR2 3 YES
SABSUPL_NATN_CODE_BIRTH VARCHAR2 5 YES
SABSUPL_SBGI_CODE_ADMIT VARCHAR2 6 YES
SABSUPL_ETHN_CODE_SELF VARCHAR2 2 YES
SABSUPL_ESEL_CODE VARCHAR2 2 YES
SABSUPL_NUMBER_DEPS NUMBER 2 YES
SABSUPL_AGENCY_FILE_NO VARCHAR2 10 YES
SABSUPL_APP_YEAR_AGENCY NUMBER 4 YES
SABSUPL_PREV_APP_1 NUMBER 4 YES
SABSUPL_PREV_APP_2 NUMBER 4 YES
SABSUPL_PREV_APP_3 NUMBER 4 YES
SABSUPL_PREV_APP_4 NUMBER 4 YES
SABSUPL_AGENCY_FEE_WAIVED VARCHAR2 1 YES
SABSUPL_CYCLE_ADDED NUMBER 3 YES
SABSUPL_CYCLE_CHANGED NUMBER 3 YES
SABSUPL_AGENCY_REPORT_DATE DATE 7 YES
SABSUPL_FLAG1 VARCHAR2 1 YES
SABSUPL_FLAG2 VARCHAR2 1 YES
SABSUPL_FLAG3 VARCHAR2 1 YES
SABSUPL_FLAG4 VARCHAR2 1 YES
SABSUPL_FLAG5 VARCHAR2 1 YES
SABSUPL_FLAG6 VARCHAR2 1 YES
SABSUPL_FLAG7 VARCHAR2 1 YES
SABSUPL_FLAG8 VARCHAR2 1 YES
SABSUPL_FLAG9 VARCHAR2 1 YES
SABSUPL_FLAG10 VARCHAR2 1 YES
SABSUPL_INST_DATA1 VARCHAR2 60 YES
SABSUPL_INST_DATA2 VARCHAR2 60 YES
SABSUPL_INST_DATA3 VARCHAR2 60 YES
Date: 24-MAY-2004 Page: 32
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABSUPL_INST_DATA4 VARCHAR2 60 YES
SABSUPL_INST_DATA5 VARCHAR2 60 YES
SABSUPL_INST_DATA6 VARCHAR2 60 YES
SABSUPL_INST_DATA7 VARCHAR2 60 YES
SABSUPL_INST_DATA8 VARCHAR2 60 YES
SABSUPL_INST_DATA9 VARCHAR2 60 YES
SABSUPL_INST_DATA10 VARCHAR2 60 YES
SABSUPL_INST_DATA11 VARCHAR2 60 YES
SABSUPL_INST_DATA12 VARCHAR2 60 YES
SABSUPL_INST_DATA13 VARCHAR2 60 YES
SABSUPL_INST_DATA14 VARCHAR2 60 YES
SABSUPL_INST_DATA15 VARCHAR2 60 YES
SABSUPL_INST_DATA16 VARCHAR2 60 YES
SABSUPL_INST_DATA17 VARCHAR2 60 YES
SABSUPL_INST_DATA18 VARCHAR2 60 YES
SABSUPL_INST_DATA19 VARCHAR2 60 YES
SABSUPL_INST_DATA20 VARCHAR2 60 YES
SABSUPL_ACTIVITY_DATE DATE 7 YES
SABSUPL_EFFEC_DATE DATE 7 YES Date when the application data was last updated by
AMCAS.
SABSUPL_APPL_TYPE VARCHAR2 1 YES AMCAS application type code.
SABSUPL_BIO_NUMBER VARCHAR2 22 YES Bio number assigned by AMCAS.
SABSUPL_HISP_IND VARCHAR2 1 YES AMCAS Hispanic ethnicity indicator.
SABSUPL_URM_IND VARCHAR2 1 YES AMCAS Under-represented Minority indicator.
SABSUPL_RACE1 VARCHAR2 2 YES Race code reported by AMCAS.
SABSUPL_RACE2 VARCHAR2 2 YES Race code reported by AMCAS.
SABSUPL_RACE3 VARCHAR2 2 YES Race code reported by AMCAS.
SABSUPL_RACE4 VARCHAR2 2 YES Race code reported by AMCAS.
SABSUPL_RACE5 VARCHAR2 2 YES Race code reported by AMCAS.
SABSUPL_RACE6 VARCHAR2 2 YES Race code reported by AMCAS.
SABSUPL_RACE7 VARCHAR2 2 YES Race code reported by AMCAS.
SABSUPL_RACE8 VARCHAR2 2 YES Race code reported by AMCAS.
SABSUPL_RACE9 VARCHAR2 2 YES Race code reported by AMCAS.
SABSUPL_RACE10 VARCHAR2 2 YES Race code reported by AMCAS.
SABSUPL_ETHNIC1 VARCHAR2 2 YES Ethnic code reported by AMCAS.
SABSUPL_ETHNIC2 VARCHAR2 2 YES Ethnic code reported by AMCAS.
SABSUPL_ETHNIC3 VARCHAR2 2 YES Ethnic code reported by AMCAS.
SABSUPL_ETHNIC4 VARCHAR2 2 YES Ethnic code reported by AMCAS.
SABSUPL_ETHNIC5 VARCHAR2 2 YES Ethnic code reported by AMCAS.
SABSUPL_ETHNIC6 VARCHAR2 2 YES Ethnic code reported by AMCAS.
SABSUPL_ETHNIC7 VARCHAR2 2 YES Ethnic code reported by AMCAS.
SABSUPL_ETHNIC8 VARCHAR2 2 YES Ethnic code reported by AMCAS.
SABSUPL_ETHNIC9 VARCHAR2 2 YES Ethnic code reported by AMCAS.
SABSUPL_ETHNIC10 VARCHAR2 2 YES Ethnic code reported by AMCAS.
Date: 24-MAY-2004 Page: 33
TABLE: SABVWID
CREATOR: SATURN
Admission Decision View Selection Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABVWID_SID VARCHAR2 30 NO This field identifies the system assigned unique
session identification number.
SABVWID_PIDM NUMBER 8 NO This field identifies the internal student
identification number.
SABVWID_TERM_CODE VARCHAR2 6 NO This field identifies the term code.
SABVWID_APPL_NO NUMBER 4 NO This field identifies the application number.
SABVWID_JOB_NAME VARCHAR2 7 YES
SABVWID_ACTIVITY_DATE DATE 7 NO This field identifies the last date the SABVWID record
was updated.
Date: 24-MAY-2004 Page: 34
TABLE: SABXMIT
CREATOR: SATURN
Electronic Admissions Transmission Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABXMIT_XMIT_SEQNO NUMBER 8 NO Person Control Sequence Number
SABXMIT_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SABXMIT_CONTROL_NO VARCHAR2 9 YES Transactions Set Control Number(ST02 - 329)
SABXMIT_PRPS_CDE VARCHAR2 2 YES Transaction Set Purpose Code (BGN01 - 353)
SABXMIT_REFERENCE_ID VARCHAR2 30 YES Reference Identification (BGN02 - 127)
SABXMIT_ORIG_DTE VARCHAR2 6 YES Origination Date of Record (BGN03 - 373)
SABXMIT_ORIG_TIME VARCHAR2 8 YES Origination Time of Record (BGN04 - 337)
SABXMIT_TIME_CDE VARCHAR2 2 YES Time Code (BGN05 - 623)
SABXMIT_ENTY_CDE_SNDR VARCHAR2 2 YES Entity Code of Sender (N1-N101 - 98)
SABXMIT_NAME1_SNDR VARCHAR2 35 YES Name 1 of Sender (N1 - N102 - 93)
SABXMIT_IDQL_CDE_SNDR VARCHAR2 2 YES ID Qualifier Code of Sender (N1-N103 - 66)
SABXMIT_IDEN_CDE_SNDR VARCHAR2 20 YES ID of Sender (N1 - N104 - 67)
SABXMIT_NAME2_SNDR VARCHAR2 35 YES Name 2 of Sender (N1 - N201 - 93)
SABXMIT_NAME3_SNDR VARCHAR2 35 YES Name 3 of Sender (N1 - N202 - 93)
SABXMIT_STREET_LINE1_SNDR VARCHAR2 35 YES Street Line 1 of Sender (N1-N301 - 166)
SABXMIT_STREET_LINE2_SNDR VARCHAR2 35 YES Street Line 2 of Sender (N1-N302 - 166)
SABXMIT_CITY_SNDR VARCHAR2 30 YES City of Sender (N1-N401-19)
SABXMIT_STAT_CDE_SNDR VARCHAR2 2 YES State Code of Sender(N1-N402-156)
SABXMIT_ZIP_SNDR VARCHAR2 15 YES Zip Code of Sender (N1-N403-116)
SABXMIT_NATN_CDE_SNDR VARCHAR2 3 YES Nation Code of Sender (N1-N404 - 26)
SABXMIT_LCQL_CDE_SNDR VARCHAR2 2 YES Location Qualifier of Sender (N1-N405-309)
SABXMIT_LOC_ID_SNDR VARCHAR2 30 YES Location Identifier of Sender(N1-N406-310)
SABXMIT_CFNC_CDE_SNDR VARCHAR2 2 YES Contact Function Code of Sender (N1-PER01-366)
SABXMIT_CNTCT_NAME_SNDR VARCHAR2 35 YES Sender Contact Name (N1-PER02-93)
SABXMIT_PQLF_CDE1_SNDR VARCHAR2 2 YES Contact Phone Number 1 Qualifier (N1-PER03-365)
SABXMIT_PHONE_NO1_SNDR VARCHAR2 80 YES Contact Phone Number 1 (N1-PER04-364)
SABXMIT_PQLF_CDE2_SNDR VARCHAR2 2 YES Contact Phone Number 2 Qualifier (N1-PER05-365)
SABXMIT_PHONE_NO2_SNDR VARCHAR2 80 YES Contact Phone Number 2 (N1-PER06-364)
SABXMIT_PQLF_CDE3_SNDR VARCHAR2 2 YES Contact Phone Number 3 Qualifier (N1-PER07-365)
SABXMIT_PHONE_NO3_SNDR VARCHAR2 80 YES Contact Phone Number 3 (N1-PER08-364)
SABXMIT_ENTY_CDE_RCVR VARCHAR2 2 YES Receiver Entity Code (N1-N101-98)
SABXMIT_NAME1_RCVR VARCHAR2 35 YES Receiver Name 1 (N1-N102-93)
SABXMIT_IDQL_CDE_RCVR VARCHAR2 2 YES Receiver ID Qualifier (N1-N103-66)
SABXMIT_IDEN_CDE_RCVR VARCHAR2 20 YES Receiver ID Code (N1-N104-67)
SABXMIT_NAME2_RCVR VARCHAR2 35 YES Receiver Name 2 (N1-N201-93)
SABXMIT_NAME3_RCVR VARCHAR2 35 YES Receiver Name 3 (N1-N202-93)
SABXMIT_STREET_LINE1_RCVR VARCHAR2 35 YES Receiver Street Line 1 (N1-N301-166)
SABXMIT_STREET_LINE2_RCVR VARCHAR2 35 YES Receiver Street Line 2 (N1-N302-166)
SABXMIT_CITY_RCVR VARCHAR2 30 YES Receiver City (N1-N401-19)
Date: 24-MAY-2004 Page: 35
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SABXMIT_STAT_CDE_RCVR VARCHAR2 2 YES Receiver State Code (N1-N402-156)
SABXMIT_ZIP_RCVR VARCHAR2 15 YES Receiver Zip Code (N1-N403-116)
SABXMIT_NATN_CDE_RCVR VARCHAR2 3 YES Receiver Nation Code (N1-N404-26)
SABXMIT_LCQL_CDE_RCVR VARCHAR2 2 YES Receiver Location Qualifier (N1-N405-309)
SABXMIT_LOC_ID_RCVR VARCHAR2 30 YES Receiver Location ID (N1-N406-310)
SABXMIT_CFNC_CDE_RCVR VARCHAR2 2 YES Receiver Contact Function Code (N1-PER01-366)
SABXMIT_CNTCT_NAME_RCVR VARCHAR2 35 YES Contact Name (N1-PER02-93)
SABXMIT_PQLF_CDE1_RCVR VARCHAR2 2 YES Receiver Contact Phone 1 Qualifier (N1-PER03-365)
SABXMIT_PHONE_NO1_RCVR VARCHAR2 80 YES Receiver Contact Phone 1 (N1-PER04-364)
SABXMIT_PQLF_CDE2_RCVR VARCHAR2 2 YES Receiver Phone 2 Qualifier (N1-PER05-365)
SABXMIT_PHONE_NO2_RCVR VARCHAR2 80 YES Receiver Phone 2 (N1-PER06-364)
SABXMIT_PQLF_CDE3_RCVR VARCHAR2 2 YES Receiver Phone 3 Qualifier (N1-PER07-365)
SABXMIT_PHONE_NO3_RCVR VARCHAR2 80 YES Receiver Phone 3 (N1-PER)*-364)
SABXMIT_LX_NUMBER VARCHAR2 6 YES Undetermined
Date: 24-MAY-2004 Page: 36
SEQUENCE: SABXSEQ
CREATOR: SATURN
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999
Increment: 1
Last Number: 1
Cache Size: 20
Order Option: ORDERED
Cycle Option: NOCYCLE
Date: 24-MAY-2004 Page: 37
TABLE: SARAATT
CREATOR: SATURN
Admissions Attribute Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARAATT_PIDM NUMBER 8 NO Internal identification number for whom the attributes
are associated with.
SARAATT_TERM_CODE VARCHAR2 6 NO The term associated with the attributes.
SARAATT_APPL_NO NUMBER 2 NO The Application Number associated with the attributes.
SARAATT_ATTS_CODE VARCHAR2 4 NO The admissions attributes for the person and term.
SARAATT_ACTIVITY_DATE DATE 7 NO The date the record was last updated.
Date: 24-MAY-2004 Page: 38
TABLE: SARACMT
CREATOR: SATURN
Application Comments Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARACMT_PIDM NUMBER 8 NO Internal identification number of applicant.
SARACMT_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
application.
SARACMT_APPL_NO NUMBER 2 NO This field identifies the Application number.
SARACMT_SEQNO NUMBER 23 20 NO This field does not display on the form. It
identifies an internal sequence number assigned to
each comment created.
SARACMT_COMMENT_TEXT VARCHAR2 4000 YES This field specifies the Application comment(s)
associated with application record.
SARACMT_ORIG_CODE VARCHAR2 4 NO This field identifies the originator of the comment
associated with application.
SARACMT_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or changed.
Date: 24-MAY-2004 Page: 39
TABLE: SARACTV
CREATOR: SATURN
Electronic Admissions Activities Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARACTV_AIDM NUMBER 8 NO Applicant Reference Number
SARACTV_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARACTV_SEQNO NUMBER 4 NO Sequence Number
SARACTV_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARACTV_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARACTV_PAID_FLAG VARCHAR2 1 YES Paid Flag
SARACTV_SCHOOL_FLAG VARCHAR2 1 YES School Flag
SARACTV_RECRUIT_FLAG VARCHAR2 1 YES Recruit Flag
SARACTV_CQLF_CDE VARCHAR2 3 YES Code List Qualifier Code
SARACTV_ACTV_CDE VARCHAR2 30 YES Industry Code
SARACTV_ACTIVITY_DESC VARCHAR2 132 YES Entity Description
SARACTV_SPONSOR VARCHAR2 132 YES Entity Title
SARACTV_INVLMT_QTY NUMBER 15 YES Quantity
SARACTV_MEAS_CDE VARCHAR2 10 YES Composit Unit of Measurement
SARACTV_ILVL_CDE VARCHAR2 2 YES Level of Individual, Test, or Course
SARACTV_DTQL_CDE1 VARCHAR2 3 YES Date and Time Qualifier
SARACTV_DFMT_CDE1 VARCHAR2 3 YES Date and Time Format Code
SARACTV_REF_DTE1 VARCHAR2 35 YES Date and Time Period
SARACTV_DTQL_CDE2 VARCHAR2 3 YES Date and Time Qualifier 2
SARACTV_DFMT_CDE2 VARCHAR2 3 YES Date and Time Format Code 2
SARACTV_REF_DTE2 VARCHAR2 35 YES Date and Time Period
Date: 24-MAY-2004 Page: 40
TABLE: SARADAP
CREATOR: SATURN
Admissions Application Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARADAP_PIDM NUMBER 8 NO This field identifies the applicant internal
identification number.
SARADAP_TERM_CODE_ENTRY VARCHAR2 6 NO This field identifies the term associated with the
information on applicant record.
SARADAP_APPL_NO NUMBER 2 NO This field identifies the application number of the
admissions record for a specific term.
SARADAP_LEVL_CODE VARCHAR2 2 NO This field identifies the level to which the applicant
is applying.
SARADAP_APPL_DATE DATE 7 NO This field identifies the date of the application
record.
SARADAP_APST_CODE VARCHAR2 1 NO This field identifies the status of the application.
SARADAP_APST_DATE DATE 7 NO This field identifies the date associated with the
most current status of the application.
SARADAP_MAINT_IND VARCHAR2 1 NO This field identifies whether the status of the
application is being maintained by the system or the
user.
SARADAP_ADMT_CODE VARCHAR2 2 YES This field identifies the admission type of the
applicant.
SARADAP_STYP_CODE VARCHAR2 1 NO This field identifies the type of student the
applicant will become if admitted.
SARADAP_CAMP_CODE VARCHAR2 3 YES This field identifies the campus to which applicant is
applying.
SARADAP_SITE_CODE VARCHAR2 3 YES This field identifies the site to which applicant is
applying.
SARADAP_COLL_CODE_1 VARCHAR2 2 NO This field identifies the primary college to which
applicant is applying.
SARADAP_DEGC_CODE_1 VARCHAR2 6 NO This field identifies the primary degree to which
applicant is applying.
SARADAP_MAJR_CODE_1 VARCHAR2 4 NO This field identifies the primary major to which
applicant is applying.
SARADAP_COLL_CODE_2 VARCHAR2 2 YES Curriculum 2 College Code
SARADAP_DEGC_CODE_2 VARCHAR2 6 YES This field identifies the secondary degree to which
applicant is applying.
SARADAP_MAJR_CODE_2 VARCHAR2 4 YES This field identifies the secondary major to which
applicant is applying.
SARADAP_RESD_CODE VARCHAR2 1 NO This field identifies the residency classification of
the applicant.
SARADAP_FULL_PART_IND VARCHAR2 1 YES This field identifies if applicant intention is for
full or part time enrollment.
SARADAP_SESS_CODE VARCHAR2 1 YES This field identifies which session applicant is
applying for.
Date: 24-MAY-2004 Page: 41
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARADAP_WRSN_CODE VARCHAR2 2 YES This field identifies the reason why an application
has been withdrawn.
SARADAP_INTV_CODE VARCHAR2 1 YES This field identifies the status of the interview
associated with the applicant.
SARADAP_FEE_IND VARCHAR2 1 YES This field identifies whether an application fee has
been assessed.
SARADAP_FEE_DATE DATE 7 YES This field identifies the date application fee has
been assessed.
SARADAP_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or changed.
SARADAP_RATE_CODE VARCHAR2 5 YES This field identifies a specific assessment rate
assigned to the student.
SARADAP_EGOL_CODE VARCHAR2 2 YES Educational Goal Code
SARADAP_EDLV_CODE VARCHAR2 3 YES Education Level Code
SARADAP_MAJR_CODE_CONC_1 VARCHAR2 4 YES Area of Concentration code.
SARADAP_DEPT_CODE VARCHAR2 4 YES Department Code.
SARADAP_SBGI_CODE VARCHAR2 6 YES Institution Attending code. Thisfield represents the
institution the student decided to attend rather than
the home institution.
SARADAP_RECR_CODE VARCHAR2 3 YES Recruiter Code.
SARADAP_RTYP_CODE VARCHAR2 2 YES Recruit Type code.
SARADAP_DEPT_CODE_2 VARCHAR2 4 YES Department Code for second curriculum.
SARADAP_MAJR_CODE_CONC_2 VARCHAR2 4 YES Area of Concentration code.
SARADAP_PROGRAM_1 VARCHAR2 12 YES Curriculum 1 Program Code
SARADAP_TERM_CODE_CTLG_1 VARCHAR2 6 YES Curriculum 1 Catalog Term Code
SARADAP_MAJR_CODE_1_2 VARCHAR2 4 YES Major Code 2 on First Curriculum
SARADAP_DEPT_CODE_1_2 VARCHAR2 4 YES Department Code 2 on First Curriculum
SARADAP_MAJR_CODE_CONC_1_2 VARCHAR2 4 YES Concentration Code 2 on Major 1, Curriculum 1
SARADAP_MAJR_CODE_CONC_1_3 VARCHAR2 4 YES Concentration Code 3 on Major 1, Curriculum 1
SARADAP_MAJR_CODE_CONC_121 VARCHAR2 4 YES Concentration Code 1 onMajor 2, Curriculum 1
SARADAP_MAJR_CODE_CONC_122 VARCHAR2 4 YES Concentration Code 2 on Major 2, Curriculum 1
SARADAP_MAJR_CODE_CONC_123 VARCHAR2 4 YES Concentration Code 3 on Major 2, Curriculum 1
SARADAP_MAJR_CODE_MINR_1_1 VARCHAR2 4 YES Minor Code 1 on Curriculum 1
SARADAP_MAJR_CODE_MINR_1_2 VARCHAR2 4 YES Minor 2 on Curriculum 1
SARADAP_PROGRAM_2 VARCHAR2 12 YES Curriculum 2 Program Code
SARADAP_TERM_CODE_CTLG_2 VARCHAR2 6 YES Curriculum 2 Catalog Term Code
SARADAP_LEVL_CODE_2 VARCHAR2 2 YES Curriculum 2 Level Code
SARADAP_CAMP_CODE_2 VARCHAR2 3 YES
SARADAP_MAJR_CODE_2_2 VARCHAR2 4 YES Major Code 2 on Curriculum 2
SARADAP_DEPT_CODE_2_2 VARCHAR2 4 YES Department Code 2 on Curriculum 2
SARADAP_MAJR_CODE_CONC_211 VARCHAR2 4 YES Concentration Code 1 on MAjor 1, Curriculum 2
SARADAP_MAJR_CODE_CONC_212 VARCHAR2 4 YES Concentration Code 2 on Major 1, Curriculum 2
SARADAP_MAJR_CODE_CONC_213 VARCHAR2 4 YES Concentration Code 3 on Major 1, Curriculum 2
SARADAP_MAJR_CODE_CONC_221 VARCHAR2 4 YES Concentration Code 1 on Major 2, Curriculum 2
SARADAP_MAJR_CODE_CONC_222 VARCHAR2 4 YES Concentration Code 2 on Major 2, Curriculum 2
Date: 24-MAY-2004 Page: 42
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARADAP_MAJR_CODE_CONC_223 VARCHAR2 4 YES Concentration Code 3 on Major 3, Curriculum 2
SARADAP_MAJR_CODE_MINR_2_1 VARCHAR2 4 YES Minor Code 1 on Curriculum 2
SARADAP_MAJR_CODE_MINR_2_2 VARCHAR2 4 YES Minor Code 2 on Curriculum 2
SARADAP_CURR_RULE_1 NUMBER 8 YES Curriculum 1 Rule reference
SARADAP_CMJR_RULE_1_1 NUMBER 8 YES Curriculum 1 Major 1 Rule Reference
SARADAP_CCON_RULE_11_1 NUMBER 8 YES Concentration 1, Major 1, Curriculum 1 Rule Reference
SARADAP_CCON_RULE_11_2 NUMBER 8 YES Concentration 2, Major 1, Curriculum 1 Rule Reference
SARADAP_CCON_RULE_11_3 NUMBER 8 YES Concentration 3, Major 1, Curriculum 1 Rule Reference
SARADAP_CMJR_RULE_1_2 NUMBER 8 YES Major 2, Curriculum Rule Reference
SARADAP_CCON_RULE_12_1 NUMBER 8 YES Concentration 1, Major 2, Curriculum 1 Rule Reference
SARADAP_CCON_RULE_12_2 NUMBER 8 YES Concentration 2, Major 2, Curriculum 1 Rule Reference
SARADAP_CCON_RULE_12_3 NUMBER 8 YES Concentration 3, Major 2, Curriculum 1 Rule Reference
SARADAP_CMNR_RULE_1_1 NUMBER 8 YES Minor 1, Curriculum 1 Rule Reference
SARADAP_CMNR_RULE_1_2 NUMBER 8 YES Minor 2, Curriculum 1 Rule Reference
SARADAP_CURR_RULE_2 NUMBER 8 YES Curriculum 2 Rule Reference
SARADAP_CMJR_RULE_2_1 NUMBER 8 YES Major 1, Curriculum 2 Rule Reference
SARADAP_CCON_RULE_21_1 NUMBER 8 YES Concentration 1, Major 1, Curriculum 2 Rule Reference
SARADAP_CCON_RULE_21_2 NUMBER 8 YES Concentration 2, Major 1, Curriculum 2 Rule Reference
SARADAP_CCON_RULE_21_3 NUMBER 8 YES Concentration 3, Major 1, Curriculum 2 Rule Reference
SARADAP_CMJR_RULE_2_2 NUMBER 8 YES Major 2, Curriculum 2 Rule Reference
SARADAP_CCON_RULE_22_1 NUMBER 8 YES Concentration 1, Major 2, Curriculum 2 Rule Reference
SARADAP_CCON_RULE_22_2 NUMBER 8 YES Concentration 2, Major 2, Curriculum 2 Rule Reference
SARADAP_CCON_RULE_22_3 NUMBER 8 YES Concentration 3, Major 2, Curriculum 2 Rule Reference
SARADAP_CMNR_RULE_2_1 NUMBER 8 YES Minor 1, Curriculum 2 Rule Reference
SARADAP_CMNR_RULE_2_2 NUMBER 8 YES Minor 2, Curriculum 2 Rule Reference
SARADAP_WEB_ACCT_MISC_IND VARCHAR2 1 YES Indicator to identify where receivable for web entered
credit card payment for application fee is found.
Values are M for misc, T for tbraccd.
SARADAP_WEB_CASHIER_USER VARCHAR2 30 YES User of cashier on transaction for web entered credit
card payment for application fee.
SARADAP_WEB_TRANS_NO NUMBER 8 YES Transaction number of cashier on transaction for web
entered credit card payment for application fee.
SARADAP_WEB_AMOUNT NUMBER 12 2 YES Amount of transaction for web entered credit card
payment for application fee.
SARADAP_WEB_RECEIPT_NUMBER NUMBER 8 YES Receipt number on transaction for web entered credit
card payment for application fee.
SARADAP_WAIV_CODE VARCHAR2 4 YES Application fee waiver reason.
Date: 24-MAY-2004 Page: 43
TABLE: SARADDR
CREATOR: SATURN
Electronics Admission Address Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARADDR_AIDM NUMBER 8 NO Applicant Reference Number
SARADDR_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARADDR_PERS_SEQNO NUMBER 2 NO Application Related Person Sequence
SARADDR_SEQNO NUMBER 1 NO Sequence Number
SARADDR_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARADDR_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARADDR_STREET_LINE1 VARCHAR2 35 YES Street Line 1
SARADDR_STREET_LINE2 VARCHAR2 35 YES Street Line 2
SARADDR_CITY VARCHAR2 30 YES City
SARADDR_STAT_CDE VARCHAR2 3 YES State Code
SARADDR_ZIP VARCHAR2 15 YES Zip Code
SARADDR_NATN_CDE VARCHAR2 5 YES Nation Code
SARADDR_LCQL_CDE VARCHAR2 2 YES Location Qualifier Code
SARADDR_LOC_ID VARCHAR2 30 YES Location ID
SARADDR_DTQL_CDE1 VARCHAR2 3 YES Date and Time Qualifier Code
SARADDR_DFMT_CDE1 VARCHAR2 3 YES Date and Time Period Format Code
SARADDR_REF_DTE1 VARCHAR2 35 YES Date and Time Period
SARADDR_DTQL_CDE2 VARCHAR2 3 YES Date and Time Qualifier Code 2
SARADDR_DFMT_CDE2 VARCHAR2 3 YES Date and Time Period Format 2
SARADDR_REF_DTE2 VARCHAR2 35 YES Date and Time Period 2
SARADDR_STREET_LINE3 VARCHAR2 30 YES Street line 3 for electronic application address data.
SARADDR_CNTY_CDE VARCHAR2 5 YES County for electronic application address data.
Date: 24-MAY-2004 Page: 44
TABLE: SARADHS
CREATOR: SATURN
Admissions Decision High School Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARADHS_TERM_CODE VARCHAR2 6 NO This field identifies the effective term associated
with the admissions decision.
SARADHS_APDC_CODE VARCHAR2 2 NO This field identifies the decision value associated
with the application.
SARADHS_SEQ_NO NUMBER 4 NO This field does not display on the screen. It assigns
the internal sequence number associated with each
decision code.
SARADHS_SBJC_CODE VARCHAR2 6 NO This field identifies the high school subjects taken
by applicant.
SARADHS_GRADE VARCHAR2 6 YES This field identifies the grade associated with the
high school subject taken by applicant.
SARADHS_SUBJ_YEARS NUMBER 4 2 YES This field identifies the number of years the subject
was taken by applicant.
SARADHS_SUBJ_GPA VARCHAR2 24 YES This field identifies the subject grade point average
earned by applicant.
SARADHS_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 45
TABLE: SARADRT
CREATOR: SATURN
Selective Admissions Calculated Decision Rating Type Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARADRT_TERM_CODE VARCHAR2 6 NO The term code the rating type decision rule is valid
SARADRT_APDC_CODE VARCHAR2 2 NO The application decision code the rule is for
SARADRT_SEQ_NO NUMBER 4 NO The sequence number of the decision rule
SARADRT_RATP_CODE VARCHAR2 5 NO The rating type code the decision rule pertains to
SARADRT_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARADRT_MIN_RATING NUMBER 6 2 YES The minimum value that must be on the applicants
rating to receive the decision record
SARADRT_MAX_RATING NUMBER 6 2 YES New data values used by decision rules calculator in
admissions decision process.
Date: 24-MAY-2004 Page: 46
TABLE: SARADTS
CREATOR: SATURN
Admissions Decision Test Score Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARADTS_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
application decision.
SARADTS_APDC_CODE VARCHAR2 2 NO This field identifies the decision value associated
with the decision sequence.
SARADTS_SEQ_NO NUMBER 4 NO This field identifies the sequence number of the
decision code.
SARADTS_TESC_CODE VARCHAR2 4 NO This field identifies the test code recorded for the
applicant.
SARADTS_MIN_TEST_SCORE VARCHAR2 5 YES This field identifies the minimum test score value to
be considered for the specified decision sequence.
SARADTS_TADM_CODE VARCHAR2 2 YES This field is currently not in use.
SARADTS_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
changed or updated.
SARADTS_MAX_TEST_SCORE VARCHAR2 5 YES Enter maximum test score for appropriate tesc code or
leave null to ignore.
SARADTS_CONNECTOR VARCHAR2 1 YES Enter "A" = "AND" or "O" = "OR" to build conditional
logic for test score evaluation.
SARADTS_LPAREN VARCHAR2 10 YES Enter up to 10 left parenthesis [(] to build grouping
logic for test score evaluation.
SARADTS_RPAREN VARCHAR2 10 YES Enter up to 10 right parenthesis [)] to build grouping
logic for test score evaluation.
SARADTS_CONDITION_SEQ NUMBER 3 NO This value is maintained by the sardcsn form. It is
used to maintaining record order in test score
evaluation.
Date: 24-MAY-2004 Page: 47
TABLE: SARAMCC
CREATOR: SATURN
AMCAS Error Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARAMCC_SESSIONID VARCHAR2 30 NO Unique session identifier generated for user
SARAMCC_CODE VARCHAR2 30 YES Code from AMCAS that is missing or in error in system
SARAMCC_CODE_DESC VARCHAR2 30 YES
SARAMCC_XTAB_NAME VARCHAR2 10 YES Cross Reference Table name for code, if applicable
SARAMCC_VTAB_NAME VARCHAR2 10 YES Validation Table name for code that is in error
SARAMCC_MESSAGE VARCHAR2 200 YES Additional error information
SARAMCC_ACTIVITY_DATE DATE 7 NO Date this row was inserted
Date: 24-MAY-2004 Page: 48
TABLE: SARAPPD
CREATOR: SATURN
Student Application Decision Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARAPPD_PIDM NUMBER 8 NO This field identifies the internal identification
number of the applicant.
SARAPPD_TERM_CODE_ENTRY VARCHAR2 6 NO This field identifies the effective term of the
application record.
SARAPPD_APPL_NO NUMBER 2 NO This field identifies the application number within
the effective term record.
SARAPPD_SEQ_NO NUMBER 2 NO This field does not display on the form. It
identifies the system assigned internal sequence
number associated with the application record.
SARAPPD_APDC_DATE DATE 7 NO This field identifies the date application decision
was effective.
SARAPPD_APDC_CODE VARCHAR2 2 NO This field identifies the application decision value
associated with the application decision.
SARAPPD_MAINT_IND VARCHAR2 1 NO This field identifies whether the application decision
was maintained by the system or the user.
SARAPPD_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or updated.
SARAPPD_USER VARCHAR2 30 NO USER: The ID of the most recent user to create or
update a record.
Date: 24-MAY-2004 Page: 49
TABLE: SARASTA
CREATOR: SATURN
Electronic Admissions Application Status Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARASTA_AIDM NUMBER 8 NO Person Reference Number
SARASTA_APPL_SEQNO NUMBER 3 NO Application Number
SARASTA_ASTA_CODE VARCHAR2 4 NO Application Status Code
SARASTA_COMPLETE_IND VARCHAR2 1 NO Application Status Completion Indicator
SARASTA_ADD_DATE DATE 7 NO Date of Insert of the Record
SARASTA_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARASTA_COMPLETE_DATE DATE 7 YES Date of Completion of Status
Date: 24-MAY-2004 Page: 50
TABLE: SARCHKB
CREATOR: SATURN
Admission Request Checklist Build Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARCHKB_TERM_CODE VARCHAR2 6 NO This field identifies the effective term of the
admissions checklist requirement.
SARCHKB_ADMR_CODE VARCHAR2 4 NO This field identifies the type of admissions checklist
requirement being requested.
SARCHKB_MANDATORY_IND VARCHAR2 1 YES This field identifies whether the checklist
requirement created is required to meet admissions
decision criteria.
SARCHKB_LEVL_CODE VARCHAR2 2 YES This field identifies the level of the applicant which
the admissions checklist requirement applies to.
SARCHKB_STYP_CODE VARCHAR2 1 YES This field identifies the student type that the
checklist requirement applies to.
SARCHKB_ADMT_CODE VARCHAR2 2 YES This field identifies the admission type that the
checklist requirement applies to.
SARCHKB_COLL_CODE VARCHAR2 2 YES This field identifies the specific college that the
checklist requirement applies to.
SARCHKB_DEGC_CODE VARCHAR2 6 YES This field identifies the specific degree that the
checklist requirement applies to.
SARCHKB_MAJR_CODE VARCHAR2 4 YES This field identifies the specific major that the
checklist requirement applies to.
SARCHKB_RESD_CODE VARCHAR2 1 YES This field identifies the specific residency type that
the checklist requirement applies to.
SARCHKB_INACTIVE_IND VARCHAR2 1 YES This field identifies whether the checklist
requirement is inactive.
SARCHKB_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record is
created or updated.
SARCHKB_CAMP_CODE VARCHAR2 3 YES
Date: 24-MAY-2004 Page: 51
TABLE: SARCHKL
CREATOR: SATURN
Admissions Checklist Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARCHKL_PIDM NUMBER 8 NO This field identifies the student internal
identification number.
SARCHKL_TERM_CODE_ENTRY VARCHAR2 6 NO This field identifies the effective term of the
application.
SARCHKL_APPL_NO NUMBER 2 NO This field identifies the application number
associated with the effective term of the application.
SARCHKL_ADMR_CODE VARCHAR2 4 NO This field identifies the checklist item required from
the applicant.
SARCHKL_MANDATORY_IND VARCHAR2 1 YES This field identifies whether the checklist item is
mandatory or optional.
SARCHKL_REQ_DATE1 DATE 7 YES This field identifies the date on which the checklist
item was first requested from the applicant.
SARCHKL_REQ_DATE2 DATE 7 YES This field identifies the date on which the checklist
item was last requested from the applicant.
SARCHKL_REQ_COUNT NUMBER 3 YES This field displays the number of times the specific
checklist item has been requested from the applicant.
SARCHKL_DEADLINE_DATE DATE 7 YES This field identifies the date the specific checklist
item must be received from an applicant to continue
admissions processing.
SARCHKL_RECEIVE_DATE DATE 7 YES This field identifies the date the checklist item was
received from the applicant.
SARCHKL_COMMENT VARCHAR2 30 YES This field identifies a comment about the specific
checklist item.
SARCHKL_CODE_VALUE VARCHAR2 10 YES This field identifies that a checklist item is
required from a specific institution.
SARCHKL_SOURCE VARCHAR2 1 NO This field identifies whether the checklist item was
added automatically by the system or manually by a
user.
SARCHKL_SOURCE_DATE DATE 7 NO This field identifies the date that the checklist item
was added to the application.
SARCHKL_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or updated.
SARCHKL_PRINT_IND VARCHAR2 1 YES Print indicator for checklist items letter
Date: 24-MAY-2004 Page: 52
TABLE: SARCHRT
CREATOR: SATURN
Cohort Admissions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARCHRT_PIDM NUMBER 8 NO Internal Person Identification Number
SARCHRT_TERM_CODE_ENTRY VARCHAR2 6 NO Entry Term Code
SARCHRT_APPL_NO NUMBER 2 NO Application Number
SARCHRT_CHRT_CODE VARCHAR2 10 NO Cohort Code
SARCHRT_ACTIVITY_DATE DATE 7 NO The Activity Date
Date: 24-MAY-2004 Page: 53
TABLE: SARCTRL
CREATOR: SATURN
Electronic Admissions Load Control Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARCTRL_AIDM NUMBER 8 NO Person Reference Number
SARCTRL_APPL_SEQNO NUMBER 3 NO Person Application Sequence
SARCTRL_PIDM NUMBER 8 NO Person PIDM Value
SARCTRL_TERM_CODE_ENTRY VARCHAR2 6 NO Application Term Code Used within SARADAP Insert
SARCTRL_APPL_NO_SARADAP NUMBER 2 NO Application Sequence Number used within SARADAP Insert
SARCTRL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 24-MAY-2004 Page: 54
TABLE: SARDCSN
CREATOR: SATURN
Admissions Decision Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARDCSN_TERM_CODE VARCHAR2 6 NO This field identifies the effective term of the
admissions decision.
SARDCSN_SEQ_NO NUMBER 4 NO This field identifies the system generated number of
each admissions decision within each effective term.
SARDCSN_APDC_CODE VARCHAR2 2 NO This field identifies the decision code associated
with the decision sequence number.
SARDCSN_LEVL_CODE VARCHAR2 2 YES This field identifies the level of the applicant
associated with the specific admissions decision.
SARDCSN_ADMT_CODE VARCHAR2 2 YES This field identifies the admission type of the
applicant associated with the specific admissions
decision.
SARDCSN_STYP_CODE VARCHAR2 1 YES This field identifies the student type of the
applicant.
SARDCSN_COLL_CODE_1 VARCHAR2 2 YES This field identifies the primary college associated
with the specific admissions decision.
SARDCSN_DEGC_CODE_1 VARCHAR2 6 YES This field identifies the primary degree associated
with the specific admissions decision.
SARDCSN_MAJR_CODE_1 VARCHAR2 4 YES This field identifies the primary major associated
with the specific admissions decision.
SARDCSN_COLL_CODE_2 VARCHAR2 2 YES This field identifies the secondary college associated
with the specific admissions decision.
SARDCSN_DEGC_CODE_2 VARCHAR2 6 YES This field identifies the secondary degree assoicated
with the specific admissions decision.
SARDCSN_MAJR_CODE_2 VARCHAR2 4 YES This field identifies the secondary major associated
with the specific admissions decision.
SARDCSN_RESD_CODE VARCHAR2 1 YES This field identifies the residency status associated
with the specific admissions decision.
SARDCSN_FULL_PART_IND VARCHAR2 1 YES This field identifies the enrollment status of the
applicant associated with the specific admissions
decision.
SARDCSN_SESS_CODE VARCHAR2 1 YES This field identifies the session status of the
applicant associated with the specific admissions
decision.
SARDCSN_DPLM_CODE_HS VARCHAR2 2 YES This field identifies the diploma type to be
associated with a specific admissions decision.
SARDCSN_COLL_PREP_IND_HS VARCHAR2 1 YES This field identifies if a college prep type diploma
is to be associated with a specific admissions
decision.
SARDCSN_MIN_GPA_HS VARCHAR2 24 YES This field identifies the minimum required high school
grade point average to be associated with a specific
admissions decision.
Date: 24-MAY-2004 Page: 55
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARDCSN_MIN_PERCENTILE_HS NUMBER 5 2 YES This field identifies the minimum required high school
rank percentile to be associated with a specific
admissions decision.
SARDCSN_DURATION_PC NUMBER 2 1 YES This field is currently not in use.
SARDCSN_DEGC_CODE_PC VARCHAR2 6 YES This field identifies the required degree type from a
prior college to be associated with a specific
admissions decision.
SARDCSN_MIN_HOURS_TRANS_PC NUMBER 11 3 YES This field identifies the required minimum number of
prior college transfer hours to be associated with a
specific admissions decision.
SARDCSN_MIN_GPA_TRANS_PC NUMBER 23 9 YES This field identifies the required minimum grade point
average of prior college transfer hours to be
associated with a specific admissions decision.
SARDCSN_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or updated.
SARDCSN_PRI_IND VARCHAR2 3 YES This field indicates whether an on-line decision
letter should be generated. This field will not be
used with the new letter generation process.
SARDCSN_CITZ_CODE VARCHAR2 2 YES Enter citizenship code to define admissions rule for
student citizenship with equivalent SPBPERS_CITZ_CODE.
SARDCSN_CAMP_CODE VARCHAR2 3 YES Enter campus code to define admission rule for
applications with equivalent SARADAP_CAMP_CODE.
SARDCSN_CAMP_CODE_2 VARCHAR2 3 YES Enter campus code to define admissions rule for
applications with equivalent SARADAP_CAMP_CODE_2.
SARDCSN_PROGRAM_1 VARCHAR2 12 YES Enter program code to define admissions rule for
applications with equivalent SARADAP_PROGRAM_1.
SARDCSN_PROGRAM_2 VARCHAR2 12 YES Enter program code to define admissions rule for
applications with equivalent SARADAP_PROGRAM_2.
SARDCSN_MAX_PERCENTILE_HS NUMBER 5 2 YES
Date: 24-MAY-2004 Page: 56
TABLE: SARDFOS
CREATOR: SATURN
Electronic Admissions Date - Field of Study Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARDFOS_AIDM NUMBER 8 NO Person Reference Number
SARDFOS_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARDFOS_PCOL_SEQNO NUMBER 2 NO Previous College Sequence Number
SARDFOS_PSES_SEQNO NUMBER 4 NO Previous College Academic Session Sequence Number
SARDFOS_PDEG_SEQNO NUMBER 2 NO Degree Sequence Number
SARDFOS_SEQNO NUMBER 2 NO Sequence Number
SARDFOS_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARDFOS_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARDFOS_FLVL_CDE VARCHAR2 1 YES Academic Field of Study Level or Type Code
SARDFOS_IDQL_CDE_DFOS VARCHAR2 2 YES Field of Student Qualifier Code
SARDFOS_IDEN_CDE_DFOS VARCHAR2 20 YES Field of Student Code
SARDFOS_STDY_DESC VARCHAR2 80 YES Field of Student Description
SARDFOS_HNRS_DESC VARCHAR2 80 YES Honors Description
Date: 24-MAY-2004 Page: 57
TABLE: SARDNTE
CREATOR: SATURN
Electronic Admissions Prior College Degree Note Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARDNTE_AIDM NUMBER 8 NO
SARDNTE_APPL_SEQNO NUMBER 3 NO
SARDNTE_PCOL_SEQNO NUMBER 2 NO
SARDNTE_PSES_SEQNO NUMBER 4 NO
SARDNTE_DEGR_SEQNO NUMBER 2 NO
SARDNTE_SEQNO NUMBER 2 NO
SARDNTE_LOAD_IND VARCHAR2 1 NO
SARDNTE_ACTIVITY_DATE DATE 7 NO
SARDNTE_NOTE VARCHAR2 60 YES
Date: 24-MAY-2004 Page: 58
TABLE: SARDSCL
CREATOR: SATURN
Selective Admissions Collector Table for Batch Decision Posting
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARDSCL_PIDM NUMBER 8 NO The PIDM of the applicant
SARDSCL_TERM_CODE VARCHAR2 6 NO The term on the student's application
SARDSCL_APPL_NO NUMBER 2 NO The application number on the students application
SARDSCL_SESSIONID VARCHAR2 30 NO The Oracle sessionID to identify the record entered
for a session
SARDSCL_USER VARCHAR2 30 NO This field identifies the most recent user who updated
or created a record
SARDSCL_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARDSCL_APDC_CODE VARCHAR2 2 YES An indicator that the decision can be posted or was
posted to the application
SARDSCL_STATUS_IND VARCHAR2 1 YES An indicator that the decision will result in the
creation of the student record
SARDSCL_STUDENT_IND VARCHAR2 1 YES The decision code
Date: 24-MAY-2004 Page: 59
TABLE: SAREFOS
CREATOR: SATURN
Electronic Admissions Date - Field of Study Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SAREFOS_AIDM NUMBER 8 NO Applicant Reference Number
SAREFOS_APPL_SEQNO NUMBER 3 NO Application Reference Number
SAREFOS_ETRY_SEQNO NUMBER 2 NO Entry Sequence Number
SAREFOS_SEQNO NUMBER 2 NO Sequence Number
SAREFOS_LOAD_IND VARCHAR2 1 NO Loading Indicator
SAREFOS_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SAREFOS_FLVL_CDE VARCHAR2 1 YES Academic Field of Study Level or Type Code
SAREFOS_IDQL_CDE VARCHAR2 2 YES Field of Student Qualifier Code
SAREFOS_IDEN_CDE VARCHAR2 20 YES Field of Student Code
SAREFOS_STDY_DESC VARCHAR2 80 YES Field of Student Description
SAREFOS_HNRS_DESC VARCHAR2 80 YES Honors Description
Date: 24-MAY-2004 Page: 60
TABLE: SAREMPL
CREATOR: SATURN
Electronic Admissions Employment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SAREMPL_AIDM NUMBER 8 NO Applicant Reference Number
SAREMPL_APPL_SEQNO NUMBER 3 NO Application Reference Number
SAREMPL_PERS_SEQNO NUMBER 2 NO Application Person Sequence Number
SAREMPL_SEQNO NUMBER 1 NO Sequence Number
SAREMPL_LOAD_IND VARCHAR2 1 NO Loading Indicator
SAREMPL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SAREMPL_ENTY_CDE VARCHAR2 2 YES Entity Identifier Code
SAREMPL_NAME VARCHAR2 35 YES Employer Name
SAREMPL_IDQL_CDE VARCHAR2 2 YES ID Qualifier Code
SAREMPL_IDEN_CDE VARCHAR2 20 YES Identification Code
SAREMPL_TITLE VARCHAR2 80 YES Employee Title or Description
SAREMPL_ECLS_CDE VARCHAR2 3 YES Employment Position Relationship
SAREMPL_OCCP_CDE VARCHAR2 6 YES Occupation Category Code
SAREMPL_EMST_CDE VARCHAR2 2 YES Employment Status Code
Date: 24-MAY-2004 Page: 61
TABLE: SARERUL
CREATOR: SATURN
Electronic Application Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARERUL_EGRP_CODE VARCHAR2 4 NO Rule Group Code
SARERUL_FUNCTION VARCHAR2 15 NO Rule Function Name
SARERUL_DESC VARCHAR2 30 NO Rule Function Description
SARERUL_VALUE VARCHAR2 50 NO Rule Function Value or Default Setting
SARERUL_EDI_IND VARCHAR2 1 NO Indication whether Function value is EDI Code
SARERUL_SYSTEM_REQ_IND VARCHAR2 1 NO System Required Indicator Denoting whether Row
Required
SARERUL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 24-MAY-2004 Page: 62
TABLE: SARETRY
CREATOR: SATURN
Electronic Admissions Entry-Exit Dates Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARETRY_AIDM NUMBER 8 NO Applicant Reference Number
SARETRY_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SARETRY_SEQNO NUMBER 2 NO Sequence Number
SARETRY_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARETRY_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARETRY_DEGR_CDE VARCHAR2 3 YES Academic Degree Code
SARETRY_PRIORITY VARCHAR2 9 YES Priority Number
SARETRY_ENTRY_DTE VARCHAR2 6 YES Date of Entry
SARETRY_EXIT_DTE VARCHAR2 6 YES Date of Exit
SARETRY_RSON_CDE_SSE VARCHAR2 3 YES Status Reason Code
SARETRY_DFMT_CDE VARCHAR2 3 YES Date and Time Format Code
SARETRY_DEGR_DTE VARCHAR2 35 YES Date and Time Degree Date
SARETRY_DEGR_DESC VARCHAR2 80 YES Degree Description
SARETRY_RSON_CDE_DEG VARCHAR2 3 YES Status Reason Code
Date: 24-MAY-2004 Page: 63
TABLE: SAREVAL
CREATOR: SATURN
Electronic Admissions Letters of Recommendations Evaluation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SAREVAL_AIDM NUMBER 8 NO Applicant Reference Number
SAREVAL_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SAREVAL_LREC_SEQNO NUMBER 2 NO Recommendation Sequence Number
SAREVAL_SEQNO NUMBER 2 NO Sequence Number
SAREVAL_LOAD_IND VARCHAR2 1 NO Loading Indicator
SAREVAL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SAREVAL_CQLF_CDE VARCHAR2 3 YES Qualifier Code
SAREVAL_EVAL_CDE VARCHAR2 30 YES Evaluation Code
SAREVAL_DESC VARCHAR2 80 YES Evaluation Code Description
SAREVAL_VALU_CDE VARCHAR2 1 YES Rating Summary Value Code
Date: 24-MAY-2004 Page: 64
TABLE: SARHCRS
CREATOR: SATURN
Electronic Admissions Academic Session Courses Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARHCRS_AIDM NUMBER 8 NO Applicant Reference Number
SARHCRS_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARHCRS_HSCH_SEQNO NUMBER 2 NO Academic Record Sequence Number
SARHCRS_HSES_SEQNO NUMBER 4 NO Session Sequence Number
SARHCRS_SEQNO NUMBER 2 NO Sequence Number
SARHCRS_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARHCRS_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARHCRS_CBAS_CDE VARCHAR2 1 YES Basis of Academic Credit Code
SARHCRS_CTYP_CDE VARCHAR2 1 YES Credit Type Code
SARHCRS_ATTEMPTED_HRS NUMBER 15 YES Attempted Hourse
SARHCRS_EARNED_HRS NUMBER 15 YES Earned Hours
SARHCRS_GQLF_CDE VARCHAR2 3 YES Grade Code Qualifier
SARHCRS_GRDE_CDE VARCHAR2 6 YES Grade Code
SARHCRS_GLVL_CDE VARCHAR2 2 YES Academic Grade or Course Level
SARHCRS_QLTY_PTS NUMBER 15 YES Quality Points
SARHCRS_HONORS_FLAG VARCHAR2 1 YES Honors Flag
SARHCRS_REPEAT_FLAG VARCHAR2 1 YES Repeat Flag
SARHCRS_ILVL_CDE VARCHAR2 2 YES Level of Course
SARHCRS_SUBJECT VARCHAR2 35 YES Course Subject
SARHCRS_COURSE VARCHAR2 30 YES Course Number
SARHCRS_TITLE VARCHAR2 35 YES Course Title
SARHCRS_DAYS_ATTND NUMBER 15 YES Days Attended
SARHCRS_DAYS_ABSNT NUMBER 15 YES Days Absent
SARHCRS_DROP_DTE VARCHAR2 6 YES Date of Drop
SARHCRS_OVRD_CDE VARCHAR2 2 YES Override Code
SARHCRS_NOTE VARCHAR2 60 YES Free Form Note Text
Date: 24-MAY-2004 Page: 65
TABLE: SARHEAD
CREATOR: SATURN
Electronic Admissions Application Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARHEAD_AIDM NUMBER 8 NO Person Reference Number
SARHEAD_APPL_SEQNO NUMBER 3 NO Person Application Sequence Number
SARHEAD_APPL_COMP_IND VARCHAR2 1 NO Complete Application Indicator
SARHEAD_ADD_DATE DATE 7 NO Date of Insert
SARHEAD_APPL_STATUS_IND VARCHAR2 1 NO Denotes Completion of Application Verification
Requirements
SARHEAD_PERS_STATUS_IND VARCHAR2 1 NO Denotes Completion of Person Verification Requirements
SARHEAD_PROCESS_IND VARCHAR2 1 NO Denotes Whether Application has been Processed
SARHEAD_APPL_ACCEPT_IND VARCHAR2 1 NO Denotes Whether Application is Accepted by Institution
SARHEAD_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARHEAD_TERM_CODE_ENTRY VARCHAR2 6 YES Application Term Code
SARHEAD_WAPP_CODE VARCHAR2 2 YES Web Application Type
SARHEAD_APLS_CODE VARCHAR2 4 YES Electronic Application Source Code
SARHEAD_PROCESS_DATE DATE 7 YES Indicates the Date of Application Processing
SARHEAD_WEB_ACCT_MISC_IND VARCHAR2 1 YES Indicator to identify where receivable for web entered
credit card payment for application fee is found.
Values are M for misc, T for tbraccd.
SARHEAD_WEB_CASHIER_USER VARCHAR2 30 YES User of cashier on transaction for web entered credit
card payment for application fee.
SARHEAD_WEB_TRANS_NO NUMBER 8 YES Transaction number of cashier on transaction for web
entered credit card payment for application fee.
SARHEAD_WEB_AMOUNT NUMBER 12 2 YES Amount of transaction for web entered credit card
payment for application fee.
SARHEAD_WEB_RECEIPT_NUMBER NUMBER 8 YES Receipt number on transaction for web entered credit
card payment for application fee.
SARHEAD_COMPLETE_DATE DATE 7 YES Date applicant marks the application complete.
SARHEAD_VERIFY_START_DATE DATE 7 YES Date application verification process is started.
SARHEAD_VERIFY_END_DATE DATE 7 YES Date application verification process is ended.
SARHEAD_LOAD_START_DATE DATE 7 YES Date application push process is started.
SARHEAD_LOAD_END_DATE DATE 7 YES Date application push process is ended.
SARHEAD_WSCT_CODE_BOOKMARK VARCHAR2 10 YES Section applicant has bookmarked to return to future
update.
SARHEAD_PREV_APPLIED_RESP VARCHAR2 1 YES Response to question if the student has previously
applied to the institution.
SARHEAD_PREV_ATTEND_RESP VARCHAR2 1 YES Response to question if the student has previously
attended the institution.
SARHEAD_WAIV_CODE VARCHAR2 4 YES Application fee waiver reason.
Date: 24-MAY-2004 Page: 66
TABLE: SARHLTH
CREATOR: SATURN
Electronic Admissions Health Conditions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARHLTH_AIDM NUMBER 8 NO Person Reference Number
SARHLTH_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARHLTH_PERS_SEQNO NUMBER 2 NO Person Sequence Number
SARHLTH_SEQNO NUMBER 4 NO Sequence Number
SARHLTH_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARHLTH_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARHLTH_COND_CDE VARCHAR2 6 YES Condition Code
SARHLTH_TRMT_CDE VARCHAR2 5 YES Treatment Code
SARHLTH_RESOLVED_FLAG VARCHAR2 1 YES Resolved Flag
SARHLTH_DFMT_CDE VARCHAR2 3 YES Date Format Code
SARHLTH_COND_DTE VARCHAR2 35 YES Condition Date
Date: 24-MAY-2004 Page: 67
TABLE: SARHSCH
CREATOR: SATURN
Electronic Admissions Academic Status Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARHSCH_AIDM NUMBER 8 NO Person Reference Number
SARHSCH_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARHSCH_SEQNO NUMBER 2 NO Sequence Number
SARHSCH_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARHSCH_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARHSCH_IDQL_CDE1 VARCHAR2 2 YES ID Qualifier Code 1
SARHSCH_IDEN_CDE1 VARCHAR2 20 YES ID 1
SARHSCH_RESIDENCY_FLAG VARCHAR2 1 YES Residency Flag
SARHSCH_RSON_CDE_HSGR VARCHAR2 3 YES HS Grad Status Reason Code
SARHSCH_DFMT_CDE_HSGR VARCHAR2 3 YES HS Grad Date and Time Format Code
SARHSCH_HSGR_DTE VARCHAR2 35 YES HS Grad Date
SARHSCH_RSON_CDE_RTRN VARCHAR2 3 YES Return Status Reason Code
SARHSCH_DFMT_CDE_RTRN VARCHAR2 3 YES Return Date Format Code
SARHSCH_RTRN_DTE VARCHAR2 35 YES Return Date
SARHSCH_RSON_CDE_CURR VARCHAR2 3 YES Current Status Reason Code
SARHSCH_ILVL_CDE VARCHAR2 2 YES Level of Individual
SARHSCH_ENTRY_DTE VARCHAR2 6 YES Entry Date into School, District, or Program
SARHSCH_EXIT_DTE VARCHAR2 6 YES Exit Date from School, District, or Program
SARHSCH_RSON_CDE_SSE VARCHAR2 3 YES Reason Status Code
SARHSCH_ENTY_CDE1 VARCHAR2 2 YES Entity Identifier Code 1
SARHSCH_NAME1 VARCHAR2 35 YES Entity Name 1
SARHSCH_ENTY_CDE2 VARCHAR2 2 YES Entity Identifier Code 2
SARHSCH_NAME2 VARCHAR2 35 YES Entity Name 2
SARHSCH_IDQL_CDE2 VARCHAR2 2 YES ID Qualifier Code 2
SARHSCH_IDEN_CDE2 VARCHAR2 20 YES ID 2
SARHSCH_STREET_LINE1 VARCHAR2 35 YES Street Line 1
SARHSCH_STREET_LINE2 VARCHAR2 35 YES Street Line 2
SARHSCH_CITY VARCHAR2 30 YES City
SARHSCH_STAT_CDE VARCHAR2 30 YES State Code
SARHSCH_ZIP VARCHAR2 30 YES Zip Code
SARHSCH_NATN_CDE VARCHAR2 30 YES Nation Code
SARHSCH_LCQL_CDE VARCHAR2 2 YES Location Qualifier Code
SARHSCH_LOC_ID VARCHAR2 30 YES Location Code
SARHSCH_STREET_LINE3 VARCHAR2 30 YES Street line 3 for electronic application high school
address data.
SARHSCH_CNTY_CDE VARCHAR2 5 YES County for electronic application high school address
data.
Date: 24-MAY-2004 Page: 68
TABLE: SARHSES
CREATOR: SATURN
Electronic Admissions Academic Status Sessions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARHSES_AIDM NUMBER 8 NO Person Reference Number
SARHSES_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARHSES_HSCH_SEQNO NUMBER 4 NO Academic Record Sequence Number
SARHSES_SEQNO NUMBER 4 NO Sequence Number
SARHSES_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARHSES_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARHSES_SESS_DTE VARCHAR2 35 YES Date Session Began
SARHSES_SESS_COUNT NUMBER 9 YES Number of Sessions falling within the General Session
SARHSES_SCHOOL_YEAR VARCHAR2 35 YES School Year
SARHSES_SESS_CDE VARCHAR2 1 YES Session Code
SARHSES_SESS_NAME VARCHAR2 35 YES Session Name
SARHSES_DFMT_CDE_BEGIN VARCHAR2 3 YES Date and Time Format Code
SARHSES_BEGIN_DTE VARCHAR2 35 YES Date and Time Session Began
SARHSES_DFMT_CDE_END VARCHAR2 3 YES Date and Time Format Code
SARHSES_END_DTE VARCHAR2 35 YES Date and Time Session Ended
SARHSES_ILVL_CDE VARCHAR2 2 YES Major Field of Study Level Code
SARHSES_IDQL_CDE VARCHAR2 2 YES ID Qualifier Code
SARHSES_IDEN_CDE VARCHAR2 20 YES Identification Code
SARHSES_CURR_NAME VARCHAR2 35 YES Major Field of Student Name
SARHSES_RSON_CDE VARCHAR2 3 YES Status Reason Code, Honors, Suspended, etc
Date: 24-MAY-2004 Page: 69
TABLE: SARHSUM
CREATOR: SATURN
Electronic Admissions Degree Summary Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARHSUM_AIDM NUMBER 8 NO Person Reference Number
SARHSUM_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SARHSUM_HSCH_SEQNO NUMBER 2 NO High School Record Sequence Number
SARHSUM_SEQNO NUMBER 1 NO Sequence number
SARHSUM_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARHSUM_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARHSUM_CTYP_CDE VARCHAR2 1 YES Academic Credit Type Code
SARHSUM_GLVL_CDE VARCHAR2 2 YES Academic Grade or Course Level
SARHSUM_EXC_GPA_FLAG VARCHAR2 1 YES Flag denotes whether possible to have GPA exceeding
High GPA
SARHSUM_CUMULATIVE_FLAG VARCHAR2 1 YES Cummulative Indicator
SARHSUM_GPA_HRS VARCHAR2 15 YES GPA Hours
SARHSUM_ATTEMPTED_HRS VARCHAR2 15 YES Attempted Hours
SARHSUM_EARNED_HRS VARCHAR2 15 YES Earned Hours
SARHSUM_MIN_GPA VARCHAR2 24 YES Lowest GPA Possible
SARHSUM_MAX_GPA VARCHAR2 24 YES Highest GPA Possible
SARHSUM_GPA VARCHAR2 24 YES Academic Grade Point Average
SARHSUM_CLASS_RANK NUMBER 4 YES Student Position within Class
SARHSUM_CLASS_SIZE NUMBER 15 YES Size of Class
SARHSUM_DFMT_CDE_RANK VARCHAR2 3 YES Date and Time Format Code
SARHSUM_RANK_DTE VARCHAR2 35 YES Date and Time Period
SARHSUM_DAYS_ATTND NUMBER 3 YES Days Attended
SARHSUM_DAYS_ABSNT NUMBER 15 YES Days Absent
SARHSUM_QLTY_PTS VARCHAR2 18 YES Quality Points
SARHSUM_ASRC_CDE VARCHAR2 1 YES Academic Summary Source
Date: 24-MAY-2004 Page: 70
TABLE: SARIMMZ
CREATOR: SATURN
Electronic Admissions Immunizations
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARIMMZ_AIDM NUMBER 8 NO Person Reference Number
SARIMMZ_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARIMMZ_PERS_SEQNO NUMBER 2 NO Application Related Person Sequence Number
SARIMMZ_SEQNO NUMBER 2 NO Sequence Number
SARIMMZ_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARIMMZ_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARIMMZ_IMTP_CDE VARCHAR2 6 YES Immunization Type Code
SARIMMZ_DFMT_CDE VARCHAR2 3 YES Date and Time Format Code
SARIMMZ_IMM_DTE VARCHAR2 35 YES Immunization Date
SARIMMZ_IMST_CDE VARCHAR2 2 YES Immunization Status Code
SARIMMZ_IMRP_CDE VARCHAR2 2 YES Immunization Report Type Code
Date: 24-MAY-2004 Page: 71
TABLE: SARLANG
CREATOR: SATURN
Electronic Admissions Language Use
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARLANG_AIDM NUMBER 8 NO Applicant Reference Number
SARLANG_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARLANG_PERS_SEQNO NUMBER 2 NO Application Person Sequence Number
SARLANG_SEQNO NUMBER 8 NO Sequence Number
SARLANG_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARLANG_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARLANG_IDQL_CDE VARCHAR2 2 YES Language Qualifier Code
SARLANG_IDEN_CDE VARCHAR2 20 YES Language Code
SARLANG_DESC VARCHAR2 80 YES Language Description
SARLANG_USE_CONDITION VARCHAR2 20 YES Use of Language Indicator
SARLANG_PROF_CDE VARCHAR2 1 YES Language Proficiency Code
Date: 24-MAY-2004 Page: 72
TABLE: SARLCOM
CREATOR: SATURN
Electronic Admissions Lettersof Recommendations Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARLCOM_AIDM NUMBER 8 NO Applicant Reference Number
SARLCOM_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SARLCOM_LREC_SEQNO NUMBER 2 NO Recommendation Letters SequenceNumber
SARLCOM_SEQNO NUMBER 2 NO Sequence Number
SARLCOM_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARLCOM_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARLCOM_CQLF_NUM VARCHAR2 2 YES Communication Qualifier Number
SARLCOM_COM_NUMBER VARCHAR2 80 YES Communication Number
Date: 24-MAY-2004 Page: 73
TABLE: SARLMSG
CREATOR: SATURN
Electronic Admissions Letters of Recommendation Messages Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARLMSG_AIDM NUMBER 8 NO
SARLMSG_APPL_SEQNO NUMBER 3 NO
SARLMSG_LREC_SEQNO NUMBER 2 NO
SARLMSG_SEQNO NUMBER 8 NO
SARLMSG_LOAD_IND VARCHAR2 1 NO
SARLMSG_ACTIVITY_DATE DATE 7 NO
SARLMSG_MSG VARCHAR2 255 YES
Date: 24-MAY-2004 Page: 74
TABLE: SARLREC
CREATOR: SATURN
Electronic Admissions Letters of Recommendation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARLREC_AIDM NUMBER 8 NO Applicant Reference Number
SARLREC_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SARLREC_SEQNO NUMBER 2 NO Sequence Number
SARLREC_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARLREC_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARLREC_RLTN_CDE VARCHAR2 2 YES Individual Relationship Code
SARLREC_RLTN_DESC VARCHAR2 80 YES Individual Relationship Description
SARLREC_NAME VARCHAR2 35 YES Name of Individual Making Reference
SARLREC_DESC VARCHAR2 80 YES Title or Position of Individual Making Reference
SARLREC_DTQL_CDE VARCHAR2 3 YES Date and Time Qualifier Code
SARLREC_DFMT_CDE VARCHAR2 3 YES Date and Time Format Code
SARLREC_DTE VARCHAR2 35 YES Date and Time Period
SARLREC_QTQL_CDE VARCHAR2 2 YES Quantity Qualifier
SARLREC_QTY NUMBER 15 YES Quantity
SARLREC_MEAS_CDE VARCHAR2 10 YES Composit Unit of Measurement
SARLREC_PQLF_CDE1 VARCHAR2 2 YES Phone Number Qualifier 1
SARLREC_PHONE1 VARCHAR2 80 YES Phone Number 1
SARLREC_PQLF_CDE2 VARCHAR2 2 YES Phone Number Qualifier 2
SARLREC_PHONE2 VARCHAR2 80 YES Phone Number 2
SARLREC_PQLF_CDE3 VARCHAR2 2 YES Phone Number Qualifier 3
SARLREC_PHONE3 VARCHAR2 80 YES Phone Number 3
SARLREC_PQLF_CDE4 VARCHAR2 2 YES Phone Number Qualifier 4
SARLREC_PHONE4 VARCHAR2 80 YES Phone Number 4
SARLREC_PQLF_CDE5 VARCHAR2 2 YES Phone Number Qualifier 5
SARLREC_PHONE5 VARCHAR2 80 YES Phone Number 5
SARLREC_ENTY_CDE VARCHAR2 2 YES Entity Identification Code
SARLREC_ENTY_NAME VARCHAR2 35 YES Entity Name
SARLREC_IDQL_CDE VARCHAR2 2 YES ID Qualifier Code
SARLREC_IDEN_CDE VARCHAR2 20 YES ID Code
SARLREC_STREET_LINE1 VARCHAR2 35 YES Street Line 1
SARLREC_STREET_LINE2 VARCHAR2 35 YES Street Line 2
SARLREC_CITY VARCHAR2 30 YES City
SARLREC_STAT_CDE VARCHAR2 2 YES State Code
SARLREC_ZIP VARCHAR2 15 YES Zip Code
SARLREC_NATN_CDE VARCHAR2 3 YES Nation Code
SARLREC_LCQL_CDE VARCHAR2 2 YES Location Qualifier Code
SARLREC_LOC_ID VARCHAR2 30 YES Location Identifier
Date: 24-MAY-2004 Page: 75
TABLE: SARLXMS
CREATOR: SATURN
Line Number Transaction Set Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARLXMS_AIDM NUMBER 8 NO Electronic Application Internal Identification number
SARLXMS_APPL_SEQNO NUMBER 3 NO Electronic Application Sequence Number
SARLXMS_ASSIGNED_NBR NUMBER 6 NO Number assigned for differentiation within a
transaction set
SARLXMS_SEQNO NUMBER 3 NO One up generated sequence number
SARLXMS_LOAD_IND VARCHAR2 1 NO System Load Indicator
SARLXMS_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARLXMS_MSG LONG NO Message Text associated with the transaction set line
number
Date: 24-MAY-2004 Page: 76
TABLE: SARLXNO
CREATOR: SATURN
Line Number Transaction Set Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARLXNO_AIDM NUMBER 8 NO Electronic Application Internal Identification number
SARLXNO_APPL_SEQNO NUMBER 3 NO Electronic Application Sequence Number
SARLXNO_ASSIGNED_NBR NUMBER 6 NO Number assigned for differentiation within a
transaction set
SARLXNO_LOAD_IND VARCHAR2 1 NO System Load Indicator
SARLXNO_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 24-MAY-2004 Page: 77
TABLE: SARMATL
CREATOR: SATURN
Data area to store electronic applicants requested materials.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARMATL_AIDM NUMBER 8 NO AIDM value of electronic applicant.
SARMATL_APPL_SEQNO NUMBER 3 NO Application sequence number of electronic application.
SARMATL_LOAD_IND VARCHAR2 1 NO Y indicator that the material has been pushed to
GURMAIL.
SARMATL_MATL_CDE VARCHAR2 4 NO Material code of electronic applicants requested
material.
SARMATL_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
Date: 24-MAY-2004 Page: 78
TABLE: SARMONY
CREATOR: SATURN
Electronic Admissions Monetary Amount Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARMONY_AIDM NUMBER 8 NO Applicant Reference Number
SARMONY_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARMONY_SEQNO NUMBER 2 NO Sequence Number
SARMONY_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARMONY_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARMONY_SUPT_CDE VARCHAR2 2 YES Amount Qualifier Code
SARMONY_AMOUNT NUMBER 15 YES Amount
SARMONY_MSG VARCHAR2 255 YES Free-Form Message Text
Date: 24-MAY-2004 Page: 79
TABLE: SARORTN
CREATOR: SATURN
Admissions Orientation information table for Voice Response.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARORTN_TERM_CODE_HOST VARCHAR2 6 NO Admissions Term Code.
SARORTN_YEAR VARCHAR2 4 NO Year of Term Code for telephone admissions.
SARORTN_MSG_ID NUMBER 6 YES VRU Message ID for Term to be spoken during telephone
admissions.
SARORTN_FR_MSG_ID NUMBER 6 YES VRU Message ID for Freshman to be spoken during
telephone admissions.
SARORTN_FR_START_DATE DATE 7 YES Starting Date of Freshman Orientation to be spoken
during telephone admissions.
SARORTN_FR_END_DATE DATE 7 YES Ending Date of Freshman Orientation to be spoken
during telephone admissions.
SARORTN_FR_START_TIME VARCHAR2 6 YES Starting Time of Freshman Orientation to be spoken
during telephone adissions.
SARORTN_FR_END_TIME VARCHAR2 6 YES Ending Time of Freshman Orientation to be spoken
during telephone admissions.
SARORTN_TR_MSG_ID NUMBER 6 YES VRU Message ID for Transfers to be spoken during
telephone admissions.
SARORTN_TR_START_DATE DATE 7 YES Starting Date of Transfer Orientation to be spoken
during telephone admissions.
SARORTN_TR_END_DATE DATE 7 YES Ending Date of Transfer Orientation to be spoken
during telephone admissions.
SARORTN_TR_START_TIME VARCHAR2 6 YES Starting Time of Transfer Orientation to be spoken
during telephone admissions.
SARORTN_TR_END_TIME VARCHAR2 6 YES Ending Time of Transfer Orientation to be spoken
during telephone admissions.
SARORTN_GR_MSG_ID NUMBER 6 YES VRU Message ID for Graduates to be spoken during
telephone admissions.
SARORTN_GR_START_DATE DATE 7 YES Starting Date of Graduate Orientation to be spoken
during telephone admissions.
SARORTN_GR_END_DATE DATE 7 YES Ending Date of Graduate Orientation to be spoken
during telephone admissions.
SARORTN_GR_START_TIME VARCHAR2 6 YES Starting Time of Graduate Orientation to be spoken
during telephone admissions.
SARORTN_GR_END_TIME VARCHAR2 6 YES Ending Time of Graduate Orientation to be spoken
during telephone admissions.
Date: 24-MAY-2004 Page: 80
TABLE: SARPCOL
CREATOR: SATURN
Electronic Admissions Previous College Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPCOL_AIDM NUMBER 8 NO Applicant Reference Number
SARPCOL_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SARPCOL_SEQNO NUMBER 2 NO Sequence Number
SARPCOL_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARPCOL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARPCOL_DFMT_CDE VARCHAR2 3 YES Date and Time Format
SARPCOL_ATTEND_DTE VARCHAR2 35 YES Attendence Date
SARPCOL_DEGR_CDE VARCHAR2 3 YES Degree Code
SARPCOL_DEGR_DTE VARCHAR2 35 YES Degree Received Date
SARPCOL_IDQL_CDE VARCHAR2 2 YES ID Qualifier Code
SARPCOL_IDEN_CDE VARCHAR2 20 YES Identification Code
SARPCOL_INST_NAME VARCHAR2 80 YES Institutional Name
SARPCOL_STREET_LINE1 VARCHAR2 35 YES Street Line 1
SARPCOL_STREET_LINE2 VARCHAR2 35 YES Street Line 2
SARPCOL_CITY VARCHAR2 30 YES City
SARPCOL_STAT_CDE VARCHAR2 3 YES State Code
SARPCOL_ZIP VARCHAR2 15 YES Zip Code
SARPCOL_NATN_CDE VARCHAR2 5 YES Nation Code
SARPCOL_LCQL_CDE VARCHAR2 2 YES Location Qualifier Code
SARPCOL_LOC_ID VARCHAR2 30 YES Location ID
SARPCOL_ENTRY_DTE VARCHAR2 6 YES Entry Date
SARPCOL_EXIT_DTE VARCHAR2 6 YES Exit Date
SARPCOL_RSON_CDE VARCHAR2 3 YES Reason Status Code
SARPCOL_PRIORITY VARCHAR2 9 YES Priority
SARPCOL_CTYP_CDE VARCHAR2 1 YES Academic Credit Type Code
SARPCOL_GLVL_CDE VARCHAR2 2 YES Academic Grade or Cource Level
SARPCOL_CUMULATIVE_FLAG VARCHAR2 1 YES Cumulative GPA Flag
SARPCOL_EXC_GPA_FLAG VARCHAR2 1 YES Exceeds GPA Max Flag
SARPCOL_GPA_HRS VARCHAR2 15 YES GPA Hours
SARPCOL_ATTEMPTED_HRS VARCHAR2 15 YES Attempted Hours
SARPCOL_EARNED_HRS VARCHAR2 15 YES Earned Hours
SARPCOL_MIN_GPA VARCHAR2 24 YES Lowest GPA Possible
SARPCOL_MAX_GPA VARCHAR2 24 YES Highest GPA Possible
SARPCOL_GPA VARCHAR2 24 YES Academic Grade Point Average
SARPCOL_CLASS_RANK NUMBER 4 YES Student Position within Class
SARPCOL_CLASS_SIZE NUMBER 15 YES Size of Class
SARPCOL_DFMT_CDE_RANK VARCHAR2 3 YES Date and Time Format Code
SARPCOL_RANK_DTE VARCHAR2 35 YES Date and Time Period
SARPCOL_DAYS_ATTND NUMBER 3 YES Days Attended
Date: 24-MAY-2004 Page: 81
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPCOL_DAYS_ABSNT NUMBER 15 YES Days Absent
SARPCOL_QLTY_PTS VARCHAR2 18 YES Quality Points
SARPCOL_ASRC_CDE VARCHAR2 1 YES Academic Summary Source
SARPCOL_STREET_LINE3 VARCHAR2 30 YES Street line 3 for electronic application prior college
address data.
SARPCOL_CNTY_CDE VARCHAR2 5 YES County for electronic application prior college
address data.
Date: 24-MAY-2004 Page: 82
TABLE: SARPCRS
CREATOR: SATURN
Electronic Admissions Academic Session Courses Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPCRS_AIDM NUMBER 8 NO Applicant Reference Number
SARPCRS_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARPCRS_PCOL_SEQNO NUMBER 2 NO Academic Record Sequence Number
SARPCRS_PSES_SEQNO NUMBER 4 NO Session Sequence Number
SARPCRS_SEQNO NUMBER 2 NO Sequence Number
SARPCRS_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARPCRS_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARPCRS_CBAS_CDE VARCHAR2 1 YES Basis of Academic Credit Code
SARPCRS_CTYP_CDE VARCHAR2 1 YES Credit Type Code
SARPCRS_ATTEMPTED_HRS NUMBER 15 YES Attempted Hourse
SARPCRS_EARNED_HRS NUMBER 15 YES Earned Hours
SARPCRS_GQLF_CDE VARCHAR2 3 YES Grade Code Qualifier
SARPCRS_GRDE_CDE VARCHAR2 6 YES Grade Code
SARPCRS_HONORS_FLAG VARCHAR2 1 YES Honors Flag
SARPCRS_REPEAT_FLAG VARCHAR2 1 YES Repeat Flag
SARPCRS_IDQL_CDE VARCHAR2 2 YES ID Qualifier Code
SARPCRS_IDEN_CDE VARCHAR2 20 YES Identification Code
SARPCRS_GLVL_CDE VARCHAR2 2 YES Academic Grade or Course Level
SARPCRS_QLTY_PTS NUMBER 15 YES Quality Points
SARPCRS_ILVL_CDE VARCHAR2 2 YES Level of Course
SARPCRS_SUBJECT VARCHAR2 35 YES Course Subject
SARPCRS_COURSE VARCHAR2 30 YES Course Number
SARPCRS_TITLE VARCHAR2 35 YES Course Title
SARPCRS_DAYS_ATTND NUMBER 15 YES Days Attended
SARPCRS_DAYS_ABSNT NUMBER 15 YES Days Absent
SARPCRS_DROP_DTE VARCHAR2 6 YES Date of Drop
SARPCRS_OVRD_CDE VARCHAR2 2 YES Override Code
SARPCRS_NOTE VARCHAR2 60 YES Free Form Note Text
Date: 24-MAY-2004 Page: 83
TABLE: SARPDEG
CREATOR: SATURN
Electronic Admissions Prior College Degree Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPDEG_AIDM NUMBER 8 NO Applicaition Reference Number
SARPDEG_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SARPDEG_PCOL_SEQNO NUMBER 2 NO Prior College Sequence Number
SARPDEG_PSES_SEQNO NUMBER 4 NO Session Sequence Number
SARPDEG_SEQNO NUMBER 2 NO Sequence Number
SARPDEG_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARPDEG_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARPDEG_DFMT_CDE VARCHAR2 3 YES Date Format Code
SARPDEG_DEGR_DTE VARCHAR2 35 YES Degree Date
SARPDEG_DEGR_CDE VARCHAR2 6 YES Prior College Degree Code
SARPDEG_DEGR_DESC VARCHAR2 80 YES Degree Description
SARPDEG_RSON_CDE_DEG VARCHAR2 3 YES Degree Reason Code
SARPDEG_CTYP_CDE VARCHAR2 1 YES Academic Credit Type Code
SARPDEG_CUMULATIVE_FLAG VARCHAR2 1 YES Cumulative GPA Flag
SARPDEG_EXC_GPA_FLAG VARCHAR2 1 YES Exceeds GPA Max Flag
SARPDEG_GLVL_CDE VARCHAR2 2 YES Academic Grade or Course Level
SARPDEG_GPA_HRS VARCHAR2 15 YES GPA Hours
SARPDEG_ATTEMPTED_HRS VARCHAR2 15 YES Attempted Hours
SARPDEG_EARNED_HRS VARCHAR2 15 YES Earned Hours
SARPDEG_MIN_GPA VARCHAR2 24 YES Lowest GPA Possible
SARPDEG_MAX_GPA VARCHAR2 24 YES Highest GPA Possible
SARPDEG_GPA VARCHAR2 24 YES Academic Grade Point Average
SARPDEG_CLASS_RANK NUMBER 4 YES Student Position within Class
SARPDEG_CLASS_SIZE NUMBER 15 YES Size of Class
SARPDEG_DFMT_CDE_RANK VARCHAR2 3 YES Date and Time Format Code
SARPDEG_RANK_DTE VARCHAR2 35 YES Date and Time Period
SARPDEG_DAYS_ATTND NUMBER 3 YES Days Attended
SARPDEG_DAYS_ABSNT NUMBER 15 YES Days Absent
SARPDEG_QLTY_PTS VARCHAR2 18 YES Quality Points
SARPDEG_ASRC_CDE VARCHAR2 1 YES Academic Summary Source
Date: 24-MAY-2004 Page: 84
TABLE: SARPERR
CREATOR: SATURN
Electronic Admissions Results Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPERR_AIDM NUMBER 8 NO Applicant Reference Number
SARPERR_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARPERR_WAPP_CODE VARCHAR2 2 NO Application Type Code
SARPERR_PROC_LABEL VARCHAR2 5 NO Procedure Label
SARPERR_PRTN_LABEL VARCHAR2 5 NO Routine Label
SARPERR_OVERRIDE_IND VARCHAR2 1 NO Routine Override Indicator
SARPERR_COMPLETE_IND VARCHAR2 1 NO Routine Completion Indicator
SARPERR_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARPERR_VERIFY_DATE DATE 7 YES Routine Verification Date
SARPERR_COMPLETE_DATE DATE 7 YES Routine Completion Date
SARPERR_MSG VARCHAR2 66 YES Routine Results Message
Date: 24-MAY-2004 Page: 85
TABLE: SARPERS
CREATOR: SATURN
Electronic Admissions Person Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPERS_AIDM NUMBER 8 NO Person Sequence Number
SARPERS_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SARPERS_SEQNO NUMBER 2 NO Sequence Number
SARPERS_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARPERS_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARPERS_ETYP_CDE VARCHAR2 1 YES Entity Type Qualifier
SARPERS_NTYP_CDE VARCHAR2 2 YES Name Type Code
SARPERS_ENTY_CDE VARCHAR2 2 YES Entity Identifier Code
SARPERS_RLTN_CDE VARCHAR2 2 YES Individual Relationship Code
SARPERS_ILVL_CDE VARCHAR2 2 YES Level, Individual, Test, or Course
SARPERS_PREFIX VARCHAR2 35 YES Person Prefix
SARPERS_FIRST_NAME VARCHAR2 35 YES Person First Name
SARPERS_MIDDLE_NAME1 VARCHAR2 35 YES Person Middle Name 1
SARPERS_MIDDLE_NAME2 VARCHAR2 35 YES Person Middle Name 2
SARPERS_LAST_NAME VARCHAR2 60 YES Person Last Name
SARPERS_FIRST_INIT VARCHAR2 35 YES Person First Initial
SARPERS_MIDDLE_INIT1 VARCHAR2 35 YES Person Middle Initial 1
SARPERS_MIDDLE_INIT2 VARCHAR2 35 YES Person Middle Initial 2
SARPERS_SUFFIX VARCHAR2 35 YES Person Suffix
SARPERS_NICKNAME VARCHAR2 35 YES Person Nickname
SARPERS_COMBINED_NAME VARCHAR2 35 YES Person Combined Name
SARPERS_FORMER_NAME VARCHAR2 60 YES Person Former Name
SARPERS_DFMT_CDE_BIRTH VARCHAR2 3 YES Date and Time Format Indicator
SARPERS_BIRTH_DTE VARCHAR2 35 YES Person Date of Birth
SARPERS_VERF_CDE VARCHAR2 2 YES Basis of Verification
SARPERS_AGE NUMBER 15 YES Person Age
SARPERS_GENDER VARCHAR2 1 YES Person Gender
SARPERS_MRTL_CDE VARCHAR2 2 YES Marital Status Code
SARPERS_ETHN_CDE VARCHAR2 2 YES Ethnic Code
SARPERS_CITZ_CDE VARCHAR2 2 YES Citizenship Code
SARPERS_NATN_CDE_CITZ VARCHAR2 3 YES Nation of Citizenship
SARPERS_NATN_CDE_BIRTH VARCHAR2 3 YES Nation of Birth
SARPERS_STAT_CDE_BIRTH VARCHAR2 2 YES State Code of Birth
SARPERS_CNTY_CDE_BIRTH VARCHAR2 5 YES County Code of Birth
SARPERS_CITY_BIRTH VARCHAR2 30 YES City of Birth
SARPERS_LANG_CDE_NATIVE VARCHAR2 3 YES Native Language Code
SARPERS_LANG_CDE_HOME VARCHAR2 3 YES Home Language Code
SARPERS_LANG_CDE_CORR VARCHAR2 3 YES Correspondence Language Code
SARPERS_PROF_CDE VARCHAR2 1 YES Language Proficiency Code
Date: 24-MAY-2004 Page: 86
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPERS_IDQL_CDE1 VARCHAR2 2 YES ID Qualifier 1
SARPERS_IDEN_CDE1 VARCHAR2 20 YES ID Code 1
SARPERS_IDQL_CDE2 VARCHAR2 2 YES ID Qualifier 2
SARPERS_IDEN_CDE2 VARCHAR2 20 YES ID Code 2
SARPERS_NOTE VARCHAR2 80 YES EDI Person Note
SARPERS_RELTN_DECEASED_RESP VARCHAR2 1 YES Code to store answer to question if the relative
entered on Admissions parent web page is deceased.
SARPERS_SDVET_CDE VARCHAR2 1 YES Veteran code for applicant; entered on the Web
Application.
SARPERS_VETC_FILE_NUMBER VARCHAR2 10 YES This field maintains veteran identification number
associated with person.
SARPERS_VERA_IND VARCHAR2 1 YES This field maintains veteran identification number
associated with person. Veteran Category. None,
(O)ther Eligible Veteran Only, (V)ietnam Veteran only,
(B)oth Vietnam and Other Eligible Veteran.
Date: 24-MAY-2004 Page: 87
TABLE: SARPHON
CREATOR: SATURN
Electronic Admissions Phone Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPHON_AIDM NUMBER 8 NO Applicant Reference Number
SARPHON_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARPHON_PERS_SEQNO NUMBER 2 NO Application Related Person Sequence Number
SARPHON_SEQNO NUMBER 2 NO Sequence Number
SARPHON_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARPHON_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARPHON_PQLF_CDE VARCHAR2 2 YES Communication Number
SARPHON_PHONE VARCHAR2 80 YES Phone Number
SARPHON_DTQL_CDE1 VARCHAR2 3 YES Date and Time Qualifier
SARPHON_DFMT_CDE1 VARCHAR2 3 YES Date and Time Format Code
SARPHON_REF_DTE1 VARCHAR2 35 YES Date and Time Period
SARPHON_DTQL_CDE2 VARCHAR2 3 YES Date and Time Qualifier 2
SARPHON_DFMT_CDE2 VARCHAR2 3 YES Date and Time Format Code
SARPHON_REF_DTE2 VARCHAR2 35 YES Date and Time Period 2
Date: 24-MAY-2004 Page: 88
TABLE: SARPRFN
CREATOR: SATURN
Electronic Admissions Person Related Reference Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPRFN_AIDM NUMBER 8 NO Applicant Reference Number
SARPRFN_APPL_SEQNO NUMBER 3 NO Application Number
SARPRFN_PERS_SEQNO NUMBER 2 NO Person Sequence Number
SARPRFN_SEQNO NUMBER 2 NO Sequence Number
SARPRFN_ACTIVITY_DATE DATE 7 NO Date of Insert of Last Update
SARPRFN_RFQL_CDE VARCHAR2 3 YES Reference Qualifier Code
SARPRFN_REF_NO VARCHAR2 30 YES Reference Number
SARPRFN_REF_DESC VARCHAR2 80 YES Reference Number Description
Date: 24-MAY-2004 Page: 89
TABLE: SARPRTN
CREATOR: SATURN
Electronic Admissions Routine Control Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPRTN_WAPP_CODE VARCHAR2 2 NO Application Type Code
SARPRTN_PROC_LABEL VARCHAR2 5 NO Procedure Label
SARPRTN_PRTN_LABEL VARCHAR2 5 NO Routine Label
SARPRTN_DESC VARCHAR2 30 NO Routine Description
SARPRTN_REQUIRED_IND VARCHAR2 1 NO Routine Required Indicator
SARPRTN_OVERRIDE_IND VARCHAR2 1 NO Routine Override Indicator
SARPRTN_SYSTEM_REQ_IND VARCHAR2 1 NO System Requirement Indicator
SARPRTN_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 24-MAY-2004 Page: 90
TABLE: SARPSES
CREATOR: SATURN
Electronic Admissions Prior College Sessions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPSES_AIDM NUMBER 8 NO Applicant Reference Number
SARPSES_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARPSES_PCOL_SEQNO NUMBER 2 NO Academic Record Sequence Number
SARPSES_SEQNO NUMBER 4 NO Sequence Number
SARPSES_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARPSES_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARPSES_SESS_DTE VARCHAR2 35 YES Date Session Began
SARPSES_SESS_COUNT NUMBER 9 YES Number of Sessions falling within the General Session
SARPSES_SCHOOL_YEAR VARCHAR2 35 YES School Year
SARPSES_SESS_CDE VARCHAR2 1 YES Session Code
SARPSES_SESS_NAME VARCHAR2 35 YES Session Name
SARPSES_DFMT_CDE_BEGIN VARCHAR2 3 YES Date and Time Format Code
SARPSES_BEGIN_DTE VARCHAR2 35 YES Date and Time Session Began
SARPSES_DFMT_CDE_END VARCHAR2 3 YES Date and Time Format Code
SARPSES_END_DTE VARCHAR2 35 YES Date and Time Session Ended
SARPSES_ILVL_CDE VARCHAR2 2 YES Major Field of Study Level Code
SARPSES_IDQL_CDE VARCHAR2 2 YES ID Qualifier Code
SARPSES_IDEN_CDE VARCHAR2 20 YES Identification Code
SARPSES_CURR_NAME VARCHAR2 35 YES Person Curriculum Name
SARPSES_RSON_CDE VARCHAR2 3 YES Reason Code
Date: 24-MAY-2004 Page: 91
TABLE: SARPSTA
CREATOR: SATURN
Electronic Admissions Person Status Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARPSTA_AIDM NUMBER 8 NO Person Reference Number
SARPSTA_ASTA_CODE VARCHAR2 4 NO Person Status Code
SARPSTA_ADD_DATE DATE 7 NO Date of Record Insert
SARPSTA_COMPLETE_IND VARCHAR2 1 NO Status Completion Indicator
SARPSTA_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARPSTA_COMPLETE_DATE DATE 7 YES Date of Resolution of Status
Date: 24-MAY-2004 Page: 92
TABLE: SARQKER
CREATOR: SATURN
Quick Entry Rules Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARQKER_TERM_CODE VARCHAR2 6 NO This field identifies the effective term for the
specific quick entry rule.
SARQKER_LEVL_CODE VARCHAR2 2 NO This field identifies the level of the applicant
associated with the quick entry rule.
SARQKER_APST_CODE VARCHAR2 1 YES
SARQKER_APDC_CODE VARCHAR2 2 YES This field identifies the decision associated with the
application.
SARQKER_ADMT_CODE VARCHAR2 2 YES This field identifies the admissions type of the
applicant.
SARQKER_STYP_CODE VARCHAR2 1 YES This field identifies the student type of the
applicant.
SARQKER_STST_CODE VARCHAR2 2 YES This field identifies the student status of the
applicant.
SARQKER_CAMP_CODE VARCHAR2 3 YES This field identifies the campus associated with the
applicant.
SARQKER_COLL_CODE VARCHAR2 2 YES This field identifies the college associated with the
applicant.
SARQKER_DEGC_CODE VARCHAR2 6 YES This field identifies the degree associated with the
applicant.
SARQKER_MAJR_CODE VARCHAR2 4 YES This field identifies the major associated with the
applicant.
SARQKER_RESD_CODE VARCHAR2 1 YES This field identifies the residence type associated
with the applicant.
SARQKER_RATE_CODE VARCHAR2 5 YES This field identifies the fee rate associated with the
applicant.
SARQKER_DEPT_CODE VARCHAR2 4 YES This field identifies the department associated with
the applicant.
SARQKER_SBGI_CODE VARCHAR2 6 YES This field identifies the primary source of the
applicant.
SARQKER_ADD_ADM_IND VARCHAR2 1 YES This field identifies whether an admissions
application should be created for this applicant.
SARQKER_ADD_RECR_IND VARCHAR2 1 YES This field identifies whether a recruiting record
should be created for the applicant.
SARQKER_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or updated.
SARQKER_EGOL_CODE VARCHAR2 2 YES Educational Goal Code
SARQKER_EDLV_CODE VARCHAR2 3 YES Education Level Code
Date: 24-MAY-2004 Page: 93
TABLE: SARQUAN
CREATOR: SATURN
Data area to store questions and answers to applicant during admissions process.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARQUAN_PIDM NUMBER 8 NO PIDM value of applicant.
SARQUAN_TERM_CODE_ENTRY VARCHAR2 6 NO Term code of application.
SARQUAN_APPL_NO NUMBER 3 NO Sequence number of application.
SARQUAN_SEQNO NUMBER 4 NO Sequence number of question for application.
SARQUAN_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARQUAN_USER_ID VARCHAR2 30 NO This field identifies the most recent user who updated
the record
SARQUAN_WEB_IND VARCHAR2 1 YES Indicator the question/answer originated from
Admissions Web page.
SARQUAN_DISPLAY_WEB_IND VARCHAR2 1 YES Indicator the question/answer can be displayed on the
Admissions Web Display page.
SARQUAN_QUESTION VARCHAR2 2000 YES Free format application question.
SARQUAN_ANSWER VARCHAR2 2000 YES Free format applicant response to application
question.
SARQUAN_LONG_ANSWER CLOB 4000 YES Application Long Answer: This field contains the
personal essay statement, which is an answer to an
application essay question.
SARQUAN_ADMR_CODE VARCHAR2 4 YES Admission Request Code: This field indicates the
checklist code associated with this question.
Date: 24-MAY-2004 Page: 94
TABLE: SARRESD
CREATOR: SATURN
Electronic Admissions Residence Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRESD_AIDM NUMBER 8 NO Applicant Reference Number
SARRESD_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARRESD_SEQNO NUMBER 4 NO Sequence Number
SARRESD_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARRESD_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARRESD_CQLF_CDE VARCHAR2 3 YES Code List Qualifier Code
SARRESD_RESD_CDE VARCHAR2 30 YES EDI Residency Code
SARRESD_RLTN_CDE VARCHAR2 2 YES Individual relationship Code
SARRESD_CITY VARCHAR2 30 YES City
SARRESD_STAT_CDE VARCHAR2 2 YES State Code
SARRESD_ZIP VARCHAR2 15 YES Zip Code
SARRESD_NATN_CDE VARCHAR2 3 YES Nation Code
SARRESD_LCQL_CDE VARCHAR2 2 YES Location Qualifier Code
SARRESD_LOC_ID VARCHAR2 30 YES Location Code
SARRESD_DTQL_CDE1 VARCHAR2 3 YES Date and Time Qualifier Code
SARRESD_DFMT_CDE1 VARCHAR2 3 YES Date and Time Format Code
SARRESD_REF_DTE1 VARCHAR2 35 YES Date and Time Period
SARRESD_DTQL_CDE2 VARCHAR2 3 YES Date and Time Qualifier Code 2
SARRESD_DFMT_CDE2 VARCHAR2 3 YES Date and Time Format Code 2
SARRESD_REF_DTE2 VARCHAR2 35 YES Date and Time Period 2
SARRESD_QTQL_CDE VARCHAR2 2 YES Quantity Qualifier
SARRESD_QTY NUMBER 15 YES Quantity
SARRESD_MEAS_CDE VARCHAR2 10 YES Composit Unit of Measurement
SARRESD_RFQL_CDE VARCHAR2 3 YES Reference ID Qualifier
SARRESD_REF_NO VARCHAR2 30 YES Reference Number
SARRESD_REF_DESC VARCHAR2 80 YES Reference Description
Date: 24-MAY-2004 Page: 95
TABLE: SARRFNO
CREATOR: SATURN
Electronic Admissions Reference Numbers Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRFNO_AIDM NUMBER 8 NO Applicant Reference Number
SARRFNO_APPL_SEQNO NUMBER 3 NO Application uUmber
SARRFNO_SEQNO NUMBER 2 NO Sequence Number
SARRFNO_ACTIVITY_DATE DATE 7 NO Date of Insert of Last Update
SARRFNO_RFQL_CDE VARCHAR2 2 YES Reference Number Qualifier Code REF-IN1-REF01
SARRFNO_REF_NO VARCHAR2 30 YES Referene Number REF-IN1-REF02
SARRFNO_REF_DESC VARCHAR2 80 YES Reference Number DescriptionREF-IN1-REF03
SARRFNO_DTQL_CDE1 VARCHAR2 3 YES Date 1 Qualifying Code REF-DPT01
SARRFNO_DFMT_CDE1 VARCHAR2 3 YES Date 1 Format Code REF-DTP02
SARRFNO_REF_DTE1 VARCHAR2 35 YES Reference Date 1 REF-DTP03
SARRFNO_DTQL_CDE2 VARCHAR2 3 YES Date 2 Qualifying Code REF-DTP01
SARRFNO_DFMT_CDE2 VARCHAR2 3 YES Date 2 Format Code REF-DTP02
SARRFNO_REF_DTE2 VARCHAR2 35 YES Reference Date 2 REF-DTP03
SARRFNO_CITY VARCHAR2 30 YES Reference City REF-N401
SARRFNO_STAT_CDE VARCHAR2 2 YES Reference State Code REF-N402
SARRFNO_ZIP VARCHAR2 15 YES Reference Zip Code REF-N403
SARRFNO_NATN_CDE VARCHAR2 3 YES Reference Nation Code REF-N404
SARRFNO_LCQL_CDE VARCHAR2 2 YES Location ID Qualifying Code REF-N405
SARRFNO_LOC_ID VARCHAR2 30 YES Location ID REF-N406
SARRFNO_ENTY_CDE VARCHAR2 2 YES Reference Entity Code REF-N101
SARRFNO_NAME VARCHAR2 35 YES Reference Name REF-N102
SARRFNO_IDQL_CDE VARCHAR2 2 YES Reference Identifier Qualifying Code REF-N103
SARRFNO_IDEN_CDE VARCHAR2 20 YES Reference Identifier Code REF-N104
Date: 24-MAY-2004 Page: 96
TABLE: SARRLGN
CREATOR: SATURN
Electronic Admissions Religions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRLGN_AIDM NUMBER 8 NO Applicant Reference Number
SARRLGN_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SARRLGN_PERS_SEQNO NUMBER 2 NO Person Sequence Number
SARRLGN_SEQNO NUMBER 2 NO Sequence Number
SARRLGN_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARRLGN_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARRLGN_RLGN_CDE VARCHAR2 30 YES Religion Code
SARRLGN_RLGN_DESC VARCHAR2 255 YES Religion Description
Date: 24-MAY-2004 Page: 97
TABLE: SARRLST
CREATOR: SATURN
Electronic Admissions Results Control Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRLST_AIDM NUMBER 8 NO Applicant Reference Number
SARRLST_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARRLST_WAPP_CODE VARCHAR2 2 NO Application Type Code
SARRLST_PROC_LABEL VARCHAR2 5 NO Procedure Label
SARRLST_OVERRIDE_IND VARCHAR2 1 NO Results Override Indicator
SARRLST_COMPLETE_IND VARCHAR2 1 NO Results Completion Indicator
SARRLST_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARRLST_VERIFY_DATE DATE 7 YES Results Verification Date
SARRLST_COMPLETE_DATE DATE 7 YES Results Completion Date
SARRLST_LOAD_DATE DATE 7 YES Load Date
Date: 24-MAY-2004 Page: 98
TABLE: SARRQST
CREATOR: SATURN
Electronic Admissions Request for Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRQST_AIDM NUMBER 8 NO Applicant Reference Number
SARRQST_APPL_SEQNO NUMBER 3 NO Application Reference Number
SARRQST_SEQNO NUMBER 4 NO Sequence Number
SARRQST_LOAD_IND VARCHAR2 1 NO Load Indicator
SARRQST_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARRQST_QSTN_CDE VARCHAR2 30 YES Question Code
SARRQST_QSTN_DESC VARCHAR2 2000 YES Question Description
SARRQST_RESP_FLAG VARCHAR2 1 YES Response Flag
SARRQST_ANSR_DESC VARCHAR2 2000 YES Answer Description
SARRQST_MSG LONG YES Message Text
SARRQST_WUDQ_NO NUMBER 4 YES User Defined Question Number
SARRQST_ADMR_CODE VARCHAR2 4 YES Admission Request Code: This field indicates the
checklist code associated with this question.
Date: 24-MAY-2004 Page: 99
TABLE: SARRRAT
CREATOR: SATURN
Selective Admissions Student Application Rating
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRRAT_PIDM NUMBER 8 NO The PIDM of the applicant
SARRRAT_TERM_CODE VARCHAR2 6 NO The term on the student's application
SARRRAT_APPL_NO NUMBER 2 NO The application number on the students application
SARRRAT_RATP_CODE VARCHAR2 5 NO The rating type code
SARRRAT_AROL_PIDM NUMBER 8 NO The PIDM value of the Admissions/Recruit Administrator
SARRRAT_RADM_CODE VARCHAR2 10 NO The role of the Administrator
SARRRAT_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARRRAT_USER VARCHAR2 30 NO
SARRRAT_RATING NUMBER 6 2 NO The rating value given the applicant by the
administrator
Date: 24-MAY-2004 Page: 100
TABLE: SARRRCT
CREATOR: SATURN
Selective Admissions Rating Type Rule Form by Term
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRRCT_TERM_CODE_EFF VARCHAR2 6 NO The start term the rating type rule is effective
SARRRCT_RATP_CODE VARCHAR2 5 NO The rating type code
SARRRCT_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARRRCT_MIN_RATING NUMBER YES The minimum rating value valid for the term and rating
type code. Valid values can be 0-99999.99
SARRRCT_MAX_RATING NUMBER YES The maximum rating value valid for the term and rating
type code. Valid values can be 0-99999.99
Date: 24-MAY-2004 Page: 101
TABLE: SARRRDF
CREATOR: SATURN
This table contains the components that define the Admissions Rating Formula. The formula will be comprised of the
following components: left parenthesis, right parenthesis, Admissions Rating Factor Codes and mathematical
operators. This formula will be
extracted from the database, evaluated and executed in SARRATE, the Admissions
Rating Process.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRRDF_TERM_CODE_EFF VARCHAR2 6 NO Rating Formula Component Effective Term.
SARRRDF_RATP_CODE VARCHAR2 5 NO Rating Type Code for Admissions Rating Formula
Definition. This will be the rating type that the
calculated rating will be assigned to.
SARRRDF_SEQ_NO NUMBER 8 4 NO Sequence number for Admissions Rating Formula
Definition component.
SARRRDF_AFCT_CODE VARCHAR2 15 YES Admissions Rating Factor Code component for Rating
Formula. This is one of the possible existing values
for a Rating Formula Component.
SARRRDF_LPAREN VARCHAR2 1 YES Left Parenthesis component for Rating Formula. This
is one of the possible existing values for the Rating
Formula component.
SARRRDF_RPAREN VARCHAR2 1 YES Right Parenthesis component for Rating Formula. This
is one of the possible existing values for a Rating
Formula component.
SARRRDF_OPERATOR VARCHAR2 1 YES Mathematical Operator component for Rating Formula.
This is one of the possible existing values for a
Rating Formula component.
SARRRDF_USER_ID VARCHAR2 30 NO Banner User ID. The user ID of the person who is
inserting or updating the SARRRDF record.
SARRRDF_ACTIVITY_DATE DATE 7 NO Activity date. The date that the information for the
row was inserted or last updated in the SARRRDF table.
Date: 24-MAY-2004 Page: 102
TABLE: SARRRFT
CREATOR: SATURN
This table contains Rating Factor Rules and Rating Factor Value definitions. The available values for specifying
rules include term, level, campus, college, program, admit type, student type, residency and major. Institutions
can enter any combination of
values to tailor the rating factors to meet their needs. The value of a Rating Factor
can be a static value or can be a key value that will be used in the generation of dynamic SQL to retrieve a factor
value from the database.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRRFT_TERM_CODE_EFF VARCHAR2 6 NO Effective Term for Admissions Rating Factor
evaluation. Only admissions rating factors with this
effective term will be evaluated using this rule.
SARRRFT_LEVL_CODE VARCHAR2 2 YES Level Code for Admissions Rating Factor evaluation.
Only admissions rating factors with this level code
will be evaluated using this rule.
SARRRFT_CAMP_CODE VARCHAR2 3 YES Campus Code for Admissions Rating Factor evaluation.
Only admissions rating factors with this campus code
will be evaluated using this rule.
SARRRFT_COLL_CODE VARCHAR2 2 YES College Code for Admissions Rating Factor evaluation.
Only admissions rating factors with this college code
will be evaluated using this rule.
SARRRFT_DEGC_CODE VARCHAR2 6 YES Degree Code for Admissions Rating Factor evaluation.
Only admissions rating factors with this degree code
will be evaluated using this rule.
SARRRFT_PROGRAM VARCHAR2 12 YES Program for Admissions Rating Factor evaluation. Only
admissions rating factors with this program will be
evaluated using this rule.
SARRRFT_ADMT_CODE VARCHAR2 2 YES Admit Type Code for Admissions Rating Factor
evaluation. Only admissions rating factors with this
admit type code will be evaluated using this rule.
SARRRFT_STYP_CODE VARCHAR2 1 YES Student Type Code for Admissions Rating Factor
evaluation. Only admissions rating factors with this
student type code will be evaluated using this rule.
SARRRFT_RESD_CODE VARCHAR2 1 YES Residency Code for Admissions Rating Factor
evaluation. Only admissions rating factors with this
residency code will be evaluated using this rule.
SARRRFT_MAJR_CODE VARCHAR2 4 YES Major Code for Admissions Rating Factor evaluation.
Only admissions rating factors with this major code
will be evaluated using this rule.
SARRRFT_AFCT_CODE VARCHAR2 15 NO Admissions Rating Factor Code for Admissions Rating
Factor evaluation. Only admissions rating factors
meeting the rule criteria will be available to an
applicant as part of the index/rating calculation for
that applicant.
Date: 24-MAY-2004 Page: 103
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRRFT_TABLE_NAME VARCHAR2 30 YES Database Table Name to optionally specify for use in
dynamic retrieval of factor value from database.
Existence of table name along with
SARRRFT_SELECT_COLUMN and SARRRFT_WHERE_COLUMN is
indicative that factor value will be retrieved from
database.
SARRRFT_SELECT_COLUMN VARCHAR2 30 YES Database Table Column to optionally specify for use in
dynamic retrieval of factor value from database. This
will be the column name used in the generated SELECT
statement. Existence of select column along with
SARRRFT_TABLE_NAME and SARRRFT_WHERE_COLUMN
is
indicative that factor value will be retrieved from
database.
SARRRFT_WHERE_COLUMN VARCHAR2 30 YES Database Table Column name to optionally specify for
use in retrieval of factor value from database. This
will be the column name used in the WHERE clause of
the generated SELECT statement. Existence of where
column along with SARRRFT_TABLE_NAME and
SARR
RFT_WHERE_COLUMN is indicative that factor value
will be retrieved from database.
SARRRFT_VALUE VARCHAR2 15 YES Actual Value to be used for Admissions Factor Code.
Value can be static value or can be key value that
will be used in the dynamic retrieval of the factor
value from the database. The existence of data in
SAARRFT_TABLE_NAME, SAARRFT_SELECT_COLUMN and
SA
ARRFT_WHERE_COLUMN is indicative that the value
will be retrieved from the database. When being
retrieved from the database, the contents of
SAARRFT_VALUE will be used in the construction of the
WHERE clause with the contents of SAARRFT_VALUE being
to the
right of the '=' in the WHERE clause of the
generated SELECT statement.
SARRRFT_USER_ID VARCHAR2 30 NO Banner User ID. The user ID of the person who is
inserting or updating the SARRRFT record.
SARRRFT_ACTIVITY_DATE DATE 7 NO Activity date. The date that the information for the
row was inserted or last updated in the SARRRFT table.
Date: 24-MAY-2004 Page: 104
TABLE: SARRRRT
CREATOR: SATURN
Selective Admissions Rating Type Rules by Term and Administrator
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRRRT_TERM_CODE_EFF VARCHAR2 6 NO The start term the rating type rule is effective
SARRRRT_RATP_CODE VARCHAR2 5 NO The rating type code
SARRRRT_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARRRRT_AROL_PIDM NUMBER 8 NO The PIDM value of the Admissions/Recruit Administrator
SARRRRT_RADM_CODE VARCHAR2 10 NO The role of the Administrator
SARRRRT_MIN_RATING NUMBER YES The minimum rating value valid for the term and rating
type code. Valid values can be 0-99999.99
SARRRRT_MAX_RATING NUMBER YES The maximum rating value valid for the term and rating
type code. Valid values can be 0-99999.99
Date: 24-MAY-2004 Page: 105
TABLE: SARRSRC
CREATOR: SATURN
Source of Application Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARRSRC_PIDM NUMBER 8 NO Internal identification number of applicant.
SARRSRC_TERM_CODE_ENTRY VARCHAR2 6 NO This field identifies the entry term
SARRSRC_APPL_NO NUMBER 2 NO This field identifies the application number
SARRSRC_SBGI_CODE VARCHAR2 6 NO This field identifies the source background associated
with the application.
SARRSRC_PRIMARY_SRCE_IND VARCHAR2 1 YES This field specifies if the source type is the primary
source of the application.
SARRSRC_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or changed.
Date: 24-MAY-2004 Page: 106
TABLE: SARTERM
CREATOR: SATURN
Telephone Admissions Term Table controls the terms and timeframes that telephone admissions is available for
callers.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARTERM_PRIORITY NUMBER 4 NO Priority Sequence Number of Term in listing of terms
for admissions status.
SARTERM_TERM_CODE_HOST VARCHAR2 6 NO Admissions Term Code.
SARTERM_YEAR VARCHAR2 4 NO Year for term to be spoken during telephone Admissions
SARTERM_MSG_ID NUMBER 6 NO VRU Message ID for the term to be spoken during
telephone Admissions
SARTERM_MSG_ID_MENU NUMBER 6 NO VRU Message ID for the term to be spoken when term is
used in a menu during telephone admissions.
SARTERM_ADM_START_DATE_1 DATE 7 YES Beginning Date of the first telephone admissions
period.
SARTERM_ADM_END_DATE_1 DATE 7 YES Ending Date of the first telephone admissions period.
SARTERM_ADM_START_DATE_2 DATE 7 YES Beginning Date of the second telephone admissions
period.
SARTERM_ADM_END_DATE_2 DATE 7 YES Ending Date of the second telephone admissions peroid.
SARTERM_DEADLN_START_DATE DATE 7 YES Starting Date to speak admissions DEADLN information
for term.
SARTERM_DEADLN_END_DATE DATE 7 YES Ending Date for speaking admissions DEADLN information
for term.
SARTERM_APPL_DEADLN_DATE DATE 7 YES DEADLN Date for admissions applications for the term.
SARTERM_CRED_DEADLN_DATE DATE 7 YES DEADLN Date for admissions credentials, for the term.
Date: 24-MAY-2004 Page: 107
TABLE: SARTEST
CREATOR: SATURN
Electronic Admissions Test Scores Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARTEST_AIDM NUMBER 8 NO Applicant Reference Number
SARTEST_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SARTEST_SEQNO NUMBER 6 NO Sequence Number
SARTEST_LOAD_IND VARCHAR2 1 NO Loading Indicator
SARTEST_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARTEST_TEST_CDE VARCHAR2 3 YES Test Code
SARTEST_TEST_DESC VARCHAR2 35 YES Test Description
SARTEST_DFMT_CDE VARCHAR2 3 YES Date and Time Format Code
SARTEST_TEST_DTE VARCHAR2 35 YES Date and Time of Test
SARTEST_FORM_REF_NO VARCHAR2 30 YES Reference Identification
SARTEST_LEVEL_REF_NO VARCHAR2 30 YES Reference Level
SARTEST_ILVL_CDE_STDNT VARCHAR2 2 YES Level of Individual
SARTEST_ILVL_CDE_TEST VARCHAR2 2 YES Level of Test
SARTEST_NORM_YEAR VARCHAR2 35 YES Date and Time of Norm Year
SARTEST_NORM_CDE VARCHAR2 1 YES Test Norm Type Code
SARTEST_NPRD_CDE VARCHAR2 1 YES Test Norming Period Code
SARTEST_LANG_CDE VARCHAR2 3 YES Language Code
SARTEST_SUBT_CDE VARCHAR2 5 YES Sub Test Code
SARTEST_SUBT_DESC VARCHAR2 35 YES Sub Test Description
SARTEST_INTP_CDE VARCHAR2 1 YES Interpretation Code
SARTEST_TQLF_CDE1 VARCHAR2 1 YES Sub Test Qualifier Code1
SARTEST_TEST_SCORE1 VARCHAR2 80 YES Sub Test Score1
SARTEST_TQLF_CDE2 VARCHAR2 1 YES Sub Test Qualifier Code2
SARTEST_TEST_SCORE2 VARCHAR2 80 YES Sub Test Score2
SARTEST_TQLF_CDE3 VARCHAR2 1 YES Sub Test Qualifier Code3
SARTEST_TEST_SCORE3 VARCHAR2 80 YES Sub Test Score3
SARTEST_NOTE1 VARCHAR2 80 YES Sub Test Note1
SARTEST_NOTE2 VARCHAR2 80 YES Sub Test Note2
Date: 24-MAY-2004 Page: 108
TABLE: SARWAAD
CREATOR: SATURN
Calendar controls for data entry of standard applicants on the admissions web pages.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWAAD_LEVL_CODE VARCHAR2 2 NO Level Code on standard application web display rule.
SARWAAD_TERM_CODE VARCHAR2 6 NO Term code of view rules for standard applications.
SARWAAD_PRIORITY_NUMBER NUMBER 3 NO Priority number on level, term, start and end date
combination to make unique record.
SARWAAD_START_DATE DATE 7 NO Start date when standard applications for term can be
viewed on admissions web pages.
SARWAAD_END_DATE DATE 7 NO End date when standard applications for term can be
viewed on admissions web pages.
SARWAAD_VIEW_IND VARCHAR2 1 NO Y/N Indicator for when application can be viewed on
web.
SARWAAD_SHOW_STATUS_IND VARCHAR2 1 NO Y/N Indicator for when application status can be
viewed on web.
SARWAAD_SHOW_DECSN_IND VARCHAR2 1 NO Y/N Indicator for when application status can be
viewed on web.
SARWAAD_CONFIRM_IND VARCHAR2 1 NO Y/N Indicator for when applicant can confirm
application on the web.
SARWAAD_WITHDRAW_IND VARCHAR2 1 NO Y/N Indicator for when applicant can withdraw
application on the web.
SARWAAD_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARWAAD_USER_ID VARCHAR2 30 NO This field identifies the most recent user the record
was updated
SARWAAD_CAMP_CODE VARCHAR2 3 YES Campus code on standard application web display rule.
SARWAAD_COLL_CODE VARCHAR2 2 YES College code on standard application web display rule.
SARWAAD_ADMT_CODE VARCHAR2 2 YES Admit Type code on standard application web display
rule.
SARWAAD_APDC_CODE_CONFIRM VARCHAR2 2 YES APDC code entered on students decision when they
confirm application on the web.
SARWAAD_APDC_CODE_WITHDRAW VARCHAR2 2 YES APDC code entered on students decision when they
withdraw application on the web.
Date: 24-MAY-2004 Page: 109
TABLE: SARWADF
CREATOR: SATURN
Default data and rules for Web Admissions Application.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWADF_WAPP_CODE VARCHAR2 2 NO Electronic Applicant type code.
SARWADF_TERM_CODE_EFF VARCHAR2 6 NO Effective term for default data.
SARWADF_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARWADF_USER_ID VARCHAR2 30 NO This field identifies the most recent user who updated
the row
SARWADF_COLL_CODE VARCHAR2 2 YES Default college code for the first curriculum choice.
SARWADF_CAMP_CODE VARCHAR2 3 YES Default campus code for the first curriculum choice.
SARWADF_DEGC_CODE VARCHAR2 6 YES Default degree code for the first curriculum choice.
SARWADF_PROGRAM VARCHAR2 12 YES Default program for the first curriculum choice.
SARWADF_MAJR_CODE VARCHAR2 4 YES Default majr code for the first curriculum choice.
SARWADF_DEPT_CODE VARCHAR2 4 YES Default department code for the first curriculum
choice.
SARWADF_CURR_RULE NUMBER 4 YES Default curriculum rule for program for the first
curriculum choice.
SARWADF_CMJR_RULE NUMBER 4 YES Default curriculum rule for majr code for the first
curriculum choice.
SARWADF_MAJR_CODE_CONC1 VARCHAR2 4 YES Default concentration 1 code for the first curriculum
choice.
SARWADF_MAJR_CODE_CONC2 VARCHAR2 4 YES Default concentration 2 code for the first curriculum
choice.
SARWADF_MAJR_CODE_CONC3 VARCHAR2 4 YES Default concentration 3 code for the first curriculum
choice.
SARWADF_MAJR_CODE_MINR1 VARCHAR2 4 YES Default minor 1 code for the first curriculum choice.
SARWADF_MAJR_CODE_MINR1_2 VARCHAR2 4 YES Default minor 2 code for the first curriculum choice.
SARWADF_COLL_CODE_2 VARCHAR2 2 YES Default college code for the second curriculum choice.
SARWADF_CAMP_CODE_2 VARCHAR2 3 YES Default campus code for the second curriculum choice.
SARWADF_DEGC_CODE_2 VARCHAR2 6 YES Default degree code for the second curriculum choice.
SARWADF_PROGRAM_2 VARCHAR2 12 YES Default program for the second curriculum choice.
SARWADF_CURR_RULE_2 NUMBER 4 YES Default curriculum rule for program for the second
curriculum choice.
SARWADF_CMJR_RULE_2 NUMBER 4 YES Default curriculum rule for majr code for the second
curriculum choice.
SARWADF_MAJR_CODE_2 VARCHAR2 4 YES Default majr code for the second curriculum choice.
SARWADF_DEPT_CODE_2 VARCHAR2 4 YES Default department code for the second curriculum
choice.
SARWADF_MAJR_CODE_CONC2_1 VARCHAR2 4 YES Default concentration 1 code for the second curriculum
choice.
SARWADF_MAJR_CODE_CONC2_2 VARCHAR2 4 YES Default concentration 2 code for the second curriculum
choice.
Date: 24-MAY-2004 Page: 110
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWADF_MAJR_CODE_CONC2_3 VARCHAR2 4 YES Default concentration 3 code for the second curriculum
choice.
SARWADF_MAJR_CODE_MINR2 VARCHAR2 4 YES Default minor 1 code for the second curriculum choice.
SARWADF_MAJR_CODE_MINR2_2 VARCHAR2 4 YES Default minor 2 code for the second curriculum choice.
SARWADF_LETR_CODE_SIGNATURE VARCHAR2 15 YES Banner Student Release 5.4 this column was replaced by
SARWALT.SARWALT_LETR_CODE.
SARWADF_LETR_CODE_EMAIL_LINK VARCHAR2 15 YES Letter code for letter that will be attached to the
email from application section menu.
SARWADF_EMAIL_LINK_TEXT VARCHAR2 60 YES Text for link to send email on application section
menu.
SARWADF_EMAIL_ADDRESS_LINK VARCHAR2 90 YES Address for link to send email on application section
menu.
SARWADF_CREDIT_CARD_ACCEPT_IND VARCHAR2 1 YES Indicator if the credit card is allowed (A), must be
entered (R) and pass approval before application can
be marked complete or not available (N).
SARWADF_DETL_CODE_CREDIT_CARD VARCHAR2 4 YES Detail code for credit card transaction.
SARWADF_ADMR_CODE_CREDIT_CARD VARCHAR2 4 YES Checklist code for credit card transaction.
SARWADF_AMOUNT_CREDIT_CARD NUMBER 12 2 YES Amount for credit card transaction.
SARWADF_CASHIER_CREDIT_CARD VARCHAR2 30 YES This column will not be used, the user entered on web
entered credit card transactions must be the web user
id.
SARWADF_TRAN_MISC_IND VARCHAR2 1 YES Y/N Indicator if the credit card transactions are
written to TBRMISD. A Y value indicates all
transactions are written to TBRMISD.
SARWADF_ACCEPT_WAIVER_IND VARCHAR2 1 YES Y/N indicator if a waiver can be entered in place of
paying an application fee.
SARWADF_INFC_CODE VARCHAR2 4 YES Interface Code to be used with automated matching
SARWADF_SSN_LN_IND VARCHAR2 1 NO Indicator that match should be based on SSN and Last
Name
SARWADF_LAST_NAME_LEN NUMBER 2 YES This field identifies the length to match on for the
last name
SARWADF_APLS_CODE VARCHAR2 4 YES Application Source code to be associated with Web
application
SARWADF_USE_ID_TYP VARCHAR2 1 YES This field indicates whether Gen ID, SSN or Web ID
should be used
SARWADF_SBGI_CODE VARCHAR2 6 YES This field will be loaded to SARRSRC_SBGI_CODE field
for corresponding SARADAP application.
SARWADF_AUTO_APPL_IND VARCHAR2 1 NO Indicator to Allow Creation of Application
SARWADF_AUTO_PUSH_IND VARCHAR2 1 NO Indicator to Allow Use of QuickStart
SARWADF_AUTO_RECR_IND VARCHAR2 1 NO Indicator to Automatically create recruit record
SARWADF_AUTO_DEC_IND VARCHAR2 1 NO Indicator to Allow Automatic decision on Web
Application
SARWADF_AUTO_TRAN_IND VARCHAR2 1 NO Indicator to Allow Automatic Transfer to Web for
Student
SARWADF_APDC_CODE VARCHAR2 2 YES Decision code to be applied to the application for
QuickStart
Date: 24-MAY-2004 Page: 111
TABLE: SARWADP
CREATOR: SATURN
Rules to control pull down list values for specific Web Admissions Application.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWADP_WAPP_CODE VARCHAR2 2 NO Electronic Applicant type code.
SARWADP_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARWADP_USER_ID VARCHAR2 30 NO This field identifies the most recent user that
updated the record.
SARWADP_VAL_TABLE VARCHAR2 30 NO Code that will identify the table of the customized
pull own lists on the Admissions web page.
SARWADP_VAL_CODE VARCHAR2 12 NO Code that will populate the customized pull down list
on the Web Admissions web page.
SARWADP_DESC VARCHAR2 30 YES Description that will appear in the pull down list.
If this value is left blank, the value from SORXREF
and then the validation table will be used.
Date: 24-MAY-2004 Page: 112
TABLE: SARWALT
CREATOR: SATURN
Entries for Signature Page Letters for Web Applications.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWALT_WAPP_CODE VARCHAR2 2 NO Module code for Web Application Code.
SARWALT_TERM_CODE_EFF VARCHAR2 6 NO Module code for Effective Term Code for Web
Application.
SARWALT_LTYP_CODE VARCHAR2 15 NO Module code for Web Signature Letter Type.
SARWALT_LETR_CODE VARCHAR2 15 NO Module code for Web Signature Letter Code.
SARWALT_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARWALT_USER_ID VARCHAR2 30 NO This field identifies the most recent user to create
or update a record.
Date: 24-MAY-2004 Page: 113
TABLE: SARWAPC
CREATOR: SATURN
Repeating table of Application Type codes associated with a curriculum major used in Web Quick Start! application
processing.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWAPC_CURR_RULE NUMBER 8 NO Curriculum Rule associated with the major (SORCMJR).
SARWAPC_CMJR_RULE NUMBER 8 NO Major rule (SORCMJR) that has an associated Web
application type.
SARWAPC_TERM_CODE_EFF VARCHAR2 6 NO Effective term code of the Major rule (SORCMJR) that
has an associated Web application type.
SARWAPC_WAPP_CODE VARCHAR2 2 NO Web application type associated with the curriculum
major(SORCMJR).
SARWAPC_ACTIVITY_DATE DATE 7 NO The most recent date a record was created
SARWAPC_USER_ID VARCHAR2 30 NO The most recent user to create or update a record.
Date: 24-MAY-2004 Page: 114
TABLE: SARWAPF
CREATOR: SATURN
Data element configuration controls for placement of elements on Admissions web pages.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWAPF_WAPP_CODE VARCHAR2 2 NO Electronic Applicant type code.
SARWAPF_WSCT_CODE VARCHAR2 10 NO Web data section code where element will be placed
within.
SARWAPF_WSCF_CODE VARCHAR2 30 NO Admissions web data element.
SARWAPF_SEQNO NUMBER 3 NO
SARWAPF_DISPLAY_IND VARCHAR2 1 NO Yes/No flag that data element will be displayed on the
admissions web page.
SARWAPF_REQUIRED_IND VARCHAR2 1 NO Yes/No flag that data element must be filled in by
applicant entering application on web.
SARWAPF_WSCF_DESC VARCHAR2 60 NO Description of admissions web data element. Also be
used for label next to element on web page.
SARWAPF_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARWAPF_USER_ID VARCHAR2 30 NO This field identifies the most recent user who updated
the record.
SARWAPF_WUDQ_SEQNO NUMBER 4 YES Sequence number entered on SAAWUDQ for free formatted
question. Can be filled in only if stvwsct_wudq_ind
is Y.
Date: 24-MAY-2004 Page: 115
TABLE: SARWAPP
CREATOR: SATURN
Web Application Section Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWAPP_WAPP_CODE VARCHAR2 2 NO Web Application Type Code
SARWAPP_WSCT_CODE VARCHAR2 10 NO Web Section Code
SARWAPP_SEQNO NUMBER 3 NO Sequence Number
SARWAPP_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARWAPP_ATYP_CODE VARCHAR2 2 YES Address Type Code
SARWAPP_WSCT_DESC VARCHAR2 30 YES Description and label for Admissions Web Data Section.
SARWAPP_EMAL_CODE VARCHAR2 4 YES Email code if data section is for email and default is
required.
Date: 24-MAY-2004 Page: 116
TABLE: SARWATD
CREATOR: SATURN
Calendar controls for displaying electronic applicants on the admissions web pages.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWATD_WAPP_CODE VARCHAR2 2 NO Electronic Applicant type code.
SARWATD_TERM_CODE VARCHAR2 6 NO Term code of display rule for electronic applications.
SARWATD_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARWATD_USER_ID VARCHAR2 30 NO This field identifies the most recent user who updated
the record.
SARWATD_START_DATE DATE 7 NO Start date when electronic applications for term can
be displayed on admissions web pages.
SARWATD_END_DATE DATE 7 NO End date when electronic applications for term can be
displayed on admissions web pages.
Date: 24-MAY-2004 Page: 117
TABLE: SARWATR
CREATOR: SATURN
Calendar controls for data entry of electronic applicants on the admissions web pages.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWATR_WAPP_CODE VARCHAR2 2 NO Electronic Applicant type code.
SARWATR_TERM_CODE VARCHAR2 6 NO Term code of data entry rule for electronic
applications.
SARWATR_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
SARWATR_USER_ID VARCHAR2 30 NO This field identifies the most recent user who updated
the record.
SARWATR_START_DATE DATE 7 NO Start date when electronic applications for term can
be entered on admissions web pages.
SARWATR_END_DATE DATE 7 NO End date when electronic applications for term can be
entered on admissions web pages.
Date: 24-MAY-2004 Page: 118
TABLE: SARWSCT
CREATOR: SATURN
WWW Application Section Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWSCT_AIDM NUMBER 8 NO Applicant Reference Number
SARWSCT_APPL_SEQNO NUMBER 3 NO Application Sequence Number
SARWSCT_WSCT_CODE VARCHAR2 10 NO WWW Section Code
SARWSCT_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 24-MAY-2004 Page: 119
TABLE: SARWUDQ
CREATOR: SATURN
Web User Defined Questions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SARWUDQ_WAPP_CODE VARCHAR2 2 NO Web Application Code
SARWUDQ_SEQNO NUMBER 4 NO Sequence Number
SARWUDQ_QUESTION VARCHAR2 2000 NO Question Text
SARWUDQ_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
SARWUDQ_QSTN_CDE VARCHAR2 30 YES EDI Question Code.
SARWUDQ_ADMR_CODE VARCHAR2 4 YES Admission Request Code: This field indicates the
checklist code associated with this question.
SARWUDQ_YES_NO_QSTN_IND VARCHAR2 1 YES Question Is Y/N Question: This field indicates if a
question asked on the web is a 'yes' or 'no' question.
This column will be used to display a Y/N radio button
on the web when the indicator is s
et to 'Y'.
Date: 24-MAY-2004 Page: 120
TABLE: SATAHLD
CREATOR: SATURN
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SATAHLD_SSN VARCHAR2 9 YES
SATAHLD_DATA_ELEMENT VARCHAR2 30 YES
SATAHLD_VALUE VARCHAR2 30 YES
SATAHLD_PREV_VALUE VARCHAR2 30 YES
SATAHLD_COMMENTS VARCHAR2 50 YES
SATAHLD_SBGI_CODE VARCHAR2 6 YES
SATAHLD_DEGC_CODE VARCHAR2 6 YES
SATAHLD_DATA_IND VARCHAR2 1 YES
Date: 24-MAY-2004 Page: 121
TABLE: SATAMAL
CREATOR: SATURN
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SATAMAL_SSN VARCHAR2 9 YES
SATAMAL_SSN_PREV VARCHAR2 9 YES
SATAMAL_AMCAS_FILE_NO VARCHAR2 5 YES
SATAMAL_CYCLE_ADD VARCHAR2 3 YES
SATAMAL_CHANGE_FLAG VARCHAR2 1 YES
SATAMAL_CHANGE_NO VARCHAR2 1 YES
SATAMAL_APPL_YEAR VARCHAR2 4 YES
SATAMAL_CYCLE_CHANGE VARCHAR2 3 YES
SATAMAL_EVAL VARCHAR2 1 YES
SATAMAL_EARLY_DCSN VARCHAR2 1 YES
SATAMAL_AMCAS_FEE_WAIVE VARCHAR2 1 YES
SATAMAL_LAST_NAME VARCHAR2 16 YES
SATAMAL_FIRST_NAME VARCHAR2 11 YES
SATAMAL_MI VARCHAR2 11 YES
SATAMAL_SUFFIX VARCHAR2 3 YES
SATAMAL_LAST_NAME_PREV VARCHAR2 16 YES
SATAMAL_STREET_1 VARCHAR2 30 YES
SATAMAL_CITY VARCHAR2 15 YES
SATAMAL_STATE VARCHAR2 2 YES
SATAMAL_ZIPC VARCHAR2 15 YES
SATAMAL_PHONE VARCHAR2 10 YES
SATAMAL_LEGAL_STATE VARCHAR2 2 YES
SATAMAL_LEGAL_CNTY_CODE VARCHAR2 3 YES
SATAMAL_LEGAL_CNTY_DESC VARCHAR2 20 YES
SATAMAL_LEGAL_CNTY_RURAL_IND VARCHAR2 1 YES
SATAMAL_LEGAL_NATN_CODE VARCHAR2 3 YES
SATAMAL_LEGAL_NATN_DESC VARCHAR2 20 YES
SATAMAL_VISA_TYPE VARCHAR2 2 YES
SATAMAL_SEX VARCHAR2 1 YES
SATAMAL_DOB VARCHAR2 8 YES
SATAMAL_BIRTH_STATE VARCHAR2 2 YES
SATAMAL_BIRTH_CITY VARCHAR2 15 YES
SATAMAL_BIRTH_CNTY_NATN VARCHAR2 3 YES
SATAMAL_BIRTH_CNTY_NATN_DESC VARCHAR2 20 YES
SATAMAL_BIRTH_CNTY_RURAL_IND VARCHAR2 1 YES
SATAMAL_AGE VARCHAR2 2 YES
SATAMAL_NUMBER_DEPENDENTS VARCHAR2 2 YES
SATAMAL_ETHN_SELF_REPORTED VARCHAR2 1 YES
SATAMAL_MINORITY_APP VARCHAR2 1 YES
SATAMAL_MILITARY_SERVICE VARCHAR2 1 YES
SATAMAL_PREV_MED_STUDENT VARCHAR2 1 YES
Date: 24-MAY-2004 Page: 122
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SATAMAL_DISCPLINARY_ACTION VARCHAR2 1 YES
SATAMAL_UNUSED VARCHAR2 1 YES
SATAMAL_PRIM_COLL_CODE_1 VARCHAR2 10 YES
SATAMAL_PRIM_COLL_DESC VARCHAR2 25 YES
SATAMAL_PRIM_COLL_STATE VARCHAR2 2 YES
SATAMAL_PRIM_COLL_PROG_TYPE VARCHAR2 1 YES
SATAMAL_PRIM_COLL_YRS_ATTND VARCHAR2 8 YES
SATAMAL_PRIM_COLL_MAJR VARCHAR2 2 YES
SATAMAL_PRIM_COLL_MAJR_DESC VARCHAR2 12 YES
SATAMAL_PRIM_COLL_DEGR VARCHAR2 2 YES
SATAMAL_PRIM_COLL_DEGR_DATE VARCHAR2 6 YES
SATAMAL_OTH1_COLL_CODE_1 VARCHAR2 10 YES
SATAMAL_OTH1_COLL_DESC VARCHAR2 25 YES
SATAMAL_OTH1_COLL_STATE VARCHAR2 2 YES
SATAMAL_OTH1_COLL_PROG_TYPE VARCHAR2 1 YES
SATAMAL_OTH1_COLL_YRS_ATTND VARCHAR2 8 YES
SATAMAL_OTH1_COLL_MAJR VARCHAR2 2 YES
SATAMAL_OTH1_COLL_MAJR_DESC VARCHAR2 12 YES
SATAMAL_OTH1_COLL_DEGR VARCHAR2 2 YES
SATAMAL_OTH1_COLL_DEGR_DATE VARCHAR2 6 YES
SATAMAL_OTH2_COLL_CODE_1 VARCHAR2 10 YES
SATAMAL_OTH2_COLL_DESC VARCHAR2 25 YES
SATAMAL_OTH2_COLL_STATE VARCHAR2 2 YES
SATAMAL_OTH2_COLL_PROG_TYPE VARCHAR2 1 YES
SATAMAL_OTH2_COLL_YRS_ATTND VARCHAR2 8 YES
SATAMAL_OTH2_COLL_MAJR VARCHAR2 2 YES
SATAMAL_OTH2_COLL_MAJR_DESC VARCHAR2 12 YES
SATAMAL_OTH2_COLL_DEGR VARCHAR2 2 YES
SATAMAL_OTH2_COLL_DEGR_DATE VARCHAR2 6 YES
SATAMAL_GPA_FR_BCPM VARCHAR2 3 YES
SATAMAL_GPA_FR_AO VARCHAR2 3 YES
SATAMAL_GPA_FR_TOTAL VARCHAR2 3 YES
SATAMAL_GPA_SO_BCPM VARCHAR2 3 YES
SATAMAL_GPA_SO_AO VARCHAR2 3 YES
SATAMAL_GPA_SO_TOTAL VARCHAR2 3 YES
SATAMAL_GPA_JR_BCPM VARCHAR2 3 YES
SATAMAL_GPA_JR_AO VARCHAR2 3 YES
SATAMAL_GPA_JR_TOTAL VARCHAR2 3 YES
SATAMAL_GPA_SR_BCPM VARCHAR2 3 YES
SATAMAL_GPA_SR_AO VARCHAR2 3 YES
SATAMAL_GPA_SR_TOTAL VARCHAR2 3 YES
SATAMAL_GPA_PB_BCPM VARCHAR2 3 YES
SATAMAL_GPA_PB_AO VARCHAR2 3 YES
SATAMAL_GPA_PB_TOTAL VARCHAR2 3 YES
SATAMAL_GPA_CUM_UG_BCPM VARCHAR2 3 YES
Date: 24-MAY-2004 Page: 123
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SATAMAL_GPA_CUM_UG_AO VARCHAR2 3 YES
SATAMAL_GPA_CUM_UG_TOTAL VARCHAR2 3 YES
SATAMAL_GPA_GR_BCPM VARCHAR2 3 YES
SATAMAL_GPA_GR_AO VARCHAR2 3 YES
SATAMAL_GPA_GR_TOTAL VARCHAR2 3 YES
SATAMAL_CRSS_FR_BCPM VARCHAR2 4 YES
SATAMAL_CRSS_FR_AO VARCHAR2 4 YES
SATAMAL_CRSS_SO_BCPM VARCHAR2 4 YES
SATAMAL_CRSS_SO_AO VARCHAR2 4 YES
SATAMAL_CRSS_JR_BCPM VARCHAR2 4 YES
SATAMAL_CRSS_JR_AO VARCHAR2 4 YES
SATAMAL_CRSS_SR_BCPM VARCHAR2 4 YES
SATAMAL_CRSS_SR_AO VARCHAR2 4 YES
SATAMAL_CRSS_PB_BCPM VARCHAR2 4 YES
SATAMAL_CRSS_PB_AO VARCHAR2 4 YES
SATAMAL_CRSS_CUM_UG_BCPM VARCHAR2 4 YES
SATAMAL_CRSS_CUM_UG_AO VARCHAR2 4 YES
SATAMAL_CRSS_GR_BCPM VARCHAR2 4 YES
SATAMAL_CRSS_GR_AO VARCHAR2 4 YES
SATAMAL_PFHOURS_FAIL VARCHAR2 4 YES
SATAMAL_PFHOURS_PASS VARCHAR2 4 YES
SATAMAL_AP_HOURS VARCHAR2 4 YES
SATAMAL_CLEP_HOURS VARCHAR2 4 YES
SATAMAL_PLUS_MINUS_GRADES VARCHAR2 1 YES
SATAMAL_NUMB_MCAT_TAKEN VARCHAR2 1 YES
SATAMAL_NEXT_MCAT_DATE VARCHAR2 6 YES
SATAMAL_MCAT1_TEST_DATE VARCHAR2 6 YES
SATAMAL_MCAT1_SERIES_CODE VARCHAR2 2 YES
SATAMAL_MCAT1_VERBAL VARCHAR2 2 YES
SATAMAL_MCAT1_PHYS_SCIENCE VARCHAR2 2 YES
SATAMAL_MCAT1_WRITING VARCHAR2 1 YES
SATAMAL_MCAT1_UNUSED_1 VARCHAR2 1 YES
SATAMAL_MCAT1_BIO_SCIENCE VARCHAR2 2 YES
SATAMAL_MCAT1_WS_FORM_NO VARCHAR2 3 YES
SATAMAL_MCAT1_UNUSED_2 VARCHAR2 1 YES
SATAMAL_MCAT1_MED_MAR VARCHAR2 1 YES
SATAMAL_MCAT1_NON_STAND_IND VARCHAR2 1 YES
SATAMAL_MCAT1_LITHO_CODE VARCHAR2 6 YES
SATAMAL_MCAT1_UNUSED_3 VARCHAR2 1 YES
SATAMAL_MCAT2_TEST_DATE VARCHAR2 6 YES
SATAMAL_MCAT2_SERIES_CODE VARCHAR2 2 YES
SATAMAL_MCAT2_VERBAL VARCHAR2 2 YES
SATAMAL_MCAT2_PHYS_SCIENCE VARCHAR2 2 YES
SATAMAL_MCAT2_WRITING VARCHAR2 1 YES
SATAMAL_MCAT2_UNUSED_1 VARCHAR2 1 YES
Date: 24-MAY-2004 Page: 124
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SATAMAL_MCAT2_BIO_SCIENCE VARCHAR2 2 YES
SATAMAL_MCAT2_WS_FORM_NO VARCHAR2 3 YES
SATAMAL_MCAT2_UNUSED_2 VARCHAR2 1 YES
SATAMAL_MCAT2_MED_MAR VARCHAR2 1 YES
SATAMAL_MCAT2_NON_STAND_IND VARCHAR2 1 YES
SATAMAL_MCAT2_LITHO_CODE VARCHAR2 6 YES
SATAMAL_MCAT2_UNUSED_3 VARCHAR2 1 YES
SATAMAL_ADV_INFO_RELEASE VARCHAR2 1 YES
SATAMAL_SCHOOL_STATE VARCHAR2 2 YES
SATAMAL_SCHOOL_NUMBER VARCHAR2 3 YES
SATAMAL_APPL_DATE VARCHAR2 8 YES
SATAMAL_PREV_YR_APPL_1 VARCHAR2 4 YES
SATAMAL_PREV_YR_APPL_2 VARCHAR2 4 YES
SATAMAL_PREV_YR_APPL_3 VARCHAR2 4 YES
SATAMAL_PREV_YR_APPL_4 VARCHAR2 4 YES
SATAMAL_ADMIT_ACTION_CODE VARCHAR2 2 YES
SATAMAL_ADMIT_ACTION_DATE VARCHAR2 8 YES
SATAMAL_MATRIC_DATE VARCHAR2 6 YES
SATAMAL_EXPECTED_GRAD_DATE VARCHAR2 6 YES
SATAMAL_ENTRY_1 VARCHAR2 1 YES Race code 2 reported by AMCAS.
SATAMAL_ENTRY_2 VARCHAR2 1 YES Race code 3 reported by AMCAS.
SATAMAL_ENTRY_3 VARCHAR2 1 YES Race code 4 reported by AMCAS.
SATAMAL_ENTRY_4 VARCHAR2 1 YES Race code 5 reported by AMCAS.
SATAMAL_ENTRY_5 VARCHAR2 1 YES Race code 6 reported by AMCAS.
SATAMAL_ENTRY_6 VARCHAR2 1 YES Race code 7 reported by AMCAS.
SATAMAL_ENTRY_7 VARCHAR2 1 YES Race code 8 reported by AMCAS.
SATAMAL_ENTRY_8 VARCHAR2 1 YES Race code 9 reported by AMCAS.
SATAMAL_EMAIL_ADDR VARCHAR2 60 YES
SATAMAL_END_UNUSED VARCHAR2 4 YES
SATAMAL_PROCESS_IND VARCHAR2 1 NO
SATAMAL_MATCH_IND VARCHAR2 1 YES
SATAMAL_OTH3_COLL_CODE_1 VARCHAR2 10 YES
SATAMAL_OTH3_COLL_DESC VARCHAR2 25 YES
SATAMAL_OTH3_COLL_STATE VARCHAR2 2 YES
SATAMAL_OTH3_COLL_PROG_TYPE VARCHAR2 1 YES
SATAMAL_OTH3_COLL_YRS_ATTND VARCHAR2 8 YES
SATAMAL_OTH3_COLL_MAJR VARCHAR2 2 YES
SATAMAL_OTH3_COLL_MAJR_DESC VARCHAR2 12 YES
SATAMAL_OTH3_COLL_DEGR VARCHAR2 2 YES
SATAMAL_OTH3_COLL_DEGR_DATE VARCHAR2 6 YES
SATAMAL_OTH4_COLL_CODE_1 VARCHAR2 10 YES
SATAMAL_OTH4_COLL_DESC VARCHAR2 25 YES
SATAMAL_OTH4_COLL_STATE VARCHAR2 2 YES
SATAMAL_OTH4_COLL_PROG_TYPE VARCHAR2 1 YES
SATAMAL_OTH4_COLL_YRS_ATTND VARCHAR2 8 YES
Date: 24-MAY-2004 Page: 125
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SATAMAL_OTH4_COLL_MAJR VARCHAR2 2 YES
SATAMAL_OTH4_COLL_MAJR_DESC VARCHAR2 12 YES
SATAMAL_OTH4_COLL_DEGR VARCHAR2 2 YES
SATAMAL_OTH4_COLL_DEGR_DATE VARCHAR2 6 YES
SATAMAL_OTH5_COLL_CODE_1 VARCHAR2 10 YES
SATAMAL_OTH5_COLL_DESC VARCHAR2 25 YES
SATAMAL_OTH5_COLL_STATE VARCHAR2 2 YES
SATAMAL_OTH5_COLL_PROG_TYPE VARCHAR2 1 YES
SATAMAL_OTH5_COLL_YRS_ATTND VARCHAR2 8 YES
SATAMAL_OTH5_COLL_MAJR VARCHAR2 2 YES
SATAMAL_OTH5_COLL_MAJR_DESC VARCHAR2 12 YES
SATAMAL_OTH5_COLL_DEGR VARCHAR2 2 YES
SATAMAL_OTH5_COLL_DEGR_DATE VARCHAR2 6 YES
SATAMAL_AAMC_ID VARCHAR2 10 YES ID number assigned by AMCAS system.
SATAMAL_VERIFIED_IND VARCHAR2 1 YES Indicator that the application has been verified.
SATAMAL_EFFECTIVE_DATE VARCHAR2 8 YES Date of when the application was included in the file
extract.
SATAMAL_APPL_TYPE VARCHAR2 1 YES Type code of the application included in the extract.
SATAMAL_BIO_NUMBER VARCHAR2 22 YES Bio number assigned by AMCAS.
SATAMAL_HISP_IND VARCHAR2 1 YES AMCAS Hispanic ethnicity indicator.
SATAMAL_PU_SHORT_DESC VARCHAR2 25 YES Short description for primary college.
SATAMAL_OT1_SHORT_DESC VARCHAR2 25 YES Short description for other college 1.
SATAMAL_OT2_SHORT_DESC VARCHAR2 25 YES Short description for other college 2.
SATAMAL_OT3_SHORT_DESC VARCHAR2 25 YES Short description for other college 3.
SATAMAL_OT4_SHORT_DESC VARCHAR2 25 YES Short description for other college 4.
SATAMAL_OT5_SHORT_DESC VARCHAR2 25 YES Short description for other college 5.
SATAMAL_NATN_CODE VARCHAR2 3 YES Preferred country code stored with preferred address.
SATAMAL_URM_IND VARCHAR2 1 YES AMCAS Under-represented Minority indicator.
SATAMAL_GPA_HS_BCPM VARCHAR2 3 YES High School BCPM GPA.
SATAMAL_GPA_HS_AO VARCHAR2 3 YES High School AO GPA.
SATAMAL_GPA_HS_TOTAL VARCHAR2 3 YES High School Total GPA.
SATAMAL_CRSS_HS_BCPM VARCHAR2 4 YES High School BCPM hours.
SATAMAL_CRSS_HS_AO VARCHAR2 4 YES High School AO hours.
SATAMAL_RACE10 VARCHAR2 1 YES Race code reported by AMCAS.
SATAMAL_ETHNIC1 VARCHAR2 1 YES Ethnic code reported by AMCAS.
SATAMAL_ETHNIC2 VARCHAR2 1 YES Ethnic code reported by AMCAS.
SATAMAL_ETHNIC3 VARCHAR2 1 YES Ethnic code reported by AMCAS.
SATAMAL_ETHNIC4 VARCHAR2 1 YES Ethnic code reported by AMCAS.
SATAMAL_ETHNIC5 VARCHAR2 1 YES Ethnic code reported by AMCAS.
SATAMAL_ETHNIC6 VARCHAR2 1 YES Ethnic code reported by AMCAS.
SATAMAL_ETHNIC7 VARCHAR2 1 YES Ethnic code reported by AMCAS.
SATAMAL_ETHNIC8 VARCHAR2 1 YES Ethnic code reported by AMCAS.
SATAMAL_ETHNIC9 VARCHAR2 1 YES Ethnic code reported by AMCAS.
SATAMAL_ETHNIC10 VARCHAR2 1 YES Ethnic code reported by AMCAS.
Date: 24-MAY-2004 Page: 126
TABLE: SATARPT
CREATOR: SATURN
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SATARPT_PIDM NUMBER 8 YES
SATARPT_SSN VARCHAR2 9 YES
SATARPT_SSN_PREV VARCHAR2 9 YES
SATARPT_MATCHED_IND VARCHAR2 1 YES
SATARPT_LAST_NAME VARCHAR2 16 YES
SATARPT_FIRST_NAME VARCHAR2 16 YES
SATARPT_SUFFIX VARCHAR2 3 YES
SATARPT_LAST_NAME_PREV VARCHAR2 16 YES
SATARPT_CHANGE_IND VARCHAR2 1 YES
Date: 24-MAY-2004 Page: 127
TABLE: SCBCDEP
CREATOR: SATURN
College/Department Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCBCDEP_COLL_CODE VARCHAR2 2 NO This field identifies the college code associated with
the college/department test base record.
SCBCDEP_DEPT_CODE VARCHAR2 4 YES This field identifies the department code associated
with the college/department base record. Department
code is optional.
SCBCDEP_TERM_CODE_START VARCHAR2 6 NO This field identifies the From Term of the earliest
version of the college/department text records.
SCBCDEP_TERM_CODE_END VARCHAR2 6 NO This field identifies the To Term of the lastest
version of the college/department text records.
SCBCDEP_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 128
TABLE: SCBCDTL
CREATOR: SATURN
Course catalog description narrative text by college and department table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCBCDTL_COLL_CODE VARCHAR2 2 NO College code. This field indicates the college code
of the course.
SCBCDTL_TERM_CODE_EFF VARCHAR2 6 NO Effective Term. This field identifies the term this
version of the course becomes effective.
SCBCDTL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the SCBCDTL table.
SCBCDTL_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
SCBCDTL_DEPT_CODE VARCHAR2 4 YES Department Code. This field indicates the department
code of the course. Text may be assigned to a course
college only or a college and department.
SCBCDTL_TEXT_NARRATIVE CLOB 4000 YES Course descriptive text is maintained here.
Date: 24-MAY-2004 Page: 129
TABLE: SCBCRKY
CREATOR: SATURN
Course Catalog Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCBCRKY_SUBJ_CODE VARCHAR2 4 NO This field displays the Subject area of courses in the
system. Completion of this field in query mode allows
you to query all courses currently defined in the
system for this Subject code.
SCBCRKY_CRSE_NUMB VARCHAR2 5 NO This field displays the Course Number of courses in
the system. Completion of this field in query mode
allows you to query all courses currently defined in
the system for this Course Number.
SCBCRKY_TERM_CODE_START VARCHAR2 6 NO This is the From Term of the earliest version of the
course. If changed to earlier or later term, all From
Terms change for this course to begin in this term.
It cannot be later than a term where sections are
scheduled.
SCBCRKY_TERM_CODE_END VARCHAR2 6 NO This is the To Term of the latest version of the
course. If changed to an earlier or later term, all
To Terms for this course will change to end in this
term. It cannot be earlier than a term where sections
are scheduled.
SCBCRKY_ACTIVITY_DATE DATE 7 NO This field specifes the date the record was created or
updated.
Date: 24-MAY-2004 Page: 130
TABLE: SCBCRSE
CREATOR: SATURN
Course General Information Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCBCRSE_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCBCRSE_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCBCRSE_EFF_TERM VARCHAR2 6 YES This field identifies the term this version of the
course becomes effective.
SCBCRSE_COLL_CODE VARCHAR2 2 YES This field is used to specify the college which offers
the course.
SCBCRSE_DIVS_CODE VARCHAR2 4 YES This field can be used to specify the division which
offers the course, if desired.
SCBCRSE_DEPT_CODE VARCHAR2 4 YES This field is used to specify the department which
offers the course, if desired.
SCBCRSE_CSTA_CODE VARCHAR2 1 YES Course Status Code. It is a required field. It can
be used to prevent creation of sections of the course
based on the Active/Inactive flag associated with the
status code.
SCBCRSE_TITLE VARCHAR2 30 YES This field is used to specify the title of the course
which will be in effect for the effective term. It is
a free format field.
SCBCRSE_CIPC_CODE VARCHAR2 6 YES This field can be used to record the CIP code of the
course. Normally, CIP course codes are used to
identify the primary subject matter of a course.
SCBCRSE_CREDIT_HR_IND VARCHAR2 2 YES This field defines whether the course can be offered
for variable credit. OR/TO is used to specify the
relationship between low and high credit hours.
values. An OR/TO value must exist to enter Credit
Hours High.
SCBCRSE_CREDIT_HR_LOW NUMBER 7 3 YES This field specifies the minimum number of credits for
which a course may be offered. Credit hour values
will control the number of credit hours for which
sections can be scheduled and for which students may
register.
SCBCRSE_CREDIT_HR_HIGH NUMBER 7 3 YES This field is used either to define a second valid
credit hour value or to define the high credit hour
value within a range. A value may only be entered if
the OR/TO field is complete and value must be > Credit
Hours Low.
SCBCRSE_LEC_HR_IND VARCHAR2 2 YES This field defines whether the course can be offered
for variable lecture hours. OR/TO is used to specify
the relationship between the low and high lecture hour
values. An OR/TO value must exist to enter Lecture
Hours High.
Date: 24-MAY-2004 Page: 131
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCBCRSE_LEC_HR_LOW NUMBER 7 3 YES This field is used to specify the minimum number of
lecture hours for which a course may be offered.
SCBCRSE_LEC_HR_HIGH NUMBER 7 3 YES This field is used either to define a second valid
lecture hour value or to define the high lecture hour
value within a range. A value may only be entered if
the OR/TO field is complete and must be > Lecture
Hours Low.
SCBCRSE_LAB_HR_IND VARCHAR2 2 YES This field defines whether the course can be offered
for variable lab hours. OR/TO is used to specify the
relationship between the low and high lab hour values.
An OR/TO value must exist to enter Lab Hours High.
SCBCRSE_LAB_HR_LOW NUMBER 7 3 YES This field is used to specify the minimum number of
lab hours for which a course may be offered.
SCBCRSE_LAB_HR_HIGH NUMBER 7 3 YES This field is used either to define a second valid lab
hour value or to define the high lab hour value within
a range. A value may only be entered if the OR/TO
field is complete and this field value must be > Lab
Hours Low.
SCBCRSE_OTH_HR_IND VARCHAR2 2 YES This field defines whether the course can be offered
for variable other hours. OR/TO is used to specify
the relationship between the low and high other hour
values. An OR/TO value must exist to enter Other
Hours High.
SCBCRSE_OTH_HR_LOW NUMBER 7 3 YES This field is used to specify the minimum number of
other hours for which the course can be offered.
Other hours is defined by the institution.
SCBCRSE_OTH_HR_HIGH NUMBER 7 3 YES This field is used to define a second valid other hour
value or to define the high other hours value within a
range. A value may only be entered if the OR/TO field
is complete and this field value must be > Other Hours
Low.
SCBCRSE_BILL_HR_IND VARCHAR2 2 YES This field defines whether the course can be billed
for variable credit. OR/TO is used to specify the
relationship between the low and high billing hour
values. An OR/TO value must exist to enter Billing
Hours High.
SCBCRSE_BILL_HR_LOW NUMBER 7 3 YES This field is used to specify the minimum number of
credits for which the course can be billed based on
defined assessment rules. Billing hours will default
to the values defined for credit hours, but may be
changed.
SCBCRSE_BILL_HR_HIGH NUMBER 7 3 YES This field defines a second valid billing hours value
or to define the high billing hours value within a
range. A value may only be entered if the OR/TO field
is complete and this field value must be > Billing
Hours Low.
SCBCRSE_APRV_CODE VARCHAR2 1 YES This field is used to record the type of requirements
a course is approved to fulfill.
Date: 24-MAY-2004 Page: 132
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCBCRSE_REPEAT_LIMIT NUMBER 2 YES This field is used to record the maximum number of
times the course may be repeated by a student. Zero
(0) will default. Repeat Limit is used in the repeat
check process in Academic History.
SCBCRSE_PWAV_CODE VARCHAR2 1 YES This field is used to record the type of authorization
a student must have in order to waive a pre-requisite
requirement. It is informational only.
SCBCRSE_TUIW_IND VARCHAR2 1 YES This field specifies whether the course is exempt from
tuit. and fees defined on Reg. Fees Process Control
Form - SFARGFE. If "Y", all rules on SFARGFE with "Y"
in Override field ignored. If "N", rules on SFARGFE
apply.
SCBCRSE_ADD_FEES_IND VARCHAR2 1 YES This field is used to record that additional fees,
outside of the SFARGFE assessment rules, are charged
for the course. Additional course fees are defined in
Fee Code Block of Course Detail Form - SCADETL. Info.
only.
SCBCRSE_ACTIVITY_DATE DATE 7 YES This field specifies the date the record was created
or updated.
SCBCRSE_CONT_HR_LOW NUMBER 7 3 YES This column contains the sum of low lecture, lab and
others hours columns. Contact hours divided by 10 are
the continuing education units for a continuing ed
course. This calculated value is stored in the credit
hour field when the ceu_ind = Y
SCBCRSE_CONT_HR_IND VARCHAR2 2 YES This column contains the literal TO or OR to define
the relationship between the low and high contact
hours
SCBCRSE_CONT_HR_HIGH NUMBER 7 3 YES This column contains the sum of high lecture, lab and
others hours columns. It functions the same as the
cont_hr_low column. A value may only be entered if
the OR/TO field is entered and must be > contact hours
low
SCBCRSE_CEU_IND VARCHAR2 1 YES
SCBCRSE_REPS_CODE VARCHAR2 2 YES Repeat status code used for reporting purposes.
SCBCRSE_MAX_RPT_UNITS NUMBER 9 3 YES Maximum number of credits permitted.
SCBCRSE_CAPP_PREREQ_TEST_IND VARCHAR2 1 NO Indicates whether CAPP areas or existing prerequisite
and test score restrictions are in effect for the
course for the effective term
SCBCRSE_DUNT_CODE VARCHAR2 4 YES Duration Unit code indicates the type of duration the
course is offered for
SCBCRSE_NUMBER_OF_UNITS NUMBER 7 2 YES Duration number of units indicates the total number of
times the duration unit extends
Date: 24-MAY-2004 Page: 133
TABLE: SCBDESC
CREATOR: SATURN
Course Catalog Description Narrative Text Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCBDESC_SUBJ_CODE VARCHAR2 4 NO Subject code. This field indicates the subject code
of the course.
SCBDESC_CRSE_NUMB VARCHAR2 5 NO Course number. This field indicatesd the course
number of the course.
SCBDESC_TERM_CODE_EFF VARCHAR2 6 NO Effective Term. This field identifies the term this
version of the course becomes effective.
SCBDESC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the SCBDESC table.
SCBDESC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
SCBDESC_TEXT_NARRATIVE CLOB 4000 YES Course descriptive text is maintained here.
SCBDESC_TERM_CODE_END VARCHAR2 6 YES End Term. Identifies the term that the course
description effective term ends
Date: 24-MAY-2004 Page: 134
TABLE: SCBSUPP
CREATOR: SATURN
Supplemental Course Data Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCBSUPP_SUBJ_CODE VARCHAR2 4 NO This is the subject code from the scbcrse table.
Combined with the course number
SCBSUPP_CRSE_NUMB VARCHAR2 5 NO This is the course number from the scbcrse table.
Combined with the subject code
SCBSUPP_EFF_TERM VARCHAR2 6 NO This is the effective term. Combined with subject
code and course number
SCBSUPP_TOPS_CODE VARCHAR2 6 YES Taxonomy of Program code
SCBSUPP_OCCS_CODE VARCHAR2 2 YES Occupational Course Indicator code
SCBSUPP_CCSL_CODE VARCHAR2 2 YES Classification Code
SCBSUPP_COOP_ED_IND VARCHAR2 1 YES Cooperative Education Indicator
SCBSUPP_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
SCBSUPP_PERM_DIST_IND VARCHAR2 12 YES Permanent District Identifier
SCBSUPP_CUDA_CODE VARCHAR2 15 YES Course Institutional Reporting Element 1 Code
SCBSUPP_CUDB_CODE VARCHAR2 15 YES Course Institutional Reporting Element 2 Code
SCBSUPP_CUDC_CODE VARCHAR2 15 YES Course Institutional Reporting Element 3 Code
SCBSUPP_CUDD_CODE VARCHAR2 15 YES Course Institutional Reporting Element 4 Code
SCBSUPP_CUDE_CODE VARCHAR2 15 YES Course Institutional Reporting Element 5 Code
SCBSUPP_CUDF_CODE VARCHAR2 15 YES Course Institutional Reporting Element 6 Code.
SCBSUPP_CREDIT_CATEGORY_IND VARCHAR2 5 YES Code for California MIS process for field CB22.
Date: 24-MAY-2004 Page: 135
TABLE: SCRATTR
CREATOR: SATURN
Course Attribute Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRATTR_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course
SCRATTR_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course
SCRATTR_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course attributes become effective
SCRATTR_ATTR_CODE VARCHAR2 4 YES This field defines the attribute code of the course
SCRATTR_ACTIVITY_DATE DATE 7 NO This field identifies the date the record was created
or updated
Date: 24-MAY-2004 Page: 136
TABLE: SCRCDTX
CREATOR: SATURN
College/Department Text Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRCDTX_COLL_CODE VARCHAR2 2 NO This field identifies the college code associated with
the text.
SCRCDTX_DEPT_CODE VARCHAR2 4 YES This field identifies the department code associated
with the text. This field is optional.
SCRCDTX_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
college/department text becomes effective.
SCRCDTX_SEQNO NUMBER 23 20 YES This field identifies the internal sequence number
associated with the line of text. Does not display on
form.
SCRCDTX_TEXT VARCHAR2 60 YES This field is used to enter or display college or
college/department text. Each line is an individual
record and an unlimited number of records may be
maintained. No word processing functions are
provided.
SCRCDTX_TEXT_CODE VARCHAR2 1 YES This field is used to internally resequence text when
a new line has been added. Valid value is: "A".
SCRCDTX_ACTIVITY_DATE DATE 7 NO This field specifies the date the record was created
or updated.
Date: 24-MAY-2004 Page: 137
TABLE: SCRCORQ
CREATOR: SATURN
Course Corequisites Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRCORQ_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRCORQ_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRCORQ_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course corequisites becomes effective.
SCRCORQ_SUBJ_CODE_CORQ VARCHAR2 4 YES This field is used to define co-requisite subjects for
a course. Co-requisites are not required to create a
course. An unlimited number of co-requisites can be
authorized for a course.
SCRCORQ_CRSE_NUMB_CORQ VARCHAR2 5 YES This field defines the course number of the
co-requisite course requirement. When registering
students, the system looks for exact matches on
Subject and Course, however, course number is not
validated against valid courses.
SCRCORQ_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 138
TABLE: SCRCPRT
CREATOR: SATURN
Partition Codes define campus zones, which are catagories or groupings of rooms. This table contains course
partition codes in the catalog module.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRCPRT_SUBJ_CODE VARCHAR2 4 NO Subject code for catalog course partitions.
SCRCPRT_CRSE_NUMB VARCHAR2 5 NO Course Number for catalog course partitions.
SCRCPRT_TERM_CODE_EFF VARCHAR2 6 NO Effective Term code for catalog course partition code.
SCRCPRT_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created/updated
SCRCPRT_USER_ID VARCHAR2 30 NO User ID of last person to create/update record.
SCRCPRT_PARS_CODE VARCHAR2 7 YES Partition code for catalog course entry.
SCRCPRT_PARS_PREF_NUMBER NUMBER 2 YES Preference Number for Partition code for catalog
course entry.
Date: 24-MAY-2004 Page: 139
TABLE: SCRCRDF
CREATOR: SATURN
Room definition/attribute Codes for catalog entries. This describes characteristics of rooms required for the
scheduling tool.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRCRDF_SUBJ_CODE VARCHAR2 4 NO Subject code for catalog course room
definition/attributes.
SCRCRDF_CRSE_NUMB VARCHAR2 5 NO Course Number for catalog course room
definition/attributes.
SCRCRDF_TERM_CODE_EFF VARCHAR2 6 NO Effective Term code for catalog course room
definition/attribute code.
SCRCRDF_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created/updated
SCRCRDF_USER_ID VARCHAR2 30 NO User ID of last person to create/update record.
SCRCRDF_RDEF_CODE VARCHAR2 4 YES Room definition/attribute code for catalog course
entry.
SCRCRDF_RDEF_PREF_NUMBER NUMBER 2 YES Preference Number for room definition/attribute code
for catalog course entry.
Date: 24-MAY-2004 Page: 140
TABLE: SCREQIV
CREATOR: SATURN
Equivalent Course Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCREQIV_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCREQIV_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCREQIV_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course equivalents becomes effective.
SCREQIV_SUBJ_CODE_EQIV VARCHAR2 4 YES 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.
SCREQIV_CRSE_NUMB_EQIV VARCHAR2 5 YES This field defines the course number of the equivalent
course. Course numbers are not validated against
valid course versions.
SCREQIV_START_TERM VARCHAR2 6 YES This field specifies the start term of the course
version which is equivalent to the course entered in
the Key Block.
SCREQIV_END_TERM VARCHAR2 6 YES This field is used to specify the end term of the
course version which is equivalent to the course
entered in the Key Block.
SCREQIV_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 141
TABLE: SCRFEES
CREATOR: SATURN
Course Fees Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRFEES_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRFEES_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRFEES_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course fees becomes effective.
SCRFEES_DETL_CODE VARCHAR2 4 YES This field defines detail codes which can be assessed
for the course in the key block. Detail codes must
have a type of C (charge) on the Detail Code Control
Form - TSADETC.
SCRFEES_FEE_IND VARCHAR2 1 YES This field is used to specify whether the course fee
will be assessed on a per-credit hour basis (C) or on
a flat basis (F). "C" and "F" are the only valid
values.
SCRFEES_FEE_IND_IND NUMBER 1 YES This field is used to convert the fee indicator of F -
flat or C - per credit to a 1 or 0. "F" is converted
to a "1" and "C" is converted to a "0".
SCRFEES_FEE_AMOUNT NUMBER 6 2 YES If Form TSADETC has a defined default amount for the
detail code it will default here when the detail code
is entered. If not, or the course fee is different
than the default, the amount may be entered or changed
here.
SCRFEES_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SCRFEES_FTYP_CODE VARCHAR2 4 YES Fee Type code: this field is used to identify the type
of fee to fee assessment.
Date: 24-MAY-2004 Page: 142
TABLE: SCRGMOD
CREATOR: SATURN
Course Grading Modes Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRGMOD_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRGMOD_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRGMOD_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of course
grading modes becomes effective.
SCRGMOD_GMOD_CODE VARCHAR2 1 NO This field is used to define grading mode
authorizations for a course. Each course must be
authorized to be offered with at least one grading
mode. A course can be authorized with an unlimited
number of grading modes.
SCRGMOD_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or updated.
SCRGMOD_DEFAULT_IND VARCHAR2 1 YES This field is used to specify the grading mode which
will default for the grading mode on the Registration
Form - SFAREGS. At least one grading mode must be a
default (D) and it may be overridden on the SFAREGS
Form.
Date: 24-MAY-2004 Page: 143
TABLE: SCRLEVL
CREATOR: SATURN
Course Level Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRLEVL_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRLEVL_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRLEVL_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course level becomes effective.
SCRLEVL_LEVL_CODE VARCHAR2 2 NO This field is used to authorize the level for which a
course may be offered. Each course must be authorized
to be offered for at least one level. A course can be
authorized for an unlimited number of levels.
SCRLEVL_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 144
TABLE: SCRRARE
CREATOR: SATURN
Course Area Restriction Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRARE_SUBJ_CODE VARCHAR2 4 NO Course subject code
SCRRARE_CRSE_NUMB VARCHAR2 5 NO Course number
SCRRARE_TERM_CODE_EFFECTIVE VARCHAR2 6 NO Identifies the term this version of the course
registration Area restriction becomes effective
SCRRARE_ACTIVITY_DATE DATE 7 NO Date of last update or insert
SCRRARE_SEQNO NUMBER 23 20 YES The sequence number is used to insure the record will
be in the correct order
SCRRARE_AREA VARCHAR2 10 YES This field defines the Area(s) of students for which
course registration restrictions exist. The
Include/Exclude field will determine how the Area is
restricted. An unlimited number of Areas maybe
defined.
Date: 24-MAY-2004 Page: 145
TABLE: SCRRCAM
CREATOR: SATURN
Catalog Campus Restriction Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRCAM_SUBJ_CODE VARCHAR2 4 NO Catalog campus restriction subject code
SCRRCAM_CRSE_NUMB VARCHAR2 5 NO Catalog campus restriction course number
SCRRCAM_EFF_TERM VARCHAR2 6 NO Catalog campus restriction effective term
SCRRCAM_REC_TYPE VARCHAR2 1 NO Catalog campus restriction record type
SCRRCAM_CAMP_IND VARCHAR2 1 YES Catalog campus restriction inclusion or exclusion
indicator
SCRRCAM_CAMP_CODE VARCHAR2 3 YES Catalog campus restriction campus code
SCRRCAM_ACTIVITY_DATE DATE 7 NO The Activity Date
Date: 24-MAY-2004 Page: 146
TABLE: SCRRCLS
CREATOR: SATURN
Course Class Restriction Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRCLS_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRRCLS_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRRCLS_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course registration classification restrictions
becomes effective.
SCRRCLS_REC_TYPE VARCHAR2 1 NO This field defines if the record contains a class
indicator or a class code. Valid values are: 1 -
Class indicator, 2 - Class code.
SCRRCLS_CLASS_IND VARCHAR2 1 YES This field indicates if the classification codes
entered should be included or excluded in restricting
the course. Valid values are: I - Include, E -
Exclude.
SCRRCLS_CLAS_CODE VARCHAR2 2 YES This field defines the classification codes of
students for which registration restrictions exist.
The Include/Exclude field will determine how the
classification is restricted.
SCRRCLS_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 147
TABLE: SCRRCMP
CREATOR: SATURN
Course Campus Restriction Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRCMP_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRRCMP_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRRCMP_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course restrictions on campus becomes effective.
SCRRCMP_REC_TYPE VARCHAR2 1 NO This field is defines if the record contains a campus
indicator or a campus code. Valid values are: 1 -
Campus indicator, 2 - Campus code.
SCRRCMP_CAMP_IND VARCHAR2 1 YES This field indicates if the campus codes entered
should be included or excluded for restricting the
scheduling of the course. Valid values are: I -
Include, E - Exclude.
SCRRCMP_CAMP_CODE VARCHAR2 3 YES This field defines the campus codes for which campus
schedule restrictions exist. The Include/Exclude
field will determine how the campus is restricted. An
unlimited number of campuses may be defined.
SCRRCMP_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 148
TABLE: SCRRCOL
CREATOR: SATURN
Course College Restriction Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRCOL_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRRCOL_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRRCOL_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course registration college restrictions becomes
effective.
SCRRCOL_REC_TYPE VARCHAR2 1 NO This field defines if the record contains a college
indicator or a college code. Valid values are: 1 -
College indicator, 2 - College code.
SCRRCOL_COLL_IND VARCHAR2 1 YES This field indicates if the college codes entered
should be included or excluded in restricting the
course. Valid values are: I - Include, E -Exclude.
SCRRCOL_COLL_CODE VARCHAR2 2 YES This field defines the college(s) of students for
which course registration restrictions exist. The
Include/Exclude field will determine how the college
is restricted. An unlimited number of colleges may be
defined.
SCRRCOL_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record is
created or updated.
Date: 24-MAY-2004 Page: 149
TABLE: SCRRDEG
CREATOR: SATURN
Course Degree Restriction Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRDEG_SUBJ_CODE VARCHAR2 4 NO Course subject area code
SCRRDEG_CRSE_NUMB VARCHAR2 5 NO Course number
SCRRDEG_TERM_CODE_EFFECTIVE VARCHAR2 6 NO Identifies the term this version of the course
registration degree restriction becomes effective
SCRRDEG_REC_TYPE VARCHAR2 1 NO Defines if the record contains a degree indicator or a
degree code. Valid values (1) Degree indicator, (2)
Degree code.
SCRRDEG_ACTIVITY_DATE DATE 7 NO Date of last update or insert
SCRRDEG_DEGC_IND VARCHAR2 1 YES Indicates if the degree codes entered should be
included or excluded in restriction the course. Valid
values (I) Include, (E) Exclude
SCRRDEG_DEGC_CODE VARCHAR2 6 YES This field defines the degree(s) of students for which
course registration restrictions exist. The
Include/Exclude field will determine how the degree is
restricted. An unlimited number of degrees may
be
defined.
Date: 24-MAY-2004 Page: 150
TABLE: SCRRLVL
CREATOR: SATURN
Course Level Restriction Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRLVL_SUBJ_CODE VARCHAR2 4 NO Course Level Restriction Subject Code
SCRRLVL_CRSE_NUMB VARCHAR2 5 NO Course Level Restriction Course Number
SCRRLVL_EFF_TERM VARCHAR2 6 NO Course Level Restriction Effective Term
SCRRLVL_REC_TYPE VARCHAR2 1 NO Course Level Restriction Record Type.
SCRRLVL_LEVL_IND VARCHAR2 1 YES Course Level Restriction Indicator
SCRRLVL_LEVL_CODE VARCHAR2 4 YES Course Level Restriction Level Code
SCRRLVL_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
Date: 24-MAY-2004 Page: 151
TABLE: SCRRMAJ
CREATOR: SATURN
Course Major Restriction Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRMAJ_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRRMAJ_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRRMAJ_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course registration major restrictions becomes
effective.
SCRRMAJ_REC_TYPE VARCHAR2 1 NO This field defines if the record contains a major
indicator or a major code. Valid values are: 1 -
Major indicator, 2 - Major code.
SCRRMAJ_MAJOR_IND VARCHAR2 1 YES This field indicates if the major codes entered should
be included or excluded in restricting the course.
Valid values are: I - Include, E - Exclude.
SCRRMAJ_MAJR_CODE VARCHAR2 4 YES This field defines the majors of students for which
registration restrictions exist. The Include/Exclude
field will determine how the major is restricted. An
unlimited number of majors may be defined.
SCRRMAJ_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 152
TABLE: SCRRPRG
CREATOR: SATURN
Course Program Restriction Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRPRG_SUBJ_CODE VARCHAR2 4 NO Course subject area code
SCRRPRG_CRSE_NUMB VARCHAR2 5 NO Course number
SCRRPRG_TERM_CODE_EFFECTIVE VARCHAR2 6 NO Identifies the term this version of the course
registration Program restriction becomes effective
SCRRPRG_REC_TYPE VARCHAR2 1 NO Defines if the record contains a Program indicator or
a Program code. Valid values (1) Program indicator,
(2) Program code.
SCRRPRG_ACTIVITY_DATE DATE 7 NO Date of last update or insert
SCRRPRG_PROGRAM_IND VARCHAR2 1 YES Indicates if the Program codes entered should be
included or excluded in restriction the course. Valid
values (I) Include, (E) Exclude
SCRRPRG_PROGRAM VARCHAR2 12 YES This field defines the Program(s) of students for
which course registration restrictions exist. The
Include/Exclude field will determine how the Program
is restricted. An unlimited number of Programs may
be
defined.
Date: 24-MAY-2004 Page: 153
TABLE: SCRRTRM
CREATOR: SATURN
Course Term Restriction Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRTRM_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRRTRM_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRRTRM_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course term restrictions becomes effective.
SCRRTRM_REC_TYPE VARCHAR2 1 NO This field defines if the recod contains a term
indicator or a term code. Valid values are: 1 - Term
indicator, 2 - Term code.
SCRRTRM_TERM_IND VARCHAR2 1 YES This field indicates if the term codes entered should
be included or excluded in restricting the scheduling
of the course. Valid values are: I - Include, E -
Exclude.
SCRRTRM_RTRM_CODE VARCHAR2 2 YES This field defines the term codes for which term
scheduling restrictions exist. The Include/Exclude
field will determine how the term is restricted. An
unlimited number of terms may be defined.
SCRRTRM_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 154
TABLE: SCRRTST
CREATOR: SATURN
The course test score restriction and course pre-requisites table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRRTST_SUBJ_CODE VARCHAR2 4 NO The subject code that the test score restriction and
pre-requisite associated with
SCRRTST_CRSE_NUMB VARCHAR2 5 NO The course number that the test score restriction and
pre-requisite associated with
SCRRTST_TERM_CODE_EFF VARCHAR2 6 NO The effective term associated with the test score
restriction and pre-requisite
SCRRTST_SEQNO NUMBER 23 20 YES The sequence number is used to insure the record will
be in the correct order
SCRRTST_TESC_CODE VARCHAR2 4 YES The test code associated with the restriction
SCRRTST_TEST_SCORE VARCHAR2 5 YES The minimum score of the test code
SCRRTST_SUBJ_CODE_PREQ VARCHAR2 4 YES This field defines the subject area for course
pre-requisite requirements.
SCRRTST_CRSE_NUMB_PREQ VARCHAR2 5 YES This field defines the course number for course
pre-requisite requirements.
SCRRTST_LEVL_CODE VARCHAR2 2 YES The level code for grade
SCRRTST_MIN_GRDE VARCHAR2 6 YES The minimum grade required
SCRRTST_CONCURRENCY_IND VARCHAR2 1 YES This field specifies that the pre-requisite course
requirement can be taken at the same time as the Key
Block course."Y" indicates that the pre-req. course
may be taken at the same time
SCRRTST_CONNECTOR VARCHAR2 1 YES The AND/OR connector used when restriction for the
subject/course/term can have an AND/OR relationship
SCRRTST_LPAREN VARCHAR2 1 YES Left parenthesis
SCRRTST_RPAREN VARCHAR2 1 YES Right parenthesis
SCRRTST_ACTIVITY_DATE DATE 7 NO The date the record was created or last updated
Date: 24-MAY-2004 Page: 155
TABLE: SCRSBGI
CREATOR: SATURN
Source background institution agreements table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRSBGI_SUBJ_CODE VARCHAR2 4 NO Source background institution agreement subject code
SCRSBGI_CRSE_NUMB VARCHAR2 5 NO Source background institution agreement course number
SCRSBGI_EFF_TERM VARCHAR2 6 NO Source background institution agreement effective term
SCRSBGI_SBGI_CODE VARCHAR2 6 YES Source background institution code
SCRSBGI_AGREEMENT_DATE DATE 7 NO Source background institution agreement date
SCRSBGI_ACTIVITY_DATE DATE 7 NO The Activity Date
Date: 24-MAY-2004 Page: 156
TABLE: SCRSCHD
CREATOR: SATURN
Course Schedule Type Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRSCHD_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRSCHD_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRSCHD_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course schedule types becomes effective.
SCRSCHD_SCHD_CODE VARCHAR2 3 NO This field defines the schedule type codes which can
be authorized for a course. Each course must be
authorized to be offered for at least one schedule
type. An unlimited number of schedule types can be
authorized for a course.
SCRSCHD_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SCRSCHD_WORKLOAD NUMBER 9 3 YES Instructional workload value for the schedule type
SCRSCHD_MAX_ENRL NUMBER 3 YES Maximum student enrollment for workload
SCRSCHD_ADJ_WORKLOAD NUMBER 9 3 YES Adjust instructional workload value for the schedule
type
SCRSCHD_INSM_CODE VARCHAR2 5 YES Instructional Method code: This field indicates how
the course is delivered to the learner. Examples are
Web based, mixed media, face to face
Date: 24-MAY-2004 Page: 157
TABLE: SCRSECT
CREATOR: SATURN
Schedule History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRSECT_SUBJ_CODE VARCHAR2 4 NO Course subject of the schedule that has been deleted
from data base by scheduling purge
SCRSECT_CRSE_NUMB VARCHAR2 5 NO Course number of the schedule that has been deleted
from data base by scheduling purge
SCRSECT_CAMP_CODE VARCHAR2 3 NO Campus of the course schedule that has been deleted
from data base by scheduling purge
SCRSECT_SCHD_CODE VARCHAR2 3 NO Schedule type of the course schedule that has been
deleted from data base by scheduling purge
SCRSECT_TERM_CODE VARCHAR2 6 NO Term of the course schedule that has been deleted from
data base by scheduling purge
SCRSECT_SECT_OFFER NUMBER 3 NO Number of the sections for the deleted schedule with
same campus, same schedule type and same term has been
offered
SCRSECT_ENRL NUMBER 6 NO The actual enrollment for the deleted schedule
SCRSECT_CENSUS_ENRL NUMBER 6 NO The census enrollment for the deleted schedule
SCRSECT_ACTIVITY_DATE DATE 7 NO The date when the record was added or last updated
Date: 24-MAY-2004 Page: 158
TABLE: SCRSPRT
CREATOR: SATURN
Partition Codes define campus zones, which are catagories or groupings of rooms. This table contains subject
partition codes in the catalog module.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRSPRT_SUBJ_CODE VARCHAR2 4 NO Subject code for catalog subject partitions.
SCRSPRT_TERM_CODE_EFF VARCHAR2 6 NO Effective Term code for catalog subject partition
code.
SCRSPRT_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created/updated
SCRSPRT_USER_ID VARCHAR2 30 NO User ID of last person to create/update record.
SCRSPRT_PARS_CODE VARCHAR2 7 YES Partition code for catalog subject entry.
SCRSPRT_PARS_PREF_NUMBER NUMBER 2 YES Preference Number for Partition code for catalog
subject entry.
Date: 24-MAY-2004 Page: 159
TABLE: SCRSRDF
CREATOR: SATURN
Room definition/attribute Codes for catalog subject entries. This describes characteristics of rooms required for
the scheduling tool.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRSRDF_SUBJ_CODE VARCHAR2 4 NO Subject code for catalog subject room
definition/attributes.
SCRSRDF_TERM_CODE_EFF VARCHAR2 6 NO Effective Term code for catalog subject room
definition/attribute code.
SCRSRDF_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created/updated
SCRSRDF_USER_ID VARCHAR2 30 NO User ID of last person to create/update record.
SCRSRDF_RDEF_CODE VARCHAR2 4 YES room definition/attribute code for catalog subject
entry.
SCRSRDF_RDEF_PREF_NUMBER NUMBER 2 YES Preference Number for room definition/attribute code
for catalog subject entry.
Date: 24-MAY-2004 Page: 160
TABLE: SCRSYLN
CREATOR: SATURN
Course Syllabus course long name table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRSYLN_SUBJ_CODE VARCHAR2 4 NO Identifies the subject code of the course that the
long name is attached to
SCRSYLN_CRSE_NUMB VARCHAR2 5 NO Identifies the course number of the course that the
long name is attached to
SCRSYLN_TERM_CODE_EFF VARCHAR2 6 NO Identifies the Start Term for which the long name is
applicable to
SCRSYLN_ACTIVITY_DATE DATE 7 NO Date this record entered or last updated
SCRSYLN_USER_ID VARCHAR2 30 NO The username of the person who entered or last updated
this record
SCRSYLN_TERM_CODE_END VARCHAR2 6 YES Identifies the term that the course long name
effective term ends
SCRSYLN_LONG_COURSE_TITLE VARCHAR2 100 YES The long title of the course
SCRSYLN_COURSE_URL VARCHAR2 100 YES The URL of the course
Date: 24-MAY-2004 Page: 161
TABLE: SCRSYLO
CREATOR: SATURN
Course Syllabus course learning objective table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRSYLO_SUBJ_CODE VARCHAR2 4 NO Identifies the subject code of the course that the
learning objective is attached to
SCRSYLO_CRSE_NUMB VARCHAR2 5 NO Identifies the course number of the course that the
learning objective is attached to
SCRSYLO_TERM_CODE_EFF VARCHAR2 6 NO Identifies the Start Term for which the learning
objective is applicable to
SCRSYLO_ACTIVITY_DATE DATE 7 NO Date this record entered or last updated
SCRSYLO_USER_ID VARCHAR2 30 NO The username of the person who entered or last updated
this record
SCRSYLO_TERM_CODE_END VARCHAR2 6 YES Identifies the Term that the learning objective
effective term ends
SCRSYLO_LEARNING_OBJECTIVES CLOB 4000 YES The Learning Objective of the course
Date: 24-MAY-2004 Page: 162
TABLE: SCRSYRM
CREATOR: SATURN
Course Syllabus course required materials table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRSYRM_SUBJ_CODE VARCHAR2 4 NO Identifies the subject code of the course that the
required material is attached to
SCRSYRM_CRSE_NUMB VARCHAR2 5 NO Identifies the course number of the course that the
required material is attached to
SCRSYRM_TERM_CODE_EFF VARCHAR2 6 NO Identifies the Start Term for which the required
material is applicable to
SCRSYRM_ACTIVITY_DATE DATE 7 NO Date this record entered or last updated
SCRSYRM_USER_ID VARCHAR2 30 NO The username of the person who entered or last updated
this record
SCRSYRM_TERM_CODE_END VARCHAR2 6 YES Identifies the Term that the required material
effective term ends
SCRSYRM_REQUIRED_MATERIALS CLOB 4000 YES The Required Materials for the course
Date: 24-MAY-2004 Page: 163
TABLE: SCRSYTR
CREATOR: SATURN
Course Syllabus course technical requirements table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRSYTR_SUBJ_CODE VARCHAR2 4 NO Identifies the subject code of the course that the
technical requirement is attached to
SCRSYTR_CRSE_NUMB VARCHAR2 5 NO Identifies the course number of the course that the
technical requirement is attached to
SCRSYTR_TERM_CODE_EFF VARCHAR2 6 NO Identifies the Start Term for which the long name is
applicable to
SCRSYTR_ACTIVITY_DATE DATE 7 NO Date this record entered or last updated
SCRSYTR_USER_ID VARCHAR2 30 NO The username of the person who entered or last updated
this record
SCRSYTR_TERM_CODE_END VARCHAR2 6 YES Identifies the term that the course technical
requirement effective term ends
SCRSYTR_TECHNICAL_REQUIREMENT CLOB 4000 YES The Technical Requirements for the course
Date: 24-MAY-2004 Page: 164
TABLE: SCRTEXT
CREATOR: SATURN
Course Descriptive Text Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SCRTEXT_SUBJ_CODE VARCHAR2 4 NO This field defines the subject area of the course.
SCRTEXT_CRSE_NUMB VARCHAR2 5 NO This field defines the course number associated with
the subject for the course.
SCRTEXT_EFF_TERM VARCHAR2 6 NO This field identifies the term this version of the
course text becomes effective.
SCRTEXT_TEXT_CODE VARCHAR2 1 YES This field is used to internally resequence text when
a new line has been added. Valid value is: "A".
SCRTEXT_SEQNO NUMBER 23 20 YES This field identifies an internal sequence number
associated with each line of text. This field is not
displayed.
SCRTEXT_TEXT VARCHAR2 60 YES Course text is maintained in these records. Text will
be reproduced in the Bulletin Report - SCRBULT,
exactly as keyed here. An unlimited number of text
records can be maintained in this block.
SCRTEXT_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 24-MAY-2004 Page: 165
TABLE: SDBCMAR
CREATOR: SATURN
Compliance Area Requirements Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDBCMAR_ACTIVITY_DATE DATE 7 NO This field specifies the date record was created or
updated.
SDBCMAR_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDBCMAR_PROGRAM VARCHAR2 6 NO This field identifies the students degree program that
has been processed through compliance.
SDBCMAR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDBCMAR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc) associated with the degree program.
SDBCMAR_REQD_MIN_GPA NUMBER 10 6 NO This field identifies the minimum GPA required to
satisfy the area specified.
SDBCMAR_REQD_MIN_HOURS_RES NUMBER 5 2 NO This field identifies the minimum hours in residence
at the institution that are required to satisfy the
area specified.
SDBCMAR_ACTL_MIN_GPA NUMBER 10 6 NO This field identifies the student"s actual GPA for the
area specified.
SDBCMAR_ACTL_MIN_HOURS_RES NUMBER 5 2 NO This field identifies the student"s actual number of
hours in residence for the area specified.
SDBCMAR_ACTL_GPA_HRS NUMBER 5 2 YES This field identifies the student"s actual number of
GPA hours to be used in the calculation of the actual
GPA.
SDBCMAR_ACTL_QUAL_POINTS NUMBER 5 2 YES This field identifies the student"s actual number of
quality points to be used in the calculation of the
actual GPA.
SDBCMAR_REQD_MIN_HOURS NUMBER 5 2 NO Required Minimum Hours for the area
SDBCMAR_ACTL_MIN_HOURS NUMBER 5 2 NO Actual Minimum Hours for the area
Date: 24-MAY-2004 Page: 166
TABLE: SDBCMGR
CREATOR: SATURN
Compliance General Requirements Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDBCMGR_ACTIVITY_DATE DATE 7 NO This field specifies the date record was created or
updated.
SDBCMGR_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDBCMGR_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has been processed through compliance.
SDBCMGR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDBCMGR_REQD_MIN_GPA NUMBER 10 6 NO This field identifies the general requirement of the
minimum GPA needed to satisfy the degree program.
SDBCMGR_REQD_MIN_HOURS NUMBER 5 2 NO This field identifies the general requirement of the
mimimum credit hours needed to satisfy the degree
program.
SDBCMGR_REQD_MIN_HOURS_RES NUMBER 5 2 NO This field identifies the general requirement of the
minimum hours in residence at the institution (not
transfer) needed to satisfy the degree program.
SDBCMGR_REQD_MIN_TRAD_HRS_RES NUMBER 5 2 NO This field identifies the general requirement of the
minimum traditional hours in residence at the
institution (normally graded courses) needed to
satisfy the degree program.
SDBCMGR_REQD_MAX_NTRAD_HRS_RES NUMBER 5 2 NO This field identifies the general requirement of the
maximum non-traditional hours in residence at the
institution (pass/fail, audit, etc.) allowed to
satisfy the degree program.
SDBCMGR_ACTL_MIN_GPA NUMBER 10 6 NO This field identifies the student"s actual GPA for the
degree program.
SDBCMGR_ACTL_MIN_HOURS NUMBER 5 2 NO This field identifies the student"s actual number of
credit hours for the degree program.
SDBCMGR_ACTL_MIN_HOURS_RES NUMBER 5 2 NO This field identifies the student"s actual number of
hours in residence at the institution (not transfer)
for the degree program.
SDBCMGR_ACTL_MIN_TRAD_HRS_RES NUMBER 5 2 NO This field identifies the student"s actual number of
traditional hours in residence for the degree program.
Traditional hours are determined based on the
traditional grade flag on the Grade Code Maintenance
Form (SHAGRDE).
SDBCMGR_ACTL_MAX_NTRAD_HRS_RES NUMBER 5 2 NO This field identifies the student"s actual number of
non-traditional hours (pass/fail, audit, etc.) in
residence for the degree program.
Date: 24-MAY-2004 Page: 167
TABLE: SDBCMPL
CREATOR: SATURN
Compliance Base Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDBCMPL_ACTIVITY_DATE DATE 7 NO This field specifies the date record was created or
updated.
SDBCMPL_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDBCMPL_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has been processed through compliance.
SDBCMPL_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDBCMPL_VERIFICATION_DATE DATE 7 NO This field specifies the date the compliance
verification was processed for this student"s degree
program.
SDBCMPL_GENERAL_REQ_IND VARCHAR2 1 NO This field indicates if the student has satisfied the
degree program general requirements. Valid values
are: Y - Requirements satisfied, N - Requirements not
satisfied.
SDBCMPL_COURSE_REQ_IND VARCHAR2 1 NO This field indicates if the student has satisfied the
degree program course requirements. Valid values are:
Y - Requirements satisfied, N - Requirements not
satisfied.
SDBCMPL_NON_COURSE_REQ_IND VARCHAR2 1 NO This field indiciates if the student has satisfied the
degree program non-course requirements. Valid values
are: Y - Requirements satisfied, N - Requirememts not
satisfied.
Date: 24-MAY-2004 Page: 168
TABLE: SDBCMRC
CREATOR: SATURN
Compliance Request Collector File
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDBCMRC_SESSIONID VARCHAR2 30 YES This field identifies the userid of the user who
requested a batch compliance.
SDBCMRC_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDBCMRC_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that is being requested for a compliance.
SDBCMRC_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDBCMRC_ACTIVITY_DATE DATE 7 NO This field identifies the date record was created or
updated.
SDBCMRC_DEGR_CRSE_IND VARCHAR2 1 YES Apply degree course indicator, Y = apply only the
degree course for degree audit, N = apply all the
course for degree audit and default will be N
SDBCMRC_DEGR_APPLIED_UPD_IND VARCHAR2 1 YES An indicator to have the degree compliance updating
the applied degree indicator in academic history
course and transfer course
Date: 24-MAY-2004 Page: 169
TABLE: SDBDEGR
CREATOR: SATURN
Ddgree Audit Degree Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDBDEGR_ACTIVITY_DATE DATE 7 NO This field specifies the date the record was created
or updated.
SDBDEGR_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDBDEGR_DGMR_SEQ_NO NUMBER 2 NO This field identifies the sequence number of the
student"s degree.
SDBDEGR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the student"s degree.
SDBDEGR_PRIM_PROGRAM VARCHAR2 6 NO This field identifies the degree program code
associated with the primary program of the student"s
degree.
SDBDEGR_SEC_PROGRAM VARCHAR2 6 YES This field identifies the degree program code
associated with the secondary program of the student"s
degree.
SDBDEGR_LEVL_CODE VARCHAR2 2 NO Degree Level Code.
SDBDEGR_DEGS_CODE VARCHAR2 2 NO Degree Program Degree Code.
SDBDEGR_GRAD_DATE DATE 7 YES Degree Graduate Date.
SDBDEGR_APPL_DATE DATE 7 YES Degree Application Date.
Date: 24-MAY-2004 Page: 170
TABLE: SDBDPGR
CREATOR: SATURN
Degree Program General Requirements Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDBDPGR_ACTIVITY_DATE DATE 7 NO This field identifies the date record was created or
updated.
SDBDPGR_PROGRAM VARCHAR2 6 NO This field identifies the degree program code for
general requirements.
SDBDPGR_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year when the
general requirements are effective.
SDBDPGR_MIN_GPA NUMBER 10 6 YES This field identifies the general requirement of the
minimum GPA needed to satisfy the degree program.
SDBDPGR_MIN_HOURS NUMBER 5 2 YES This field identifies the general requirement of the
minimum credit hours needed to satisfy the degree
program.
SDBDPGR_MIN_HOURS_RES NUMBER 5 2 YES This field identifies the general requirement of the
minimum hours in residence at the institution (not
transfer) needed to satisfy the degree program.
SDBDPGR_MIN_TRAD_HOURS_RES NUMBER 5 2 YES This field identifies the general requirement of the
minimum traditional hours (normally graded courses) in
residence at the institution (not transfer) needed to
satisfy the degree program.
SDBDPGR_MAX_NON_TRAD_HOURS_RES NUMBER 5 2 YES This field identifies the general requirement of the
maximum non traditional hours (pass/fail, audit, etc)
in residence at the insititution (not transfer)
allowed to satisfy the degree program.
Date: 24-MAY-2004 Page: 171
TABLE: SDBPROG
CREATOR: SATURN
Program Code Maintenance Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDBPROG_ACTIVITY_DATE DATE 7 NO This field identifies the date record was created or
updated.
SDBPROG_PROGRAM VARCHAR2 6 NO This field identifies the degree program code. Can be
system assigned or user defined.
SDBPROG_DESC VARCHAR2 30 NO This field identifies the free format description of
the degree program.
SDBPROG_CIPC_CODE VARCHAR2 6 NO This field identifies the CIP code associated with the
degree program.
SDBPROG_START_BLTN_YEAR VARCHAR2 4 NO This field specifies the beginning bulletin year
(academic year or catalog) of the degree program.
Identifies catalog in which degree is first offered.
SDBPROG_END_BLTN_YEAR VARCHAR2 4 NO This field specifies the ending bulletin year of the
degree program. Identifies the last catalog in which
degree is valid.
SDBPROG_DEGC_CODE VARCHAR2 6 NO This field identifies the degree associated with the
degree program code.
SDBPROG_COLL_CODE VARCHAR2 2 NO This field identifies the college of the degree
associated with the degree program code.
Date: 24-MAY-2004 Page: 172
TABLE: SDBSMUC
CREATOR: SATURN
Student Degree Program Multiple Use Course Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDBSMUC_ACTIVITY_DATE DATE 7 NO This field specifies the date record was created or
updated.
SDBSMUC_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDBSMUC_PROGRAM VARCHAR2 6 NO This field identifies the degree program to specify
the student"s multiple use courses.
SDBSMUC_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDBSMUC_SEQ_NO NUMBER 2 NO This field specifies the sequence number associated
with the multiple use course.
SDBSMUC_TERM_CODE VARCHAR2 6 NO This field specifies the term of the student"s course
that is being identified to satisfy multiple course
requirements.
SDBSMUC_SUBJ_CODE VARCHAR2 4 NO This field specifies the subject of the student"s
course that is being identified to satisfy multiple
course requirements.
SDBSMUC_CRSE_NUMB VARCHAR2 4 NO This field specifies the course number of the
student"s course that is being identified to satisfy
multiple course requirements.
SDBSMUC_HOURS NUMBER 4 2 NO This field specifies the number of credit hours of the
student"s course that is being identified to satisfy
multiple course requirements.
SDBSMUC_TRANSFER_IND VARCHAR2 1 NO This field indicates if the student"s course that is
being identified to satisfy multiple course
requirements is an institutional or transfer course.
Valid values are: I - Institutional course, T -
Transfer course.
SDBSMUC_ATTR_CODE VARCHAR2 4 YES Multiple use course attribute code
Date: 24-MAY-2004 Page: 173
TABLE: SDBSSAR
CREATOR: SATURN
Student Specific Area Requirements Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDBSSAR_ACTIVITY_DATE DATE 7 NO This field identifies the date record was created or
updated.
SDBSSAR_PIDM NUMBER 8 NO Internal Identification Number of the student who has
specific area requirements.
SDBSSAR_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program for
the specific area requirements.
SDBSSAR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDBSSAR_AREA_CODE VARCHAR2 4 NO This field identifies the student specific area code
for the degree program.
SDBSSAR_MIN_GPA NUMBER 10 6 NO This field specifies the minimum GPA needed for the
student to satisfy this specific area requirement.
SDBSSAR_MIN_HOURS_RES NUMBER 5 2 NO This field specifies the minimum hours in residence at
the institution (not transfer) needed for the student
to satisfy this specific area requirement.
SDBSSAR_MIN_HOURS NUMBER 5 2 NO Minimum Hours Requirement for the area
Date: 24-MAY-2004 Page: 174
TABLE: SDRACTX
CREATOR: SATURN
Degree Program General Requirements Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRACTX_PROGRAM VARCHAR2 6 NO Degree program code for attribute requirements
comments
SDRACTX_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO Bulletin year when the attribute requirements comments
are effective
SDRACTX_SEQNO NUMBER 23 20 YES Computer generated sequence number used to order the
attribute requirements comments
SDRACTX_TEXT VARCHAR2 60 YES Comment text associated with the degree program
attribute requirements
SDRACTX_ACTIVITY_DATE DATE 7 NO Indicates the date the record was created or updated
Date: 24-MAY-2004 Page: 175
TABLE: SDRCCNU
CREATOR: SATURN
Compliance Courses Not Used Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRCCNU_ACTIVITY_DATE DATE 7 NO This field specifies the date record was created or
updated.
SDRCCNU_PIDM NUMBER 8 NO Internal Identification Number of the student who has
unused course in compliance.
SDRCCNU_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has been processed through compliance and has
unused courses.
SDRCCNU_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRCCNU_SUBJ_CODE VARCHAR2 4 NO This field identifies the subject of the unused
course.
SDRCCNU_GRDE_CODE VARCHAR2 3 NO This field identifies the grade of the unused course.
SDRCCNU_CRSE_NUMB VARCHAR2 4 YES This field identifies the course number of the unused
course.
SDRCCNU_CRSE_TITLE VARCHAR2 30 YES This field identifies the title of the unused course.
SDRCCNU_TERM_CODE VARCHAR2 6 YES This field identifies the term the unused course was
taken.
SDRCCNU_HOURS NUMBER 4 2 YES This field identifies the credit hours of the unused
course.
SDRCCNU_TCKN_SEQ_NO NUMBER 2 YES The tckn sequence number for the non-used course of
degree audit
SDRCCNU_CRN VARCHAR2 5 YES The course reference number for the non-used course of
degree audit
Date: 24-MAY-2004 Page: 176
TABLE: SDRCMAT
CREATOR: SATURN
Attribute General Requirements Compliance Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRCMAT_PIDM NUMBER 8 NO Student Pidm.
SDRCMAT_PROGRAM VARCHAR2 6 NO Degree Program
SDRCMAT_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO Degree Program Effective Bulletin Year
SDRCMAT_ATTR_CODE VARCHAR2 4 YES General Requirements Attribute code
SDRCMAT_REQD_MIN_HOURS NUMBER 5 2 YES Attribute General Requirements Actual Minimum Hours
SDRCMAT_REQD_MIN_HOURS_RES NUMBER 5 2 YES Attribute General Requirements Actual Minimum Hours
Residence
SDRCMAT_ACTL_MIN_HOURS NUMBER 5 2 YES Student Actual Minimum Hours.
SDRCMAT_ACTL_MIN_HOURS_RES NUMBER 5 2 YES Student Actual Residence Minimum Hours.
SDRCMAT_ACTIVITY_DATE DATE 7 NO Activity Date
Date: 24-MAY-2004 Page: 177
TABLE: SDRCMCR
CREATOR: SATURN
Compliance Cluster Requirements Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRCMCR_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDRCMCR_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has been processed through compliance.
SDRCMCR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRCMCR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) associated with the cluster.
SDRCMCR_CMPR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the group
associated with the cluster.
SDRCMCR_SEQ_NO NUMBER 2 NO This field specifies the sequence number assigned to
the cluster.
SDRCMCR_STATUS_IND VARCHAR2 1 NO This field indicates if the student met the cluster
requirement. Valid values are: Y - Satisfied
requirement, N - Did not satisfy requirement.
SDRCMCR_ACTIVITY_DATE DATE 7 NO This field identifies the date record was created or
updated.
Date: 24-MAY-2004 Page: 178
TABLE: SDRCMSR
CREATOR: SATURN
Compliance Course Requirements Satisfied Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRCMSR_ACTIVITY_DATE DATE 7 NO This field identifies the date record was created or
updated.
SDRCMSR_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDRCMSR_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has been processed through complance..
SDRCMSR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRCMSR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) associated with the degree program.
SDRCMSR_CMPR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the group
associated with the cluster.
SDRCMSR_CMCR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the
cluster associated with the course requirement.
SDRCMSR_CMRR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the course
requirement for the cluster, group, and area
associated with the degree program.
SDRCMSR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the course
from the student"s academic history that satisfied the
course requirement.
SDRCMSR_SUBJ_CODE VARCHAR2 4 NO This field identifies the subject of the student"s
course that satisfied the course requirement.
SDRCMSR_GRDE_CODE VARCHAR2 3 NO This field identifies the grade of the student"s
course that satisfied the course requirement.
SDRCMSR_CRSE_NUMB VARCHAR2 4 YES This field identifies the course number of the
student"s course that satisfied the course
requirement.
SDRCMSR_TERM_CODE VARCHAR2 6 YES This field identifies the term the student took the
course that satisfied the course requirement.
SDRCMSR_HOURS NUMBER 4 2 YES This field identifies the credit of the student"s
course that satisfied the course requirement.
SDRCMSR_CRSE_TITLE VARCHAR2 30 YES This field identifies the title of the student"s
course that satisfied the course requirement.
SDRCMSR_TCKN_SEQ_NO NUMBER 2 YES The tckn sequence number for the satisfied course of
degree audit
SDRCMSR_CRN VARCHAR2 5 YES The course reference number for the course satisfied
of degree audit
Date: 24-MAY-2004 Page: 179
TABLE: SDRCNCR
CREATOR: SATURN
Compliance Non-Course Requirements Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRCNCR_ACTIVITY_DATE DATE 7 NO This field identifies the date record was created or
updated.
SDRCNCR_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDRCNCR_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has been processed through compliance.
SDRCNCR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRCNCR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) associated with the non-course
requirement for the degree program.
SDRCNCR_NCRQ_CODE VARCHAR2 4 NO This field identifies the non-course requirement
associated with the degree program.
SDRCNCR_SAT_IND VARCHAR2 1 NO This field indicates if the non-course requirement has
been satisfied for the student. Valid values: Y -
Requirement satisfied, N - Requirement not satisfied.
Will default from the status code.
SDRCNCR_NCST_CODE VARCHAR2 2 YES This field identifies the non-course requirement
status code. The status code indicates is the status
means satisfied or not.
SDRCNCR_NCST_DATE DATE 7 YES This field specifies the date the non-course
requirement status was entered or updated.
SDRCNCR_ADVR_PIDM NUMBER 8 YES This field identifies the internal identification
number for the advisor responsible for the status of
the non-course requirement.
Date: 24-MAY-2004 Page: 180
TABLE: SDRCOLR
CREATOR: SATURN
Degree Audit Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRCOLR_SESSIONID VARCHAR2 30 NO The user sessionid
SDRCOLR_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDRCOLR_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has been processed through compliance.
SDRCOLR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRCOLR_ACTIVITY_DATE DATE 7 NO This field identifies the date record was created or
updated.
Date: 24-MAY-2004 Page: 181
TABLE: SDRDCMT
CREATOR: SATURN
Student Degree Program Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRDCMT_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRDCMT_PIDM NUMBER 8 NO Internal Identification Number of the student.
SDRDCMT_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program.
SDRDCMT_SEQ_NO NUMBER 23 20 NO This field identifies the internal sequence number of
the comment line. It does not display on-line.
SDRDCMT_TEXT VARCHAR2 50 NO This field specifies free format comment text.
SDRDCMT_PRINT_IND VARCHAR2 1 NO This field indicates if the comment should print on
the student"s degree audit compliance verification
report. Valid values: Y - print, N - do not print.
Date: 24-MAY-2004 Page: 182
TABLE: SDRDPAR
CREATOR: SATURN
Degree Program Area Requirements Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRDPAR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRDPAR_PROGRAM VARCHAR2 6 NO This field identifies the degree program associated
with the area requirements.
SDRDPAR_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO This filed identifies the bulletin year this version
of the area requirement becomes effective.
SDRDPAR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) for the degree program.
SDRDPAR_MIN_GPA NUMBER 10 6 YES This field identifies the minimum GPA required to
satisfy the area specfied. If no GPA is required,
0.00 is the default.
SDRDPAR_MIN_HOURS_RES NUMBER 5 2 YES This field identifies the minimum in residence
(institutional only, not transfer hours) required to
satisfy the area requirement. If no minimum is
required, 0.00 is the default.
SDRDPAR_MIN_HOURS NUMBER 5 2 YES Minimum Hours Requirement for the area
Date: 24-MAY-2004 Page: 183
TABLE: SDRDPAT
CREATOR: SATURN
Attribute General Requirements Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRDPAT_PROGRAM VARCHAR2 6 NO Dgree Program
SDRDPAT_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO Dgree Program Effective Bulletin Year
SDRDPAT_ATTR_CODE VARCHAR2 4 YES General Requirements Attribute code
SDRDPAT_MIN_HOURS NUMBER 5 2 YES Attribute General Requirements Minimum Hours
SDRDPAT_MIN_HOURS_RES NUMBER 5 2 YES Attribute General Requirements Minimum Hours Residence
SDRDPAT_ACTIVITY_DATE DATE 7 NO Activity Date
Date: 24-MAY-2004 Page: 184
TABLE: SDRDPCR
CREATOR: SATURN
Degree Program Cluster Requirements Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRDPCR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRDPCR_PROGRAM VARCHAR2 6 NO This field identifies the degree program associated
with the cluster requirements.
SDRDPCR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) associated with the cluster
requiements.
SDRDPCR_DPPR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the group
associated with the cluster requirements.
SDRDPCR_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year this version
of the cluster requirements becomes effective.
SDRDPCR_SEQ_NO NUMBER 2 NO This field specifies the sequence number assigned to
the cluster. A cluster defines an "OR" relationship
between selections of course requirements.
SDRDPCR_MIN_HOURS NUMBER 5 2 YES This field specifies the minimum number of course
requirement hours that must be met to satisfy the
cluster requirement.
SDRDPCR_DESC VARCHAR2 60 YES This field identifies a free-format description of the
cluster.
SDRDPCR_DESC2 VARCHAR2 60 YES The second line of the degree program cluster
requirement description
SDRDPCR_DESC3 VARCHAR2 60 YES The third line of the degree program cluster
requirement description
Date: 24-MAY-2004 Page: 185
TABLE: SDRDPNC
CREATOR: SATURN
Degree Program Non-Course Requirements Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRDPNC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
changed or updated.
SDRDPNC_PROGRAM VARCHAR2 6 NO This field identifies the degree program associated
with the non-course requirement.
SDRDPNC_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year this version
of the non-course requirements becomes effective.
SDRDPNC_AREA_CODE VARCHAR2 4 YES This field identifies the area code (math, social
sciences, etc.) associated with the non-course
requirements.
SDRDPNC_NCRQ_CODE VARCHAR2 4 YES This field specifies the non-course requirement needed
to satisfy the degree program. A non-course
requirement is any activity that is not an actual
course in the course catalog, such as a senior paper,
that must be completed.
Date: 24-MAY-2004 Page: 186
TABLE: SDRDPPR
CREATOR: SATURN
Degree Program Group Requirements Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRDPPR_ACTIVITY_DATE DATE 7 NO This field identifies the most current date record was
created or updated.
SDRDPPR_PROGRAM VARCHAR2 6 NO This field identifies the degree program associated
with the group requirements.
SDRDPPR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) associated with the group
requirements.
SDRDPPR_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year this version
of the group requirements becomes effective.
SDRDPPR_SEQ_NO NUMBER 2 NO This field specifies the sequence number assigned to
the group. A group is defined, as at least one
cluster of course requirements. Multiple groups are
an "AND" relationship. Ex-Group 1 and Group 2 are
needed to satisfy an area req.
SDRDPPR_CVO_NUMBER NUMBER 2 1 YES This field identifies the compliance verification
order number. This number determines the order the
groups are processed through compliance. The lower
the number the higher the order.
SDRDPPR_MAX_HOURS NUMBER 5 2 YES This field specifies the maximum hours of course
requirements that can be taken from the clusters
associated with the group. The default value is
999.99".
SDRDPPR_DESC VARCHAR2 60 YES This field identifies a free-format description of the
group.
SDRDPPR_CRSE_REUSE_IND VARCHAR2 1 YES Course reuse flag
SDRDPPR_ATTR_REUSE_IND VARCHAR2 1 YES Course attribute reuse flag
SDRDPPR_AREA_REUSE_IND VARCHAR2 1 YES Area course reuse flag
SDRDPPR_GRUP_REUSE_IND VARCHAR2 1 YES The group course re-use flag
SDRDPPR_DESC2 VARCHAR2 60 YES The second line of the degree program group
requirement description
SDRDPPR_DESC3 VARCHAR2 60 YES The third line of the degree program group requirement
description
Date: 24-MAY-2004 Page: 187
TABLE: SDRDPSR
CREATOR: SATURN
Degree Program Course Requirements Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRDPSR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRDPSR_PROGRAM VARCHAR2 6 NO This field identifies the degree program associated
with the course requirements.
SDRDPSR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) associated with the course
requirements.
SDRDPSR_DPPR_SEQ_NO NUMBER 2 NO This field identifies the sequence number of the group
within the area associated with the course
requirements.
SDRDPSR_DPCR_SEQ_NO NUMBER 2 NO This field identifies the sequence number of the
cluster within the group and area associated with the
course requirements.
SDRDPSR_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year this version
of the course requirements becomes effective.
SDRDPSR_SEQ_NO NUMBER 2 NO This field specifies the sequence number assigned to
the course requirement. A course requirement
identifies the specific course or range of courses to
be used to satisfy the requirements for a cluster,
group, area, degree program.
SDRDPSR_ACTION_IND VARCHAR2 1 YES This field indicates the type of course requirement.
Valid values are: O - Optional course requirement, R -
Required course requirement, E - Exclude course from
previous range.
SDRDPSR_SUBJ_CODE VARCHAR2 4 YES This field identifies the subject code of the course
requirement. Value of "XXXX" indicates that all
subjects are valid.
SDRDPSR_MIN_GRDE_CODE VARCHAR2 3 YES This field identifies the minimum grade needed to meet
the course requirement.
SDRDPSR_TRANSFER_IND VARCHAR2 1 YES This field indicates if a transfer course may be used
to satisfy the course requirement. Valid values are:
N - No restrictions on using transfer courses, Y -
Institutional courses only may be used.
SDRDPSR_FROM_CRSE_NUMB VARCHAR2 4 YES This field indicates the beginning range of the course
number for a course requirement. If the requirement
consists of only one course, the course number would
be here.
SDRDPSR_TO_CRSE_NUMB VARCHAR2 4 YES This field indicates the endng range of the course
number for a course requirement. The field would be
blank if the requirement consists of only one course.
Date: 24-MAY-2004 Page: 188
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRDPSR_TERM_CODE_FROM VARCHAR2 6 YES This field indicates the beginning range of the terms
the course is valid as a requirement. If the course
is valid for only one term, the term would be here.
If the course requirement is valid for all terms, no
term would be entered.
SDRDPSR_TERM_CODE_TO VARCHAR2 6 YES This field indicates the ending range of the terms the
course is valid as a requirement. If course is valid
for only one term, this field would be blank.
SDRDPSR_FROM_HOURS NUMBER 4 2 YES This field indicates the beginning range of the valid
credit hours the course requirement may be taken for.
If there is no range, the single value would be in
this field.
SDRDPSR_TO_HOURS NUMBER 4 2 YES This field indicates the ending range of the valid
credit hours the course requirement may be taken for.
If there is no range, this field would be blank.
SDRDPSR_ATTR_CODE VARCHAR2 4 YES The course attribute code
Date: 24-MAY-2004 Page: 189
TABLE: SDRMCTX
CREATOR: SATURN
Degree Program General Requirement Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRMCTX_PROGRAM VARCHAR2 6 NO Degree program code for general requirements comments
SDRMCTX_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO Bulletin year when the general requirements comments
are effective
SDRMCTX_SEQNO NUMBER 23 20 YES Computer generated sequence number used to order the
general requirements comments
SDRMCTX_TEXT VARCHAR2 60 YES Comment text associated with the degree program
general requirements
SDRMCTX_ACTIVITY_DATE DATE 7 NO Indicates the date the record was created or updated
Date: 24-MAY-2004 Page: 190
TABLE: SDRNCTX
CREATOR: SATURN
Degree Program Non-course Requirements Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRNCTX_PROGRAM VARCHAR2 6 NO Degree program code for non-course requirements
comments
SDRNCTX_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO Bulletin year when the non-course requirements
comments are effective
SDRNCTX_SEQNO NUMBER 23 20 YES Computer generated sequence number used to order the
non-course requirements comments
SDRNCTX_TEXT VARCHAR2 60 YES Comment text associated with the degree program
non-course requirements
SDRNCTX_ACTIVITY_DATE DATE 7 NO Indicates the date the record was created or updated
Date: 24-MAY-2004 Page: 191
TABLE: SDRPCNC
CREATOR: SATURN
Program Code Area Of Concentration Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRPCNC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRPCNC_PROGRAM VARCHAR2 6 NO This field identifies the degree program code
associated with the major.
SDRPCNC_MAJR_CODE_AREA VARCHAR2 4 NO This field identifies the concentration code that is
valid for the degree program.
Date: 24-MAY-2004 Page: 192
TABLE: SDRPCTX
CREATOR: SATURN
Degree Program Area Requirements Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRPCTX_PROGRAM VARCHAR2 6 NO Degree program code for area requirements comments
SDRPCTX_EFFECTIVE_BLTN_YEAR VARCHAR2 4 NO Bulletin year when the area requirements comments are
effective
SDRPCTX_AREA VARCHAR2 4 NO Area code for area requirements comments
SDRPCTX_SEQNO NUMBER 23 20 YES Computer generated sequence number used to order the
area requirements comments
SDRPCTX_TEXT VARCHAR2 60 YES Comment text associated with the degree program area
requirements
SDRPCTX_ACTIVITY_DATE DATE 7 NO Indicates the date the record was created or updated
Date: 24-MAY-2004 Page: 193
TABLE: SDRPMJR
CREATOR: SATURN
Program Code Major Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRPMJR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRPMJR_PROGRAM VARCHAR2 6 NO This field identifies the degree program associated
with the major.
SDRPMJR_MAJR_CODE_MAJOR VARCHAR2 4 NO This field identifies the major code that is valid for
the degree program.
Date: 24-MAY-2004 Page: 194
TABLE: SDRPMNR
CREATOR: SATURN
Program Code Minor Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRPMNR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRPMNR_PROGRAM VARCHAR2 6 NO This field identifies the degreee program code
associated with the minor.
SDRPMNR_MAJR_CODE_MINOR VARCHAR2 4 NO This field identifies the minor code that is valid for
the degree program.
Date: 24-MAY-2004 Page: 195
TABLE: SDRSAWV
CREATOR: SATURN
Student Degree Program Area Waivers Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSAWV_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or added.
SDRSAWV_PIDM NUMBER 8 NO Internal Identification Number of student who has a
waiver of an area requirement.
SDRSAWV_PROGRAM VARCHAR2 6 NO This field specifies the degree program for which the
student has an area GPA and/or minimum hour
requirement waiver.
SDRSAWV_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRSAWV_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) that is associated with the waiver.
SDRSAWV_GPA_REAS_CODE VARCHAR2 2 YES This field identifies the reason code for waiving the
minimum GPA requirement for the area. If the field is
blank, the requirement was not waived.
SDRSAWV_MIN_HOURS_REAS_CODE VARCHAR2 2 YES This field identifies the reason code for waiving the
minimum hours in residence requirement for the area.
If the field is blank, the requirement was not waived.
Date: 24-MAY-2004 Page: 196
TABLE: SDRSCAD
CREATOR: SATURN
Student Degree Program Course Additions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSCAD_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRSCAD_PIDM NUMBER 8 NO Internal Identification Number of the student who has
additional course requirements for their degree
program.
SDRSCAD_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has additional course requirements.
SDRSCAD_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRSCAD_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) of the degree program.
SDRSCAD_DPPR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the group
within the area that additional course requirements
are being added for.
SDRSCAD_DPCR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the
cluster within the group that additional course
requirements are being added for.
SDRSCAD_SEQ_NO NUMBER 2 NO This field specifies the sequence number associated
with the new course requirement being added. Must be
different than existing course sequence numbers for
the area/group/cluster.
SDRSCAD_ACTION_IND VARCHAR2 1 NO This field indicates the type of course requirement.
Valid values are: O - Optional course requirement, R -
Required course requirement, E - Excluded requirement
from previous range.
SDRSCAD_SUBJ_CODE VARCHAR2 4 YES This field identifies the subject code of the
additional course requirement for the student.
SDRSCAD_MIN_GRDE_CODE VARCHAR2 3 YES This field identifies the minimum grade needed to meet
the course requirement.
SDRSCAD_TRANSFER_IND VARCHAR2 1 NO This field indicates if a transfer course may be used
to satisfy the course requirement. Valid values are:
N - no restrictions on using transfer courses, Y -
Institutional courses only may be used.
SDRSCAD_FROM_CRSE_NUMB VARCHAR2 4 YES This field indicates the beginning range of the course
number for a course requirement. If the requirement
consists of only one course the course number would be
here.
SDRSCAD_TO_CRSE_NUMB VARCHAR2 4 YES This field indicates the ending range of the course
number for a course requirement. This field would be
blank if the requirement consists of only one course.
Date: 24-MAY-2004 Page: 197
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSCAD_FROM_TERM_CODE VARCHAR2 6 YES This field indicates the beginning range of the terms
the course is valid as a requirement. If the course
is valid for only one term, the term would be here.
If the course requirement is valid for all terms, no
term would be entered.
SDRSCAD_TO_TERM_CODE VARCHAR2 6 YES This field indicates the ending range of the terms the
course is valid as a requirement. If the course is
valid for only one term, this field would be blank.
SDRSCAD_FROM_HOURS NUMBER 4 2 YES This field indicates the beginning range of the valid
credit hours the course requirement may be taken for.
If there is no range, the single value would be in
this field.
SDRSCAD_TO_HOURS NUMBER 4 2 YES This field indicates the ending range of the valid
credit hours the course requirement may be taken for.
If there is no range, this field would be blank.
SDRSCAD_ATTR_CODE VARCHAR2 4 YES The additional course attribute code
Date: 24-MAY-2004 Page: 198
TABLE: SDRSCAJ
CREATOR: SATURN
Student Degree Program Course Adjustments Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSCAJ_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRSCAJ_PIDM NUMBER 8 NO Internal Identification Number of student who has
substitutions to their degree program.
SDRSCAJ_PROGRAM VARCHAR2 6 NO This field identifies the degree program the student
has adjustments for
SDRSCAJ_BLTN_YEAR VARCHAR2 4 NO This field indicates the bulletin year associated with
the degree program.
SDRSCAJ_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math,social
sciences, etc.) of the degree program for adjustments
to be made.
SDRSCAJ_DPPR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the group
for a adjustment to be made.
SDRSCAJ_DPCR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the
cluster within the group for a adjustments to be made.
SDRSCAJ_DPSR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the course
requirement within the cluster and group that is to be
adjustmented.
SDRSCAJ_ADVR_PIDM NUMBER 8 NO This field identifies the internal identification
number of the advisor who approved the adjustment.
SDRSCAJ_REAS_CODE VARCHAR2 2 NO This field identifies the reason code for why the
adjustment was made.
SDRSCAJ_SUBJ_CODE_SUBS VARCHAR2 4 NO This field identifies the subject that is being
adjusted for the course requirement.
SDRSCAJ_FROM_CRSE_NUMB_SUBS VARCHAR2 4 YES This field identifies the beginning course number that
is being adjusted for the course requirement.
SDRSCAJ_TO_CRSE_NUMB_SUBS VARCHAR2 4 YES This field identifies the ending course number of the
course number range that is being adjusted for the
course requirement.
SDRSCAJ_FROM_HOURS_SUBS NUMBER 4 2 YES This field identifies the beginning range of the valid
credit hours that is being adjusted for the course
requirement.
SDRSCAJ_TO_HOURS_SUBS NUMBER 4 2 YES This field identifies the ending range of the the
valid credit hours that is being adjusted for the
course requirement.
Date: 24-MAY-2004 Page: 199
TABLE: SDRSCSB
CREATOR: SATURN
Student Degree Program Course Substitutions Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSCSB_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRSCSB_PIDM NUMBER 8 NO Internal Identification Number of student who has
substitutions to their degree program.
SDRSCSB_PROGRAM VARCHAR2 6 NO This field identifies the degree program the student
has substitutions to.
SDRSCSB_BLTN_YEAR VARCHAR2 4 NO This field indicates the bulletin year associated with
the degree program.
SDRSCSB_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math,social
sciences, etc.) of the degree program for
substitutions to be made.
SDRSCSB_DPPR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the group
for a substitution to be made.
SDRSCSB_DPCR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the
cluster within the group for a substitution to be
made.
SDRSCSB_DPSR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the course
requirement within the cluster and group that is to be
substituted.
SDRSCSB_ADVR_PIDM NUMBER 8 NO This field identifies the internal identification
number of the advisor who approved the substitution.
SDRSCSB_REAS_CODE VARCHAR2 2 NO This field identifies the reason code for why the
substitution was made.
SDRSCSB_SUBJ_CODE_SUBS VARCHAR2 4 YES This field identifies the subject that is being
substituted for the course requirement.
SDRSCSB_FROM_CRSE_NUMB_SUBS VARCHAR2 4 YES This field identifies the beginning course number that
is being substituted for the course requirement.
SDRSCSB_TO_CRSE_NUMB_SUBS VARCHAR2 4 YES This field identifies the ending course number of the
course number range that is being substituted for the
course requirement.
SDRSCSB_FROM_HOURS_SUBS NUMBER 4 2 YES This field identifies the beginning range of the valid
credit hours that is being substituted for the course
requirement.
SDRSCSB_TO_HOURS_SUBS NUMBER 4 2 YES This field identifies the ending range of the the
valid credit hours that is being substituted for the
course requirement.
SDRSCSB_ATTR_CODE VARCHAR2 4 YES The substitute course attribute code
Date: 24-MAY-2004 Page: 200
TABLE: SDRSCWV
CREATOR: SATURN
Student Degree Program Course Waivers Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSCWV_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRSCWV_PIDM NUMBER 8 NO Internal Identification Number of the student who has
a course waiver.
SDRSCWV_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has a course requirement waived.
SDRSCWV_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRSCWV_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) within the degree program that has a
course requirement waived.
SDRSCWV_DPPR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the group
that has the course requirement that is waived.
SDRSCWV_DPCR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the
cluster that has the course requirement that is
waived.
SDRSCWV_DPSR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the course
requirement that is waived.
SDRSCWV_ADVR_PIDM NUMBER 8 NO This field identifies the internal identification
number of the advisor who approved the course
requirement waiver.
SDRSCWV_REAS_CODE VARCHAR2 2 NO This field identifies the reason why the course
requiement was waived.
Date: 24-MAY-2004 Page: 201
TABLE: SDRSMUR
CREATOR: SATURN
Student Degree Program Multiple Use Requirement Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSMUR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRSMUR_PIDM NUMBER 8 NO Internal identification number of the student who has
a course that is being used to satisfy multiple course
requirements.
SDRSMUR_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that contains the course requirements for the multiple
use course.
SDRSMUR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRSMUR_SMUC_SEQ_NO NUMBER 2 NO This field specifies the internal sequence number
associated with the course that has been specified as
a multiple use course.
SDRSMUR_SEQ_NO NUMBER 2 NO This field specifies the internal sequence number
associated with the course requirement that is being
satisfied by the multiple use course.
SDRSMUR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) within the degree program that has a
course requirement being satisfied by a multiple use
course.
SDRSMUR_DPPR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the group
that has a course requirement being satisfied by a
multiple use course.
SDRSMUR_DPCR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the
cluster that has a course requirement being satisfied
by a multiple use course.
SDRSMUR_DPSR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the course
requirement being satisfied by a multiple use course.
SDRSMUR_PRIMARY_IND VARCHAR2 1 NO This field indicates the course requirement that is
considered the primary requirement of the multiple use
course. Valid value is: Y - Primary requirement.
Only one requirement is primary.
SDRSMUR_ADVR_PIDM NUMBER 8 NO This field identifies the internal identification
number of the advisor who approved the use of one
course to satisfy multiple requirements.
SDRSMUR_REAS_CODE VARCHAR2 2 NO This field identifies the reason why the course
requirement was approved to be satisfied by a multiple
use course.
Date: 24-MAY-2004 Page: 202
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSMUR_ATTR_CODE VARCHAR2 4 YES Multiple use course attribute code
Date: 24-MAY-2004 Page: 203
TABLE: SDRSNCA
CREATOR: SATURN
Student Degree Non-Course Requirements Approval Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSNCA_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRSNCA_PIDM NUMBER 8 NO Internal Identification Number of the student who has
non-course requirements.
SDRSNCA_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
associated with the non-course requirements.
SDRSNCA_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRSNCA_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) associated with the non-course
requirements.
SDRSNCA_NCRQ_CODE VARCHAR2 4 NO This field identifies the non-course requirement code
needed to satisfy this student"s degree program.
SDRSNCA_NCST_CODE VARCHAR2 2 YES This field identifies the status of this this
student"s non-course requirement: is it complete,
pending, etc.
SDRSNCA_NCST_DATE DATE 7 YES This field specifies the date the status was entered
for the non-course requirement.
SDRSNCA_ADVR_PIDM NUMBER 8 YES This field identifies the internal identification
number of the advisor who approved the status for the
non-course requirement.
Date: 24-MAY-2004 Page: 204
TABLE: SDRSSCR
CREATOR: SATURN
Student Specific Cluster Requirements Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSSCR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRSSCR_PIDM NUMBER 8 NO Internal Identification Number of student who has
additional area requirements for their degree program.
SDRSSCR_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has additional area requirements.
SDRSSCR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRSSCR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) associated with the cluster.
SDRSSCR_SSGR_SEQ_NO NUMBER 2 NO This field specifies the sequence number of the group
associated with the cluster.
SDRSSCR_SEQ_NO NUMBER 2 NO This field specifies the sequence number assigned to
the cluster. A cluster defines an "OR" relationship
between selections of course requirements.
SDRSSCR_MIN_HOURS NUMBER 5 2 NO This field identifies the minimum number of course
requirement hours that must be met to satisfy the
cluster requirement.
SDRSSCR_DESC VARCHAR2 30 YES This field identifies a free-format description of the
cluster.
Date: 24-MAY-2004 Page: 205
TABLE: SDRSSGR
CREATOR: SATURN
Student Specific Group Requirements Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
SDRSSGR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
SDRSSGR_PIDM NUMBER 8 NO Internal Identification Number of the student who has
additional area requirements for their degree program.
SDRSSGR_PROGRAM VARCHAR2 6 NO This field identifies the student"s degree program
that has additional area requirements.
SDRSSGR_BLTN_YEAR VARCHAR2 4 NO This field identifies the bulletin year associated
with the degree program.
SDRSSGR_AREA_CODE VARCHAR2 4 NO This field identifies the area code (math, social
sciences, etc.) associated with the group
requirements.
SDRSSGR_SEQ_NO NUMBER 2 NO This field specifies the sequence number assigned to
the group. A group is defined as at least one cluster
of course requirements. Multiple groups are an "AND"
relationship. EX-Group 1 and Group 2 are needed to
satisfy an area req.
SDRSSGR_CVO_NO NUMBER 2 1 NO This field identifies the compliance verification
order number. This number determines the order the
groups are processed through compliance. The lower
the number the higher the order.
SDRSSGR_MAX_HOURS NUMBER 5 2 NO This field identifies the maximum hours of course
requirements that can be taken from the clusters
associated with the group. The default value is
999.99.
SDRSSGR_DESC VARCHAR2 30 YES This field identifies a free-format description of the
group.
SDRSSGR_CRSE_REUSE_IND VARCHAR2 1 YES Course reuse flag
SDRSSGR_ATTR_REUSE_IND VARCHAR2 1 YES Course attribute reuse flag
SDRSSGR_AREA_REUSE_IND VARCHAR2 1 YES Area course reuse flag
SDRSSGR_GRUP_REUSE_IND VARCHAR2 1 YES The group course re-use flag
Date: 24-MAY-2004 Page: 206
TABLE: SDRSSSR
CREATOR: SATURN
Student Specific Course Requirements Repeating Table
===================================================================================================================
Column Name