HRCD_STCNT_LANG (SQL Table)	Index Back
Co.Dir.Setup-Addtl Cntct Types

HRCD_STCNT_LANG

(SQL Table)

Co.Dir.Setup-Addtl Cntct Types

Related Language Record for 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 HRCD_CNTCT_LBL Character(18) VARCHAR2(18) NOT NULL Label

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	HRCD_CNTCT_LBL	Character(18)	VARCHAR2(18) NOT NULL	Label