PHONE_TYPE_VWL (SQL View)	Index Back
Phone Types by Employee. Phone Types by Employee. Used as prompt record in EMERGENCY_CNTCT.

PHONE_TYPE_VWL

(SQL View)

Phone Types by Employee.

Phone Types by Employee. Used as prompt record in EMERGENCY_CNTCT.

SELECT B.FIELDVALUE , B.LANGUAGE_CD , B.XLATLONGNAME FROM PS_HR_XLAT_EFF_VW A , PSXLATITEMLANG B WHERE A.FIELDNAME = 'PHONE_TYPE' AND B.FIELDNAME = A.FIELDNAME AND B.FIELDVALUE = A.FIELDVALUE AND %EffdtCheck(PSXLATITEMLANG, B, %CurrentDateIn)

Related Language Record for PHONE_TYPE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description