HRCD_SETUP_CNTC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRCD_CNTCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field contains the Contact Type that will be displayed in the Company Directory. EMOT=Other Email EMPE=Personal Email IMGT=Instant Msg GTALK IMMS=Instant Msg MSN IMXP=Instant Msg XMPP IMYH=Instant Msg YAHOO PHHM=Home Phone PHHO=Home Office Phone PHMO=Mobile Phone PHOT=Other Phone USER=Other ZZZZ=Admin-Defined
2	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
3	HRCD_CNTCT_FMT	Character(1)	VARCHAR2(1) NOT NULL	This field contains the value format for Contact Type used in the Company Directory Setup. E=Email I=Instant Message T=Text Z=Text or Email Default Value: T
4	HRCD_CNTCT_LBL	Character(18)	VARCHAR2(18) NOT NULL	Label
5	HRCD_IM_PROTOCOL	Character(50)	VARCHAR2(50) NOT NULL	This field stores the Instant Message Protocol value for the Org Chart Node Setup. Prompt Table: PERSON_IM_SRVRS
6	HRCD_SELECT_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if a Contact Type item has been selected in the Company Directory Setup.
7	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N