SRBPRED SRBRECR SRBWPDS SRBWPRO SRRCHRT SRRLEND SRRRATT SRRRCMT SRRRSRC SRRVIST SRRWACK SRTADDR SRTEMAL SRTHSCH SRTIDEN SRTINTL SRTINTS SRTLEND SRTMATL SRTPCOL SRTPERS SRTPREL SRTRECR SRTTELE SRTTEST SRTTPFD

Model Recruiting


Model Label : ERD for Banner Student Recruiting Module
Path : BANNER DEV/Student/Recruiting/Recruiting

List of Objects

Object Name Object Type Layer Name
SRBPRED TABLE Default
SRBRECR TABLE Default
SRBWPDS TABLE Default
SRBWPRO TABLE Default
SRRCHRT TABLE Default
SRRLEND TABLE Default
SRRRATT TABLE Default
SRRRCMT TABLE Default
SRRRSRC TABLE Default
SRRVIST TABLE Default
SRRWACK TABLE Default
SRTADDR TABLE Default
SRTEMAL TABLE Default
SRTHSCH TABLE Default
SRTIDEN TABLE Default
SRTINTL TABLE Default
SRTINTS TABLE Default
SRTLEND TABLE Default
SRTMATL TABLE Default
SRTPCOL TABLE Default
SRTPERS TABLE Default
SRTPREL TABLE Default
SRTRECR TABLE Default
SRTTELE TABLE Default
SRTTEST TABLE Default
SRTTPFD TABLE Default

Comments

Model View

''

Table SRBPRED

Schema Name SATURN
Label SRBPRED
Server name MALDEV8_B60
Creation Date 08/29/2002 07:22:06:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SRBPRED_PREL_CODE SRBPRED_PREL_CODE VARCHAR2(10) No *
SRBPRED_LEVL_CODE SRBPRED_LEVL_CODE VARCHAR2(2) No *
SRBPRED_ACTIVITY_DATE SRBPRED_ACTIVITY_DATE DATE No
SRBPRED_TAPE_ID SRBPRED_TAPE_ID VARCHAR2(6) Yes
SRBPRED_TERM_CODE SRBPRED_TERM_CODE VARCHAR2(6) Yes *
SRBPRED_RECR_CODE SRBPRED_RECR_CODE VARCHAR2(3) Yes *
SRBPRED_RTYP_CODE SRBPRED_RTYP_CODE VARCHAR2(2) Yes *
SRBPRED_STYP_CODE SRBPRED_STYP_CODE VARCHAR2(1) Yes *
SRBPRED_EGOL_CODE SRBPRED_EGOL_CODE VARCHAR2(2) Yes *
SRBPRED_VTYP_CODE SRBPRED_VTYP_CODE VARCHAR2(2) Yes
SRBPRED_TSRC_CODE SRBPRED_TSRC_CODE VARCHAR2(4) Yes *
SRBPRED_SBGI_CODE SRBPRED_SBGI_CODE VARCHAR2(6) Yes *
SRBPRED_CTYP_CODE SRBPRED_CTYP_CODE VARCHAR2(3) Yes *
SRBPRED_TERM_CODE_CTLG SRBPRED_TERM_CODE_CTLG VARCHAR2(6) Yes
SRBPRED_PROGRAM SRBPRED_PROGRAM VARCHAR2(12) Yes *
SRBPRED_DEGC_CODE SRBPRED_DEGC_CODE VARCHAR2(6) Yes *
SRBPRED_CAMP_CODE SRBPRED_CAMP_CODE VARCHAR2(3) Yes *
SRBPRED_COLL_CODE SRBPRED_COLL_CODE VARCHAR2(2) Yes *
SRBPRED_MAJR_CODE SRBPRED_MAJR_CODE VARCHAR2(4) Yes *
SRBPRED_DEPT_CODE SRBPRED_DEPT_CODE VARCHAR2(4) Yes *
SRBPRED_RSTA_CODE SRBPRED_RSTA_CODE VARCHAR2(2) Yes *
SRBPRED_ADMT_CODE SRBPRED_ADMT_CODE VARCHAR2(2) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SRBPRED_COLL_CODE STVCOLL_CODE STVCOLL
SRBPRED_MAJR_CODE STVMAJR_CODE STVMAJR
SRBPRED_ADMT_CODE STVADMT_CODE STVADMT
SRBPRED_RTYP_CODE STVRTYP_CODE STVRTYP
SRBPRED_STYP_CODE STVSTYP_CODE STVSTYP
SRBPRED_EGOL_CODE STVEGOL_CODE STVEGOL
SRBPRED_CTYP_CODE STVCTYP_CODE STVCTYP
SRBPRED_DEGC_CODE STVDEGC_CODE STVDEGC
SRBPRED_DEPT_CODE STVDEPT_CODE STVDEPT
SRBPRED_TSRC_CODE STVTSRC_CODE STVTSRC
SRBPRED_CAMP_CODE STVCAMP_CODE STVCAMP
SRBPRED_LEVL_CODE STVLEVL_CODE STVLEVL
SRBPRED_TERM_CODE STVTERM_CODE STVTERM
SRBPRED_PROGRAM SMRPRLE_PROGRAM SMRPRLE
SRBPRED_RSTA_CODE STVRSTA_CODE STVRSTA
SRBPRED_RECR_CODE STVRECR_CODE STVRECR
SRBPRED_SBGI_CODE STVSBGI_CODE STVSBGI

Index

Index Name Index Type Column Name
PK_SRBPRED Unique SRBPRED_PREL_CODE

Comments

Source Code Comments

Default values for Web for Prospect Web pages.

Columns Comments for SRBPRED_PREL_CODE (1)

Source Code Comments

Electronic Prospect Code for default values.

Columns Comments for SRBPRED_LEVL_CODE (2)

Source Code Comments

Level default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_ACTIVITY_DATE (3)

Source Code Comments

This field identifies the date of creation or update.

Columns Comments for SRBPRED_TAPE_ID (4)

Source Code Comments

Tape ID for Electronic Prospect Tape Source.

Columns Comments for SRBPRED_TERM_CODE (5)

Source Code Comments

Term Code of Electronic Prospect Recruit Peroid.

Columns Comments for SRBPRED_RECR_CODE (6)

Source Code Comments

Recruit default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_RTYP_CODE (7)

Source Code Comments

Recruit type default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_STYP_CODE (8)

Source Code Comments

Student type default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_EGOL_CODE (9)

Source Code Comments

Education level default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_VTYP_CODE (10)

Source Code Comments

Visa Type default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_TSRC_CODE (11)

Source Code Comments

Tape source default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_SBGI_CODE (12)

Source Code Comments

Recruit source default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_CTYP_CODE (13)

Source Code Comments

Contact type default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_TERM_CODE_CTLG (14)

Source Code Comments

Catalog term default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_PROGRAM (15)

Source Code Comments

Degree default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_DEGC_CODE (16)

Source Code Comments

Degree default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_CAMP_CODE (17)

Source Code Comments

Campus default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_COLL_CODE (18)

Source Code Comments

College default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_MAJR_CODE (19)

Source Code Comments

Major default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_DEPT_CODE (20)

Source Code Comments

Department default code value for Web for Prospect Web page.

Columns Comments for SRBPRED_RSTA_CODE (21)

Source Code Comments

Status of recruit

Columns Comments for SRBPRED_ADMT_CODE (22)

Source Code Comments

Type of application

Table SRBRECR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SRBRECR_PIDM SRBRECR_PIDM NUMBER(8,0) No * *
SRBRECR_PIDM SRBRECR_PIDM NUMBER(8,0) No * *
SRBRECR_TERM_CODE SRBRECR_TERM_CODE VARCHAR2(6) No * *
SRBRECR_ADMIN_SEQNO SRBRECR_ADMIN_SEQNO NUMBER(2,0) No *
SRBRECR_DEPT_CODE SRBRECR_DEPT_CODE VARCHAR2(4) Yes *
SRBRECR_LEVL_CODE SRBRECR_LEVL_CODE VARCHAR2(2) No *
SRBRECR_DEGC_CODE SRBRECR_DEGC_CODE VARCHAR2(6) No *
SRBRECR_MAJR_CODE SRBRECR_MAJR_CODE VARCHAR2(4) No *
SRBRECR_RECR_CODE SRBRECR_RECR_CODE VARCHAR2(3) Yes *
SRBRECR_RSTA_CODE SRBRECR_RSTA_CODE VARCHAR2(2) Yes *
SRBRECR_ACTIVITY_DATE SRBRECR_ACTIVITY_DATE DATE No
SRBRECR_SELECT_IND SRBRECR_SELECT_IND VARCHAR2(1) Yes
SRBRECR_ADD_DATE SRBRECR_ADD_DATE DATE No
SRBRECR_ADMT_CODE SRBRECR_ADMT_CODE VARCHAR2(2) Yes
SRBRECR_CAMP_CODE SRBRECR_CAMP_CODE VARCHAR2(3) Yes
SRBRECR_COLL_CODE SRBRECR_COLL_CODE VARCHAR2(2) Yes *
SRBRECR_MAJR_CODE2 SRBRECR_MAJR_CODE2 VARCHAR2(4) Yes *
SRBRECR_EDLV_CODE SRBRECR_EDLV_CODE VARCHAR2(3) Yes *
SRBRECR_EGOL_CODE SRBRECR_EGOL_CODE VARCHAR2(2) Yes *
SRBRECR_FULL_PART_IND SRBRECR_FULL_PART_IND VARCHAR2(1) Yes
SRBRECR_SBGI_CODE SRBRECR_SBGI_CODE VARCHAR2(6) Yes *
SRBRECR_WRSN_CODE SRBRECR_WRSN_CODE VARCHAR2(2) Yes *
SRBRECR_RTYP_CODE SRBRECR_RTYP_CODE VARCHAR2(2) Yes *
SRBRECR_RESD_CODE SRBRECR_RESD_CODE VARCHAR2(1) Yes *
SRBRECR_SESS_CODE SRBRECR_SESS_CODE VARCHAR2(1) Yes *
SRBRECR_SITE_CODE SRBRECR_SITE_CODE VARCHAR2(3) Yes *
SRBRECR_STYP_CODE SRBRECR_STYP_CODE VARCHAR2(1) Yes *
SRBRECR_PROGRAM_1 SRBRECR_PROGRAM_1 VARCHAR2(12) Yes *
SRBRECR_TERM_CODE_CTLG_1 SRBRECR_TERM_CODE_CTLG_1 VARCHAR2(6) Yes *
SRBRECR_DEPT_CODE_2 SRBRECR_DEPT_CODE_2 VARCHAR2(4) Yes *
SRBRECR_MAJR_CODE_CONC_111 SRBRECR_MAJR_CODE_CONC_111 VARCHAR2(4) Yes *
SRBRECR_MAJR_CODE_CONC_112 SRBRECR_MAJR_CODE_CONC_112 VARCHAR2(4) Yes *
SRBRECR_MAJR_CODE_CONC_113 SRBRECR_MAJR_CODE_CONC_113 VARCHAR2(4) Yes *
SRBRECR_MAJR_CODE_CONC_121 SRBRECR_MAJR_CODE_CONC_121 VARCHAR2(4) Yes *
SRBRECR_MAJR_CODE_CONC_122 SRBRECR_MAJR_CODE_CONC_122 VARCHAR2(4) Yes *
SRBRECR_MAJR_CODE_CONC_123 SRBRECR_MAJR_CODE_CONC_123 VARCHAR2(4) Yes *
SRBRECR_MAJR_CODE_MINR_1 SRBRECR_MAJR_CODE_MINR_1 VARCHAR2(4) Yes *
SRBRECR_MAJR_CODE_MINR_1_2 SRBRECR_MAJR_CODE_MINR_1_2 VARCHAR2(4) Yes *
SRBRECR_CURR_RULE_1 SRBRECR_CURR_RULE_1 NUMBER(8,0) Yes *
SRBRECR_CMJR_RULE_1_1 SRBRECR_CMJR_RULE_1_1 NUMBER(8,0) Yes *
SRBRECR_CCON_RULE_11_1 SRBRECR_CCON_RULE_11_1 NUMBER(8,0) Yes *
SRBRECR_CCON_RULE_11_2 SRBRECR_CCON_RULE_11_2 NUMBER(8,0) Yes *
SRBRECR_CCON_RULE_11_3 SRBRECR_CCON_RULE_11_3 NUMBER(8,0) Yes *
SRBRECR_CMJR_RULE_1_2 SRBRECR_CMJR_RULE_1_2 NUMBER(8,0) Yes *
SRBRECR_CCON_RULE_12_1 SRBRECR_CCON_RULE_12_1 NUMBER(8,0) Yes *
SRBRECR_CCON_RULE_12_2 SRBRECR_CCON_RULE_12_2 NUMBER(8,0) Yes *
SRBRECR_CCON_RULE_12_3 SRBRECR_CCON_RULE_12_3 NUMBER(8,0) Yes *
SRBRECR_CMNR_RULE_1_1 SRBRECR_CMNR_RULE_1_1 NUMBER(8,0) Yes *
SRBRECR_CMNR_RULE_1_2 SRBRECR_CMNR_RULE_1_2 NUMBER(8,0) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SRBRECR_CURR_RULE_1 SOBCURR_CURR_RULE SOBCURR
SRBRECR_COLL_CODE STVCOLL_CODE STVCOLL
SRBRECR_DEGC_CODE STVDEGC_CODE STVDEGC
SRBRECR_EGOL_CODE STVEGOL_CODE STVEGOL
SRBRECR_RESD_CODE STVRESD_CODE STVRESD
SRBRECR_RTYP_CODE STVRTYP_CODE STVRTYP
SRBRECR_SESS_CODE STVSESS_CODE STVSESS
SRBRECR_STYP_CODE STVSTYP_CODE STVSTYP
SRBRECR_WRSN_CODE STVWRSN_CODE STVWRSN
SRBRECR_LEVL_CODE STVLEVL_CODE STVLEVL
SRBRECR_EDLV_CODE STVEDLV_CODE STVEDLV
SRBRECR_PROGRAM_1 SMRPRLE_PROGRAM SMRPRLE
SRBRECR_RSTA_CODE STVRSTA_CODE STVRSTA
SRBRECR_SITE_CODE STVSITE_CODE STVSITE
SRBRECR_RECR_CODE STVRECR_CODE STVRECR
SRBRECR_SBGI_CODE STVSBGI_CODE STVSBGI
SRBRECR_PIDM SORPCOL_PIDM SORPCOL
SRBRECR_PIDM SORHSCH_PIDM SORHSCH

Index

Index Name Index Type Column Name
PK_SRBRECR Unique SRBRECR_PIDM
PK_SRBRECR Unique SRBRECR_TERM_CODE
PK_SRBRECR Unique SRBRECR_ADMIN_SEQNO
SRBRECR_KEY_INDEX2 SRBRECR_RECR_CODE
SRBRECR_KEY_INDEX2 SRBRECR_TERM_CODE

Comments

Source Code Comments

Recruiting Base Table

Columns Comments for SRBRECR_PIDM (1)

Source Code Comments

Internal identification number.

Columns Comments for SRBRECR_TERM_CODE (2)

Source Code Comments

This field defines the effective term the recruiting records will be viewed or created.

Columns Comments for SRBRECR_ADMIN_SEQNO (3)

Source Code Comments

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

Columns Comments for SRBRECR_DEPT_CODE (4)

Source Code Comments

This field defines the department associated with the prospect recruiting record.

Columns Comments for SRBRECR_LEVL_CODE (5)

Source Code Comments

This field defines the level code associated with the prospect recruiting record.

Columns Comments for SRBRECR_DEGC_CODE (6)

Source Code Comments

This field defines the degree code associated with the prospect recruiting record.

Columns Comments for SRBRECR_MAJR_CODE (7)

Source Code Comments

This field defines the major code associated with the prospect recruiting record.

Columns Comments for SRBRECR_RECR_CODE (8)

Source Code Comments

This field defines the recruiter assigned to the prospect recruiting record.

Columns Comments for SRBRECR_RSTA_CODE (9)

Source Code Comments

This field defines the status of the prospect associated with the recruiting record.

Columns Comments for SRBRECR_ACTIVITY_DATE (10)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for SRBRECR_SELECT_IND (11)

Source Code Comments

Selected indicator to specify which record is current or most recent recruiting record. Informational only Values are Y or null. Only 1 record per term may be selected.

Columns Comments for SRBRECR_ADD_DATE (12)

Source Code Comments

Date record added.

Columns Comments for SRBRECR_ADMT_CODE (13)

Source Code Comments

Admission Type code.

Columns Comments for SRBRECR_CAMP_CODE (14)

Source Code Comments

Campus code.

Columns Comments for SRBRECR_COLL_CODE (15)

Source Code Comments

College code.

Columns Comments for SRBRECR_MAJR_CODE2 (16)

Source Code Comments

Area of Concentration code.

Columns Comments for SRBRECR_EDLV_CODE (17)

Source Code Comments

Education Level code.

Columns Comments for SRBRECR_EGOL_CODE (18)

Source Code Comments

Education Goal code.

Columns Comments for SRBRECR_FULL_PART_IND (19)

Source Code Comments

Fulltime-Parttime Indicator. If not null, values are F or P.

Columns Comments for SRBRECR_SBGI_CODE (20)

Source Code Comments

Institution Attending code. Thisfield represents the institution the student decided to attend rather than the home institution.

Columns Comments for SRBRECR_WRSN_CODE (21)

Source Code Comments

Withdrawal Reason code. Used when student decides not to attend home institution.

Columns Comments for SRBRECR_RTYP_CODE (22)

Source Code Comments

Recruit Type code.

Columns Comments for SRBRECR_RESD_CODE (23)

Source Code Comments

Residency code.

Columns Comments for SRBRECR_SESS_CODE (24)

Source Code Comments

Session code.

Columns Comments for SRBRECR_SITE_CODE (25)

Source Code Comments

Site code.

Columns Comments for SRBRECR_STYP_CODE (26)

Source Code Comments

Student Type code.

Columns Comments for SRBRECR_PROGRAM_1 (27)

Source Code Comments

Curriculum 1 Program Code

Columns Comments for SRBRECR_TERM_CODE_CTLG_1 (28)

Source Code Comments

Curriculum 1 Catalog Term Code

Columns Comments for SRBRECR_DEPT_CODE_2 (29)

Source Code Comments

Department Code 2 on Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_111 (30)

Source Code Comments

Concentration Code 1 on Major 1, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_112 (31)

Source Code Comments

Concentration Code 2 on Major 1, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_113 (32)

Source Code Comments

Concentration Code 3 on Major 1, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_121 (33)

Source Code Comments

Concentration Code 1 on Major 2, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_122 (34)

Source Code Comments

Concentration Code 2 on Major 2, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_CONC_123 (35)

Source Code Comments

Concentration Code 3 on Major 2, Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_MINR_1 (36)

Source Code Comments

Minor 1 on Curriculum 1

Columns Comments for SRBRECR_MAJR_CODE_MINR_1_2 (37)

Source Code Comments

Minor 2 on Curriculum 1

Columns Comments for SRBRECR_CURR_RULE_1 (38)

Source Code Comments

Curriculum 1 Rule reference

Columns Comments for SRBRECR_CMJR_RULE_1_1 (39)

Source Code Comments

Curriculum 1 Major 1 Rule Reference

Columns Comments for SRBRECR_CCON_RULE_11_1 (40)

Source Code Comments

Concentration 1, Major 1, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CCON_RULE_11_2 (41)

Source Code Comments

Concentration 2, Major 1, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CCON_RULE_11_3 (42)

Source Code Comments

Concentration 3, Major 1, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CMJR_RULE_1_2 (43)

Source Code Comments

Major 2, Curriculum Rule Reference

Columns Comments for SRBRECR_CCON_RULE_12_1 (44)

Source Code Comments

Concentration 1, Major 2, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CCON_RULE_12_2 (45)

Source Code Comments

Concentration 2, Major 2, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CCON_RULE_12_3 (46)

Source Code Comments

Concentration 3, Major 2, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CMNR_RULE_1_1 (47)

Source Code Comments

Minor 1, Curriculum 1 Rule Reference

Columns Comments for SRBRECR_CMNR_RULE_1_2 (48)

Source Code Comments

Minor 2, Curriculum 1 Rule Reference

Table SRBWPDS

Schema Name SATURN
Label SRBWPDS
Server name MALDEV8_B60
Creation Date 08/29/2002 07:22:10:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SRBWPDS_PREL_CODE SRBWPDS_PREL_CODE VARCHAR2(10) No * *
SRBWPDS_VAL_TABLE SRBWPDS_VAL_TABLE VARCHAR2(30) No *
SRBWPDS_VAL_CODE SRBWPDS_VAL_CODE VARCHAR2(12) No *
SRBWPDS_VAL_DESC SRBWPDS_VAL_DESC VARCHAR2(30) No
SRBWPDS_ACTIVITY_DATE SRBWPDS_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SRBWPDS_PREL_CODE STVPREL_CODE STVPREL

Index

Index Name Index Type Column Name
PK_SRBWPDS Unique SRBWPDS_PREL_CODE
PK_SRBWPDS Unique SRBWPDS_VAL_TABLE
PK_SRBWPDS Unique SRBWPDS_VAL_CODE

Comments

Source Code Comments

Web Prospect Validation Code Display Section Rules Form. This form determines which validation values from the validation tables will be displayed on specific Prospect Web pages.

Columns Comments for SRBWPDS_PREL_CODE (1)

Source Code Comments

Electronic Prospect Code for display selection.

Columns Comments for SRBWPDS_VAL_TABLE (2)

Source Code Comments

Validation Table Suffix of the item to be displayed.

Columns Comments for SRBWPDS_VAL_CODE (3)

Source Code Comments

Validation Table code to be displayed on the Prospect Web page.

Columns Comments for SRBWPDS_VAL_DESC (4)

Source Code Comments

Validation Table code description to be displayed on the Prospect Web page.

Table SRBWPRO

Schema Name SATURN
Label SRBWPRO
Server name MALDEV8_B60
Creation Date 08/29/2002 07:22:11:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SRBWPRO_PREL_CODE SRBWPRO_PREL_CODE VARCHAR2(10) No * *
SRBWPRO_WPIC_CODE SRBWPRO_WPIC_CODE VARCHAR2(10) No *
SRBWPRO_DISPLAY_ORDER SRBWPRO_DISPLAY_ORDER NUMBER(3,0) No
SRBWPRO_ACTIVITY_DATE SRBWPRO_ACTIVITY_DATE DATE No
SRBWPRO_ATYP_CODE SRBWPRO_ATYP_CODE VARCHAR2(2) Yes *
SRBWPRO_EMAL_CODE SRBWPRO_EMAL_CODE VARCHAR2(4) Yes *
SRBWPRO_RESPONSE_REQ_IND SRBWPRO_RESPONSE_REQ_IND VARCHAR2(1) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SRBWPRO_EMAL_CODE GTVEMAL_CODE GTVEMAL
SRBWPRO_ATYP_CODE STVATYP_CODE STVATYP
SRBWPRO_PREL_CODE STVPREL_CODE STVPREL

Index

Index Name Index Type Column Name
PK_SRBWPRO Unique SRBWPRO_PREL_CODE
PK_SRBWPRO Unique SRBWPRO_WPIC_CODE
SRBWPRO_KEY_INDEX SRBWPRO_PREL_CODE
SRBWPRO_KEY_INDEX SRBWPRO_DISPLAY_ORDER

Comments

Source Code Comments

Web Prospect Section Rules Form, SRAWPRO that will be used by an institution to designate what pieces of data will be displayed on each different type of Prospect Code defined on STVWPRO.

Columns Comments for SRBWPRO_PREL_CODE (1)

Source Code Comments

Electronic Prospect Code for display selection.

Columns Comments for SRBWPRO_WPIC_CODE (2)

Source Code Comments

WEB Prospect Selection Code.

Columns Comments for SRBWPRO_DISPLAY_ORDER (3)

Source Code Comments

The order the Data is displayed on the Web Prospect Page.

Columns Comments for SRBWPRO_ATYP_CODE (5)

Source Code Comments

The address type for the Web Prospect page.

Columns Comments for SRBWPRO_RESPONSE_REQ_IND (7)

Source Code Comments

Indicator that the data must be filled in on the Prospect Web page before being saved in the database.

Table SRRCHRT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SRRCHRT_PIDM SRRCHRT_PIDM NUMBER(8,0) No * *
SRRCHRT_TERM_CODE SRRCHRT_TERM_CODE VARCHAR2(6) No * *
SRRCHRT_TERM_CODE SRRCHRT_TERM_CODE VARCHAR2(6) No * *
SRRCHRT_ADMIN_SEQNO SRRCHRT_ADMIN_SEQNO NUMBER(2,0) No * *
SRRCHRT_CHRT_CODE SRRCHRT_CHRT_CODE VARCHAR2(10) No * *
SRRCHRT_ACTIVITY_DATE SRRCHRT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SRRCHRT_PIDM SRBRECR_PIDM SRBRECR
SRRCHRT_TERM_CODE SRBRECR_TERM_CODE SRBRECR
SRRCHRT_ADMIN_SEQNO SRBRECR_ADMIN_SEQNO SRBRECR
SRRCHRT_CHRT_CODE STVCHRT_CODE STVCHRT
SRRCHRT_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SRRCHRT Unique SRRCHRT_PIDM
PK_SRRCHRT Unique SRRCHRT_TERM_CODE
PK_SRRCHRT Unique SRRCHRT_ADMIN_SEQNO
PK_SRRCHRT Unique SRRCHRT_CHRT_CODE

Comments

Source Code Comments

Cohort Recruiting Table

Columns Comments for SRRCHRT_PIDM (1)

Source Code Comments

Internal Person Identification Number

Columns Comments for SRRCHRT_TERM_CODE (2)

Source Code Comments

Term code

Columns Comments for SRRCHRT_ADMIN_SEQNO (3)

Source Code Comments

Sequence Number

Columns Comments for SRRCHRT_CHRT_CODE (4)

Source Code Comments

Cohort Code

Columns Comments for SRRCHRT_ACTIVITY_DATE (5)

Source Code Comments

The Activity Date

Table SRRLEND

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SRRLEND_PIDM SRRLEND_PIDM NUMBER(8,0) No * *
SRRLEND_TERM_CODE SRRLEND_TERM_CODE VARCHAR2(6) No * *
SRRLEND_TERM_CODE SRRLEND_TERM_CODE VARCHAR2(6) No * *
SRRLEND_ADMIN_SEQNO SRRLEND_ADMIN_SEQNO NUMBER(2,0) No * *
SRRLEND_LEND_CODE SRRLEND_LEND_CODE VARCHAR2(10) No * *
SRRLEND_ACTIVITY_DATE SRRLEND_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SRRLEND_PIDM SRBRECR_PIDM SRBRECR
SRRLEND_TERM_CODE SRBRECR_TERM_CODE SRBRECR
SRRLEND_ADMIN_SEQNO SRBRECR_ADMIN_SEQNO SRBRECR
SRRLEND_LEND_CODE STVLEND_CODE STVLEND
SRRLEND_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SRRLEND Unique SRRLEND_PIDM
PK_SRRLEND Unique SRRLEND_TERM_CODE
PK_SRRLEND Unique SRRLEND_ADMIN_SEQNO
PK_SRRLEND Unique SRRLEND_LEND_CODE

Comments

Source Code Comments

Table used to store how I learned of the institution code of Recruit.

Columns Comments for SRRLEND_PIDM (1)

Source Code Comments

Unique ID of Recruit.

Columns Comments for SRRLEND_TERM_CODE (2)

Source Code Comments

Term code of Recruit.

Columns Comments for SRRLEND_ADMIN_SEQNO (3)

Source Code Comments

Seqno of Recruit Record for the Term.

Columns Comments for SRRLEND_LEND_CODE (4)

Source Code Comments

Legend code of Recruit.

Columns Comments for SRRLEND_ACTIVITY_DATE (5)

Source Code Comments

This field identifies the most recent date of creation or update.

Table SRRRATT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SRRRATT_PIDM SRRRATT_PIDM NUMBER(8,0) No *
SRRRATT_TERM_CODE SRRRATT_TERM_CODE VARCHAR2(6) No * *
SRRRATT_ADMIN_SEQNO SRRRATT_ADMIN_SEQNO NUMBER(2,0) No *
SRRRATT_ATTS_CODE SRRRATT_ATTS_CODE VARCHAR2(4) No * *
SRRRATT_ACTIVITY_DATE SRRRATT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SRRRATT_ATTS_CODE STVATTS_CODE STVATTS
SRRRATT_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SRRRATT Unique SRRRATT_PIDM
PK_SRRRATT Unique SRRRATT_TERM_CODE
PK_SRRRATT Unique SRRRATT_ADMIN_SEQNO
PK_SRRRATT Unique SRRRATT_ATTS_CODE

Comments

Source Code Comments

Recruiting Attribute Repeating Table.

Columns Comments for SRRRATT_PIDM (1)

Source Code Comments

Internal identification number for whom the attributes are associated with.

Columns Comments for SRRRATT_TERM_CODE (2)

Source Code Comments

The term associated with the attributes.

Columns Comments for SRRRATT_ADMIN_SEQNO (3)

Source Code Comments

The administrative sequence number of the prospect record associated with the attribute.

Columns Comments for SRRRATT_ATTS_CODE (4)

Source Code Comments

The recruiting attributes for the person and term.

Columns Comments for SRRRATT_ACTIVITY_DATE (5)

Source Code Comments

The date the record was last updated.

Table SRRRCMT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SRRRCMT_PIDM SRRRCMT_PIDM NUMBER(8,0) No
SRRRCMT_TERM_CODE SRRRCMT_TERM_CODE VARCHAR2(6) No *
SRRRCMT_SEQNO SRRRCMT_SEQNO NUMBER(3,0) No
SRRRCMT_COMMENT_TEXT SRRRCMT_COMMENT_TEXT VARCHAR2(4000) Yes
SRRRCMT_ORIG_CODE SRRRCMT_ORIG_CODE VARCHAR2(4) No *
SRRRCMT_ACTIVITY_DATE SRRRCMT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SRRRCMT_ORIG_CODE STVORIG_CODE STVORIG
SRRRCMT_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
SRRRCMT_KEY_INDEX SRRRCMT_PIDM
SRRRCMT_KEY_INDEX SRRRCMT_TERM_CODE

Comments

Source Code Comments

Recruiting Comment Table

Columns Comments for SRRRCMT_PIDM (1)

Source Code Comments

Internal identification number of prospect.

Columns Comments for SRRRCMT_TERM_CODE (2)

Source Code Comments

This field identifies the term associated with prospect record.

Columns Comments for SRRRCMT_SEQNO (3)

Source Code Comments

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

Columns Comments for SRRRCMT_COMMENT_TEXT (4)

Source Code Comments

This field specifies the recruiting comment(s) associated with prospect record.

Columns Comments for SRRRCMT_ORIG_CODE (5)

Source Code Comments

This field identifies the originator of the comment associated with prospect.

Columns Comments for SRRRCMT_ACTIVITY_DATE (6)

Source Code Comments

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

Table SRRRSRC

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SRRRSRC_ADMIN_SEQNO SRRRSRC_ADMIN_SEQNO NUMBER(2,0) No * *
SRRRSRC_PIDM SRRRSRC_PIDM NUMBER(8,0) No * *
SRRRSRC_TERM_CODE SRRRSRC_TERM_CODE VARCHAR2(6) No * *
SRRRSRC_TERM_CODE SRRRSRC_TERM_CODE VARCHAR2(6) No * *
SRRRSRC_SBGI_CODE SRRRSRC_SBGI_CODE VARCHAR2(6) No * *
SRRRSRC_PRIMARY_SRCE_IND SRRRSRC_PRIMARY_SRCE_IND VARCHAR2(1) Yes
SRRRSRC_ACTIVITY_DATE SRRRSRC_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SRRRSRC_PIDM SRBRECR_PIDM SRBRECR
SRRRSRC_TERM_CODE SRBRECR_TERM_CODE SRBRECR
SRRRSRC_ADMIN_SEQNO SRBRECR_ADMIN_SEQNO SRBRECR
SRRRSRC_TERM_CODE STVTERM_CODE STVTERM
SRRRSRC_SBGI_CODE STVSBGI_CODE STVSBGI

Index

Index Name Index Type Column Name
PK_SRRRSRC Unique SRRRSRC_PIDM
PK_SRRRSRC Unique SRRRSRC_TERM_CODE
PK_SRRRSRC Unique SRRRSRC_ADMIN_SEQNO
PK_SRRRSRC Unique SRRRSRC_SBGI_CODE

Comments

Source Code Comments

Source of Recruit Repeating Table

Columns Comments for SRRRSRC_ADMIN_SEQNO (1)

Source Code Comments

This field does not display on form. It assigns an internal sequence number to each source background record.

Columns Comments for SRRRSRC_PIDM (2)

Source Code Comments

Internal identification number associated with prospect.

Columns Comments for SRRRSRC_TERM_CODE (3)

Source Code Comments

This field identifies the term associated with the recruiting record.

Columns Comments for SRRRSRC_SBGI_CODE (4)

Source Code Comments

This field identifies the source background associated with the prospect.

Columns Comments for SRRRSRC_PRIMARY_SRCE_IND (5)

Source Code Comments

This field specifies if the source type is the primary source of the prospect.

Columns Comments for SRRRSRC_ACTIVITY_DATE (6)

Source Code Comments

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

Table SRRVIST

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SRRVIST_TERM_CODE SRRVIST_TERM_CODE VARCHAR2(6) No *
SRRVIST_RECR_CODE SRRVIST_RECR_CODE VARCHAR2(3) No * *
SRRVIST_SBGI_CODE SRRVIST_SBGI_CODE VARCHAR2(6) No * *
SRRVIST_CTYP_CODE SRRVIST_CTYP_CODE VARCHAR2(3) No *
SRRVIST_CONTACT_DATE SRRVIST_CONTACT_DATE DATE No *