SIS TERM ADDRESS CATEGORY Table
View exposing term-specific address category reference data including address type codes and term applicability used in student records address tracking and enrollment reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
LIVING_GROUP_TYPE |
Living group type associated with the record. |
VARCHAR2 |
1 |
LIVING_GROUP_TYPE_DESC |
Description of living group type. |
VARCHAR2 |
10 |
TERM_ADDRESS_CATEGORY |
Term address category associated with the record. |
VARCHAR2 |
30 |
TERM_ADDRESS_CATEGORY_CODE |
Term address category code associated with the record. |
VARCHAR2 |
3 |
VALID_FROM_DATE |
Date associated with valid from. |
DATE |
|
VALID_THRU_DATE |
Date associated with valid thru. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |