SABAUDF SABBTCH SABECRL SABECTM SABXMIT SARAATT SARACMT SARACTV SARAMCC SARASTA SARCHKB SARCTRL SARDNTE SARERUL SAREVAL SARIMMZ SARLANG SARLCOM SARLMSG SARLREC SARLXMS SARLXNO SARMATL SARMONY SARORTN SARPCRS SARPERR SARPRTN SARPSTA SARQKER SARRESD SARRFNO SARRLST SARRRAT SARRRCT SARRRDF SARRRFT SARRRRT SARTERM SARTEST SARWAAD SARWATD SARWATR SARWSCT SATAHLD SATAMAL SATARPT SMRPRLE SORAROL SORCMJR SORCRSS SORGPAT SORMATT SORTEST SPRADDR STVADMR STVADMT STVAFCT STVAPDC STVAPST STVASTA STVATTS STVDEPT STVEDLV STVEGOL STVEGRP STVLEVL STVORIG STVRADM STVRATE STVRATP STVRESD STVSBGI STVSTST STVSTYP STVTSRC STVWAPP STVWSCF STVWSCT

Model Admissions Group #3


Model Label : ERD For Portions of Banner Student Admissions Module.
Path : BANNER DEV/Student/Admissions/Admissions Group #3

List of Objects

Object Name Object Type Layer Name
SABAUDF TABLE Table_Layer_3
SABBTCH TABLE Table_Layer_3
SABECRL TABLE Table_Layer_3
SABECTM TABLE Table_Layer_3
SABXMIT TABLE Table_Layer_3
SARAATT TABLE Table_Layer_3
SARACMT TABLE Table_Layer_3
SARACTV TABLE Table_Layer_3
SARAMCC TABLE Table_Layer_3
SARASTA TABLE Table_Layer_3
SARCHKB TABLE Table_Layer_3
SARCTRL TABLE Table_Layer_3
SARDNTE TABLE Table_Layer_3
SARERUL TABLE Table_Layer_3
SAREVAL TABLE Table_Layer_3
SARIMMZ TABLE Table_Layer_3
SARLANG TABLE Table_Layer_3
SARLCOM TABLE Table_Layer_3
SARLMSG TABLE Table_Layer_3
SARLREC TABLE Table_Layer_3
SARLXMS TABLE Table_Layer_3
SARLXNO TABLE Table_Layer_3
SARMATL TABLE Table_Layer_3
SARMONY TABLE Table_Layer_3
SARORTN TABLE Table_Layer_3
SARPCRS TABLE Table_Layer_3
SARPERR TABLE Table_Layer_3
SARPRTN TABLE Table_Layer_3
SARPSTA TABLE Table_Layer_3
SARQKER TABLE Table_Layer_3
SARRESD TABLE Table_Layer_3
SARRFNO TABLE Table_Layer_3
SARRLST TABLE Table_Layer_3
SARRRAT TABLE Table_Layer_3
SARRRCT TABLE Table_Layer_3
SARRRDF TABLE Table_Layer_3
SARRRFT TABLE Table_Layer_3
SARRRRT TABLE Table_Layer_3
SARTERM TABLE Table_Layer_3
SARTEST TABLE Table_Layer_3
SARWAAD TABLE Table_Layer_3
SARWATD TABLE Table_Layer_3
SARWATR TABLE Table_Layer_3
SARWSCT TABLE Table_Layer_3
SATAHLD TABLE Table_Layer_3
SATAMAL TABLE Table_Layer_3
SATARPT TABLE Table_Layer_3
SMRPRLE TABLE Links_3
SORAROL TABLE Links_3
SORCMJR TABLE Links_1
SORCRSS TABLE Links_3
SORGPAT TABLE Links_3
SORMATT TABLE Links_3
SORTEST TABLE Links_3
SPRADDR TABLE Links_3
STVADMR TABLE Links_1
STVADMT TABLE Links_2
STVAFCT TABLE Links_3
STVAPDC TABLE Links_1
STVAPST TABLE Links_3
STVASTA TABLE Links_3
STVATTS TABLE Links_3
STVDEPT TABLE Links_3
STVEDLV TABLE Links_3
STVEGOL TABLE Links_3
STVEGRP TABLE Links_3
STVLEVL TABLE Links_2
STVORIG TABLE Links_3
STVRADM TABLE Links_3
STVRATE TABLE Links_3
STVRATP TABLE Links_2
STVRESD TABLE Links_2
STVSBGI TABLE Links_1
STVSTST TABLE Links_3
STVSTYP TABLE Links_2
STVTSRC TABLE Links_3
STVWAPP TABLE Links_3
STVWSCF TABLE Links_3
STVWSCT TABLE Links_3

Comments

Model View

''

Table SABAUDF

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABAUDF_TERM_CODE_EFF SABAUDF_TERM_CODE_EFF VARCHAR2(6) No * *
SABAUDF_FLAG1_DESC SABAUDF_FLAG1_DESC VARCHAR2(20) Yes
SABAUDF_FLAG2_DESC SABAUDF_FLAG2_DESC VARCHAR2(20) Yes
SABAUDF_FLAG3_DESC SABAUDF_FLAG3_DESC VARCHAR2(20) Yes
SABAUDF_FLAG4_DESC SABAUDF_FLAG4_DESC VARCHAR2(20) Yes
SABAUDF_FLAG5_DESC SABAUDF_FLAG5_DESC VARCHAR2(20) Yes
SABAUDF_FLAG6_DESC SABAUDF_FLAG6_DESC VARCHAR2(20) Yes
SABAUDF_FLAG7_DESC SABAUDF_FLAG7_DESC VARCHAR2(20) Yes
SABAUDF_FLAG8_DESC SABAUDF_FLAG8_DESC VARCHAR2(20) Yes
SABAUDF_FLAG9_DESC SABAUDF_FLAG9_DESC VARCHAR2(20) Yes
SABAUDF_FLAG10_DESC SABAUDF_FLAG10_DESC VARCHAR2(20) Yes
SABAUDF_DATA1_DESC SABAUDF_DATA1_DESC VARCHAR2(20) Yes
SABAUDF_DATA2_DESC SABAUDF_DATA2_DESC VARCHAR2(20) Yes
SABAUDF_DATA3_DESC SABAUDF_DATA3_DESC VARCHAR2(20) Yes
SABAUDF_DATA4_DESC SABAUDF_DATA4_DESC VARCHAR2(20) Yes
SABAUDF_DATA5_DESC SABAUDF_DATA5_DESC VARCHAR2(20) Yes
SABAUDF_DATA6_DESC SABAUDF_DATA6_DESC VARCHAR2(20) Yes
SABAUDF_DATA7_DESC SABAUDF_DATA7_DESC VARCHAR2(20) Yes
SABAUDF_DATA8_DESC SABAUDF_DATA8_DESC VARCHAR2(20) Yes
SABAUDF_DATA9_DESC SABAUDF_DATA9_DESC VARCHAR2(20) Yes
SABAUDF_DATA10_DESC SABAUDF_DATA10_DESC VARCHAR2(20) Yes
SABAUDF_DATA11_DESC SABAUDF_DATA11_DESC VARCHAR2(20) Yes
SABAUDF_DATA12_DESC SABAUDF_DATA12_DESC VARCHAR2(20) Yes
SABAUDF_DATA13_DESC SABAUDF_DATA13_DESC VARCHAR2(20) Yes
SABAUDF_DATA14_DESC SABAUDF_DATA14_DESC VARCHAR2(20) Yes
SABAUDF_DATA15_DESC SABAUDF_DATA15_DESC VARCHAR2(20) Yes
SABAUDF_DATA16_DESC SABAUDF_DATA16_DESC VARCHAR2(20) Yes
SABAUDF_DATA17_DESC SABAUDF_DATA17_DESC VARCHAR2(20) Yes
SABAUDF_DATA18_DESC SABAUDF_DATA18_DESC VARCHAR2(20) Yes
SABAUDF_DATA19_DESC SABAUDF_DATA19_DESC VARCHAR2(20) Yes
SABAUDF_DATA20_DESC SABAUDF_DATA20_DESC VARCHAR2(20) Yes
SABAUDF_ACTIVITY_DATE SABAUDF_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SABAUDF_TERM_CODE_EFF STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SABAUDF Unique SABAUDF_TERM_CODE_EFF

Comments

Source Code Comments

Application User Defined Fields Table

Columns Comments for SABAUDF_TERM_CODE_EFF (1)

Source Code Comments

This is the effective term.

Columns Comments for SABAUDF_ACTIVITY_DATE (32)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Table SABBTCH

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABBTCH_PIDM SABBTCH_PIDM NUMBER(8,0) No *
SABBTCH_TERM_CODE SABBTCH_TERM_CODE VARCHAR2(6) No * *
SABBTCH_APPL_NO SABBTCH_APPL_NO NUMBER(4,0) No *
SABBTCH_JOB_NAME SABBTCH_JOB_NAME VARCHAR2(7) No *
SABBTCH_ACTIVITY_DATE SABBTCH_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SABBTCH_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SABBTCH Unique SABBTCH_PIDM
PK_SABBTCH Unique SABBTCH_TERM_CODE
PK_SABBTCH Unique SABBTCH_APPL_NO
PK_SABBTCH Unique SABBTCH_JOB_NAME

Comments

Source Code Comments

Admission Report Id Selection Table

Columns Comments for SABBTCH_PIDM (1)

Source Code Comments

Internal identification number of student.

Columns Comments for SABBTCH_TERM_CODE (2)

Source Code Comments

This field identifies the term for which information is to be generated.

Columns Comments for SABBTCH_APPL_NO (3)

Source Code Comments

This field identifies the application number associated with the student record.

Columns Comments for SABBTCH_JOB_NAME (4)

Source Code Comments

This field identifies the name of the job to be generated.

Columns Comments for SABBTCH_ACTIVITY_DATE (5)

Source Code Comments

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

Table SABECRL

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABECRL_WAPP_CODE SABECRL_WAPP_CODE VARCHAR2(2) No *
SABECRL_PROC_LABEL SABECRL_PROC_LABEL VARCHAR2(5) No *
SABECRL_PROC_LABEL_DESC SABECRL_PROC_LABEL_DESC VARCHAR2(30) No
SABECRL_REQUIRED_IND SABECRL_REQUIRED_IND VARCHAR2(1) No
SABECRL_OVERRIDE_IND SABECRL_OVERRIDE_IND VARCHAR2(1) No
SABECRL_SYSTEM_REQ_IND SABECRL_SYSTEM_REQ_IND VARCHAR2(1) No
SABECRL_ACTIVITY_DATE SABECRL_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_SABECRL Unique SABECRL_WAPP_CODE
PK_SABECRL Unique SABECRL_PROC_LABEL

Comments

Source Code Comments

Electronic Admissions Control Table

Columns Comments for SABECRL_WAPP_CODE (1)

Source Code Comments

Web Application Code

Columns Comments for SABECRL_PROC_LABEL (2)

Source Code Comments

Procedure Label

Columns Comments for SABECRL_PROC_LABEL_DESC (3)

Source Code Comments

Procedure Label Description

Columns Comments for SABECRL_REQUIRED_IND (4)

Source Code Comments

Procedure Required Indicator

Columns Comments for SABECRL_OVERRIDE_IND (5)

Source Code Comments

Procedure Over-Ride Indicator

Columns Comments for SABECRL_SYSTEM_REQ_IND (6)

Source Code Comments

System Requirement Indicator

Columns Comments for SABECRL_ACTIVITY_DATE (7)

Source Code Comments

Date of Insert or Last Update

Table SABECTM

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABECTM_START_DATE SABECTM_START_DATE DATE No *
SABECTM_END_DATE SABECTM_END_DATE DATE No
SABECTM_TERM_CODE SABECTM_TERM_CODE VARCHAR2(6) No
SABECTM_ACTIVITY_DATE SABECTM_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_SABECTM Unique SABECTM_START_DATE

Comments

Source Code Comments

EDI Cross-Reference Term Code Rules

Columns Comments for SABECTM_START_DATE (1)

Source Code Comments

Starting Date of Date Range for associated Term

Columns Comments for SABECTM_END_DATE (2)

Source Code Comments

End Date of Date Range for associated Term

Columns Comments for SABECTM_TERM_CODE (3)

Source Code Comments

Term associated with the Date Range

Columns Comments for SABECTM_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Table SABXMIT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABXMIT_XMIT_SEQNO SABXMIT_XMIT_SEQNO NUMBER(8,0) No *
SABXMIT_ACTIVITY_DATE SABXMIT_ACTIVITY_DATE DATE No
SABXMIT_CONTROL_NO SABXMIT_CONTROL_NO VARCHAR2(9) Yes
SABXMIT_PRPS_CDE SABXMIT_PRPS_CDE VARCHAR2(2) Yes
SABXMIT_REFERENCE_ID SABXMIT_REFERENCE_ID VARCHAR2(30) Yes
SABXMIT_ORIG_DTE SABXMIT_ORIG_DTE VARCHAR2(6) Yes
SABXMIT_ORIG_TIME SABXMIT_ORIG_TIME VARCHAR2(8) Yes
SABXMIT_TIME_CDE SABXMIT_TIME_CDE VARCHAR2(2) Yes
SABXMIT_ENTY_CDE_SNDR SABXMIT_ENTY_CDE_SNDR VARCHAR2(2) Yes
SABXMIT_NAME1_SNDR SABXMIT_NAME1_SNDR VARCHAR2(35) Yes
SABXMIT_IDQL_CDE_SNDR SABXMIT_IDQL_CDE_SNDR VARCHAR2(2) Yes
SABXMIT_IDEN_CDE_SNDR SABXMIT_IDEN_CDE_SNDR VARCHAR2(20) Yes
SABXMIT_NAME2_SNDR SABXMIT_NAME2_SNDR VARCHAR2(35) Yes
SABXMIT_NAME3_SNDR SABXMIT_NAME3_SNDR VARCHAR2(35) Yes
SABXMIT_STREET_LINE1_SNDR SABXMIT_STREET_LINE1_SNDR VARCHAR2(35) Yes
SABXMIT_STREET_LINE2_SNDR SABXMIT_STREET_LINE2_SNDR VARCHAR2(35) Yes
SABXMIT_CITY_SNDR SABXMIT_CITY_SNDR VARCHAR2(30) Yes
SABXMIT_STAT_CDE_SNDR SABXMIT_STAT_CDE_SNDR VARCHAR2(2) Yes
SABXMIT_ZIP_SNDR SABXMIT_ZIP_SNDR VARCHAR2(15) Yes
SABXMIT_NATN_CDE_SNDR SABXMIT_NATN_CDE_SNDR VARCHAR2(3) Yes
SABXMIT_LCQL_CDE_SNDR SABXMIT_LCQL_CDE_SNDR VARCHAR2(2) Yes
SABXMIT_LOC_ID_SNDR SABXMIT_LOC_ID_SNDR VARCHAR2(30) Yes
SABXMIT_CFNC_CDE_SNDR SABXMIT_CFNC_CDE_SNDR VARCHAR2(2) Yes
SABXMIT_CNTCT_NAME_SNDR SABXMIT_CNTCT_NAME_SNDR VARCHAR2(35) Yes
SABXMIT_PQLF_CDE1_SNDR SABXMIT_PQLF_CDE1_SNDR VARCHAR2(2) Yes
SABXMIT_PHONE_NO1_SNDR SABXMIT_PHONE_NO1_SNDR VARCHAR2(80) Yes
SABXMIT_PQLF_CDE2_SNDR SABXMIT_PQLF_CDE2_SNDR VARCHAR2(2) Yes
SABXMIT_PHONE_NO2_SNDR SABXMIT_PHONE_NO2_SNDR VARCHAR2(80) Yes
SABXMIT_PQLF_CDE3_SNDR SABXMIT_PQLF_CDE3_SNDR VARCHAR2(2) Yes
SABXMIT_PHONE_NO3_SNDR SABXMIT_PHONE_NO3_SNDR VARCHAR2(80) Yes
SABXMIT_ENTY_CDE_RCVR SABXMIT_ENTY_CDE_RCVR VARCHAR2(2) Yes
SABXMIT_NAME1_RCVR SABXMIT_NAME1_RCVR VARCHAR2(35) Yes
SABXMIT_IDQL_CDE_RCVR SABXMIT_IDQL_CDE_RCVR VARCHAR2(2) Yes
SABXMIT_IDEN_CDE_RCVR SABXMIT_IDEN_CDE_RCVR VARCHAR2(20) Yes
SABXMIT_NAME2_RCVR SABXMIT_NAME2_RCVR VARCHAR2(35) Yes
SABXMIT_NAME3_RCVR SABXMIT_NAME3_RCVR VARCHAR2(35) Yes
SABXMIT_STREET_LINE1_RCVR SABXMIT_STREET_LINE1_RCVR VARCHAR2(35) Yes
SABXMIT_STREET_LINE2_RCVR SABXMIT_STREET_LINE2_RCVR VARCHAR2(35) Yes
SABXMIT_CITY_RCVR SABXMIT_CITY_RCVR VARCHAR2(30) Yes
SABXMIT_STAT_CDE_RCVR SABXMIT_STAT_CDE_RCVR VARCHAR2(2) Yes
SABXMIT_ZIP_RCVR SABXMIT_ZIP_RCVR VARCHAR2(15) Yes
SABXMIT_NATN_CDE_RCVR SABXMIT_NATN_CDE_RCVR VARCHAR2(3) Yes
SABXMIT_LCQL_CDE_RCVR SABXMIT_LCQL_CDE_RCVR VARCHAR2(2) Yes
SABXMIT_LOC_ID_RCVR SABXMIT_LOC_ID_RCVR VARCHAR2(30) Yes
SABXMIT_CFNC_CDE_RCVR SABXMIT_CFNC_CDE_RCVR VARCHAR2(2) Yes
SABXMIT_CNTCT_NAME_RCVR SABXMIT_CNTCT_NAME_RCVR VARCHAR2(35) Yes
SABXMIT_PQLF_CDE1_RCVR SABXMIT_PQLF_CDE1_RCVR VARCHAR2(2) Yes
SABXMIT_PHONE_NO1_RCVR SABXMIT_PHONE_NO1_RCVR VARCHAR2(80) Yes
SABXMIT_PQLF_CDE2_RCVR SABXMIT_PQLF_CDE2_RCVR VARCHAR2(2) Yes
SABXMIT_PHONE_NO2_RCVR SABXMIT_PHONE_NO2_RCVR VARCHAR2(80) Yes
SABXMIT_PQLF_CDE3_RCVR SABXMIT_PQLF_CDE3_RCVR VARCHAR2(2) Yes
SABXMIT_PHONE_NO3_RCVR SABXMIT_PHONE_NO3_RCVR VARCHAR2(80) Yes
SABXMIT_LX_NUMBER SABXMIT_LX_NUMBER VARCHAR2(6) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_SABXMIT Unique SABXMIT_XMIT_SEQNO

Comments

Source Code Comments

Electronic Admissions Transmission Header Table

Columns Comments for SABXMIT_XMIT_SEQNO (1)

Source Code Comments

Person Control Sequence Number

Columns Comments for SABXMIT_ACTIVITY_DATE (2)

Source Code Comments

Date of Insert or Last Update

Columns Comments for SABXMIT_CONTROL_NO (3)

Source Code Comments

Transactions Set Control Number(ST02 - 329)

Columns Comments for SABXMIT_PRPS_CDE (4)

Source Code Comments

Transaction Set Purpose Code (BGN01 - 353)

Columns Comments for SABXMIT_REFERENCE_ID (5)

Source Code Comments

Reference Identification (BGN02 - 127)

Columns Comments for SABXMIT_ORIG_DTE (6)

Source Code Comments

Origination Date of Record (BGN03 - 373)

Columns Comments for SABXMIT_ORIG_TIME (7)

Source Code Comments

Origination Time of Record (BGN04 - 337)

Columns Comments for SABXMIT_TIME_CDE (8)

Source Code Comments

Time Code (BGN05 - 623)

Columns Comments for SABXMIT_ENTY_CDE_SNDR (9)

Source Code Comments

Entity Code of Sender (N1-N101 - 98)

Columns Comments for SABXMIT_NAME1_SNDR (10)

Source Code Comments

Name 1 of Sender (N1 - N102 - 93)

Columns Comments for SABXMIT_IDQL_CDE_SNDR (11)

Source Code Comments

ID Qualifier Code of Sender (N1-N103 - 66)

Columns Comments for SABXMIT_IDEN_CDE_SNDR (12)

Source Code Comments

ID of Sender (N1 - N104 - 67)

Columns Comments for SABXMIT_NAME2_SNDR (13)

Source Code Comments

Name 2 of Sender (N1 - N201 - 93)

Columns Comments for SABXMIT_NAME3_SNDR (14)

Source Code Comments

Name 3 of Sender (N1 - N202 - 93)

Columns Comments for SABXMIT_STREET_LINE1_SNDR (15)

Source Code Comments

Street Line 1 of Sender (N1-N301 - 166)

Columns Comments for SABXMIT_STREET_LINE2_SNDR (16)

Source Code Comments

Street Line 2 of Sender (N1-N302 - 166)

Columns Comments for SABXMIT_CITY_SNDR (17)

Source Code Comments

City of Sender (N1-N401-19)

Columns Comments for SABXMIT_STAT_CDE_SNDR (18)

Source Code Comments

State Code of Sender(N1-N402-156)

Columns Comments for SABXMIT_ZIP_SNDR (19)

Source Code Comments

Zip Code of Sender (N1-N403-116)

Columns Comments for SABXMIT_NATN_CDE_SNDR (20)

Source Code Comments

Nation Code of Sender (N1-N404 - 26)

Columns Comments for SABXMIT_LCQL_CDE_SNDR (21)

Source Code Comments

Location Qualifier of Sender (N1-N405-309)

Columns Comments for SABXMIT_LOC_ID_SNDR (22)

Source Code Comments

Location Identifier of Sender(N1-N406-310)

Columns Comments for SABXMIT_CFNC_CDE_SNDR (23)

Source Code Comments

Contact Function Code of Sender (N1-PER01-366)

Columns Comments for SABXMIT_CNTCT_NAME_SNDR (24)

Source Code Comments

Sender Contact Name (N1-PER02-93)

Columns Comments for SABXMIT_PQLF_CDE1_SNDR (25)

Source Code Comments

Contact Phone Number 1 Qualifier (N1-PER03-365)

Columns Comments for SABXMIT_PHONE_NO1_SNDR (26)

Source Code Comments

Contact Phone Number 1 (N1-PER04-364)

Columns Comments for SABXMIT_PQLF_CDE2_SNDR (27)

Source Code Comments

Contact Phone Number 2 Qualifier (N1-PER05-365)

Columns Comments for SABXMIT_PHONE_NO2_SNDR (28)

Source Code Comments

Contact Phone Number 2 (N1-PER06-364)

Columns Comments for SABXMIT_PQLF_CDE3_SNDR (29)

Source Code Comments

Contact Phone Number 3 Qualifier (N1-PER07-365)

Columns Comments for SABXMIT_PHONE_NO3_SNDR (30)

Source Code Comments

Contact Phone Number 3 (N1-PER08-364)

Columns Comments for SABXMIT_ENTY_CDE_RCVR (31)

Source Code Comments

Receiver Entity Code (N1-N101-98)

Columns Comments for SABXMIT_NAME1_RCVR (32)

Source Code Comments

Receiver Name 1 (N1-N102-93)

Columns Comments for SABXMIT_IDQL_CDE_RCVR (33)

Source Code Comments

Receiver ID Qualifier (N1-N103-66)

Columns Comments for SABXMIT_IDEN_CDE_RCVR (34)

Source Code Comments

Receiver ID Code (N1-N104-67)

Columns Comments for SABXMIT_NAME2_RCVR (35)

Source Code Comments

Receiver Name 2 (N1-N201-93)

Columns Comments for SABXMIT_NAME3_RCVR (36)

Source Code Comments

Receiver Name 3 (N1-N202-93)

Columns Comments for SABXMIT_STREET_LINE1_RCVR (37)

Source Code Comments

Receiver Street Line 1 (N1-N301-166)

Columns Comments for SABXMIT_STREET_LINE2_RCVR (38)

Source Code Comments

Receiver Street Line 2 (N1-N302-166)

Columns Comments for SABXMIT_CITY_RCVR (39)

Source Code Comments

Receiver City (N1-N401-19)

Columns Comments for SABXMIT_STAT_CDE_RCVR (40)

Source Code Comments

Receiver State Code (N1-N402-156)

Columns Comments for SABXMIT_ZIP_RCVR (41)

Source Code Comments

Receiver Zip Code (N1-N403-116)

Columns Comments for SABXMIT_NATN_CDE_RCVR (42)

Source Code Comments

Receiver Nation Code (N1-N404-26)

Columns Comments for SABXMIT_LCQL_CDE_RCVR (43)

Source Code Comments

Receiver Location Qualifier (N1-N405-309)

Columns Comments for SABXMIT_LOC_ID_RCVR (44)

Source Code Comments

Receiver Location ID (N1-N406-310)

Columns Comments for SABXMIT_CFNC_CDE_RCVR (45)

Source Code Comments

Receiver Contact Function Code (N1-PER01-366)

Columns Comments for SABXMIT_CNTCT_NAME_RCVR (46)

Source Code Comments

Contact Name (N1-PER02-93)

Columns Comments for SABXMIT_PQLF_CDE1_RCVR (47)

Source Code Comments

Receiver Contact Phone 1 Qualifier (N1-PER03-365)

Columns Comments for SABXMIT_PHONE_NO1_RCVR (48)

Source Code Comments

Receiver Contact Phone 1 (N1-PER04-364)

Columns Comments for SABXMIT_PQLF_CDE2_RCVR (49)

Source Code Comments

Receiver Phone 2 Qualifier (N1-PER05-365)

Columns Comments for SABXMIT_PHONE_NO2_RCVR (50)

Source Code Comments

Receiver Phone 2 (N1-PER06-364)

Columns Comments for SABXMIT_PQLF_CDE3_RCVR (51)

Source Code Comments

Receiver Phone 3 Qualifier (N1-PER07-365)

Columns Comments for SABXMIT_PHONE_NO3_RCVR (52)

Source Code Comments

Receiver Phone 3 (N1-PER)*-364)

Columns Comments for SABXMIT_LX_NUMBER (53)

Source Code Comments

Undetermined

Table SARAATT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SARAATT_PIDM SARAATT_PIDM NUMBER(8,0) No *
SARAATT_TERM_CODE SARAATT_TERM_CODE VARCHAR2(6) No * *
SARAATT_APPL_NO SARAATT_APPL_NO NUMBER(2,0) No *
SARAATT_ATTS_CODE SARAATT_ATTS_CODE VARCHAR2(4) No * *
SARAATT_ACTIVITY_DATE SARAATT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SARAATT_ATTS_CODE STVATTS_CODE STVATTS
SARAATT_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SARAATT Unique SARAATT_PIDM
PK_SARAATT Unique SARAATT_TERM_CODE
PK_SARAATT Unique SARAATT_APPL_NO
PK_SARAATT Unique SARAATT_ATTS_CODE

Comments

Source Code Comments

Admissions Attribute Repeating Table.

Columns Comments for SARAATT_PIDM (1)

Source Code Comments

Internal identification number for whom the attributes are associated with.

Columns Comments for SARAATT_TERM_CODE (2)

Source Code Comments

The term associated with the attributes.

Columns Comments for SARAATT_APPL_NO (3)

Source Code Comments

The Application Number associated with the attributes.

Columns Comments for SARAATT_ATTS_CODE (4)

Source Code Comments

The admissions attributes for the person and term.

Columns Comments for SARAATT_ACTIVITY_DATE (5)

Source Code Comments

The date the record was last updated.

Table SARACMT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SARACMT_PIDM SARACMT_PIDM NUMBER(8,0) No *
SARACMT_TERM_CODE SARACMT_TERM_CODE VARCHAR2(6) No * *
SARACMT_APPL_NO SARACMT_APPL_NO NUMBER(2,0) No *
SARACMT_SEQNO SARACMT_SEQNO NUMBER(23,20) No *
SARACMT_COMMENT_TEXT SARACMT_COMMENT_TEXT VARCHAR2(4000) Yes
SARACMT_ORIG_CODE SARACMT_ORIG_CODE VARCHAR2(4) No *
SARACMT_ACTIVITY_DATE SARACMT_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
SARACMT_ORIG_CODE STVORIG_CODE STVORIG
SARACMT_TERM_CODE STVTERM_CODE STVTERM

Index

Index Name Index Type Column Name
PK_SARACMT Unique SARACMT_PIDM
PK_SARACMT Unique SARACMT_TERM_CODE
PK_SARACMT Unique SARACMT_APPL_NO
PK_SARACMT Unique SARACMT_SEQNO

Comments

Source Code Comments

Application Comments Repeating Table.

Columns Comments for SARACMT_PIDM (1)

Source Code Comments

Internal identification number of applicant.

Columns Comments for SARACMT_TERM_CODE (2)

Source Code Comments

This field identifies the term associated with the application.

Columns Comments for SARACMT_APPL_NO (3)

Source Code Comments

This field identifies the Application number.

Columns Comments for SARACMT_SEQNO (4)

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 SARACMT_COMMENT_TEXT (5)

Source Code Comments

This field specifies the Application comment(s) associated with application record.

Columns Comments for SARACMT_ORIG_CODE (6)

Source Code Comments

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

Columns Comments for SARACMT_ACTIVITY_DATE (7)

Source Code Comments

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

Table SARACTV

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SARACTV_AIDM SARACTV_AIDM NUMBER(8,0) No *
SARACTV_APPL_SEQNO SARACTV_APPL_SEQNO NUMBER(3,0) No *
SARACTV_SEQNO SARACTV_SEQNO NUMBER(4,0) No *
SARACTV_LOAD_IND SARACTV_LOAD_IND VARCHAR2(1) No
SARACTV_ACTIVITY_DATE SARACTV_ACTIVITY_DATE DATE No
SARACTV_PAID_FLAG SARACTV_PAID_FLAG VARCHAR2(1) Yes
SARACTV_SCHOOL_FLAG SARACTV_SCHOOL_FLAG VARCHAR2(1) Yes
SARACTV_RECRUIT_FLAG SARACTV_RECRUIT_FLAG VARCHAR2(1) Yes
SARACTV_CQLF_CDE SARACTV_CQLF_CDE VARCHAR2(3) Yes
SARACTV_ACTV_CDE SARACTV_ACTV_CDE VARCHAR2(30) Yes
SARACTV_ACTIVITY_DESC SARACTV_ACTIVITY_DESC VARCHAR2(132) Yes
SARACTV_SPONSOR SARACTV_SPONSOR VARCHAR2(132) Yes
SARACTV_INVLMT_QTY SARACTV_INVLMT_QTY NUMBER(15,0) Yes
SARACTV_MEAS_CDE SARACTV_MEAS_CDE VARCHAR2(10) Yes
SARACTV_ILVL_CDE SARACTV_ILVL_CDE VARCHAR2(2) Yes
SARACTV_DTQL_CDE1 SARACTV_DTQL_CDE1 VARCHAR2(3) Yes
SARACTV_DFMT_CDE1 SARACTV_DFMT_CDE1 VARCHAR2(3) Yes
SARACTV_REF_DTE1 SARACTV_REF_DTE1 VARCHAR2(35) Yes
SARACTV_DTQL_CDE2 SARACTV_DTQL_CDE2 VARCHAR2(3) Yes
SARACTV_DFMT_CDE2 SARACTV_DFMT_CDE2 VARCHAR2(3) Yes
SARACTV_REF_DTE2 SARACTV_REF_DTE2