LM_PRI_PHONE_VW(SQL View) |
Index Back |
|---|---|
Primary Phone ViewPrimary Phone View |
| SELECT LM_PERSON_ID , LM_CM_PURP_TYPE , LM_COUNTRY_CODE , LM_PHONE , LM_PHONE_EXT FROM PS_LM_PERSON_PHONE WHERE LM_PRIMARY = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 2 | LM_CM_PURP_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Contact Method Purpose Type |
| 3 | LM_COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 4 | LM_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Phone |
| 5 | LM_PHONE_EXT | Character(6) | VARCHAR2(6) NOT NULL | Phone extension |