Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse XFINITY INFORMATION Table


View exposing Xfinity-related service or entitlement information associated with institutional asset or service administration.


Field Name

Description

Data Type

Length

DW_ADDRESS_CATEGORY

Dw address category associated with the record.

VARCHAR2

3

DW_ADDRESS_CATEGORY_DESC

Dw address category desc associated with the record.

VARCHAR2

100

DW_XFINITY_FLAG

Indicator identifying whether dw xfinity (Y/N).

VARCHAR2

2

FULL_NAME

Full name associated with the person or request.

VARCHAR2

102

IS_ELIGIBLE_FOR_CAMPUS_XF

Indicator identifying whether eligible for campus xf (Y/N).

VARCHAR2

1

KRB_NAME_UPPERCASE

Krb name uppercase associated with the record.

VARCHAR2

93

MITSIS_PIDM

Mitsis pidm associated with the record.

VARCHAR2

8

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

REG_TERM

Reg term associated with the record.

VARCHAR2

6

REG_TYPE

Reg type associated with the record.

VARCHAR2

50

TERM_ADDR_CATEGORY

Term addr category associated with the record.

VARCHAR2

3

TERM_CITY

Term city associated with the record.

VARCHAR2

80

TERM_STATE

Term state associated with the record.

VARCHAR2

4

TERM_STREET1

Term street1 associated with the record.

VARCHAR2

60

XFINITY_REASON

Xfinity reason associated with the record.

VARCHAR2

283