APRACYR APRCHIS APRCHLD APRCSPS APRDHIS APRXREF GOBSEVS GOREMAL GORSEVD NBRBJOB PABAPPL PDRBENE PEBEMPL RORSTAT RPRATRM RPRAWRD SARADAP SARDCSN SFBETRM SGBSTDN SHRLGPA SHRTTRM SIBINST SLRRASG SLRRMAT SORMCTZ SORMETH SORMLGY SORMSEX SPBPERS SPRMEDI SRBRECR SRRRSRC STVCITZ STVETHN STVLGCY STVMRTL STVNATN STVRELG TBRACCD TBRAPPL TBRDEPO TBRISTL

Model SPBPERS


Model Label : Banner SPBPERS Table with Linked Tables
Path : BANNER DEV/COMMON/SPBPERS

List of Objects

Object Name Object Type Layer Name
APRACYR TABLE Advancement
APRCHIS TABLE Advancement
APRCHLD TABLE Advancement
APRCSPS TABLE Advancement
APRDHIS TABLE Advancement
APRXREF TABLE Advancement
GOBSEVS TABLE General
GOREMAL TABLE General
GORSEVD TABLE General
NBRBJOB TABLE Payroll
PABAPPL TABLE Payroll
PDRBENE TABLE Payroll
PEBEMPL TABLE Payroll
RORSTAT TABLE FinAid
RPRATRM TABLE FinAid
RPRAWRD TABLE FinAid
SARADAP TABLE Payroll
SARDCSN TABLE Student
SFBETRM TABLE Student
SGBSTDN TABLE Student
SHRLGPA TABLE Student
SHRTTRM TABLE Student
SIBINST TABLE Student
SLRRASG TABLE Common
SLRRMAT TABLE Student
SORMCTZ TABLE Student
SORMETH TABLE Student
SORMLGY TABLE Student
SORMSEX TABLE Student
SPBPERS TABLE Default
SPRMEDI TABLE Common
SRBRECR TABLE Student
SRRRSRC TABLE Student
STVCITZ TABLE Common
STVETHN TABLE Common
STVLGCY TABLE Common
STVMRTL TABLE Common
STVNATN TABLE Student
STVRELG TABLE Common
TBRACCD TABLE A/R
TBRAPPL TABLE A/R
TBRDEPO TABLE A/R
TBRISTL TABLE A/R

Comments

Model View

''

Table APRACYR

Schema Name ALUMNI
Label APRACYR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:05:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
APRACYR_PIDM APRACYR_PIDM NUMBER(8,0) No * *
APRACYR_SACT_CODE APRACYR_SACT_CODE VARCHAR2(3) Yes
APRACYR_YEAR APRACYR_YEAR NUMBER(4,0) No *
APRACYR_ACTIVITY_DATE APRACYR_ACTIVITY_DATE DATE No
APRACYR_ACTC_CODE APRACYR_ACTC_CODE VARCHAR2(8) No * *
APRACYR_ACTC_CODE APRACYR_ACTC_CODE VARCHAR2(8) No * *

Foreign Key information

Column name is Foreign Key For Column on Table
APRACYR_PIDM APRACTY_PIDM APRACTY
APRACYR_ACTC_CODE APRACTY_ACTC_CODE APRACTY
APRACYR_ACTC_CODE STVACTC_CODE STVACTC

Index

Index Name Index Type Column Name
PK_APRACYR Unique APRACYR_PIDM
PK_APRACYR Unique APRACYR_ACTC_CODE
PK_APRACYR Unique APRACYR_YEAR

Comments

Source Code Comments

Special Activity Year Repeating Table

Columns Comments for APRACYR_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRACYR_SACT_CODE (2)

Source Code Comments

This column is no longer used Rel 1.2

Columns Comments for APRACYR_YEAR (3)

Source Code Comments

This field specifies the year(s) associated with a particular special activity.

Columns Comments for APRACYR_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for APRACYR_ACTC_CODE (5)

Source Code Comments

The ACTC code replaced the SACT code in Rel 1.2 using the STVACTC student validation form.

Table APRCHIS

Schema Name ALUMNI
Label APRCHIS
Server name MALDEV8_B60
Creation Date 12/20/2002 10:42:30:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
APRCHIS_PIDM APRCHIS_PIDM NUMBER(8,0) No *
APRCHIS_CAMPAIGN APRCHIS_CAMPAIGN VARCHAR2(5) No * *
APRCHIS_FISC_CODE APRCHIS_FISC_CODE NUMBER(4,0) No * *
APRCHIS_AMT_PLEDGED APRCHIS_AMT_PLEDGED NUMBER(13,2) Yes
APRCHIS_AMT_PLEDGED_PAID APRCHIS_AMT_PLEDGED_PAID NUMBER(13,2) Yes
APRCHIS_AMT_GIFT APRCHIS_AMT_GIFT NUMBER(13,2) Yes
APRCHIS_AMT_MEMO APRCHIS_AMT_MEMO NUMBER(13,2) Yes
APRCHIS_ACTIVITY_DATE APRCHIS_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
APRCHIS_FISC_CODE ATVFISC_CODE ATVFISC
APRCHIS_CAMPAIGN AFBCAMP_CAMPAIGN AFBCAMP

Index

Index Name Index Type Column Name
APRCHIS_KEY_INDEX2 APRCHIS_FISC_CODE
APRCHIS_KEY_INDEX2 APRCHIS_PIDM
APRCHIS_KEY_INDEX3 APRCHIS_CAMPAIGN
PK_APRCHIS Unique APRCHIS_PIDM
PK_APRCHIS Unique APRCHIS_CAMPAIGN
PK_APRCHIS Unique APRCHIS_FISC_CODE

Comments

Source Code Comments

Giving History By Campaign Repeating Table

Columns Comments for APRCHIS_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRCHIS_CAMPAIGN (2)

Source Code Comments

This field specifies the campaign(s) the constituent has responded to with a gift or pledge payment.

Columns Comments for APRCHIS_FISC_CODE (3)

Source Code Comments

This field specifies the fiscal year associated with the campaign.

Columns Comments for APRCHIS_AMT_PLEDGED (4)

Source Code Comments

This field specifies the amount the constituent pledged to a specific campaign.

Columns Comments for APRCHIS_AMT_PLEDGED_PAID (5)

Source Code Comments

This field specifies the amount of pledge payments received from the constituent for a specific campaign.

Columns Comments for APRCHIS_AMT_GIFT (6)

Source Code Comments

This field specifies the amount of gift money received from the constituent for a specific campaign.

Columns Comments for APRCHIS_AMT_MEMO (7)

Source Code Comments

This field specifies the dollar amount of memo credit (soft dollars) the constituent has been credited with for a specific campaign.

Columns Comments for APRCHIS_ACTIVITY_DATE (8)

Source Code Comments

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

Table APRCHLD

Schema Name ALUMNI
Label APRCHLD
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:06:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
APRCHLD_PIDM APRCHLD_PIDM NUMBER(8,0) No * *
APRCHLD_SEQ_NO APRCHLD_SEQ_NO NUMBER(5,0) No *
APRCHLD_LAST_NAME APRCHLD_LAST_NAME VARCHAR2(25) Yes
APRCHLD_FIRST_NAME APRCHLD_FIRST_NAME VARCHAR2(15) Yes
APRCHLD_MI APRCHLD_MI VARCHAR2(1) Yes
APRCHLD_SEX APRCHLD_SEX VARCHAR2(1) Yes
APRCHLD_BIRTH_DATE APRCHLD_BIRTH_DATE DATE Yes
APRCHLD_SSN APRCHLD_SSN VARCHAR2(9) Yes
APRCHLD_ATYP_CODE APRCHLD_ATYP_CODE VARCHAR2(2) Yes *
APRCHLD_ACTIVITY_DATE APRCHLD_ACTIVITY_DATE DATE No
APRCHLD_XREF_CODE APRCHLD_XREF_CODE VARCHAR2(3) Yes *
APRCHLD_CHLD_PIDM APRCHLD_CHLD_PIDM NUMBER(8,0) Yes *
APRCHLD_DISP_WEB_IND APRCHLD_DISP_WEB_IND VARCHAR2(1) Yes
APRCHLD_DECEASED_IND APRCHLD_DECEASED_IND VARCHAR2(1) Yes
APRCHLD_DECEASED_DATE APRCHLD_DECEASED_DATE DATE Yes
APRCHLD_OK_FOR_NOTES_IND APRCHLD_OK_FOR_NOTES_IND VARCHAR2(1) Yes
APRCHLD_DISP_NOTES_IND APRCHLD_DISP_NOTES_IND VARCHAR2(1) Yes
APRCHLD_DISP_NOTES_DATE APRCHLD_DISP_NOTES_DATE DATE Yes
APRCHLD_USER APRCHLD_USER VARCHAR2(30) No
APRCHLD_REVIEWED_IND APRCHLD_REVIEWED_IND VARCHAR2(1) Yes
APRCHLD_REVIEWED_USER APRCHLD_REVIEWED_USER VARCHAR2(30) Yes
APRCHLD_COMMENT APRCHLD_COMMENT LONG Yes

Foreign Key information

Column name is Foreign Key For Column on Table
APRCHLD_PIDM APBCONS_PIDM APBCONS
APRCHLD_XREF_CODE ATVXREF_CODE ATVXREF
APRCHLD_CHLD_PIDM SPBPERS_PIDM SPBPERS
APRCHLD_ATYP_CODE STVATYP_CODE STVATYP

Index

Index Name Index Type Column Name
PK_APRCHLD Unique APRCHLD_PIDM
PK_APRCHLD Unique APRCHLD_SEQ_NO

Comments

Source Code Comments

Children Repeating Table

Columns Comments for APRCHLD_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRCHLD_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for APRCHLD_LAST_NAME (3)

Source Code Comments

This field specifies the last name of the constituents child.

Columns Comments for APRCHLD_FIRST_NAME (4)

Source Code Comments

This field specifies the first name of the constituents child.

Columns Comments for APRCHLD_MI (5)

Source Code Comments

This field specifies the middle initial of the constituents child.

Columns Comments for APRCHLD_SEX (6)

Source Code Comments

This field specifies the gender of the constituents child.

Columns Comments for APRCHLD_BIRTH_DATE (7)

Source Code Comments

This field specifies the date of birth of the constituents child.

Columns Comments for APRCHLD_SSN (8)

Source Code Comments

This field specifies the social security number of the constituents child.

Columns Comments for APRCHLD_ATYP_CODE (9)

Source Code Comments

This field specifies the constituent address type to used when corresponding with the constituents child.

Columns Comments for APRCHLD_ACTIVITY_DATE (10)

Source Code Comments

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

Columns Comments for APRCHLD_XREF_CODE (11)

Source Code Comments

This field is used to identify the cross reference record created for the constituent and child relationship.

Columns Comments for APRCHLD_CHLD_PIDM (12)

Source Code Comments

This field is internal identification number for the child. This is an optional field and is only used for children that have id on the system.

Columns Comments for APRCHLD_DISP_WEB_IND (13)

Source Code Comments

Display on the Web Indicator, Y indicates that this child may be displayed on the Web.

Columns Comments for APRCHLD_DECEASED_IND (14)

Source Code Comments

Deceased Indicator, Y indicates the this child is deceased.

Columns Comments for APRCHLD_DECEASED_DATE (15)

Source Code Comments

This id the date the child became deceased.

Columns Comments for APRCHLD_OK_FOR_NOTES_IND (16)

Source Code Comments

OK for Note Indicator, Y indicates that it is OK to use this child in Class Notes.

Columns Comments for APRCHLD_DISP_NOTES_IND (17)

Source Code Comments

Displayed in Notes Indicator, Y indicates that this child has been used in Class Notes.

Columns Comments for APRCHLD_DISP_NOTES_DATE (18)

Source Code Comments

The date that this child was used in Class Notes.

Columns Comments for APRCHLD_USER (19)

Source Code Comments

The User ID of the person who created or last modified the child record.

Columns Comments for APRCHLD_REVIEWED_IND (20)

Source Code Comments

Reviewed Indicator, Y indicates that this child has been reviewed and accepted.

Columns Comments for APRCHLD_REVIEWED_USER (21)

Source Code Comments

The User ID of the person who reviewed and accepted this child.

Columns Comments for APRCHLD_COMMENT (22)

Source Code Comments

Free form text comment for this child.

Table APRCSPS

Schema Name ALUMNI
Label APRCSPS
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:06:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
APRCSPS_PIDM APRCSPS_PIDM NUMBER(8,0) No *
APRCSPS_PIDM APRCSPS_PIDM NUMBER(8,0) No *
APRCSPS_PIDM APRCSPS_PIDM NUMBER(8,0) No *
APRCSPS_MARS_IND APRCSPS_MARS_IND VARCHAR2(1) No
APRCSPS_ACTIVITY_DATE APRCSPS_ACTIVITY_DATE DATE No
APRCSPS_SPS_PIDM APRCSPS_SPS_PIDM NUMBER(8,0) Yes *
APRCSPS_SPS_PIDM APRCSPS_SPS_PIDM NUMBER(8,0) Yes *
APRCSPS_SPS_PIDM APRCSPS_SPS_PIDM NUMBER(8,0) Yes *
APRCSPS_LAST_NAME APRCSPS_LAST_NAME VARCHAR2(60) Yes
APRCSPS_FIRST_NAME APRCSPS_FIRST_NAME VARCHAR2(15) Yes
APRCSPS_MAIDEN_NAME APRCSPS_MAIDEN_NAME VARCHAR2(60) Yes
APRCSPS_NAME_PREFIX APRCSPS_NAME_PREFIX VARCHAR2(20) Yes
APRCSPS_NAME_SUFFIX APRCSPS_NAME_SUFFIX VARCHAR2(20) Yes
APRCSPS_BIRTH_DATE APRCSPS_BIRTH_DATE DATE Yes
APRCSPS_SPS_COMMENT APRCSPS_SPS_COMMENT VARCHAR2(60) Yes
APRCSPS_MRTL_CODE APRCSPS_MRTL_CODE VARCHAR2(1) Yes *
APRCSPS_MRTL_START_DATE APRCSPS_MRTL_START_DATE DATE Yes
APRCSPS_MRTL_END_DATE APRCSPS_MRTL_END_DATE DATE Yes
APRCSPS_DEAD_IND APRCSPS_DEAD_IND VARCHAR2(1) Yes
APRCSPS_DEAD_DATE APRCSPS_DEAD_DATE DATE Yes
APRCSPS_XREF_CODE APRCSPS_XREF_CODE VARCHAR2(3) Yes *
APRCSPS_MI APRCSPS_MI VARCHAR2(15) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
APRCSPS_PIDM APRDHIS_PIDM APRDHIS
APRCSPS_PIDM APBCONS_PIDM APBCONS
APRCSPS_XREF_CODE ATVXREF_CODE ATVXREF
APRCSPS_PIDM APRCHIS_PIDM APRCHIS
APRCSPS_SPS_PIDM APRCATG_PIDM APRCATG
APRCSPS_SPS_PIDM SPBPERS_PIDM SPBPERS
APRCSPS_SPS_PIDM SPRIDEN_PIDM SPRIDEN
APRCSPS_MRTL_CODE STVMRTL_CODE STVMRTL

Index

Index Name Index Type Column Name
APRCSPS_KEY_INDEX APRCSPS_PIDM

Comments

Source Code Comments

Constituent Spouse Table

Columns Comments for APRCSPS_PIDM (1)

Source Code Comments

This is the internal identification number of the constituent who is associated with the spouse.

Columns Comments for APRCSPS_MARS_IND (2)

Source Code Comments

This field is the marriage status indicator. Valid values are A for active and I for inactive. Each constituent is allowed only one spouse record with a marriage status of A.

Columns Comments for APRCSPS_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for APRCSPS_SPS_PIDM (4)

Source Code Comments

This field is the internal identification number of the spouse of the constituent. This field is optional and is populated only if the spouse has an id in BANNER.

Columns Comments for APRCSPS_LAST_NAME (5)

Source Code Comments

This field is the last name of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the name will display from the identification form, SPAIDEN or APAIDEN.

Columns Comments for APRCSPS_FIRST_NAME (6)

Source Code Comments

This field is the first name of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the name will display from the identification form, SPAIDEN or APAIDEN.

Columns Comments for APRCSPS_MAIDEN_NAME (7)

Source Code Comments

This field is the maiden name of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the name will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_NAME_PREFIX (8)

Source Code Comments

This field is the spouses prefix. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_NAME_SUFFIX (9)

Source Code Comments

This field is the spouses suffix. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_BIRTH_DATE (10)

Source Code Comments

This field is the spouses birth date. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_SPS_COMMENT (11)

Source Code Comments

This field contains comments about the spouse.

Columns Comments for APRCSPS_MRTL_CODE (12)

Source Code Comments

This field is the spouses marital status. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_MRTL_START_DATE (13)

Source Code Comments

This field is the start date of the marriage.

Columns Comments for APRCSPS_MRTL_END_DATE (14)

Source Code Comments

This field is the end date of the marriage. It will default to the current date when an inactive status is entered. It is blank for active marriages.

Columns Comments for APRCSPS_DEAD_IND (15)

Source Code Comments

This field is the deceased indicator of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_DEAD_DATE (16)

Source Code Comments

This field is the deceased date of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_XREF_CODE (17)

Source Code Comments

Code used to create cross reference for the spouse on the APAXREF form. Spouse indiciator on ATVXREF table must by Y for marriage status of A, and N for marriage status of I.

Columns Comments for APRCSPS_MI (18)

Source Code Comments

Spouse middle name. It will be stored on aprcsps if the spouse does not have a BANNER Id. If the spouse does have an Id, the name be stored on spriden.

Table APRDHIS

Schema Name ALUMNI
Label APRDHIS
Server name MALDEV8_B60
Creation Date 12/20/2002 10:42:33:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
APRDHIS_PIDM APRDHIS_PIDM NUMBER(8,0) No *
APRDHIS_DESG APRDHIS_DESG VARCHAR2(10) No *
APRDHIS_FISC_CODE APRDHIS_FISC_CODE NUMBER(4,0) No * *
APRDHIS_AMT_PLEDGED APRDHIS_AMT_PLEDGED NUMBER(13,2) Yes
APRDHIS_AMT_PLEDGED_PAID APRDHIS_AMT_PLEDGED_PAID NUMBER(13,2) Yes
APRDHIS_AMT_GIFT APRDHIS_AMT_GIFT NUMBER(13,2) Yes
APRDHIS_AMT_MEMO APRDHIS_AMT_MEMO NUMBER(13,2) Yes
APRDHIS_ACTIVITY_DATE APRDHIS_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
APRDHIS_FISC_CODE ATVFISC_CODE ATVFISC

Index

Index Name Index Type Column Name
APRDHIS_KEY_INDEX2 APRDHIS_FISC_CODE
APRDHIS_KEY_INDEX2 APRDHIS_PIDM
APRDHIS_KEY_INDEX3 APRDHIS_DESG
PK_APRDHIS Unique APRDHIS_PIDM
PK_APRDHIS Unique APRDHIS_DESG
PK_APRDHIS Unique APRDHIS_FISC_CODE

Comments

Source Code Comments

Giving History By Desg Repeating Table

Columns Comments for APRDHIS_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRDHIS_DESG (2)

Source Code Comments

This field specifies the designation(s) associated with the constituents gifts and/or pledge payments.

Columns Comments for APRDHIS_FISC_CODE (3)

Source Code Comments

This field specifies the fiscal year of the campaign the associated with the designation.

Columns Comments for APRDHIS_AMT_PLEDGED (4)

Source Code Comments

This field specifies the amount the constituent pledged for a specific designation.

Columns Comments for APRDHIS_AMT_PLEDGED_PAID (5)

Source Code Comments

This field specifies the amount of pledge payments for a specific designation.

Columns Comments for APRDHIS_AMT_GIFT (6)

Source Code Comments

This field specifies the dollar amount of gifts received from a constituent for a specific designation.

Columns Comments for APRDHIS_AMT_MEMO (7)

Source Code Comments

This field specifies the amount of memo credit (soft dollars) credited to the constituent for a specific designation.

Columns Comments for APRDHIS_ACTIVITY_DATE (8)

Source Code Comments

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

Table APRXREF

Schema Name ALUMNI
Label APRXREF
Server name MALDEV8_B60
Creation Date 04/15/2002 18:16:08:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
APRXREF_PIDM APRXREF_PIDM NUMBER(8,0) No *
APRXREF_XREF_CODE APRXREF_XREF_CODE VARCHAR2(3) No * *
APRXREF_XREF_CODE APRXREF_XREF_CODE VARCHAR2(3) No * *
APRXREF_XREF_PIDM APRXREF_XREF_PIDM NUMBER(8,0) No *
APRXREF_ACTIVITY_DATE APRXREF_ACTIVITY_DATE DATE No
APRXREF_CM_PRI_IND APRXREF_CM_PRI_IND VARCHAR2(1) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
APRXREF_XREF_CODE ATVXREF_CODE ATVXREF
APRXREF_XREF_CODE AGBSPRL_XREF_CODE AGBSPRL

Index

Index Name Index Type Column Name
PK_APRXREF Unique APRXREF_PIDM
PK_APRXREF Unique APRXREF_XREF_CODE
PK_APRXREF Unique APRXREF_XREF_PIDM

Comments

Source Code Comments

Cross Reference Repeating View

Columns Comments for APRXREF_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRXREF_XREF_CODE (2)

Source Code Comments

This field specifies the code that identifies the relationship to the cross-referenced constituent.

Columns Comments for APRXREF_XREF_PIDM (3)

Source Code Comments

This field specifies the internal system generated identification number of the constituent that is cross-referenced.

Columns Comments for APRXREF_ACTIVITY_DATE (4)

Source Code Comments

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

Columns Comments for APRXREF_CM_PRI_IND (5)

Source Code Comments

This field indicates the relationship of the pidm to the xref pidm for spousal relations.

Table GOBSEVS

Schema Name GENERAL
Label GOBSEVS
Server name MALDEV8_B60
Creation Date 05/23/2003 13:35:50:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBSEVS_PIDM GOBSEVS_PIDM NUMBER(8,0) No * *
GOBSEVS_ENG_PROF_REQ_IND GOBSEVS_ENG_PROF_REQ_IND VARCHAR2(1) No
GOBSEVS_ENG_PROF_MET_IND GOBSEVS_ENG_PROF_MET_IND VARCHAR2(1) No
GOBSEVS_CRIMINAL_CONVICT_IND GOBSEVS_CRIMINAL_CONVICT_IND VARCHAR2(1) No
GOBSEVS_TERMINATE_STUDENT_IND GOBSEVS_TERMINATE_STUDENT_IND VARCHAR2(1) No
GOBSEVS_EXTEND_FAILURE_IND GOBSEVS_EXTEND_FAILURE_IND VARCHAR2(1) No
GOBSEVS_TRANSFER_FAIL_IND GOBSEVS_TRANSFER_FAIL_IND VARCHAR2(1) No
GOBSEVS_APPROVAL_FAIL_IND GOBSEVS_APPROVAL_FAIL_IND VARCHAR2(1) No
GOBSEVS_OTHER_INFRACT_IND GOBSEVS_OTHER_INFRACT_IND VARCHAR2(1) No
GOBSEVS_ACTIVITY_DATE GOBSEVS_ACTIVITY_DATE DATE No
GOBSEVS_USER_ID GOBSEVS_USER_ID VARCHAR2(30) No
GOBSEVS_BIRTH_NATN_CODE GOBSEVS_BIRTH_NATN_CODE VARCHAR2(5) Yes *
GOBSEVS_LEGAL_NATN_CODE GOBSEVS_LEGAL_NATN_CODE VARCHAR2(5) Yes *
GOBSEVS_PROGRAM_BEGIN_DATE GOBSEVS_PROGRAM_BEGIN_DATE DATE Yes
GOBSEVS_PROGRAM_END_DATE GOBSEVS_PROGRAM_END_DATE DATE Yes
GOBSEVS_PROGRAM_ENROLL_DATE GOBSEVS_PROGRAM_ENROLL_DATE DATE Yes
GOBSEVS_ENG_PROF_REASON GOBSEVS_ENG_PROF_REASON VARCHAR2(500) Yes
GOBSEVS_ACADEMIC_TERM_MONTHS GOBSEVS_ACADEMIC_TERM_MONTHS NUMBER(3,0) Yes
GOBSEVS_TUITION_EXPENSE GOBSEVS_TUITION_EXPENSE NUMBER(12,2) Yes
GOBSEVS_PERSONAL_FUNDS GOBSEVS_PERSONAL_FUNDS NUMBER(12,2) Yes
GOBSEVS_TRANS_CDE GOBSEVS_TRANS_CDE VARCHAR2(10) Yes
GOBSEVS_SEVIS_ID GOBSEVS_SEVIS_ID VARCHAR2(11) Yes
GOBSEVS_VTYP_CODE GOBSEVS_VTYP_CODE VARCHAR2(2) Yes *
GOBSEVS_SVCR_CODE GOBSEVS_SVCR_CODE VARCHAR2(4) Yes *
GOBSEVS_SESSION_START_DATE GOBSEVS_SESSION_START_DATE DATE Yes
GOBSEVS_SESSION_END_DATE GOBSEVS_SESSION_END_DATE DATE Yes
GOBSEVS_TRANSFER_COMMENT GOBSEVS_TRANSFER_COMMENT VARCHAR2(500) Yes
GOBSEVS_ISSUE_COMMENT GOBSEVS_ISSUE_COMMENT VARCHAR2(500) Yes
GOBSEVS_SVEL_CODE GOBSEVS_SVEL_CODE VARCHAR2(2) Yes *
GOBSEVS_MAJR_CODE GOBSEVS_MAJR_CODE VARCHAR2(4) Yes *
GOBSEVS_STUDY_LENGTH GOBSEVS_STUDY_LENGTH NUMBER(3,0) Yes
GOBSEVS_LIVING_EXPENSES GOBSEVS_LIVING_EXPENSES NUMBER(12,2) Yes
GOBSEVS_SVFT_CODE GOBSEVS_SVFT_CODE VARCHAR2(2) Yes *
GOBSEVS_AUTH_START_DATE GOBSEVS_AUTH_START_DATE DATE Yes
GOBSEVS_COMPLETION_REMARKS GOBSEVS_COMPLETION_REMARKS VARCHAR2(500) Yes
GOBSEVS_NEW_PROGRAM_END_DATE GOBSEVS_NEW_PROGRAM_END_DATE DATE Yes
GOBSEVS_DA_PROGRAM_START_DATE GOBSEVS_DA_PROGRAM_START_DATE DATE Yes
GOBSEVS_DA_PROGRAM_END_DATE GOBSEVS_DA_PROGRAM_END_DATE DATE Yes
GOBSEVS_DISC_ACTION_TEXT GOBSEVS_DISC_ACTION_TEXT VARCHAR2(500) Yes
GOBSEVS_EMPLOYMENT_CDE GOBSEVS_EMPLOYMENT_CDE VARCHAR2(2) Yes
GOBSEVS_EMPLOYMENT_COMMENT GOBSEVS_EMPLOYMENT_COMMENT VARCHAR2(500) Yes
GOBSEVS_EMPLOYMENT_START_DATE GOBSEVS_EMPLOYMENT_START_DATE DATE Yes
GOBSEVS_EMPLOYMENT_END_DATE GOBSEVS_EMPLOYMENT_END_DATE DATE Yes
GOBSEVS_EMPLOYMENT_TYPE_CDE GOBSEVS_EMPLOYMENT_TYPE_CDE VARCHAR2(2) Yes
GOBSEVS_EMPLOYER_LAST_NAME GOBSEVS_EMPLOYER_LAST_NAME VARCHAR2(500) Yes
GOBSEVS_EMPLOYER_FIRST_NAME GOBSEVS_EMPLOYER_FIRST_NAME VARCHAR2(40) Yes
GOBSEVS_EMP_ADDRESS_LINE1 GOBSEVS_EMP_ADDRESS_LINE1 VARCHAR2(60) Yes
GOBSEVS_EMP_ADDRESS_LINE2 GOBSEVS_EMP_ADDRESS_LINE2 VARCHAR2(60) Yes
GOBSEVS_EMPLOYER_CITY GOBSEVS_EMPLOYER_CITY VARCHAR2(60) Yes
GOBSEVS_EMPLOYER_STATE GOBSEVS_EMPLOYER_STATE VARCHAR2(2) Yes
GOBSEVS_EMPLOYER_ZIP GOBSEVS_EMPLOYER_ZIP VARCHAR2(9) Yes
GOBSEVS_COURSE_RELEVANCE GOBSEVS_COURSE_RELEVANCE VARCHAR2(500) Yes
GOBSEVS_EXTEND_END_DATE GOBSEVS_EXTEND_END_DATE DATE Yes
GOBSEVS_SVTR_CODE GOBSEVS_SVTR_CODE VARCHAR2(6) Yes *
GOBSEVS_TERMINATE_DATE GOBSEVS_TERMINATE_DATE DATE Yes
GOBSEVS_APPROVAL_FAIL_COMMENT GOBSEVS_APPROVAL_FAIL_COMMENT VARCHAR2(500) Yes
GOBSEVS_OTHER_INFRACT_COMMENT GOBSEVS_OTHER_INFRACT_COMMENT VARCHAR2(500) Yes
GOBSEVS_SVEP_CODE GOBSEVS_SVEP_CODE VARCHAR2(4) Yes *
GOBSEVS_END_PROGRAM_EFF_DATE GOBSEVS_END_PROGRAM_EFF_DATE DATE Yes
GOBSEVS_EV_FORM_NUMBER GOBSEVS_EV_FORM_NUMBER VARCHAR2(40) Yes
GOBSEVS_SVRP_CODE GOBSEVS_SVRP_CODE VARCHAR2(2) Yes *
GOBSEVS_REPRINT_REASON_COMMENT GOBSEVS_REPRINT_REASON_COMMENT VARCHAR2(500) Yes
GOBSEVS_SVCR_COMMENT GOBSEVS_SVCR_COMMENT VARCHAR2(500) Yes
GOBSEVS_PRINT_REQUEST_IND GOBSEVS_PRINT_REQUEST_IND VARCHAR2(1) No
GOBSEVS_DEPENDENT_EXPENSES GOBSEVS_DEPENDENT_EXPENSES NUMBER(12,2) Yes
GOBSEVS_OTHER_FUNDS GOBSEVS_OTHER_FUNDS NUMBER(12,2) Yes
GOBSEVS_OTHER_FUNDS_COMMENT GOBSEVS_OTHER_FUNDS_COMMENT VARCHAR2(500) Yes
GOBSEVS_OTHER_EXPENSES GOBSEVS_OTHER_EXPENSES NUMBER(12,2) Yes
GOBSEVS_OTHER_EXP_COMMENT GOBSEVS_OTHER_EXP_COMMENT VARCHAR2(500) Yes
GOBSEVS_AUTH_END_DATE GOBSEVS_AUTH_END_DATE DATE Yes
GOBSEVS_NEW_PROGRAM_START_DATE GOBSEVS_NEW_PROGRAM_START_DATE DATE Yes
GOBSEVS_SVPC_CODE GOBSEVS_SVPC_CODE VARCHAR2(3) Yes *
GOBSEVS_SVSC_CODE GOBSEVS_SVSC_CODE VARCHAR2(7) Yes
GOBSEVS_SVSC_COMMENT GOBSEVS_SVSC_COMMENT VARCHAR2(500) Yes
GOBSEVS_COMMUTER_IND GOBSEVS_COMMUTER_IND VARCHAR2(1) No
GOBSEVS_ADMISSION_NUMBER GOBSEVS_ADMISSION_NUMBER VARCHAR2(11) Yes
GOBSEVS_DRIVERS_LIC_NUMBER GOBSEVS_DRIVERS_LIC_NUMBER VARCHAR2(30) Yes
GOBSEVS_STAT_CODE_DRIVERS_LIC GOBSEVS_STAT_CODE_DRIVERS_LIC VARCHAR2(2) Yes *
GOBSEVS_TIN GOBSEVS_TIN VARCHAR2(9) Yes
GOBSEVS_MAJR_CODE_2 GOBSEVS_MAJR_CODE_2 VARCHAR2(4) Yes *
GOBSEVS_MAJR_CODE_MINR GOBSEVS_MAJR_CODE_MINR VARCHAR2(4) Yes *
GOBSEVS_SCHOOL_FUNDS GOBSEVS_SCHOOL_FUNDS NUMBER(12,2) Yes
GOBSEVS_SCHOOL_FUNDS_COMMENT GOBSEVS_SCHOOL_FUNDS_COMMENT VARCHAR2(500) Yes
GOBSEVS_EMPLOYMENT_FUNDS GOBSEVS_EMPLOYMENT_FUNDS NUMBER(12,2) Yes
GOBSEVS_FUNDING_COMMENT GOBSEVS_FUNDING_COMMENT VARCHAR2(500) Yes
GOBSEVS_SVFT_COMMENT GOBSEVS_SVFT_COMMENT VARCHAR2(500) Yes
GOBSEVS_SVEP_COMMENT GOBSEVS_SVEP_COMMENT VARCHAR2(500) Yes
GOBSEVS_DA_COMMENT GOBSEVS_DA_COMMENT VARCHAR2(500) Yes
GOBSEVS_SVTR_COMMENT GOBSEVS_SVTR_COMMENT VARCHAR2(500) Yes
GOBSEVS_PASSPORT_NUMBER GOBSE