TELEPHONE - 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. |
|
SPRIDEN |
SPRIDEN_PIDM |
UNKNOWN |
PHONE_TYPE |
TELEPHONE TYPE CODE ASSOCIATED WITH THE PERSON'S PREFERRED TELEPHONE NUMBER. |
|
SPRTELE |
SPRTELE_TELE_CODE |
UNKNOWN |
PHONE_TYPE_DESC |
DESCRIPTION FOR THE TYPE OF TELEPHONE RECORD. |
|
STVTELE |
STVTELE_DESC |
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_INTL_ACCESS |
FREE FORMAT INTERNATIONAL ACCESS CODE FOR TELEPHONE NUMBER INCLUDING COUNTRY AND CITY CODE. |
|
SPRTELE |
SPRTELE_INTL_ACCESS |
UNKNOWN |
PHONE_AREA |
AREA CODE OF THE REFERENCE. |
|
SPRTELE |
SPRTELE_PHONE_AREA |
UNKNOWN |
PHONE_NUMBER |
TELEPHONE NUMBER. |
|
SPRTELE |
SPRTELE_PHONE_NUMBER |
UNKNOWN |
PHONE_EXT |
TELEPHONE NUMBER EXTENSION. |
|
SPRTELE |
SPRTELE_PHONE_EXT |
UNKNOWN |
PHONE_UNLIST_IND |
SPECIFIES IF THE PREFERRED PHONE NUMBER IS TO BE UNLISTED OR NOT. |
|
SPRTELE |
SPRTLEL_UNLIST_IND |
UNKNOWN |
ADDRESS_TYPE |
INSTITUTIONAL DEFINED ADDRESS TYPE USED FOR SELECTION. |
|
SPRTELE |
SPRTELE_ATYP_CODE |
UNKNOWN |
ADDRESS_TYPE_DESC |
INSTITUTION DESCRIPTION ASSOCIATED WITH THE ADDRESS TYPE. |
|
STVATYP |
STVATYP_DESC |
UNKNOWN |
ADDRESS_NUMBER |
SEQUENCE OF THE ADDRESSES STORED FOR THIS TYPE OF ADDRESS. |
|
SPRTELE |
SPRTELE_ADDR_SEQNO |
UNKNOWN |
PHONE_PRIMARY_IND |
INDICATES THIS IS THE PRIMARY TELEPHONE NUMBER GIVEN TO THE INSTITUTION. |
|
SPRTELE |
SPRTELE_PRIMARY_IND |
UNKNOWN |
PHONE_SEQ_NUMBER |
TELEPHONE NUMBER. |
|
SPRTELE |
SPRTELE_? |
UNKNOWN |