EMPLIDDefault Value: NEW
Prompt Table: PERSON
SCC_PERPHN_VW(SQL View) |
Index Back |
|---|---|
Person Phone ViewPerson Phone View used by personal data view SCC_PERDATA_VW. |
| SELECT P.EMPLID ,%subrec(PHONE_SBR, F) ,F.EXTENSION FROM PS_PERSON P , PS_PERSONAL_PHONE F ,PS_PERSON_DT_SETUP S WHERE F.EMPLID = P.EMPLID AND S.PHONE_FLG = 'Y' AND F.PHONE_TYPE = ( SELECT MAX(FT.PHONE_TYPE) FROM PS_PERSONAL_PHONE FT WHERE FT.EMPLID = F.EMPLID AND FT.PREF_PHONE_FLAG = 'Y') UNION SELECT PX.EMPLID ,' ' ,' ' ,' ' FROM PS_PERSON PX WHERE NOT EXISTS ( SELECT 'X' FROM PS_PERSONAL_PHONE FX ,PS_PERSON_DT_SETUP SX WHERE FX.EMPLID = PX.EMPLID AND SX.PHONE_FLG = 'Y' AND FX.PHONE_TYPE = ( SELECT MAX(FXT.PHONE_TYPE) FROM PS_PERSONAL_PHONE FXT WHERE FXT.EMPLID = FX.EMPLID AND FXT.PREF_PHONE_FLAG = 'Y' )) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PERSON |
| 2 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 3 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 4 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone number extension |