RS_WRKR_PHONE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: RS_WORKER_TBL
2	SEQUENCE_NBR_6	Number(6,0)	INTEGER NOT NULL	Sequence Default Value: 1
3	RS_PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	SRS Phone type is used to identify the type of phone number when capturing the worker's phone numbers. ALT=Alternate BUSN=Business HOME=Home MESG=Voicemail MOB=Mobile OTHR=Other PAGE=Pager WORK=Work Site
4	RS_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Phone number.
5	RS_PH_WKDAY	Character(1)	VARCHAR2(1) NOT NULL	This field will be used to indicate whether the worker's phone number is valid during weekdays. Y/N Table Edit Default Value: N
6	RS_PH_WKDAY_EVE	Character(1)	VARCHAR2(1) NOT NULL	This field will be used to indicate whether the worker's phone number is valid weekday evenings. Y/N Table Edit Default Value: N
7	RS_PH_WKEND	Character(1)	VARCHAR2(1) NOT NULL	Phone Weekends Y/N Table Edit Default Value: N
8	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
9	HOME_NUM	Character(20)	VARCHAR2(20) NOT NULL	Field to hold the Home Phone number value for a Resource.
10	MOBILE_NUM	Character(20)	VARCHAR2(20) NOT NULL	Field to hold the Mobile number value for a Resource.