HRCD_CNT_TP_LVW (SQL View)	Index Back
Co.Dir.-Addtl Cntct Types Lang Used to populate the drop down that the users see in the Company Directory.

HRCD_CNT_TP_LVW

(SQL View)

Co.Dir.-Addtl Cntct Types Lang

Used to populate the drop down that the users see in the Company Directory.

SELECT A.HRCD_CNTCT_TYPE %Concat '_' %Concat %NumToChar(A.SEQ_NO) , A.LANGUAGE_CD , A.HRCD_CNTCT_LBL FROM PS_HRCD_STCNT_LANG A , PS_HRCD_SETUP_CNTC B WHERE B.HRCD_SELECT_FLG = 'Y'

Related Language Record for HRCD_CNT_TYP_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRCD_CNTCT_TYPE_SQ Character(10) VARCHAR2(10) NOT NULL This field contains the Contact Type that will be displayed in the Company Directory to the end user via a derived record.

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

3 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRCD_CNTCT_TYPE_SQ	Character(10)	VARCHAR2(10) NOT NULL	This field contains the Contact Type that will be displayed in the Company Directory to the end user via a derived record.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description