ROOM_ASSIGNMENT - Report
| Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
| PERSON_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SLRRASG |
SLRRASG_PIDM |
UNKNOWN |
| ACADEMIC_YEAR |
ACADEMIC YEAR ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_ACYR_CODE |
UNKNOWN |
| ACADEMIC_YEAR_DESC |
DESCRIPTION OF THE ACADEMIC YEAR ASSOCIATED WITH THIS RECORD. |
|
STVACYR |
STVACYR_DESC |
UNKNOWN |
| ACADEMIC_PERIOD |
IDENTIFIES THE ACADEMIC PERIOD OR TERM ASSOCIATED WITH THIS INFORMATION. |
|
SLRRASG |
SLRRASG_TERM_CODE |
UNKNOWN |
| ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
| SUB_ACADEMIC_PERIOD |
IDENTIFIES THE SUB ACADEMIC PERIOD OR PART OF TERM ASSOCIATED WITH THE INFORMATION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| SUB_ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE SUB ACADEMIC PERIOD OR SESSION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| ROOM_APPLICATION_TYPE |
|
|
SLBRMAP |
SLBRMAP_ARTP_CODE |
UNKNOWN |
| ROOM_APPLICATION_TYPE_DESC |
|
|
STVARTP |
STVARTP_DESC |
UNKNOWN |
| ROOM_APPLICATION_STATUS |
|
|
SLBRMAP |
SLBRMAP_HAPS_CODE |
UNKNOWN |
| ROOM_APPLICATION_STATUS_DESC |
DESCRIPTION FOR THE ROOM ASSIGNMENT STATUS. |
|
STVHAPS |
STVHAPS_DESC |
UNKNOWN |
| ROOM_APPLICATION_STATUS_DATE |
|
|
SLBRMAP |
SLBRMAP_HAPS_DATE |
UNKNOWN |
| ROOM_APPLICATION_DATE_ADDED |
|
|
SLBRMAP |
SLBRMAP_ADD_DATE |
UNKNOWN |
| ROOM_APPLICATION_FROM_PERIOD |
|
|
SLBRMAP |
SLBRMAP_FROM_TERM |
UNKNOWN |
| ROOM_APPLICATION_TO_PERIOD |
|
|
SLBRMAP |
SLBRMAP_TO_TERM |
UNKNOWN |
| PREFERRED_BUILDING |
|
|
SLBRMAP |
SLBRMAP_PREFERRED_BUILDING |
UNKNOWN |
| PREFERRED_BUILDING_DESC |
|
|
STVBLDG |
STVBLDG_DESC |
UNKNOWN |
| PREFERRED_CATEGORY |
|
|
SLBRMAP |
SLBRMAP_PREFERED_BCAT_CODE |
UNKNOWN |
| PREFERRED_CATEGORY_DESC |
|
|
SLRBCAT |
SLRBCAT_DESC |
UNKNOWN |
| PREFERRED_ROOM |
|
|
SLBRMAP |
SLBRMAP_PREFERRED_ROOM |
UNKNOWN |
| PREFERRED_CAMPUS |
|
|
SLBRMAP |
SLBRMAP_PREFERRED_CAMP_CODE |
UNKNOWN |
| PREFERRED_CAMPUS_DESC |
|
|
STVCAMP |
STVCAMP_DESC |
UNKNOWN |
| BUILDING |
BUILDING OF THE VENDOR. |
|
SLRRASG |
SLRRASG_BLDG_CODE |
UNKNOWN |
| BUILDING_DESC |
SPECIFIES THE BUILDING ASSOCIATED WITH THE BUILDING CODE. |
|
STVBLDG |
STVBLDG_DESC |
UNKNOWN |
| BUILDING_CAPACITY |
SPECIFIES THE BUILDING ASSOCIATED WITH THE BUILDING CODE. |
|
STVBLDG |
STVBLDG_DESC |
UNKNOWN |
| BUILDING_PHONE_AREA |
|
|
SLBBLDG |
NOT AVAILABLE |
UNKNOWN |
| BUILDING_PHONE_NUMBER |
PHONE NUMBER FOR THE BUILDING. |
|
SLBBLDG |
SLBBLDG_PHONE_NUMBER |
UNKNOWN |
| BUILDING_PHONE_EXT |
PHONE NUMBER EXTENSION FOR THE BUILDING CONTACT OFFICE. |
|
SLBBLDG |
SLBBLDG_PHONE_EXTENSION |
UNKNOWN |
| BUILDING_PHONE_NUM_COMBINED |
|
|
SLBBLDG |
SLBBLDG_PHONE_NUMBER COMBO |
UNKNOWN |
| ROOM_NUMBER |
|
|
SLBRDEF |
SLBRDEF_ROOM_NUMBER |
UNKNOWN |
| ROOM_TYPE |
|
|
SLBRDEF |
SLBRDEF_ROOM_TYPE |
UNKNOWN |
| ROOM_TYPE_DESC |
"TYPE OF ROOM DEFINED THAT WILL CONTROL SOME OF THE ASSIGNMENTS FOR THE ROOM. VALUES INCLUDE D FOR DORMITORY OR HOUSING ROOM AND C FOR CLASSROOM OR O FOR OVERALL." |
|
SLBRDEF |
SLBRDEF_ROOM_TYPE |
UNKNOWN |
| ROOM_CAPACITY |
|
|
SLBRDEF |
SLBRDEF_MAXIMUM_CAPACITY |
UNKNOWN |
| ROOM_PHONE_AREA |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| ROOM_PHONE_NUMBER |
|
|
SLBRDEF |
SLBRDEF_PHONE_NUMBER |
UNKNOWN |
| ROOM_PHONE_EXT |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| ROOM_PHONE_NUM_COMBINED |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| ROOM_RATE |
|
|
SLRRASG |
SLRRASG_RRCD_CODE |
UNKNOWN |
| ROOM_RATE_DESC |
DESCRIPTION FOR THE ROOM RATE CODE. |
|
STVRRCD |
STVRRCD_DESC |
UNKNOWN |
| ROOM_STATUS |
|
|
SLRRASG |
SLRRASG_ASCD_CODE |
UNKNOWN |
| ROOM_STATUS_DESC |
|
|
STVASCD |
STVASCD_DESC |
UNKNOWN |
| ROOM_STATUS_DATE |
|
|
SLRRASG |
SLRRASG_ASCD_DATE |
UNKNOWN |
| ROOM_RATE_TIME |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| ROOM_START_DATE |
|
|
SLRRASG |
SLRRASG_BEGIN_DATE |
UNKNOWN |
| ROOM_END_DATE |
|
|
SLRRASG |
SLRRASG_END_DATE |
UNKNOWN |
| ROOM_TOTAL_DAYS |
|
|
SLRRASG |
SLRRASG_TOTAL_DAYS |
UNKNOWN |
| ROOM_TOTAL_MONTHS |
|
|
SLRRASG |
SLRRASG_TOTAL_MONTHS |
UNKNOWN |
| ROOM_TOTAL_PERIODS |
|
|
SLRRASG |
SLRRASG_TOTAL_TERMS |
UNKNOWN |
| ROOM_CHARGES_IND |
|
|
SLRRASG |
SLRRASG_AR_IND |
UNKNOWN |
| ROOM_OVERLOAD_IND |
|
|
SLRRASG |
SLRRASG_OVERLOAD_IND |
UNKNOWN |
| ROOM_ROLL_IND |
|
|
SLRRASG |
SLRRASG_ROLL_IND |
UNKNOWN |
| ROOM_OVERRIDE_IND |
|
|
SLRRASG |
SLRRASG_OVERRIDE_ERROR |
UNKNOWN |
| ROOM_ASSESSMENT_IND |
|
|
SLBRMAP |
NOT AVAILABLE |
UNKNOWN |