GM_IN_PHONE (SQL Table)	Index Back
Institution Official Phone

GM_IN_PHONE

(SQL Table)

Institution Official Phone

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 INSTID Character(5) VARCHAR2(5) NOT NULL Institution ID
Prompt Table: GM_INSTITUTION

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business Phone
CAMP=Campus Phone
CELL=Cellular Phone
DORM=Dormitory Phone
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
Prompt Table: GM_IN_PHONE_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	INSTID	Character(5)	VARCHAR2(5) NOT NULL	Institution ID Prompt Table: GM_INSTITUTION
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business Phone CAMP=Campus Phone CELL=Cellular Phone DORM=Dormitory Phone FAX=FAX HOME=Home Phone MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex Prompt Table: GM_IN_PHONE_VW