ORGANIZATION_CONTACT - Report
| Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
| ENTITY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
AORCONT |
AORCONT_PIDM |
UNKNOWN |
| PRIMARY_CONTACT_IND |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| CONTACT_UID |
SYSTEM INTERNALLY GENERATED NUMBER TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
AORCONT |
AORCONT_CONTACT_PIDM |
UNKNOWN |
| CONTACT_LAST_NAME |
|
|
AORCONT/AOBORGN |
AORCONT_LAST_NAME |
UNKNOWN |
| CONTACT_FIRST_NAME |
|
|
AORCONT/AOBORGN |
AORCONT_FIRST_NAME |
UNKNOWN |
| CONTACT_MIDDLE_INITIAL |
|
|
AORCONT/AOBORGN |
AORCONT_MI/AOBORGN_MI_CONTACT |
UNKNOWN |
| CONTACT_NAME_PREFIX |
|
|
AORCONT/AOBORGN |
AORCONT_NAME_PREFIX |
UNKNOWN |
| CONTACT_NAME_SUFFIX |
|
|
AORCONT/AOBORGN |
AORCONT_NAME_SUFFIX |
UNKNOWN |
| CONTACT_TYPE |
THIS FIELD DEFINES THE TYPE OF CONTACT BETWEEN THE INSTITUTION AND PERSON. |
|
AORCONT |
AORCONT_OCON_CODE |
UNKNOWN |
| CONTACT_TYPE_DESC |
THIS FIELD DEFINES THE TYPE OF CONTACT DESCRIPTION BETWEEN THE INSTITUTION AND PERSON. |
|
ATVOCON |
ATVOCON_DESC |
UNKNOWN |
| JOB_CATEGORY |
|
|
AOBORGN |
AOBORGN_JOBC_CODE |
UNKNOWN |
| JOB_CATEGORY |
|
|
AORCONT |
AORCONT_JOBC_CODE |
UNKNOWN |
| JOB_CATEGORY_DESC |
|
|
ATVJOBC |
ATVJOBC_DESC |
UNKNOWN |
| JOB_TITLE |
|
|
AOBORGN |
AORCONT_TITLE |
UNKNOWN |
| JOB_TITLE |
|
|
AORCONT |
AORCONT_TITLE |
UNKNOWN |
| ADDRESS_TYPE |
INSTITUTIONAL DEFINED ADDRESS TYPE USED FOR SELECTION. |
|
AORCONT |
AORCONT_ATYP_CODE |
UNKNOWN |
| ADDRESS_TYPE_DESC |
INSTITUTION DESCRIPTION ASSOCIATED WITH THE ADDRESS TYPE. |
|
STVATYP |
STVATYP_DESC |
UNKNOWN |
| STREET_LINE1 |
FIRST LINE OF THE PERSON'S ADDRESS. |
|
AORCONT |
AORCONT_ADDR_LINE1 |
UNKNOWN |
| STREET_LINE2 |
SECOND LINE OF THE PERSON'S ADDRESS. |
|
AORCONT |
AORCONT_ADDR_LINE2 |
UNKNOWN |
| STREET_LINE3 |
THIRD LINE OF THE PERSON'S ADDRESS. |
|
AORCONT |
AORCONT_ADDR_LINE3 |
UNKNOWN |
| STREET_LINE4 |
FOURTH LINE OF THE PERSON'S ADDRESS. |
|
AORCONT |
AORCONT_ADDR_LINE4 |
UNKNOWN |
| CITY |
CITY IN THE ADDRESS FOR A PERSON OR ENTITY. |
|
AORCONT |
AORCONT_ADDR_CITY |
UNKNOWN |
| COUNTY |
COUNTY CODE FOR THIS ADDRESS. |
|
AORCONT |
AORCONT_CNTY_CODE_ADDR |
UNKNOWN |
| COUNTY_DESC |
NAME OF THE COUNTY FROM THE ADDRESS. |
|
STVCNTY |
STVCNTY_DESC |
UNKNOWN |
| STATE_PROVINCE |
STATE/PROVINCE CODE OF THE ADDRESS. |
|
AORCONT |
AORCONT_STAT_CODE_ADDR |
UNKNOWN |
| STATE_PROVINCE_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S PREFERRED ADDRESS STATE/PROVINCE CODE. |
|
STVSTAT |
STVSTAT_DESC |
UNKNOWN |
| POSTAL_CODE |
ADDRESS POST CODE OR ZIP CODE. |
|
AORCONT |
AORCONT_ZIPC_CODE_ADDR |
UNKNOWN |
| NATION |
CODE WHICH IDENTIFIES A PARTICULAR COUNTRY. |
|
AORCONT |
AORCONT_NATN_CODE_ADDR |
UNKNOWN |
| NATION_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S PREFERRED ADDRESS NATION/COUNTRY CODE. |
|
STVNATN |
STVNATN_NATION |
UNKNOWN |
| DELIVERY_POINT |
DELIVERY POINT INFORMATION FOR ADDRESS |
|
AORCONT |
AORCONT_DELIVERY_POINT |
UNKNOWN |
| CORRECTION_DIGIT |
CORRECTION DIGIT INFORMATION FOR THE POSTAL SERVICE. |
|
AORCONT |
AORCONT_CORRECTION_DIGIT |
UNKNOWN |
| CARRIER_ROUTE |
CARRIER ROUTE INFORMATION FOR THE ADDRESS |
|
AORCONT |
AORCONT_CARRIER_ROUTE |
UNKNOWN |
| GEOGRAPHIC_REGION_COUNT |
NUMBER OF GEOGRAPHIC REGION CODES ASSOCIATED WITH THE PERSON'S ADDRESS RECORDS. |
|
FUNCTION |
F_COUNT_GEOGRAPHIC_REGIONS |
UNKNOWN |
| ADDRESS_COUNT |
NUMBER OF ADDRESSES RECORDS FOR THIS PERSON OR ENTITY. |
|
FUNCTION |
F_COUNT_ADDRESSES |
UNKNOWN |
| PHONE_NUMBER_COMBINED |
ALL RECORDED PIECES OF THE TELEPHONE NUMBER COMBINED IN A SINGLE FIELD. INTERNATIONAL CODE, AREA CODE, NUMBER, EXTENSION. |
|
SUBSTR |
PHONE_NUMBER_COMBINED |
UNKNOWN |
| PHONE_AREA |
AREA CODE OF THE REFERENCE. |
|
AORCONT |
AORCONT_PHONE_AREA |
UNKNOWN |
| PHONE_NUMBER |
TELEPHONE NUMBER. |
|
AORCONT |
AORCONT_PHONE_NUMBER |
UNKNOWN |
| PHONE_EXT |
TELEPHONE NUMBER EXTENSION. |
|
AORCONT |
AORCONT_PHONE_EXT |
UNKNOWN |
| PHONE_UNLIST_IND |
SPECIFIES IF THE PREFERRED PHONE NUMBER IS TO BE UNLISTED OR NOT. |
|
SPRTELE |
SPRTELE_UNLIST_IND |
UNKNOWN |
| PHONE_TYPE |
TELEPHONE TYPE CODE ASSOCIATED WITH THE PERSON'S PREFERRED TELEPHONE NUMBER. |
|
SPRTELE |
SPRTELE_TELE_CODE |
UNKNOWN |
| PHONE_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S PREFERRED PHONE TYPE. |
|
STVTELE |
STVTELE_DESC |
UNKNOWN |
| PHONE_COUNT |
COUNT OF TELEPHONE NUMBER RECORDS FOR THIS PERSON OR ENTITY. |
|
FUNCTION |
F_COUNT_TELEPHONES |
UNKNOWN |
| EMAIL_ADDRESS |
EMAIL ADDRESS TYPE OF THE PERSON. |
|
GOREMAL |
GOREMAL_EMAIL_ADDRESS |
UNKNOWN |
| EMAIL_TYPE |
EMAIL TYPE CODE OF THE PERSON'S EMAIL ADDRESS. |
|
GOREMAL |
GOREMAL_EMAL_CODE |
UNKNOWN |
| EMAIL_DESC |
DESCRIPTION ASSOCIATED WITH THE PERSON'S EMAIL TYPE CODE. |
|
GOREMAL |
GOREMAL_DESC |
UNKNOWN |