ADDRESS_BY_RULE - Report
| Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
| ADDRESS_RULE |
ODS DISPLAY RULE USED TO DETERMINE ADDRESSES IN ADDRESS_BY_RULE VIEW. |
|
MSKFUNC |
F_ADDRESS_ROWID |
UNKNOWN |
| ENTITY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SPRIDEN |
SPRIDEN_PIDM |
UNKNOWN |
| ADDRESS_NUMBER |
SEQUENCE OF THE ADDRESSES STORED FOR THIS TYPE OF ADDRESS. |
|
SPRADDR |
SPRADDR_ADDR_SEQNO |
UNKNOWN |
| STREET_LINE1 |
FIRST LINE OF THE PERSON'S ADDRESS. |
|
SPRADDR |
SPRADDR_STREET_LINE1 |
UNKNOWN |
| STREET_LINE2 |
SECOND LINE OF THE PERSON'S ADDRESS. |
|
SPRADDR |
SPRADDR_STREET_LINE2 |
UNKNOWN |
| STREET_LINE3 |
THIRD LINE OF THE PERSON'S ADDRESS. |
|
SPRADDR |
SPRADDR_STREET_LINE3 |
UNKNOWN |
| STREET_LINE4 |
FOURTH LINE OF THE PERSON'S ADDRESS. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| CITY |
CITY IN THE ADDRESS FOR A PERSON OR ENTITY. |
|
SPRADDR |
SPRADDR_CITY |
UNKNOWN |
| COUNTY |
COUNTY CODE FOR THIS ADDRESS. |
|
SPRADDR |
SPRADDR_CNTY_CODE |
UNKNOWN |
| COUNTY_DESC |
NAME OF THE COUNTY FROM THE ADDRESS. |
|
STVCNTY |
STVCNTY_DESC |
UNKNOWN |
| STATE_PROVINCE |
STATE/PROVINCE CODE OF THE ADDRESS. |
|
SPRADDR |
SPRADDR_STAT_CODE |
UNKNOWN |
| STATE_PROVINCE_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S PREFERRED ADDRESS STATE/PROVINCE CODE. |
|
SPRADDR |
STVSTAT_DESC |
UNKNOWN |
| EDI_EQUIVALENT |
STATE EQUIVALENT CODE EDI WILL USE FOR ELECTRONIC TRANSFER OF INFORMATION. |
|
STVNATN |
STVNATN_EDI_EQUIV |
UNKNOWN |
| FEDERAL_REPORTING_CODE |
FEDERAL CODE FOR REPORTING STATE OR PROVINCE INFORMATION. |
|
STVSTAT |
STVSTAT_IPEDS_CDE |
UNKNOWN |
| POSTAL_CODE |
ADDRESS POST CODE OR ZIP CODE. |
|
SPRADDR |
SPRADDR_ZIP |
UNKNOWN |
| NATION |
CODE WHICH IDENTIFIES A PARTICULAR COUNTRY. |
|
SPRADDR |
SPRADDR_NATN_CODE |
UNKNOWN |
| NATION_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S PREFERRED ADDRESS NATION/COUNTRY CODE. |
|
STVNATH |
STVNATN_NATION |
UNKNOWN |
| NATION_ISO_CODE |
THREE CHARACTER INTERNATIONAL STANDARDS ORGANIZATION (ISO) CODE ASSOCIATED WITH THE NATION CODE. |
|
STVNATH |
STVNATN_SCOD_CODE_ISO |
UNKNOWN |
| NATION_EDI_EQUIVALENT |
EDI/SPEEDE COUNTRY CODE THAT EQUATES TO THE NATION CODE OF THE PERSON. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| ADDRESS_TYPE |
INSTITUTIONAL DEFINED ADDRESS TYPE USED FOR SELECTION. |
|
SPRADDR |
SPRADDR_ATYP_CODE |
UNKNOWN |
| ADDRESS_TYPE_DESC |
INSTITUTION DESCRIPTION ASSOCIATED WITH THE ADDRESS TYPE. |
|
STVATYP |
STVATYP_DESC |
UNKNOWN |
| DELIVERY_POINT |
DELIVERY POINT INFORMATION FOR ADDRESS |
|
SPRADDR |
SPRADDR_DELIVERY_POINT |
UNKNOWN |
| CORRECTION_DIGIT |
CORRECTION DIGIT INFORMATION FOR THE POSTAL SERVICE. |
|
SPRADDR |
SPRADDR_CORRECTION_DIGIT |
UNKNOWN |
| CARRIER_ROUTE |
CARRIER ROUTE INFORMATION FOR THE ADDRESS |
|
SPRADDR |
SPRADDR_CARRIER_ROUTE |
UNKNOWN |
| PREFERRED_ADDRESS_IND |
THIS FIELD STORES A Y OR N TO INDICATE IF THIS IS THE ENTITY'S PREFERRED ADDRESS. |
|
FUNCTION |
F_PREFERRED_ADDRESS_IND |
UNKNOWN |
| ENRL_PLANNING_SERVICE |
EPS MARKETING CODE BASED ON THE STUDENT'S ZIP CODE. USED TO PROVIDE A STANDARD GEOGRAPHIC REGION CODE FOR USE IN PLANNING AND RESEARCH. (CSS FORMATS ONLY) |
|
FUNCTION |
F_EPSCCODE |
UNKNOWN |
| ENRL_PLANNING_SERVICE_DESC |
DESCRIPTION ASSOCIATED WITH THE EPS CODE. |
|
STVEPSC |
STVEPSC_DESC |
UNKNOWN |
| GEOGRAPHIC_REGION_COUNT |
NUMBER OF GEOGRAPHIC REGION CODES ASSOCIATED WITH THE PERSON'S ADDRESS RECORDS. |
|
FUNCTION |
F_COUNT_GEOGRAPHIC_REGIONS |
UNKNOWN |