Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
Academic Period
|
Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.
|
VARCHAR2(63)
|
SLRRASG STVTERM
|
SLRRASG_TERM_CODE STVTERM_CODE
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_YEAR
|
Academic Year
|
Academic year associated with the academic period on this record.
|
VARCHAR2(4)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
BUILDING
|
Building
|
Building code for the room assignment.
|
VARCHAR2(63)
|
SLRRASG
|
SLRRASG_BLDG_CODE
|
BUILDING_CAPACITY
|
Building Capacity
|
Maximum number of persons that may be in the building at time.
|
NUMBER
|
SLBBLDG
|
SLBBLDG_MAXIMUM_CAPACITY
|
BUILDING_DESC
|
Building Description
|
Name of the building.
|
VARCHAR2(255)
|
STVBLDG
|
STVBLDG_DESC
|
BUILDING_PHONE_AREA
|
Building Phone Area
|
Area code for the phone number for the building.
|
VARCHAR2(63)
|
SLBBLDG
|
SLBBLDG_PHONE_AREA
|
BUILDING_PHONE_EXT
|
Building Phone Extension
|
Phone extension for the building.
|
VARCHAR2(63)
|
SLBBLDG
|
SLBBLDG_PHONE_EXTENSION
|
BUILDING_PHONE_NUMBER
|
Building Phone Number
|
Building phone number for current room assignment.
|
VARCHAR2(63)
|
SLBBLDG
|
SLBBLDG_PHONE_NUMBER
|
BUILDING_PHONE_NUM_COMBINED
|
Building Phone Number Combined
|
Complete telephone number for the building which combines the area code, phone number, and extension recorded for the building.
|
VARCHAR2(63)
|
CALCULATION
|
SLBBLDG_PHONE_AREA||SLBBLDG_PHONE_NUMBER||SLBBLDG_PHONE_EXTENSION
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SLRRASG
|
SLRRASG_PIDM
|
PREFERRED_BUILDING
|
Preferred Building
|
Preferred housing building code.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_PREFERED_BUILDING
|
PREFERRED_BUILDING_DESC
|
Preferred Building Description
|
Building description associated with the building code.
|
VARCHAR2(255)
|
STVBLDG
|
STVBLDG_DESC
|
PREFERRED_CAMPUS
|
Preferred Campus
|
Applicant's preferred campus for housing room assignment.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_PREFERED_CAMP_CODE
|
PREFERRED_CAMPUS_DESC
|
Preferred Campus Description
|
Institution campus description.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
PREFERRED_CATEGORY
|
Preferred Category
|
Applicant's preferred category for housing.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_PREFERED_BCAT_CODE
|
PREFERRED_CATEGORY_DESC
|
Preferred Category Description
|
Category code description.
|
VARCHAR2(255)
|
SLRBCAT
|
SLRBCAT_DESC
|
PREFERRED_ROOM
|
Preferred Room
|
Applicant's preferred room for housing.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_PREFERED_ROOM
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
ROOM_APPLICATION_DATE_ADDED
|
Room Application Date Added
|
Date the room application was added to the system.
|
DATE
|
SLBRMAP
|
SLBRMAP_ADD_DATE
|
ROOM_APPLICATION_FROM_PERIOD
|
Room Application From Period
|
Beginning academic period for this room application.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_FROM_TERM
|
ROOM_APPLICATION_STATUS
|
Room Application Status
|
Current room application status for this applicant.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_HAPS_CODE
|
ROOM_APPLICATION_STATUS_DATE
|
Room Application Status Date
|
Date the room application status was last updated.
|
DATE
|
SLBRMAP
|
SLBRMAP_HAPS_DATE
|
ROOM_APPLICATION_STATUS_DESC
|
Room Application Status Description
|
Current room application status description.
|
VARCHAR2(255)
|
STVHAPS
|
STVHAPS_DESC
|
ROOM_APPLICATION_TO_PERIOD
|
Room Application To Period
|
End academic period for this room application.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_TO_TERM
|
ROOM_APPLICATION_TYPE
|
Room Application Type
|
Type of room requested in this application and whether an associated meal plan is requested.
|
VARCHAR2(63)
|
SLBRMAP
|
SLBRMAP_ARTP_CODE
|
ROOM_APPLICATION_TYPE_DESC
|
Room Application Type Description
|
Requested type of room and or meal plan description.
|
VARCHAR2(255)
|
STVARTP
|
STVARTP_DESC
|
ROOM_ASSESSMENT_IND
|
Room Assessment Indicator
|
Indicates whether charges must be processed for the room assignment.
|
VARCHAR2(1)
|
SLRRASG
|
SLRRASG_ASSESS_NEEDED
|
ROOM_CAPACITY
|
Room Capacity
|
Identifies the current room capacity.
|
NUMBER
|
SLBRDEF
|
SLBRDEF_MAXIMUM_CAPACITY
|
ROOM_CHARGES_IND
|
Room Charges Indicator
|
Indicates whether room charges have been processed to the accounts receivable account.
|
VARCHAR2(1)
|
SLRRASG
|
SLRRASG_AR_IND
|
ROOM_END_DATE
|
Room End Date
|
End date for current room assignment.
|
DATE
|
SLRRASG
|
SLRRASG_END_DATE
|
ROOM_NUMBER
|
Room Number
|
Current room number assigned.
|
VARCHAR2(10)
|
SLBRDEF
|
SLBRDEF_ROOM_NUMBER
|
ROOM_OVERLOAD_IND
|
Room Overload Indicator
|
Indicates whether an overload condition exists based on the current assignments to this room.
|
VARCHAR2(1)
|
SLRRASG
|
SLRRASG_OVERLOAD_IND
|
ROOM_OVERRIDE_IND
|
Room Override Indicator
|
Indicates whether an overload condition exists based on the current assignments to this room.
|
VARCHAR2(1)
|
SLRRASG
|
SLRRASG_OVERRIDE_ERROR
|
ROOM_PHONE_AREA
|
Room Phone Area
|
Telephone area code for this room.
|
VARCHAR2(63)
|
SLBRDEF
|
SLBRDEF_PHONE_AREA
|
ROOM_PHONE_EXT
|
Room Phone Extension
|
Telephone extension number for this room.
|
VARCHAR2(63)
|
SLBRDEF
|
SLBRDEF_PHONE_EXTENSION
|
ROOM_PHONE_NUMBER
|
Room Phone Number
|
Telephone number for this room.
|
VARCHAR2(63)
|
SLBRDEF
|
SLBRDEF_PHONE_NUMBER
|
ROOM_PHONE_NUM_COMBINED
|
Room Phone Number Combined
|
Combined area code, phone number, and extension of the room.
|
VARCHAR2(63)
|
CALCULATION
|
SLBRDEF_PHONE_AREA||SLBRDEF_PHONE_NUMBER||SLBRDEF_PHONE_EXTENSION
|
ROOM_RATE
|
Room Rate
|
Identifies the rate code for current room assignment.
|
VARCHAR2(63)
|
SLRRASG
|
SLRRASG_RRCD_CODE
|
ROOM_RATE_DESC
|
Room Rate Description
|
Room rate code description.
|
VARCHAR2(255)
|
STVRRCD
|
STVRRCD_DESC
|
ROOM_RATE_TIME
|
Room Rate Time
|
Describes whether the time is monthly, daily or academic period basis for the room rate charges.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(STVRRCD_MONTHLY_IND,'Y','MONTHLY',DECODE(STVRRCD_DAILY_IND,'Y','DAILY','TERMLY'))
|
ROOM_ROLL_IND
|
Room Roll Indicator
|
Controls whether the current room assignment can be rolled forward to the next academic period through automated processing.
|
VARCHAR2(1)
|
SLRRASG
|
SLRRASG_ROLL_IND
|
ROOM_START_DATE
|
Room Start Date
|
Start date for current room assignment.
|
DATE
|
SLRRASG
|
SLRRASG_BEGIN_DATE
|
ROOM_STATUS
|
Room Status
|
Identifies current room assignment status. For example, active or inactive, etc.
|
VARCHAR2(63)
|
SLRRASG
|
SLRRASG_ASCD_CODE
|
ROOM_STATUS_DATE
|
Room Status Date
|
Date the room assignment status was last updated.
|
DATE
|
SLRRASG
|
SLRRASG_ASCD_DATE
|
ROOM_STATUS_DESC
|
Room Status Description
|
Current room assignment status description.
|
VARCHAR2(255)
|
STVASCD
|
STVASCD_DESC
|
ROOM_TOTAL_DAYS
|
Room Total Days
|
Total number of days in the current room assignment.
|
NUMBER
|
SLRRASG
|
SLRRASG_TOTAL_DAYS
|
ROOM_TOTAL_MONTHS
|
Room Total Months
|
Total number of months in the current room assignment.
|
NUMBER
|
SLRRASG
|
SLRRASG_TOTAL_MONTHS
|
ROOM_TOTAL_PERIODS
|
Room Total Periods
|
Total number of academic periods in the current room assignment.
|
NUMBER
|
SLRRASG
|
SLRRASG_TOTAL_TERMS
|
ROOM_TYPE
|
Room Type
|
Identifies the current type of room assigned.
|
VARCHAR2(63)
|
SLBRDEF
|
SLBRDEF_ROOM_TYPE
|
ROOM_TYPE_DESC
|
Room Type Description
|
Current room type description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(SLBRDEF_ROOM_TYPE,'D','DORM','C','CLASS','OTHER')
|
SUB_ACADEMIC_PERIOD
|
Sub Academic Period
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
NA
|
NA
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub Academic Period Description
|
Sub academic period description.
|
VARCHAR2(255)
|
NA
|
NA
|