Model STVCAMP

Model Label : ERD for Banner Student STVCAMP Table
Path : BANNER DEV/Student/Common/STVCAMP/STVCAMP_ERD

List of Objects

Object Name	Object Type	Layer Name
APRADEG	TABLE	Default
GTVPARS	TABLE	Default
PEBEMPL	TABLE	Default
RORCAMP	TABLE	Default
RORWKST	TABLE	Default
SARCHKB	TABLE	Default
SARQKER	TABLE	Default
SARRRFT	TABLE	Default
SARWAAD	TABLE	Default
SCRRCAM	TABLE	Default
SCRRCMP	TABLE	Default
SCRSECT	TABLE	Default
SFRSTCR	TABLE	Default
SFRTMSL	TABLE	Default
SFRTMST	TABLE	Default
SGRDSER	TABLE	Default
SHBGSCH	TABLE	Default
SHRCGDR	TABLE	Default
SHRGPAC	TABLE	Default
SHRGPAL	TABLE	Default
SHRPREV	TABLE	Default
SHRTCKN	TABLE	Default
SLBRMAP	TABLE	Default
SLBRMPF	TABLE	Default
SLRTASG	TABLE	Default
SMRACAA	TABLE	Default
SMRAQUA	TABLE	Default
SMRAREX	TABLE	Default
SMRARSA	TABLE	Default
SMRARUL	TABLE	Default
SMRGCAA	TABLE	Default
SMRGREX	TABLE	Default
SMRGRSA	TABLE	Default
SMRGRUL	TABLE	Default
SMRIECP	TABLE	Default
SMRPCRS	TABLE	Default
SMRPRLE	TABLE	Layer(1)
SMRPRSA	TABLE	Default
SMRRQCM	TABLE	Default
SMRSACA	TABLE	Default
SMRSARE	TABLE	Default
SMRSARS	TABLE	Default
SMRSARU	TABLE	Default
SMRSGCA	TABLE	Default
SMRSGRE	TABLE	Default
SMRSGRS	TABLE	Default
SMRSGRU	TABLE	Default
SMRSPRS	TABLE	Default
SOBCALD	TABLE	Default
SOBCURR	TABLE	Default
SOBODTE	TABLE	Default
SOBPROF	TABLE	Default
SORCCOL	TABLE	Default
SORCOMM	TABLE	Default
SOREXTN	TABLE	Default
SORRFND	TABLE	Default
SORRSTS	TABLE	Default
SORT22A	TABLE	Default
SORWDSP	TABLE	Default
SRBPRED	TABLE	Default
SRTPREL	TABLE	Default
SSBDFEE	TABLE	Default
SSBSECT	TABLE	Default
SSRCTRL	TABLE	Default
SSRRCMP	TABLE	Default
SSTSCHW	TABLE	Default
STVCAMP	TABLE	Layer(1)
TBRIACM	TABLE	Default

Comments

Model View

Table APRADEG

Schema Name ALUMNI
Label APRADEG
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
APRADEG_PIDM	APRADEG_PIDM	NUMBER(8,0)	No	*	*
APRADEG_PIDM	APRADEG_PIDM	NUMBER(8,0)	No	*	*
APRADEG_SEQ_NO	APRADEG_SEQ_NO	NUMBER(5,0)	No	*
APRADEG_SBGI_CODE	APRADEG_SBGI_CODE	VARCHAR2(6)	Yes		*
APRADEG_DEGC_CODE	APRADEG_DEGC_CODE	VARCHAR2(6)	Yes		*
APRADEG_DATE	APRADEG_DATE	DATE	Yes
APRADEG_HONR_CODE	APRADEG_HONR_CODE	VARCHAR2(6)	Yes		*
APRADEG_COLL_CODE	APRADEG_COLL_CODE	VARCHAR2(2)	Yes		*
APRADEG_ACTIVITY_DATE	APRADEG_ACTIVITY_DATE	DATE	No
APRADEG_ACYR_CODE	APRADEG_ACYR_CODE	VARCHAR2(4)	Yes		*
APRADEG_ACYR_CODE_BULLETIN	APRADEG_ACYR_CODE_BULLETIN	VARCHAR2(4)	Yes		*
APRADEG_CAMP_CODE	APRADEG_CAMP_CODE	VARCHAR2(3)	Yes		*
APRADEG_DEPT_CODE	APRADEG_DEPT_CODE	VARCHAR2(4)	Yes		*
APRADEG_COMMENTS	APRADEG_COMMENTS	VARCHAR2(2000)	Yes
APRADEG_MAJR_CODE_MINR_1	APRADEG_MAJR_CODE_MINR_1	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_MINR_2	APRADEG_MAJR_CODE_MINR_2	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_1	APRADEG_MAJR_CODE_CONC_1	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_2	APRADEG_MAJR_CODE_CONC_2	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_3	APRADEG_MAJR_CODE_CONC_3	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_4	APRADEG_MAJR_CODE_CONC_4	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_5	APRADEG_MAJR_CODE_CONC_5	VARCHAR2(4)	Yes		*
APRADEG_MAJR_CODE_CONC_6	APRADEG_MAJR_CODE_CONC_6	VARCHAR2(4)	Yes		*
APRADEG_DEPT_CODE_2	APRADEG_DEPT_CODE_2	VARCHAR2(4)	Yes		*
APRADEG_HONR_CODE_2	APRADEG_HONR_CODE_2	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_3	APRADEG_HONR_CODE_3	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_4	APRADEG_HONR_CODE_4	VARCHAR2(6)	Yes		*
APRADEG_HONR_CODE_5	APRADEG_HONR_CODE_5	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_1	APRADEG_HOND_CODE_1	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_2	APRADEG_HOND_CODE_2	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_3	APRADEG_HOND_CODE_3	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_4	APRADEG_HOND_CODE_4	VARCHAR2(6)	Yes		*
APRADEG_HOND_CODE_5	APRADEG_HOND_CODE_5	VARCHAR2(6)	Yes		*
APRADEG_OK_FOR_NOTES_IND	APRADEG_OK_FOR_NOTES_IND	VARCHAR2(1)	Yes
APRADEG_DISP_NOTES_IND	APRADEG_DISP_NOTES_IND	VARCHAR2(1)	Yes
APRADEG_DISP_NOTES_DATE	APRADEG_DISP_NOTES_DATE	DATE	Yes
APRADEG_USER	APRADEG_USER	VARCHAR2(30)	No
APRADEG_REVIEWED_IND	APRADEG_REVIEWED_IND	VARCHAR2(1)	Yes
APRADEG_REVIEWED_USER	APRADEG_REVIEWED_USER	VARCHAR2(30)	Yes
APRADEG_MAJOR_COMMENT	APRADEG_MAJOR_COMMENT	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRADEG_PIDM	APBCONS_PIDM	APBCONS
APRADEG_COLL_CODE	STVCOLL_CODE	STVCOLL
APRADEG_DEGC_CODE	STVDEGC_CODE	STVDEGC
APRADEG_CAMP_CODE	STVCAMP_CODE	STVCAMP
APRADEG_SBGI_CODE	STVSBGI_CODE	STVSBGI
APRADEG_PIDM	APRACYR_PIDM	APRACYR

Index

Index Name	Index Type	Column Name
PK_APRADEG	Unique	APRADEG_PIDM
PK_APRADEG	Unique	APRADEG_SEQ_NO

Comments

Source Code Comments

Academic Degree Repeating Table

Columns Comments for APRADEG_PIDM (1)

Source Code Comments

This field specifies the internal system generated identification number.

Columns Comments for APRADEG_SEQ_NO (2)

Source Code Comments

This field specifies the internal sequence number.

Columns Comments for APRADEG_SBGI_CODE (3)

Source Code Comments

This field specifies the institution at which the constituent earned the degree.

Columns Comments for APRADEG_DEGC_CODE (4)

Source Code Comments

This field spsecifies the type of degree earned by the constituent.

Columns Comments for APRADEG_DATE (5)

Source Code Comments

This field specifies the date the degree was awarded to the constituent.

Columns Comments for APRADEG_HONR_CODE (6)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_COLL_CODE (7)

Source Code Comments

This field specifies the college that awarded the associated degree to the constituent.

Columns Comments for APRADEG_ACTIVITY_DATE (8)

Source Code Comments

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

Columns Comments for APRADEG_ACYR_CODE (9)

Source Code Comments

The Academic Year Code associated with this degree.

Columns Comments for APRADEG_ACYR_CODE_BULLETIN (10)

Source Code Comments

The Academic Year Bulletin Code associated with this degree.

Columns Comments for APRADEG_CAMP_CODE (11)

Source Code Comments

The campus associated with this degree.

Columns Comments for APRADEG_DEPT_CODE (12)

Source Code Comments

The first department associated with this degree.

Columns Comments for APRADEG_COMMENTS (13)

Source Code Comments

Free form text comments about this degree.

Columns Comments for APRADEG_MAJR_CODE_MINR_1 (14)

Source Code Comments

The first Minor code associated with this degree.

Columns Comments for APRADEG_MAJR_CODE_MINR_2 (15)

Source Code Comments

The second Minor code associated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_1 (16)

Source Code Comments

The first Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_2 (17)

Source Code Comments

The second Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_3 (18)

Source Code Comments

The third Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_4 (19)

Source Code Comments

The fourth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_5 (20)

Source Code Comments

The fifth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_MAJR_CODE_CONC_6 (21)

Source Code Comments

The sixth Concentration Code assosiated with this degree.

Columns Comments for APRADEG_DEPT_CODE_2 (22)

Source Code Comments

The second department associated with this degree.

Columns Comments for APRADEG_HONR_CODE_2 (23)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_3 (24)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_4 (25)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HONR_CODE_5 (26)

Source Code Comments

This field specifies the honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_1 (27)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_2 (28)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_3 (29)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_4 (30)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_HOND_CODE_5 (31)

Source Code Comments

This field specifies the departmental honors the constituent received with the associated degree.

Columns Comments for APRADEG_OK_FOR_NOTES_IND (32)

Source Code Comments

OK for Notes Indicator, Y indicates that this degree can be used in Class Notes.

Columns Comments for APRADEG_DISP_NOTES_IND (33)

Source Code Comments

Displayed in Notes Indicator, Y indicates that this degree was displaeyd in Class Notes.

Columns Comments for APRADEG_DISP_NOTES_DATE (34)

Source Code Comments

The date that this degree was displayed in Class Notes.

Columns Comments for APRADEG_USER (35)

Source Code Comments

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

Columns Comments for APRADEG_REVIEWED_IND (36)

Source Code Comments

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

Columns Comments for APRADEG_REVIEWED_USER (37)

Source Code Comments

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

Columns Comments for APRADEG_MAJOR_COMMENT (38)

Source Code Comments

Free form text comments about this degree.

Table GTVPARS

Schema Name GENERAL
Label GTVPARS
Server name MALDEV8_B60
Creation Date 06/11/2003 11:13:01:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GTVPARS_CODE	GTVPARS_CODE	VARCHAR2(7)	No	*
GTVPARS_DESC	GTVPARS_DESC	VARCHAR2(30)	No
GTVPARS_SCHEDULER_NUMBER	GTVPARS_SCHEDULER_NUMBER	NUMBER(2,0)	No
GTVPARS_USER_ID	GTVPARS_USER_ID	VARCHAR2(30)	No
GTVPARS_ACTIVITY_DATE	GTVPARS_ACTIVITY_DATE	DATE	No
GTVPARS_CAMP_CODE	GTVPARS_CAMP_CODE	VARCHAR2(3)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVPARS_CAMP_CODE	STVCAMP_CODE	STVCAMP

Index

Index Name	Index Type	Column Name
PK_GTVPARS	Unique	GTVPARS_CODE

Comments

Source Code Comments

Validation entries for Partition codes. Partition Codes define campus zones, which are catagories or groupings of rooms.

Columns Comments for GTVPARS_CODE (1)

Source Code Comments

Partition code for campus zones for scheduling product.

Columns Comments for GTVPARS_DESC (2)

Source Code Comments

Description of partition code for scheduling product.

Columns Comments for GTVPARS_SCHEDULER_NUMBER (3)

Source Code Comments

Numeric identifying value for partition code for scheduling product.

Columns Comments for GTVPARS_USER_ID (4)

Source Code Comments

This field identifies the user wholast updated the record

Columns Comments for GTVPARS_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for GTVPARS_CAMP_CODE (6)

Source Code Comments

Campus code associated with partition for scheduling product.

Table PEBEMPL

Schema Name PAYROLL
Label PEBEMPL
Server name MALDEV8_B60
Creation Date 07/30/2003 15:18:53:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
PEBEMPL_PIDM	PEBEMPL_PIDM	NUMBER(8,0)	No	*	*
PEBEMPL_EMPL_STATUS	PEBEMPL_EMPL_STATUS	VARCHAR2(1)	No
PEBEMPL_COAS_CODE_HOME	PEBEMPL_COAS_CODE_HOME	VARCHAR2(1)	Yes
PEBEMPL_ORGN_CODE_HOME	PEBEMPL_ORGN_CODE_HOME	VARCHAR2(6)	No		*
PEBEMPL_COAS_CODE_DIST	PEBEMPL_COAS_CODE_DIST	VARCHAR2(1)	Yes
PEBEMPL_ORGN_CODE_DIST	PEBEMPL_ORGN_CODE_DIST	VARCHAR2(6)	No		*
PEBEMPL_ECLS_CODE	PEBEMPL_ECLS_CODE	VARCHAR2(2)	No		*
PEBEMPL_LCAT_CODE	PEBEMPL_LCAT_CODE	VARCHAR2(2)	No		*
PEBEMPL_BCAT_CODE	PEBEMPL_BCAT_CODE	VARCHAR2(2)	No		*
PEBEMPL_FIRST_HIRE_DATE	PEBEMPL_FIRST_HIRE_DATE	DATE	No
PEBEMPL_CURRENT_HIRE_DATE	PEBEMPL_CURRENT_HIRE_DATE	DATE	No
PEBEMPL_ADJ_SERVICE_DATE	PEBEMPL_ADJ_SERVICE_DATE	DATE	No
PEBEMPL_SENIORITY_DATE	PEBEMPL_SENIORITY_DATE	DATE	No
PEBEMPL_LREA_CODE	PEBEMPL_LREA_CODE	VARCHAR2(2)	Yes
PEBEMPL_LOA_BEG_DATE	PEBEMPL_LOA_BEG_DATE	DATE	Yes
PEBEMPL_LOA_END_DATE	PEBEMPL_LOA_END_DATE	DATE	Yes
PEBEMPL_TREA_CODE	PEBEMPL_TREA_CODE	VARCHAR2(2)	Yes		*
PEBEMPL_TERM_DATE	PEBEMPL_TERM_DATE	DATE	Yes
PEBEMPL_I9_FORM_IND	PEBEMPL_I9_FORM_IND	VARCHAR2(1)	Yes
PEBEMPL_I9_DATE	PEBEMPL_I9_DATE	DATE	Yes
PEBEMPL_I9_EXPIRE_DATE	PEBEMPL_I9_EXPIRE_DATE	DATE	Yes
PEBEMPL_ACTIVITY_DATE	PEBEMPL_ACTIVITY_DATE	DATE	No
PEBEMPL_WKPR_CODE	PEBEMPL_WKPR_CODE	VARCHAR2(4)	Yes		*
PEBEMPL_FLSA_IND	PEBEMPL_FLSA_IND	VARCHAR2(1)	No
PEBEMPL_STGR_CODE	PEBEMPL_STGR_CODE	VARCHAR2(2)	Yes		*
PEBEMPL_DAYS_IN_CANADA	PEBEMPL_DAYS_IN_CANADA	NUMBER(3,0)	Yes
PEBEMPL_1042_RECIPIENT_CD	PEBEMPL_1042_RECIPIENT_CD	VARCHAR2(2)	Yes
PEBEMPL_INTERNAL_FT_PT_IND	PEBEMPL_INTERNAL_FT_PT_IND	VARCHAR2(1)	No
PEBEMPL_DICD_CODE	PEBEMPL_DICD_CODE	VARCHAR2(3)	Yes
PEBEMPL_EGRP_CODE	PEBEMPL_EGRP_CODE	VARCHAR2(4)	Yes
PEBEMPL_IPEDS_SOFT_MONEY_IND	PEBEMPL_IPEDS_SOFT_MONEY_IND	VARCHAR2(1)	Yes
PEBEMPL_FIRST_WORK_DATE	PEBEMPL_FIRST_WORK_DATE	DATE	Yes
PEBEMPL_LAST_WORK_DATE	PEBEMPL_LAST_WORK_DATE	DATE	Yes
PEBEMPL_CALIF_PENSION_IND	PEBEMPL_CALIF_PENSION_IND	VARCHAR2(1)	Yes
PEBEMPL_NRSI_CODE	PEBEMPL_NRSI_CODE	VARCHAR2(4)	Yes		*
PEBEMPL_SSN_LAST_NAME	PEBEMPL_SSN_LAST_NAME	VARCHAR2(20)	Yes
PEBEMPL_SSN_FIRST_NAME	PEBEMPL_SSN_FIRST_NAME	VARCHAR2(15)	Yes
PEBEMPL_SSN_MI	PEBEMPL_SSN_MI	VARCHAR2(15)	Yes
PEBEMPL_SSN_SUFFIX	PEBEMPL_SSN_SUFFIX	VARCHAR2(4)	Yes
PEBEMPL_JBLN_CODE	PEBEMPL_JBLN_CODE	VARCHAR2(6)	Yes		*
PEBEMPL_COLL_CODE	PEBEMPL_COLL_CODE	VARCHAR2(2)	Yes		*
PEBEMPL_CAMP_CODE	PEBEMPL_CAMP_CODE	VARCHAR2(3)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
PEBEMPL_BCAT_CODE	PTRBCAT_CODE	PTRBCAT
PEBEMPL_ECLS_CODE	PTRECLS_CODE	PTRECLS
PEBEMPL_JBLN_CODE	PTRJBLN_CODE	PTRJBLN
PEBEMPL_TREA_CODE	PTRTREA_CODE	PTRTREA
PEBEMPL_LCAT_CODE	PTVLCAT_CODE	PTVLCAT
PEBEMPL_NRSI_CODE	PTVNRSI_CODE	PTVNRSI
PEBEMPL_STGR_CODE	PTVSTGR_CODE	PTVSTGR
PEBEMPL_WKPR_CODE	PTRWKPR_CODE	PTRWKPR
PEBEMPL_COLL_CODE	STVCOLL_CODE	STVCOLL
PEBEMPL_CAMP_CODE	STVCAMP_CODE	STVCAMP
PEBEMPL_PIDM	POTPARM_PIDM	POTPARM

Index

Index Name	Index Type	Column Name
PEBEMPL_HOME_INDEX		PEBEMPL_ORGN_CODE_HOME
PEBEMPL_HOME_INDEX		PEBEMPL_COAS_CODE_HOME
PEBEMPL_HOME_INDEX		PEBEMPL_PIDM
PEBEMPL_KEY2_INDEX	Unique	PEBEMPL_LCAT_CODE
PEBEMPL_KEY2_INDEX	Unique	PEBEMPL_PIDM
PEBEMPL_KEY3_INDEX		PEBEMPL_ECLS_CODE
PK_PEBEMPL	Unique	PEBEMPL_PIDM

Comments

Source Code Comments

Employee Base Table

Columns Comments for PEBEMPL_PIDM (1)

Source Code Comments

PIDM: Internal System Identification Number.

Columns Comments for PEBEMPL_EMPL_STATUS (2)

Source Code Comments

EMPLOYEE STATUS: The status of the employee.

Columns Comments for PEBEMPL_COAS_CODE_HOME (3)

Source Code Comments

CHART OF ACCOUNTS CODE HOME: The home Chart of Accounts Code for the employee.

Columns Comments for PEBEMPL_ORGN_CODE_HOME (4)

Source Code Comments

HOME ORGANIZATION CODE: The home organization code of the employee.

Columns Comments for PEBEMPL_COAS_CODE_DIST (5)

Source Code Comments

CHART OF ACCOUNTS CODE DISTRIBUTION: The Chart of Accounts Code to which this emplyees labor is distributed.

Columns Comments for PEBEMPL_ORGN_CODE_DIST (6)

Source Code Comments

ORGANIZATION CODE DISTRIBUTION: The organization code used for labor distribution.

Columns Comments for PEBEMPL_ECLS_CODE (7)

Source Code Comments

EMPLOYEE CLASS CODE: The employee grouping to which the employee belongs.

Columns Comments for PEBEMPL_LCAT_CODE (8)

Source Code Comments

LEAVE CATEGORY CODE: The leave category to which the employee belongs.

Columns Comments for PEBEMPL_BCAT_CODE (9)

Source Code Comments

BENEFIT CATEGORY CODE: The benefit category to which the employee belongs.

Columns Comments for PEBEMPL_FIRST_HIRE_DATE (10)

Source Code Comments

FIRST HIRE DATE: The date the employee was first hired.

Columns Comments for PEBEMPL_CURRENT_HIRE_DATE (11)

Source Code Comments

CURRENT HIRE DATE: The employees current date of hire.

Columns Comments for PEBEMPL_ADJ_SERVICE_DATE (12)

Source Code Comments

ADJUSTED SERVICE DATE: Date used to determine years of service for leave accrual if the First Hire Date and Current Hire Date are not equal.

Columns Comments for PEBEMPL_SENIORITY_DATE (13)

Source Code Comments

SENIORITY DATE: Currently not used by system. Reserved for future use.

Columns Comments for PEBEMPL_LREA_CODE (14)

Source Code Comments

LEAVE REASON CODE: A code identifying the reason of the leave of absence for the employee.

Columns Comments for PEBEMPL_LOA_BEG_DATE (15)

Source Code Comments

LEAVE OF ABSENCE BEGIN DATE: The begin date of a leave of absence for the employee.

Columns Comments for PEBEMPL_LOA_END_DATE (16)

Source Code Comments

LEAVE OF ABSENCE END DATE: The anticipated end date for an employees leave of absence.

Columns Comments for PEBEMPL_TREA_CODE (17)

Source Code Comments

TERMINATION REASON CODE: Code used to identify the reason of termination.

Columns Comments for PEBEMPL_TERM_DATE (18)

Source Code Comments

TERMINATION DATE: Termination date of the employee.

Columns Comments for PEBEMPL_I9_FORM_IND (19)

Source Code Comments

I9 FORM INDICATOR: Indicates whether or not immigration information has been received.

Columns Comments for PEBEMPL_I9_DATE (20)

Source Code Comments

I9 DATE: The date immigration information was received.

Columns Comments for PEBEMPL_I9_EXPIRE_DATE (21)

Source Code Comments

I9 EXPIRATION DATE: The date the immigration information expires.

Columns Comments for PEBEMPL_ACTIVITY_DATE (22)

Source Code Comments

ACTIVITY DATE: Date when the record was inserted or last modified.

Columns Comments for PEBEMPL_WKPR_CODE (23)

Source Code Comments

WKPR_CODE: Work Period Code

Columns Comments for PEBEMPL_FLSA_IND (24)

Source Code Comments

FLSA INDICATOR: Used for Fair Labor Overtime compensation. (C)ash, (A)ccrual or (N)o FLSA.

Columns Comments for PEBEMPL_STGR_CODE (25)

Source Code Comments

STGR_CODE: Statistics Canada Grouping Code.

Columns Comments for PEBEMPL_DAYS_IN_CANADA (26)

Source Code Comments

DAYS IN CANADA: Number of days employee worked in Canada.

Columns Comments for PEBEMPL_1042_RECIPIENT_CD (27)

Source Code Comments

1042 RECIPIENT CODE: Identifies the type of individual who is receiving this 1042 statement.

Columns Comments for PEBEMPL_INTERNAL_FT_PT_IND (28)

Source Code Comments

Internal Part Time/Full Time Indicator, used for EEO reporting.

Columns Comments for PEBEMPL_DICD_CODE (29)

Source Code Comments

DISTRICT/DIVISION CODE: The district or division associated with an employee.

Columns Comments for PEBEMPL_EGRP_CODE (30)

Source Code Comments

EMPLOYEE GROUP CODE: An employee classification which is broken down into employee classes.

Columns Comments for PEBEMPL_IPEDS_SOFT_MONEY_IND (31)

Source Code Comments

IPEDS Soft Money Indicator.

Columns Comments for PEBEMPL_FIRST_WORK_DATE (32)

Source Code Comments

The first day that employee worked.

Columns Comments for PEBEMPL_LAST_WORK_DATE (33)

Source Code Comments

The last day that employee worked.

Columns Comments for PEBEMPL_CALIF_PENSION_IND (34)

Source Code Comments

California Pension Indicator.

Columns Comments for PEBEMPL_NRSI_CODE (35)

Source Code Comments

NRSI CODE:Non-resident Service Code.

Columns Comments for PEBEMPL_SSN_LAST_NAME (36)

Source Code Comments

Social security last name used in regulatory.

Columns Comments for PEBEMPL_SSN_FIRST_NAME (37)

Source Code Comments

Social security first name used in regulatory.

Columns Comments for PEBEMPL_SSN_MI (38)

Source Code Comments

Social security middle name used in regulatory.

Columns Comments for PEBEMPL_SSN_SUFFIX (39)

Source Code Comments

Social security name suffix used in regulatory.

Columns Comments for PEBEMPL_JBLN_CODE (40)

Source Code Comments

LOCATION CODE: The Location to which the employee belongs.

Columns Comments for PEBEMPL_COLL_CODE (41)

Source Code Comments

COLLEGE CODE: The College to which the employee belongs.

Columns Comments for PEBEMPL_CAMP_CODE (42)

Source Code Comments

CAMPUS CODE: The Campus to which the employee belongs.

Table RORCAMP

Schema Name FAISMGR
Label RORCAMP
Server name MALDEV8_B60
Creation Date 03/27/2003 14:53:10:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
RORCAMP_AIDY_CODE	RORCAMP_AIDY_CODE	VARCHAR2(4)	No	*
RORCAMP_CAMP_CODE	RORCAMP_CAMP_CODE	VARCHAR2(3)	No	*
RORCAMP_ACAD_CAL	RORCAMP_ACAD_CAL	NUMBER(1,0)	No
RORCAMP_ACTIVITY_DATE	RORCAMP_ACTIVITY_DATE	DATE	No
RORCAMP_PELL_ID	RORCAMP_PELL_ID	VARCHAR2(6)	Yes
RORCAMP_ENTITY_ID	RORCAMP_ENTITY_ID	VARCHAR2(12)	Yes
RORCAMP_EXPECT_HRS	RORCAMP_EXPECT_HRS	NUMBER(4,0)	Yes
RORCAMP_HRS_IN_YR	RORCAMP_HRS_IN_YR	NUMBER(4,0)	Yes
RORCAMP_NBR_MTHS_PAY	RORCAMP_NBR_MTHS_PAY	NUMBER(2,0)	Yes
RORCAMP_JUL_PAY	RORCAMP_JUL_PAY	VARCHAR2(1)	Yes
RORCAMP_AUG_PAY	RORCAMP_AUG_PAY	VARCHAR2(1)	Yes
RORCAMP_SEP_PAY	RORCAMP_SEP_PAY	VARCHAR2(1)	Yes
RORCAMP_OCT_PAY	RORCAMP_OCT_PAY	VARCHAR2(1)	Yes
RORCAMP_NOV_PAY	RORCAMP_NOV_PAY	VARCHAR2(1)	Yes
RORCAMP_DEC_PAY	RORCAMP_DEC_PAY	VARCHAR2(1)	Yes
RORCAMP_JAN_PAY	RORCAMP_JAN_PAY	VARCHAR2(1)	Yes
RORCAMP_FEB_PAY	RORCAMP_FEB_PAY	VARCHAR2(1)	Yes
RORCAMP_MAR_PAY	RORCAMP_MAR_PAY	VARCHAR2(1)	Yes
RORCAMP_APR_PAY	RORCAMP_APR_PAY	VARCHAR2(1)	Yes
RORCAMP_MAY_PAY	RORCAMP_MAY_PAY	VARCHAR2(1)	Yes
RORCAMP_JUN_PAY	RORCAMP_JUN_PAY	VARCHAR2(1)	Yes
RORCAMP_INST_XREF_IND	RORCAMP_INST_XREF_IND	VARCHAR2(1)	Yes
RORCAMP_PAYMENT_METHOD	RORCAMP_PAYMENT_METHOD	VARCHAR2(1)	Yes
RORCAMP_EXPECT_WKS	RORCAMP_EXPECT_WKS	NUMBER(2,0)	Yes
RORCAMP_WKS_IN_YR	RORCAMP_WKS_IN_YR	NUMBER(2,0)	Yes
RORCAMP_MAIL_LINE1_INST_FAA	RORCAMP_MAIL_LINE1_INST_FAA	VARCHAR2(35)	Yes
RORCAMP_MAIL_LINE2_INST_FAA	RORCAMP_MAIL_LINE2_INST_FAA	VARCHAR2(35)	Yes
RORCAMP_MAIL_CITY_INST_FAA	RORCAMP_MAIL_CITY_INST_FAA	VARCHAR2(25)	Yes
RORCAMP_STAT_CODE_INST_FAA	RORCAMP_STAT_CODE_INST_FAA	VARCHAR2(3)	Yes	*
RORCAMP_ZIP_INST_FAA	RORCAMP_ZIP_INST_FAA	VARCHAR2(9)	Yes
RORCAMP_FAA_EMAIL	RORCAMP_FAA_EMAIL	VARCHAR2(50)	Yes
RORCAMP_FAA_ADMIN_NAME	RORCAMP_FAA_ADMIN_NAME	VARCHAR2(30)	Yes
RORCAMP_FAA_PHONE_AREA	RORCAMP_FAA_PHONE_AREA	VARCHAR2(3)	Yes
RORCAMP_FAA_PHONE_NO	RORCAMP_FAA_PHONE_NO	VARCHAR2(7)	Yes
RORCAMP_FAA_PHONE_EXT	RORCAMP_FAA_PHONE_EXT	VARCHAR2(4)	Yes
RORCAMP_FAA_FAX_AREA	RORCAMP_FAA_FAX_AREA	VARCHAR2(3)	Yes
RORCAMP_FAA_FAX_NO	RORCAMP_FAA_FAX_NO	VARCHAR2(7)	Yes
RORCAMP_FAA_FAX_EXT	RORCAMP_FAA_FAX_EXT	VARCHAR2(4)	Yes
RORCAMP_INST_TYPE	RORCAMP_INST_TYPE	VARCHAR2(1)	Yes
RORCAMP_INST_FIN_CONTROL	RORCAMP_INST_FIN_CONTROL	VARCHAR2(1)	Yes
RORCAMP_EL_SCHOOL_CDE	RORCAMP_EL_SCHOOL_CDE	VARCHAR2(6)	Yes
RORCAMP_TITLE_IV_RET_IND	RORCAMP_TITLE_IV_RET_IND	VARCHAR2(1)	Yes
RORCAMP_TITLE_IV_ROUND_IND	RORCAMP_TITLE_IV_ROUND_IND	VARCHAR2(1)	Yes
RORCAMP_EL_BRANCH_CDE	RORCAMP_EL_BRANCH_CDE	VARCHAR2(2)	Yes
RORCAMP_PELL_FUND_CODE	RORCAMP_PELL_FUND_CODE	VARCHAR2(6)	Yes
RORCAMP_TURN_OFF_PELL_IND	RORCAMP_TURN_OFF_PELL_IND	VARCHAR2(1)	Yes
RORCAMP_COMMON_SCHOOL_ID	RORCAMP_COMMON_SCHOOL_ID	VARCHAR2(8)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RORCAMP_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RORCAMP_STAT_CODE_INST_FAA	STVSTAT_CODE	STVSTAT
RORCAMP_CAMP_CODE	STVCAMP_CODE	STVCAMP

Index

Index Name	Index Type	Column Name
RORCAMP_KEY_INDEX	Unique	RORCAMP_AIDY_CODE
RORCAMP_KEY_INDEX	Unique	RORCAMP_CAMP_CODE

Comments

Source Code Comments

Financial Aid Campus Table

Columns Comments for RORCAMP_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record.

Columns Comments for RORCAMP_CAMP_CODE (2)

Source Code Comments

CAMPUS CODE: This code identifies which campus the information is relevant to.

Columns Comments for RORCAMP_ACAD_CAL (3)

Source Code Comments

ACADEMIC CALENDAR: This field identifies which academic calendar this campus operates under.

Columns Comments for RORCAMP_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RORCAMP_PELL_ID (5)

Source Code Comments

FEDERAL PELL ID: This field identifies the federal Pell ID number associated with the particular campus code.

Columns Comments for RORCAMP_ENTITY_ID (6)

Source Code Comments

FEDERAL ENTITY ID: This is the f